Create .csv files for device import
Create the CSV file with a text editor, or by exporting the device information from an application that can generate the CSV file format. The file should be formatted as follows for SNMP and non-SNMP devices.
|
Each device type must be contained within its own .csv file. For example, if you are importing printers and hubs, you must have a .csv file for printers and a separate file for hubs. |
SNMP devices
For SNMP devices, format each line in the CSV file as follows: CONTAINER,IP,USER,TELNET,ENABLE,RWCOMM,ROCOMM,ROLE
|
|
There must be a carriage return at the end of the each line in the file. The final line in the CSV file must also end in a carriage return or the last line will not be imported. Also, if a field is null, you must still include the field delimiter (comma). |
|
|
If multiple SNMP devices with the same name are imported, the first device has the correct name. All subsequent devices are named with a combination of the name and IP address, such as Camera[192.168.5.86]. |
Settings
|
Field |
Definition |
|---|---|
|
CONTAINER |
Folder model in the Inventory. Containers are used to group devices (required). If the Container field is blank, the IP address is used as the Container name and a localhost IP is entered (127.0.0.1). |
|
IP |
IP address of the new device (required). If the IP address field is blank, a localhost IP is entered (127.0.0.1). |
|
USER |
User name used to telnet into the device. |
|
TELNET |
Password used to telnet into the device. |
|
ENABLE |
Enable password. |
|
RWCOMM |
Read/Write Community Name. This must come first, before the Read Only community name. |
|
ROCOMM |
Read Only Community Name. |
|
ROLE |
Role for the device. |
Example:
test,192.168.5.32,admin,net123,,private,public,NAC_Default,
test,192.168.5.35,admin,net456,bscen1,private,public,NAC_Default
Non-SNMP devices
For non-SNMP devices, format each line in the CSV file as follows:
CONTAINER,IP,NAME,MAC,na,na,na,Role
|
|
There must be a carriage return at the end of the each line in the file. The final line in the CSV file must also end in a carriage return or the last line will not be imported. Also, if a field is null, you must still include the field delimiter (comma). |
Settings
|
Field |
Definition |
||
|---|---|---|---|
|
CONTAINER |
Folder model in the Inventory. Containers are used to group devices (required). If the Container field is blank, the IP address is used as the Container name and a localhost IP is entered (127.0.0.1). |
||
|
IP |
IP address of the new device (required). If the IP address field is blank, a localhost IP is entered (127.0.0.1). |
||
|
NAME |
Name of the device.
|
||
|
MAC |
MAC address of the device (optional). |
||
|
NA |
blank |
||
|
NA |
blank |
||
|
NA |
blank |
||
|
ROLE |
Role for the device. |