Import Devices from an Excel Sheet
The Device Catalog screen displays a list of devices that are known to an organization site. The list will be empty if no devices have been added to the site. There are three methods for adding a device to a site: import an OmniVista CSV file, import an Excel XLSX file, or manually add a device (Full Management Mode or Analytics Only Mode).
To import devices from an existing Excel sheet (.xlxs), click on Import from… and select XLSX template file. You will then be prompted to download an XLSX template file that contains instructions on how to configure the Excel file with the necessary device information.
Select the Management Mode (Full Management or Analytics Only) in which the Access Points will interact with OmniVista Cirrus. Next, click on Download XLSX template and specify where you would like to save the template file. When you open the template file, instructions are provided about how to define the devices to be added.
There is a different XLSX template file for each Management Mode. Depending on which mode you select (Full or Analytics Only), the corresponding template file is made available for download.
Consider the following when filling out and importing the template file:
If the serial number and Management Mode for a device defined in the import template file matches the serial number and Management Mode of a device already known in the Device Catalog, then OmniVista Cirrus imports the serial number and overwrites the device details with the template device details.
If the serial number for a device defined in the import template file matches the serial number of a device already known in the Device Catalog but the Management Mode is different, then OmniVista Cirrus will not import the serial number and related device details.
The following sample template file is an example of the template provided for Full Management devices:
The following sample template file is an example of the template provided for Analytics Only devices:
Fill out the template with information for each device that is to be imported. Once the file is complete and saved, return to Step 3 on the Import form and complete the following fields:
File Browser - Click in this field to find and select the existing template file to import.
Site Assignment - Click in this field to display a list of organization sites and select the site to which the devices defined in the template file will be imported.
Group Assignment (Full Management) - Click on this field to select the Access Point Group to which the devices will be assigned. The provisioning configuration associated with this group will be applied to the imported devices. This field does not apply or display when Analytics Only mode is selected.
Once the Import form is complete, click on Import. The Device Catalog list for the site is populated with the imported devices.