Smart 3D Interface - Intergraph Smart Reference Data Standard Database - Version 12.3 - Help - Hexagon PPM

SDB Worksheets for Consistency with Smart3D

Project Defaults

A new project default, ZI_SP3D_VR, was introduced in SDB, with possible values 2009.1, 2011.1, 2011.R1, 2014, 2014.R1, 2016, 2018, 2019 and 13. The default value for this project default is 13. To support the latest version of Smart 3D v13, a new value 13 was added in SDB.

To generate the exported Excel (that is, exported Excel for Smart 3D from the SP3D 20.01 Export Jobs screen) with Smart 3D 2019, the project default value for ZI_SP3D_VR should be changed to 2018-2019. For generating exported Excel for Smart 3D 13, the value for this project default should be set to 13.

Smart 3D Sheet Procedure

A new Smart 3D procedure SET_SHT_ATTRS_FOR_S3D_VERSIONS has been created on Smart 3D Procedures. This procedure should be added to the sheets with attributes for Smart 3D versions 2009.1, 2011, 2011 R1, 2014, 2014 R1, 2016, 2018, 2019 and 13 on Data Table Configurations on the Attached Procedures tab.

S3D Hierarchy Structure in Smart Reference Data-SDB

SDB catalog structure is included with all the applicable class nodes and the Part Class sheets that are delivered with S3D. SDB Catalog Structure is modified to match the S3D Catalog Structure to the possible extent.

Configuration Update for Smart 3D Version 2011 R1 in SDB

List of New Attributes

The following table shows the new attributes that were added to the SDB sheet templates (SP3D 10.07 screen).

The attributes that have been deleted in Smart 3D 2011 R1, will not be exported in the exported template when the export is performed for Smart 3D 2011 R1.

The below attached procedure must be "active" for this functionality to work properly.

New Rules in SDB for Consistency with Smart 3D 2014

The following are the new piping rules that are added in Smart 3D 2014. SDB has provided sample data for these rules.

• BoltLengthLookupRule

• PipeBranchFabricationRule

• EndPrepCompatibleExceptionsRule

• NPDCompatibilityExceptionsRule

The following are the new HVAC rules which are added in Smart 3D 2014.

• MinimumDuctThickness

• PermissibleDuctThicknessPerSpec

Updated the properties in SDB to be compliant with Smart 3D version 2016

"MaterialsManagementIdent" attribute has been deleted from the connection parts and added to CommoditycodeSubstRule sheets to support S3D 2016. Also, updated the Smart 3D procedure SET_SHT_ATTRS_FOR_S3D_VERSIONS.

"MaterialsMgmtIDENT" attribute is removed from the following sheets in S3D 2016 Version:

• GasketPartData

• NutPartData

• WasherPartData

"MaterialsMgmtIDENT" attribute is added to the following sheets in S3D 2016 Version:

• BoltCommodityCodeSubstRule

• GasketCommodityCodeSubstRule

• NutCommodityCodeSubstRule

• WasherCommodityCodeSubstRule

Updated the properties in SDB to be compliant with the Smart 3D version 2018

• New attribute "PurchaseLengthBasisOption" has been added to "PipingMaterialsClassData" sheet to be compatible with S3D 2018.

• "CalculationProgIDs" sheet is updated with Dot Net progIDs.

Enabled the PreserveRows option in Data Table configuration for all the hierarchical codelist sheets in SDB

• The PreserveRows option is enabled in the data table configurations (SDB_SHT_CONFIG) for all the hierarchical codelist sheets in SDB.

• User can easily export the codelist sheets in the correct format for delta export and new entries with the required parent entries.

Configuration Update for Smart 3D Version 13 in SDB

Updated the properties in SDB to be compliant with the Smart 3D version 13.

• New attribute " FlangeSetBackDistanceProgID" has been added to "CalculationProgIDs" sheet to be compatible with Smart 3D 13.

• Updated SDB Custom Packages, General Configuration, Project Defaults and SDB delivered data to be inline and compatible with the latest Smart 3D version.

Smart 3D Interface Configurations in SDB

The Smart 3D interface is designed in a flexible and powerful way. Customers can maintain multiple sets of configurations and choose any one when creating an export job. Customers should create and work on customized versions of the SDB configurations.

Transfer Types

SDB has provided the data transfer types as listed below. These transfer types must be used for exporting SDB delivered data. All the SDB delivered transfer types are marked as Standard to prevent customers from modifying the delivered transfer types.

For Piping

• SDB_CODE_LISTS: Contains a list of data tables required for exporting SDB codelists data.

• SDB_GENERIC_DATA: Contains a list of data tables required for exporting SDB Generic data.

• SDB_PIPING_EN_SPEC: Contains a list of specification data tables required for exporting European Norm specifications.

• SDB_PIPING_JS_SPEC: Contains a list of specification data tables required for exporting Japanese Industry specifications.

• SDB_PIPING_SPEC_WBK: Contains a list of specification data tables required for exporting PIP, Power and BioPharma specifications.

