Msg.status.text (object) to csv (via payload?)

General
1

Dear

I am a beginner as far as Node-Red is concerned.
Currently I have a msg.object, from which I would like to get the text (msg.status.text).

image

The photo shows the text as "offline" in this case. The text is variable. I have not yet been able to write a working function.

I want to display this text as a payload value (msg.payload.melding) to be written to a csv file afterwards.
Or are there better methods to make this happen?

Info: flow of the status messages to csv.

image
image1142Ă—135 13.8 KB

Thank you very much for your time and help.

2

Hi Arne, welcome to the forum!

The first ting I would suggest is you read the documentation on working with messages and watch the video: https://nodered.org/docs/user-guide/messages
and you can look at the cookbook for an example. Once you do that if you still have a question, I (or someone else) will be glad to help.

1 Like
3

Thank you for your fast reply @zenofmud.

I think I need to use the "change-node"?
image

I can add a payload, but I can't link it with the variable.

Earlier I used a function to associate the time with a particular message. But I still can't link a variable

image
image1016Ă—356 12.3 KB

4

Did you realise that the change node you have shown to overwrite the current value in msg.status.txt to the value in msg.payload.melding? It sets msg.status.txt. I wonder whether you wanted those the other way round. I tend to use Move rather than Set as Set can be confusing. So perhaps you want Move msg.status.text To msg.payload.melding.
If that doesn't work use a Debug node set to Show Complete Message to show us what is going into the Change node, another showing what is coming out. Give them names so they are identifiable in the debug, and post a screenshot of the debug output here.

5

When running into an issue like this, I would put a debug node (set to display the complete msg object) on the output of the node feeding the change node and then anotehr one on the output of the change node to see what the msg going in and msg coming out look like.

That should give you information to discover the issue.

6

Hey

In the meantime I have achieved what I was looking for. I am convinced that this is certainly not the most optimal solution, but it works.

Maybe I need to reformulate my problem. I didn't know how to add "msg.status.text" to a csv file.
I was still able to achieve this by:

  1. Add msg.payload.Status (change node: set)
  2. msg.payload.Status = msg.status.text; [see picture in the first post]] (function)

Flow:

image
image1293Ă—163 25.1 KB

  1. Change-node:
    image

  2. Function:

    image
    image1304Ă—351 18.7 KB

    [If there is a status msg, there is no PLC-data know, so I write "/" to the csv file]

Note that I use different names than in previous posts.

If this was the correct method, you can put a lock on it :slight_smile:

I want to learn how to work better with Node-red, suggestions are certainly welcome. I've been working with the tool for a few days now. My programming background is very limited, with the exception of TIA Portal to basic HTML and basic Java.

Just a quick question, presumably I have to open a new topic for this .. But is it possible to write data to an exact cell in Excel? I try to generate a report in which I would provide the layout in Excel and then send the desired data to the correct cells. Suggestions? I have not yet found suitable information about this.

Thanks!

7

What do you think the Change node is doing, and what do the first two lines of the function do?

8

The first 2 lines in the function write the msg.status.text to msg.payload.Status

In my CSV I use the following columns:
"Time, oiSnelheidBand, roActueleHoek, roEffectieveTempWater, roLevelWaterbad, Status"

The values are from an S7-1500 PLC, with the exception of Status and Tijd.

If I don't put a Change-note, where I create msg.payload.Status, it looks like my function cannot create the msg.payload.Status. So by first creating msg.payload.Status via the change note, the function can fill it in.

Is it possible to write 'msg.status.text' in the CSV without placing it first in msg.payload.Status? Most likely yes, but I couldn't ..

9

That is because msg.payload does not exist. Remove the Change node and in the function node use, instead of the first two lines
msg.payload = {Status: msg.status.text}
That will create msg.payload as an object and set the Status value

1 Like
10

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