Import old energy readings for use in energy dashboard

[klaj (Klaus Jandl)]

@brjhaverkamp

Based on the instructions of the integration however I already have two requests/comments. I think the “sum” column can be or even should be reconstructed completely after importing the data. Also for the already existing data. So you can leave it out of the CVS file and after importing the state values, the integration then should updat the sum values of the entire statistics table.
At least that is what I understood from this post Home Assistant SQlite - Change statistics data .

I do not think this is possible. Offline, with sqlite, yes. But online, when there are constantly new values coming in, the new values would lead to problems again. So, unfortunately, you have to calculate the sum as well (using negative values is totally fine, see somewhere here and also in the readme of the integration. In the backlog there is a feature request to automatically calculate the sum based on the last existing value, this I plan to do sometime.

@brjhaverkamp

Second request is to have an upload button in the integration. It is a minor thing, but it would look much more rounded if you don’t first have to upload the cvs seperately to the home assistant folder. Not sure how difficult that is though.

This would be possible for sure, I only do not know how. My integration just offers a HA service, and for file upload I probably would need a web server. If somebody has a better/simple idea, please let me know. But uploading the files can be done e.g. with Samba or via ssh/scp, so, as you said, thats a minor thing.

Sorry,
Klaus

[OCT0PUSCRIME]

Hi are you able to post your Node Red flow for this?

Thanks!