TnAC Access Control File Formats

Introduction

This document describes the format of the interface files used by TnAC.

WhiteList

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

• mandatory
  • barcode, event_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;event_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
  • event_id;event_name;event_code
• then
  • product_id;product_name;product_code

Checked Barcodes file

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

Example:

ORG;;5012;
24282035061813972260;2008-04-03T08:00:00