TnAC Access Control File Formats

Introduction

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;season_code;product_code;category_id;reduced_price;is_specimen;validity_date;tag

• mandatory
  • barcode, season_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;season_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
  • season_id;season_name;season_code
• then
  • product_id;product_name;product_code

Checked Barcodes file

• first row
  • organizer_code;;product_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