How to import attendees
While Workshop Butler provides full-featured customisable registration pages for events, there are many reasons why you may use other tools to gather info about the participants of your events. To simplify the process of adding the attendees manually, you can import them.
There are two ways to start importing attendees. You can either click on the Import from CSV file link right on the Attendees tile or push the Import button on the list of event attendees.
Important note: You cannot import attendees to archived or canceled events
Now it is time to upload a CSV file. There are two requirements for an uploading file:
- the first line should contain the name of columns;
- the columns should be separated by commas (,). Other separators are not supported.
You can use this file as a reference when creating your own list: example.csv
When the file is uploaded, you can match the columns. Each record must contain at least three columns: first name, last name, and email. All other attributes are optional. Workshop Butler tries to match these columns automatically. You need to match other columns manually.
Hint: Use a keyboard for faster matching.You can match data to both system attributes (Country, VAT Number, Phone) and custom attributes from registration forms.
Only a few rules apply to the input data:
- first name and last name must not be empty
- email must have a correct format
- country (for home, work, and billing addresses) must be either a two-letter country code or a valid country name in English. Letter capitalization doesn’t matter. The platform sees DE, de, Germany, germany, GERMANY as equals.
It is possible to import ticket data. For that, you need to add ticket types to an event first. Records in the CSV file should contain price without currency.
For example, you added a Regular ticket type for $1300. A Ticket column in CSV must be 1300 for a successful import.
The platform is clever enough to understand that 1300 and 1300.00 are equal numbers.
The platform automatically detects which ticket type should be assigned to which attendee. If you have several ticket types, and import attendees with different paid amounts, Workshop Butler handles it.
If it is not possible to identify, what ticket type should be assigned to an attendee, the price is recorded as a Custom amount.
By checking related flags, you can set additional attributes for all imported attendees. These include:
- participation status
- paid status
If it’s possible to generate certificates for an event, a checkbox Generate certificates for all attendees appears. If checked, the platform generates and sends certificates along with a post-event message to each imported attendee.
Important note: Generation of certificates may take some time. If you import the attendees and see no certificates along with their names in the list of attendees – do not worry. Give it a few seconds and refresh the page.
The system does not send a welcome email to imported attendees. To send a welcome email to them, put a checkmark next to Send a welcome email to the attendees.
Do not forget to click the Import button for initiating the process of importing attendees.