The Locations Export feature enables administrators to export location configuration data into a Microsoft Excel workbook (.xlsx) for reporting, auditing, migration, backup, or offline review.
The Locations export is generated as a multi-spreadsheet, where each spreadsheet represents a specific category of location configuration.
Export generation is performed asynchronously to ensure optimal performance regardless of the number of locations and associated configuration objects.
Note
The exported data reflects the state of the database at the time the export is processed. Because exports are generated asynchronously, they do not represent a transactional snapshot of the data at the moment the export request is submitted.
Permissions
The Export locations action is available to administrators with permission to view and edit locations.
Export locations
To export locations:
- Navigate to Locations > List.
- Click Import / Export.
- Select Export locations.
Export options
Before the export starts, a confirmation dialog is displayed.
The administrator can choose whether to include disabled locations by enabling the Include disabled locations option.
- Unchecked (default): exports only enabled locations.
- Checked: exports both enabled and disabled locations.
Click Start to generate the export.
Export generation
Once Start is clicked:
- an asynchronous backend export task is created;
- the administrator may continue using the application while the export is being generated;
- once the export is complete, the workbook is automatically downloaded by the browser.
Workbook structure
The exported workbook contains multiple worksheets. Each worksheet groups a specific category of configuration associated with the exported locations.
All worksheets are related through the exported locations and together represent the complete location configuration.
Locations
The Locations worksheet contains the general configuration of each exported location.
Typical information includes:
- Location name
- Location type
- Parent location
- Alias
- Country
- Timezone
- Assigned portal
- Assigned Terms of Use
- Redirect URL
- Postal address
- City
- Region
- Tags
- Comments
- Status
This worksheet is the primary reference for all exported locations.
GRE tunnels
The GRE tunnels worksheet contains all GRE tunnel configurations associated with the exported locations.
Typical information includes:
- Location
- Tunnel source
- GRE endpoint
- Primary destination
- Secondary destination
- Internal routing ranges
- Comments
Only locations configured with GRE tunnels appear in this worksheet.
UFQDN tunnels
The UFQDN tunnels worksheet lists all User Fully Qualified Domain Name (UFQDN) tunnel configurations.
Typical information includes:
- Location
- UFQDN
- Comments
Only locations configured with UFQDN tunnels are included.
IPSEC tunnels
The IPSEC tunnels worksheet contains all IPsec tunnel endpoints associated with exported locations.
Typical information includes:
- Location
- Tunnel IP address
- Comments
Only locations configured with IPsec tunnels appear in this worksheet.
IP ranges
The IP ranges worksheet contains all IP network ranges assigned to exported locations.
Typical information includes:
- Location
- IP range
- Network mask
- Security profile
- Portal status
- Internal identifier
- Comments
A location may have multiple IP ranges.
IP addresses
The IP addresses worksheet lists individual IP addresses associated with exported locations.
Typical information includes:
- Location
- IP address
- Comments
Only locations configured with individual IP addresses are included.
Access points
The Access points worksheet contains wireless access points associated with exported locations.
Typical information includes:
- Location
- Access Point MAC address
- Device name
- Serial number
- Model
- Firmware version
- Physical address
- Latitude
- Longitude
- Comments
Only locations containing registered access points appear in this worksheet.
Vendor ID
The Vendor ID worksheet lists vendor identifiers associated with exported locations.
Typical information includes:
- Location
- Vendor identifier
- Vendor name
- Comments
Only configured Vendor IDs are exported.
Hash keys
The Hash keys worksheet contains the hash-based identifiers configured for exported locations.
Typical information includes:
- Location
- Hash value
- Alias
Export scope
The exported workbook:
- includes all locations accessible to the administrator;
- optionally includes disabled locations when Include disabled locations is selected;
- exports all eligible configuration associated with each location;
- organizes configuration into dedicated worksheets for easier navigation and analysis;
- respects the administrator's permissions and tenant scope;
- reflects the data available when the asynchronous export task is processed.
Notes
- Export generation is asynchronous.
- Export duration depends on the number of locations and the amount of associated configuration.
- The exported file is provided as a Microsoft Excel (.xlsx) workbook containing multiple worksheets.
- Some worksheets may be empty if no corresponding configuration exists for the exported locations.
- Changes made while the export is running may be reflected in the generated workbook, as the export uses the data available when the background task is processed.