• SDB_CATALOG: This is a sample transfer type delivered with SDB.

For Enterprise Content

• SDB_PLC_HVAC: Contains a list of data tables required for exporting HVAC data.

• SDB_PLC_CARNES_HVAC: Contains a list of data tables required for exporting Carnes HVAC data.

• SDB_PLC_LINDAB_HVAC: Contains a list of data tables required for exporting Lindab HVAC data.

• SDB_PLC_CONDUIT: Contains a list of data tables required for exporting Conduit data.

• SDB_PLC_CABLING: Contains a list of data tables required for exporting S3D cabling data.

• SDB_PLC_CABLETRAY: Contains a list of data tables required for exporting Cable Tray data.

• SDB_PLC_CABLEWAY: Contains a list of data tables required for exporting Cable Way data.

• SDB_PLC_DUCTBANK: Contains a list of data tables required for exporting Ductbank data.

• SDB_PLC_EQUIP: Contains a list of data tables required for exporting equipment data.

• SDB_PLC_MHE: Contains a list of data tables required for exporting MHE (Material Handling Equipment) data.

• SDB_PLC_MHEC: Contains a list of data tables required for exporting MHEC (Material Handling Equipment Component) data.

• SDB_HS_ASSEMBLY_CDL: Contains a list of data tables required for exporting Hangers and Supports - Assemblies codelist data.

• SDB_HS_S3DASSY_CDL: Contains a list of data tables required for exporting Hangers and Supports - S3D Assembly codelist data.

• SDB_HS_S3DPARTS_CDL: Contains a list of data tables required for exporting Hangers and Supports - S3D Parts codelist data.

• SDB_HS_SYSTEM_CDL: Contains a list of data tables required for exporting Hangers and Supports - S3D System codelist data.

• SDB_PLC_HS_AISC: Contains a list of data tables required for exporting Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

• SDB_PLC_HS_AN10: Contains a list of data tables required for exporting Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

• SDB_PLC_HS_ASSY: Contains a list of data tables required for exporting Hangers and Supports - S3D Assy data.

• SDB_PLC_HS_ASV2: Contains a list of data tables required for exporting Hangers and Supports - S3D AssembliesV2 data.

• SDB_PLC_HS_BP: Contains a list of data tables required for exporting Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

• SDB_PLC_HS_BP_A: Contains a list of data tables required for exporting Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

• SDB_PLC_HS_PART: Contains a list of data tables required for exporting Hangers and Supports - S3D Parts data.

• SDB_PLC_HS_SYS: Contains a list of data tables required for exporting Hangers and Supports - S3D System data.

• SDB_HS_DDAASSY_CDL: Contains a list of data tables required for exporting Hangers and Supports - DDS Assy codelist data.

• SDB_HS_DDS_PRT: Contains a list of data tables required for exporting Hangers and Supports - DDS Parts data.

• SDB_HS_DDSASSY: Contains a list of data tables required for exporting Hangers and Supports - DDS Assemblies data.

• SDB_SPEL_SPI_PLC_CBL: Contains a list of data tables required for exporting Smart Electrical and Smart Instrumentation cabling data.

For Structural

• SDB_STR_CROSSSECTION: Contains a list of data tables required for exporting Structure data.

• SDB_STIFFENER: Contains a list of data tables required for exporting structure data in stiffener format.

For Marine Content

• SDB_PLC_MC_GCMD: Contains a list of data tables required for exporting GC Macro Defnitions data.

• SDB_PLC_MC_GCSO: Contains a list of data tables required for exporting GC Standard Openings data.

• SDB_PLC_MC_GCTD: Contains a list of data tables required for exporting GC Template Definitions data.

• SDB_PLC_MC_SMBX: Contains a list of data tables required for exporting SM-BuiltUpCrossSections-Metric-1.0 data.

• SDB_PLC_MC_SMSC: Contains a list of data tables required for exporting SM_Struct Common data.

• SDB_PLC_MC_SMSX: Contains a list of data tables required for exporting SM_Struct Cross sections data.

Data Table Mappings

SDB has provided below list of Data Table mappings. These configurations must be used for exporting SDB delivered data from SDB.

For Piping

• SDB_ITEM_MAPPING: Contains Data table & Attribute mappings required for exporting PIP specifications, Power specifications, BioPharma specifications and component data defined in imperial units.

• SDB_METRIC_MAPPING: Contains Data table & Attribute mappings required for exporting European Norm specifications and component data defined in metric units.

• SDB_ITEM_MAPPING_JS: Contains Data table & Attribute mappings required for exporting Japanese Industry specifications.

For Enterprise Content

• SDB_ITEM_MAP_HVAC: Contains Data table mappings required for exporting HVAC data.

• SDB_ITM_CARNES_HVAC: Contains Data table mappings required for exporting Carnes HVAC data.

• SDB_ITM_LINDAB_HVAC: Contains Data table mappings required for exporting Lindab HVAC data.

• SDB_ITEM_MAP_CONDUIT: Contains Data table mappings required for exporting Conduit data.

