Write file node error when writing to an open csv file

No it does not lock up permanently. It only throws an error if the file is in use, as soon as you close the file in Excel/Calc, it appears to work as intended. Please DO NOT give incorrect information, unless your going to show us proof that it does in fact lock up.

@HaroldPetersInskipp, I presume that comment is addressed to @KarolisL

Strange that we have different behaviors then. Alarm:

failed to append to file: Error: EBUSY: resource busy or locked, open 'C:\Users\User\Desktop\CNC1234.csv'

is correct to show, because the file is open. I close excel, after repeated attempt I receive:

"failed to append to file: Error [ERR_STREAM_WRITE_AFTER_END]: write after end"

I attach a link to video file: WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free

Full flow:

[{"id":"db62fbb0a0e496a9","type":"ui_text_input","z":"fa5ad0aa4db28cdf","name":"VardasPavardė","label":"          VARDAS PAVARDĖ","tooltip":"","group":"6c68973a.b918d8","order":3,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":160,"y":120,"wires":[["2b1d6e87aba02064"]]},{"id":"1aa6671e36a12ac3","type":"ui_text_input","z":"fa5ad0aa4db28cdf","name":"","label":"  UŽSAKYMAS","tooltip":"Nr","group":"9c065d24d1bbc522","order":3,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":160,"y":160,"wires":[["85a648f2f0cef235"]]},{"id":"a8a10cc2.9d0ae","type":"ui_template","z":"fa5ad0aa4db28cdf","group":"9c065d24d1bbc522","name":"","order":1,"width":0,"height":0,"format":"<style>\nbody.nr-dashboard-theme {\n    font-size: 35px !important;\n}\n   \nbody.nr-dashboard-cardtitle {\n    font-size: 60px !important;\n}    \n</style>\n\n<!--class=\"nr-dashboard-cardtitle\"-->\n\n<style>\n.small p {font-size:100%;\n}\n.big p {font-size:150%;\n}\n.huge p {font-size:300%;\n}    \n</style>","storeOutMessages":true,"fwdInMessages":true,"resendOnRefresh":false,"templateScope":"local","x":900,"y":120,"wires":[[]]},{"id":"3fcf6c8d7005ab2f","type":"ui_text_input","z":"fa5ad0aa4db28cdf","name":"","label":"  SURINKIMO NR.","tooltip":"","group":"9c065d24d1bbc522","order":5,"width":0,"height":0,"passthru":true,"mode":"text","delay":300,"topic":"","x":170,"y":200,"wires":[["d7f097ef5f033095"]]},{"id":"87d5dd2e35caee04","type":"ui_text_input","z":"fa5ad0aa4db28cdf","name":"","label":"  SERIJOS NR.","tooltip":"","group":"9c065d24d1bbc522","order":7,"width":0,"height":0,"passthru":true,"mode":"number","delay":300,"topic":"","x":160,"y":260,"wires":[["794d894abf4126da"]]},{"id":"2de813204832e1b3","type":"inject","z":"fa5ad0aa4db28cdf","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"1","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":170,"y":20,"wires":[["38931350facda7c7"]]},{"id":"38931350facda7c7","type":"function","z":"fa5ad0aa4db28cdf","name":"Act time","func":"var now = new Date();\nvar timestamp = now.getFullYear() + (\"0\" + (now.getMonth() + 1)).slice(-2) + (\"0\" + now.getDate()).slice(-2) + \"  \" + (\"0\" + now.getHours()).slice(-2) + \":\" + (\"0\" + now.getMinutes()).slice(-2) + \":\" + (\"0\" + now.getSeconds()).slice(-2);\nmsg.payload = timestamp;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":340,"y":20,"wires":[["1524aa7641391298"]]},{"id":"1524aa7641391298","type":"ui_text","z":"fa5ad0aa4db28cdf","group":"6c68973a.b918d8","order":1,"width":0,"height":0,"name":"Laikas","label":"<font size = 5>Laikas:","format":"<font size = 5> {{msg.payload}}","layout":"row-spread","x":490,"y":20,"wires":[]},{"id":"c4b993dfcf1fb3d0","type":"ui_text_input","z":"fa5ad0aa4db28cdf","name":"","label":"  SPAUDIMAS","tooltip":"","group":"9c065d24d1bbc522","order":9,"width":0,"height":0,"passthru":true,"mode":"number","delay":300,"topic":"","x":150,"y":320,"wires":[["d5dad8882b5c5211"]]},{"id":"0ae9122b55a0f7ec","type":"ui_text_input","z":"fa5ad0aa4db28cdf","name":"","label":"  AUKŠTIS (mm)","tooltip":"","group":"9c065d24d1bbc522","order":11,"width":0,"height":0,"passthru":true,"mode":"number","delay":300,"topic":"","x":160,"y":360,"wires":[["400664c0d89b9845"]]},{"id":"95fb7f2243039991","type":"ui_text_input","z":"fa5ad0aa4db28cdf","name":"","label":"  JĖGA (bar)","tooltip":"","group":"9c065d24d1bbc522","order":13,"width":0,"height":0,"passthru":true,"mode":"number","delay":300,"topic":"","x":150,"y":400,"wires":[["e15eed234cf34d99"]]},{"id":"aa20d91b6b53ddc9","type":"ui_button","z":"fa5ad0aa4db28cdf","name":"","group":"9c065d24d1bbc522","order":15,"width":9,"height":2,"passthru":false,"label":"<font size=8>PATVIRTINTI","tooltip":"","color":"","bgcolor":"","icon":"","payload":"Confirm","payloadType":"str","topic":"","x":200,"y":520,"wires":[["ae3c7b3394965b47"]]},{"id":"c466a6a63246e65b","type":"inject","z":"fa5ad0aa4db28cdf","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":260,"y":480,"wires":[["ae3c7b3394965b47"]]},{"id":"85a648f2f0cef235","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"BATCH_NO","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":380,"y":160,"wires":[[]]},{"id":"d7f097ef5f033095","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"ASSEMBLY_NO","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":400,"y":200,"wires":[["4df5e3347aec4455"]]},{"id":"794d894abf4126da","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"SERIAL_NO","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":380,"y":260,"wires":[[]]},{"id":"d5dad8882b5c5211","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"PUSH_NO","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":380,"y":320,"wires":[[]]},{"id":"400664c0d89b9845","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"HEIGHT","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":370,"y":360,"wires":[[]]},{"id":"e15eed234cf34d99","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"PRESSURE","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":380,"y":400,"wires":[[]]},{"id":"3ca7695a74dc281a","type":"function","z":"fa5ad0aa4db28cdf","name":"Write first time with column names","func":"var NAME = global.get('ID')\nvar BATCH_NO = global.get('BATCH_NO');\nvar Assembly_NO = global.get('ASSEMBLY_NO');\nvar Dir = global.get('FileDir');\nvar Serial = global.get('SERIAL_NO');\nvar Height = global.get('HEIGHT');\nvar Pressure = global.get('PRESSURE')\nvar PushNo = global.get('PUSH_NO')\n\nvar now = new Date();\nvar timestamp = now.getFullYear() + \"-\" + (\"0\" + (now.getMonth() + 1)).slice(-2) + \"-\" + (\"0\" + now.getDate()).slice(-2) + \" \" + (\"0\" + now.getHours()).slice(-2) + \":\" + (\"0\" + now.getMinutes()).slice(-2) + \":\" + (\"0\" + now.getSeconds()).slice(-2);\n\nmsg.filename = Dir+BATCH_NO+\".csv\"\n\nmsg.payload = \"DATA\" + \",\" + \"ATLIKO\" + \",\" + \"UZSAKYMAS\" + \",\" + \"SURINKIMO NR\" + \",\" + \"SERIJOS NR\" + \",\" + \"AUKSTIS\" + \",\" + \"JEGA\" + \",\" + \"SPAUDIMAS\"+\"\\n\"+\n    timestamp + \",\" + NAME + \",\" + BATCH_NO + \",\" + Assembly_NO + \",\" + Serial + \",\" + Height + \",\" + Pressure + \",\" + PushNo;\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1020,"y":540,"wires":[["f0fdae733f96c3d2"]]},{"id":"f0fdae733f96c3d2","type":"file","z":"fa5ad0aa4db28cdf","name":"","filename":"filename","filenameType":"msg","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"ISO-8859-13","x":1260,"y":480,"wires":[["8032cf2e2075a734"]]},{"id":"ae3c7b3394965b47","type":"function","z":"fa5ad0aa4db28cdf","name":"GetFile Name","func":"var msg2 = {};\nvar msg1 = {};\nvar NAME = global.get('ID')\nvar BATCH_NO = global.get('BATCH_NO');\nvar Assembly_NO = global.get('ASSEMBLY_NO');\nvar Dir = global.get('FileDir');\nvar Serial = global.get('SERIAL_NO');\nvar Height = global.get('HEIGHT');\nvar Pressure = global.get('PRESSURE')\nvar PushNo = global.get('PUSH_NO')\n\nif (NAME != \"\" && BATCH_NO != \"\" && Assembly_NO > 0 && Serial > 0 && Pressure >0 )\n{\n    msg1.filename = Dir + BATCH_NO + \".csv\"\n    msg1.payload = \"Sukurtas naujas įrašas\";\n\n    node.send([msg1, null]);\n}\nelse\n{\n    msg2.payload = \"Nepilnai suvesti duomenys\"\n    node.send([null,msg2]);\n}","outputs":2,"noerr":0,"initialize":"","finalize":"","libs":[],"x":440,"y":480,"wires":[["eeb582058a3296c7","ad1fd8a8fd7c9e7f","551dab72ab486dae"],["eeb582058a3296c7"]]},{"id":"551dab72ab486dae","type":"file in","z":"fa5ad0aa4db28cdf","name":"","filename":"filename","filenameType":"msg","format":"utf8","chunk":false,"sendError":false,"encoding":"none","allProps":false,"x":640,"y":480,"wires":[["f8b54da71e191e5f"]]},{"id":"f8b54da71e191e5f","type":"switch","z":"fa5ad0aa4db28cdf","name":"","property":"payload","propertyType":"msg","rules":[{"t":"cont","v":"DATA","vt":"str"},{"t":"else"}],"checkall":"true","repair":false,"outputs":2,"x":790,"y":480,"wires":[["467c483d07ea4dde"],[]]},{"id":"467c483d07ea4dde","type":"function","z":"fa5ad0aa4db28cdf","name":"Write new line if Exists already","func":"var NAME = global.get('ID')\nvar BATCH_NO = global.get('BATCH_NO');\nvar Assembly_NO = global.get('ASSEMBLY_NO');\nvar Dir = global.get('FileDir');\nvar Serial = global.get('SERIAL_NO');\nvar Height = global.get('HEIGHT');\nvar Pressure = global.get('PRESSURE')\nvar PushNo = global.get('PUSH_NO')\n\nvar now = new Date();\nvar timestamp = now.getFullYear() + \"-\" + (\"0\" + (now.getMonth() + 1)).slice(-2) + \"-\" + (\"0\" + now.getDate()).slice(-2) + \" \" + (\"0\" + now.getHours()).slice(-2) + \":\" + (\"0\" + now.getMinutes()).slice(-2) + \":\" + (\"0\" + now.getSeconds()).slice(-2);\n\nmsg.filename = Dir + BATCH_NO + \".csv\"\n\nmsg.payload = timestamp + \",\" + NAME + \",\" + BATCH_NO + \",\" + Assembly_NO + \",\" + Serial + \",\" + Height + \",\" + Pressure + \",\" + PushNo;\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1010,"y":480,"wires":[["f0fdae733f96c3d2"]]},{"id":"6fd1bb199b5e91b2","type":"catch","z":"fa5ad0aa4db28cdf","name":"","scope":["551dab72ab486dae"],"uncaught":false,"x":790,"y":540,"wires":[["3ca7695a74dc281a"]]},{"id":"78412f107b653617","type":"inject","z":"fa5ad0aa4db28cdf","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"C:/Users/User/Desktop/","payloadType":"str","x":150,"y":80,"wires":[["9cc9ac3fd4a402e1"]]},{"id":"9cc9ac3fd4a402e1","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"FileDir","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":370,"y":80,"wires":[[]]},{"id":"8032cf2e2075a734","type":"file in","z":"fa5ad0aa4db28cdf","name":"","filename":"filename","filenameType":"msg","format":"utf8","chunk":false,"sendError":false,"encoding":"none","allProps":false,"x":1400,"y":480,"wires":[["2918850eb505b43b"]]},{"id":"2918850eb505b43b","type":"csv","z":"fa5ad0aa4db28cdf","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"mult","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":1270,"y":540,"wires":[["9b93eaed7bd635a2","d026765a9396f366","d1f3780b02ecf9d2"]]},{"id":"2b1d6e87aba02064","type":"change","z":"fa5ad0aa4db28cdf","name":"","rules":[{"t":"set","p":"ID","pt":"global","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":350,"y":120,"wires":[["4df5e3347aec4455"]]},{"id":"4df5e3347aec4455","type":"debug","z":"fa5ad0aa4db28cdf","name":"debug 9","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":600,"y":120,"wires":[]},{"id":"eeb582058a3296c7","type":"ui_template","z":"fa5ad0aa4db28cdf","group":"29b9b9d1901d5782","name":"Result message","order":2,"width":0,"height":0,"format":"<h6><div ng-bind-html=\"msg.payload\"></div></h6>","storeOutMessages":true,"fwdInMessages":true,"resendOnRefresh":true,"templateScope":"local","x":660,"y":680,"wires":[[]]},{"id":"ad1fd8a8fd7c9e7f","type":"delay","z":"fa5ad0aa4db28cdf","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":640,"y":580,"wires":[["e89dceba3443ed77"]]},{"id":"e89dceba3443ed77","type":"function","z":"fa5ad0aa4db28cdf","name":"function 9","func":"msg.payload = \"\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":640,"y":640,"wires":[["eeb582058a3296c7"]]},{"id":"9b93eaed7bd635a2","type":"function","z":"fa5ad0aa4db28cdf","name":"Reset values","func":"var msg2 = {};\nmsg.payload = 0;\n\nvar SerialNO = global.get('SERIAL_NO')+1\nmsg2.payload = SerialNO;\n\nreturn [msg,msg2];","outputs":2,"noerr":0,"initialize":"","finalize":"","libs":[],"x":970,"y":420,"wires":[["0ae9122b55a0f7ec","95fb7f2243039991"],["87d5dd2e35caee04"]]},{"id":"d026765a9396f366","type":"debug","z":"fa5ad0aa4db28cdf","name":"debug 10","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1360,"y":620,"wires":[]},{"id":"d1f3780b02ecf9d2","type":"ui_table","z":"fa5ad0aa4db28cdf","group":"29b9b9d1901d5782","name":"","order":1,"width":0,"height":0,"columns":[],"outputs":0,"cts":false,"x":1630,"y":500,"wires":[]},{"id":"6c68973a.b918d8","type":"ui_group","name":"ID","tab":"813cfdf1.bc551","order":1,"disp":true,"width":8,"collapse":false},{"id":"9c065d24d1bbc522","type":"ui_group","name":"Duomenys","tab":"813cfdf1.bc551","order":2,"disp":true,"width":"9","collapse":false},{"id":"29b9b9d1901d5782","type":"ui_group","name":"Ataskaita","tab":"813cfdf1.bc551","order":3,"disp":true,"width":"18","collapse":false},{"id":"813cfdf1.bc551","type":"ui_tab","name":"Presas","icon":"dashboard","disabled":false,"hidden":false}]

There is no need to post the full flow, you have already posted a small flow that you said failed in the same way. Please confirm that it fails with that small test flow and does not recover when you close the excel and try the flow again. If it still fails when excel is closed please do what I asked for earlier, which is to stop node red and start it again in a terminal, trigger the error, close excel and trigger the error again. Then post the full output from the terminal here, including the node-red startup messages. Copy/paste please, not screenshot.

C:\Users\User>node-red
23 Jul 10:55:31 - [info]

Welcome to Node-RED
===================

23 Jul 10:55:31 - [info] Node-RED version: v3.0.0
23 Jul 10:55:31 - [info] Node.js  version: v12.18.4
23 Jul 10:55:31 - [info] Windows_NT 10.0.19044 x64 LE
23 Jul 10:55:32 - [info] Loading palette nodes
23 Jul 10:55:33 - [s7comm-Error] - Installation of Module net-keepalive failed because we might be on the wrong OS. OS=win32
23 Jul 10:55:33 - [s7comm-Info] - Debug configuration for logLevelNodeS7:{"debug":0,"silent":true}
23 Jul 10:55:33 - [s7comm-Info] - Debug configuration for logLevelNodeRED:{"debug":2,"silent":true}
23 Jul 10:55:33 - [info] +-----------------------------------------------------
23 Jul 10:55:33 - [info] | uibuilder initialised:
23 Jul 10:55:33 - [info] |   root folder: \Users\User\.node-red\uibuilder
23 Jul 10:55:33 - [info] |   version . .: 3.2.0
23 Jul 10:55:33 - [info] |   packages . : jquery,socket.io
23 Jul 10:55:33 - [info] +-----------------------------------------------------
23 Jul 10:55:33 - [info] Dashboard version 2.24.0 started at /ui
23 Jul 10:55:33 - [info] Settings file  : \Users\User\.node-red\settings.js
23 Jul 10:55:33 - [info] Context store  : 'default' [module=memory]
23 Jul 10:55:33 - [info] User directory : \Users\User\.node-red
23 Jul 10:55:33 - [warn] Projects disabled : editorTheme.projects.enabled=false
23 Jul 10:55:33 - [warn] Flows file name not set. Generating name using hostname.
23 Jul 10:55:33 - [info] Flows file     : \Users\User\.node-red\flows_DESKTOP-KVMEO5T.json
23 Jul 10:55:33 - [warn]

---------------------------------------------------------------------
Your flow credentials file is encrypted using a system-generated key.

If the system-generated key is lost for any reason, your credentials
file will not be recoverable, you will have to delete it and re-enter
your credentials.

You should set your own key using the 'credentialSecret' option in
your settings file. Node-RED will then re-encrypt your credentials
file using your chosen key the next time you deploy a change.
---------------------------------------------------------------------

23 Jul 10:55:33 - [info] Server now running at http://127.0.0.1:1880/
23 Jul 10:55:33 - [info] Starting flows
23 Jul 10:55:33 - [info] Started flows
23 Jul 10:55:33 - [info] [tcp in:05f8fb510ebdc9d5] listening on port 6000
23 Jul 10:56:18 - [info] Stopping modified nodes
23 Jul 10:56:18 - [info] Stopped modified nodes
23 Jul 10:56:18 - [info] Updated flows
23 Jul 10:56:18 - [info] Starting modified nodes
23 Jul 10:56:18 - [info] Started modified nodes
23 Jul 10:56:48 - [error] [file:eb839545e1c5df78] failed to append to file: Error: EBUSY: resource busy or locked, open 'C:\Users\User\Desktop\CNC1234.csv'
23 Jul 10:56:55 - [error] [file:eb839545e1c5df78] failed to append to file: Error [ERR_STREAM_WRITE_AFTER_END]: write after end
23 Jul 10:57:05 - [error] [file:eb839545e1c5df78] failed to append to file: Error [ERR_STREAM_WRITE_AFTER_END]: write after end
23 Jul 10:57:20 - [info] Stopping flows
23 Jul 10:57:20 - [info] [tcp in:05f8fb510ebdc9d5] stopped listening on port
23 Jul 10:57:20 - [info] Stopped flows

C:\Users\User>node-red
23 Jul 10:57:25 - [info]

Welcome to Node-RED
===================

23 Jul 10:57:25 - [info] Node-RED version: v3.0.0
23 Jul 10:57:25 - [info] Node.js  version: v12.18.4
23 Jul 10:57:25 - [info] Windows_NT 10.0.19044 x64 LE
23 Jul 10:57:26 - [info] Loading palette nodes
23 Jul 10:57:27 - [s7comm-Error] - Installation of Module net-keepalive failed because we might be on the wrong OS. OS=win32
23 Jul 10:57:27 - [s7comm-Info] - Debug configuration for logLevelNodeS7:{"debug":0,"silent":true}
23 Jul 10:57:27 - [s7comm-Info] - Debug configuration for logLevelNodeRED:{"debug":2,"silent":true}
23 Jul 10:57:27 - [info] +-----------------------------------------------------
23 Jul 10:57:27 - [info] | uibuilder initialised:
23 Jul 10:57:27 - [info] |   root folder: \Users\User\.node-red\uibuilder
23 Jul 10:57:27 - [info] |   version . .: 3.2.0
23 Jul 10:57:27 - [info] |   packages . : jquery,socket.io
23 Jul 10:57:27 - [info] +-----------------------------------------------------
23 Jul 10:57:28 - [info] Dashboard version 2.24.0 started at /ui
23 Jul 10:57:28 - [info] Settings file  : \Users\User\.node-red\settings.js
23 Jul 10:57:28 - [info] Context store  : 'default' [module=memory]
23 Jul 10:57:28 - [info] User directory : \Users\User\.node-red
23 Jul 10:57:28 - [warn] Projects disabled : editorTheme.projects.enabled=false
23 Jul 10:57:28 - [warn] Flows file name not set. Generating name using hostname.
23 Jul 10:57:28 - [info] Flows file     : \Users\User\.node-red\flows_DESKTOP-KVMEO5T.json
23 Jul 10:57:28 - [warn]

---------------------------------------------------------------------
Your flow credentials file is encrypted using a system-generated key.

If the system-generated key is lost for any reason, your credentials
file will not be recoverable, you will have to delete it and re-enter
your credentials.

You should set your own key using the 'credentialSecret' option in
your settings file. Node-RED will then re-encrypt your credentials
file using your chosen key the next time you deploy a change.
---------------------------------------------------------------------

23 Jul 10:57:28 - [info] Server now running at http://127.0.0.1:1880/
23 Jul 10:57:28 - [info] Starting flows
23 Jul 10:57:28 - [info] Started flows
23 Jul 10:57:28 - [info] [tcp in:05f8fb510ebdc9d5] listening on port 6000

After the NR reset I'm able to write to file

I noticed that my Node.js version is too old, after updating to v16 this error is gone :man_facepalming:

Sorry for wasting your time.

1 Like

I tested it also on my Windows system and

  1. if i open the csv with Excel it locks the file and cannot write to it.
  2. if i close Excel and wait a few seconds it unlocks the file and I can write to it again.
  3. writing to the csv file while having it open with VSCode causes no issues and can even see the new writes appearing! since VScode doesnt seem to lock the file.

How long did you wait until Excel unlocks the file ? .. in your video you dont seem to leave it long enough.

If you are not planning to edit the file with Excel .. you can always open it as Read Only to avoid blocking background writes. (File > Open > select file > Open Read-Only)

ps. on my test system i was already on Node.js version: v16 .. dont know if that makes the difference

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.