Node Red: How to Export Database Data to CSV

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ธ.ค. 2024

ความคิดเห็น •

  • @laitechingchannel
    @laitechingchannel 9 หลายเดือนก่อน +1

    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.😀

  • @werneroostendorp1154
    @werneroostendorp1154 11 หลายเดือนก่อน +2

    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
      @ruwindustries  11 หลายเดือนก่อน +1

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

  • @wick_bourne
    @wick_bourne 10 หลายเดือนก่อน +1

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

  • @danielasrijan5076
    @danielasrijan5076 10 หลายเดือนก่อน +1

    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!

  • @CristianTorres-il6og
    @CristianTorres-il6og 9 หลายเดือนก่อน +1

    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
      @ruwindustries  9 หลายเดือนก่อน +1

      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.

  • @TycoelectronicsB0E
    @TycoelectronicsB0E 8 หลายเดือนก่อน +1

    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
      @ruwindustries  7 หลายเดือนก่อน

      You need to create the folders yourself.

  • @wick_bourne
    @wick_bourne 9 หลายเดือนก่อน +1

    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
      @ruwindustries  9 หลายเดือนก่อน +1

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

    • @wick_bourne
      @wick_bourne 9 หลายเดือนก่อน +1

      ​@@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

  • @MOBILITECHN
    @MOBILITECHN 5 หลายเดือนก่อน

    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
      @ruwindustries  5 หลายเดือนก่อน

      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.

    • @Dalfaro21
      @Dalfaro21 2 หลายเดือนก่อน

      @@ruwindustries and what should I change to make it work on my local Node Red?

  • @wihartaIDBM
    @wihartaIDBM หลายเดือนก่อน

    hi sir, how to download some data using pickdate?

    • @ruwindustries
      @ruwindustries  หลายเดือนก่อน

      You have to adjust the SQL query to take the date picker into account when selecting data.

  • @m.rgh.i9199
    @m.rgh.i9199 3 หลายเดือนก่อน

    what is the password? 1:51

    • @ruwindustries
      @ruwindustries  3 หลายเดือนก่อน +1

      The password you set when creating the database.