There may be cases where a value that is required for a mapping is either not available in the physical file or the physical data supplied needs to be reformatted. In such cases, a computed column can be set up. For example, there is no column for the revision to map to, so a new computed column is required. The document revision has been created using the computed column, COMP_REVISION, which creates a revision object.
-
In the Import Definitions pane, select the ImportDef-Documents import definition.
-
Click Create New Column Header.
-
In the Column Header pane, select Computed from the Column Type list.
-
Type COMP_REVISION in the Name box.
-
Type func. in the Computed API box, double-click Replace to select it from the drop-down list, and type the parameter string syntax, func.Replace([Name], "ZZ", "ZZ"). This function simply copies the data in the Name column to this new column.
Column header
Column type
Object mappings
Is mandatory
Action
UID (unique identifier)
COMP_REVISION
Computed
func.Replace([Name], "ZZ", "ZZ")
SPFDesignDocRevision
Yes
Create Update
COMP_REVISION
COMP_CONFIG
Computed
@CONFIG1@
SPFPlant
No
Check Exists
COMP_CONFIG
-
As there is no Copy function available, the Replace function is being used in the COMP_REVISION computed column.
-
Ensure that the Name property has been mapped to the objects.