Database to Autocad automated changes

[Anonymous]

Hello,

Let me preface this by saying I don’t know if this is possible or this a question better suited for a dynamic blocks forum, but I’m currently working on a pretty intensive project that requires me to connect a database source to my dwg file. The goal of the project is to automate changes from the database and reflect them onto a text script or something of the sort on autocad.

For example: if my database reads 8 machines are being supplied by this distributor, the text would read “8” and they would have a green fill/hatch to mark that they are online, but if I changed the information on the database, which is excel based, to read 7 machines, it would change to “7” and the machine that no longer is being supplied changes it’s shape fill/hatch to yellow, meaning not currently in use. 

I know its a lot but I appreciate any help anyone can provide

[Alfred.NESWADBA]

Hi,

(partially) automatic changes of text could be done using a database link (look to command _DBCONNECT, e.g. >>>this video<<< showing connection between AutoCAD entities and database).

>> on the database, which is excel based

Don't kill me for that, but SCNR ... "Excel" is not a replacement for a database 😉

In general: if you want to develop such an application and you have the skills to control AutoCAD and to control database access you can get that done. OOTB changing a hatch color just because of a modification within the database is not possible.

- alfred -