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.