The ExportAttributeMapping.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.
Provides an index of all the other sheets in the workbook.
Provides the main mapping sheet for neutral schema mapping. This sheet in turn refers to the other NSchema mapping sheets.
Maps the supported classes between Smart 3D and the neutral schema. This is the main mapping sheet for the neutral schema translation.
Maps structural compartment user attributes and interfaces between Smart 3D and the neutral schema.
Maps structural spatial load user attributes and interfaces between Smart 3D and the neutral schema.
Maps structural unit load user attributes and interfaces between Smart 3D and the neutral schema.
Maps model details between Smart 3D and the neutral schema.
Maps model additional model attributes between Smart 3D and the neutral schema.
Maps additional model attributes between Smart 3D and the neutral schema.
Maps principal particulars attributes between Smart 3D and the neutral schema.
Maps third party application details between Smart 3D and the neutral schema.
Maps third party application attribute details between Smart 3D and the neutral schema.
Maps third party additional attribute details between Smart 3D and the neutral schema.
Maps the Smart 3D cross-section user attributes and interfaces between Smart 3D and the neutral schema.
Maps the member system user attributes and interfaces between Smart 3D and the neutral schema.
Maps the member part user attributes and interfaces between Smart 3D and the neutral schema.
Maps the design member part user attributes and interfaces between Smart 3D and the neutral schema.
Maps the Smart 3D cross-section attributes and interfaces between Smart 3D and the neutral schema.
Defines global settings for data export to the neutral schema.
Mapping Sheets Columns
Defines the Smart 3D object attribute to map.
Defines the neutral schema attribute to which the Smart 3D attribute value is mapped.
Defines the map type of the attribute. Acceptable values are as follows:
NameDef - Used when the value needs to be directly transferred. For example, there is an attribute named Name in the source system and the same attribute named name in the target system. Because both attributes have the same meaning, the value just needs to be transferred between the two systems. By default, if no MapType is specified, NameDef is used.
ValueDef - Used when the value of an attribute needs to be mapped before it is transferred.
AdditionalAttributeDef - Used when it is necessary to create new or additional attributes for the value of a given attribute.
PatternDef - Used when any valid regular expression can be used to map the values.
CharacterDef - Used to split the value of an attribute using a delimiter or character position and string length to generate new attributes.
Defines the name of the sheet in the ExportAttributeMapping.xls workbook that contains additional mapping information related to the attribute, if any exists.
Defines the formula used to calculate the value of the attribute to mapped, 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 results from the following calculation: Diameter = 2 * Radius.
Specifies the value of the neutral schema attribute.
Specifies whether the Smart 3D attribute is a label. Type TRUE/YES or FALSE/NO. Entries can be in lowercase or uppercase.
Specifies whether the item is ignored during export. Type TRUE/YES or FALSE/NO. Entries can be in lowercase or uppercase.
Use the labels in Smart 3D to map the direct properties of objects or the properties of the related objects such as traverse relationships.
The following steps illustrate how to export the structure member weight to the neutral schema xml file:
If a label is not available in the Catalog task, create a label that gives the Structure Member Weight of the placed member.
For more information about creating labels, see Label Editor Command in the Catalog User's Guide.
Open the MemberPartMap sheet in translation mapping file.
The MemberPartMap sheet is available in the ExportAttributeMapping.xls workbook. By default, the ExportAttributeMapping.xls workbook is available in the following location:
[Reference Data Folder]\SharedContent\Data\TranslatorsMarine\AttributeMapFile.
Map the Smart 3D Attribute to the corresponding Neutral Schema Attribute.
Type TRUE in the Label column.
Save the mapping file.
Label mapping is not applicable for GeniE export functionality.
The ExportAttributeMapping.xls workbook also supports hierarchical mapping between source and target systems. For example, if the source object has an attribute value called web length on a cross-section object using the following hierarchy:
If the above hierarchy is matched with Web.WebLength on the target system, then you can directly map this hierarchy in the Value and Target Attribute columns.
This hierarchical mapping is applicable until a child item is a direct attribute on its parent.