View Source

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

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