The SPCRetrieveMappings.xlsm workbook contains separate tabs; each defines different properties and data required for retrieving documents into Smart Construction.
-
Column names are fixed and cannot be modified.
-
Columns can be moved to different locations on the same sheet.
-
Do not add new columns. Smart Construction does not read or handle any newly added columns.
Main tab
The Main tab is located on the first sheet of the workbook. It contains the Generate Retrieve Mapping button, which generates the XML file and saves it in the location specified when the file is checked out.
The Generate Retrieve Mapping button should not be renamed or removed because it contains a macro. The code behind the button should not be modified or removed.
Tool Specific tabs
Each tool-specific tab contains data and properties for tools that publish to SmartPlant Foundation and the mapping between those properties and Smart Construction.
Column Header |
Explanation |
---|---|
DomainUID |
Unique ID for the specific tool domain that is used by SmartPlant Foundation when doing schema mapping. |
EFClassDef |
Class definition of the object published into SmartPlant Foundation. |
EFInterface |
Interface definition of the object published into SmartPlant Foundation. It exposes the EFProperty defined on the same row. You can also use a view definition in this column. |
EFProperty |
Property definition of the object published into SmartPlant Foundation. If multiple values are available for a property of a published object, you can specify an identifier, such as MAX, MIN, or AVG, to get the maximum, minimum, or average value for the mapped property. |
SPCInterface |
Interface definition of the Smart Construction property into which the EFSchema property published maps to. |
SPCProperty |
Property definition of the Smart Construction property into which the EFSchema property published. |
Formula |
Formula definition of an object, either published into SmartPlant Foundation that is used by Smart Construction during schema mapping or a Smart Construction object. For mapped components, such as equipment, the formula can be "1." |
FormulaUOM |
Unit of measurement for the object, either published into SmartPlant Foundation that is used by Smart Construction during schema mapping or a Smart Construction object. For mapped components such as equipment, the FormulaUOM can be "each." |
You can specify either an interface and property definition (EFInterface/EFProperty) or a formula definition (Formula/FormulaUOM) as the source for a SmartPlant Foundation property to be mapped to a Smart Construction property, but you cannot specify both.
OrderedValues tab
The OrderedValues tab lists table names and values used to specify enumerated properties for view definitions.
Column Header |
Explanation |
---|---|
TableName |
Name of a table referenced by the enumerated entry. |
Name |
Name of the enumerated entry. |
Value |
An order value for the enumerated entry. |
ComponentCategories tab
The ComponentCategories tab maps component categories to class definitions for a particular tool. Data in the same row maps a particular category to a class definition and domain unique ID.
-
The component category must be spelled exactly the same as the component category in SmartPlant Foundation Desktop Client. For more information, see Manage Component Disciplines and Categories.
-
If a class definition is not assigned a component category, engineered published components related to the class definition are excluded from the Smart Construction retrieve.
Column Header |
Explanation |
---|---|
ComponentCategory |
Category of a component within a discipline. |
DomainUID |
Unique ID for the specific tool domain that is used by SmartPlant Foundation when doing schema mapping. |
EFClassDef |
Class definition of the object published into SmartPlant Foundation. |
EFInterface |
Interface definition of the object published into SmartPlant Foundation. It exposes the EFProperty defined on the same row. |
EFProperty |
Property definition of the object published into SmartPlant Foundation. |
Value |
The value to compare the existing property value against. If multiple values need to be compared to a property of a published object, list the values in brackets, separated with a pipe. For example, {Value1 | Value2 | Value3}. |
FabricationReplaceable |
Select Y to signify that the class definition specified in the EFClassDef column is fabrication replaceable. When a component is retrieved (or a component correlated to the component being retrieved) has a class definition marked as replaceable and a correlated equivalent component, it is replaced by that equivalent component. |
AssemblyDefinition tab
The AssemblyDefinition tab maps an EF interface definition to a Smart Construction class definition, either SPC_Spool or SPC_Assembly. Published components that are published to the interface definition are retrieved to the Smart Construction class definition. As a result, components can be grouped as spools or assembly definitions.
Column Header |
Explanation |
---|---|
EFInterface |
Interface definition of the object published into SmartPlant Foundation. |
SPCClass |
Smart Construction class definition of the object, either SPC_Spool or SPC_Assembly. |
Grouping tab
The Grouping tab allows you to define a group. The group is represented as a single item in Smart Construction, and its geometry is the accumulation of each of the group elements. For example, you can define every graphic of a nozzle as part of the geometry of the equipment class definition. The nozzles would be highlighted in models and drawings together as a group and added to IWPs as a single component.
Column Header |
Explanation |
---|---|
GroupRepresentative |
EF class definition of the item which is going to be the representative of a group. |
GroupRelationToExpand |
EF relationship definition to expand to navigate from the group representative to the corresponding group elements. |
GroupElements |
EF class definition of the group elements. |
SPCRepresentative |
Corresponding representative in Smart Construction. The value is SPC_ComponentItem. |