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 workbook(s)
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.
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.
You can also run the Bulkload utility from the command line. For more information,
see Bulkload from the Command Line in the Reference Data Guide, available from the Help > Printable Guides command.
|
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
|
|
|
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
|
-
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