Simple Click PLC Data Logging

We will now be looking at simple data logging using a Click PLC with an Ethernet port. Node-RED will be used to communicate to the controller via Modbus TCP protocol. Information collected will be then stored in an SQLite SQL database. A Raspberry Pi 4 single-board computer will be used for the Node-RED collecting and storing. The update time will be two times a second (500 mSec). This method is ideal for quickly determining how things are operating. https://accautomation.ca/series/node-red-iot-enabling-software/ Analysis or display of the information will be done with a spreadsheet. The spreadsheet will be run on a windows computer. Let’s get started. More information can be obtained at our website. This includes all of the links mentioned in this video. https://accautomation.ca/simple-click-data-logging-node-red/ In this series we started using Node-RED in some of the following ways: Installing the Windows Software https://accautomation.ca/node-red-installing-the-windows-software/ https://youtu.be/xGzH2Hv31WA Modbus RTU / TCP Communication https://accautomation.ca/node-red-modbus-communication/ https://youtu.be/yX1w5vcV6cc User Interface - Dashboards https://accautomation.ca/node-red-user-interface-dashboards/ https://youtu.be/8zAG2wXwGOc SQL Database Log https://accautomation.ca/node-red-sql-database-log-modbus-logging/ https://youtu.be/QHjcNj1S_Mo SQL Database Spreadsheet Connection https://accautomation.ca/node-red-sql-database-spreadsheet-connection/ https://youtu.be/Cd3LvhoMaCI Install Node-RED on Raspberry Pi 4 https://accautomation.ca/install-node-red-on-raspberry-pi-4/ https://youtu.be/KleNtxvJkU4 We will continue with the following: Simple Click Data Logging 00:00 Simple Click Data Logging 01:05 Click PLC Logging Program 04:32 Simple Click Data Logging Hardware 05:43 SQLite SQL Database Setup 07:28 Node-RED Click Logging Program 15:03 Viewing the SQL Database Information on a Spreadsheet There are several reasons why we are using Node-RED. Here are just a few. - Built on top of the most dependable programming language JavaScript. - JavaScript is flexible and easy to work with on web browsers, server-side, IoT, IIoT projects, and more. - Visual flow type interface making programming easy. - Node will allow JavaScript code to run directly on a computer. - Node-RED is a free, open-source logic engine. - Connect to PLC, PAC, Temperature Controllers, Process Controllers using standard protocols. - Save and read from databases - Easily make the Internet of Things (IoT, IIoT) industrial solutions. Node-RED provides the ability for you to quickly create custom control solutions. https://accautomation.ca/