- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Database to Autocad automated changes
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
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
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 -
Alfred NESWADBA
ISH-Solutions GmbH / Ingenieur Studio HOLLAUS
www.ish-solutions.at ... blog.ish-solutions.at ... LinkedIn ... CDay 2025
------------------------------------------------------------------------------------
(not an Autodesk consultant)