How to use Validation rules during import

By using Validation rules during import you can validate the correctness of incoming data

Prerequisite: This tutorial assumes you know the basics of the import feature. If this is not the case you can learn the basics in other guides here: How to use import The tools this tutorial goes through are all found on the data mapping page of import

Validation rules

When importing Text attributes you can choose to add validation rules on the incoming values.

You can add these validation rules on a column by column basis. If you wish to add a validation rule to a column you can click the 'Validation Rules (0)' text to the right of the data mapping.

Data mapping during import

Clicking the 'Validation Rules (0)' text will open a new tab. In this tab you can add one or more validation rules to the specified attribute.

Your first choice is the kind of Validation mode you wish to use. You have two choices:

• Error - If validation rule does not hold for a row, it will show in the change cell and the attribute will be ignored during import
• Warning - If validation rule does not hold for a row, a warning will be shown in that change cell.

This choice will determine how the system tells you a validation rule does not hold for a row.

Validation rule will warn if incoming text length is not less than 5

Next choice is the Validation type you wish to use. Once again you have two choices:

• Textstring length - How many symbols are in the text.

• Regular expression - If a regex pattern matches

Third you choose the condition, the condition will depend on the Validation type.

Having succesfully created a rule you can choose to add another rule to the column or click the green "Update rules"-button in the bottom-left corner.

Warning & Error

Underneath is shown images of what it looks like if a Validation rule does not hold for warning and error respectively:

Left: Warning, Right: Error