RA Ticket Scanner: Uploading external tickets

You may be using the RA Ticket Scanner to scan tickets from different ticketing outlets. This guide will show you how to prep your external ticket files and upload them into the Scanner app.

Preparing the file:
  • In order to import external tickets into the RA scanning system, you’ll need to create a spreadsheet for each separate ticketing outlet.
  • The file must be in .csv format and there must only be 3 columns - with the titles: Name, Barcode and Type
  • The column titles must contain those titles only.
Name Barcode Type
Joe Bloggs 12345678 Early bird
Jane Doe 12345678 4th release

Please note that the columns can be uploaded in any order but the titles must be as stated. 

Please check for spacing before or after the words as any additional characters or spaces in the title field can cause upload issues (including capital letters and -s at the end of the titles)

Accents or special characters in customer names can also cause files to not upload. If you are experiencing issues, try removing them.

If there’s a separate column for first name and last name in the export spreadsheet for the other ticket outlets, you’ll need to collate this into one column.

How to collate first & last names in a spreadsheet:
  1. Create a new column and input the following formula:

=B3&”(space)”&C3

Note that B3 and C3 are just random examples and represent the cell number for the first name and last name respectively

B3 = first name cell

C3 = surname cell

  1. Drag the formula down to fill in the full name for all ticket holders
  2. Create a new column to the right of the previous column
  3. Copy the name data and paste into the new column using ‘paste values only’
  4. Delete all other columns
  5. Title the remaining column ‘Name’

Once you’re left with the three columns, save this as a CSV. file which can then be imported.

Uploading into RA:

To import your pre-prepared files:

  1. Head to RA Pro
  2. Click on the event title of the event you need to upload the tickets to
  3. Go to the 'Ticket Scanner' tab and click on 'External Ticket Import'
  4. Once uploaded, you will see a list of all your external tickets below as well as an update of the number of external tickets that have been imported

If you make a mistake, you can delete individual tickets or delete all from the bottom of the page.

These tickets will then appear in the ticket scanner and can be scanned in or manually entered.

More:

If you’re an event promoter or event organiser and you still need help, go to RA Pro and login. Then use the “Help” button in the corner to contact us.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Related Articles