Bulk import
The bulk import allows you to use a spreadsheet to import your attendees. This is a great way to import a large number of attendees at once.
You must use the correct spreadsheet template to import your attendees. You can download the template from the manage attendees page OR using the 'Download attendee template' button at the top right of the bulk import page.
Spreadsheet template
If an attendee has an 'attendeeID' present, the system will attempt too 'update' that attendee. If no attendee ID is present, the system will try and insert that attendee as a new attendee.
| Type | Value | Description |
|---|---|---|
| Title | String | The title for the attendee DR, CEO, MD |
| First_Name | String | The first name of the attendee |
| Last_Name | String | The last name of the attendee |
| The email address of the attendee | ||
| Phone | String | The phone number of the attendee |
| Company | String | The company the speaker is associated with |
| Description | String | The bio of the attendee |
| Attendee_Only | String | The attendee only section allows you to set attendee specific details, this will allow an attendee, when validated, to click on the 'my details' in the app. This can contain special instructions or a personalized welcome message for the attendee. |
| Groups | Comma list | The groups section allows you to assign groups to an attendee. To add multiple groups, they must be in a comma deliminated list eg group1,group2,group3 If a group is not in the system, one will be created |
| Links | JSON Object | The links section must be in a JSON object format See sample below |
| SpeakerID | String in brackets | This option is only valid if the speaker is also a mapped attendee. |
| AttendeeID | String in brackets | The attendee ID Attendee ID must be contain in brackets [attendeeID] If an attendeeID is present , the system will attempt to 'update' that attendee. If no attendee with that ID is found, it will return an error. |
| Is_Speaker | Yes/No | This setting, when set to YES, and the attendee ID section is blank, will create a mapped speaker for the new attendee |
A mapped attendee is done when creating an attendee. If an attendee is mapped, it will create an attendee that is mapped to the speaker Any updates done to the speaker or attendee will update both profiles in the system
If you do not wish to display attendee emails in the app, you can set the attendee email to 'hidden' in the configuration page
Links JSON Object
If adding links, use the format below to ensure proper linking.
[
{“icon”:”icon-globe”,”color”:”#009EDB”,”url”:”https://conbop.com”},
{“icon”:”icon-globe”,”color”:”#009EDB”,”url”:”https://conbop.com”}
]
If any values are incorrect, the system will return an error with the line number of each error. Once corrected, you can upload the speadsheet again.