CSV Injection

If your organizer does not use S-360 to inject and manage all or part of an event tickets, TIXNGO supports injecting tickets by uploading a CSV file in Backoffice.

TIXNGO V4

Open

TIXNGO V4 new CSV injection screen

Steps by step

1. Use the provided CSV template if need (click on the this CSV template link)

2. Fill the CSV with your ticket data. Please be sure that your file comply with the following constraints:

   1. The CSV file must be encoded in UTF-8.

   2. All dates must follow the RFC3339 standard for date and time.

   3. No more than 100’000 tickets can be imported at once

   4. Event(s) referenced must already exists in TIXNGO (use manual creation screen if needed before uploading)

   5. Please refrain from including "injection" in the file name

3. Upload CSV file

4. Submit

5. Check the result in the table. Possible status are:

   • In progress TIXNGO is currently processing the file you upload. Give it a bit of time and refresh the page later.

   • completed All tickets have been injected successfully. Good job! You can the download the output file for tracking purposes.

   • partial Some tickets have been injected successfully, but at least one failed. --> Please download the output and review the errors.

   • Failed Not a single tickets could be injected. Something most probably wrong with the format or data in your file. → Please download the output and review the errors. Make sure to use the provided template and check the Troubleshooting section below.

Troubleshooting & detailed information

Typical errors

In case of errors, please check out some points below:

• The CSV file must be encoded in UTF-8 to make sure your data format is valid

• Instead of leaving unused columns empty, please delete them from the file. These empty cells could cause 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.

Fields detailed documentation

TIXNGO V3 deprecated

Inject tickets by CSV file

• Get an example template

• Upload CSV file

Open

What you should know:

General set-up:

• 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".

• If you failed to inject your CSV file, check out some points below to figure out what's the rootcause:
  
  

  • The CSV file must be encoded in UTF-8 to make sure your data format is valid

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

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

More details