I have a large number of event entries for my whole house energy monitor. I'm trying to copy this data for use in excel etc. Even copying to a text file would be fine. There seems to be ~200 entries a day for 7 or 8 days.
However I've only been able to capture a screen or couple of screen's worth of data at a time. If I try to copy more the browser freezes. I've tried MS Edge, Qpera & LibreWolf with the same results.
I can save the events as an HTML file (size about 6.1 Meg) however when I open it with any of the above browsers or MS word.
When I open the html in any browser it flashes the first page then goes to:
You could try Long Term Storage(LTS) in webcore. It will create a file as shown below that you could download off your HUB. It is just a text file.
The file in my case contains about 1000 data points and that is for 2 days. You can save up to a year or more but the file will get pretty big. This file according to the HUB file manager is 32K.
How about using Rule Machine to append a file?
I just tried it with my Aeotec HEM, which is taking a reading every 5 seconds.
Of course, I don't know how to get the seconds exposed, but maybe someone does.
Many users, including myself, use InfluxDB and Grafana running on an always-on local 'server'. I personally use a Home Assistant Yellow, with a 1TB NVME SSD drive, to run both InfluxDB and Grafana. I also use it to host Node-RED, NUT, and various local HomeKit devices (to allow them to be used locally with Hubitat.)
I figured out I could make several local variables and log them to a local file at a time interval I choose. I chose every10 seconds. However, I have the device basically geared towards power logging, every 5 seconds, and energy, every 10 minutes, with the other parameters turned off. It does seem possible though. I thought it was interesting, and who knows, maybe I will use it in the future, lol.
