TnAC Access Control File Formats

This document describes the format o TnAC, the native Access Control module of SecuTix.

Files are CSV, semi-colon  separated, without header.

barcode;season_code;product_code;category_id;reduced_price;is_specimen;validity_date;tag;entranceBarcodeId

• 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)

• entranceBarcodeId: empty or ID (is using Marketplace with EntranceID)

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)

• first row

  • season_id;season_name;season_code

• then

  • product_id;product_name;product_code

• 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