topic Re: field attributes and data extraction in AutoCAD Forum

field attributes and data extraction

Anonymous — Tue, 10 Mar 2015 15:05:16 GMT

Hi there,

Need some help! I want to combine field attributes with data extraction.

I currently have several fields connected to polylines that automatically give me areas.

Each polyline also has a MText with its name.

So I have 2 Mtext: One with "room number 4 " and another with area field (updated automatically).

What I want to do is to extract everything to an excel spreadsheet that could be updated automatically as well.

Does anyone know how to do this?

TY!

Re: field attributes and data extraction

leothebuilder — Tue, 10 Mar 2015 15:20:53 GMT

You can use an autocad table and in a cell(s) insert a field that reflects the area of the polyline(s).

You could do the same for the room name.

If needed you can export the autocad table to excel

Re: field attributes and data extraction

BrianBenton — Tue, 10 Mar 2015 16:44:15 GMT

Use the command DATAEXTRACTION. It will retrieve all data from any object in your file. Select the objects and the type of data you want to get. Then it will place it in a table in the AutoCAD file of in a CSV file. You can link the CSV file into AutoCAD as a table.

Here is the Autodesk site about it.

Re: field attributes and data extraction

Anonymous — Tue, 10 Mar 2015 18:35:57 GMT

Thank you for your help!

I didnt knew that it was possible to use field inside tables.. 🙂

Re: field attributes and data extraction

leothebuilder — Tue, 10 Mar 2015 18:53:16 GMT

Yes, you can insert fields inside autocad table cells.

You can insert formulas inside table cells as well.

Autocad tables can be pretty powerfull, not like excel mind you.