Contents Previous Next

Customer data import

Here you can import customer data from other applications. Customer data are: Customer-ID, Name, Birthday, Sex, Address, etc.. The common CSV table format is used as file format.

For a successful data import you have to assign the fields of the customer database to the columns of the CSV file. Therefore the following dialogue appears after opening the import file:

A preview of the first 5 lines of the CSV import file will be displayed in the upper part of the dialogue. Normally the first line contains the column titles. In the lower part of the dialogue these import columns will be assigned to the fields of the database (DB-Column). An asterisk behind the field name points out, that this column is not allowed to be empty. The Customer-ID has to be always unique over the whole database, because it is used as primary key. In the column "Import format" can be defined a mask for encoding for all data and time fields.

In case you might often use the import function you can save all the settings in this dialogue over the key "Profile Save" as a ini-file. This profile can be opened later instead of the import file.


Contents Previous Next