This guide will help you understand how to best specify data—email addresses, phone number, and variable information—in CSV/Excel for best results.
This article is relevant to you if you're planning to generate and send tickets, and additionally, need unique information on each ticket.
Ticket Generator allows you to do this in two ways—uploading a CSV/MS-Excel data file OR enter data directly in a data table.
In this article, we share the best practices on how to create and prepare the data file (CSV/MS-Excel).
Firstly, you can get started by creating a new data sheet (CSV, MS-Excel) in a spreadsheet editor such as Google Sheets (Online), MS-Excel (Windows, Mac), Numbers (Mac) or LibreOffice Calc (Linux).
Or simply, you can download a sample sheet from the website (that is already in the correct format) and modify it.
When working on the data sheet, enter the required information in the following format:
Column A: In this column, specify email addresses of the ticket recipients. One email address in each row. Ensure that Column Header (Cell A1) is "Email ID"
- Column B (Optional): Specify the phone number on which you want to send the ticket. Tickets can be sent either through SMS or WhatsApp. One phone number should be present in each row. Ensure that Column Header (Cell B1) is 'Phone Number'
- Note that you have to always provide either email or the phone number for Generate & Send feature
- Column C-G (Optional): You can optionally use these columns to specify unique information that will go on the ticket of the specified recipient in Column A, or Column B.
Use these five columns (max) to share unique information such as: Seat Number (e.g., 1, 2, 3, 4, 5), Row Number (e.g., A, B, C, D), Section (e.g., Silver, Gold, Platinum), Ticket Price (e.g., USD 100, EUR 50), Hall/Auditorium (e.g. Audi 1, Hall 5)
For example, if the data in the CSV/MS-Excel is:
the data on the ticket that will be sent to email@example.com will be printed as follows:
You can use Columns C-G (in case a phone number is added in column B) to provide upto 5 data-points. This means if your CSV/MS-Excel has more than 7 columns (incl. column A, column B), data of 8th column onwards will be ignored.
Note that the total number of characters for Columns C-G are limited. To avoid header text or data text from being truncated, ensure that number of characters are limited. For example, if you are using only 1 column, you can specify upto 70 characters. If you're using 2 columns, each column data should not be more than 32 characters. And so on. For best results, keep in the number of characters in the range given below:
1 Column: 1-70 characters per column
2 Columns: 1-32 characters per column
3 Columns: 1-19 characters per column
4 Columns: 1-13 characters per column
5 Columns: 1-10 characters per column
Note that at no point should the total number of characters (sum of all columns text i.e. B-F) should be greater than 70 characters. This will ensure that the information on the ticket is clearly printed and visible.
If you're not certain, always check the ticket preview before proceeding to generate the tickets.
Once you've finalized your CSV/Excel sheet, follow the steps given below:
Login to your Ticket Generator account
Select an existing event from drop-down. If you don't have one, click on Create New Event and enter event details
Customize the design of ticket as per your requirements and click on Generate & Send
Click on Upload Data File and upload your CSV/Excel file. Note that the data you upload will be available for review and modification in the data table
Enter information in Email Content, and SMS Content fields
After specifying and reviewing all fields, click on Generate
If you still have questions related to this topic, please feel free to reach out to the customer relations team at firstname.lastname@example.org.