Appendix: Smart 3D Export to PDMS Workbook - Intergraph Smart 3D - 13 - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D PDMS Conversion to Smart 3D

Language
English
Product
Intergraph Smart 3D
Search by Category
Administration & Configuration
Smart 3D Version
13
Smart Interop Publisher Version
16

The File > Export > PDMS Datal Export > Export Model command uses the Microsoft Excel workbook S3DPDMSExportMapping.xls to map all of the Smart 3D objects and object properties to the corresponding objects in PDMS. By default, the workbook is delivered in the [Reference Data Folder]\SharedContent\Data\Translators\S3DPDMSExport folder during setup.

The S3DPDMSExportMapping.xls workbook consists of all required types of translation mapping worksheets. Before you export Smart 3D model data, you must modify these mapping worksheets to ensure that all of the necessary criteria have been met.

The S3DPDMSExportMapping_DIN.xls workbook is also delivered in the [Reference Data Folder]\SharedContent\Data\Translators\S3DPDMSExport folder during setup. Default mapping is done according to the DIN standards for structural cross-sections.

See the comments in the delivered mapping file sheets for more information on configuring the mapping files.

Common Mapping Attribute Settings

When modifying the translation mapping worksheets, some of the data columns are specific to that individual worksheet. Other data columns are common amongst many mapping worksheets. When you modify a mapping worksheet, you may see any, or all, of the data columns listed below.

MapType

Indicates the map type of the attribute. Acceptable values are:

  • NameDef specifies that the value needs to be directly transferred. For example, an attribute named Name exists in the source system and an identical attribute named Name exists in the target system. Because both attributes have the same meaning, the value only needs to be transferred between the two systems. By default, if no MapType is specified, NameDef is used.

  • ValueDef specifies that the value of an attribute must be mapped before it is transferred.

  • AdditionalAttributeDef specifies that you must create new or additional attributes for the value of a given attribute.

  • PatternDef specifies that the creation of a new attribute value is to be based on a specific pattern.

    • n - Variable number of digits in a numeric field.

    • ? - Wild card. Matches any single printable character.

    • * - Wild token. Matches any number of printable characters.

    • [ ] - Literal character match. Matches the character that appears within the brackets. For example, [N] matches the upper case character, N.

    • ~ - Reverse pattern match. For example, AA-NNN~ matches AA-NNN or NNN-AA.

  • CharacterDef splits the value of an attribute using a delimiter or character position and string length to generate new attributes.

SheetName

Identifies the name of the sheet in the PDMSS3DImportMapping.xls workbook that contains additional mapping information related to the attribute, if any exists.

Formula

Defines the formula Smart 3D uses to calculate the value of the attribute to map, if one is needed. For example, if the source system has an attribute Radius that needs to be mapped to the destination system's attribute Diameter, the software cannot substitute one value for the other. Instead the value used for Diameter would result from the following calculation: Diameter = 2 * Radius.

Value

Defines the value to set for the Smart 3D attribute, or defines the PDMS value that needs additional mapping.

Label

Specifies whether the Smart 3D attribute is a label. Type TRUE/YES or FALSE/NO. Entries can be in lowercase or uppercase. See Export equipment attributes using labels.

Ignore

Specifies whether the item is ignored during import. Type TRUE/YES or FALSE/NO. Entries can be in lowercase or uppercase.

Remarks

Specifies any additional information regarding the data being mapped.

See Also

Set up the PDMS and Smart 3D Catalogs