CSV file example - SmartPlant Foundation - IM Update 48 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

Csv_File

Object mappings example

Column header

Column type

Object mappings

Object name

Optional interface

File 1

Physical

SPFDesignFile

File 1

ISPFNavigationFileComposition

MarkupFile

Physical

SPFMarkupFile

MarkupFile

AlternateRendition

Physical

SPFAlternateRendition

AlternateRendition

NavigationFile

Physical

SPFNavigationFile

NavigationFile

ISPFGraphicsMapComposition

GraphicsMap

Physical

SPFGraphicsMap

GraphicsMap

Property mappings example

Column header

Column type

Property mappings

Parent objects

File 1

Physical

Name

File 1

MarkupFile

Physical

Name

MarkupFile

AlternateRendition

Physical

Name

AlternateRendition

NavigationFile

Physical

Name

NavigationFile

GraphicsMap

Physical

Name

GraphicsMap

DesignFile Map

Computed (func.Concat( [FileDirectory], [File 1]))

SPFLocalFileName

File 1

MarkupFileName

Coputed (func.Concat ([FileDirectory],[MarkupFile]))

SPFLocalFileName

MarkupFile

AlternateRendition

Computed(func.Concat ([FileDirectory], [AlternateRendition]))

SPFLocalFileName

AlternateRendition

NavigationFileName

Computed(func.Concat ([FileDirectory], [NavigationFile]))

SPFLocalFileName

NavigationFile

GraphicsMap

Computed(func.Concat ([FileDirectory], [GraphicsMap]))

SPFLocalFileName

GraphicsFile

Relationships mappings example

Relationship mappings

End column 1

End column 2

SPFFileComposition

File 1

Document_NUMBER

SPFFileMarkup

File 1

MarkupFile

SPFAlternateRendition

File 1

AlternateRendition

SPFFileNavigationFile

File 1

NavigationFile

SPFGraphicsMap

NavigationFile

GraphicsFile

  • To identify supporting file objects, use query definition as .Name for SPFDesignFile, SPFMarkupFile, SPFAlternateRendition, SPFNavigationFile, and SPFGraphicsMap.

  • The design file must exist before the markup and navigation files in the Target system. The export weightings must be set to export the design file before the markup file and navigation file, and the navigation file before the graphics map. The navigation file must be exported before the graphics map file.

  • From Update 14 onwards, use the following query definitions to identify supporting file objects:

Object type

Target System Query Definition

SPFDesignFile

.Name,+SDVSPFFileComposition.Name,+SDVSPFFileComposition.SDVSPFMajorRevision,+SDVSPFFileComposition.SDVSPFMinorRevision

SPFMarkupFile

.Name,-SDVSPFFileMarkup.Name,-SDVSPFFileMarkup+SDVSPFFileComposition.Name,-SDVSPFFileMarkup+SDVSPFFileComposition.SDVSPFMajorRevision,-SDVSPFFileMarkup+SDVSPFFileComposition.SDVSPFMinorRevision

SPFNavigationFile

.Name,-SDVSPFFileNavigationFile.Name,-SDVSPFFileNavigationFile+SDVSPFFileComposition.Name,-SDVSPFFileNavigationFile+SDVSPFFileComposition.SDVSPFMajorRevision,-SDVSPFFileNavigationFile+SDVSPFFileComposition.SDVSPFMinorRevision

SPFAlternateRendition

.Name,-SDVSPFFileAlternateRendition.Name,-SDVSPFFileAlternateRendition+SDVSPFFileComposition.Name,-SDVSPFFileAlternateRendition+SDVSPFFileComposition.SDVSPFMajorRevision,-SDVSPFFileAlternateRendition+SDVSPFFileComposition.SDVSPFMinorRevision

SPFGraphicsMap

.Name,-SDVSPFFileGraphicsMap.Name,-SDVSPFFileGraphicsMap-SDVSPFFileNavigationFile.Name,-SDVSPFFileGraphicsMap-SDVSPFFileNavigationFile+SDVSPFFileComposition.Name,-SDVSPFFileGraphicsMap-SDVSPFFileNavigationFile+SDVSPFFileComposition.SDVSPFMajorRevision,-SDVSPFFileGraphicsMap-SDVSPFFileNavigationFile+SDVSPFFileComposition.SDVSPFMinorRevision