Extracting extended data from entities

[Anonymous]

Hi everyone. 

I trying to extract some data and I can't figure out how.

I've got objects (mostly hatch atm, but I might want to extend this to solids as well) with a Work Breakdown Structure (WBS) code attached to them through a Property Set Definition. I've set up the code for the object in the extended data Property window. 

I'm now trying to extract the WBS code from the hatches together with the area size. 

The problem I run in to that through a normal data extraction I can't access the extended data.

Is there a work around?

[Anonymous]

I don't know much about this, so forgive me if I am way off. But, can you do it with a Map3D query?

[Mike.M.Carlson · Accepted solution]

Hello,

I would second the idea @Anonymous has using Map3D query.  This short video shows how to set it up. 

At the end he drags the exported shape file into the dwg and shows how to view the imported Map layer Data Table to see all the extended attributes.  You can then copy and paste from that into excel. 

However, another option to consider/try is to not export the .shp, but keep the dwg with the extended attributes as is and use "ADEDRAWING" command to connect this dwg to a separate new dwg and do a Query (ADEQUERY).  At this stage, in lieu of querying the objects from the attached dwg that has the extended data into the new drawing using the 'Draw" option, click "Report" instead and it will show the results in a report format that you can manipulate.

I hope this helps.

[Anonymous]

This is indeed a different solution then I thought off, but it will work. Thanks!