The File > Import > PDMS Datal Import > Import Model command uses the Microsoft Excel workbook PDMSS3DImportMapping.xls to map all of the PDMS objects and object properties to the corresponding objects in Smart 3D. By default, the workbook is delivered in the [Product Folder]\3DRefData\SharedContent\Data\Translators\PDMSS3DImport folder during setup.
The PDMSS3DImportMapping.xls workbook consists of all of the required types of translation mapping worksheets. Before you import PDMS model data, modify these mapping worksheets to ensure that they meet all of the necessary criteria. Refer to 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.
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 value for an attribute 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.
Identifies the name of the sheet in the PDMSS3DImportMapping.xls workbook that contains additional mapping information related to the attribute, if any exists.
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.
Defines the value to set for the Smart 3D attribute, or defines the PDMS value that needs additional mapping.
Specifies whether the Smart 3D attribute is a label. Type TRUE/YES or FALSE/NO. Entries can be in lowercase or uppercase. For more information, see Map equipment attributes using labels.
Specifies whether the item is ignored during import. Type TRUE/YES or FALSE/NO. Entries can be in lowercase or uppercase.
Specifies any additional information regarding the data being mapped.