erpware logo

EORI Validation: XLSX import interface

With the import interface for Microsoft Excel (XLSX) file, the module EORI Validation offers you a possibility to check your entire data set from your master data.

We take care to maintain compatibility (also with Microsoft Excel) when extending the XLSX EORI interface. This means that you can always use the latest version without generating additional effort when integrating it into your ERP system.

In order to be able to uniquely assign an XLSX data record from your ERP system in the EORI Validation, 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. However, you can also leave these two fields (Key_1 and Key_2) empty.

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

Please note that all highlighted fields must be specified in the EORI import file.

The EORI Validation column header labels will be searched within the XLSX file during import and mapped during import. Please enter only one designation at a time, e.g. “key1” and not “key1,key_1”.

The upper and lower case of the column headers is not relevant for the import.

Structure — EORI XLSX Import File

Column header (1st row!) Format Example
key1 or key_1 String 4711
key2 or key_2 String 2
EORI String EN123456

Structure — EORI XLSX Export File

The XLSX export file of the EORI Validation contains the returned values of each check, also in the same data format unless otherwise specified.

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

XLSX Versions

We support all XLSX versions up to and including the latest version of Office 365 in the EORI Validation module. Please understand that we will no longer support older versions (XLS).

Our test scope for the EORI Validation module includes very many different variants of how a Microsoft Excel document can look like. Nevertheless, we could not test all functions and possibilities. If you encounter a problem when importing XLSX files, please contact us and send us one or two test data sets so that we can help you quickly.