|
|
There are two methods of importing devices into your Cisco Resource Manager network inventory:
The Resource Manager Admin > Inventory > Import from File feature uses the device integration file format. The CSV file format is an alternative to the device integration file format. The CSV file format uses a script to import the devices into your network inventory. Both formats are described in this appendix.
The device integration file is currently encoded in the ISO Latin-1 character set using an extended BNF notation described in the Resource Manager online help (Inventory Administration > Adding and Importing Devices > Import from File). The device integration file specifies the following characteristics of each device:
Following is a sample device integration file, incorporating these characteristics. The sample file was imported from CiscoWorks.
First, the device integration file is defined:
cisco Systems NM data import, source=CW; Version = 1.0;
The device table is defined.
Table name = Device basic inventory; Version = 1.0; Column count = 7; Separator = |;
Columns for the device table are defined.
Col# = 1; Name = Row#; Col# = 2; Name = Device name; Col# = 3; Name = Domain; Col# = 4; Name = RO community string; Col# = 5; Name = RW community string; Col# = 6; Name = Telnet password; Col# = 7; Name = Enable password;
Rows of data for the device table are defined.
000001|111.22.333.4||||fooey|more 000002|landfall|cisco.com|public|private|| 000003|yet_another_router||read|write|mommy|whoKnows 000004|Pinpointed_router|organized.org|read|write|thickAsABrick|clearAsMud 999999
An administrative domain table is defined.
Table name = Device grouping; Version = 1.0; Column count = 4; Separator = $
Columns for the domains table are defined.
Col# = 1; Name = Row# Col# = 2; Name = Group Col# = 3; Name = Device name Col# = 4; Name = Domain
Rows of data for the domain table are defined.
000001$CW_World$111.22.333.4$ 000002$CW_World$yet_another_router$ 000003$CW_World$landfall$cisco.com$ 000004$CW_Smaller than world$yet_another_router$ 999999
The user annotation table is defined.
Table name = Device annotations; Version = 1.0; Column count = 7; Separator = $
Columns for the annotation table are defined.
Col# = 1; Name = Row# Col# = 2; Name = Device name Col# = 3; Name = Domain Col# = 4; Name = Annotation 1 Col# = 5; Name = Annotation 2 Col# = 6; Name = Annotation 3 Col# = 7; Name = Annotation 4
Rows of data for the annotations table are defined (the first annotation holds location; the second annotation holds the contact name).
000001$111.22.333.4$$San Jose: Bldg F$Joe Smith 000002$yet_another_router$$San Jose: Bldg A$Jill Jones 000003$landfall$cisco.com$San Jose: Bldg F$Joe Smith 000004$yet_another_router$Santa Clara: Bldg 1$George Black 999999
The serial number table is defined.
Table name = Device serial numbers; Version = 1.0; Column count = 4; Separator = $ Col# = 1; Name = Row# Col# = 2; Name = Device name Col# = 3; Name = Domain Col# = 4; Name = Serial number
Table name = Device Rcp access data; Version = 1.0; Column count = 5; Separator = $ Col# = 1; Name = Row# Col# = 2; Name = Device name Col# = 3; Name = Domain Col# = 4; Name = Rcp user Col# = 5; Name = Rcp password
RCP data is provided.
000001$111.22.333.4$$jsmith$1dasf8 000002$yet_another_router$$jjones$1ruf7dhgd 000003$landfall$cisco.com$jsmith$1dasf8 000004$yet_another_router$gblack$7fghs4 999999
Table name = Device Tacacs access data; Version = 1.0; Column count = 5; Separator = $ Col# = 1; Name = Row# Col# = 2; Name = Device name Col# = 3; Name = Domain Col# = 4; Name = Tacacs user Col# = 5; Name = Tacacs password
TACACS data is provided.
000001$111.22.333.4$$jsmith$3dfg6 000002$yet_another_router$$jjones$adf6789 000003$landfall$cisco.com$jsmith$3dfg6 000004$yet_another_router$gblack$jh3df7 999999
As an alternative to the device integration file, you can create a CSV file to import your devices into your network inventory. After you have created the CSV file, run the crmimport.pl script to import the device data.
The CSV format currently provides the following device information:
The CSV format currently does not allow you to include password information. You may need to enter passwords manually. This may affect future upgrades of the product, but will not compromise current functionality. Once the CSV file is complete, use the crmimport.pl script to pull the device data from your CSV file. Refer to the crmimport.pl manual page for details. Manual pages are located in /opt/CSCOpx/man/man1m/crmimport.pl.1m.
Following is a sample CSV-formatted file.
; This file was manually generated as a sample. ; ; The header line is required. ; cisco Systems NM data import, source = Hand edit; Version = 1.0; Type = Csv ; ; Here are the columns of the table. ; Columns 1 and 2 are required. ; Columns 3 through 8 are optional. ; ; Col# = 1: Name = Device name (include domain unless your site has ; unqualified device names registered in the name services) ; - or - ; IP address in dotted decimal notation ; Col# = 2: Name = RO community string ; Col# = 3: Name = RW community string ; Col# = 4: Name = Serial Number; ; Col# = 5: Name = User Field 1 ; Col# = 6: Name = User Field 2 ; Col# = 7: Name = User Field 3 ; Col# = 8: Name = User Field 4 ; ; Here are the rows of data. ; bigrouter.yourcompany.com,public,private,, dev-2501.yourcompany.com,"Not so, "" public as, thought",private,sn2501, dev-2502.yourcompany.com,public,"private",sn2502, dev-2503.yourcompany.com,public,private,sn2503,"" dev-2504.yourcompany.com,public,private,sn2504, dev-2505.yourcompany.com,public,private,sn2505, dev-2507.yourcompany.com,public,private,sn2507, dev-2509.yourcompany.com,public,private,sn2509, dev-2510.yourcompany.com,public,private,sn2510, dev-2511.yourcompany.com,public,private,sn2511, dev-2512.yourcompany.com,public,private,sn2512, dev-2513.yourcompany.com,public,private,sn2513, dev-2514.yourcompany.com,public,private,sn2514, dev-2515.yourcompany.com,public,private,sn2515, dev-2516.yourcompany.com,public,private,sn2516, dev-4000.yourcompany.com,public,private,,Big Boys dev-4500.yourcompany.com,public,private,,Big Boys dev-7000.yourcompany.com,public,private,,Big Boys dev-7010.yourcompany.com,public,private,,Big Boys dev-2517.yourcompany.com,public,private,,,nm 25xx dev-2518.yourcompany.com,public,private,,,mylabel2 dev-2520.yourcompany.com,public,private,,,mylabel2 dev-2521.yourcompany.com,public,private,,,mylabel2 dev-2522.yourcompany.com,public,private,,,mylabel2 dev-2523.yourcompany.com,public,private,,,mylabel2 dev-2524.yourcompany.com,public,private,,,mylabel2 dev-2525.yourcompany.com,public,private,,,mylabel2 dev-4700.yourcompany.com,public,private,,yourlabel1,,yourlabel3,yourlabel4 dev-7206.yourcompany.com,public,private,, dev-7505.yourcompany.com,public,private,,,,,yourlabel4 dev-7507.yourcompany.com,public,private,, dev-7513.yourcompany.com,public,private,, dev-1200.yourcompany.com,public,private,, dev-2900.yourcompany.com,public,private,, dev-3000.yourcompany.com,public,private,, dev-5000.yourcompany.com,public,private,, 1.2.3.4,public,public,,
|
|