You can extract information from objects, such as block attributes and drawing properties, to create a schedule, a parts list, or a bill of materials.
For example, if you have a residential construction project and you need to create a door installation schedule to place in the drawing. Using the Data Extraction wizard, you can select only those objects that are doors (blocks in this case), and extract the attribute data. Because the Data Extraction wizard also extracts property information from objects, you have more flexibility.
After you select the properties of the doors, the extracted data is displayed in the wizard in columns. You can organize and refine the information in these columns, and format it by specifying a table style or using an existing table as a template.
When you’re satisfied with how the table looks, the extraction is complete when you insert the table into the drawing. If you need to share the extracted information with others on the project, you can output the same extracted data to an external file.
Information stored in an Excel spreadsheet can be linked and combined with the extracted drawing data (object property data). Continuing with the example above; you have some additional information about the doors in the your drawing in an Excel spreadsheet (supplier and cost). You select the columns for supplier and cost in the spreadsheet and combine them with the other data in the data extraction.
The columns in the Excel spreadsheet will be added to the columns on the Refine Data page in the Data Extraction wizard.
All the columns except for Cost were added to the extracted data columns. Excel columns are designated with a symbol in the column label.
The table inserted in the drawing contains columns from both the extracted data and from the Excel spreadsheet.
When a drawing from which property data was extracted has changed, you can be notified that the data extraction table is no longer current. For example, if some doors in the drawing were resized or removed, you can choose to be notified that the data extraction table needs to be updated. Notification is especially useful during critical times when it’s important to know if the data is not current in the table, such as when plotting or publishing.
Starting a Data Extraction
When you create a new data extraction, you are prompted to save all the specific details about the extraction to a data extraction (DXEX) file. The DXEX file stores drawing and folder selections, object and property selections, and formatting choices.
You can use a data extraction file as a template to perform the same type of extraction at any time. If you need to extract the same type of information repeatedly, using a DXEX file is time-saving and convenient.
You can also edit an existing data extraction to add or remove drawings, add or remove objects, or select different properties from which to extract data. Tables that reference the same DXEX file, even if those tables are in other drawings, will display the changes when those tables are updated.