Adding Event Participants with CSV files

Adding Event Participants with CSV files

The uploaded CSV file should be UTF-8 encoded, and the fields must be delimited by either a comma (,) or a semicolon (;). The first record of the CSV file should be the header, containing a list of field names. Currently the list of supported field names are the following:

Field name
Description
emailAddress
The participant's email address. This value is displayed in the event's participants list under Email and is used in login forms as the email address.
firstName
The participant's first name. This value is displayed in the event's participants list under 'First Name'.
lastName
The participant's last name. This value is displayed in the event's participants list under 'Last Name'.
company
The participant's company. This value is displayed in the event's participants list under 'Company'.
password
The participant's password used to access the event if an appropriate access control method is set using a viable login form.

Here is a sample in CSV form with all of the above fields names defined on the first row.

  1. emailAddress,password,firstName,lastName,company
  2. test.user@icareus.com,password,Test,User,Icareus
  3. another.user@icareus.com,password,Another,User,Icareus
The above CSV would create the following users to the event it is uploaded to:

Email
First Name
Last Name
Company
Password
Test
User
Icareus
password
Another
User
Icareus
password

Wildcards in emailAddress field

It is also possible to enter a wildcard value to the emailAddress field in the CSV. This allows you to create a login form where the username can be any email address that ends in the specified domain, and the password for all email addresses ending in that domain is going to be the same. See the below CSV as an example:
  1. emailAddress,password
  2. test.user@test.com,1234
  3. *@icareus.com,icapassword
The above CSV will create 2 participants to the event: "test.user@test.com" and "*@icareus.com". If a login form is then added to this event with an Email Address and Password fields, it will result in the following scenario:

  1. A user can successfully login to the event using the email address "test.user@test.com" and the password "1234"
  2. A user can successfully login to the event using any email address that ends in "@icareus" (i.e. test@icareus.com) and the password "icapassword"