User Guide
To enter properties for the assets being imported:
1. Select the Settings worksheet and enter information for the optional columns, D, E and F.
2. If a rack is being imported, go to the Floor Level Assets worksheet and enter information in the columns, for
example:
• maxPower Property.
• maxHeat Property.
• maxWeight Property.
3. Select the Contained Assets worksheet and enter information in the same as the columns in Step 2.
4. Save the worksheet and go back to the application to import the updated spreadsheet.
5. Select File - Import from the menu options. The Plan Import dialog box opens.
6. Click the Import button, and select the file to import, then click Open.
7. After the import is complete, search for the assets by name in the Unplaced pane.
Unit Types Unit Value Column Name Property Type Property Name
(Required) (Required) (Optional) (Optional) (Optional)
Column A Column B Column D Column E Column F
Length inches maxPower Property POWER maxPower
Angle degrees maxPower Property Units POWER maxPower
Power kilowatts maxWeight Property WEIGHT maxWeight
Heat BTU/Hr maxHeat Property HEAT maxHeat
Weight L IP address Property STRING IPaddress
support Property STRING support
DSView software name Property STRING DSView software name
Table 10.3: Columns in Worksheet
Importing User-Defined Properties
If a large number of user-defined information is being added to assets, this can be accomplished easily by
exporting the floor plan to a spreadsheet, adding the information, then importing the floor plan back into the
application as an Import to Update.
To add large amounts of data to a floor plan:
1. Open the desired floor plan.
2. Select File - Export to .xls file from the menu options.
3. Click Export, name the file and save it.
4. Log out of the application.
5. Open the Spreadsheet.
6. Navigate to the appropriate worksheet and add the information. An example would be adding IPAddresses
to a list of devices, which would be added to the floor-level assets worksheet.
7. Save the spreadsheet.
8. Log back in to the application. Do not open the floor plan yet.
70 Data Center Planner Installer/User Guide