• Home
  • Training Books
  • Subscribe to Our Email Newsletter
  • About
    • Contributors
    • Feedback
    • Contact
    • Privacy policy
    • Cookie Policy

CADnotes

CAD Tutorials and Best Practices for professionals and students

  • Featured
  • AutoCAD
    • AutoLISP
  • Revit
    • Revit Architecture Basic
    • Revit MEP Basic Tutorial
  • Inventor
  • MicroStation
    • MicroStation Basic Tutorial
You are here: Home / AutoCAD / Create a Report Table with Data Extraction

Create a Report Table with Data Extraction

June 28, 2009 by Edwin Prakoso 7 Comments

In this Article...

  • 1. Begin
  • 2. Define Data Source
  • 3. Select Objects
  • 4. Select Properties
  • 5. Refine Data
  • 6. Choose Output
  • 7. Table Style
  • 8. Finish

1186105_building_plans_4 Have you use AutoCAD data extraction? You can extract any properties from any objects in your AutoCAD drawings with data extraction. I believe some of you have seen a nice demo from Autodesk about this. They use a data set to create door schedule from a drawing. It count the number of door blocks, and report it on a table. If you haven’t seen it, you can try creating schedule by yourself here.

Data extraction actually can extract any data, not only from blocks. Lines, points, rectangle… any data! You might want to have a hole table, benchmark coordinates, or estimate pipe length from your drawing. Sure, AutoCAD might not the perfect solution, but if that what you have, data extraction might help you.

In this example I will try to extract data from lines. I draw several lines as shown below. Of course, you might want to use real data, better than mine :)

lines

I created them in three layers. Imagine this layers define pipe size. If I draw pipe layout in my plan, I can generate a report how many pipe I will use.

layers

To understand more about this data extraction, I override color in some lines. Not by layer, but define it’s color.

You can activate data extraction on blocks and references TAB. On linking & extraction section.

data extraction

After you activate the tool, then a wizard will open. There are 8 steps you must follow before you can have your report. Trust me, these 8 steps are not scary at all :D

1. Begin

Here you must define, are you going to define a new data extraction or use previous extraction settings. Let’s just use create new data extraction now. Click next.

1- begin

Type a setting file name. For example: lines.dxe.

2. Define Data Source

Next step, you must define your data source. Are you going to generate reports from all objects in your drawing (includes reference, nested blocks) or just some objects you selected.

Let’s just use select objects in current drawing, click the pick button on the right side of this option. Select all your lines, then [enter].

Click next.

2 - data source

3. Select Objects

If you have different type of objects in your previous selection, you will see them here. You can filter what kind of objects you want to include (or exclude) in your report. In my drawing I only have lines, so that’s the only thing shown here.

After finish selecting your object, then click next.

3 - select objects

4. Select Properties

Next, you will see the list of your object properties. What you will see depends on what you choose on the previous step.

Line properties, grouped into 4 categories (column on the right). I only want to report general properties and geometry. I turn off the others.

See image below. I select length, start X & Y, end X & Y, delta X & Y, layer name, and object color. You can choose other than these example to suit your needs.

4 - select properties

After this one, the rest is easy.

5. Refine Data

You will see a preview of your report here. You can sort the table by clicking the header column, arrange the column by dragging the header and change some options. Preview if necessary.

5 - refine data

6. Choose Output

Where do you want to put your table? In the drawing or to excel file, or both?

6 - choose output

7. Table Style

Choose a table style you want to use. This step won’t appear if you don’t choose your output to drawing. Choose appropriate table style for your output.

7 - table style

8. Finish

Well… there’s nothing to do here but click the finish button.

8 - finish

Here is my report.

result

You might need to process your data further, you can do it easily in Excel or in your AutoCAD.

You may also want to see that you can report multiple coordinate from an AutoCAD block here. Easy isn’t it? So what kind of reports that you might want to create with data extraction? I would love to discuss it with you here.

About Edwin Prakoso

I work as a Sr. Consultant in PT Cipta Satria Informatika. I've been using AutoCAD since R14 and Revit since Revit Building 9. I occasionally write for AUGIWorld magazine and I am also active in Autodesk discussion forum. I'm a member of Autodesk Expert Elite, an appreciation for individuals who give contributions to the Autodesk community.
Connect with me on twitter or LinkedIn.

