Fetching +A and -A profile datas

[wrobi]

[feature-request] Is there any way to process the 15-minute data? I mean the +A and -A profiles. I know they can be half a day late, but it would be nice to see the consumption and recharge data on the Home Assistant Energy Dashboard. BTW it's a very useful product, thanks a lot.

[ZsBT]

Yes I already wanted it to be implemented. There are a few concerns:

• EON however has the data in 15-min periods, it publishes them once or twice day on the Portal (they confirmed by email when I asked).
• HA does not support a sensor reading to be placed in the past (I already send attribute "last_updated" accordingly with this integration, no success)
• It could be achieved by inserting records directly to the database, which is quite dangerous. If I was able to do it correctly, a future HA release would break, which means the whole DB can be corrupted. This case, HA drops the db a creates a new one, meaning all historical data will be lost
• My best tip would be the History Stats feature, however that is a quite basic stuff probably not eligible (yet?) for energy measurements.

Overall, I won't give up. But, at least one or two of the abovements should improve to make something useful.

[wrobi]

I found this articles: https://community.home-assistant.io/t/import-old-energy-readings-for-use-in-energy-dashboard/341406/9 I hope it helps.

[ZsBT]

That looks promising; thanks a lot @wrobi for the finding. ( permalink for me to an example )

[wrobi]

It seems to be I implemented successfully, but it needs to be tested. You will find it on my fork (Nov 14th was a sunny day)

[wrobi]

I figured out the datas were offseted by 1 hour, so I fixed it. But I didn't find automatic solution to determine DST, Other things to do is to somehow determine the daily starting value and then add the changes. Yesterday we had a blackout at 8:30 to 10:00

[lazlykama]

@wrobi Looking great thank you your work. I hope @ZsBT merge this soon. :rocket: Now the energy dashboard looking very strange because the one spike in the middle of the night from the previous day, and because this the energy balance wrong too.

Are you sure it's avaiable for everybody? I can't dig 15 minutes data even from the official website. I found as +A and -A based on your sourcecode :+1:

The +1 hour probably not static, it's because Hungary not in daylight saving time at the moment ("winter time"), it should +2 in summer. So it's arrive in UTC time simple.

[wrobi]

We are working on it, but it's still in the testing phase and the code changes daily. Anyway, a bit pretentiously, we could say, like Szilárd Leó in the Manhattan Project: -We could also continue in Hungarian. :)

[ZsBT]

Discussing [HU]

[ZsBT]

• implemented by commit 9f23f227e449e17f5942495638e326c585ef27c8
• keeping open for a while

[lazlykama]

Thank you for your work, looks pretty awesome for me too. A new feature without extra hardware. :rocket:

But from other hand, looks like there is a huge spike for me in the very last "unmeasured" day in energy dashboard. It contain all the measures from the 0 kWh, when the meter was new. I attach screenshot from two following days how it's looks for me. Do you have similar problems too?

I tried to follow instructions from here, but I don't see anything in statistics page under dev functions.

[ZsBT]

(...) Do you have similar problems too?

Yes, unfortunately the start day of measurement looks like this, as Home Assistant does not support an "initial value" of a meter in statistics. Also, you can expect such a messy graph for every "today": EON publishes new data once a day in the early hours. But, at least it gets nice for the next day. For example, if you started using the "A" curve on 3rd of December and it is 9th of December, the graphs would be OK only from 2nd to 8th. On the next morning, 10th of December, graphs for 9th will be corrected. That is the least messy approach under these circumstances.

[lazlykama]

unfortunately the start day of measurement looks like this, as Home Assistant does not support an "initial value" of a meter in statistics

I'm wondering maybe we can define an intial shift in EON's site. If I understand right we could shift the measurement with a static value here:

[ZsBT]

I'm wondering maybe we can define an intial shift in EON's site. (...)

Offset seems to be a time shift instead :( According to the user manual,

Offset is a shift in the timeline of a report graph. Offset adjustment will
cause the movement of curve on the graph. It is possible to set a different
offset for each curve in a graph. Offset can be used for comparing data
curves in different time ranges.

[lazlykama]

I see. Thank you the info. Lets wait to add the missing initial value field inside HA in a future release.

[ZsBT]

closing as completed, listening to discussion https://github.com/ZsBT/hass-w1000-portal/discussions/8