Use the following table to create your property mappings:
Column header |
Column type |
Property mappings |
Action |
Parent object |
---|---|---|---|---|
Document Name |
Physical |
Name |
Create Update |
ComputedSPXEngineering DocMaster ComputedSPXEngineering DocRevision |
Document Description |
Physical |
Description |
Create Update |
ComputedSPXEngineering DocMaster ComputedSPXEngineering DocRevision |
Major revision |
Physical |
SPFMajorRevision |
Create Update |
ComputedSPXEngineering DocRevision |
Minor revision |
Physical |
SPFMinorRevision |
Create Update |
ComputedSPXEngineering DocRevision |
Document Revision Scheme |
Physical |
Name |
No Action |
Document Revision Scheme |
Document Owning Group |
Physical |
Name |
No Action |
Document Owning Group |
SPFPrimaryClassification |
Physical |
Name |
No Action |
SPFPrimaryClassification |
Area |
Physical |
Name |
No Action |
Area |
Unit |
Physical |
Name |
No Action |
Unit |
Project Number |
Physical |
Name |
No Action |
Project Number |
Discipline |
Physical |
Name |
No Action |
Discipline |
Originator |
Physical |
Name |
No Action |
Originator |
Book Reference Code |
Physical |
EngineeringDoc_BookReferenceCode |
Create Update |
ComputedSPXEngineering DocMaster |
Config |
Computed @CONFIG1@ |
Name |
No Action |
Config |
Computed Document Issue Date |
Computed func.DateTimeColumn([Document Issue Date], "dd-MM-yyyy", "UTC") |
SPFRevIssueDate |
Create Update |
ComputedSPXEngineering DocRevision |
ComputedPrimaryClassification |
Computed func.Decode([SPFPrimaryClassification], {"Design Documents", "", "Document Types", ""}, "") |
SPFClassificationOccurance |
No Action |
SPFPrimaryClassification |
-
Ensure that the Name property has been mapped for every object.
-
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.