Import participants
Importing participants takes two steps: 1) adding registrations and 2) assigning the registrations. It is only possible to import e-mail addresses and names; so it is not possible to import other personal data such as address and date of birth. See Import custom fields to add custom field values to existing registrations.
Step 1: Adding registrations
Make sure there are unassigned registrations for the participants to be imported. This can be done by adding an order with multiple tickets via the back-end, or by purchasing multiple (group) tickets via the registration form.
Step 2: Assigning registrations
Create a spreadsheet that looks like this. In the first column, place the registration numbers you can find in the export of registrations. Place the fields you want to edit in the remaining columns (first name, gender, date of birth, etc.). To assign registrations, the following columns are required: email address, first name, last name.
Registration number | Email address | First name | Last name | Date of birth |
101 | email1@atleta.cc | First name 1 | Last name 1 | 22/02/1992 |
102 | email2@atleta.cc | First name 2 | Last name 2 | 01/12/1978 |
103 | email3@atleta.cc | First name 3 | Last name 3 |
Save the spreadsheet as a CSV file. You're now ready to upload it to Atleta. Atleta will analyse the file for potential problems, and show you a summary of the results. If no problems are found, you can go ahead an finalise the import. However, if Atleta does find problems, you have two options:
Finalise the import anyway, skipping all invalid rows, and only importing the valid rows.
Go back to your spreadsheet, correct the invalid rows, and try again.
After the import is complete, you have the option to send a confirmation email.
Columns that can be imported
You can take the columns from the export registrations (regardless of language). Below is an overview of the columns that can be imported. Columns that cannot be imported are ignored. So you can re-import an export of registrations without deleting unnecessary columns first.
Column title | Example value |
Registration number | 102 |
E-mail address | email1@atleta.cc |
First name | Jan |
Last name | van Egmond |
Date of birth | 01/12/1978 |
Gender | Male |
Nationality | The Netherlands or NL |
Street | Barentszplein |
House number | 2e |
ZIP Code | 1013 NJ |
City | Amsterdam |
Country | The Netherlands or NL |
Phone | 0612345678 |
Emergency phone | +32612345678 |