Filed Under: AutoCAD

0 0 votes
Article Rating
Subscribe
Login
Notify of
guest

guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

7 Comments
Inline Feedbacks
View all comments
Pepe
Pepe
6 years ago

Hi Edwin, thank you for your Post. I want to extract the geometry data and color data, and then transfer to file/Programm which robot can directly read and do the automatic spray painting work. Do you have any idea?

0
Reply
sasan
sasan
6 years ago

hi how can i have a report from all my blocks + their pics

0
Reply
Brian Thorn
Brian Thorn
11 years ago

Do any of you know why the “combine like rows” does not work when I use the (2012 Autocad) data extraction wizard? I Everything seems to work fine but that option. It is grey and is not selectable. I use a block with 2 attributes-a name and a quantity. So on my final report I want all the like names to be combined into one quantity. Secondly, my tree names are always 2 characters and my shrub names are always 3 characters-Is there a way to separate all the 2 character names/quantities from the 3 character names/quantities in my final report? We used to have a lisp routine to do this but it has been lost with a change of computer hardware. If don’t get it working I guess I will get out my highlighter and prints and start counting. Hehe.
Any help is greatly appreciated,B.

0
Reply
Chad Sparks
Chad Sparks
15 years ago

I've used this for years now (since 2008) and only recently, just out of the blue, it started with the "Deleteme" issue. I have no idea what caused it. But it's strange to use this feature for so long and just like that, it does it.

One workaround I've read about, and it does work for me, is to save the file to my local hard drive instead of the network drive of the project folder. For whatever reason, this works. I just have the small inconvenience of having to move the file from my desktop to the network folder after-wards.

0
Reply
Todd McElrath
Todd McElrath
15 years ago

I use the DATAEXTRACTION feature just like you and AutoCAD's help tell me to. On Step 5 I do a preview. Everything looks good. At the end, whether I choose insert a table or output data to an Excel file, I get nothing. Well, it creates an Excel file, but only one cell, A1, has anything in it, "DeleteMe". I've used it before and it worked. What happened? How do I fix it?

0
Reply
Edwin Prakoso
Edwin Prakoso
Author
Reply to  Todd McElrath
15 years ago

I found similar threads in many AutoCAD forums, and it looks like it's not solved yet. The workaround is to save it as csv, not xls. You can save it to xls with Excel, then insert it to AutoCAD using datalinks. I tried to search in Autodesk support page and can't find this issue.
I'm interested because it works before. Have you tried to install AutoCAD updates and reinstall it? Is it a machine specific or file specific problem?

0
Reply
Todd McElrath
Todd McElrath
Reply to  Edwin Prakoso
15 years ago

I am using AutoCAD 2009 with SP1 & SP2. I have not tried searched for more recent service packs or tried to reinstall AutoCAD because we have recently recived 2010 and it will be getting installed within the next few days. The problem occurs on all files, and only on my computer. Other users in my department do not have the problem. My 2009 will be transfered to another user, so please let me know if a solution is found in case it occurs again.

I had not tried saving it as a CSV file. I was not familiar with that file type, so I ignored it. For now, it does work, though. If I find out anything more about it, I'll let you know. Thank you very much for your help!

0
Reply
wpdiscuz   wpDiscuz

Featured

What’s new in AutoCAD: drawing and drafting tools

Another AutoCAD new features roundup. In this post we will see what are drawing and drafting features have been added.

Recent Articles

  • Autodesk Construction Cloud Activity Log
  • Exporting AutoCAD Plant 3D Model to Navisworks
  • Autodesk Data Connector for Power BI is Now Available

Advertisement

New on CADnotes

  • Autodesk Construction Cloud Activity Log
  • Exporting AutoCAD Plant 3D Model to Navisworks
  • Autodesk Data Connector for Power BI is Now Available
  • Autodesk Forma Design Contest
  • Revit 2025: Toposolid Enhancements

Meet the Authors

avatar for
avatar for
avatar for
avatar for
avatar for
avatar for

Get Connected

CADnotes on FacebookCADnotes on InstagramCADnotes on TwitterCADnotes on YouTube

© 2009 – 2025 CADnotes · Feedback · Privacy Policy · Become an affiliate

wpDiscuz