Export CSV files based on 1st of Month

[Michilson]

Hello all,

I am a new Node Red User and I am looking to export/log sensor data to a CSV file. I'd like to start a new file on the 1st of each month.

The flow show posts data every 15 min. currently temp and humidity.

I'd like for the file to include all header data, (Date/Time, Temp, Humidity) and the File Name to be Year Month. ie (2020-April-Irrigation History.csv)

Can someone please help me to trigger the Template file, Adjust the Name, And move the file into a separate Directory. for the CSV export.

Node Red is running on Rasberry Pi, Sensor Data is from MQTT.

Thanks for the help.
Mike C

[Bobo]

To start, have you had a look at any of the scheduling nodes to determine which would suit your needs? There are quite a few to choose from.

[Steve-Mcl]

@Michilson

Can someone please help me to trigger the Template

node-red-contrib-cron-plus or node-red-contrib-bigtimer or inject node

@Michilson

Adjust the Name

change node or function node

@Michilson

And move the file into a separate Directory

node-red-contrib-fs-ops

[Andrei]

Additionally to the previous replies. You could use a change node with below configuration to generate the dynamic file name (required by the file node).