erpware logo

EORI Validation: Processing settings

You have the possibility to define some settings for the EORI Validation on the tab card. These will be taken into account during processing. These settings are described in detail below.

ID Validation Settings EORI Number Processing

Attempts

Via the entered value of the attempts you have the possibility to set the number of retries of a check. A retry can be triggered if the remote station of the EOS is busy or your network connection leads to a timeout. Each attempt, if enabled, is stored in the audit log.

Delimiter

The separator is only relevant for the import of CSV files for the EORI Validation (regardless of whether batch processing or background processing). The data is split into individual values based on this separator and prepared for checking. Please consider when setting the separator to an occurrence in your master data. A comma or a semicolon can possibly occur in a company name and lead to an error in the processing. We have defined the pipe character “|” as default. For JSON and XLSX this separator is not necessary.

Spaces

If blanks are allowed in your master data when entering EORI numbers, this can lead to errors during the check. This setting gives you the possibility that these are ignored during the check.

case-sensitive

If the entry of lower case letters is allowed in your master data when entering EORI numbers, this can lead to errors during the check. This setting gives you the possibility that during the check the upper and lower case letters are ignored and set to the correct format automatically.

Clean EORI Number

If this option is set, the cleaned EORI number (spaces, upper and lower case) will be returned in the export file. This means that in log files (these have the same structure as the imported CSV file) the EORI number is output without this incorrect spelling. When re-importing into your ERP system, the data record can thus be cleaned up.

Character encoding of the output

With this setting you have the possibility to control the code page of the CSV output of the EORI Validation. UTF-8 is specified here by default. If the CSV file is further processed with Microsoft Excel, it is recommended to use Win1252 (this corresponds to the ANSI coding).

If the data records in the output file of the EORI Validation are not displayed correctly in your text editor or in Microsoft Excel, for example with umlauts, please also set this parameter to a different one than the one currently set for you. This solves display problems in most cases.