Using the Data Extraction Wizard

The Data Extraction wizard lets you specify a set of entities or blocks and extract the attribute data. Additionally, you can extract property data from entities.

You can choose to display the result in a table on the drawing or in an external file.

Using the Data Extraction wizard you can do the following:

• Specify the set of drawings or folders
• Filter entities
• Organize the extracted data
• Add information from a Microsoft Excel file to the extracted data
• Specify an output format
• Format the output data in a table

The ExtractData command opens the Data Extraction wizard.

To create a data extraction table:

1. Do one of the following:
   • On the menu, click Insert > Data Extraction.
   • On the BIM Navigator palette, click Extract Data.
   • Type ExtractData.
2. Type ExtractData at the command prompt.
3. On the first page, do the following:
   • Click Create a new data extraction.
   • To use a template, select Use previous extraction as a template.
   • Click Next.
4. In the dialog box, type the name of the .det file and click Save.
5. On the Define data Source page, specify the drawings and folders from which to extract data and click Next.
6. On the Select Entities page, specify the entities from which to extract data and click Next.
7. On the Select Properties page, specify the properties to extract.
8. On the Refine Data page, change the column order if necessary and include columns from a Microsoft Excel (XLSX or CSV) file using the Link External Data dialog box.

   You can preview the result. Click Next.

9. On the Choose Output page, specify the output type.
10. On the Table Style page, specify the format of the data extraction table. Optionally, specify a title for the table. Click Next.
11. On the Finish page, click Finish.

    The table appears attached to the mouse cursor.

12. In the graphics area, specify a point to place the table.

Note: Use the ExportTable command to export tables in a comma separated format (CSV).

To edit an existing data extraction:

1. Do one of the following:
   • On the menu, click Insert > Data Extraction.
   • Type ExtractData.
2. Type ExtractData at the command prompt.
3. On the first page, click Edit an existing data extraction.
4. If there are new drawings in the specified folder, the New Drawings Found dialog box appears. Specify the drawings to include in the specified data extraction and click OK.

Access

Menu: Insert > Data Extraction

Command: ExtractData

Tool Palettes: Modify > Data Extraction