I'm reading data from a S7 PLC and exporting to a csv file. Every 5 seconds it creates a new row. I would like the first line were the header (the Tag name could be fine). The problem is that if I click the 'Include column name row', it insert it every time. How could I fix it? Thank you! The co…

Hopefully something like this for your function context.day = context.day || ""; // restore or create blank variable to hold "old" day var d = new Date(); var t = d.getTime(); var year = d.getFullYear(); var month = d.getMonth()+1; if (month.toString().length == 1) { month = '0'+month; } var…

All you have provided is one node - the S7 in node. Where is the rest of your flow showing what you are doing?

How do you know if it is the first time? Can you stick a debug on the output of the s7 in node and show what the data looks like?

thank you for showing the debug data however you did not reply to my question. How do you know when the first data comes in so you can determine if you need to output the column headers?

A new file is created every day using the 'Date'. The procedure should be: Create the file (already done). Insert the header. Insert data every 5 seconds (already done)

So why don't you create the header when you create the file each day and skip putting in the column names in the CSV node?

Yes, that could be a solution but I don't know how I can do it... (it's my first project with node-red)

Node-RED

Node-RED Forum

Csv Header only once

General

zenofmud 18 February 2020 10:12 2

Please read How to share code or flow json and edit your post fixing the flow so it can be imported

Topic		Replies	Views
How to put headers only once in a csv file General	6	632	20 May 2022
Struggling to add headers to CSV file General	10	2873	28 April 2020
Add column headers to CSV file General	12	2559	13 April 2021
CSV node - coloum header General	1	348	25 January 2021
'save to file' node, set the first row General	14	7372	23 June 2018

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.

Csv Header only once

Related topics