User Guide

NOTE: Upon exporting, non-editable columns appear in color on the spreadsheet.
To export template data to a spreadsheet:
1. In plan, rack or asset view, select the Templates pane.
2. Double-click on the template to export.
3. Click the Export All button.
4. Click Export. A directory opens to save the file.
5. Enter a file name and save to the appropriate location. If problems occur during the export, the screen shows
a list of errors.
NOTE: The Cancel button is available only during the export and is grayed out before and after the export.
6. Close the export screen.
7. Open the .xls file to view the template spreadsheet.
To import template data from a spreadsheet:
1. In asset view, select File - Export, From .xls file.
2. Click the Import button.
3. A directory opens to select a file.
4. Select the file to be imported. Click Open.
5. Select Templates to view the imported template.
Importing Assets with No Containment
This function allows you to import assets that are not placed on a floor plan or in other assets. You can import
unplaced assets by creating a spreadsheet using Microsoft Excel software and listing the assets to be stored in
inventory.
A custom Avocent spreadsheet is available with the application or can be obtained from Avocent Professional
Services.
The columns in this worksheet must have the required cells. In addition, when adding properties to the assets
being imported, optional cells can have the property information, according to the following table.
To import assets with no containment:
1. Open the spreadsheet and go to the Settings worksheet. Verify that the information is listed in the required
columns, A and B.
2. Select the Contained Assets worksheet and enter information in the following columns:
• Contained Assets Name - For example, Server-24.
• Shape Type ID - For example, DELL462.
• The Asset Container column must be blank for the asset to be treated as unplaced upon import. All
other columns may be blank.
Chapter 10: Export and Import Features 69