[AutoCAD 2007 & Higher Versions]
[Commands:ATTEXT, EATTEXT, DATAEXTRACTION]
Once we place attributes in commands, they become intelligent. They can carry a lot of information on them. If you're using blocks correctly and regularly, the attribute objects you place can help you a lot in quantity surveying. This is why AutoCAD has a data transfer command (DATAEXTRACTION) which can be accessed in the "Insert" tab of the ribbon menu. Although this command can do a lot more than just extracting block data, this article will focus on this feature of the command. We will be talking about this feature while we're preparing this comprehensive series about blocks.
The command extracts drawing properties, object properties and block attributes into data tables, external files or an
EXCEL file (as a link). It is really useful for users who use blocks a lot. The command can be accessed by entering
DATAEXTRACTION or
EATTEXT from the command line or from the ribbon menu (Figure.1). The
EATTEXT command actually does not work any more, it redirects you to the
DATAEXTRACTION command.
A wizard takes us through eight steps. Let's explain these step by step. We will be working with block attributes in our example and hence we'll be using appropriate settings.
Step 1: Creating a new DXE file...

Figure.2
This is where we decide whether we'll be working on a new file or an existing file.
DXE files store the data and settings used during the execution of this command. The data table we will be using will come in the next steps and have nothing to do with the
DXE file. We will be creating a new file in this example. If there is a file that you have been using and you wish to use similar settings, use the old file by marking 'Use previous extraction as template (.dxe or .blk)'. Do not forget that the file you select will be used as a template. Keep this in mind. You wil be asked to name the new
DXE file before we move on to Step 2. We have emphasized the importance of keeping these files organized in a location that you know, in previous articles.
Step 2: Specify the data source...

Figure.3
We can use a drawing, mutliple drawings or selected objects from within a drawing as the data source. If you wish to transfer data from multiple drawings, you can use the '
Add Folder...', '
Add Drawings...' and '
Remove' buttons near the '
Drawings/Sheet set' option. There is a little button just beside the option we used in our example (Select objects in the current drawing). We then switch over to the drawing to select objects. The first thing that catches our attention is the fact that non block objects can also be selected. We'll come back to this later. We have some settings to pay attention to first, so let's hit the '
Settings...' button.

Figure.4
This screen is where detail level is specified. This command has other areas of use also, but for now we're interested only in blocks. Some of you may find these settings useful. We may sometimes need
POLYLINEs and their geometric data.
Step 3: Which objects are we interested in?

Figure.5
As we are working only on blocks, we unmark ‘
Display all object types’ and then mark the ‘
Display blocks with attributes only’ option. With the '
Display blocks with attributes only' option, blocks with attributes are filtered. The ‘
Display objects currently in use only’ option removes the blocks, text styles etc. that have been defined, but not used in the drawing. This option comes in really handy when working on one or more drawings. In this example however, this option is unnecessary as we did the selections manually.
Step 4: Selecting which data to extract...

Figure.6
At this step, the category list on the right side is really important. Block attributes are important, they're even our starting point. This is why we should have 'Attribute' marked. When '
Drawing' is marked, information about the drawing is transferred too. You may configure the rest to best suit your needs.
Step 5: Fine tuning the data...

Figure.7
Now we have our data list ready. A list of the blocks and their number of appearances is given. Similar rows can be grouped using the '
Combine identical rows' option. The similarity has to be in attributes and not just names. That is, both the block names and attributes have to match. Although listing can be done easily in the transfer file, I hit the '
Sort Column Options...' for a more comprehensive job. I list by the '
TAG-TITLE', as seen in Figure.8.

Figure.8
You can link external EXCEL tables using the ‘
Link External Data...’ button. This process is a little complicated and we'll leave it aside for another article.
Step 6: Deciding on outputs...

Figure.9
There are two types of outputs with this command. You can add it as a
TABLE object into the drawing or store it as a file. Any of
XLS,
CSV,
MDB and
TXT file types can be used. I suppose only people with no access to
EXCEL or
ACCESS programs would use
CSV or
TXT files when there are the other options. In this example, we'll be using
EXCEL files. Because we choose this option, the command ends here. I'll like to discuss further how tables can be placed in drawings, using the other option.
Step 7: Table Style...

Figure.10
Hitting the '
Finish...' button once you're done will prepare your
EXCEL file if you selected the option; and prompt you to place the table as you wish.
The prepared EXCEL file is as seen in Figure.11.

Figure.11
Table view of the same list will look similar to Figure.12.

Figure.12
We have already talked about software that transfers block counts to EXCEL before. Follow the links below to download and try these free programs.
Have a nice day.