Create New Piping Part Classes using Bulkload - Intergraph Smart 3D - Reference Data - Hexagon PPM

Intergraph Smart 3D Piping Reference Data

English (United States)
Intergraph Smart 3D
Search by Category
Reference Data
Smart 3D Version

Creating new piping part classes requires editing and bulkloading two Excel workbooks: AllCodeLists.xls and your piping catalog workbook (such as Ten_Specs_CatalogData.xls or Piping Catalog.xls). The software reads the specified commodity type in the part sheet and automatically places it in the correct location in the catalog according to where the commodity type is defined in the PipingCommodityType sheet in the AllCodeLists.xls workbook.

In AllCodeLists.xls

  1. In the AllCodeLists.xls workbook, go to the PipingCommodityType sheet.

  2. Review the sheet to see if there is an existing commodity type for the part class that you want to create. For example, if you want to add a gate valve part class, you would look under Valves > Linear Valves to see if a gate valve commodity type exists.

  3. If the Commodity Type exists, note the Piping Commodity Type Short Description as you will need it for the part sheet. Continuing the gate valve example, you would note the GAT short description.

  4. If the Commodity Type does not exist, add it to the PipingCommodityType sheet under the appropriate Commodity Class and Commodity Subclass. You also need to add a unique Codelist number for the new Commodity Type. You must bulkload AllCodeLists.xls for your new commodity type to be available.

    As an alternative, you can add a new Commodity Type in the Catalog task by adding a row to the Piping Commodity Type select list, found at [Catalog Root]\Select Lists\Piping commodity Type.

In Your Piping Catalog Workbook

  1. Create a new sheet in the workbook for your new part class. The new sheet must have a unique sheet name across your entire catalog.

    SHARED Tip You may want to copy an existing sheet of a similar part to create your new part class sheet.

  2. In the Commodity Type column, enter the Piping Commodity Type Short Description or Codelist Number that you found on the PipingCommodityType sheet in the AllCodeLists.xls workbook or the new Piping Commodity Type Short Description created in step 4 of the previous procedure. To continue the example, you would enter GAT.

  3. At the very top of the part sheet, enter a unique name in the User Class Name and the Occ Class Name cells. The user class name is the name that will appear in the Catalog task.

  4. Define the unique commodity code and other part attributes as required.

  5. Bulkload the piping catalog.

See Also

Piping Parts