The following CSV example mappings are an extension of the Document mappings. However, this section only shows the extensions to work with files and does not list the document mappings.
CSV file example
Object mappings example
Column header |
Column type |
Object mappings |
Object name |
---|---|---|---|
File 1 |
Physical |
SPFDesignFile |
File 1 |
File 2 |
Physical |
SPFDesignFile |
File 2 |
Property mappings example
Column header |
Column type |
Property mappings |
Parent objects |
---|---|---|---|
File1 |
Physical |
None |
n/a |
File2 |
Physical |
None |
n/a |
File1 Path |
Computed (Concat, Fileshare, and File1) |
SPFLocalFileName |
File1 |
File2 Path |
Computed (Concat, Fileshare, and File2) |
SPFLocalFileName |
File2 |
UID Definitions mappings example
Column header |
Object mappings |
Unique identifier |
Prefix |
---|---|---|---|
File1 |
SPFDesignFile |
[Document Name], [Major Revision Code], [Minor Revision Code], [Version Number], [File1] |
DM |
File2 |
SPFDesignFile |
[Document Name], [Major Revision Code], [Minor Revision Code], [Version Number], [File2] |
DM |
The Version Number is a constant column, which contains the literal "1". This ensures that the uniqueness is the same as defined in the SmartPlant Foundation target system’s document version UID Definition. This assumes that the document version UID Definition has the version number and the UID definition for the file object. For example:
SPFUIDDef="+SPFFileComposition.UID,Name"
Relationships mappings example
Relationship mappings |
End column 1 |
End column 2 |
---|---|---|
SPFFileComposition |
[File1] |
[Document Name] |
SPFFileComposition |
[File2] |
[Document Name] |
The revision must exist before the file can exist. The export weightings must be set to export the revision before the file.