If you want to upload historical data or data that cannot be accessed through data integrations, You can do so in two different ways.
You can upload data to a manual meter, updating the datapoints, when they become available. Read more about how to do that.
If you have a larger historical dataset with multiple datapoints, we can help you upload this.
To do so, you need to send us a csv file with the data. Please sort the data according to the different file formats listed beneath. Afterwards send it to your contact person or to support@ento.ai, and we will upload the data for you.
Columns
All files must have a "meter type" column. Possible values are: electricity, district heating, gas, water.
Data series are stored in three columns: value + unit + mode:
- energy, energy unit, energy mode
- volume, volume unit, volume mode
- forward temperature, forward temperature unit, forward temperature mode
- return temperature, return temperature unit, return temperature mode
- forward energy, forward energy unit, forward energy mode
- return energy, return energy unit, return energy mode
Unit: we convert units on our side, so as long as they make sense, we can probably manage it. Examples: kWh, MWh, m3, liters, C, m3xC
Mode: must be either counter or interval
Column names must match. The column order doesn’t matter.
Required columns:
meter type | time | time end | meter id | installation id | name | address | energy + unit + mode | volume + unit + mode | forward temperature + unit + mode | return temperature + unit + mode | forward energy + unit + mode | return energy + unit + mode |
---|---|---|---|---|---|---|---|---|---|---|---|---|
electricity | Required | Required for interval | Required | Required | ||||||||
district heating | Required | Required for interval | Required | Required | Optional | Optional | Optional | Optional | Optional | |||
gas | Required | Required for interval | Required | Required | ||||||||
water | Required | Required for interval | Required | Required |