How to generate a pdf/send tickets mails using an excel file
The steps for generating a pdf/sending of ticket mails using an excel file are:
-
Create an event.
-
Create a category of ticket.
-
On the detail page of the ticket category, there is an option that says 'Upload excel file', click on that link.
-
Select the option 'Generate and send by email the tickets'.
-
Upload the excel file to the platform. This file to upload must follow a certain structure, so it is necessary to download the template.
Download the excel template from this link, fill in the fields at your convenience, upload the excel.
Remember that you can include in the QR column the texts that you want to show in the QR, although keep in mind that if you fill that column, there may be problems if validated with our app, by not assigning bikubo automatically the locators of the QRs.
The column observations of the excel file, it serves so that what is written there, is shown in the validation. For example, if for an attendee it is put as an observation 'Notify organization when it is validated', this message will be shown in the validator of our app.
The fields Name and ID of the excel, you can fill in regardless of whether to register the event, have requested to require Name / ID, saved in database, and also serve for searches in the list of attendees.
You will be able to generate and send at most the number of tickets that you have available as electronic credit balance available. After the generation and sending, the tickets generated are available in the 'list of PDFs' jointly, and individually in the 'Attendant list'. If you need more tickets, you can buy them.
The system will perform a series of checks, which can show you warnings (which allow you to progress although it is advised to correct them if necessary), errors (the system would not let you move forward and you should correct them) or if everything is correct.
-
To view the pdf, click on Menu => Events => Active => Title of the event in question => List of category tickets => Ticket in question (option - PDF list). There the download link is displayed.
From bikubo we control the number of times that the rar files containing the pdf are downloaded, and the time of availability of the rar, to optimize the traffic and performance of the systems. We advise you to keep the pdf in a safe place. For any problem in this aspect you can send an email to admin@bikubo.com.
The shipment and generation that takes place with this process, gives as exit tickets taken to size of format A4, so that the attendees can print them.