Import 15 Minute Data

[GeraldPape]

Data is provided on the next day. So daily import of yesterdays 15 minute consumption data would be a nice feature.

[luchmhor]

This would be awesome. Looking forward :)

[weilix65]

Would be a great improvement :-)

[reox]

15min data is unfortunately impossible with the current HA API. Hourly data is the minimal timelength you can get... See also #9

[JinKanzaki]

I've made a terribly written python script that converts the export csv-file of the 15 minute data into the appropriate formatting for import into influxdb in case you use that. The script should also work for hourly data etc, but I'm too lazy to check.

Just name the export file "input.csv", run the script and import the output.csv into influxdb (Explore -> Write data with s precision) I should point out that since the script is crap it won't work if your export contains empty data (i.e. timestamps without energy data)

https://github.com/JinKanzaki/Wiener_Netze_Smart_Meter_InfluxDB_import/blob/main/00_wn_to_influxdb.py

[reox]

@JinKanzaki that is also a neat idea! It basically circumvents all the limitations of HA.

[luchmhor]

Wow, it would be awesome to see 15min (or 1h) values in HA.

[reox]

@luchmhor 1h is already working. with the builtin tools of HA 15min is currently not possible. If you need a high resolution, you should use the infrared dataport on the smartmeter itself.

[luchmhor]

@reox Ah, didn't know that. But how can iI configure the HA device to display 1h values? I only see the daily value.

[reox]

See the FAQ: https://github.com/DarwinsBuddy/WienerNetzeSmartmeter/discussions/19