Automatic data import

Introduction

We of course support automated data import – it is the only way to reduce the effort of sanctions list and PEP screening to a minimum while still fully meeting your legal obligations. Two approaches have proven themselves in practice: using our API, which lends itself particularly well to online shops (see also the API documentation), and the automatic import of CSV files (more on how the CSV file should be structured / OWASP compliance), which is described below.

Scenario

You use an ERP, CRM or other business system and want to automate the upload of the CSV files, so that nobody has to keep your records in easycompliance up to date by hand.

How it works

First, make sure your software supports the automated export of CSV files. This is a basic feature of every common solution, or can at least be added afterwards via what is usually called workflows or batch runs. Save the generated CSV file wherever you like. What matters is that the file always keeps the same name and that the name contains no timestamp or similar. You can of course generate several CSV files, for example "private-customers.csv", "business-customers.csv" and "suppliers.csv". If you would like to use automatic import, please contact our customer service – they will provide your credentials and set the automatic import up for you.

Providing the file via FTPS

The generated CSV file is then uploaded to an online storage location every evening. You get access to it via FTPS, because we collect the CSV files from there automatically every night and start the import. A direct automatic import into easycompliance is not possible, and neither is us collecting the files from one of your own servers.

The easiest route is probably an automated upload using the free tool WinSCP. Every administrator knows this program, and automating file uploads with it takes only a few minutes (described by WinSCP themselves, or see below for our ready-made example configuration). You are of course free to use a different tool. Some ERP systems – particularly cloud-based ones – can even transfer the files they generate themselves.

IMPORTANT: Please upload your files by 10 p.m. (CET/CEST) so that they can still be picked up by the next import run. Otherwise they will be delayed by one day.

A note on ports and firewalls

Please make sure that ports 40000:40099 are open in your firewall, as the secure connection between you and us is handled over these ports. Also make sure your firewall does not block outbound connections.

For security reasons we use several firewalls and proxies, so it can happen that you are unable to establish an FTPS connection to us at first. In that case please contact our customer service and let us know the IP address you transfer the data from. We will then unblock that IP manually.

Automating the upload with WinSCP

We have prepared ready-made scripts for you. All you have to do is enter the FTPS credentials you received from our customer service and specify the folder on your server that holds the files to be uploaded.

Downloading the scripts and the instructions

You can download the scripts as a ZIP archive here: Go to download

The ZIP archive contains the following files:

Related articles

• Structuring the CSV files for import
• Automatic import (set up by customer service)

Last reviewed: 2026-07-27