nodered receive mqtt message and save in csv

flow_mqtt_csv_2

[{"id":"22de6241.99d99e","type":"tab","label":"ReceiveMQTT","disabled":false,"info":""},{"id":"fa9bfea5.972ee","type":"mqtt in","z":"22de6241.99d99e","name":"","topic":"SCUTTLE/pi/cmd","qos":"2","datatype":"auto","broker":"1cc0cc73.690154","x":120,"y":80,"wires":[["721e0737.c93978","8d8ca943.671f88"]]},{"id":"721e0737.c93978","type":"csv","z":"22de6241.99d99e","name":"","sep":",","hdrin":false,"hdrout":"all","multi":"one","ret":"\\n","temp":"fieldA, fieldB","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":180,"y":180,"wires":[["cc5a197f.041b88","5895d1cf.f5221"]]},{"id":"cc5a197f.041b88","type":"file","z":"22de6241.99d99e","name":"","filename":"/home/pi/piScuttle/data3.csv","appendNewline":true,"createDir":true,"overwriteFile":"true","encoding":"none","x":350,"y":240,"wires":[[]]},{"id":"5895d1cf.f5221","type":"debug","z":"22de6241.99d99e","name":"debug3","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":310,"y":300,"wires":[]},{"id":"8d8ca943.671f88","type":"debug","z":"22de6241.99d99e","name":"debug2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":330,"y":100,"wires":[]},{"id":"1cc0cc73.690154","type":"mqtt-broker","z":"","name":"hiveMQ","broker":"broker.mqttdashboard.com","port":"1883","clientid":"","usetls":false,"compatmode":false,"keepalive":"60","cleansession":true,"birthTopic":"DPM/TEST","birthQos":"0","birthPayload":"pi_connected","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""}]

this video shows how the code is used.

https://youtu.be/4_rlm2HexTI