Import Caveats
General
Never change the name of the headers
No two session,speaker,attendee etc should have the same unique id
Use Excel file for Windows and CSV for mac
Check documentation if in doubt about the format needed or mandate fields
Check previous imports by using import history
Sessions
Add speakers in the session file itself
Can add upto 25 speakers per session
If more than 25 rest can be manually added
Unique id,session name,start and end date and time are mandate
First name and last name or display name of speaker is mandate if adding speaker here
Roles of speaker can be defined in this file
Add unique id of parent session in parent unique id fields of subsessions to create subsessions
Enable Live Q&A for sessions in bulk by adding yes,y ,t under "LIveQ&A Enabled"
Organisation
Sponsorship levels need to be defined first under advance settings or file would not import
Sponsorship levels are case sensitive
If " is a sponsor" is a yes and no sponsorship level added organisation will be added under "sponsor" header
If sponsorship level added but "is a sponsor" is blank organisation will still be added as a sponsor
If over 10 sponsor level use tags for sponsor level and create a sponsor icon as a top level with "with the tag" logic for each sponsor level
Add VIP admin emails comma separated under "admin invitation column"
Attendees
Hide attendees on the attendee list by adding "n, no, f, or false" under "Show on Attendee List"
Custom field show in the import file in this format "introductory::qualification"
Custom Field can't be added directly in import file but need to be defined first
To make attendee profiles public change the setting under privacy settings first as public and then import the attendees (wont affect confirmed attendees)
Hide email of attendees by adding "n, no, f, or false" under "Show Email on Attendee Profile?"
Email address of an attendee ,his first and last name are mandate
Mandate fields
Attendees
Session
Speaker
Page
Geolocation
Attendee Schedule
Attendee appointment
Name,start and end date and time
Name
Name and Location info
Appointment Name,start and end date and time
First name and last name or Display name
first name and last name and Email address
Attendee Unique ID,Activity Unique ID,Change