Importing Historical Data

How to Import

1. Go to Configuration → Logging.

2. Click Import at the top of the page.

3. Upload an Excel spreadsheet (.xlsx or .xls).

4. Click Import.

File format

Required column:

• Time Format: dd.mm.yyyy hh:mm (text or Excel date)

Value columns:

• One or more columns with log names as headers.

• Log names are unique per building, so each value column is uniquely mapped to a single log point.

Example:

Time | Supply Temperature | Return Temperature

Recommended workflow

1. Select logs in the table.

2. Select "Export Selected."

3. Enter values in the spreadsheet.

4. Import the same file using Import.

How the import finds the correct logs

When you import, the column names in the file are used to find the correct logs in the build.

If no columns match any logs in the building, the import will stop with an error message.

Important points

Updating existing data:
If a value exists for the same timestamp, the value is updated.

Adding new data:
Use a new timestamp to add data without overwriting existing data.

Cumulative log:
The values must be increasing over time (e.g., meter reading).