Import and Export Devices and Interfaces Using Excel

Units

Export Devices

1. Go to Configuration and select Devices.

2. Click Export. You will receive the file `hosts.xlsx` containing all the units in the building.

Import devices

1. Go to Configuration and select Devices.

2. Click Import.

3. Click Download Template at the bottom of the window if you need a file with the correct columns, and fill it out.

4. Under Select gateway, choose the gateway to which the new devices will be added.

5. Select the file under "Select .xlsx file."

6. Check the "Update existing" box if you want to modify existing devices.

7. Click Import.

Columns

• Name: the name of the device. Required.

• Description: optional description.

• IP Address: The IP address or hostname of the device. Required.

• Type: The device type with its English name, as listed in an export: Unknown, Pls, VentilationSystem, EnergyMeter, Gateway, HeatPump, HeatingSystem, CoolingSystem, EnergyCentral, SolarPowerSystem, BatteryStorage, EVCharger, WeatherStation, FireSafetySystem, AccessControlSystem, WaterMeter, or Other. The list is also included in the column comment in the template. An empty cell indicates the type “Unknown.”

• Model Name: optional model.

• MAC Address: optional MAC address, for example 00:20:18:61:f1:8a.

Interface

Export Interface

1. Go to Configuration and select Interface.

2. Click Export. You will receive the file “hostinterfaces.xlsx.”

The file contains one sheet per interface type: Modbus TCP, KNX-IP, BACnet-IP, MQTT, MQTT Inbound, OPC UA, Loxone, and Virtual. All sheets begin with the columns ID, Host, Name, Description, and Enabled. These are followed by the settings for that type.

Import Interfaces

1. Go to Configuration and select Interfaces.

2. Click Import.

3. Click Download Template at the bottom of the window if you need a blank file with the correct columns, and fill it out.

4. Select the file under "Select .xlsx file."

5. Check Update existing if you want to modify an existing interface.

6. Click Import. Evolo sends the new setup to the gateways in the building.

Here’s how to link the rows to the correct device and interface

• Host: the name of the device to which the interface belongs, as listed under Devices. The name must exist and be unique within the building. Otherwise, the import will stop and indicate which sheet and row are incorrect.

• Update existing: “Evolo” updates the interface with the same device, type, and name. Without this checkbox selected, each row creates a new interface, even if an identical one already exists.

• ID: for information only. This column is not used to locate the interface.

• Password and client keys: If you leave the cell blank during an update, the interface retains the stored value.

If the import stops

Evolo each cell is checked before anything is saved. The error message shows the sheet, row, and column that are incorrect, using the same row numbering as in Excel. Nothing from the file is saved until all rows are approved, so you can correct the file and import it again.