Tag Archives: PLC Logging

Click PLC Logging Data with Time and Date Stamp




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 Highly Effective People said: “Begin With the End in Mind.” This is especially true when looking at storing or logging data within the programmable logic controller. (PLC) It is important to fully define what you want to accomplish with your program.

In our Click PLC example, we want to take a series of consecutive memory locations (DS1 to DS10) and store them in memory areas DS100 to DS4100 each minute. We will be able to store 400 entries (400 minutes) in our storage area. Every entry will include the real-time clock (RTC) of the Click. This will show the date and time of each entry. Let’s get started! Keep on Reading!

Creating a Database in SQL Server Express 2014

Microsoft SQL Server Express 2014 is a free, edition of SQL Server this is ideal for learning and developing desktop, web and small server applications. The database size can be 10 gigabytes in size. SQL Server Express 2014 release includes the full version of SQL Server 2014 Management Studio. We will be using SQL Server 2014 Management Studio (SSMS) to create a database. The SQL Server database will be created so we can connect to it for data acquisition (data logging) from our PLC applications. Continue Reading!

Installing SQL Server Express 2014

Microsoft SQL Server Express 2014 is a free, edition of SQL Server this is ideal for learning and developing desktop, web and small server applications. The database size can be 10 gigabytes in size. SQL Server Express 2014 release includes the full version of SQL Server 2014 Management Studio. This is a method to read, write and maintain our database. (Tools) We will be installing this SQL Server database so we can connect to it for data acquisition (data logging) from our PLC applications.

Installing the software
The download file can be obtained from the website for SQL Express 2014.
https://www.microsoft.com/en-ca/download/details.aspx?id=42299
We will be installing the ExpressAdv 64Bit\SQLEXPRADV_x64_ENU.exe on a windows 7 64 bit machine.
This is the latest software that can be installed on the Windows 7 operating system. Continue Reading!