Navigation:  Recipients - Managing customer data > Import function for recipient data > The import assistant >

Error handling

Previous pageReturn to chapter overviewNext page

In principle, two kinds of error can occur when importing CSV files into the database:

The import profile chosen does not match the CSV file.
The CSV file contains errors.

If the Assistant does not even display the first lines of the CSV file as a preview, the import file chosen does not match the CSV file. This can occur when no information on the column names or on the key column is noted in the import profile. OpenEMM therefore indicates an error and switches directly to the input mask of the selected import profile for correction.

Fig. 4.21: The Assistant reports an error when importing recipient data. The import profile chosen does not match the CSV file.

Fig. 4.21: The Assistant reports an error when importing recipient data. The import profile chosen does not match the CSV file.

Now switch to the Manage columns tab. You can there see that OpenEMM has already read out the column names of  your CSV file and added the import profile as a CSV column. Assign the CSV columns whose information that you want to import – at a minimum the key column – to a database name and accept the changes with Save. Then click on the submenu Import in the navigation bar, again select your import profile and restart the Assistant via Proceed.

In the second case – the CSV file contains errors – OpenEMM does not switch to the import profile but remains directly in the Assistant. After clicking on the Start import button in the import preview, the system carries out a search for errors. This includes a search for erroneous e-mail addresses and wrong numerical values. If discrepancies occur, the system announces those found on the following page, for example with the following output:

Fig. 4.22: OpenEMM has discovered an error in the CSV file. In this example, the key field with the email address is missing for one of the recipients.

Fig. 4.22: OpenEMM has discovered an error in the CSV file. In this example, the key field with the email address is missing for one of the recipients.

OpenEMM highlights CSV fields containing wrong information in yellow, and requests that you enter the correct data. The corrected information is accepted with Save. The search for errors is subsequently restarted to check your corrections. Alternatively, you can Ignore errors found. The erroneous information is then not imported.

If in the import profile you have given an email address in the field Email for report, OpenEMM sends a message that can contain the following information:

A CSV file containing the found and corrected errors A CSV file corresponding to the figure above would consist of two lines. The first line contains individual categories such as gender, last name and email address; the second line contains the data record for the recipient that has the wrong email address.
A CSV file with the wrong lines that were not imported.
A report containing import statistics.