Cadgen Data & Attribute Import Export Utility

Cadgen Data & Attribute Import Export Utility

Win32 and 64, English

Cadgen Software LLC
A convenient utility to import/export attributes on a drawing to Excel or CSV format and export data created with Cadgen Quick Label, including unit length report between blocks added to group.

General Usage Instructions

The Cadgen Data & Attribute Import Export Utility can be used in the following ways-

Attribute Editing

  • Any drawing with block references that contain attributes can be imported and exported to .csv and .xlsx format.
  • All attributes from model space and all layouts can be exported from the active drawing, or by using the appropriate command to export by selection or block name.
  • The resulting file can be edited in a flat file format and then re-imported to update the attribute values in the drawing.
  • An example of usage might be to keep title block information on all layouts up to date. Export title block attributes by using a command to select the title block definition by block. The resulting export would include all instances of the block in a flat file format, with the layout name and all attribute tags as columns. The attribute values can be easily edited and then re-imported into the drawing after closing and saving the edited file. As layouts and revisions are created and updated, repeat as necessary. 

 

Exporting data from the Cadgen Quick Label addin, freely available in the Autodesk® App Store.

  • Data exported includes all properties added to block references, associated group and sequence labels, and orthogonal and direct unit lengths between blocks sequentially associated in a group.
  • An example of usage might be to use the Cadgen Quick Label addin to indicate the order of electrical lights on a circuit. Use the 'cgexquicklabeltoexcel' command to export the stored data to an .xlsx file. Use the data to create accurate schedules, calculations and reports with the exported group and sequence labels, length between block references, and custom properties that are available in the raw data export. Repeat the process to get the latest data exported from a drawing edited with the Quick Label addin to quickly and easily apply to your own report creation process. 

 

Data Fields available in the exported data files

For attribute import/export functions, the following read-only columns are always included- 

Layout Name
Entity Handle
Block Name
Position X
Position Y
Position Z

The columns above are used to re-import the data and apply attribute values to the correct block. The values should not be modified or deleted.

Additional columns will be added for each attribute tag name in the selected export blocks, and the values of each attribute can be edited and re-imported. 

 

For Cadgen Quick Label Data export functions, the following read-only columns are always included-

Entity Handle
Group Label
Block Name
Position X
Position Y
Position Z
Length From Previous (Direct Units)
Length From Previous (Ortho Units)

 

When exporting to .xlsx files, a worksheet is added for each group. Blocks added to multiple groups will appear on more than one worksheet.

Additional columns will be added for each visible or hidden custom property added to the block references that appear in a group.

This data can be used for custom report or calculation in your own template, and modifications can be made with the free Cadgen Quick Label addin.

Screenshots

Commands

Ribbon/Toolbar Icon Command Command Description

cgexquicklabeltocsv_bysel

Exports all Cadgen Quick Label data for the selected block references in the current drawing to a .csv file.

cgexquicklabeltoexcel_byblock

Exports all Cadgen Quick Label data for the selected block name in the current drawing to an .xlsx file.

cgexquicklabeltocsv_byblock

Exports all Cadgen Quick Label data for the selected block name in the current drawing to a .csv file.

cgexattdatatocsv

Exports all block reference attribute data in the current drawing across all layouts to a .csv file.

cgexattdatatocsv_byblock

Exports all attribute data for the selected block name across all layouts in the current drawing to a .csv file. This is a useful method for updating title block attributes on all layouts.

cgexquicklabeltocsv

Exports all Cadgen Quick Label data in the current drawing to a .csv file. The Cadgen Quick Label addin is freely available in the Autodesk App Store.

cgexattdatatoexcel

Exports all block reference attribute data in the current drawing across all layouts to an .xlsx file.

cgexquicklabeltoexcel

Exports all Cadgen Quick Label data in the current drawing to an .xlsx file. The Cadgen Quick Label addin is freely available in the Autodesk App Store.

cgimportattributedata

Imports modified attribute data from an exported .xlsx file or .csv file.

cgexattdatatoexcel_byblock

Exports all attribute data for the selected block name across all layouts in the current drawing to an .xlsx file. This is a useful method for updating title block attributes on all layouts.

cgexquicklabeltoexcel_bysel

Exports all Cadgen Quick Label data for the selected block references in the current drawing to an .xlsx file.

cgexattdatatocsv_bysel

Exports all attribute data for the selected block references in the current drawing to a .csv file.

cgexattdatatoexcel_bysel

Exports all attribute data for the selected block references in the current drawing to an .xlsx file.

cglicense

Opens the license activation dialog.

Installation/Uninstallation

Install using the downloaded application installer. Uninstall or repair the installation using Add/Remove Programs in the Windows Control Panel.

Additional Information

The installer includes the prerequisites of the .Net Framework 4.5.1 and SQLite 3.0

Known Issues

None

Contact

Company Name: Cadgen Software LLC
Support Contact: support@cadgen.com

Author/Company Information

Cadgen Software LLC

Support Information

Please email support requests to support@cadgen.com.

Version History

Version Number Version Description

1.16.10

Autodesk® AutoCAD® 2017 product compatibility added

1.16.3

Installer prerequisite updates

1.16.2

  • Added context help to ribbon commands.
  • Updated license client.

1.16.1

Initial release

Go top