This topic provides information about the worksheets that are required for loading into a new Catalog database.
If you are translating reference data from PDS, this information will be helpful as you edit the output from the translator.
prefix_Catalog.xls
Worksheet Name |
Comments |
---|---|
CustomClassInterfaceList CustomInterfaces CatalogRoot GUIDs Revision History (optional) Part Classes - dependent on the input files for the translation |
Worksheets listed in bold are required. |
prefix_Specification.xls
Worksheet Name |
Comments |
---|---|
DefaultProjectOptions |
These worksheets are project-related worksheets in the specification reference data. Bulleted worksheets are present in the translated output file. NPDEquivalence and MaterialsData worksheets are present in the output; however, they may be empty in the translated workbook. Worksheets in bold are the minimum required. Worksheets in italics are required only if the corresponding commodities exist in the piping commodity filter. For example, if stud bolts are present, then the PreferredStudBoltLength worksheet is required. |
prefix_Specification.xls
Worksheet Name |
Comments |
---|---|
CorrosionAllowance |
These worksheets are specification- related worksheets in the specification reference data. The bulleted worksheets are present in the translated output file. Worksheets in this row are required for each piping material class. Worksheets in bold are the minimum required. |
AllCodeLists.xls
Worksheet Name |
Comments |
All worksheets |
The translator does not convert codelists. Make sure that the codelists meet the project requirements. |
AllCommon.xls
Worksheet Name |
Comments |
Material OutfittingCrossSections |
The required worksheets are shown in bold. The AllCommon.xls workbook also contains worksheets with delivered generic data for piping. |
BulkLoadIsoKeys.xls
Worksheet Name |
Comments |
All worksheets |
This workbook is required for isometric drawing extraction. |
Equipment.xls
Worksheet Name |
Comments |
All worksheets |
This workbook is required for equipment placement. |
GenericNamingRules.xls
Worksheet Name |
Comments |
All worksheets |
Required. |
InsulationData.xls
Worksheet Name |
Comments |
All worksheets |
This workbook is required if you want to have insulation specifications. |
StructCrossSections-AISC-LRFD-3.0.xls
Worksheet Name |
Comments |
All worksheets |
This workbook is required for placement of US steel sections. |