• SDB_ITEM_MAP_CABL: Contains Data table mappings required for exporting Cabling data.

• SDB_ITEM_MAP_CTRY: Contains Data table mappings required for exporting CableTray and CableWay data.

• SDB_ITEM_MAP_EQUIP: Contains Data table mappings required for exporting Equipment data.

• SDB_ITEM_MAP_MHE: Contains Data table mappings required for exporting MHE (Material Handling Equipment) data.

• SDB_ITEM_MAP_MHEC: Contains Data table mappings required for exporting MHEC (Material Handling Equipment Component) data.

• SDB_ITEM_MAP_HS_AISC: Contains Data table mappings required for exporting Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

• SDB_ITEM_MAP_HS_AN10: Contains Data table mappings required for exporting Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

• SDB_ITEM_MAP_HS_ASSY: Contains Data table mappings required for exporting Hangers and Supports - S3D Assy data.

• SDB_ITEM_MAP_HS_ASV2: Contains Data table mappings required for exporting Hangers and Supports - S3D AssembliesV2 data.

• SDB_ITEM_MAP_HS_BP: Contains Data table mappings required for exporting Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

• SDB_ITEM_MAP_HS_BP_A: Contains Data table mappings required for exporting Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

• SDB_ITEM_MAP_HS_PART: Contains Data table mappings required for exporting Hangers and Supports - S3D Parts data.

• SDB_ITEM_MAP_HS_SYS: Contains Data table mappings required for exporting Hangers and Supports - S3D System data.

• SDB_ITEM_MAP_DDS_PRT: Contains Data table mappings required for exporting Hangers and Supports - DDS Parts data.

• SDB_ITEM_MAP_DDSASSY: Contains Data table mappings required for exporting Hangers and Supports - DDS Assemblies data.

• SDB_SPEL_SPI_MAP_CBL: Contains Data table mappings required for exporting Smart Electrical and Smart Instrumentation cabling data.

For Structural

• SDB_ITEM_MAP_STR: Contains Data table mappings required for exporting Structure data.

• SDB_ITEM_MAP_STIFF: Contains Data table mappings required for exporting Structure data in stiffener format.

For Marine Content

• SDB_ITEM_MAP_MC_GCMD: Contains Data table mappings required for exporting GC Macro Definitions data.

• SDB_ITEM_MAP_MC_GCSO: Contains Data table mappings required for exporting GC Standard Openings data.

• SDB_ITEM_MAP_MC_GCTD: Contains Data table mappings required for exporting GC Template Definitions data.

• SDB_ITEM_MAP_MC_SMBX: Contains Data table mappings required for exporting SM-BuiltUpCrossSections-Metric-1.0 data.

• SDB_ITEM_MAP_MC_SMSC: Contains Data table mappings required for exporting SM_Struct Common data.

• SDB_ITEM_MAP_MC_SMSX: Contains Data table mappings required for exporting SM_Struct Cross sections data.

Data Table Configurations

SDB has provided the below list of data table configs. These configurations must be used for exporting SDB delivered data from SDB. All the SDB delivered data table configurations are marked as Standard to prevent customers from modifying the delivered data table configs.

For Piping

• SDB_SHT_CONFIG: Contains data table configurations required for exporting PIP specifications, Power specifications, BioPharma specifications, codelists and component data defined in imperial units.

• SDB_METRI_SHT_CONFIG: Contains data table configurations required for exporting European Norm specifications and component data defined in metric units.

• SDB_SHT_CONFIG_JS: Contains data table configurations required for exporting Japanese Industry specifications and component data.

• SDB_SAMPLE_CONFIG: Sample Data Table configurations have been provided under this configuration.

For Enterprise Content

• SDB_SHT_CONFIG_HVAC: Contains data table configurations required for exporting HVAC data.

• SDB_CONF_CARNES_HVAC: Contains data table configurations required for exporting Carnes HVAC data.

• SDB_CONF_LINDAB_HVAC: Contains data table configurations required for exporting Lindab HVAC data.

• SDB_SHT_CNFG_CONDUIT: Contains data table configurations required for exporting Conduit data.

• SDB_SHT_CONFIG_CABL: Contains data table configurations required for exporting S3D Cabling, Smart Electrical and Smart Instrumentation Cabling data.

• SDB_SHT_CONFIG_CTRY: Contains data table configurations required for exporting CableTray & CableWay data.

• SDB_SHT_CONFIG_EQUIP: Contains data table configurations required for exporting Equipment data.

• SDB_SHT_CONFIG_MHE: Contains data table configurations required for exporting MHE (Material Handling Equipment) data.

• SDB_SHT_CONFIG_MHEC: Contains data table configurations required for exporting MHEC (Material Handling Equipment Component) data.

• SDB_SHT_CNFG_HS_AISC: Contains data table configurations required for exporting Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

• SDB_SHT_CNFG_HS_AN10: Contains data table configurations required for exporting Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

• SDB_SHT_CNFG_HS_ASSY: Contains data table configurations required for exporting Hangers and Supports - S3D Assy data.

