Bulk import

The bulk import allows you to use a spreadsheet to import your exhibitors / sponsors. This is a great way to import a large number of exhibitors / sponsors at once.

Note

You must use the correct spreadsheet template to import your exhibitors / sponsors. You can download the template from the manage exhibitors or sponsors page OR using the 'Download Exhibitor / sponsor template' button at the top right of the bulk import page.

Spreadsheet template

Note

If an exhibitor / sponsors has an 'ID' present, the system will attempt too 'update' that exhibitor / sponsors. If no ID is present, the system will try and insert that exhibitor / sponsors as a new item, depending on 'type'.

Type	Value	Description
Name	String	The Name of the exhibitor / sponsor
Type	Exhibitor, Sponsor, Both	They type of item, valid types are Exhibitor, Sponsors, Both
Location	String	The location of the exhibitor / sponsor If location is not in the system, it will be added
Address	String	The address of the exhibitor / sponsor
Phone	String	The phone number of the exhibitor / sponsor
Email	Email	The email of the exhibitor / sponsor
Description	String	The description of the exhibitor / sponsor
Links	JSON Object	The links section must be in a JSON object format See sample below
Group	String	The group this exhibitor / sponsor belongs to If group is not in the system, a new group will be added, default order is 1
LiveStream	URL to video	This is the URL to a youtube video, must use the 'embed' link and will display in the detail of the exhibitor / sponsor
leadEmail	Email	The email address where generated leads will be sent

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”}
]

Values

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.