Use the following table to create your property mappings:
|
Column header |
Column type |
Property mappings |
Action |
Parent object |
|---|---|---|---|---|
|
Title |
Physical |
SPFTitle |
Create Update |
SPFDesignDocMaster Name |
|
Major Revision |
Physical |
SPFMajorRevision |
Create Update |
SPFDesignDocRevision (COMP_REVISION) |
|
Minor Revision |
Physical |
SPFMinorRevision |
Create Update |
SPFDesignDocRevision (COMP_REVISION) |
|
COMP_DESIGNPATH |
Computed func.Concat({[FileDirectory], [File]}) |
SPFLocalFileName |
Check Staging File Exists |
(SPFDesignFile) File |
|
COMP_NAVIGATIONFILE |
Computed func.Concat({[FileDirectory], [Navigation File]}) |
SPFLocalFileName |
Check Staging File Exists |
(SPFNavigationFile) Navigation File |
|
COMP_GRAPHICSPATH |
Computed func.Concat({[FileDirectory], [Graphics Map File]}) |
SPFLocalFileName |
Check Staging File Exists |
(SPFGraphicsMap) Graphics Map File |
|
COMP_ISSUE_DATE |
Computed func.DateTimeColumn([Issue date], "dd-MM-yyyy", "UTC") |
SPFRevIssueDate |
Create Update |
(SPFDesignDocRevision) COMP_REVISION |
-
All the objects must be mapped to the Name property.
-
The file name and the file directory can be in different columns or concatenated into a single computed column.
-
The format of the issue date in the CSV file must match the format in the staging server. Otherwise, you can use the computed column function to correct the format in the CSV file.
-
The issue date has been mapped to the SPFRevIssueDate property and it decides the state of the document. If different revisions of the same document are loaded into Data Validator, the following scenarios are possible:
-
If the column has a value, for example 01-01-2017, the revision state is set to CURRENT, and the revision number is 01A.
-
If the column has a value, for example 10-01-2017, the CURRENT revision is changed to SUPERSEDED and the latest revision is set to CURRENT, and the revision number is 03A.
-
If the column has a value, for example 05-01-2017, the revision state is set to SUPERSEDED because a more recent revision is available, and the revision number is 02A.
-
If the column has no values in the input CSV, then the revision state is WORKING, and the revision number is 04A.
-