Anuncios

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

Database to Autocad automated changes

Anonymous

Database to Autocad automated changes

Anonymous
No aplicable

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

 

0 Me gusta
Responder
437 Vistas
1 Respuesta
Respuesta (1)

Alfred.NESWADBA
Consultant
Consultant

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)