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/