Energy dashboard - data not showing

[francsoitv]

First, thanks for your work!

I have setup this addon and It works, I receive all the data :

But when I try to add it to the energy dashboard, nothing shows on the graph (0kWh every day, every month, ...)

I tried with the alias, both kWh and m3, nothing seems to enable the data ingestion

I don't see any logs that might help me..

HA 2024.10.0

[ssenart]

Hello, the data start to feed the energy dashboard from the time you set it up.

You won't get the past data.

[C-Duv]

Do you know any way to insert those old values manually?

[francsoitv]

Ok thanks!
+1 i'd love to be able to get history

If that's of any help, it's possible for Linky (https://github.com/bokub/ha-linky)

[C-Duv]

Too bad ha-linky is not in Python, it would have been easy to mimic the feature.

[francsoitv]

So I'm trying to get the history myself, with these steps:

• Download the raw daily data from GRDF ("Donnees_informatives_xxx.csv")

• Convert it into a CSV to import into the SQL database

With metadata_id = the ID of sensor.gazpar in the statistics_metadata table
Be careful to put everything in the same metrics, kWh only in my case. I had to average the m3<>kWh conversion so that I can use the total m3

I'm still struggling with the new data, it seems that there is confusion between state column (which should be differential) and sum column (which should be total)