• SDB_SHT_CNFG_HS_ASV2: Contains data table configurations required for exporting Hangers and Supports - S3D AssembliesV2 data.

• SDB_SHT_CNFG_HS_BP: Contains data table configurations required for exporting Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

• SDB_SHT_CNFG_HS_BP_A: Contains data table configurations required for exporting Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

• SDB_SHT_CNFG_HS_PART: Contains data table configurations required for exporting Hangers and Supports - S3D Parts data.

• SDB_SHT_CNFG_HS_SYS: Contains data table configurations required for exporting Hangers and Supports - S3D System data.

• SDB_SHT_CNFG_DDS_PRT: Contains data table configurations required for exporting Hangers and Supports - DDS Parts data.

• SDB_SHT_CNFG_DDSASSY: Contains data table configurations required for exporting Hangers and Supports - DDS Assemblies data.

• SDB_SPEL_SPI_SFG_CBL: Contains data table configurations required for exporting Smart Electrical and Smart Instrumentation Cables data.

For Structural

• SDB_SHT_CONFIG_STR: Contains data table configurations required for exporting Structure data.

• SDB_SHT_CONFIG_STIFF: Contains data table configurations required for exporting Structure data in Stiffener format.

For Marine Content

• SDB_SHT_CNFG_MC_GCMD: Contains data table configurations required for exporting GC Macro Definitions data.

• SDB_SHT_CNFG_MC_GCSO: Contains data table configurations required for exporting GC Standard Openings data.

• SDB_SHT_CNFG_MC_GCTD: Contains data table configurations required for exporting GC Template Definitions data.

• SDB_SHT_CNFG_MC_SMBX: Contains data table configurations required for exporting SM-BuiltUpCrossSections-Metric-1.0 data.

• SDB_SHT_CNFG_MC_SMSC: Contains data table configurations required for exporting SM_Struct Common data.

• SDB_SHT_CNFG_MC_SMSX: Contains data table configurations required for exporting SM_Struct Cross sections data.

Templates

SDB has provided the below list of Templates. These templates must be used for exporting SDB delivered data from SDB. All the SDB delivered templates are marked as Standard to prevent customers from modifying the delivered data table configs.

For Piping

• SDB_CODELISTS: Contains template data sheets required for exporting codelists data.

• SDB_TEMPLATE: Contains template data sheets required for exporting Generic Data, PIP Specifications, Power Piping Specifications and BioPharma Specifications.

• SDB_METRIC_TEMPLATE: Contains template data sheets required for exporting European Norm (EN) Specifications.

• SDB_TEMPLATE_JS: Contains template data sheets required for exporting Japanese Industry Specifications.

• SDB_TEMPLATE_SAMPLE: Contains sample template data sheets.

For Enterprise Content

• SDB_TEMPLATE_HVAC: Contains template data sheets required for exporting HVAC data.

• SDB_TPL_CARNES_HVAC: Contains template data sheets required for exporting Carnes HVAC data.

• SDB_TPL_LINDAB_HVAC: Contains template data sheets required for exporting Lindab HVAC data.

• SDB_TEMPLATE_CONDUIT: Contains template data sheets required for exporting Conduit data.

• SDB_TEMPLATE_CABL: Contains template data sheets required for exporting Cabling data.

• SDB_TEMPLATE_CTRY: Contains template data sheets required for exporting Cable Tray & Cable Way data.

• SDB_TEMPLATE_EQUIP: Contains template data sheets required for exporting Equipment data.

• SDB_TEMPLATE_MHE: Contains template data sheets required for exporting MHE (Material Handling Equipment) data.

• SDB_TEMPLATE_MHEC: Contains template data sheets required for exporting MHEC (Material Handling Equipment Component) data.

• SDB_TEMPLATE_HS_AISC: Contains template data sheets required for exporting Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

• SDB_TEMPLATE_HS_AN10: Contains template data sheets required for exporting Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

• SDB_TEMPLATE_HS_ASSY: Contains template data sheets required for exporting Hangers and Supports - S3D Assy data.

• SDB_TEMPLATE_HS_ASV2: Contains template data sheets required for exporting Hangers and Supports - S3D AssembliesV2 data.

• SDB_TEMPLATE_HS_BP: Contains template data sheets required for exporting Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

• SDB_TEMPLATE_HS_BP_A: Contains template data sheets required for exporting Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

• SDB_TEMPLATE_HS_PART: Contains template data sheets required for exporting Hangers and Supports - S3D Parts data.

• SDB_TEMPLATE_HS_SYS: Contains template data sheets required for exporting Hangers and Supports - S3D System data.

• SDB_TEMPLATE_DDS_PRT: Contains template data sheets required for exporting Hangers and Supports - DDS Parts data.

• SDB_TEMPLATE_DDSASSY: Contains template data sheets required for exporting Hangers and Supports - DDS Assemblies data.

• SDB_SPEL_SPI_TPL_CBL: Contains template data sheets required for exporting Smart Electrical and Smart Instrumentation cables data.

For Structural

• SDB_TEMPLATE_STR: Contains template data sheets required for exporting Structure data.

