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.
-
18:44
AccAutomation
2 years agoSimple Click PLC Data Logging
13 -
15:54
AccAutomation
2 years agoDo-More PLC Node-RED HTTP Request
4 -
6:02
Fusion Automate
8 months agoNode RED as a Soft PLC | Control WIN-IO-4AOMV & WIN-IO-4DDAM Modbus Serial IO Card from Node-RED |
22 -
16:46
Shane Welcher
2 years agoSetup Studio 5000 Produced Consumed Data | PLC Processor Communication
16 -
12:58
Fusion Automate
9 months agoModbus TCP Device Data Logging in MySQL Database from Node-RED | IoT | IIoT | Industry 4.0 |
7 -
8:27
Insights In Automation
1 year agoFactoryTalk ViewSE Data Logging and Reporting Options
1 -
13:24
Shane Welcher
2 years ago $0.01 earnedUsing Pylogix to Read PLC Data through a Python3 GUI
12 -
13:14
Fusion Automate
9 months agoModbus TCP/IP Device Data Logging in SQLite Database from Node-RED | IoT | IIoT | Industry 4.0 |
6 -
16:10
Insights In Automation
1 year agoRead Logix Tags Values Into An S7 PLC Over Ethernet
14 -
13:12
Fusion Automate
8 months agoHow to Log Modbus Serial Device Data in SQLite Database using Node-RED
28