The following example mappings illustrate how to create an import mapping from the object mappings to the relationships.
CSV file example
Object mappings example
|
Column header |
Column type |
Object mappings |
Object name |
|---|---|---|---|
|
Name |
Physical |
SPFDesignDocRevision |
Document Name |
|
Title |
Physical |
SPFDesignDocMaster |
Document Title |
|
Class |
Physical |
SPFDocumentClass |
Document Class |
|
Revision Scheme |
Physical |
SPFRevisionScheme |
Revision Scheme |
|
Owning Group |
Physical |
SPFDataAccessGroup |
SPFDataAccessGroup |
Property mappings example
|
Column header |
Column type |
Property mappings |
Parent objects |
|---|---|---|---|
|
Name |
Physical |
Name |
[Document Name], [Document Title] |
|
Title |
Physical |
SPFDescription |
[Document Name], [Document Title] |
|
Issue Date |
Physical |
SPFIssueDate |
[Document Name] |
|
Major Revision |
Physical |
SPFMajorRevision |
[Document Name] |
|
Minor Revision |
Physical |
SPFMinorRevision |
[Document Name] |
|
Class |
Physical |
SPFDocumentClass |
[Document Class] |
|
Revision Scheme |
Physical |
SPFRevisionScheme |
[Revision Scheme] |
|
Owning Group |
Physical |
SPFDataAccessGroup |
[SPFDataAccessGroup] |
SPFIssueDate must be set as GMT and invariant format (the date time computed column
can format and change the value).
UID Definitions mappings example
|
Column header |
Object mappings |
Unique identifier |
Prefix |
|---|---|---|---|
|
Name |
SPFDesignDocRevision |
[Document Name], [Major Revision Code], [Minor revision Code] |
DM |
|
Title |
SPFDesignDocMaster |
[Document Name] |
DM |
|
Class |
SPFDocumentClass |
[Document Class] |
DC |
|
Revision Scheme |
SPFRevisionScheme |
[Revision Scheme] |
RS |
|
Owning Group |
SPFDataAccessGroup |
[SPFDataAccessGroup] |
DAG |
Data Validator requires all UID definitions must be in place in the target system.
Relationships mappings example
|
Relationship mappings |
End column 1 |
End column 2 |
|---|---|---|
|
SPFDocumentRevisions |
Title |
Name |
|
SPFItemOwningGroup |
Name |
Owning Group |
|
SPFDocRevisionRevisionScheme |
Name |
Revision Scheme |
|
SPFPrimaryClassification |
Class |
Title |