Introduction
If you have many events you need to create, it might be easier to import a spreadsheet that contains the event details instead of creating each one manually. The import will save you time but note that there will be certain elements that you'll need to complete on your own after the import. This help topic first explains how the import works and then outlines the limitations or action items you'll need to take after the import has been completed.
Time Savings
If you have 3 or fewer events to create, the import will probably take as much time as simply created those events from scratch. This import is designed as a time saver for a high volume of events.
Spreadsheet Template
If you ever need a copy of the template, click on and save the.xls file: Boomer event import template as of 012025.xlsx.
Here is a sample version with a single event defined: event import sample as of 012025.xlsx
Column Order and Content
The fields in the spreadsheet map to the following within Boomer when imported:
| Excel Column Placement Order | Name | Target in Boomer | Comments | Required |
|---|---|---|---|---|
| A | EventName | Event Name | Yes | |
| B | Venue | Venue | The venue name in your spreadsheet must match the name of the venue in Boomer exactly | Yes |
| C | EventType | Event Type | In almost all cases, this will always be "Exhibitor" unless your business process uses our "Meeting" feature. | Yes |
| D | Acronym | Acronym | No | |
| E | Attendance | Attendance | Numeric value | No |
| F | EventStart | Event Start | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | Yes |
| G | EventEnd | Event End | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | Yes |
| H | SalesManager | Sales Manager | Enter the email address (Boomer username) of the sales manager. Note this field may be named something different in your system. | No |
| I | CateringManager | Catering Manager | Enter the email address (Boomer username) of the catering manager. Leave blank if you do not use or see the catering manager field. | No |
|
J |
ServiceManager | Convention Service Manager | Enter the email address (Boomer username) of the convention service manager. Leave blank if you do not use or see the convention service manager field. | No |
|
K |
ExhibitorServiceManager | Exhibitor Service Manager | Enter the email address (Boomer username) of the exhibitor service manager. Note this field may be named something different in your system. | No |
|
L |
GeneralServiceContractor | General Service Contractor | The general service contractor name in your spreadsheet must match the name of the general service contractor in Boomer exactly | Yes |
|
M |
EventWebSite | Event Website | No | |
|
N |
MainMobileNumber | Main Mobile Number | No | |
|
O |
ExhibitorKitLink | Exhibitor Kit Link | No | |
|
P |
Message | Message | No | |
|
Q |
ExternalShowCode1 | External Show Code 1 | No | |
|
R |
ExternalShowCode2 | External Show Code 2 | No | |
|
S |
ExternalShowCode3 | External Show Code 3 | No | |
|
T |
CommonEventCode | Common Event Code | No | |
|
U |
AdvancedPricingStart | Advanced Pricing Start | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
V |
AdvancedPricingEnd | Advanced Pricing End | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
W |
ExhibitorMoveInStart | Exhibitor Move-In Start Date/Time | Format should be MMDDYYYY HH:MM (no dashes or slashes, include leading zeros for single digit months, time in military format) | No |
|
X |
ExhibitorMoveInEnd | Exhibitor Move-In End Date/Time | Format should be MMDDYYYY HH:MM (no dashes or slashes, include leading zeros for single digit months, time in military format) | No |
|
Y |
ExhibitorMoveOutStart | Exhibitor Move-Out Start Date/Time | Format should be MMDDYYYY HH:MM (no dashes or slashes, include leading zeros for single digit months, time in military format) | |
|
Z |
ExhibitorMoveOutEnd | Exhibitor Move-Out End Date/Time | Format should be MMDDYYYY HH:MM (no dashes or slashes, include leading zeros for single digit months, time in military format) | |
|
AA |
ContractorMoveIn | Contractor Move-In | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
AB |
ContractorMoveOut | Contractor Move-Out | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
AC |
ShowStart | Show Start | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
AD |
ShowEnd | Show End | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
AE |
StorefrontLockDownDate | Storefront Lock Down Date | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
AF |
AdminLockDownDate | Admin Lock Down Date | Format should be MMDDYYYY (no dashes or slashes, include leading zeros for single digit months) | No |
|
AG |
Location | Location | Text | No |
|
AH |
GrossSqFt | Gross Sq Ft | Numeric | No |
|
AI |
NetSqFt | Net Sq Ft | Numeric | No |
|
AJ |
Published | Status | Yes | |
|
AK |
NumberBooths | Number Booths | Numeric | No |
|
AL |
LogoFileName | Not Currently Used | Leave Blank |
Security
The ability to import an event spreadsheet is controllable by security. By default, only those users with a Store Administrator role will see the command at the top of the Events grid. You can edit other security roles as desired to enable the feature for that group.
Import a List
To import an event list:
- Go to the Events grid.
- Click "Import Events" at the top of the grid (if you do not see the option, you do not have the security rights to import events).
- Click "Choose File" and select the Excel file to be imported.
- Click "Import".
- Boomer will review the file to make sure there are no format issues. If there are none, you will be prompted that the import was successful. If there are issues, you will be notified via a message.
Spreadsheet Errors
If after choosing the file and clicking "Import", you receive an error regarding the format of the spreadsheet, the following are the likely causes:
- The spreadsheet does not have the right number of columns. See to make sure the columns in the spreadsheet are the same as outlined in Boomer help.
- The spreadsheet has extra data in columns beyond the expected columns or data in rows beyond the event rows, or extra tabs with information on them.
- The data is not in the right format as outlined in Boomer help.
Below is an example of an error due to the fact that there is no manager with the email address provided in the spreadsheet: