Generate a Bolt Report

This task shows you how to generate a bolt BOM (bill of materials) report . The bolt report provides the name, code material, length and diameter for all bolts in your product.

The macro generates a report based on rules tables in Specification in CS150R-BoltingRules.txt and in  Standards in ASTL-EndDimension.txt.

The BoltingRules table has the following column headings:

  • Min_Nominal Size
  • Max_Nominal Size
  • Part Name
  • Part Code
  • Material Code

The EndDimension table has the following column headings:

  • EndStyle
  • Rating
  • NominalSize
  • EndDiameter
  • EndThickness
  • HexBoltCount
  • HexBoltLength
  • HexBoltDiameter
  • StudBoltCount
  • StudBoltLength
  • StudBoltDiameter

When complete, the report displays the values for all attributes defined in the column headings of the two text files except for nominal size.

See Rules Overview and Modifying Design Rules to find out more. The design tables have to have the correct entries for accurate reports.

The bolt report function does the following:

  • Looks for gaskets with a minimum of two connectors that are connected to a flange or valve (one of the connections must be to a flange).
  • Attributes like EndStyle and NominalSize from the flange are used to obtain the bolt count data, using the End Dimensions rules table.
  • If one of the connections is to a valve that has the parameter BoltThrough with a value of Yes, then its bolt count is half of the count found in the table.

To generate a report for the bolts in your document, first make sure the Product is active (highlighted blue).
1. Go to Tools - Macro - Macros. The Macros dialog box displays. If the file CATAttrPipingBOMReport.CATScript does not display initially, click Select and navigate to the directory intel_a\code\command. Select the file named above and click Open. The file displays in the Macro dialog box.

2. Click the Run button. The Report Generation dialog box opens. Enter the file name (and the path) where you want your report created.

3. The Report Generation Complete advisory appears when your report generation is complete. The report is created as an html file if you used the .html file extension. You can also create files as .csv and .txt files by using those file extensions.
4. Now you can navigate to where your report is stored and open the file to view the report.