Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Anonymous
437 Vistas, 1 Respuesta

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

 

Etiquetas (2)
Alfred.NESWADBA
en respuesta a: Anonymous

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 :cara_guiñando_un_ojo:

 

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)