Create CSV File

Select “Create CSV files from drawing data” from the Operation Tab and click the “Next” button.

Click the “Add File” button.

Select ATTEXT.DWG and click the “Open” button. Click the “Cancel” button.

The AutoCAD drawing now appears in the list of selected drawings. With the registered version it is possible to add hundreds, even thousands of drawing files to this list. Imagine how time consuming and tedious it would be to manually change a company name (in block attribute values or text values) for thousands of drawings. With Ultra AutoCAD Tool you can perform this task in mere seconds! Hopefully you are starting to realize some of the benefits of this invaluable tool.

Click the Next button to move to the next screen.

Now we will select the fields to include in the CSV file. For this demonstration we will select all the available fields by clicking the “>>” button.

All fields should now exist in the right list box. For this demonstration we will create the CSV file in the same directory as the drawing, extract block attribute data, and include field headings in the CSV file. To specify a record filter type layout = ‘model’ and name = ‘d00005d1’ and layername = ‘xt’ in the Record filter text box. Note that only specific fields can be used in the filter. Click the “?” button to see record filter help and a list of all available fields. To build the CSV file click the “Process” button. If all goes well you will see a message “1 items processed” in the status message at the bottom of the screen. If an error had occurred you would see a message box containing error information (provided you have the error messages turned on via the System menu).

Open Window’s Explorer and look in folder C:\Program Files\Ultra AutoCAD Tool to verify if the file was created.

Open the file in any text editor such as Window’s Notepad. Note that only records where the layout name is equal to ‘model’ and layer name is equal to ‘xt’ and block name is equal to ‘d0005d1’ appear in the file (as specified in the record filter).

If Excel is installed on your machine double-clicking on the CSV file should open it in an Excel workbook.