The Validate Data page is used to check the data pending import for errors.
On the left is a listing of the files and groups uploaded to the import. They can be selected by clicking them. Selecting a group selects everything within it.
Validation Result
After running validate on a file, its validation result will be displayed on the right.
Mapping Errors
Mapping errors are errors that result from the transformation of data from source fields to destination fields. For example, if the output of a transformation is linked to a required field, but nothing is linked to the input of that transformation, then that would result in a mapping error.
Validation Errors
Validation errors are errors that come from the destination of a mapping. An example of this is a destination field that is required, but has no value. Another example is a destination field that expects a numerical value, but recieves a text value instead.
The extent to which a destination does validation is ultimately up to the developers who implement them and may vary on a site-by-site basis.
Resolving Validation Errors
There are few tools that can be used to help resolve Validation Errors. They appear as buttons along the bottom of a Validation Error.
Override Value
This tool is used to override a value for one field of one row. The value entered here will be passed directly to the destination and not through the mapping.
View Transformed Row
Clicking this button will open a dialog displaying the row from which this value came both before and after transformation.
Skip Row
Entire rows can be skipped as well. A CSV of just skipped rows can be downloaded from the Import Result.
Comments