• SDB_TEMPLATE_STIFF: Contains template data sheets required for exporting Structure data in Stiffener format.

For Marine Content

• SDB_TEMPLATE_MC_GCMD: Contains template data sheets required for exporting GC Macro Definitions data.

• SDB_TEMPLATE_MC_GCSO: Contains template data sheets required for exporting GC Standard Openings data.

• SDB_TEMPLATE_MC_GCTD: Contains template data sheets required for exporting GC Template Definitions data.

• SDB_TEMPLATE_MC_SMBX: Contains template data sheets required for exporting SM-BuiltUpCrossSections-Metric-1.0 data.

• SDB_TEMPLATE_MC_SMSC: Contains template data sheets required for exporting SM_Struct Common data.

• SDB_TEMPLATE_MC_SMSX: Contains template data sheets required for exporting SM_Struct Cross sections data.

Sample Export Jobs

The following sample jobs are provided for exporting the delivered data from SDB:

For Piping

• SDB_EXP_CODELIST: Sample job for exporting all the SDB codelists.

• SDB_EXP_GENERIC_DATA: Sample job for exporting SDB Generic Data.

• SDB_EXP_ALL_PIPSPEC: Sample job for exporting all the PIP specifications in SDB.

• SDB_EXP_POWER_SPEC: Sample job for exporting all the Power piping specifications in SDB.

• SDB_EXP_ENSPEC: Sample job for exporting all the European Norm (EN) specifications in SDB.

• SDB_EXP_JSSPEC: Sample job for exporting all Japanese Industry specifications in SDB.

• SDB_EXP_GB: Sample job for exporting component data referring to Guobiao (GB) Standards.

• SDB_EXP_BPH_SPEC: Sample job for exporting Bio Pharma Specifications in SDB.

For Enterprise Content

• SDB_EXP_HVAC: Sample job for exporting HVAC specifications & Data in SDB.

• SDB_EXP_CARNES_HVAC: Sample job for exporting Carnes HVAC specifications & Data in SDB.

• SDB_EXP_LINDAB_HVAC: Sample job for exporting Lindab HVAC specifications & Data in SDB.

• SDB_EXP_CONDUIT: Sample job for exporting Conduit Data in SDB.

• SDB_EXP_CABLING: Sample job for exporting Cabling Data in SDB.

• SDB_EXP_CABLETRAY: Sample job for exporting CableTray specifications & Data in SDB.

• SDB_EXP_CABLEWAY: Sample job for exporting CableWay specifications & Data in SDB.

• SDB_EXP_DUCTBANK: Sample job for exporting Ductbank specifications & Data in SDB.

• SDB_EXP_EQUIPMENT: Sample job for exporting Equipment Data in SDB.

• SDB_EXP_MHE: Sample job for exporting MHE (Material Handling Equipment) Data in SDB.

• SDB_EXP_MHEC: Sample job for exporting MHEC (Material Handling Equipment Component) Data in SDB.

• SDB_HS_ASSEMBLY_CDL: Sample job for exporting Hangers and Supports - Assemblies codelist data.

• SDB_HS_S3DASSY_CDL: Sample job for exporting Hangers and Supports - S3D Assembly codelist data.

• SDB_HS_S3DPARTS_CDL: Sample job for exporting Hangers and Supports - S3D Parts codelist data.

• SDB_HS_SYSTEM_CDL: Sample job for exporting Hangers and Supports - S3D System codelist data.

• SDB_EXP_HS_AISC: Sample job for exporting Hangers and Supports - Structure AISC-LFRD 3.1 cross section data.

• SDB_EXP_HS_AN10: Sample job for exporting Hangers and Supports - S3D Parts data as per Anvil PH 2010 catalog.

• SDB_EXP_HS_S3DASSY: Sample job for exporting Hangers and Supports - S3D Assy data.

• SDB_HS_S3DASSYV2: Sample job for exporting Hangers and Supports - S3D AssembliesV2 data.

• SDB_EXP_HS_BP: Sample job for exporting Hangers and Supports - S3D Parts data as per Bergen PowerNF09.3 catalog.

• SDB_EXP_HS_BP_A: Sample job for exporting Hangers and Supports - S3D Assemblies data as per Bergen PowerNF09.3 catalog.

• SDB_EXP_HS_S3DPARTS: Sample job for exporting Hangers and Supports - S3D Parts data.

• SDB_EXP_HS_SYSTEM: Sample job for exporting Hangers and Supports - S3D System data.

• SDB_EXP_HS_DDS_CDL: Sample job for exporting Hangers and Supports - DDS Assy codelist data.

• SDB_EXP_HS_DDSPARTS: Sample job for exporting Hangers and Supports - DDS Parts data.

• SDB_EXP_HS_DDSASSY: Sample job for exporting Hangers and Supports - DDS Assemblies data.

• SDB_EXP_SPEL_SPI: Sample job for exporting Smart Electrical and Smart Instrumentation cabling data.

For Structural

• SDB_EXP_STRUCTURE: Sample job for exporting Structure data.

