File format
Extended import files can be delivered in one of following formats:
- Excel 2013 ++ file
- The formatting of the cells must be adapted to the format described hereunder. For example, phone numbers are given a Text values and the excel cell should therefore be formatted as Text and not as a Number or as General (Loss of leading zeros).
- CSV file
- End of line: LF (0x0a) or CR-LF (0x0d 0x0a)
- Fields are separated with semi-colon ( ; ), tabulator (0x09) or pipe ( | )
- Fields are optionally enclosed with double-quotes ( " ), except if the separator is a tabulator.
- File encoding: UTF-8 without BOM or UNICODE
File contents
- Each column represents one field
- The first row of each file contains the field codes
- The values are case sensitive (upper/lower case) and accent sensitive.
- The values must be formatted as described in the table hereunder.
Field formats
| Data type | Format and values | Example |
|---|---|---|
| Date | DD.MM.YYYY or YYYY-MM-DD | 01.08.1965 or 1965-08-01 |
| Timestamp | DD.MM.YYYY HH24:MI:SS or YYYY-MM-DD HH24:MI:SS | 01.08.1965 11:34:56 or 1965-08-01 11:34:56 |
| Amount | The amount must be defined in 100ths of units. No decimal separator No thousands separator | 12000 means 120.00€ |
| Percentage | The percentage must be given in 100ths of percents | 1960 means 19.6% |
| Text | Free text. The optionally indicated number is the maximum length of the text. By default, the maximum length is 2'000 characters. | |
| Boolean | TRUE/FALSE | TRUE FALSE |
| Code | Text, max length 8 characters | PERFO123 |
| Number | Digits only. No decimal separator. No thousands separator. | 1234582 |
| CodeValue | Code=Value couple. | SOURCE=MYFILE |
| SeatNumber | String describing uniquely a seat: Area / Block / Row / Number | Orchestre//P/17 Loges/Cour/B/64 2emeBalcon//A/45B |