1. Home
  2. Docs
  3. Exhibitor / Sponsors
  4. Upload Excel

Upload Excel

The upload Exhibitor and Sponsors section allows you to bulk upload exhibitor & sponsor information from an excel spreadsheet. From the bulk upload, you can

 

Add Exhibitors & Sponsors

Adding an exhibitor or sponsor from the spreadsheet can be done by first downloading the exhibitors & sponsors template file by selecting the ‘Download Exhibitors & Sponsors’ button from the ‘Exhibitors / Sponsors > Upload Excel’ section

 

Once downloaded you can then open the excel file and start adding / updating exhibitor & sponsor information

The excel spreadsheet for sessions includes options for

  • Name
    The name of the exhibitor / sponsor
  • Location
    The location of the exhibitor / sponsor at the event
  • Address
    The physical address of the exhibitor / sponsor
  • Phone
    The exhibitor / sponsor phone number
  • Website
    The exhibitor / sponsor company website
  • Email
    The exhibitor / sponsor’s email address [This email will be used for the QR share if QR share is being used]
  • Twitter
    The exhibitor / sponsor’s Twitter page
  • Facebook
    The exhibitor / sponsor’s Facebook page
  • Linkedin
    The exhibitor / sponsor’s Linkedin page
  • Description
    The description of the exhibitor / sponsor
  • SponsorType
    The sponsor type allows you to set if the item is an exhibitor, sponsor, or both. This option must be set to one of the three options

    • exhibitor
    • sponsor
    • both
  • DisplayType [Sponsor Only]
    NOTE: To set a display type, the category must already be in the system. This can be done by going to the add exhibitor / sponsor page and selecting category > Add a new category
    The Display Type allows you to set the category of the exhibitor / sponsor. This is commonly used for things such as Gold, Silver, Bronze
  • SortOrder [Sponsor Only]
    The sort order is the order in which the sponsor should display in the set category
  • sid
    The sid is the ID of the element. This item should not be modified, when present the system will treat the elements as an update, if no sid is defined the system will add the exhibitor / sponsor as new
  • Image
    The image section should not be modified unless the image file name is known, otherwise this could result in broken images [For informational purposes]
  • banner
    The image section should not be modified unless the image file name is known, otherwise this could result in broken images [For informational purposes]
  • isBanner
    This is simply an indicator for banners and should not be modified. [For informational purposes]

 

 

To add a new exhibitor / sponsor, simply add a new entry to the spreadsheet, when no sid is added the system will treat the exhibitor / sponsor as a ‘New’ item

 

Update Exhibitor / Sponsor

Updating an exhibitor / sponsor can be done by simply updating an exhibitor / sponsor that is already in the spreadsheet. Exhibitors / Sponsors that contain a valid sid will be updated.

 

Note: If a sid is not valid it will prevent the spreadsheet from being uploaded, the sid should not be modified

Was this article helpful to you? Yes No

How can we help?