Generic file format (Extended)
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€ 3450 means 34.50$ |
Percentage | The percentage must be given in 100ths of percents. No decimal separator. | 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. |
|
Enum | Valid value in upper case. OPERATION_TYPE: SALE/RESERVATION TICKET_STATE: NOT_PRINTED/PRINTED/CONTROLLED |
|
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: Physical configuration/Area/Block/Row/Number. All are in code.
| Have all info: Away/Loges/Cour/B/64 Without block: Away/Loges//B/64 Unnumbered area: Away/Loges |