General requirements
File format:.csv or .txt
Field separator: ; (recommended), may also be
different String separator: “ (double quotation marks)
Character encoding: UTF-8
File name
The file name is irrelevant from version 2.0 onwards, as all necessary information is transmitted within the file.
File structure and record structure
The CSV file must have the following row format:
Line 1: Column headers (see ‘Description’ field in the table below)
Line 2: Record 1
Line 3: Record 2
Line 4: …
The individual data records must be separated by line breaks.
The first line contains the column headers, which are defined in the ‘Description’ column of the table below.
All fields within a data record must be separated by the configured separator (recommended: semicolon).
If the defined separator is used within a field, the “string separator” (double-quotation marks) must be used for that field.
The column order and number of columns is identical for every data record (i.e. if a field has no value, it is transmitted as an empty field).
The sync tool
To upload the CSV file to the portal, you will need the synchronisation tool. This is a small tool that monitors a folder. As soon as a file is saved, it is encrypted and uploaded to the portal.
When you install the synchronisation tool, you will be asked for the ServiceUser and ServiceUserPassword at the start of the installation. You must enter the details generated in the portal beforehand. You will also need to generate an API token once. However, you do not need to enter this.
Once the installation is complete, you must specify the Careflex ID and the paths to the folders where the CSV files are stored in the configuration file.
Installation
The installation file can be downloaded using the following login details. It cannot be opened in a web browser, but only using an SFTP-compatible programme, such as FileZilla or WinSCP.
Host: data4.n4group.eu
Username: u245801-sub16
Password: VIo622ebY1vmKU4o
It makes sense to install this on a server, e.g. in a DMZ, so that more than one person has access to it. However, the tool can also be configured to retrieve data from a shared folder on a network drive. In that case, only the relevant staff members need access to it.
Only one file can run at a time, so either a production installation or a staging version for the test portal (the other must then be uninstalled).
Firewall
If necessary, the following entries must be whitelisted in your firewall:
For staging:
careflex-staging-xfiles.de-hamburg-4.s3.xws.x-ion.de
staging.unternehmen.careflexchemie.de
Port 443
For production:
careflex-production-xfiles.de-hamburg-4.s3.xws.x-ion.de
unternehmen.careflexchemie.de
Port 443
