#Export data from all entities of a single device to csv-ish data format

1 messages · Page 1 of 1 (latest)

queen plaza
#
  • How could I go about to export all data from 1 device ( a good 100-ish entities ) to an excel, or probably first a CSV file?

2 years ago we got a whole new install of a heat pump with energy storage & some hybrid stuff, but I am fairly certain something is wrong with the heat pump, but I got told off by the installer/manufacturer everytime I tried to bring this up.
Now I started logging all data from the heat pump's modbus interface, and I can prove something is wrong (some sensors are stuck on 25ºC and the heat pump often falls in a case where it cycles on-off every 2-3 minutes, and buffer storage is completely ignored).

Of course the installer & manufacturer are not happy with just Home Assistant screenshots, they want an excel file.

Thanks in advance.

soft nest
#

The only export option I know of is in the energy dashboard.
A MySQL query could get these for you pretty easily.