• SDB_EXP_STIFFENER: Sample job for exporting structure data in stiffener format.

For Marine Content

• SDB_EXP_MC_GCMACDEF: Sample job for exporting GC Macro Definitions data.

• SDB_EXP_MC_GCSTDOPN: Sample job for exporting GC Standard Openings data.

• SDB_EXP_MC_GCTEMDEF: Sample job for exporting GC Template Definitions data.

• SDB_EXP_MC_STRBXSECT: Sample job for exporting SM-BuiltUpCrossSections-Metric-1.0 data.

• SDB_EXP_MC_STRUCTCOM: Sample job for exporting SM_Struct Common data.

• SDB_EXP_MC_STRXSECT: Sample job for exporting SM_Struct Cross sections data.

SRD SDB - S3D Interface work process

The overriding objective of this integrated work process is to benefit from the key strengths and unique advantages of both tools – each being "best in class" – in the most efficient and highest value adding manner.

While there will always be company and project-specific requirements that may deviate from the process outlined below, this section describes how Hexagon clients would typically use these two systems in an integrated environment.

The role of Smart Reference Data in the integrated process is to enrich the Smart 3D "best in class" design and modeling capabilities, with its world market-leading capabilities in piping standards management:

• Creation and maintenance of material component libraries that consist of groups, parts, commodity codes, and idents.

• Creation and maintenance of material specifications combined with revision management.

• Creation and maintenance of miscellaneous information, and rules.

The integrated process itself is easy and characterized by limited dynamics:

• At the beginning of each project based on a new Smart 3D catalog, a one-time upload of the Smart Reference Data specifications and/or Smart Reference Data component library into Smart 3D takes place. A feedback loop with Smart Reference Data helps to ensure quality and change control.

• Revisions and ad-hoc updates are transferred from Smart Reference Data to Smart 3D whenever required during the project execution.

Export Components and Specifications to Smart 3D

After all the specifications have been successfully created, they can be transferred into Smart 3D. The following procedures are applicable to both product group and project group environments.

The workflow shown below explains how the export functionality behind the export screen of Smart 3D Transfer Jobs collects all required data. This includes component data, specification data, general Smart 3D interface data, template data (for example, the code lists and rules for Smart 3D), sheet configurations, and item mappings from the various areas in Smart Reference Data and the Smart 3D interface. Once all the required data is collected via the export function, the software writes the data into an Excel workbook, which can then be loaded into Smart 3D.

Export Jobs

1. Click Integration > Smart 3D > Smart 3D Transfer Jobs to run the export job for accessing the Smart 3D Bulk load sheets.

2. On the screen, enter the following details:

   • Job - Enter any job name to identify it. For example, enter 1CA1S01 as the job name based on the specification name to be exported to Smart 3D.

   • Comment - Enter comments for the job. For example, Export 1CA1S01. This is simply a description for the job name.

Destinations

Destination - Smart Reference Data can be delivered to different Smart 3D catalogs. Smart Reference Data keeps track of what was transferred to which Smart 3D instance, to enable incremental (delta) transfers. Each export destination has a name and is characterized by the catalog server, catalog schema server, catalog database, and catalog schema database.

1. Users can select the Destination from LOV.

2. If Smart Reference Data is used to feed multiple instances of Smart 3D, all the instances should be configured on this screen with a different destination name. This helps Smart Reference Data to understand what information is already transferred to Smart 3D for each instance/destination combination.

3. The user needs to update the Destination with Interface Version and Symbol Path to extract associated symbol DLLs and symbol Icons from Smart Reference Data as a ZIP file.

Transfer Types

Transfer Type is a logical grouping of Excel spread sheets to be populated. Currently, there are a few logical groups available in OOTB SDB.

Bulkload Utility

Bulk load Mode - The Bulk load utility is used to load the Excel spreadsheets into the Smart 3D catalog. While working with Smart Reference Data, it is recommended that the ADD_ MODIFY_DELETE option of the bulk loader is used. This option requires the bulk loader commands A, M, or D in the first column of each row of the Excel spreadsheet. These bulk loader commands are placed automatically by Smart Reference Data during the generation of the Excel spreadsheets.

Job Goal - The post data transfer scenario in Smart Reference Data depends on the selection in the Job Goal combo box. The available options are:

• PRE_IF_TABS

• FILL_IF_TABS

• VERIFY_CSTCY

• WRITE_TO_FILE

• BULKLOAD

• ANALYZE_LOG

• VERIFY_SP3D

• IMP_GUIDS

• COMPLETE_JOB

Following are some tips on the combo box selection in Smart Reference Data:

• It might be necessary to change and modify the codelist data during the project. If the changes have been performed in Smart Reference Data, the codelist workbook should be generated for loading into Smart 3D using Smart 3D Bulk load utility.

