erpware logo

Duplicate Check: XLSX import interface

With the import interface for Microsoft Excel (XLSX) file, the module Duplicate Check 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 duplicate 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 Duplicate Check, 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) blank.

The designations of the column headers of the duplicate check are searched for within the XLSX file during import and assigned during import. Please enter only one name 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 - Duplicate Check XLSX Import File

field format example
key1 String
key2 String
firstname String
lastname String
name1 String
name2 String
name3 String
name4 String
street String
number String
postcode String
town String
department String
country String

Structure - Duplicate Check XLSX Export File

The XLSX export file of the Duplicate Check contains the returned values of the individual checks, also in the same data format unless otherwise specified.

field format example
internalid String
key1 String
key2 String
firstname String
lastname String
name1 String
name2 String
name3 String
name4 String
street String
number String
postcode String
town String
department String
country String
// cleaned data
cleaned firstname String
cleaned lastname String
cleaned name1 String
cleaned name2 String
cleaned name3 String
cleaned name4 String
cleaned street String
cleaned number String
cleaned postcode String
cleaned town String
cleaned department String
cleaned country String
// applied cleaners
applied cleaners String
// applied duplicates
duplicate ids String
address group String

XLSX versions

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

Our test scope for the duplicate check 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.