Export Bill of Material - CADWorx - Help

CADWorx Plant

Language
English
Product
CADWorx
Subproduct
Plant
Search by Category
Help
Isogen Version
15
Smart Isometrics Version
8
Spoolgen Version
10
CADWorx Version
22

Mouse Icon CADWorx Plant tab: Bill of Material panel > Export BOM Export BOM - Structure

Mouse Icon Plant menu: Bill of Material > Export

Keyboard Command line: BOMEXPORT

Exports the Bill of Material schedule to an external file format that you specify. The schedule for the Bill of Material is defined using BOM Setup. CADWorx can export the Bill of Material schedules to:

  • Access file (*.mdb)

  • Excel file (*.xls)

  • Text file (*.txt)

  • HTML file (*.htm)

When exporting data to Microsoft Excel, numeric data is exported as text and is preceded by a single quote. This single quote prevents you from totaling the column in Excel. To correct this in Excel, select the column and then select Data > Text To Columns. Step through the wizard selecting the Delimited option and Tab as the Delimiter check box. This changes the data from text to numbers. In Imperial/Inch settings, length is exported in feet and inches, which cannot be totaled in Excel. To export length in decimal format, change the current CAD platform Dimension Style settings Primary Units format to decimal.

An additional command called BOMEXTERNAL is available to export a project database to a file based on the columns chosen in the BOMSETUP.

  1. Click Export BOM Export BOM - Structure in the Bill of Material panel.

    SHARED Tip You can also type BOMEXPORT in the command line.

  2. Specify if you want a Cut, Total, or Single BOM.

  3. Select the objects to include in the BOM. Right-click or press ENTER when you are finished.

  4. In the Save as type box, select the file format that you want.

  5. Type the file name, and specify the folder location.

  6. Click Save.