User Guide

Function Description
Last File The Last file exported.
Import to Update Check this box if importing a floor plan with changes to the .xls to update a current floor plan.
Last Import Date of the last import.
Current Import
Current Import can show the following: No Import, Uploading file, Processing Data, Import
completed or Import failed.
Elapsed Time Total
These give you an indication of progress in processing and indexing. Indexing time is the time to
prepare the data for searches.
If errors occur, the following information is displayed. This may occur when shapes are not available in the database.
Missing Devices This area shows a list of devices not currently in the device database upon import.
Errors A detailed description of any errors that occurred during the import.
Print Errors Click this button to print a list of errors that occurred.
Cancel Click this button to stop the import. This button is enabled only during the import.
Import Click this button to begin the import.
Close Click this button to close the import dialog box.
Table 10.1: Plan Importer Descriptions
Importing and Exporting Sheets and Column Values
This information details the Import and Export worksheets and a partial list of recognized column values using
Microsoft Excel. The columns depict information and properties associated with each asset.
An import template is available in the doc folder with the installation. Select Program Files, Avocent,
MergePoint, DataCenterPlanner, doc, ImportTemplate.xls. The template is also available on the Avocent
download site. The template is a starting point for users who require importing a floor plan from a spreadsheet.
NOTE: Upon exporting data, non-editable columns are highlighted in pink on the spreadsheet. The sheets are not locked, but these
columns should not be changed if the spreadsheet will be re-imported.
Sheets and Recognized Column Values
Settings
Units Type
Units Value
Column Name
Property Type
Property Name
Plans
PLAN ID
PLAN NAME
ADDRESS 1
ADDRESS 2
CITY, STATE, COUNTRY, ZIP
CONTACT NAME
CONTACT PHONE
MAX HEAT
MAX HEAT UNITS
DEFAULT HEAT
DEFAULT HEAT UNITS
MAX POWER
MAX POWER UNITS
DEFAULT POWER
DEFAULT POWER UNITS
MAX WEIGHT
MAX WEIGHT UNITS
DEFAULT WEIGHT
DEFAULT WEIGHT UNITS
LATITUDE
LONGITUDE
Table 10.2: Sheets and Column Values
66 Data Center Planner Installer/User Guide