CSV file properties with personal data for import:
> The first row is always ignored. For this reason, we recommend you enter the field
names in this row to make identification of the remaining data easier. You can also
leave the first row empty. However, it must not contain personal data because that
would then not be imported.
> Empty rows or rows featuring spaces and tab stops (blanks) only are also ignored.
Consequently, you can leave any number of blanks if you would like to add more
transparency to your CSV file.
> Each file must feature all 13 fields (attributes) shown in Figure 30.
> Fields are each separated by a semicolon.
> There are a mere three mandatory fields: first name (field 1), last name (field 2) and
language for correspondence (field 12).
> If the remaining fields do not feature data, they must still be available as empty fields
(;;).
> The gender (field 4) must exclusively contain M (for male) or F (for female) or be left
empty. This applies to all languages and M and F must be used in capital letters only.
> Enter the date of birth (field 5) in YYYY-MM-DD format (e.g. 1997-12-20).
> The e-mail address (field 6) must contain the @ character including other characters
or be empty.
> The country for the address (field 10) must contain the 3-digit ISO 3166-1 code
(ALPHA-3 column) of the corresponding country or be left empty. Enter the code in
capitals only. Examples: AUT, DEU, GBR, NLD, SWE, FRA, ITA, ESP, PRT, CZE, SVK,
POL, etc.
> The field to specify the language for correspondence (field 12) is a mandatory field
and must feature the ISO code for the language. Keep to the exact spelling with
upper/lower-case letters. Only the following codes are accepted: cs-CZ, de-DE, en-
UK, es-ES, fr-FR, it-IT, nl-NL, pl-PL, pt-PT, sk-SK, sv-SE.
> A person to be imported is shown as a person that is already available ( icon) if the
first name + last name + ID (fields 1-3) combination already exists in the AirKey
Online Administration, even if the remaining fields (fields 4-13) are different. These
persons are not imported. Please note that the names are case insensitive (e.g.
"Danny;DeVito;DD" and "Danny;deVito;Dd" are considered the same person and
only the first person will be imported).
> Persons are interpreted as duplicates within the CSV file if the combination of first
name + last name + ID (fields 1-3) already exists once, even if the remaining fields
(fields 4-13) are different. In this case, merely the first row is shown with a certain
combination before it is imported. Any further duplicates are ignored and not shown
in the table of persons to be imported.
> A CSV file may contain the data of max. 10,000 persons. If you want to import more
persons, create several CSV files that you can import separately.
> Faulty rows in the CSV file are highlighted by the icon and added to the tool tip
that describes all errors prior to import. These rows are not imported.
To Next Page
Loading...