Export Bill of Material - CADWorx - Help

CADWorx Equipment

Language
English
Product
CADWorx
Subproduct
Equipment
Search by Category
Help
CADWorx Version
20.2
CADWorx Structure Version
4.2

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

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.