Data Extraction with AutoCAD

I taught an Advanced AutoCAD class recently and was reminded of how much data can be mined from AutoCAD drawings. 

In the example below, I have a simple floor plan with several blocks in place.  I can use AutoCAD’s data extraction tools to do count of all the light fixture blocks that I have in the drawing.  This can be accomplished with no additional programming or customization.

Start

On the insert tab, there is a panel called “Linking and Extraction”.  One of the tools available on this panel is Extract data.  One this tool is selected the data extraction dialog box will appear.

Extractionpanel

In this case, this is the first time I have extracted data from this drawing, so I will choose “Create a new data extraction”.  The next screen asks me to save the data extraction settings that I am about to create.  This is saved in a file called a .dxe file.

Dataextraction1

Next, I can choose which drawings to extract data from. In this instance, I will only use the current drawing.  Additional files could be added on a per file basis, or entire folders could be added.  The file selection is concluded by choosing the “Next” button.

Dataextraction2

Now the dialogue displays all the drawing types that information could be extracted from.  For what I am doing, I will uncheck the “Display all object types” check box.  Now I only see the blocks in the drawing.  I will choose the recessed light fixture block name and click on the “Next” button.

Dataextraction3

I am now presented with a series of data that I can extract from the blocks.  I will change the category filter to only show Dynamic Block information, and select the height and width properties.

After hitting next, I now see a preview of the data that is being extracted.  I have chosen to include the block name column and the count column. 

Dataextraction4

On the next screen, I can choose to put this information on the drawing in the form of a table, or extract it out to an external file.  In this case I will put it directly on the drawing.

Dataextraction5

On the next screen, I can choose a table style set up a title for the table.  I will use the Standard table style and end “Light Fixtures” for the title. Dataextraction6

Having completed the dialog box, the table is now ready to be placed on the drawing.

Final

If any part of your workday includes counting up symbols on drawings, the data extraction tool can save you hours of busy work.

About the Author

Caleb Funk

Manufacturing Team Manager<br><br>Caleb began his career as a professional CAD instructor after a short stint as a production draftsman, and has 10+ yrs CAD experience starting with AutoCAD R12. He enjoys sharing his knowledge of drafting and solid modeling best practices, and is well known for his versatility and extensive knowledge of CAD software. He is a Solid Modeling Expert; MicroStation Certified Instructor, and has Authored MicroStation courseware for the Florida Department of Transportation. Caleb is PSE and ATC Certified in AutoCAD, AutoCAD Mechanical, AutoCAD Electrical, and Autodesk Inventor.

Follow on Linkedin More Content by Caleb Funk
Previous Article
Autodesk:  Have Users assigned to a Team in the Autodesk Account. However, the Users do not see the Software in their Account and cannot use
Autodesk: Have Users assigned to a Team in the Autodesk Account. However, the Users do not see the Software in their Account and cannot use

If you have Users assigned to a Team in the Autodesk Account but Users do not see the Software in their Acc...

Next Article
AutoCAD Electrical:  Microsoft Database Errors during Launch, Install , of Deployment
AutoCAD Electrical: Microsoft Database Errors during Launch, Install , of Deployment

Traditionally this is a result of compatibility issue with the Microsoft Access Database.

Need tech support? Let us help!

Learn More