User guide

98 CHAPTER 5: IMPORTING AND REFRESHING DEVICES
Importing Devices
from a Spreadsheet
You maintain the list of devices on your network in a Microsoft Excel
spreadsheet. You wish to configure the devices using the tools provided
by 3Com Network Administrator.
To enable access to the configuration tools that 3Com Network
Administrator provides you must export the devices from your
spreadsheet to a CSV file and then import them into your 3Com Network
Administrator inventory file. One of the columns in the spreadsheet must
specify the IP address of the device:
1 Open your spreadsheet in Microsoft Excel.
2 Keep the main spreadsheet open and create a second spreadsheet by
selecting File > New.
3 Use the Window menu to return to the main spreadsheet and select the
entire IP Address column by clicking on the column header to highlight it.
4 Select Edit > Copy to copy the highlighted column.
5 Using the Window menu, return to the second spreadsheet.
6 Click the column header A to select the entire column and select Edit >
Paste to paste the IP addresses into column.
7 Repeat this process for the Subnet Mask column, pasting it into column B
of the second spreadsheet. If you have no subnet mask column in your
main spreadsheet then leave column B blank in your second spreadsheet.
8 Repeat this process for the Name column, pasting it into column C of the
second spreadsheet. If you have no name column in your main
spreadsheet then leave column C blank in your second spreadsheet.
9 Repeat this process for the Read Community column, pasting it into
column D of the second spreadsheet. If you have no read community
column in your main spreadsheet then leave column D blank in your
second spreadsheet.
10 Repeat this process for the Write Community column, pasting it into
column E of the second spreadsheet. If you have no write community
column in your main spreadsheet then leave column E blank in your
second spreadsheet.
11 Select File > Save As to save the second spreadsheet and select CSV as the
file type. Save the spreadsheet as
C:\MyDevices.csv.
3Com Network Administrator for HP OpenView.book Page 98 Wednesday, November 12, 2003 2:33 PM