Ryan1980 (Customer) asked a question.
Best way to pull live information from PLC to a database
I'm wanting to monitor a future PLC project so that I can display the machines OEE on a TV in the area. In the past I've used AB products (RSlinx to Excel, Access, etc...). Is there something similar in AutomationDirects lineup that would work?
Hi Ryan,
Since the Click will communicate Modbus (TCP and RTU) you can use any driver that communicates Modbus.
Here is a post using VBA in Excel to retrieve data.
https://accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel/
Another way would be to use AdvancedHMI. This is a free package that is opened sourced, written in VB.Net, and runs on visual studio.
https://accautomation.ca/click-plc-advancedhmi-communication/
This post also uses VB.Net without AdvancedHMI.
https://accautomation.ca/modbus-tcp-data-logging-to-database/
Node-Red can also be used.
https://accautomation.ca/node-red-modbus-rtu-tcp-communication/
You could also save yourself some programming and just get a headless C-More. This will connect directly to a TV via an HDMI cable.
https://accautomation.ca/c-more-ea9-hmi-series-headless-rhmi-panel/
I hope this helps you out.
Regards,
Garry
https://accautomation.ca/series/click-plc/
https://accautomation.ca/series/c-more-hmi-series-panel/
I do not think that Modbus ASCII is available in CLICK. A minor point, I realize, but it could be important to some.
Hi Kewakl,
I made a post that will allow the Click to communicate Modbus ASCII to a Solo Temperature Controller.
https://accautomation.ca/click-plc-modbus-ascii-protocol/
I did the same for a Productivity and BRX Do-More Controller
https://accautomation.ca/productivity-1000-series-plc-modbus-ascii-protocol/
https://accautomation.ca/brx-do-more-plc-modbus-ascii-protocol/
The above are all set up for Modbus ASCII masters.
Regards,
Garry
I made a post that will allow the Click to communicate Modbus ASCII to a Solo Temperature Controller.
I see what you did! This is not native to the firmware. Nice. Make that CLICK work for its supper!
I am a huge fan of python and PyModbus as it has worked very well for me in the past. It also looks like there is a module named pyodbc that can read and write to a Access database. I haven't used pyodbc but it dosent look too difficult
https://datatofish.com/insert-ms-access-python/
Thank you all for the replies, I'll be checking them out!
So the new click PLC does not have the ability to send emails?
I see nothing that would suggest that the new CLICK can send email.
So what is the real advantage of having it connect to WI-FI and the data logging?
I think they have "plans" to offer more options down the road using these new features(somebody from Automation Direct I'm sure can confirm).
That being said, I think the new CLICK units can blow the Siemens Logo series out of the water if they add more features on the communications side(all the hardware is there, the features just have to be implemented).