Hello experts .. I am in a need of your guidance.
I created a simple flow by which i get the temperature data via MQTT broker and need to keep these data in excel file.. I create the flow and also implement the debug node to see whether the flow is ok or not.. it looks ok to me and file is also created in designated address but when i open the file it popups some alert and the the file show empty..
Here is a flow .. Can anyone guide me what's happening ?
[{"id":"3ee1387d.a79638","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"c7eb1b2.296a5e8","type":"mqtt in","z":"3ee1387d.a79638","name":"Motor Front Temperature","topic":"motor/fronttemperature","qos":"2","datatype":"auto","broker":"313d9abb.3bd086","x":110,"y":100,"wires":[["e198740f.e5aa98","2ce63582.d427aa","88a1888c.36bdd8"]]},{"id":"e198740f.e5aa98","type":"ui_chart","z":"3ee1387d.a79638","name":"Motor Front Temp","group":"e3c6e812.f530f8","order":3,"width":19,"height":5,"label":"Motor Front Temperature","chartType":"line","legend":"false","xformat":"D/M HH:mm","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"80","removeOlder":"1","removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"x":330,"y":60,"wires":[[]]},{"id":"2ce63582.d427aa","type":"ui_gauge","z":"3ee1387d.a79638","name":"Motor Front Temp","group":"e3c6e812.f530f8","order":1,"width":6,"height":5,"gtype":"gage","title":"Motor Front Tempeature","label":"oC","format":"{{value}}","min":"0","max":"80","colors":["#00b500","#e6e600","#ca3838"],"seg1":"40","seg2":"50","x":370,"y":100,"wires":[]},{"id":"88a1888c.36bdd8","type":"function","z":"3ee1387d.a79638","name":"Data","func":"var temperature = msg.payload\nvar d = new Date();\nvar t = d.toLocaleTimeString();\nvar m ={\"Time\" : t,\"Temperature\" :temperature};\nreturn {payload:m};\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":310,"y":140,"wires":[["635f545.ddfe9ac"]]},{"id":"635f545.ddfe9ac","type":"csv","z":"3ee1387d.a79638","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"one","ret":"\\n","temp":"Time,Temperature","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":140,"wires":[["febe10e0.5596b","d78b5c5e.29ffa"]]},{"id":"febe10e0.5596b","type":"file","z":"3ee1387d.a79638","name":"","filename":"D:\\Temperature\\temperature.xlsx","appendNewline":true,"createDir":false,"overwriteFile":"false","encoding":"none","x":680,"y":140,"wires":[[]]},{"id":"d78b5c5e.29ffa","type":"debug","z":"3ee1387d.a79638","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":700,"y":200,"wires":[]},{"id":"313d9abb.3bd086","type":"mqtt-broker","name":"mylaptop","broker":"192.168.12.140","port":"1883","clientid":"","usetls":false,"compatmode":false,"keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"e3c6e812.f530f8","type":"ui_group","name":"Blower 1","tab":"9de879d7.266968","order":1,"disp":true,"width":30,"collapse":false},{"id":"9de879d7.266968","type":"ui_tab","name":"Artos 3","icon":"dashboard","order":2,"disabled":false,"hidden":false}]
