Node Red: How to Import Database Data from a CSV File

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ม.ค. 2025

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

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

    Sir please upload a video. how to import the csv file and send the datas to MSSQL server

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

    hello, could you make a video how to dynamically pick a color for my bar chart? ie: if the value of my bar chart is less than 10, it will be green, above 10 it will be red. thank you in advance

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

    I find from node to write data into db sensor_values have 2 columns, "timestamp" and "value", but in your video, there is a column "id", but when I edit db to add this column, it will cause error when write data. what is the exact structure of this db? your video is very good.

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

      You can see the structure of the Database after the query which gets the column names. It has "id", "timestamp" and "value". The "id" is an auto_incremented primary key. This is also the reason, why you can't write this data.

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

    Good tutorial. But so far there's only 1 problem on my side.
    In my csv contain string like value (like device name), while my MySQL database column was created with varchar (255) type.
    But every time when I tried to insert, in the debug will give error: "Error: Unknown column 'DDC_1' in 'field list'".
    *DDC_1 here is for the device name column in MySQL.
    Is there any way to upload string/varchar value via CSV?
    Thank you for attention.

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

      Seems like your insert command is wrong as DDC_1 should be the value and not the column name