This manual describes how to supply historical measurement data via CSV files. This is useful when you want to transfer data from another system to MeterInsight. Before importing the measurement data, it is necessary that the relevant EANs are known within MeterInsight.
The file name must contain the EAN number of the meter, followed by the product type. This helps us to correctly assign the data.
File name format:
<ean>_<product>.csv
Examples:
871685920000000001_electricity.csv871685920000000001_gas.csv871685920000000001_cold.csv871685920000000001_heat.csv871685920000000001_water.csvWe use the following units by default, depending on the product:
| Product | Unit |
|---|---|
| electricity | kWh |
| gas | m³ |
| cold | GJ |
| heat | GJ |
| water | m³ |
;)dd-MM-yyyy HH:mm (e.g. 01-02-2025 00:00)d-M-yyyy HH:mm (e.g. 1-2-2025 00:00)yyyy-MM-dd HH:mm (e.g. 2025-02-01 00:00),) and period (.) are acceptedDateTime;Delivery
2025-02-01 00:00;0.00
DateTimeUtc;Delivery
2025-02-01 00:00;0.00
DateTime;Delivery;Return
2025-02-01 00:00;3.0;2.0
DateTimeUtc;Delivery;Return
2025-02-01 00:00;3.0;2.0
The following format can be used to supply daily readings from, for example, an analogue meter:
EAN;Datum;Stand levering dal;Stand levering piek;Stand teruglevering dal;Stand teruglevering piek
"871687140000000001";2024-01-01;12345;123;;
EAN;Date;Off-peak delivery reading;Peak return reading;Peak return reading);)dd-MM-yyyy (e.g. 01-02-2025)d-M-yyyy (e.g. 1-2-2025)yyyy-MM-dd (e.g. 2025-02-01)Do you want to supply periodic measurement data? This is possible via e-mail, but we need to configure the necessary settings for this.
Do you have any questions? Please contact us at support@meterinsight.com. We are happy to help you!