Fortinet black logo

Administration Guide

Create .csv files for device import

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.

Note

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

Note

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).

Note

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

Note

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.

Note

If multiple non-SNMP devices with the same name are in the import file, the first device has the correct name. All subsequent devices are not imported.

MAC

MAC address of the device (optional).

NA

blank

NA

blank

NA

blank

ROLE

Role for the device.

Create .csv files for device import

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.

Note

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

Note

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).

Note

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

Note

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.

Note

If multiple non-SNMP devices with the same name are in the import file, the first device has the correct name. All subsequent devices are not imported.

MAC

MAC address of the device (optional).

NA

blank

NA

blank

NA

blank

ROLE

Role for the device.