Page tree

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 typeFormat and valuesExample
DateDD.MM.YYYY or YYYY-MM-DD01.08.1965 or 1965-08-01
TimestampDD.MM.YYYY HH24:MI:SS or YYYY-MM-DD HH24:MI:SS01.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


BooleanTRUE/FALSE

TRUE

FALSE

CodeText, max length 8 charactersPERFO123
Number

Digits only.

No decimal separator.

No thousands separator.

1234582
CodeValueCode=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

  • No labels