How to Log MQTT Sensor Data in Node-Red

[@gilquinones6652]

Very good video. Learning more and more as I watch each one.

[@lionfeen]

It's a few years since this was created. Is this still a viable logging flow or are there other updated options available ?

[@stevecope]

Yes it is still a basic flow I have updated it slightly to include options to store the data if you contact me using the ask steve page on the site I will send it to you. stevesnoderedguide.com/ask-steve rgds steve

[@stevecope]

Its habit. I usually declare it at the top of all functions as well as payload=msg.payload

[@luism9847]

Hi. Im trying to send data from a sensor that is connected by RS485 to a IOT gateway, that got mqtt protocol. Do I need a broker mqtt before the node red plataform? Thank you

[@stevecope]

Yes. To send MQTT messages you always need a broker. Rgds Steve

[@SriRam-dv6mb]

Hai Steve.. where can i learn that script program used in function node....i searched a long and learned very few..where can i learn all that program used in function node... Please help...:-)

[@kahfiramadhan1555]

How to read (.rrd) on node red bro? Thnks

[@soovui]

Very good knowledge. Is that possible build a tutorial plotting a graph?

[@kishorerabha8920]

why did you declare var topic = msg.topic? You didn't use it anywhere.

[@NabinMurali]

Hi, Steve I Learned node red from scratch using your tutorial and website. For finalizing my project I need to log my MQTT data into Google sheets via GOOGLE Sheets API. Will you please post a video how it can be done. I have searched many resources for weeks but couldn't come up with a solution. Hope you would be able to help. Thanks

[@stevecope]

I assume you are using node-red?

[@stevecope]

Hi Glad you fin them useful. I did have aquick look at Google sheets but wasn't able to make much sense of it. I've put it on my to do list but I'm afraid it won't be soon. I did find this. flows.nodered.org/flow/b7bba30a006e1cc7729e It is old but may be useful Rgds Steve

[@zhaowentao6036]

Thank you, very resourceful.

[@sananebanane910]

I don't want set mqtt server username and password in flow. I have form in dashboard, I want enter MQTT username and password on form. When I click submit connect.

[@stevecope]

As far as I know that isn't possible

[@jaehonglee3061]

Thank you so much for the video! It is of great help for my assignment! I have a established a MQTT Broker through Amazon Web Services, and here Mosquitto was used as the broker. How would it be possible to change the broker from Mosquitto to AWS MQTT Broker? Again, thank you so much!

[@stevecope]

For the purpose of the video any broker will do. I use mosquitto because it is easier for me . Rgds Steve

[@farmaforpresident8138]

Thank you for the video, but I couldn't make it work on my hass.io node-red (Raspberry pi). Do you know how should start the filepath?

[@stevecope]

The file should start logging when it receives data. Are you seeing the data. Instead of using the python script you could use an inject node to inject data and test it that way. Are you seeing any data in the debug console

[@farmaforpresident8138]

Steve Cope I'm using it in a flow that receives and transforms IR codes. I'm pretty sure that the payload arrives, I have a debug node conected at the same place. But the file is not being created, also tried manually creating a file but it didn't work.

[@stevecope]

Did you download the flow example from my site?

[@farmaforpresident8138]

Steve Cope No, but I followed the same steps in the file node. I guess the problem is which directories has node-red acces. It's installed as an addon of hass.io...

[@stevecope]

No I think the file is created by the function node which passes the name to the file node. The easiest way is to download the flow and copy out the code.

[@bodyguardsafetysolutions1957]

Thanks for the great video Steve. Do you have any examples of using node red to get data into a windows application? I am looking at a temperature monitoring system using MQTT data and node red and using a Visual Studio C# program to write an app that displays the temps, logs to a file, sends SMS text alert etc.

[@stevecope]

Sorry I don't but you could do what you want with node-red. The only way I know would be to log the data and then get the windows application to read it and display it.Do you already have the app and want to reuse it?RgdsSteve

[@osamanasher2550]

Hi Steve, Thanks for your great vidio. But actually I new in this field I like to learn more. First can you provide me the links to download MQTT and node red? Is there library for extract samples for MQTT??

[@stevecope]

Hi If you go to the website you will find links and instructions for node-red and mqtt rgds steve

[@viniciusnoyoutube]

Very good! Thanks!