Fortinet black logo

Administration Guide

Sample import files

Copy Link
Copy Doc ID 825689eb-200d-11e9-b6f6-f8bc1258b856:919278
Download PDF

Sample import files

Hosts, Adapters, Users or Devices can be imported through the Hosts View using a .csv file. All of these items can be included in the same import file as long as the header row contains the appropriate database field names. Below are sample import files for each type as well as an import file containing records of all types.

Host import

The adap.mac field is required for this import.

adap.mac,siblings,adap.ip,host.owner,host.devType

00:13:CE:6C:56:75,00:13:CE:6C:56:75,192.168.20.45,Smith2010,Windows

00:15:70:D9:46:B0,00:15:70:D9:46:B0;00:15:70:D9:46:B1,,Orr2010,Linux

00:15:70:D9:46:B1,00:15:70:D9:46:B0;00:15:70:D9:46:B1,,Orr2010,Linux

Pingable device import

The adap.mac field is required for this import. The host.devType field is recommended to ensure that the correct icon displays. Use the host.topo field to display this device both in the Host View and the Topology View. Entering the name of the Topology Container in the host.topo field triggers FortiNAC to display the device in the Topology View. The device is automatically displayed in the Host View.

adap.mac,siblings,adap.ip,host.topo,host.devType

00:13:CE:6C:56:75,00:13:CE:6C:56:75,192.168.20.45,Blding_B,PBX

00:15:70:D9:46:B0,00:15:70:D9:46:B0,192.168.20.10,Blding_A,Camera

00:15:70:D9:46:B2,00:15:70:D9:46:B2,192.168.20.12,Blding_A,Printer

IP phone import

The adap.mac field is required for this import. The host.devType field is not required, however, since IP Phones are treated differently to prevent dropped calls, it is recommended that you include this field.

adap.mac,host.devType

00:12:C2:6C:56:74,IP Phone

00:12:C2:D9:46:B0,IP Phone

User import

The user.uid field is required for this import.

user.uid,user.fn,user.ln

Hebert2010,Frank,Hebert

Miller2009,Tammy,Miller

Mixed record types import

When combining different record types into a single import file, all of the fields for each record type must exist in the header row. For fields that do not apply to a particular record type, you must still include commas. Required fields for each type must be included.

adap.mac,siblings,host.owner,host.devType,user.uid,user.fn,user.ln

,,,,Hebert2010,Frank,Hebert

00:12:C2:6C:56:74,,,IP Phone,,,

00:13:CE:6C:56:75,00:13:CE:6C:56:75,Smith2010,Windows,,,

Sample import files

Hosts, Adapters, Users or Devices can be imported through the Hosts View using a .csv file. All of these items can be included in the same import file as long as the header row contains the appropriate database field names. Below are sample import files for each type as well as an import file containing records of all types.

Host import

The adap.mac field is required for this import.

adap.mac,siblings,adap.ip,host.owner,host.devType

00:13:CE:6C:56:75,00:13:CE:6C:56:75,192.168.20.45,Smith2010,Windows

00:15:70:D9:46:B0,00:15:70:D9:46:B0;00:15:70:D9:46:B1,,Orr2010,Linux

00:15:70:D9:46:B1,00:15:70:D9:46:B0;00:15:70:D9:46:B1,,Orr2010,Linux

Pingable device import

The adap.mac field is required for this import. The host.devType field is recommended to ensure that the correct icon displays. Use the host.topo field to display this device both in the Host View and the Topology View. Entering the name of the Topology Container in the host.topo field triggers FortiNAC to display the device in the Topology View. The device is automatically displayed in the Host View.

adap.mac,siblings,adap.ip,host.topo,host.devType

00:13:CE:6C:56:75,00:13:CE:6C:56:75,192.168.20.45,Blding_B,PBX

00:15:70:D9:46:B0,00:15:70:D9:46:B0,192.168.20.10,Blding_A,Camera

00:15:70:D9:46:B2,00:15:70:D9:46:B2,192.168.20.12,Blding_A,Printer

IP phone import

The adap.mac field is required for this import. The host.devType field is not required, however, since IP Phones are treated differently to prevent dropped calls, it is recommended that you include this field.

adap.mac,host.devType

00:12:C2:6C:56:74,IP Phone

00:12:C2:D9:46:B0,IP Phone

User import

The user.uid field is required for this import.

user.uid,user.fn,user.ln

Hebert2010,Frank,Hebert

Miller2009,Tammy,Miller

Mixed record types import

When combining different record types into a single import file, all of the fields for each record type must exist in the header row. For fields that do not apply to a particular record type, you must still include commas. Required fields for each type must be included.

adap.mac,siblings,host.owner,host.devType,user.uid,user.fn,user.ln

,,,,Hebert2010,Frank,Hebert

00:12:C2:6C:56:74,,,IP Phone,,,

00:13:CE:6C:56:75,00:13:CE:6C:56:75,Smith2010,Windows,,,