Identifiers in the SPCRetrieveMapping.xlsm workbook examples - Intergraph Smart Construction - 2019 (7.0) - Customization - Hexagon PPM

Intergraph Smart Construction Customization (2019)

Language
English
Product
Intergraph Smart Construction
Search by Category
Customization & Programming
Smart Construction Version
2019(7.0)

Use the following examples to understand how to use identifiers in the SPCRetrieveMapping.xlsm workbook.

Mapping size for instruments

An instrument may use two different sizes, 6-inch or 8-inch; you can specify that the EFProperty be MAX(Nominal Diameter) in the SPCRetrieveMappings.xlsm, which informs the base processor to return the maximum value for the size property.

First, the processor checks the location defined in the Server Manager property SPCRetrievePropertyProcessorsDirectory to see if any custom processors exist for the published object. If no processor is found, the software checks if there are any internal processors. If there are not any internal processors, the software defaults to the base processor class to attempt a standard mapping.

Mapping thickness for a piping component

A piping component can have multiple ports, and each opening can have a different thickness. You can specify that the minimum or maximum values be used to calculate the thickness for a piping component by using identifiers in the SPCRetrieveMapping.xlsm.

The EFProperty is MAX(ScheduleThickness 2, Thickness), which indicates that the maximum value for schedule thickness in the thickness table on the OrderedValues tab be used to specify thickness for this piping component.

The column header TableName defines table name (in this case, Thickness). Name defines the thickness enumerated value, and Value defines thickness enumerated value. The Value column returns either the maximum or minimum value for the table Thickness.