How to bulk upload sold tickets

Overview

This article serves as a guide for club admins on how they can bulk upload physical tickets sold to Foireann for the National Club Draw.  

---

Table of Contents

• Bulk uploading tickets

---

Bulk uploading tickets

1. Log into your Foireann account and navigate to the 'Administration' section on the left-side menu.

2. Go to the 'Draws' tab.

3. You will see a list of the active draws taking place in your club.  Click on the 'Manage Draw' button.

4. Click the 'Get template file' button and a . CSV file will start downloading to your device.

Note: if the file doesn't start downloading automatically you may need to change your browser settings

 

Below is an example of how you should layout your bulk upload file

ticket_number	This should match the 'Ticket Number' column on your allocated ticket.  For example, in the screenshot of Foireann above the first ticket number starts at 12000, so you should match the number from the physical ticket sold and add it to your bulk file for the status to update on Foireann
name	The name of the person who purchased the ticket
street_address	The ticket owner's address
telephone	The contact number of the ticket owner.  This should be formatted as a number and begin with your area code e.g. 353 or 44, dropping any 0's from the start of the number
purchase_date	The date the ticket was purchased in the format of DD/MM/YYYY

5. When your. CSV is ready for upload return to Foireann, click on the 'Upload' button and submit your file.

6. Another .CSV file will automatically download to your device to show you the status of each of the records added to the bulk upload.  If any of the records have a 'FAILED' status an error message will appear for that record in the errors column.  For example, 'ticket_number not found' if the ticket number entered does not match with any of the ticket numbers allocated to your club.

7. You will then be able to see the newly added details to the tickets you uploaded.