Locations import

The Locations Import feature enables administrators to create or update locations in bulk by importing a spreadsheet workbook.

The import uses the same workbook structure as the Locations Export, allowing administrators to export existing locations, edit the workbook offline, and import the updated configuration back into Cloudi-Fi.

A single workbook can contain multiple worksheets representing the different network topologies supported by Cloudi-Fi.

Permissions

The Import locations action is available to administrators with permission to create and manage locations.

Import Locations

To import locations:

1. Navigate to Locations > List.
2. Click Import / Export.
3. Select Import locations.

Getting started

The import dialog provides two useful resources before importing a workbook.

• Documentation – Opens the Locations Import documentation.
• Download template – Downloads the latest supported import template.

Using the latest template is strongly recommended to ensure compatibility with the current platform version.

Select the workbook

Click Choose and select the workbook to import.

Supported formats are:

• .xlsx
• .xls
• .ods

After selecting a valid workbook, the Start button becomes available.

Update existing entries

The Update existing entries option controls how existing locations are handled.

Disabled (default)

Only new locations are created.

If a location already exists, it is skipped and reported in the import summary.

Enabled

Existing locations are updated using the values contained in the workbook.

Locations that do not already exist are created.

Workbook structure

The workbook is composed of several worksheets.

The Locations worksheet is mandatory.

Additional worksheets contain configuration associated with specific location types.

Only the worksheets applicable to the imported location types are processed.

Locations worksheet

The Locations worksheet contains the list of locations to create or update.

Location types

The Type column determines which additional worksheets are required for each location.

REDIRECT_URL

The following worksheets are associated with this location type:

• Access points
• Vendor ID
• Hash keys

Access points

Associates wireless access points with the location.

Vendor ID

Associates vendor identifiers with the location.

Hash keys

Associates hash identifiers used for location recognition.

VPN_FQDN

A VPN_FQDN location represents a VPN endpoint identified by a Fully Qualified Domain Name.

It uses the UFQDN tunnels worksheet.

UFQDN tunnels

VPN_IP

A VPN_IP location represents a VPN endpoint identified by one or more public IP addresses.

It uses the IPSEC tunnels worksheet.

IPSEC tunnels

GRE

A GRE location represents a GRE tunnel endpoint.

It uses the GRE tunnels worksheet.

GRE tunnels

VIRTUAL

A VIRTUAL location represents logical networks attached to an existing location.

A Virtual location must have a Parent location defined in the Locations worksheet.

It uses the following worksheets:

• IP ranges

IP ranges

Import validation

Before importing data, Cloudi-Fi validates:

• supported workbook format;
• required worksheets;
• mandatory columns;
• supported location types;
• parent location references;
• duplicate locations;
• duplicate network objects;
• worksheet relationships;
• data consistency.

Rows containing validation errors are skipped and reported in the import summary.

Notes

• Always use the latest downloadable template.
• The Locations worksheet is mandatory.
• Additional worksheets are processed only for the corresponding location type.
• A VIRTUAL location requires a valid Parent location.
• Enabling Update existing entries updates existing locations instead of skipping them.
• Importing a workbook never deletes existing locations or associated configuration that are not present in the workbook.
• Only worksheets relevant to each location type are imported; unrelated worksheets are ignored.