Hi V Richter, Yes, the database is stored on the PC running Node-RED in my example but this could be anywhere on your network. accautomation.ca/click-plus-data-logging-csv-file-sql-database/ Here is a post that will discuss the database only using Node-RED. accautomation.ca/node-red-sql-database-log-modbus-logging/ SQLite was used because this can be placed on many different operating systems and devices like a Raspberry Pi. Regards, Garry
@@TheUnofficialMaker You are correct. 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. ruclips.net/video/m-p28H9Fl5s/видео.html This will be released within the next few months so all of the links in the description may not work. Regards, Garry
Hi James, The data cannot be exported directly to an excel file using the PLC. I would use Node-RED to place the data into a database and then use Excel to connect and view the data in the database. This is the preferred method. accautomation.ca/node-red-sql-database-spreadsheet-connection/ Excel has VBA incorporated into it. You could also use VBA to communicate Modbus TCP to the PLC to get the data and put it into the Excel file. accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel/ I hope this helps you out. Regards, Garry
@@ACCautomation Yes that helps a lot but I was watching your "Click Plus PLC MQTT Communication" video and was wondering if I have to also download that SQlight program. Also what is the difference between the two?
@@jamesalexander9856 You could use MQTT, but you would need a broker as well. The video shows a Mosquitto broker running in the background. An SQLite database can be placed on the same drive that Node-RED would have access to. The information would then be polled using Modbus or MQTT and then placed in the database using SQL commands. Excel can then connect to the SQLite database and display the information. The advantage of using a database is that several users can connect to it at the same time. Regards, Garry
is the db stored on the pc running node red?
Hi V Richter,
Yes, the database is stored on the PC running Node-RED in my example but this could be anywhere on your network.
accautomation.ca/click-plus-data-logging-csv-file-sql-database/
Here is a post that will discuss the database only using Node-RED.
accautomation.ca/node-red-sql-database-log-modbus-logging/
SQLite was used because this can be placed on many different operating systems and devices like a Raspberry Pi.
Regards,
Garry
@@ACCautomation i could do the same thing on my brx correct?
@@TheUnofficialMaker
You are correct. 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.
ruclips.net/video/m-p28H9Fl5s/видео.html
This will be released within the next few months so all of the links in the description may not work.
Regards,
Garry
can you have the data be exported into an excel file ?
Hi James,
The data cannot be exported directly to an excel file using the PLC. I would use Node-RED to place the data into a database and then use Excel to connect and view the data in the database. This is the preferred method.
accautomation.ca/node-red-sql-database-spreadsheet-connection/
Excel has VBA incorporated into it. You could also use VBA to communicate Modbus TCP to the PLC to get the data and put it into the Excel file.
accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel/
I hope this helps you out.
Regards,
Garry
@@ACCautomation Yes that helps a lot but I was watching your "Click Plus PLC MQTT Communication" video and was wondering if I have to also download that SQlight program. Also what is the difference between the two?
@@jamesalexander9856
You could use MQTT, but you would need a broker as well. The video shows a Mosquitto broker running in the background.
An SQLite database can be placed on the same drive that Node-RED would have access to. The information would then be polled using Modbus or MQTT and then placed in the database using SQL commands.
Excel can then connect to the SQLite database and display the information. The advantage of using a database is that several users can connect to it at the same time.
Regards,
Garry