ExportAttributeMapping.xls - Intergraph Smart 3D - Help

Intergraph Smart 3D Molded Forms

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Help
Version_S3D
10.1(2014R1)

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.

Worksheets

Index

Provides an index of all the other sheets in the workbook.

NSchemaMap

Provides the main mapping sheet for neutral schema mapping. This sheet in turn refers to the other NSchema mapping sheets.

Smart3DClassMap

Maps the supported classes between Smart 3D and the neutral schema. This is the main mapping sheet for the neutral schema translation.

CompartmentMap

Maps structural compartment user attributes and interfaces between Smart 3D and the neutral schema.

SpatialLoadingMap

Maps structural spatial load user attributes and interfaces between Smart 3D and the neutral schema.

UnitLoadingMap

Maps structural unit load user attributes and interfaces between Smart 3D and the neutral schema.

ModelDetailsMap

Maps model details between Smart 3D and the neutral schema.

ModelAdditionalAttributesMap

Maps model additional model attributes between Smart 3D and the neutral schema.

AdditionalAttributesMap

Maps additional model attributes between Smart 3D and the neutral schema.

PrincipalParticulars

Maps principal particulars attributes between Smart 3D and the neutral schema.

ThirdPartyDetailsMap

Maps third party application details between Smart 3D and the neutral schema.

ThirdPartyApplicationAttrMap

Maps third party application attribute details between Smart 3D and the neutral schema.

ThirdPartyAdditionalAttrMap

Maps third party additional attribute details between Smart 3D and the neutral schema.

SM3DCrossSectionMap

Maps the Smart 3D cross-section user attributes and interfaces between Smart 3D and the neutral schema.

MemberSystemMap

Maps the member system user attributes and interfaces between Smart 3D and the neutral schema.

MemberPartMap

Maps the member part user attributes and interfaces between Smart 3D and the neutral schema.

DesignMemberPartMap

Maps the design member part user attributes and interfaces between Smart 3D and the neutral schema.

SP3DCrossSectionMap

Maps the Smart 3D cross-section attributes and interfaces between Smart 3D and the neutral schema.

GlobalsMap

Defines global settings for data export to the neutral schema.

Mapping Sheets Columns

Source Attribute

Defines the Smart 3D object attribute to map.

Target Attribute

Defines the neutral schema attribute to which the Smart 3D attribute value is mapped.

MapType

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.

SheetName

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

Formula

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.

Value

Specifies the value of the neutral schema attribute.

Label

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

Ignore

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

Mapping Tips

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:

  1. 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.

  2. 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.

  3. Map the Smart 3D Attribute to the corresponding Neutral Schema Attribute.

  4. Type TRUE in the Label column.

  5. Save the mapping file.

Label mapping is not applicable for GeniE export functionality.

Hierarchical Mapping

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:

IJUAXSectionWeb.WebLength

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.