extracting data from autocad to excel

[fackie76]

Good morning to all, I tried to search in the forum similar topics but I couldn't find what I look for. I press that I am not a neophyte of autocad, but I have always been osticated the vba or the lisp, actually more for laziness than for other.... .

goal to achieve:
extract data from cad blocks that within them acquire some data from drawing entities.

example:
drawing one/tenth/hundred entity line/polyline/circle then I would later insert a block that asks me to select the date entity and then asks me to complete other data such as material, height, while the length recovers it from the entity. (such as the necessary data for a metric compute or the separation of armored irons. . . )

current solution
I first created a polylinea, then I created a series of attributes some of which recover info from the previously designed polylinea type length and layer and a whole set of other parameters that I then insert by hand, eventually I created the block.

workflow
to extract the data I in the current state I am forced to insert this group of 2 entities/lock elements and copy it so many times as are the elements to "measure" then manually I have to arm myself with patience and move and change the individual polylines copied on my entities.

problem
not being the only one who has to do this job, it could happen that some of my collaborators cancel the polylinea by mistake and redesign new but at that point the block would lose the reference, in the same way if one inserts ex-novo the block that is without reference.

I hope to have explained quite well
Andrea

 

[GP.]

It's a special need, if you don't have programming bases, I see it hard.
data can also be stored "directly" in the entity, without creating blocks, depends whether they can be hidden or must be viewed in the graphics area.
Then how do you extract them now?

 

[fackie76]

I have now made a block and then I do the classic data extraction by selecting only the blocks (which already contain the quantities recovered from the entities).

for visibility in graphical area we can also talk about it but enter data within the various entities how can it be done?

Thank you.
Andrea

 

[Tristan]

you can always use an external database for data storage. with dbconnect you can connect records taken from a database ms access to your graphic objects

 

[fackie76]

you can always use an external database for data storage. with dbconnect you can connect records taken from a database ms access to your graphic objects

What do you mean? I don't have to assign database data to my objects I have to get data, i.e.:

We admit that I have two lines on the design from 10 and 50 units, well I want to "assign" to one the characteristic/parameter/assignment "pippo", to the other "pluto".

then I would like to extract the data of the various lines in a csv file where I find
Feature______Length

____pluto_________10
____poplar_________50

 

[Tristan]

drawing one/tenth/hundred entity line/polyline/circle then I would later insert a block that asks me to select the date entity and then asks me to complete other data such as material, height, while the length recovers it from the entity. (such as the necessary data for a metric compute or the separation of armored irons. . . )

What do you mean? I don't have to assign database data to my objects I have to get data, i.e.:
We admit that I have two lines on the design from 10 and 50 units, well I want to "assign" to one the characteristic/parameter/assignment "pippo", to the other "pluto".

What do you think the external db is for?! How do you think you assign the "material" or "pluto" characteristics?

 

[GP.]

...but enter the data within the various entities how can it be done?

the simplest way is the use of dictionaries (http://www.afralisp.net/autolisp/tutorials/dictionaries-and-xrecords.php), but it serves programming, with naked autocad you can not.

Unfortunately I do not have the time to help you with something practical.

 

[fackie76]

What do you think the external db is for?! How do you think you assign the "material" or "pluto" characteristics?

Boh? ? What do you want me to answer?

then it seems to me to begin to understand that you delinete 2 roads:
- xdata proposed by gp that also provided me a link to start studying
- dbconnect proposed by tristan on which unfortunately from a first search I did not find usable links.

 

[fackie76]

http://www.corsi-cad.it/articoli/connettere-dati-ad-autocad-nuovo-tutorialFirst step.

Now I have to figure out how to extract features from entities to db cells

 

[fackie76]

small update.
using the database method I managed to connect the drawing objects with database records.
so I managed to do practically what you find in the drop guide or online tutorials.
now comes the problem.. .
We admit that in my database created the column length, what I would like is that once I create the link between the cad object (line) and the database record the cell length was compiled automatically. in practice the database should be able to retrieve information from the drawing but this I can't do it.. . .
help...