Most people just want to log some information into a database. This can be production or performance information on the machine or equipment. Node-RED is the easiest way to manage this process. This can be run on any PC including a Raspberry Pi. Communications to the PLC are done through Modbus TCP. Any of the AD PLC families, Do-More, Click, or Productivity can be used. Spreadsheets can then be used to view the data in the database. Let me know if you found this video helpful. Thank you, Garry
This is a great video thank you. I just have a question? How do you read the db from pi? How do you share to the windows over the network? You need to enable or install additional software?
Copying the .sqlite file to your computer would be the easiest route, so you don't have to deal with the network connections. If you want to share then I would try to do the following: accautomation.ca/node-red-sql-database-spreadsheet-connection/ Note: You may have to open the ports to expose the database directory on your windows PC. I have not tried this. Regards, Garry
Hi V J, Looking at the Click programming software, call up the address picker. On the bottom right-hand side there is a display Modbus address. Leave this on Modbus 984 Addressing. X001 has Modbus address 100001 the function code read-only is displayed as well. (02) I hope this helps you out. Regards, Garry
Most people just want to log some information into a database. This can be production or performance information on the machine or equipment.
Node-RED is the easiest way to manage this process. This can be run on any PC including a Raspberry Pi.
Communications to the PLC are done through Modbus TCP. Any of the AD PLC families, Do-More, Click, or Productivity can be used.
Spreadsheets can then be used to view the data in the database.
Let me know if you found this video helpful.
Thank you,
Garry
This is a great video thank you. I just have a question? How do you read the db from pi? How do you share to the windows over the network? You need to enable or install additional software?
Copying the .sqlite file to your computer would be the easiest route, so you don't have to deal with the network connections.
If you want to share then I would try to do the following:
accautomation.ca/node-red-sql-database-spreadsheet-connection/
Note: You may have to open the ports to expose the database directory on your windows PC.
I have not tried this.
Regards,
Garry
Hi V J,
Looking at the Click programming software, call up the address picker. On the bottom right-hand side there is a display Modbus address. Leave this on Modbus 984 Addressing.
X001 has Modbus address 100001 the function code read-only is displayed as well. (02)
I hope this helps you out.
Regards,
Garry
thanks! got it!
@@TheUnofficialMaker
Glad you got it working.
Thanks for the feeback.
Garry
fantastic!