Bulk import
The bulk import allows you to use a spreadsheet to import your speakers. This is a great way to import a large number of speakers at once.
You must use the correct spreadsheet template to import your speakers. You can download the template from the manage speakers page OR using the 'Download speakers template' button at the top right of the bulk import page.
Spreadsheet template
If a speaker has a 'speaker ID' present, the system will attempt too 'update' that speaker. If no speaker ID is present, the system will try and insert that speaker
| Type | Value | Description |
|---|---|---|
| Title | String | The title for the speaker DR, CEO, MD |
| First_Name | String | The first name of the speaker |
| Last_Name | String | The last name of the speaker |
| The email address of the speaker | ||
| Phone | String | The phone number of the speaker |
| Company | String | The company the speaker is associated with |
| Description | String | The bio of the speaker |
| Links | JSON Object | The links section must be in a JSON object format See sample below |
| Speaker ID | String in brackets | The speaker ID Speaker ID must be contain in brackets [speakerID] If a speaker ID is present , the system will attempt to 'update' that speaker. If no speaker with that ID is found, it will return an error. |
| Attendee ID | String in brackets | This option is only valid if the speaker is also a mapped 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
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.