Extract object custom properties data

Extract object custom properties data

Beka_Tchigladze
Advisor Advisor
4,118 Views
7 Replies
Message 1 of 8

Extract object custom properties data

Beka_Tchigladze
Advisor
Advisor

hello 

so I have several objects in my AutoCAD and I have defined properties for each of them and now I want to extract this data with data extraction tool but this property category does not show up how to extract this property data from AutoCAD?here are some screenshots below

2019-09-25_11-50-42.jpg2019-09-25_11-51-42.jpg2019-09-25_11-53-08.jpg2019-09-25_11-55-00.jpg


Beka Tchigladze

Infrastructure Design Engineer | BIM Automation Developer

Autodesk Developer Network (ADN) Member

Autodesk Certified Professional: Civil 3D & AutoCad

LinkedIn | Autodesk App Store
0 Likes
Accepted solutions (1)
4,119 Views
7 Replies
Replies (7)
Message 2 of 8

Koesti
Autodesk Support
Autodesk Support
Accepted solution

Hi @Beka_Tchigladze,

from the screenshots, we speak about Map 3D object data not only properties.

There are several processes to export this data together with the graphical data.

One fast way is using MAPEXPORT command and choose one of the general formats like SDF, SHP.

Attach the exported format via FDO to the .dwg and open table view.

Other alternative is to add the .dwt to an new .dwt and run query to CSV to export the object data, e.g. to use them in excel.

 

1. Run Mapexport command

Select format SDF

Export and add object data

object_data.png

In Task Pane 

Connect to exported SDF file

Open table view (select and copy to Excel or export to CSV)

 

table_view.png

 

2. Alternative run Map query

Close the .dwg with object data

Open new .dwg and drag&drop original .dwt to TaskPane - Tab Map Explorer

Query to report as CSV file

Video

Regards

 



Brigitte Koesterke

Technical Support Senior Specialist
Message 3 of 8

Beka_Tchigladze
Advisor
Advisor

@Koesti 

So apart from these above, I solve problem. I use MAPEXPORT command and export as mif/mid with object data I needed after I import .mid which consist of information about "OD" as a text file into the excel.

thank you 🙂


Beka Tchigladze

Infrastructure Design Engineer | BIM Automation Developer

Autodesk Developer Network (ADN) Member

Autodesk Certified Professional: Civil 3D & AutoCad

LinkedIn | Autodesk App Store
Message 4 of 8

АлексЮстасу
Advisor
Advisor

You can try the ODEDIT capabilities for loading data into Object Data - ODEDIT_SETXYZ, ODEDIT_SETPROP, ODEDIT_SETTEXT, ODEDIT_LOAD_ATTRS, ODEDIT_SETID, etc.

And to upload them to csv - ODEDIT_EXPL, Explication.

 


-- Alexander, private person, pacifist, english only with translator 🙂 --

Object-modeling _ odclass-odedit.com _ Help

0 Likes
Message 5 of 8

Beka_Tchigladze
Advisor
Advisor

unfortunately, I do not like to use additional tools.

thank you for reply


Beka Tchigladze

Infrastructure Design Engineer | BIM Automation Developer

Autodesk Developer Network (ADN) Member

Autodesk Certified Professional: Civil 3D & AutoCad

LinkedIn | Autodesk App Store
0 Likes
Message 6 of 8

АлексЮстасу
Advisor
Advisor

And I agree with you! 😀
I believe that such features should be in Map 3D itself.
And I agree that the MAPEXPORT-MAPIMPORT of mif/mid helps to use text-type data well.

 


-- Alexander, private person, pacifist, english only with translator 🙂 --

Object-modeling _ odclass-odedit.com _ Help

0 Likes
Message 7 of 8

Beka_Tchigladze
Advisor
Advisor

yes, sometimes you should really dig into cores of software if you need to get what you want. 


Beka Tchigladze

Infrastructure Design Engineer | BIM Automation Developer

Autodesk Developer Network (ADN) Member

Autodesk Certified Professional: Civil 3D & AutoCad

LinkedIn | Autodesk App Store
0 Likes
Message 8 of 8

АлексЮстасу
Advisor
Advisor

You can also upload to txt by query:

Report.png


-- Alexander, private person, pacifist, english only with translator 🙂 --

Object-modeling _ odclass-odedit.com _ Help

0 Likes