Garry (Customer) asked a question.

Click Plus Data Logging - CSV File and SQL Database

Data Logging capability using the Click Plus PLC.

Data logging is the collection of data over time. This is usually used for data analysis at a later time. The amount of data (System Information) stored and the frequency of the storage will depend on your specific application.

The hardware used to store the data is usually called a data logger. Using the information from our last post, the MQTT information collected (Temperature in Atlanta and Click Analog) will now be logged in two different ways. A micro SD card on the Click Plus will be used to store the data every minute in a CSV (Comma Separated Value) file. Node-RED will also be used to store the same data in a SQL database. 

Post Location:

https://accautomation.ca/click-plus-data-logging-csv-file-sql-database/

YouTube Video:

https://youtu.be/ydoWvMzHSKc

 

Regards,

Garry

 

https://accautomation.ca/


ADC Community_02 and Garry like this.
    • Garry (Customer)

      Logging to a database is now so easily done using Node-RED.

      Garry

  • bwvick (Customer)

    Can this same process be done on a BRX using Do-MOre?

     

    • Garry (Customer)

      Hi bwvick

      The BRX can communicate MQTT, Modbus TCP, and Modbus RTU both reading and writing.

      The BRX also has REST API that will allow reading of all of the memory areas. Node-RED HTTP Request can take advantage of this.

      Here is a video that will show you how this is done.

      https://youtu.be/m-p28H9Fl5s

      This will be released within the next few months so all of the links in the description may not work.

      Regards,

      Garry

      Expand Post
      • Garry (Customer)

        This can also be done using the Productivity line of controllers.

        They can use Modbus TCP or Modbus RTU.

        Regards,

        Garry