This workbook contains mapping for both neutral schema and GeniE export. That is, it contains all the sheets of the ExportAttributeMapping.xls workbook and the mapping sheets needed for GeniE export. In the existing sample mapping sheets, you can add new mapping entries.
Worksheets
Index
Provides an index of all the other sheets in the workbook. It describes all other sheets in the workbook.
GeniEMap
Provides the main mapping sheet for GeniE mapping. This sheet in turn refers to the other GeniE mapping sheets.
GeniEClassMap
Maps the supported structure classes between Smart 3D and GeniE export. This is the main mapping sheet for the GeniE translation.
GeniEGlobalsMap
Defines global settings for data export to GeniE Schema.
StraightMemSystemAttrsMap
Maps the straight member system attributes and interfaces between the neutral and GeniE schemas.
CurvedMemSystemAttrsMap
Maps the curved member system attributes and interfaces between the neutral and GeniE schemas.
StraightMemPartAttrsMap
Maps the straight member part attributes and interfaces between the neutral and GeniE schemas.
CurvedMemPartAttrsMap
Maps the curved member part attributes and interfaces between the neutral and GeniE schemas.
StraightStiffenerSysAttrsMap
Maps the straight stiffener system attributes and interfaces between the neutral and GeniE schemas.
CurvedStiffenerSysAttrsMap
Maps the curved stiffener system attributes and interfaces between the neutral and GeniE schemas.
StraightERSysAttrsMap
Maps the straight edge reinforcement system attributes and interfaces between the neutral and GeniE schemas.
CurvedERSysAttrsMap
Maps the curved edge reinforcement system attributes and interfaces between the neutral and GeniE schemas.
BeamSysAttrsMap
Maps the beam system attributes and interfaces between the neutral and GeniE schemas.
MaterialMap
Maps the material attributes and interfaces between the neutral and GeniE schemas.
ApplicationDetailsMap
Maps the application details between the neutral and the GeniE schemas.
UnitsNameMap
Maps the unit names and interfaces between the neutral and GeniE schemas.
UnitsMap
Maps the unit attributes and interfaces between the neutral and GeniE schemas.
FlatBarXSectionMap
Maps the flat bar cross-section attributes and interfaces between the neutral and GeniE schemas.
AngleXSectionMap
Maps the angle cross-section attributes and interfaces between the neutral and GeniE schemas.
GeneralXSectionMap
Maps the generic cross-section attributes and interfaces between Neutral and GeniE Schema.
IXSectionMap
Maps the I-cross-section attributes and interfaces between the neutral and GeniE schemas.
ChannelXSectionMap
Maps the channel cross-section attributes and interfaces between the neutral and GeniE schemas.
TubeXSectionMap
Maps the tubular cross- section attributes and interfaces between the neutral and GeniE schemas.
BoxXSectionMap
Maps the box cross-section attributes and interfaces between the neutral and GeniE schemas.
XSectionAdditionalAttrMap
Maps the cross-sectional additional attributes and interfaces between the neutral and GeniE schemas.
SlabAttrsMap
Maps the slab attributes and interfaces between the neutral and GeniE schemas.
FlatPlateSysAttrsMap
Maps the flat plate system attributes and interfaces between the neutral and GeniE schemas.
CurvedPlateSysAttrsMap
Maps the curved plate system attributes and interfaces between the neutral and GeniE schemas.
EquipmentAttrsMap
Maps the equipment attributes and interfaces between the neutral and GeniE schemas.
EqpFoundationAttrsMap
Maps the equipment foundation attributes and interfaces between the neutral and GeniE schemas.
FootingAttrsMap
Maps the footing attributes and interfaces between the neutral and GeniE schemas.
StairAttrsMap
Maps the stair attributes and interfaces between the neutral and GeniE schemas.
LadderAttrsMap
Maps the ladder attributes and interfaces between the neutral and GeniE schemas.
HandRailAttrsMap
Maps the hand rail attributes and interfaces between the neutral and GeniE schemas.
LoadCaseAttrMap
Maps the load case attributes and interfaces between the neutral and GeniE schemas.
LoadCombinationAttrMap
Maps the load combination attributes and interfaces between the neutral and GeniE schemas.
PointLoadAttrMap
Maps the point load attributes and interfaces between the neutral and GeniE schemas.
UDLAttrMap
Maps the UDL load attributes and interfaces between the neutral and GeniE schemas.
Mapping Sheets Column Description
Source Attribute
Defines the neutral schema attribute to be mapped.
Target Attribute
Defines the GeniE schema attribute to which the neutral schema 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 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 would result 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.
Hierarchical Mapping
The S3DGeniEExportMapping.xls workbook also supports hierarchical mapping between source and target systems. For example, if the source object has an attribute called COG on Equipment using the following hierarchy:
EquipmentProperties.Physical.DryCoG.Point3D.X
And if the above hierarchy is matched with cog.x on the target system, then you can directly map this hierarchy in the Source Attribute and Target Attribute columns.
This hierarchical mapping is applicable until a child item is a direct attribute on its parent.