It would be wonderful to be able to do a simple .csvc export from history. The History function has come a long way, and is terrific. I can easily select an entity and a date range, and it produces a nice graph. But there are times when I want to export that data to do further analysis. I know there are tools that can operate on my database, but it would be so much nicer to have an “Export to .csv” button added to the history graph!
Now that is a very interesting idea. That would have helped a lot back when I was debugging my outdoor PIRs and radars. So basically two columns, timestamp and states, maybe additional columns for the attributes, if any. Maybe the ability to combine multiple sensors in additional columns.
Hmm… Shouldn’t be too hard to implement
Something like this ?
The CSV file:
Time stamp,State
sensor.outside_temperature
2022-01-26 02:56:34,-1.7
2022-01-26 03:06:34,-1.8
2022-01-26 03:26:35,-1.9
2022-01-26 03:46:36,-2.0
2022-01-26 05:16:41,-2.1
2022-01-26 05:26:41,-2.2
2022-01-26 05:56:43,-2.1
2022-01-26 06:06:43,-2.2
2022-01-26 06:16:44,-2.3
2022-01-26 06:56:46,-2.4
2022-01-26 08:26:50,-2.3
2022-01-26 08:36:51,-2.4
2022-01-26 09:16:53,-2.2
2022-01-26 09:26:53,-2.3
2022-01-26 09:36:54,-2.1
person.alex
2022-01-26 00:00:00,home
2022-01-26 14:26:30,not_home
2022-01-26 17:34:11,arriving
2022-01-26 17:35:00,home
binary_sensor.internet_status
2022-01-26 00:00:00,on
weather.home
2022-01-26 00:00:00,cloudy
2022-01-26 00:03:56,partlycloudy
2022-01-26 02:57:59,cloudy
2022-01-26 03:56:00,sunny
2022-01-26 10:42:09,partlycloudy
2022-01-26 14:34:15,sunny
2022-01-26 15:32:16,partlycloudy
2022-01-26 18:26:20,sunny
2022-01-26 23:16:27,partlycloudy
input_select.qubino2_3
2022-01-26 00:00:00,Confort - 1
2022-01-26 05:27:10,Confort - 2
2022-01-26 06:04:11,Eco
Yup, exactly. There is a Notify function that allows me to log any entity to a CSV file, but that is not nearly as useful and friendly as having an Export CSV option in the history tab.
This looks like a duplicate of