I ported a flow from a raspi to a pc running unix mint.
I get the below error when acessing this CSV file.
Error: EACCES: permission denied, open '/home/hannes/standard-temp.CSV'
The file has read and write access enabled.
I am new to unix and know that there are groups and owners but don't know how to fiyx it.
Which user is running node-red (where is the .node-red folder located)?
in a terminal can you run
ls -l /home/hannes/standard-temp.CSV
Post the result including the command please.
Also show us the code or node configuration trying to access it please. Did you have to change anything in the flow related to this when you ported it?
By the way, it is Linux Mint, Unix is different.
yes, of course it is linux mint. sorry!
hannes@hannes-GA-890GPA-UD3H:~$ ls -l /home/hannes/standard-temp.CSV
-rw-rw-rw- 1 hannes hannes 3937 Mai 13 2020 /home/hannes/standard-temp.CSV
hannes@hannes-GA-890GPA-UD3H:~$
no, I did not change anything. As long as there is no file access it works perfectly.
Can you stop node red and start it again in a terminal please, and post the startup log up to the point of failure. If you installed using the recommended method you can stop/start using
node-red-stop
node-red-start
Hi Colin,
most probabely I have made a wrong installation of Node-RED.
I am going to reinstall mint on my PC (not a big problem as I only tried node-red until now on this PC)
Will let you know if this will have been successful.
regards Hannes
the new installation of linux mint was successful!
my flow works.
I actually enhanced cron-plus to load my heating profiles from a CSV file which are currently hard coded in my heating system. With this flow I can load and change the profiles without redeploying my heating application.
[{"id":"2ef07d68.54d3f2","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"acef56ea.c42488","type":"ui_text","z":"2ef07d68.54d3f2","group":"51478d85.3cb7d4","order":5,"width":"12","height":"1","name":"CRON Description","label":"Expression Description (updates as you type)...","format":"{{msg.payload.result.description}}","layout":"col-center","x":910,"y":500,"wires":[]},{"id":"b5248dbd.48a63","type":"cronplus","z":"2ef07d68.54d3f2","name":"","outputField":"payload","timeZone":"Europe/Berlin","outputs":1,"options":[],"x":700,"y":500,"wires":[["acef56ea.c42488"]]},{"id":"83738d35.ed41c","type":"function","z":"2ef07d68.54d3f2","name":"describe cmd","func":"msg.payload = {\n \"command\": \"describe\",\n \"expression\": msg.payload\n}\nreturn msg;","outputs":1,"noerr":0,"x":510,"y":500,"wires":[["b5248dbd.48a63"]]},{"id":"9bc4b55b.8b98f8","type":"change","z":"2ef07d68.54d3f2","name":"","rules":[{"t":"set","p":"ui_add_schedule_name","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":570,"y":380,"wires":[[]]},{"id":"1a505206.b47bce","type":"change","z":"2ef07d68.54d3f2","name":"","rules":[{"t":"set","p":"ui_add_schedule_payload","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":580,"y":420,"wires":[[]]},{"id":"4a924196.c339c","type":"change","z":"2ef07d68.54d3f2","name":"","rules":[{"t":"set","p":"ui_add_schedule_expression","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":590,"y":460,"wires":[[]]},{"id":"bfbb0bdf.32a568","type":"change","z":"2ef07d68.54d3f2","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"{}","tot":"json"},{"t":"set","p":"payload.payload","pt":"msg","to":"ui_add_schedule_payload","tot":"flow"},{"t":"set","p":"payload.name","pt":"msg","to":"ui_add_schedule_name","tot":"flow"},{"t":"set","p":"payload.expression","pt":"msg","to":"ui_add_schedule_expression","tot":"flow"},{"t":"set","p":"payload.command","pt":"msg","to":"add","tot":"str"},{"t":"set","p":"payload.type","pt":"msg","to":"str","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":380,"y":580,"wires":[["5d75bb51.5ba184","4767abc.f772054"]]},{"id":"5d75bb51.5ba184","type":"cronplus","z":"2ef07d68.54d3f2","name":"","outputField":"payload","timeZone":"Europe/Berlin","outputs":1,"options":[],"x":720,"y":580,"wires":[["420adf6f.c1cda","b973b0ae.b1728"]]},{"id":"a8fef294.b767e","type":"ui_toast","z":"2ef07d68.54d3f2","position":"top right","displayTime":"3","highlight":"","sendall":true,"outputs":0,"ok":"OK","cancel":"","topic":"","name":"","x":990,"y":660,"wires":[]},{"id":"420adf6f.c1cda","type":"switch","z":"2ef07d68.54d3f2","name":"1=Cron Event 2=List Results ","property":"cronplus.triggerTimestamp","propertyType":"msg","rules":[{"t":"nnull"},{"t":"else"}],"checkall":"true","repair":false,"outputs":2,"x":740,"y":680,"wires":[["a8fef294.b767e"],["54267582.ed464c"]]},{"id":"fa7ff821.1cc168","type":"catch","z":"2ef07d68.54d3f2","name":"","scope":null,"uncaught":false,"x":160,"y":1020,"wires":[["a3f45a37.5e4e98","a4a3176.66ddee8"]]},{"id":"a3f45a37.5e4e98","type":"ui_toast","z":"2ef07d68.54d3f2","position":"top right","displayTime":"3","highlight":"red","outputs":0,"ok":"OK","cancel":"","topic":"Error...","name":"","x":370,"y":1020,"wires":[]},{"id":"4767abc.f772054","type":"ui_button","z":"2ef07d68.54d3f2","name":"Refresh","group":"51478d85.3cb7d4","order":4,"width":"4","height":"1","passthru":true,"label":"Refresh","tooltip":"Get status of jobs","color":"","bgcolor":"","icon":"fa-refresh","payload":"{\"command\":\"list-all\"}","payloadType":"json","topic":"","x":560,"y":600,"wires":[["5d75bb51.5ba184"]]},{"id":"af117a11.770138","type":"ui_text_input","z":"2ef07d68.54d3f2","name":"","label":"Expression","tooltip":"CRON expression or date/csv list of dates","group":"51478d85.3cb7d4","order":8,"width":"4","height":"1","passthru":true,"mode":"text","delay":"100","topic":"","x":330,"y":460,"wires":[["83738d35.ed41c","4a924196.c339c"]]},{"id":"4bdc8bc2.2be154","type":"ui_text_input","z":"2ef07d68.54d3f2","name":"","label":"Name","tooltip":"Schedule Name","group":"51478d85.3cb7d4","order":7,"width":"4","height":"1","passthru":true,"mode":"text","delay":"100","topic":"","x":310,"y":380,"wires":[["9bc4b55b.8b98f8"]]},{"id":"d11d2c6b.d0426","type":"ui_button","z":"2ef07d68.54d3f2","name":"","group":"51478d85.3cb7d4","order":10,"width":"4","height":"1","passthru":false,"label":"Add line","tooltip":"Add or update named schedule","color":"","bgcolor":"","icon":"send","payload":"","payloadType":"str","topic":"","x":180,"y":600,"wires":[["bfbb0bdf.32a568"]]},{"id":"71d201d6.b6045","type":"ui_text_input","z":"2ef07d68.54d3f2","name":"","label":"Payload","tooltip":"Payload to send when schedule fires","group":"51478d85.3cb7d4","order":9,"width":"4","height":"1","passthru":true,"mode":"text","delay":"100","topic":"","x":320,"y":420,"wires":[["1a505206.b47bce"]]},{"id":"e4d48888.531608","type":"ui_template","z":"2ef07d68.54d3f2","group":"51478d85.3cb7d4","name":"","order":11,"width":"16","height":"14","format":"<style type=\"text/css\">\n.t1 {border-collapse:collapse;border-spacing:0;border-color:#ccc;}\n.t1 td{font-family:Arial, sans-serif;font-size:14px;padding:8px 3px;border-style:solid;border-width:0px;overflow:hidden;word-break:normal;border-top-width:1px;border-bottom-width:1px;border-color:#ccc;color:#333;background-color:#fff;}\n.t1 th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:#ccc;color:#333;background-color:#f0f0f0;}\n.t1 .t1-36r9{background-color:#000000;color:#ffffff;text-align:left;vertical-align:top}\n.t1 .t1-x2zo{background-color:#c0c0c0;font-size:small;text-align:left;vertical-align:top}\n.t1 .t1-o73e{background-color:#c0c0c0;font-size:small;text-align:center;vertical-align:top}\n.t1 .t1-5qt9{font-size:small;text-align:left;vertical-align:top}\n.t1 .t1-5qta{font-size:small;text-align:center;vertical-align:middle}\n</style>\n<table class=\"t1\">\n <tr>\n <th class=\"t1-36r9\" colspan=\"9\">CRON Schedules</th>\n </tr>\n <tr>\n <td class=\"t1-x2zo\">Name</td>\n <td class=\"t1-x2zo\">Expression</td>\n <td class=\"t1-x2zo\">Payload</td>\n <td class=\"t1-x2zo\">Description</td>\n <td class=\"t1-x2zo\">Next run</td>\n <td class=\"t1-x2zo\">State</td>\n <td class=\"t1-o73e\">Delete</td>\n <td class=\"t1-o73e\">Pause</td>\n <td class=\"t1-o73e\">Resume</td>\n </tr>\n <tr ng-repeat=\"item in msg.payload\">\n <td class=\"t1-5qt9\">{{item.config.name}}</td>\n <td class=\"t1-5qt9\" style=\"white-space: nowrap\" nowrap>{{item.config.expression}}</td>\n <td class=\"t1-5qt9\">{{item.config.payload}}</td>\n <td class=\"t1-5qt9\">{{item.status.description}}</td>\n <td class=\"t1-5qt9\">{{item.status.nextDescription}}</td>\n <td class=\"t1-5qta\"><i class=\"fa fa-{{item.status.isRunning ? 'play' : 'pause'}}\"> </i></td>\n\n <td class=\"t1-5qta\">\n <md-button class=\"md-raised\"\n ng-click=\"send([[{payload:{command:'remove', name: item.config.name}}, {payload:{command:'list-all'}}]]);\"> <i class=\"fa fa-trash\"> </i></md-button>\n </td>\n <td class=\"t1-5qta\">\n <md-button class=\"button\" \n ng-click=\"send([[{payload:{command:'pause', name: item.config.name}}, {payload:{command:'list-all'}}]]);\"> <i class=\"fa fa-pause\"> </i></md-button>\n </td>\n <td class=\"t1-5qta\">\n <md-button class=\"button\" \n ng-click=\"send([[{payload:{command:'start', name: item.config.name}}, {payload:{command:'list-all'}}]]);\"> <i class=\"fa fa-play\"> </i></md-button>\n </td>\n\n </tr>\n\n </tbody>\n</table>\n\n<!--<table id=\"table\" class=\"table table-striped table-responsive-md btn-table\" >-->\n<!-- <tr>-->\n<!-- <th>Name</th> -->\n<!-- <th>Expression</th> -->\n<!-- <th>Payload</th> -->\n<!-- <th>Description</th>-->\n<!-- <th>Next run</th>-->\n<!-- <th>State</th>-->\n<!-- <th>Delete</th>-->\n<!-- <th>Pause</th>-->\n<!-- <th>Resume</th>-->\n<!-- </tr>-->\n<!-- <tbody>-->\n<!-- <tr ng-repeat=\"item in msg.payload\">-->\n<!-- <td >{{item.config.name}}</td>-->\n<!-- <td style=\"white-space: nowrap\" nowrap>{{item.config.expression}}</td>-->\n<!-- <td >{{item.config.payload}}</td>-->\n<!-- <td >{{item.status.description}}</td>-->\n<!-- <td >{{item.status.nextDescription}}</td>-->\n<!-- <td >{{item.status.isRunning ? 'Running' : 'Paused'}}</td>-->\n<!-- <td>-->\n<!-- <md-button class=\"md-raised\"-->\n<!-- ng-click=\"send([[{payload:{command:'remove', name: item.config.name}}, {payload:{command:'list-all'}}]]);\"> <i class=\"fa fa-trash\"> </i></md-button>-->\n<!-- </td>-->\n<!-- <td>-->\n<!-- <md-button class=\"button\" -->\n<!-- ng-click=\"send([[{payload:{command:'pause', name: item.config.name}}, {payload:{command:'list-all'}}]]);\"> <i class=\"fa fa-pause\"> </i></md-button>-->\n<!-- </td>-->\n<!-- <td>-->\n<!-- <md-button class=\"button\" -->\n<!-- ng-click=\"send([[{payload:{command:'start', name: item.config.name}}, {payload:{command:'list-all'}}]]);\"> <i class=\"fa fa-play\"> </i></md-button>-->\n<!-- </td>-->\n<!-- </tr>-->\n<!-- </tbody>-->\n<!--</table>-->\n\n","storeOutMessages":false,"fwdInMessages":false,"templateScope":"local","x":1140,"y":700,"wires":[["e0b97f7d.c96ff"]]},{"id":"54267582.ed464c","type":"function","z":"2ef07d68.54d3f2","name":"Make table data","func":"if(!msg.payload || !msg.payload.result || !msg.payload.result.length){\n msg.payload = [];\n return msg;\n}\nmsg.payload = msg.payload.result;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":980,"y":700,"wires":[["e4d48888.531608"]]},{"id":"a4a3176.66ddee8","type":"debug","z":"2ef07d68.54d3f2","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":330,"y":1060,"wires":[]},{"id":"e0b97f7d.c96ff","type":"link out","z":"2ef07d68.54d3f2","name":"","links":["b9b9e3e3.d4933","9e6d5f7a.2e80e"],"x":1235,"y":700,"wires":[]},{"id":"c2324651.c0c7e8","type":"ui_template","z":"2ef07d68.54d3f2","group":"51478d85.3cb7d4","name":"CRON Info","order":12,"width":"16","height":"12","format":"<div>\n<pre>CRON Format...\n\n s m h md m wd y\n | | | | | | |\n * * * * * * * Field Allowed values Special symbols\n | | | | | | | ----------------- --------------- ---------------\n `--|--|--|--|--|--|-> Second (optional) 0-59 * / , -\n `--|--|--|--|--|-> Minute 0-59 * / , -\n `--|--|--|--|-> Hour 0-23 * / , -\n `--|--|--|-> Day of Month 1-31 * / , - L W\n `--|--|-> Month 1-12 or JAN-DEC * / , -\n `--|-> Day of Week 0-7 or SUN-SAT * / , - L #\n `-> Year (optional) 1970-2099 * / , -\n \n</pre> \n</div>\n\n<style type=\"text/css\">\n.t2 {border-collapse:collapse;border-spacing:0;border-color:#ccc;}\n.t2 td{font-family:Arial, sans-serif;font-size:14px;padding:2px 2px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:#ccc;color:#333;background-color:#fff;}\n.t2 th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:#ccc;color:#333;background-color:#f0f0f0;}\n.t2 .t2-dg6o{background-color:#000000;color:#ffffff;text-align:left;vertical-align:top}\n.t2 .t2-6e8n{font-weight:bold;background-color:#c0c0c0;border-color:inherit;text-align:left;vertical-align:top}\n.t2 .t2-0pky{border-color:inherit;text-align:left;vertical-align:top}\n</style>\n<table class=\"t2\">\n <tr>\n <th class=\"t2-dg6o\" colspan=\"2\">Example CRON Expressions</th>\n </tr>\n <tr>\n <td class=\"t2-6e8n\">Expression</td>\n <td class=\"t2-6e8n\">Description</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">* * * * * *</td>\n <td class=\"t2-0pky\">Every Second</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 * * * * *</td>\n <td class=\"t2-0pky\">Every minute</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 */10 * * * *</td>\n <td class=\"t2-0pky\">Every 10 minutes</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 */20 1 * * *</td>\n <td class=\"t2-0pky\">Every 20 minutes, between 01:00 AM and 01:59 AM</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 15,30,45 * * * *</td>\n <td class=\"t2-0pky\">At 15, 30, and 45 minutes past the hour</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 0 12 * * *</td>\n <td class=\"t2-0pky\">Every day at noon - 12pm</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 0 2 29 FEB * 2020-2040</td>\n <td class=\"t2-0pky\">At 02:00 AM, on day 29 of the month, only in February, every 4 years, 2020 through 2040</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 0 7 * *</td>\n <td class=\"t2-0pky\">MON#1 * At 07:00 AM, on the first Monday of the month</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 0 12 * JAN,FEB,MAR,APR *</td>\n <td class=\"t2-0pky\">Every day at noon in January, February, March and April</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">* * 1W * *</td>\n <td class=\"t2-0pky\">Every minute, on the first weekday of the month</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">* * * * Tue#3</td>\n <td class=\"t2-0pky\">Every minute, on the third Tuesday of the month</td>\n </tr>\n <tr>\n <td class=\"t2-0pky\">0 12 * * MONL</td>\n <td class=\"t2-0pky\">At 12:00 PM, on the last Monday of the month</td>\n </tr>\n</table>","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":1150,"y":740,"wires":[[]]},{"id":"9e6d5f7a.2e80e","type":"link in","z":"2ef07d68.54d3f2","name":"cron_in","links":["e0b97f7d.c96ff","7bf6d3d6.c6b13c","84847491.39a5f8"],"x":595,"y":560,"wires":[["5d75bb51.5ba184"]]},{"id":"2e359ee5.a71de2","type":"debug","z":"2ef07d68.54d3f2","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":1170,"y":580,"wires":[]},{"id":"aa4a9a34.79bc78","type":"file in","z":"2ef07d68.54d3f2","name":"","filename":"/home/hannes/standard-temp.CSV","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":420,"y":120,"wires":[["d8fc8eb9.2e946"]]},{"id":"d8fc8eb9.2e946","type":"csv","z":"2ef07d68.54d3f2","name":"","sep":";","hdrin":false,"hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"1","strings":true,"x":690,"y":120,"wires":[["9aafa63e.915ed8"]]},{"id":"91764fc7.ef4df","type":"inject","z":"2ef07d68.54d3f2","name":"","repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":180,"y":140,"wires":[["aa4a9a34.79bc78","71a000c9.4645b"]]},{"id":"a28121d6.75077","type":"function","z":"2ef07d68.54d3f2","name":"","func":"let msg1 = {};\nlet msg2 = {};\nlet c = flow.get('list_counter');\nc = c + 1;\nflow.set('list_counter',c);\nmsg1.payload = c;\nmsg2.payload = \"1\";\nreturn [msg1,msg2];","outputs":2,"noerr":0,"initialize":"","finalize":"","x":720,"y":320,"wires":[["af9adcb5.ce09e"],["c0fe1796.91ef48"]]},{"id":"a9564535.990f98","type":"link in","z":"2ef07d68.54d3f2","name":"","links":["c0fe1796.91ef48"],"x":215,"y":560,"wires":[["bfbb0bdf.32a568"]]},{"id":"c0fe1796.91ef48","type":"link out","z":"2ef07d68.54d3f2","name":"testload","links":["a9564535.990f98"],"x":835,"y":340,"wires":[]},{"id":"f150f131.ffddf","type":"delay","z":"2ef07d68.54d3f2","name":"","pauseType":"delay","timeout":"500","timeoutUnits":"milliseconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":510,"y":320,"wires":[["a28121d6.75077"]]},{"id":"74e9128b.1af06c","type":"function","z":"2ef07d68.54d3f2","name":"","func":"let name = msg.payload.col1;\nlet expression = msg.payload.col2;\nlet pload = msg.payload.col3;\nreturn [\n {payload:name},\n {payload:expression},\n {payload:pload}\n ];","outputs":3,"noerr":0,"initialize":"","finalize":"","x":310,"y":320,"wires":[["9bc4b55b.8b98f8","f150f131.ffddf"],["4a924196.c339c"],["1a505206.b47bce"]]},{"id":"9aafa63e.915ed8","type":"delay","z":"2ef07d68.54d3f2","name":"","pauseType":"rate","timeout":"5","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":890,"y":160,"wires":[["74e9128b.1af06c"]]},{"id":"b973b0ae.b1728","type":"switch","z":"2ef07d68.54d3f2","name":"string?","property":"payload","propertyType":"msg","rules":[{"t":"istype","v":"string","vt":"string"}],"checkall":"true","repair":false,"outputs":1,"x":910,"y":580,"wires":[["afde5118.54ce4"]]},{"id":"afde5118.54ce4","type":"json","z":"2ef07d68.54d3f2","name":"","property":"payload","action":"","pretty":false,"x":1030,"y":580,"wires":[["2e359ee5.a71de2"]]},{"id":"a483b764.b83798","type":"ui_button","z":"2ef07d68.54d3f2","name":"add standard list","group":"51478d85.3cb7d4","order":1,"width":"4","height":"1","passthru":false,"label":"add standard list","tooltip":"","color":"","bgcolor":"","icon":"send","payload":"","payloadType":"date","topic":"","x":160,"y":100,"wires":[["aa4a9a34.79bc78","71a000c9.4645b"]]},{"id":"26ae013.6b9cefe","type":"file in","z":"2ef07d68.54d3f2","name":"","filename":"/home/pi/Temp_Tabelle/standard-temp.CSV","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":450,"y":800,"wires":[["c0f1c6cc.7093c8"]]},{"id":"c0f1c6cc.7093c8","type":"csv","z":"2ef07d68.54d3f2","name":"","sep":";","hdrin":false,"hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"1","strings":true,"x":690,"y":800,"wires":[["793ce45b.a57f9c"]]},{"id":"944256ae.1ddfb8","type":"inject","z":"2ef07d68.54d3f2","name":"","repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":180,"y":820,"wires":[["26ae013.6b9cefe"]]},{"id":"793ce45b.a57f9c","type":"delay","z":"2ef07d68.54d3f2","name":"","pauseType":"rate","timeout":"5","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":860,"y":800,"wires":[["47f8cdd4.8f00b4"]]},{"id":"d72f0274.cc5d4","type":"ui_button","z":"2ef07d68.54d3f2","name":"delete_list","group":"51478d85.3cb7d4","order":3,"width":"4","height":"1","passthru":false,"label":"delete all","tooltip":"","color":"","bgcolor":"","icon":"send","payload":"","payloadType":"date","topic":"","x":180,"y":780,"wires":[["5da48bbe.c6a1c4"]]},{"id":"47f8cdd4.8f00b4","type":"function","z":"2ef07d68.54d3f2","name":"","func":"let name = msg.payload.col1;\nlet expression = msg.payload.col2;\nlet pload = msg.payload.col3;\nreturn {payload:{\"command\":\"remove\", \"name\":name}};\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":280,"y":880,"wires":[["f51c04d2.6bbd28","7bf6d3d6.c6b13c"]]},{"id":"7bf6d3d6.c6b13c","type":"link out","z":"2ef07d68.54d3f2","name":"","links":["9e6d5f7a.2e80e"],"x":935,"y":880,"wires":[]},{"id":"e7daf5b7.c21058","type":"function","z":"2ef07d68.54d3f2","name":"","func":"return{payload:{\"command\":\"list-all\"}};","outputs":1,"noerr":0,"initialize":"","finalize":"","x":810,"y":900,"wires":[["7bf6d3d6.c6b13c"]]},{"id":"f51c04d2.6bbd28","type":"delay","z":"2ef07d68.54d3f2","name":"","pauseType":"delay","timeout":"250","timeoutUnits":"milliseconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":490,"y":900,"wires":[["e7daf5b7.c21058"]]},{"id":"1932e90b.488647","type":"file in","z":"2ef07d68.54d3f2","name":"","filename":"/home/hannes/gaeste-temp.CSV","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":410,"y":200,"wires":[["12777159.dd25cf"]]},{"id":"12777159.dd25cf","type":"csv","z":"2ef07d68.54d3f2","name":"","sep":";","hdrin":false,"hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"1","strings":true,"x":690,"y":200,"wires":[["9aafa63e.915ed8"]]},{"id":"61f7dcd6.028a64","type":"inject","z":"2ef07d68.54d3f2","name":"","repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":180,"y":220,"wires":[["1932e90b.488647","71a000c9.4645b"]]},{"id":"e3413521.a001a8","type":"ui_button","z":"2ef07d68.54d3f2","name":"add gaeste list","group":"51478d85.3cb7d4","order":2,"width":"4","height":"1","passthru":false,"label":"add gaeste list","tooltip":"","color":"","bgcolor":"","icon":"send","payload":"","payloadType":"date","topic":"","x":160,"y":180,"wires":[["1932e90b.488647","71a000c9.4645b"]]},{"id":"5da48bbe.c6a1c4","type":"function","z":"2ef07d68.54d3f2","name":"","func":"return{payload:{\"command\":\"remove-all\"}};","outputs":1,"noerr":0,"initialize":"","finalize":"","x":370,"y":740,"wires":[["84847491.39a5f8","917f8c5f.a35bb"]]},{"id":"917f8c5f.a35bb","type":"delay","z":"2ef07d68.54d3f2","name":"","pauseType":"delay","timeout":"2","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":360,"y":700,"wires":[["82029ab8.ee5148"]]},{"id":"84847491.39a5f8","type":"link out","z":"2ef07d68.54d3f2","name":"","links":["9e6d5f7a.2e80e"],"x":475,"y":740,"wires":[]},{"id":"71a000c9.4645b","type":"change","z":"2ef07d68.54d3f2","name":"","rules":[{"t":"set","p":"list_counter","pt":"flow","to":"0","tot":"num"}],"action":"","property":"","from":"","to":"","reg":false,"x":380,"y":160,"wires":[[]]},{"id":"af9adcb5.ce09e","type":"ui_text","z":"2ef07d68.54d3f2","group":"51478d85.3cb7d4","order":6,"width":"4","height":"1","name":"","label":"ADDED LINES","format":"{{msg.payload}}","layout":"row-spread","x":900,"y":300,"wires":[]},{"id":"82029ab8.ee5148","type":"function","z":"2ef07d68.54d3f2","name":"","func":"return{payload:\"0\"};","outputs":1,"noerr":0,"initialize":"","finalize":"","x":370,"y":660,"wires":[["a66c050.f2ba8f8","4767abc.f772054"]]},{"id":"a66c050.f2ba8f8","type":"link out","z":"2ef07d68.54d3f2","name":"","links":["a2cc8e55.ae549"],"x":495,"y":660,"wires":[]},{"id":"a2cc8e55.ae549","type":"link in","z":"2ef07d68.54d3f2","name":"counter","links":["a66c050.f2ba8f8"],"x":675,"y":280,"wires":[["af9adcb5.ce09e"]]},{"id":"51478d85.3cb7d4","type":"ui_group","name":"Default","tab":"e9f13623.bea068","order":1,"disp":false,"width":"16","collapse":false},{"id":"e9f13623.bea068","type":"ui_tab","name":"CRON","icon":"dashboard","order":2,"disabled":false,"hidden":false}]
This is my standard CSV file:
standard-temp .txt (3.8 KB)
you have to change the extension back to CSV!
many thanks for your support!
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy