Import model devices from a CSV file

Model devices can be imported using a CSV file. This can be used to import large numbers of model devices into FortiManager.

When importing model devices from a CSV file, a device blueprint is used to configure the initial settings. See Using device blueprints for model devices.

ADOM-level metadata variables for each device can be specified in the CSV file.

To import model devices from a CSV File:

1. If ADOMs are enabled, select the ADOM to which you want to add the device.

2. Go to Device Manager > Device & Groups.

3. Click Add Device.
   The Add Device dialog is displayed.

   

4. Click Import Model Devices from CSV File.

5. Configure your local CSV file for the devices that you want to import. CSV files must contain the following columns: Serial Number, Device Blueprint, and Name, with the respective data listed in the cells below.

   • If you are creating an HA cluster, also include the following columns: Cluster Id, Cluster Name, Priority, and HA Mode. HA must also be enabled and configured in the Device Blueprint assigned to the model device.

   • Additional columns can be added for each metadata variable that you want to specify. In the following image, the branch_id metadata variable has been added to specify this variable for each imported device. See ADOM-level metadata variables.

   • You can export an example CSV file from the Device Blueprint table.
     
     

6. Drag and drop the CSV file into the Upload area, or select the CSV file location on your computer.
   The model devices' serial numbers, names, blueprints, and optional metadata variables are displayed in the table.

7. (Optional) From the Copy Device Dashboard dropdown, select a device to copy custom device dashboards from.

   For more information about dashboards in the device database, see Device DB - Dashboard.

8. Review the device list, and click Next to begin importing the devices. Click Finish when the import process is complete.

Supported fields in CSV files

The following fields are supported when importing model devices from a CSV file. Configuration of the model devices can be specified using device blueprints (for example, configuration of assigned Pre-Run CLI Templates and Policy Packages).

Column name	Requirement	Value
Serial Number sn	Required	The serial number of the model device. For example: FGVM02TM20000000
Device Blueprint	Required	The device blueprint for the model device. This blueprint must match the platform of the model device. See Using device blueprints for model devices. For example: branch_blueprint
Name	Required	The name of the model device. For example: br3
Cluster Id	Required for HA devices.	The cluster ID. For example: 100
Cluster Name	Required for HA devices.	The cluster name. For example: FGT60FHA1
Priority	Required for HA devices.	The priority of this device in the HA cluster. For example: 200
HA Mode	Required for HA devices.	Specify the HA mode as AP(active-passive) or AA (active-active). For example: AP
{Metadata_Variables}	Optional	Enter the metadata variable name as the column header and the value for the model device in the corresponding cell. For example: Column name: branch_id Cell value: 3