Page History

...

This document describes the format of the interface files used by TnAC, the native Access Control module of SecuTix.

Files are CSV, semi-colon  separated.

WhiteList

barcode;eventseason_code;product_code;category_id;reduced_price;is_specimen;validity_date;tag

• mandatory
  • barcode, eventseason_code, product_code
• optional
  • all others
• reduced_price, is_specimen: TRUE or FALSE
• validity_date: empty or yyyy-mm-dd hh:mm:ss
• tag: empty or String
• category_id: 0 (always)

BlackList

barcode;reason;eventseason_code;product_code;blacklist_date

...

• mandatory
  • all
• reason:
  • CANCELLED
  • TECHNICAL
  • STOLEN
  • blacklist_date: yyyy-mm-dd hh:mm:ss (can be empty)

...

Definition file

• first row
  • eventseason_id;eventseason_name;eventseason_code
• then
  • product_id;product_name;product_code

...

• first row
  • organizer_code;;eventproduct_code;
  • field 2 = season (empty)
  • field 4 = representation (empty)
• then
  • barcode;date;
  • date format is yyyy-MM-dd'T'HH:mm:ss

...