Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

If your organizer does not use S-360 to inject and manage tickets, TIXNGO provides another solution which is CSV injection to allow the organizer to inject up to 20'000 tickets at a time.

Inject tickets by CSV file

  • Get an example template

Go to CSV Injection > Click CSV template at section 02

The minimal template contains all mandatory values that you need to inject tickets successfully to TIXNGO.

The full template contains all possible values that you can provide when injecting tickets to TIXNGO.


  • Upload CSV file

Go to CSV Injection > Choose file > Submit


What you should know:

General set-up: (lightbulb)

  • CSV File Specifications:
    • Maximum tickets per CSV file: 20,000 tickets
    • The CSV file must be encoded in UTF-8.
    • All dates must follow the RFC3339 standard for date and time.

  • Template Options:
    • Minimal Required Fields Template (CSV Minimal Template): Contains the minimum required fields.
    • Complete Template (CSV Full Template): Includes all possible ticket fields to assist with CSV setup.
    • Multilingual Template (CSV Full Template for Multilingual): Supports injecting with multilingual option.
    • With these 3 templates, please exclude "injection" from the file name to avoid any error
    • When using the Multilingual option, please ensure that you save your CSV file with the suffix "-multilingual".
  • Note:
    • Instead of leaving unused columns empty, please delete them from the file. These empty cells will cause the errors of wrong formatting. 
    • When saving your CSV file using Excel, please be cautious of a common issue where quotation marks ("") may be doubled. This duplication can cause errors when uploading the file.
    • By ensuring that quotation marks are not doubled, you can prevent potential errors during the file upload process. To avoid this problem, follow these steps after saving the CSV file:
      1. Open the CSV file using a text editor or spreadsheet software.
      2. Search for any instances where quotation marks are doubled ("").
      3. Remove the duplicate quotation marks, leaving only single quotation marks (").
      4. Save the modified CSV file.

Tracking status: (tick)

  • On this page, you will find a comprehensive list of all CSV injection jobs sent by the organizer, along with their respective statuses (COMPLETED/FAILED/IN PROGRESS).
  • It is essential for organizers to review the output file to verify the actual status of each injected ticket, whether it is ACCEPTED or REJECTED
  • Both the uploaded CSV file and the output file are available for download. The output file provides detailed information about the status of injected tickets, including any associated errors in case of failures.
  • For more details on each field of the file, please check here for better understanding.

Understand each fields in CSV:

Variable NameVariable TypeValue lengthVariable usage/description
Genderstring1 charM (male), F (female), U (unknown), X (other)
First Namestring50 charSpectator's first name
Last Namestring100 charSpectator's last name
Emailstring256 charSpectator's email address
Main ApplicantstringBoolean

Indicates if the spectator is the main applicant (SecuTix) for this ticket (default false).

Ticket IDstring256 charTicket ID in the TIXNGO system (a-z|A-Z / numbers / spaces / some special characters: *.-_+/())
Barcodestring512 charPlain text ticket barcode
Sorting Keystring256 charKey used to order the tickets for the spectator following the alphabetical order.
PricenumberfloatPrice of the ticket
Currencystring20 charCurrency of the ticket's price
Categorystring512 charPurchase category (e.g. ADULT, CHILD, VIP, etc...)
Tax. Numberstring256 charPurchase taxation number
Ticket Image URLstring256 charDisplay image as per URL on following ticket views: Ticket View, Ticket Detailed View
File IDstring256 charSecuTix File ID (or any file ID that would list groups of ticket, e.g. injection file)
Event IDstring256 charEvent ID in the TIXNGO system
Event Namestring128 charName of the match
Sitestring200 charSite name displayed at the Ticket View and Ticket Detailed View under Address title
Citycity200 charCity where the event takes place
Country Codestring200 charcountry code for the address
Zipstring200 charzip code for the address
Event Image URLstring256 charDisplay image as per URL on following ticket views: My Tickets - "Group Image"
Start Timestringmust follow RFC 3339 date formatDisplays Match date and kick-off time at the Ticket View and Ticket Detailed View
Ribbon Display Timestringmust follow RFC 3339 date formatTime at which a ribbon is displayed on the mobile app to notify spectator turn on Bluetooth
Transfer Group Idstring256 charTransfer rules can technically be different for every ticket. Organizer might want to chose to have different transfer rules for different types of ticket (ex: Adult, child, VIP, etc…). This GroupID is the Transfer rules group ID representing a group of transfer rules applied to certain tickets. If Organizers want to apply the same rules to every tickets, by default this groupID is set to the EventID and every ticket will be in this group.
Max number of Ticket per receiver's PhoneintegerintegerMaximum amount of tickets per phone for this Transfer rules group id
Max Resell Price increase (in %)integersmallint

Maximum profit (price increase in %) of the original ticket price for a resell between spectator.

Max number transfer per PhoneintegerintegerTotal amount of transfers per Phone (-1 feature is disabled). Counter is increased for every new transfer, but decrease on a Return.
Max number transfer per TicketintegerintegerTotal amount of transfers per Ticket (-1 feature is disabled). Counter is increased for every new transfer, but decrease on a Return.
Assign LimitintegerintegerUpper bound amount of transfer before the Assign function is disable (-1 means unlimited)
Allow TransferBooleanBooleanEnables or Disables transfer functionality for given match (Send menu item in the ticket view hidden or displayed)
Allow Transfer after ActivationBooleanBooleanEnables or Disables transfer functionality for given match for Activated Tickets (Send menu item in the ticket view hidden or displayed)
Allow Transfer after ControlBooleanBooleanEnables or Disables transfer functionality for given match for Controlled Tickets (Send menu item in the ticket view hidden or displayed)
Allow Return To OrganizerBooleanBooleanEnables or Disable allow everyone to release ticket to resale.
Allow Return To Organizer For Initial SpectatorBooleanBooleanEnables or Disable only Initial Spectator can release ticket to resale.
Resale Group Idstring256 char

Resale rules can technically be different for every ticket. Organizer might want to chose to have different resale rules for different types of ticket (ex: Adult, child, VIP, etc…). This GroupID is the Resale rules group ID representing a group of resale rules applied to certain tickets. If Organizers want to apply the same rules to every tickets, by default this groupID is set to the EventID and every ticket will be in this group.

It is editable or used only if organizer resale setting is enabled

Allow ResellBooleanBoolean

Enables or Disables resale functionality for given match for all Tickets (Send menu item in the ticket view hidden or displayed)

It is editable or used only if organizer resale setting is enabled

Allow Resell after ActivationBooleanBoolean

Enables or Disables resale functionality for given match for ActivatedTickets (Send menu item in the ticket view hidden or displayed)

It is editable or used only if organizer resale setting is enabled

Keep one Ticket OverallBooleanBooleanForce ALL ticket wallet holders to keep at least 1 ticket per given Match
Keep one Ticket at InjectionBooleanBooleanForce ticket wallet holder to whom tickets were originally injected to keep at least 1 ticket per given Match. E.g. all his transfer guests will be able to forward all the tickets they received

string 100 char

Support organizer define the resale price with three options A, B and C per Transfer Group Id:

  • "Option A: Price range" [the resale price of this ticket is allowed by the event organizer to be resold between a minimum and a maximum]
  • "Option B: Fixed price" [the resale price of this ticket is set by the event organizer]
  • "Option C: Unlimited price" [the resale price of this ticket is allowed by the event organizer to be resold at any price]

It is editable or used only if organizer resale setting is enabled

Min resale price decreasenumberfloat

Enable when Resale option A is selected. Min resale price decrease (in % of the initial price) of the ticket to be resold

It is editable or used only if organizer resale setting is enabled

Min resale price amountnumberfloat

Enable when Resale option A is selected. Min resale price amount of the ticket to be resold

It is editable or used only if organizer resale setting is enabled

Max resale price increasenumber float

Enable when Resale option A is selected. Max resale price Increase (in % of the initial price) of the ticket to be resold

It is editable or used only if organizer resale setting is enabled

Max resale price amountnumberfloatEnable when Resale option A is selected. Max resale price amount of the ticket to be resold
Specific resale price decrease/increasenumberfloat

Enable when Resale option B is selected. Specific resale price decrease/increase (in % of the initial price) of the ticket to be resold

  • Value > 0: Increase
  • Value < 0: Decrease

It is editable or used only if organizer resale setting is enabled

Specific resale price amountnumberfloat

Enable when Resale option B is selected. Specific resale price amount of the ticket to be resold

  • Value > 0: Increase
  • Value < 0: Decrease

It is editable or used only if organizer resale setting is enabled

The Resale & Purchase Agreement URLstring512 char

The Resale & Purchase Agreement URL in P2P resale

It is editable or used only if organizer resale setting is enabled

Ticket Terms & Conditions URLstring512 char

Ticket Terms & Conditions URL in P2P resale

It is editable or used only if organizer resale setting is enabled

Activation Idstring50 charActivation group ID. Different tickets could have different activation method, this group ID make the distinction between them.
Activation TimestringDate Time RFC3339 standardActivation time at which the system will activate the ticket (display barcode)
Activation Methodstring"online"/"offline"The method using to activate the ticket. online : when activationTime is reached (backend clock), the backend activates the tickets and sends push notifications to trigger a GET /spectator/tickets on the app. offline: the mobile application activates the tickets when time is reaches (mobile clock).
Online requires the user to be online, Offline does not.
More on Ticket activation: 5-Understanding TIXNGO Activation flow
Purchase DatestringDate Time RFC3339 standardDate & time at which the ticket was bought
Main Ticket Detailsstringkey (32 char) - value (4096 char)Ticket details shown on the ticket's front (usually used to set entrance & seat details)
Extra Ticket Detailsstringkey (32 char) - value (4096 char)Ticket extra details shown on the back of the ticket (usually used to set extra information about the ticket or the event)
Hidden Ticket Detailsstringkey (32 char) - value (4096 char)Ticket hidden details (not displayed), used for different technical or business purposes, i.e. reserved key such as Seat Map, Sponsors details, etc...
Hold (only CSV injection for now)BooleanBooleanActivate ticket holder (ticket is hold for someone else)
Holder email (only CSV injection for now)string256 charTicket holder email
Holder date of birth (only CSV injection for now)stringrfc3339 standardTicket holder date of birth
Holder first name (only CSV injection for now)string50 charTicket holder first name
Holder last name (only CSV injection for now)string100 charTicket holder last name
Holder gender (only CSV injection for now)string1 charTicket holder gender (M, F or U)
Holder card numberstring200 charTicket holder ID card number
Holder nationalitystring2 charTicket holder nationality
Holder passport numberstring200 charTicket holder passport number
mobileAppIdstring256 charOptional Mobile Application App Id to use associated invitation email template (used by organizer using their own app or branded apps).
langstring5 char ISO 639‑1 formatThe default language for the Ticket. Injection communications will be sent in this language. Example: fr, en, de, it, es
Design Idstring256 charThis Design Id representing a design applied to certain tickets in an Event
Background Colorstring7 char hexadecimal colorThe background color of the Ticket and the corresponding Design Id (If the Design Id is set). Example: #bbccdd
  • No labels