Hey, I think I only have a small problem. Nevertheless, I do not know what to do. I have made a flow wich create files to an ftp File and name them by some parts of the payload. The saving process works, but i can not open the csv data. The error text says that the path isnt there. Then i tryed to…

Welcome to the forum. Add a debug node showing what is going to the file node, and set it to output Full Message and check whether the content is correct. If it looks ok then show us what you see there and also show us how the file node is configured.

Have you done what I suggested with a debug node?

The Path for the local hard drive is : F:/HomeeVerlaufsdaten/attribute ___id__135.csv ( "F:/HomeeVerlaufsdaten/" and ".csv" are given in the funktion and only the attribute is based on the payload for ftp it is: //fritz.box/FRITZ.NAS/HomeeVerlaufdaten/attribute ___id__103.csv and it works. …

That screenshot is unfortunately illegible on my system. Please show just one output from the debug node and make sure you expand it fully so it is all visible. In fact better to hover over the top of the debug and click the Copy Value button that will appear and paste that here. For the function…

[image] skyover99: is it possible that the problem is the little arrow behind attribute Yes, seems you have a carriage return in your filepath, in your list of replaces try adding this: PayloadString3 = PayloadString3.replace(/\r?\n/,"");

Thank you very much. That was actually the problem and you solved it. But first you have to come to the conclusion that in this case it is because of it and that you have to solve it that way. I would never have thought of it in my life. Thank you, thank you, thank you :slight_smile:

Node-RED

Node-RED Forum

Saving CSV Data

General

grant1 6 October 2021 00:23 3

I posted (and resolved) a question a while back about filepaths for saving a csv that was created & named using Node-RED. Maybe it will help.

Topic		Replies	Views
Exporting array to a local file General	12	4238	22 May 2018
How can I send CSV files to an FTP server? General	8	2445	17 January 2021
CSV node, write output node is not working General	10	513	11 August 2022
Saving CSV data like original dataset prior to ftp General	1	467	13 January 2022
First Post - Combine csv node with my filename assignment General	15	309	17 January 2024

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.

Saving CSV Data

Related topics