Help in developing custom e-Distribuzione integration

Development
,
1

Hi All,

I hope this is the correct place to post this; if not, I’m sorry and I ask the mod to move this post to the correct place.

I looked for a very long time for a way to track my home consumption in Home Assistant, unfortunately I am renting and thus I cannot install a reader like a Shelly or similar and neither I can attach a reader to the meter outside my apartment.

I have discovered that the distributor in my area (e-Distribuzione) does have a website on which you can see the energy consumption day by day independently by your end provider and download a CSV file composed of all consumption divided by day and in blocks of 15 minutes (like from 00:00 to 00:15, 00:15 to 00:30 and so on)

I have easily developed a simple script that goes trough the file and get the data for each minute and I would love to integrate that into Home Assistant but after reading the documentation I’m sure that is way above my code knowledge and I need help.
Here an example of how I have structured the output data but it can be easily changed if needed:
20_14-44-46_WindowsTerminal-Prompt_dei_comandi

This solution is not perfect as you need to manually provide the file when you want to update the data on Home Assistant as well as only being able to see the data on the website 24 hours later; but I believe that for many people based in Italy like me this is as good as we can get without buying some dedicated hardware, as I have failed to find any provider that allowed any kind of API or integration.

Hope someone could help me understand how to move from a simple script to something that can actually be integrated.

Thanks a lot,
Gianlu

2

Hi @GianlucaUlivi, if I understand you correctly this would require some additional support from within Home Assistant, as there is currently (at least as far as I know) no way to import data into the past.

3

This integration can import a CSV into the long term statistics, if you can convert your data in the required format.
But you would need to filter/merge the rows to be hourly, not quarterly; also I think it expects an increasing value, not partial sums.

Apparently it uses the undocumented function async_add_external_statistics, if you want to create an integration to import directly from the website without having to download and convert the file manually each time.

I also have e-Distribuzione, but right now I am unable to register to the website and check the source CSV myself.
Can you provide a few rows sample of the original data?

4

Hi there,
Sorry I missed your reply.

In the meantime I bought a meter and I’m using that.
Here is the CSV for a few days as and example for you:

Giorno;00:00-00:15;00:15-00:30;00:30-00:45;00:45-01:00;01:00-01:15;01:15-01:30;01:30-01:45;01:45-02:00;02:00-02:15;02:15-02:30;02:30-02:45;02:45-03:00;03:00-03:15;03:15-03:30;03:30-03:45;03:45-04:00;04:00-04:15;04:15-04:30;04:30-04:45;04:45-05:00;05:00-05:15;05:15-05:30;05:30-05:45;05:45-06:00;06:00-06:15;06:15-06:30;06:30-06:45;06:45-07:00;07:00-07:15;07:15-07:30;07:30-07:45;07:45-08:00;08:00-08:15;08:15-08:30;08:30-08:45;08:45-09:00;09:00-09:15;09:15-09:30;09:30-09:45;09:45-10:00;10:00-10:15;10:15-10:30;10:30-10:45;10:45-11:00;11:00-11:15;11:15-11:30;11:30-11:45;11:45-12:00;12:00-12:15;12:15-12:30;12:30-12:45;12:45-13:00;13:00-13:15;13:15-13:30;13:30-13:45;13:45-14:00;14:00-14:15;14:15-14:30;14:30-14:45;14:45-15:00;15:00-15:15;15:15-15:30;15:30-15:45;15:45-16:00;16:00-16:15;16:15-16:30;16:30-16:45;16:45-17:00;17:00-17:15;17:15-17:30;17:30-17:45;17:45-18:00;18:00-18:15;18:15-18:30;18:30-18:45;18:45-19:00;19:00-19:15;19:15-19:30;19:30-19:45;19:45-20:00;20:00-20:15;20:15-20:30;20:30-20:45;20:45-21:00;21:00-21:15;21:15-21:30;21:30-21:45;21:45-22:00;22:00-22:15;22:15-22:30;22:30-22:45;22:45-23:00;23:00-23:15;23:15-23:30;23:30-23:45;23:45-00:00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"01/10/2025;""0","114"";""0","136"";""0","142"";""0","11"";""0","11"";""0","11"";""0","109"";""0","138"";""0","139"";""0","111"";""0","109"";""0","11"";""0","11"";""0","139"";""0","133"";""0","11"";""0","165"";""0","416"";""0","13"";""0","142"";""0","132"";""0","11"";""0","109"";""0","109"";""0","109"";""0","139"";""0","128"";""0","108"";""0","109"";""0","107"";""0","111"";""0","14"";""0","146"";""0","093"";""0","039"";""0","349"";""0","363"";""0","379"";""0","355"";""0","349"";""0","352"";""0","351"";""0","3"";""0","076"";""0","054"";""0","045"";""0","05"";""0","071"";""0","093"";""0","097"";""0","061"";""0","049"";""0","047"";""0","149"";""0","093"";""0","084"";""0","059"";""0","06"";""0","048"";""0","051"";""0","078"";""0","065"";""0","045"";""0","045"";""0","045"";""0","053"";""0","076"";""0","063"";""0","12"";""0","378"";""0","111"";""0","087"";""0","084"";""0","054"";""0","053"";""0","046"";""0","057"";""0","389"";""0","121"";""0","062"";""0","063"";""0","062"";""0","067"";""0","098"";""0","087"";""0","069"";""0","068"";""0","065"";""0","344"";""0","283"";""0","039"";""0","037"";""0","038"";""0","047"";""0","066"";""0","05"";"
"02/10/2025;""0","033"";""0","032"";""0","033"";""0","05"";""0","064"";""0","044"";""0","032"";""0","033"";""0","034"";""0","052"";""0","062"";""0","315"";""0","078"";""0","032"";""0","032"";""0","055"";""0","062"";""0","035"";""0","033"";""0","032"";""0","032"";""0","056"";""0","061"";""0","032"";""0","033"";""0","033"";""0","033"";""0","057"";""0","061"";""0","031"";""0","032"";""0","032"";""0","035"";""0","06"";""0","061"";""0","05"";""0","034"";""0","034"";""0","034"";""0","057"";""0","219"";""0","307"";""0","035"";""0","055"";""0","094"";""0","072"";""0","079"";""0","052"";""0","047"";""0","047"";""0","048"";""0","052"";""0","269"";""0","412"";""0","36"";""0","363"";""0","645"";""0","619"";""0","375"";""0","362"";""0","352"";""0","339"";""0","359"";""0","366"";""0","346"";""0","337"";""0","168"";""0","06"";""0","08"";""0","092"";""0","069"";""0","061"";""0","038"";""0","104"";""0","339"";""0","062"";""0","317"";""0","15"";""0","07"";""0","073"";""0","095"";""0","07"";""0","041"";""0","341"";""0","405"";""0","179"";""0","092"";""0","06"";""0","046"";""0","044"";""0","054"";""0","077"";""0","057"";""0","046"";""0","064"";""0","464"";"
"03/10/2025;""0","45"";""0","166"";""0","116"";""0","114"";""0","107"";""0","116"";""0","135"";""0","117"";""0","11"";""0","104"";""0","1"";""0","124"";""0","131"";""0","1"";""0","098"";""0","098"";""0","289"";""0","528"";""0","428"";""0","407"";""0","339"";""0","097"";""0","106"";""0","127"";""0","111"";""0","098"";""0","096"";""0","098"";""0","114"";""0","089"";""0","036"";""0","03"";""0","031"";""0","031"";""0","055"";""0","059"";""0","031"";""0","03"";""0","031"";""0","031"";""0","062"";""0","051"";""0","03"";""0","03"";""0","03"";""0","039"";""0","061"";""0","044"";""0","03"";""0","03"";""0","031"";""0","045"";""0","06"";""0","038"";""0","03"";""0","031"";""0","03"";""0","051"";""0","059"";""0","033"";""0","029"";""0","092"";""0","088"";""0","055"";""0","057"";""0","031"";""0","03"";""0","03"";""0","031"";""0","058"";""0","055"";""0","03"";""0","03"";""0","03"";""0","03"";""0","059"";""0","054"";""0","029"";""0","03"";""0","03"";""0","03"";""0","06"";""0","053"";""0","03"";""0","03"";""0","041"";""0","067"";""0","061"";""0","053"";""0","03"";""0","03"";""0","03"";""0","029"";""0","06"";""0","055"";""0","029"";"
"04/10/2025;""0","03"";""0","03"";""0","03"";""0","055"";""0","058"";""0","03"";""0","03"";""0","03"";""0","029"";""0","052"";""0","059"";""0","091"";""0","03"";""0","029"";""0","03"";""0","046"";""0","06"";""0","038"";""0","03"";""0","03"";""0","03"";""0","04"";""0","06"";""0","042"";""0","029"";""0","03"";""0","03"";""0","034"";""0","06"";""0","049"";""0","029"";""0","03"";""0","031"";""0","031"";""0","059"";""0","055"";""0","03"";""0","031"";""0","03"";""0","03"";""0","056"";""0","058"";""0","031"";""0","029"";""0","03"";""0","03"";""0","054"";""0","059"";""0","031"";""0","03"";""0","03"";""0","031"";""0","053"";""0","06"";""0","031"";""0","03"";""0","03"";""0","03"";""0","08"";""0","109"";""0","03"";""0","03"";""0","03"";""0","03"";""0","052"";""0","059"";""0","031"";""0","03"";""0","03"";""0","03"";""0","052"";""0","06"";""0","032"";""0","029"";""0","03"";""0","03"";""0","051"";""0","06"";""0","033"";""0","03"";""0","029"";""0","03"";""0","052"";""0","06"";""0","033"";""0","07"";""0","099"";""0","099"";""0","095"";""0","06"";""0","034"";""0","03"";""0","03"";""0","029"";""0","052"";""0","061"";"
"05/10/2025;""0","031"";""0","03"";""0","03"";""0","03"";""0","052"";""0","061"";""0","031"";""0","03"";""0","03"";""0","03"";""0","053"";""0","07"";""0","099"";""0","099"";""0","047"";""0","03"";""0","052"";""0","063"";""0","031"";""0","03"";""0","03"";""0","03"";""0","049"";""0","06"";""0","034"";""0","029"";""0","03"";""0","03"";""0","045"";""0","06"";""0","038"";""0","03"";""0","031"";""0","03"";""0","042"";""0","061"";""0","041"";""0","03"";""0","03"";""0","029"";""0","042"";""0","061"";""0","042"";""0","03"";""0","031"";""0","03"";""0","041"";""0","062"";""0","043"";""0","029"";""0","03"";""0","03"";""0","042"";""0","061"";""0","041"";""0","031"";""0","029"";""0","03"";""0","045"";""0","06"";""0","04"";""0","03"";""0","03"";""0","03"";""0","045"";""0","061"";""0","038"";""0","03"";""0","03"";""0","03"";""0","046"";""0","06"";""0","037"";""0","03"";""0","03"";""0","03"";""0","048"";""0","06"";""0","036"";""0","03"";""0","03"";""0","03"";""0","052"";""0","06"";""0","033"";""0","03"";""0","03"";""0","03"";""0","057"";""0","058"";""0","03"";""0","03"";""0","03"";""0","031"";""0","062"";""0","053"";"

For e-Distribuzione, you have to register at Portale Clienti, it should be quite easy.