Finding file check errors

The file check may result in errors if the imported file does not match the formatting specifications outlined in the interface description. In the file check, the icon will then be displayed next to the check result. This icon also appears in the Error column of the File check overview. You will also be informed about such an error by e-mail.

• Erroneous data records cannot be checked, so they are skipped.

Proceed as follows to display the details of an error:

1. Select Compliance Screening – File check.
2. Open an erroneous file check with the icon.
3. In the Check result field group, click Show error details.

• You will find the formatting specifications in the interface description, which you can download from the service portal at https://service.aeb.de/en/downloads/.

If the information displayed here does not help you, run a format check.

Proceed as follows to run a format check:

1. Select Compliance Screening – File check.
2. Select an erroneous file check and click Format check at the top.
3. Click the Import button.
   • The Number of addresses and the Error count are displayed.
4. In the table, you can review the individual errors and modify your file accordingly. Here you can view all the fields of the file.
5. The icon is shown in any line containing an error. If you highlight the line, an error description appears in the field below.
6. An address record with too few fields produces an error. The empty columns are displayed with a question mark ? in the table.

• Format checks are not included in the calculation of the address checks by AEB, therefore a prior format check is recommended.

The three most common errors during file checks

• Invalid number of columns: The columns to be checked are separated by a field delimiter (a semicolon by default). Make sure that the correct number of columns is available.
• Country code is either wrong or missing: Store the respective country code in the line as a two-character ISO code, for example, DE, US, AT.
• Name is missing: Enter the name in the file to be imported.