ExhibitDay

Importing Assets From a Spreadsheet

You can import your Assets from a spreadsheet into ExhibitDay. The Asset Import tool can be accessed via the dropdown menu of the “Manage Assets” tab.

Prerequisite: At Least One Storage Location

As a part of the asset bulk upload process, right after you upload your spreadsheet, you’ll be asked to specify the Storage Location for each Capital Asset that you’re importing.

Before you begin, please ensure that the Storage Locations to which you plan to assign the assets you’re importing have already been entered into the system.

Storage Locations can be managed from the dropdown menu of the “Manage Assets” tab.

Note: Storage Locations are different from “Storage Areas.” Storage Locations are places where assets are stored (for example, Warehouse A, Warehouse B). Each Storage Location has a name, address, point of contact, etc. Storage Areas are places within Storage Locations where assets are typically stored (e.g. “Aisle 1, Bin 3”). If you want to specify Storage Areas for assets you’re importing, you can enter the Storage Area for each asset under the “Storage Area” column (Column F of the upload template).

The Import Process

The import process is simple — you download the spreadsheet template (.xlsx), then fill in your assets (1 asset per row), and upload the completed file.

Please note that in the template, “Asset Name” (column A) and “Asset Type” (column B) are the only required columns.

Note: You can import up to 100 assets per upload. If you have more than 100 assets that you would like to import, you can break them down into multiple spreadsheets and upload each spreadsheet separately. Also, the import tool is limited to the properties of assets listed in the spreadsheet template (Asset Name, Type, Internal ID, Make/Model, Cost, Storage Area, Tags, and Pull Notes). Other properties of assets (like asset images, and quantities for collateral, etc.) cannot be imported using the import tool — they would have to be entered into the system manually after the import is complete.

Final Step: Review Screen

After you upload the spreadsheet, the system will parse your data and present you with a screen where you can review the data you’re about to import for accuracy. Review each asset that is being imported and make changes as needed.

If you are importing any Capital Assets, please ensure that you select the appropriate Storage Location for each Capital Asset on the review screen.

Once you’re done reviewing the data, click the “Submit” button at the bottom of the page to complete the import process.

Note: In ExhibitDay, each Capital Asset must be assigned to a Storage Location. That is why you are given the option to choose the Storage Location for each Capital Asset you’re importing on the review screen. On the other hand, Collateral / Multi-quantity Items do not need to have a storage location defined; the storage locations for Collateral / Multi-quantity Items can be selected whenever you make inventory adjustments for them (after the import is done).

Deleting Assets

If you accidentally import a duplicate asset, you can delete it by going to the Asset page itself. Please note that prior to deleting an asset, the asset must be marked as ‘Archived’. You can archive an asset from the extended menu of the tab strip on the Asset page. Once an asset is marked as ‘Archived’, the option to delete it appears in the extended menu of the tab strip.

Keeping Track of Your Giveaways at Events

You can track your giveaways (like swag and raffle items) at tradeshows by adding them under the event “Giveaways” tab.

Calculating the Cost of Giveaways Based on Asset Costs

When creating a Capital Asset or a Collateral/Multi-quantity item (in the “Manage Assets” area), you have the option of specifying the base cost for the Asset. Once an asset is reserved for an event (under the event Asset Reservations tab), that reservation can then be tagged in your Giveaways.

For example, if you have an Asset called “Company Logo Pen” with a cost of $1.00 per pen, and you reserve 500 of them for an event (via the Asset Reservations tab), you can then create a Giveaway (under the Giveaways tab) and tag that reservation in the giveaway. Once an asset reservation is tagged in a giveaway, the cost of the asset is displayed and you can use that cost to enter the cost for the giveaway.

Setting a Budget for Giveaways

You can enter your planned budget for giveaways at an event under the “Giveaways” section of the event “Budget” tab.

Images for Assets

You can upload up to 5 images for each asset.

Use the “Edit Images” link on the asset page in order to manage images for a given asset.

Uploading and Cropping Images

On the Asset Images popup dialog, click the “Add Image” button in order to add a new image for your asset. After you select the image file that you’d like to use, you’ll see a canvas that helps you crop the image in order to make it have the standard ExhibitDay asset image aspect ratio (125 / 94). You can move the crop area by clicking down and dragging it around. You can expand or shrink the crop area by clicking and dragging its corners. You can use the buttons at the top of the canvas to zoom, flip and rotate the image on the canvas.

Re-ordering Images

If you upload more than one image, the order in which the uploaded images are listed defines the sequence of the images when viewing the image gallery for the asset; the first image will always be the primary image for the asset. You can change the ordering by click-and-dragging the image handles.

Asset Image Gallery

Once you have uploaded images for an asset, those images can be viewed wherever the asset appears throughout your ExhibitDay workspace (e.g., in your main list of assets, in the list of asset reservations under a given event, etc.). Clicking on the asset image will pop open an image gallery that displays all the images for the asset.

Actual Costs for Events

Actual costs for a given event can be viewed under the “Actual Costs” section of the Event “Budget” tab.

Actual Costs for a given event are automatically complied based on the following:

Booth reservation cost (as entered under the “Booth” tab)
Booth service costs (as entered under the Booth Services section of the event “Booth” tab)
Attendee registration/ticket costs (as entered under the event “Staff” tab)
Travel reservation costs (as entered under the event “Travel Reservations” tab)
Shipment costs (as entered under the event “Shipments” tab)
Miscellaneous expense/credit costs/amounts (as entered under the event “Misc. Expenses & Credits” tab)
Sponsorship costs (as entered under the “Sponsorships” tab)

Actual Costs for all Events in a Given Year

Actual costs for all events in a given year can be viewed and downloaded under the “Actual Costs Details” section of the “Annual Budgets (all events)” page.

Copy / Duplicate Travel Reservations

You can easily create a copy of an existing travel reservation (under the event travel tab).

To create a duplicate copy of an existing travel reservation, click on the “Duplicate” option in the “Edit” menu of the reservation you’d like to copy.

Once the “Duplicate Travel Reservation” dialog appears, you can choose to copy the same tagged people and file attachments (if any) over to the new copy.

Finally, click the “Create Copy” button to complete the process.

Note: The ability to copy/duplicate travel reservations is only offered with ExhibitDay’s paid plans.

Exhibit Day