Node-RED SQL Database Log – Modbus Logging

Node-RED SQL Database Log - Modbus Logging

Node-RED can easily log data to a database. SQL (Structured Query Language) can be used to communicate to a SQL database. Databases separate analysis from the data unlike spreadsheets like Excel. The database is designed to hold more information than spreadsheets and allow multiple users to access the information. We will be creating an SQLite … Read more

Click PLC Logging Data with Time and Date Stamp

We will now look at logging data with time and date in the Click PLC. The Click PLC can perform indirect addressing. This means that I can ask for information to be moved to and from locations in the PLC using a pointer that will indicate the address. Stephen Covey in The 7 Habits of … Read more

Productivity 2000 PLC Data Handling Part 2

Productivity 2000 PLC Data Handling Part 2

Data handling instructions are used to perform movement and manipulations of the memory in the programmable logic controller. The Productivity 2000 Series PLC has fifteen different data handling instructions that can be used in various applications. This includes all of the data handling instructions. Understanding the full capability of the PLC that you are programming … Read more

Productivity 2000 PLC Data Handling Part 1

Productivity 2000 PLC Data Handling Instructions Part 1

Data handling instructions are used to perform movement and manipulations of the memory in the programmable logic controller. The Productivity 2000 Series PLC has fifteen different data handling instructions that can be used in various applications. It is important to look at the capabilities of your programmable logic controller. This will lead you to different … Read more

Productivity 2000 Series PLC Tag Database

Productivity 2000 Series PLC Tag Database

The Productivity Suite Software allows us to use tags in the PLC. Tags are a method for assigning and referencing memory locations (numbering systems) within the programmable logic controller. They allow a more structured programming approach and are stored within a tag database. The tag database is stored in the memory of the Productivity Series … Read more

Click PLC Retentive Data Memory Registers

Click PLC Retentive Data Memory Registers

The Click PLC retentive data memory registers are not included in the program file by default. All Click PLC CPUs are included. This option must be selected to include the C, CT, DS, DD, DH, DF, CTD, and TXT memory in the Click project file. We will be enabling the option to include the retentive … Read more

Node-RED SQL Database Spreadsheet Connection

Node-RED SQL Database Spreadsheet Connection

We will now look at the connection to our SQL database using a spreadsheet application. Previously we used Node-RED to communicate Modbus TCP and RTU to our Click PLC and Solo Temperature Controller. The information collected from the controllers was then put into an SQLite SQL database. Spreadsheets like Excel are great for analysis of … Read more

Productivity P1AM Arduino Variables Data Types

We will look at Arduino variables data types that can be used with our P1AM unit. Data types in the C++ language are used to determine the variable or function applied for the given type. The type will determine the size of the storage (bits), and the method to interpret the information. Microprocessors can only … Read more

Productivity 1000 Series PLC Data Logger

The productivity series of PLCs has a built in data logger. This easy data logger will log up to 64 tag values on a USB (Micro SD) storage device connected to the CPU. The logs will be stored in CSV (Comma Separated Values) file format. Logging can be triggered by the rising edge transition of … Read more

Productivity 1000 PLC Data Handling Part 2

Data handling instructions are used to perform movement and manipulations of the memory in the programmable logic controller. The Productivity 1000 Series PLC has fifteen different data handling instructions that can be used in a wide variety of applications. In this second part we will be looking at the following instructions: Lookup Table (LKUP) – … Read more