/
TnAC Access Control File Formats

TnAC Access Control File Formats

Oct 10, 2023

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, without header.

WhiteList

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)

 

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)

 

 

 

Below are deprecated files.

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