In our Session Locations Guide, we discussed the ins and outs of adding, editing, and assigning individual locations to your sessions. However, as your event starts ramping up, you may find yourself working with many locations for all of your event's sessions. Rather than adding locations one at a time, you can bulk add users by importing a spreadsheet.
Creating the Spreadsheet
To import locations, you'll need to fill out a .xlsx or .csv file with all your location data and import it to your event site.
When you're importing your location data, you can select one of two data types:
- Session Location Data
- Meeting Location Data
You'll need to import these in separate spreadsheets. In order for the import to be successful, you're required to add some fields as headers along the first row (row 1) of each spreadsheet.
For Session Locations, the following fields are required:
|Session Name||Describe the location.||Address||Must be greater than 0|
For Meeting Locations, the following fields are required:
|Name of venue||Address||Ex: "Please check in at the front desk."||598||Table29||10||1/20/2020||1/24/2020||11:00||17:00|
A few things to keep in mind before importing:
- Please include the headers (first row) in the spreadsheet before you import it.
- Please use 24hr format when entering DailyStartTime and DailyEndTime.
- The uploaded file cannot exceed 1000 rows. If you need to import more than 1000 rows for either Sessions or Meetings, please break the import into multiple files.
- Your file must be in either .xlsx or .csv format.
Importing the Spreadsheet
From the Admin portal, click on Locations > Import Locations:
Next, click on Start New Import in the right hand corner:
On the next page, select which Data Type you'd like to import. In this example, we're going to select Meeting Location. Be sure to read the import instructions that display after selecting your data type. Next, we'll locate the spreadsheet file on our device.
When you're finished with this step, click Next to proceed:
For the next step, you're required to map your file fields to their respective Hubb fields. This is a crucial step in the import process, so make sure you map your fields correctly! Map your fields until all of them indicate a green check mark.
Note: if your file's headers are exactly as they're written in this article, your fields should map automatically.
When you're done mapping your fields, click the Next button to proceed:
On the last step, please review your import. Any errors with your data will be detected at this step; if there are any errors, please edit and re-upload your spreadsheet.
Once everything is looking good to go, click the Import button in the top right corner to complete your import!
Lastly, you'll be prompted to confirm your import:
Once you hit OK, you're all done!
Any questions on importing locations? Feel free to reach out to us at email@example.com.