Write data to csv files and store in Network drive

[mauerwinkel (Holger)]

Hi,

I want to collect data from HA sensors into csv-files and store those in a defined network drive. The storage should be done automatically every week into file looking like this: data$YY$WW.csv. The file structure should be: Date, Sensor1, Sensor2, … with a header description. A Network drive is already there. Does anybody can provide a script for this? Thanks,

Holger

[tom_l]

How do I create a CSV file and append values to it?

Use the file notification service: notify: - name: write_to_csv platform: file filename: my_csv_file.csv In use: action: - service: notify.write_to_csv data: message: "some,csv,data,to,write,here" You can use templates in the message, e.g. action: - service: notify.write_to_csv data: message: "{{ now(),states('sensor.temperature'),states('sensor.humidity') }}"

[mauerwinkel (Holger)]

OK, thanks, understand so far. But how do I realize, saving all data from the specified sensors of the last week?

[tom_l]

What do you mean by:

@mauerwinkel

of the last week?

This method writes data when you call the service. You can do this using an automation and a time pattern trigger. It can only write current data. Not data from the past.

[CaptTom (Tom)]

You can accumulate data over time with history_stats.

I’m not sure what you’re after, but for example I accumulate my heating system oil burner runtime, along with the runtime for each heating and cooling zone. These all go into csv files. I track each on/off event, as well as a daily summery of run-time for each entity.

I’ve posted some of this process before. There are a couple of posts in this thread which might help explain what I’m doing.