Minimum Reference Data - Intergraph Smart 3D - Installation

Intergraph Smart 3D Installation

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Installation & Upgrade
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

When you create a new catalog, you must bulk load a minimum amount of reference data in order for the software to function properly. You must bulk load the workbooks for the disciplines that you want to work with and any other workbooks with related data such as codelists, naming rules, and so forth.

For example, if you want to create a catalog for piping and equipment only, bulk load AllCodelists.xls, AllCommon.xls, Equipment.xls, EquipmentComponent.xls, GenericNamingRules.xls, InsulationData.xls, Shapes.xls (for designed equipment), Ten_Specs_SpecificationData.xls, and Ten_Specs_CatalogData.xls.

Workbooks that are not delivered with the software are available on the customer support web site.

  • When using the Bulkload utility to create a new catalog, you must use the apprepos.dat (for MSSQL) or apprepos.dmp (for Oracle) template file to create the Catalog Schema. This file is located in [Product Folder]\DatabaseTemplates folder on the computer where the reference data was installed.

  • The Select lists (Codelists) delivered with the software (AllCodeLists.xls) might be different than the codelists provided on the customer support web site. The most recent codelists available on the customer support web site should be used for the most current functionality.

Discipline

Required Workbooks in Catalog

Cable

  • AllCodelists.xls

  • Cabling.xls

  • GenericNamingRules.xls

Cable Tray

  • AllCodelists.xls

  • AllCommon.xls

  • CableTray.xls

  • GenericNamingRules.xls

Cableway

  • AllCodelists.xls

  • AllCommon.xls

  • CableWay.xls

  • GenericNamingRules.xls

Conduit

  • AllCodelists.xls

  • Conduit.xls

  • GenericNamingRules.xls

  • MatingPort Sheet

  • GenericDataPipingFemale Sheet

  • PlainPipingGenericData Sheet

Drawings and Reports

  • AllCodelists.xls

  • Drawings.xls for volume drawings

  • BulkLoadIsoKeys.xls for isometric drawings or spooling

  • Reports.xls for report templates

Electrical

  • AllCodeLists.xls

  • Ductbank.xls

Equipment and Furnishings

  • AllCodelists.xls

  • AllCommon.xls

  • Equipment.xls

  • EquipmentComponent.xls

  • GenericNamingRules.xls

  • InsulationData.xls

  • Shapes.xls for designed equipment

  • Standard Nozzle Data.xls for designed equipment

  • Ten_Specs_CatalogData.xls

Grids

  • AllCodelists.xls

  • GridsCodelist.xls

  • GenericNamingRules.xls

Hangers and Supports

  • AllCodelists.xls

  • HS_System_Codelists.xls

  • AllCommon.xls

  • GenericNamingRules.xls

  • HS_System.xls

Apart from these workbooks, you must load the parts and assembly workbooks that you intend to use.

HVAC

  • AllCodelists.xls

  • AllCommon.xls

  • GenericNamingRules.xls

  • HVAC.xls

  • InsulationData.xls

  • Carnes HVAC Catalog.xls for Carnes HVAC parts

  • Lindab HVAC Catalog.xls for Lindab HVAC parts

  • Spiral HVAC Catalog.xls for Spiral HVAC parts

Interference Checking

  • AllCodelists.xls

  • GenericNamingRules.xls

  • IFCRule.xls

Piping

  • AllCodelists.xls

  • AllCommon.xls

  • GenericNamingRules.xls

  • InsulationData.xls

  • Ten_Specs_SpecificationData.xls

  • Ten_Specs_CatalogData.xls

  • Piping instruments require Instrument Data.xls and On-the-fly Instruments.xls

  • Piping specialties require Piping Specialty Data.xls and On-the-fly Piping Specialties.xls

  • A larger set of piping specifications and data are in Piping Specification.xls and Piping Catalog.xls.

  • Metric piping specifications are in Piping.xls.

Space Management

  • AllCodelists.xls

  • GenericNamingRules.xls

  • Shapes.xls for volumes

  • SpaceMgmt.xls

Structural Analysis

  • AllCodelists.xls

  • GenericNamingRules.xls

Structure

  • AllCodelists.xls

  • StructCustomCodelists.xls

  • AllCommon.xls

  • AllStructCommon.xls

  • GenericNamingRules.xls

  • SimpleDoor.xls

  • StructAssemblyConnections.xls

  • StructCrossSections_AISC_LRFD_3.1.xls

  • StructCrossSections-MISC_SHAPES-1.0.xls

  • StructEquipFoundations.xls

  • StructFootings.xls

  • StructFrameconnections.xls

  • StructHandrails.xls

  • StructInsulationSpec.xls

  • StructLadders.xls

  • StructMemberFireproofing.xls

  • StructOpeningsMetric.xls

  • StructPlateDimensions.xls

  • StructSlabAssemblyConnections.xls

  • StructSlabGeneral.xls

  • StructSlabLayer.xls

  • StructSplitConnections.xls

  • StructStairs.xls

  • StructWallAssemblyConnections.xls

  • StructWallCrossSection.xls

  • StructWallGeneral.xls

  • StructWallLayer.xls

  • StructWallOperators.xls

Systems and Specifications

  • AllCodelists.xls

  • GenericNamingRules.xls

  • The Copy to Catalog or Paste from Catalog commands require ModuleTypes.xls.

  • Control points require GenericNamingRules.xls.

  • Nozzles for piping, conduit, cable, and cable tray require Standard Nozzle Data.xls.

  • MatingPorts, PipingGenericDataFemale, and PlainPipingGenericData worksheets are required when placing the conduit fittings. These sheets are located in the Ten_Specs_SpecificationData.xls and Ten_Specs_CatalogData.xls.

See Also

Using Excel Workbooks to Configure Reference Data