• It might also be necessary to update Smart 3D part class data, if existing Smart Reference Data components are modified, existing Smart Reference Data components are deleted, or new Smart Reference Data components are created. In such cases, Smart Reference Data takes care of the required change management in the Smart 3D part sheets. This means that the revised Smart 3D catalog data sheets being created by Smart Reference Data can be loaded with the Smart 3D Bulk load utility in the ADD_MODIFY_DELETE mode. With each export, Smart Reference Data creates the spreadsheets from the database and a user can decide whether they want to create a difference sheet. This will only show the modified, new, or deleted items, or if an entire sheet should be created. (See inventory description below)

• Another common exercise is the modification of Smart 3D specification sheets (all specification related sheets) by Smart Reference Data. Smart Reference Data stores all successfully transferred Smart 3D information in an inventory. After an update of specification-related attributes in Smart Reference Data, a new export job compares the current data against the inventory data. Smart Reference Data creates the A, M, D entries in the first column based on this comparison, where data changed is compared to the last transfer. An initial transfer always generates all records with the A (append) command. In a subsequent transfer, Smart Reference Data only creates new, deleted, or modified records.

Unchanged records compared to the previous transfer are not exported again.

A: Add the record

M: Modify the record

D: Delete the record for codelists. The Delete operation does not physically delete the record in the database.

• In some cases, the modification of a record happens inside the attributes building the unique key of the record. In this case, simple M information is not sufficient, because Smart 3D is not able to find the correct record. In such cases, the previous version of the record must be marked by a D. Then the new version of the record must be marked with an A. If such an update is carried out within a catalog that was already used in plants, the plants need to be synchronized with the catalog in the Smart 3D project management tool.

• Occasionally, the use of inventory logic in the interface is not required. In such cases, the job goal should be set to Write to File. After an export job has been executed, the job can be cancelled by clicking Cancel Job to not use the inventory. After the job is cancelled, the same sheets can be created once again, even though the containing data has not been changed. This method is especially helpful for training, testing, and during implementation phases. It is also useful in cases where reference data is delivered to different targets.

• All "generation" mechanisms in Smart Reference Data perform data validations (Smart Reference Data internal) and create detailed log files. When a log file reports a warning (for example, missing data or mapping), the problem should be resolved in the Smart Reference Data library or specification. A user should NOT attempt to manually modify data in the spreadsheets under any circumstances, to avoid information inconsistency.

Data Table Mappings/Attribute Mappings

• Data Table Mappings - The Data table mapping is a named set of relations between Sheets and assigned groups/parts/commodity codes/idents.

• Attribute Mappings - The Attribute mapping is a named set of relations between Sheet attributes and those values that should appear on distinct parts/commodity codes/idents or Specifications/spec items.

The search process proceeds in the following level order:

Ident> Commodity Codes > Commodity Parts > Spec Items > Spec Headers

If no mapping is found on one level, the search continues the next level.

On Data Table Configurations, there is a config setting on the attribute level that can restrict the levels scanned.

If the value is defined as read from geometric and the value is not found in the assigned geometric on Attribute Mappings, the higher mapping levels are automatically ignored, in the same way as if a value is not found in the geometric.

General Configurations

Config - Smart Reference Data can store different sets of settings. These settings are project independent. Copying a configuration, copies all the details such as configuration items and their values.

The general config items define different aspects of the Smart 3D interface. User may not be required to create new config items. However, if a config item is missing, it can be added on General Configurations.

The config items SI_SCHEDULE1_ATTRIBUTE and SI_SCHEDULE2_ATTRIBUTE should be set to ATTR_CHAR1 and ATTR_CHAR2 respectively to export Piping Specifications.

The config item SI_TRANSLATION_LEVEL should be set to IDENT to export Piping Specifications.

The config item SI_ASSOCIATED_CC_GRP_PART should be updated if associated commodity codes are required for new group part combinations as shown below:

The config item SDB_DEF_PROG_IDS should be updated with DOTNET_PROG_IDS and EXPORT_DLL_FILE with "Y" values, if the commodity codes are required to exported with Dot Net ProgIDs along with DLLs.

The config item SDB_DEF_PROG_IDS should be updated with VB6_PROG_IDS and EXPORT_DLL_FILE with "N" values, if the commodity codes are required to export with Legacy COM ProgIDs and Non-piping content from SDB.

The user needs to select the appropriate SDB_CONFIG from the LOV.

Templates

Template - There are many sheets required by the Smart 3D database to enable the placement of components or the intended automation.

The data for these sheets may not be extracted dynamically from the Smart Reference Data commodity code or geometric tables during Smart 3D export jobs. However, data not conventionally maintained or standardized using Smart Reference Data commodity code, geometric, ident, or specification management screens can be maintained in Smart Reference Data as TEMPLATES. These sheets can be extracted during Smart 3D export jobs and loaded in Smart 3D.

Some examples of TEMPLATE sheets are:

• ValveOperatorMatlControlData

• Operator’s Dimensional Data

Selection of Data to be exported in Transfer Job

The second block of the Transfer Jobs screen contains seven tabs as shown in the figure below:

Data Tables - This tab displays the sheets selected for exporting data to Smart 3D. The sheets are automatically added here, based upon the transfer type selected on the previous screen. Sheets can also be added or deleted manually on this screen before submitting the export job.

