Upload of manual data

Send data in a csv file to get it uploaded

2 min read

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 typetimetime endmeter idinstallation idnameaddressenergy + unit + modevolume + unit + modeforward temperature + unit + modereturn temperature + unit + modeforward energy + unit + modereturn energy + unit + mode
electricityRequiredRequired for intervalRequiredRequired
district heatingRequiredRequired for intervalRequiredRequiredOptionalOptionalOptionalOptionalOptional
gasRequiredRequired for intervalRequiredRequired
waterRequiredRequired for intervalRequiredRequired

Electricity examples

ento_format_example_electricity_interval.csv 13.9 kB ento_format_example_electricity_counter.csv 11.3 kB

District heating examples

ento_format_example_district_heating_interval_temperature.csv 21.9 kB ento_format_example_district_heating_interval_energy.csv 21.5 kB ento_format_example_district_heating_counter_temperature.csv 16.4 kB ento_format_example_district_heating_counter_energy.csv 17.4 kB

Gas examples

ento_format_example_gas_interval.csv 13.1 kB ento_format_example_gas_counter.csv 10.5 kB

Water examples

ento_format_example_water_interval.csv 13.5 kB ento_format_example_water_counter.csv 10.9 kB

Did this answer your question?