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.
-
13:50
The Gun Collective
3 hours agoFinally!! - TGC News!
18.4K2 -
1:01:58
Glenn Greenwald
7 hours agoBrazil and E.U. Force X and Telegram To Censor & Spy; Who Sent More Troops To The Middle East?; CNN Fabricates Antisemitism Quote | SYSTEM UPDATE #340
86.9K73 -
55:09
Flyover Conservatives
1 day agoHollywood’s Dark Side: The Transgender Symbol of Satan & the Rise of Baphomet - Clay Clark; The Cultural Shifts Away from Kamala Harris | FOC Show
39.8K16 -
2:28:50
WeAreChange
8 hours agoDiddy Foreknowledge Surfaces! All UNRAVELING Now In Hollywood?!
87.4K31 -
1:20:48
Michael Franzese
1 day agoDemocrat's Message: "Who will rid us of Trump?" | Michael Franzese LIVE! Ep. 20
64.9K193 -
1:06:31
Josh Pate's College Football Show
7 hours agoWeek 5 Predictions: UGA vs Alabama | OU vs Auburn | Big JP Poll Moves | Surprises & Disappointments
47.9K4 -
1:10:38
The Anthony Rogers Show
11 hours agoEpisode 241
18.9K2 -
54:45
LFA TV
1 day agoTargeting Donald Trump | Trumpet Daily 9.24.24 9PM EST
24.2K13 -
59:23
The StoneZONE with Roger Stone
7 hours agoFmr. FBI Agent Questions West Palm Attack On Trump | The StoneZONE w/ Roger Stone
35.1K16 -
1:10:30
Edge of Wonder
7 hours agoDiddy’s Downfall: How the Power of Music Can Be Weaponized
34.4K11