EORI Validation: CSV Import Interface

We recommend using the XLSX or JSON import interfaces.

By using a simple CSV file, the “EORI Validation” module provides you with a way to check your entire data set.

We take care to maintain compatibility when extending the CSV import interface of the EORI Validation module. This means that you can always use the latest version without generating additional effort when integrating it into your ERP system.

In order to guarantee the affiliation of the individual EORI data records in your master data, you have the option of specifying up to two unique keys in the import file. These will be returned in the export file and can be used for re-import into your ERP system. You can also leave these two fields (Key_1 and Key_2) blank.

The default separator of the individual elements for the EORI Validation is the ‘|’ character (pipe). This can be changed via the settings. Bold field names are mandatory fields (the separator can be changed via settings).

Since the EORI interface also returns the name and address, we will also enable a check of your stored data and extend the CSV interface in a future release of the EORI Validation.

Please note that all fields must be specified in the import file of the EORI Validation, even if you do not use Key_1 and Key_2.

Structure — EORI CSV Import File

Field Format Example
Key_1 String 4711
Key_2 String 2
EORI String EN123456

Example in the form of a CSV file: 4711|2|EN123456… (further EORI Validations)

Note

When creating the EORI import file, please pay attention to the correct number of columns (3 columns). This note is important for possible errors during import when using CSV. In the future we will support other import formats that do not have this restriction.

Structure — EORI CSV Export File

The EORI Validation CSV export file contains the returned values of each validation.

Key Format Example
key1 String 4711
key2 String 2
eori String DE123456
name String Sample Company
address String
street String Samplestreet 1
postalCode String 12345
city String Village of Samples
country String Germany
status String 0
statusDescr String Valid
errorReason String
requestdate String

Example in the form of a CSV file (with standard delimiter):

4711|2|EN123456|Sample Company||Sample Street 1|12345|Sample Village|Germany|0|Valid||

The naming of the fields of the EORI Validation within the CSV import or export file is done in German language. In the course of the extension of the import formats, these will be internationalized, i.e. we will keep the field names in English in the future. However, we have considered a configuration of the field names in order to increase flexibility.

The output of the export file in CSV format of the EORI Validation always includes an additional column containing the headings. Please take this into account in case of a possible automatic re-import of the check results.