Node Red: How to Export Database Data to CSV

[@laitechingchannel]

For someone, who may get a conclusion at 11:11 in this video. If you use a different machine to edit node red flow. For example, I run node red service on a pi board and edit the flow on a mac following this video. The localhost should be replaced by the ip address of the machine, which is running node red. In my case, it is the ip address of my pi board. It took me some time to figure out that. Hope this can save your time. Thank you a lot for the great training video. Following your instructions, I learned how to create useful dashboard and perform CRUD application and import/export CSV files. All instruction work.😀

[@danielasrijan5076]

Hi! Thanks for the videos, they helped me alot. If it isn't too much of a bother for you, could you do a video about the "cronplus"- node? I think it is alot better in most scenarios than the "inject"- node but don't understand all the possibilities of the node. Perhaps you could find some function I didnt quite understand. But it is only if it is in your interest of course, thanks again for the videos and have a great day!

[@TycoelectronicsB0E]

Weirdly enough, there isn't a path called "\data\static\files" for me. I am using node-red on a raspberry pi and I am unsure if that's the problem...

[@ruwindustries]

You need to create the folders yourself.

[@wick_bourne]

Is there is automate the data logging? i mean date-wise csv file added with corresspoing date data without manual intervention?

[@werneroostendorp1154]

Hi! Thnx for the amazing video! Could you give me a hint on how to download all the information from the Table in CSV format with a download button? Without using MySQL

[@ruwindustries]

You have to adjust the nodes before the write file node to do whatever you want it to do.

[@CristianTorres-il6og]

Great video, I'm curious, is it possible to graph the database in node red? That is to say that the data that is in the DB is read in node red and graphed in the dashboard, it makes me somewhat curious, keep it up, I have learned a lot from your channel.

[@ruwindustries]

Yes, it's possible to graph data from the database in the dashboard. But it requires a few manual conversions. That's a good idea for a new video - thanks.

[@MOBILITECHN]

Hi, I have ths error "Cannot GET /data/static/files/sensor_values.csv" I don't understand msg.path which does not point to the .nodered folder. An Advice ? Thanks,

[@ruwindustries]

The Path /data only works if you use node-red from a docker container. If you run Node Red locally, the part before /static is different. I just use msg.path, so I can specify the path from a function.

[@wick_bourne]

What if our node-red setup is running on raspberry-pi and we want to download CSV/excel file in the network PC using download button of node-red dashboard?

[@ruwindustries]

Just change the ip-address in the template node from localhost to the ip-address of the raspberry-pi in the network

[@wick_bourne]

​@@ruwindustriesWhere do you mean? There is no option to provide IP-address in the Template node. Also, The file-in node only takes csv-file directory as the Input

[@m.rgh.i9199]

what is the password? 1:51