How to Log Modbus Data to Microsoft Access and Excel
4.9 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
125 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to Log Modbus Data to Microsoft Access and Excel to your Wishlist.

Add to Wishlist

How to Log Modbus Data to Microsoft Access and Excel

Set up the Winlog Lite HMI Development application to log data from a Modbus slave to Microsoft Access and Excel
4.9 (16 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
125 students enrolled
Created by Emile Ackbarali
Last updated 2/2017
English
Curiosity Sale
Current price: $10 Original price: $40 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Have an appreciation for the basic Structured Query Language commands
  • Build a Human Machine Interface to capture a Modbus data point
  • Configure a Human Machine Interface to log data to a Microsoft Access database
  • Configure a Human Machine Interface to log data to a Microsoft Excel file
  • Have an introductory appreciation for HMI scripting
View Curriculum
Requirements
  • Basic working knowledge of the Modbus RTU protocol.
  • Familiarity with the installation of software applications on the Windows OS platform
  • Familiarity with Microsoft Access and Excel
Description

Archival of process control data is paramount to tracking of process performance and troubleshooting of issues with the process plant. Modbus is used heavily to acquire process data via the use of Human Machine Interfaces (HMIs). HMI's typically have the ability to not only read real-time data but also to archive that data for further analysis. A frequent drawback of HMIs is that archived data is usually stored in a proprietary format, which can make porting data to other system for further analysis problematic.

This course details the use of the Winlog Lite HMI in archiving process data directly to a Microsoft Access database as well as a Microsoft Excel workbook. By being able to do this type of archival, porting of data becomes much easier and faster. 

The course uses a Modbus slave simulator from which the HMI acquires a single data point which is deemed a line pressure. The HMI is then configured to have this data point archived every 10 seconds a Microsoft Access database as well as a Microsoft Excel file. Structured Query Language (SQL) is introduced to the student as well as an example of HMI scripting.

The course is very practical and the student can perform all tasks that are shown in the videos. In fact, throughout the course, students are strongly encouraged to do all that is show in the videos for maximum learning effect.

Who is the target audience?
  • Electrical Engineers
  • Electrical Technicians
  • Electrical Tech or Engineering Students
  • Process Control Technicians and Engineers
  • Process Automation Engineers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
01:08:35
+
Introduction
2 Lectures 07:07

Using a schematic, the architecture of the software configuration that will be used in the course.

Preview 03:13
+
Downloading the Software Applications
4 Lectures 09:04

Modsim32 is a Modbus slave simulation application. It will be used to provide data values that will be read by the HMI application and logged to Access and Excel.

Preview 01:44

Virtual Serial Port kit is an application that creates virtual com ports in Windows. It creates the ports in pairs and ties them together in a null modem fashion.

Preview 02:07

Winlog Lite is an HMI Development Application. It will be used to build an HMI application that will read data from the Modbus slave and then constantly log those data values to Access and Excel.

Preview 02:22

+
Building a Basic Single Master / Slave Modbus Network
3 Lectures 14:26

Modsim32 is configured as a Modbus slave device with only 1 Input Register. A single virtual port pair is configured in Virtual Serial Port kit. 

Preview 05:15

Channels, Devices and Gates are configured in the application to acquire data from a single input register in Modsim32. 

Configuring Channels, Devices and Gates in Winlog Lite
05:34

A template screen is configured with a single object to view the value. The HMI application is then run.

Configuring Templates and Running the HMI Application
03:37
+
Configuring Microsoft Access and Excel for Data Logging
2 Lectures 08:21

The MS Access database as well as the Excel file will act as data stores for the logged data.

Creating the MS Access Database and the MS Excel File
05:09

Data Source Names allow databases of different types to be interfaced to in a common way. 

Creating the Data Source Names (DSN)
03:12
+
Using SQL for Reading from and Writing to the Databases
2 Lectures 07:56

This command is used to insert new data into a database table.

The INSERT INTO SQL Command
05:22

This command is used to read data from a database table.

The SELECT SQL Command
02:34
+
Configuration of the Logging to the MS Access and Excel
5 Lectures 19:06

A new channel (#2) is configured to link to the ODBC DSN, which is connected to the MS Access database.

Configuration of the ODBC Channel
03:40

A gate is created, whose value will be written to the VALUESP column of the database table.

Configuration of a new Gate and Modification of the INSERT SQL Query
05:31

A code script called "Main'" is written with periodically copies the value of LINE_PRESSURE to LINE_PRESSURE_DB.

Writing a Code Script to copy the Modbus value
03:10

The HMI application is run and the Modbus value is changed in Modsim32. The database is then opened to check for logged data.

Running the HMI application and Logging Data to MS Access
02:55

The HMI application is modified and then run again to see if data is being logged to the excel file.

Modifying the HMI application to Log Data to Excel
03:50
+
Conclusion
1 Lecture 02:35

What to do next to keep further solidify learning.

The End - Where To Go From Here
02:35
About the Instructor
Emile Ackbarali
4.5 Average rating
1,036 Reviews
2,520 Students
13 Courses
Software Developer, Systems Integrator and Entrepreneur

I have been working in the fields of Software Development, Software Systems Integration and Process Automation since 1996. In 2003, I stepped out on my own and started working for myself providing software development and systems integration services to small and medium businesses.

I am also associated with a great company called Mora Systems Limited that under the leadership of it's Managing Director has produced innovative and outstanding products and services in the fields of GIS and Cellular based SCADA.

Teaching has always been a passion for me. I have taught at the tertiary level for many years on the subjects of programming, control systems as well as systems integration. In the last few years I found myself incorporating more and more videos into the curriculum with amazing results.

When I heard of uDemy I just could not help but sign up. With teaching in a classroom, you can reach only so many students, but with uDemy you can reach the world! I plan to publish and promote as many courses as I possibly can on the uDemy platform.