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:
- Select Compliance Screening – File check.
- Open an erroneous file check with the icon.
- In the Check result field group, click Show error details.
- For a look at the details: Click the Error analysisbutton.
- In the table, trace each error and adjust your file accordingly.
- The icon is shown in any line containing an error. If you highlight the line, an error description appears in the field below.
- 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/.
- Format checks are not included in the calculation of the address checks by AEB, therefore a prior format check is recommended.
The 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.
- The character set does not match the check settings for this file check: Correct the character set in the check settings of the affected file check.
- “ISO-8859-1” is equivalent to “ANSI”.
- “UTF-8” is not identical to “UTF-8-BOM”.