By keeping the selection switch Y for the General Configuration Item AUTO_SELECT_SHTS_FOR_PARTS on General Configurations, all the sheets applicable for the spec items in the selected spec codes automatically get "copied to" after submitting the job.

Specification Items - The specification code to be submitted for the Smart 3D export job is selected on this screen. Multiple specification codes can be submitted. By clicking LOV (F9), the selection list pops up, enabling the user to select the specification code to fill in the data.

After making all the relevant selections, click Save.

Idents - In a spec code, if the user wants to extract the part class sheet for an item such as an elbow, pipe, flange, and so on, the commodity code can be selected from the LOV. Users must select the group, part, and commodity code and then click Save.

Start Online

The previous screens show how to select relevant data for a Smart 3D export job. When a user clicks Start Online, the job is submitted for extraction.

After the job is started, the following steps are automatically executed by the export job.

This step performs the collection of ALL required data for later export. The data is stored in interface tables. After a job collects data for a component such as a specification, or a template (that is, a code list), no other job can access this data for the same destination unless the first job is not completed or cancelled.

After all the required data for the current export job is collected within the interface tables, the export job exports the data from the interface tables into Excel spreadsheets and stores them in one or several workbooks. Each of the steps explained above may fail due to many reasons.

To avoid the failure of steps,

• Check the settings in a job environment

• Check log files

• Verify that the settings given in the job environment (especially Data Table Configurations) are correct against assigned specification data, components, and all other sheets.

Once a job is successfully completed, the exported workbook is displayed on the Transfer Files Tab. Double-click the workbook name to download it to the user’s workstation.

Logfiles

1. Click the Log Files tab, to view the log files created during the Smart 3D export job.

2. Double-click the log file name to open the log file or to read the Consistency Check Report, Verification Report, Write_xlsx, and so on.

Transfer Files

1. Click the Transfer Files tab, to view the bulk load sheets workbook extracted by the Smart 3D export job.

2. Double-click the workbook. The workbook opens in a separate window. This file can be either saved in a different folder in Smart 3D or in the download folder of Smart Reference Data itself.

   

Once the export job has created the Excel workbook files, they are stored in a previously defined folder on the Smart Reference Data application server. These workbook files can be downloaded to any Smart Reference Data client by double-clicking the file name on the Transfer Files tab of Transfer Jobs.

It is necessary to transfer the workbook files into a folder from where the Smart 3D Bulk load utility can access them. The Bulk load utility is then started.

For more information on how the Bulk load utility is used, refer to the corresponding Smart 3D documentation.

The specifications, which must be verified, must be added to the right window. It is recommended that the Verify Symbol Placement checkbox is checked. This will virtually verify and place all specification components and report errors.

This tool produces an Excel workbook that reports issues and inconsistencies under several categories for the selected specifications and their components.

Verification has errors

The verification has errors:

By answering this question with NO, the user has found a problem in the Smart 3D catalog definition. If this error is due to the Smart Reference Data exported, the export environment inside the Smart Reference Data must be corrected until it fulfills the requirements of Smart 3D.

If the user cancels the job, it deletes the data of this job from the interface tables and allows a new job, or a new run of the same job to collect the data again from the scratch.

Once the reasons for errors within Smart 3D are identified, the appropriate settings in Smart Reference Data must be checked.

The settings in the Smart Reference Data can be checked using the methods below:

• Correcting the SP3D 10.07 Sheet Configs settings for a sheet and its attributes, by inserting new data on SP3D 10.04 Item Mappings

• Correcting the Smart Reference Data specifications or component base tables

• Adding additional data or modifying existing data on SP3D 10.08 Templates. Sometimes several of the above corrections must be performed to resolve an error.

Once the above corrections are finalized, a new job run can be created and started again.

Verification has no errors

The verification has no errors:

Once the verification of the data inside Smart 3D is verified as correct, the job can be completed.

During the execution of a job, Smart Reference Data requests the upload of the GUID sheet into Smart Reference Data. The GUID sheet is created by Smart 3D during bulkloading and stored in the workbook, which was loaded into Smart 3D.

Once the job goal is reached, the job is complete, and the current export workflow is finished.

If the same job (or a different job with the same destination, same sheets, and same specifications/components) is started again without a change in any data, most of the sheets (except special sheets such as custom interfaces) remain empty. This is because Smart Reference Data recognizes that the data has been successfully exported previously. In other words, as long as Smart Reference Data does not find new, deleted, or modified records in the current job interface table data compared with the inventory, no data is exported.

If the data must be exported entirely once again for any reason, the job must be started with a new destination.

Loading Exported Data to the Smart 3D Catalog

Existing Smart 3D Catalog

User can load the data exported from Smart Reference Data-SDB into an existing catalog or a new Smart 3D catalog.

1. Make sure that user has not added codelists from the Hexagon specific codelist range, otherwise there will be issues with codelists.

2. Bulk load the data exported from SDB in Append mode into an existing catalog in Smart 3D. Check that this operation does not result in any errors except for a few warnings.