In this window, you create a link between the fields found in the import file (left) and the fields available in your Database Application Pro 7 database (right). After linking an import field (left) to a database field (right), a data validation is performed, it checks whether the data you want to import does match the required data type of the database field (right). This prevents invalid data from entering your database.

Only one import field (left) can be linked to each field in your database (right). However, it is possible to link an import field (left) to multiple database fields (right) as long as the data validation succeeds.

It is only possible to start the actual import when there are no validation errors.

In case the data validation fails, you will see a line in the result window for each failed validation field. This will specifically name which data cannot be converted to the desired data type. This provides you with a handle to correct the data to be imported.

When importing, each line is converted to a new entity by default, unless a link has been made to the Id database field (right). The Id database field (right) is a special field, this field contains the entity's internal database id. By attaching an import field (left) to this, there are two options when importing a data line:

• If the id already exists in the database, the linked fields of this existing entity are updated when importing.
• If the id does not yet exist, a new entity is created, and the specified id is ignored.

This function allows you to update your entities with the imported data.