Published — v. 13
/
Generic file format (Extended)
Generic file format (Extended)
File format
Extended import files can be delivered in one of following formats:
- Excel 2013 ++ file
- The formattiText 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 te | |
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 |
, multiple selections available,
Related content
Single Entry import file formats
Single Entry import file formats
More like this
Contact import Format (Extended)
Contact import Format (Extended)
Read with this
Contact credit note balance import file formats
Contact credit note balance import file formats
More like this
Membership import file formats
Membership import file formats
Read with this
Season Ticket file formats
Season Ticket file formats
More like this