* Cantinho Satkeys

Refresh History
  • FELISCUNHA: ghyt74   49E09B4F  e bom feriado   4tj97u<z
    Hoje às 10:39
  • JPratas: try65hytr Pessoal  h7ft6l k7y8j0
    Hoje às 03:51
  • j.s.: try65hytr a todos  4tj97u<z
    30 de Outubro de 2024, 21:00
  • JPratas: dgtgtr Pessoal  4tj97u<z k7y8j0
    28 de Outubro de 2024, 17:35
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  k8h9m
    27 de Outubro de 2024, 11:21
  • j.s.: bom fim de semana   49E09B4F 49E09B4F
    26 de Outubro de 2024, 17:06
  • j.s.: dgtgtr a todos  4tj97u<z
    26 de Outubro de 2024, 17:06
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana
    26 de Outubro de 2024, 11:49
  • JPratas: try65hytr Pessoal  101yd91 k7y8j0
    25 de Outubro de 2024, 03:53
  • JPratas: dgtgtr A Todos  4tj97u<z 2dgh8i k7y8j0
    23 de Outubro de 2024, 16:31
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    23 de Outubro de 2024, 10:59
  • j.s.: dgtgtr a todos  4tj97u<z
    22 de Outubro de 2024, 18:16
  • j.s.: dgtgtr a todos  4tj97u<z
    20 de Outubro de 2024, 15:04
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  101041
    20 de Outubro de 2024, 11:37
  • axlpoa: hi
    19 de Outubro de 2024, 22:24
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    19 de Outubro de 2024, 11:31
  • j.s.: ghyt74 a todos  4tj97u<z
    18 de Outubro de 2024, 09:33
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    18 de Outubro de 2024, 03:28
  • schmeagle: iheartradio
    17 de Outubro de 2024, 22:58
  • j.s.: dgtgtr a todos  4tj97u<z
    17 de Outubro de 2024, 18:09

Autor Tópico: How to Log Modbus Data to Microsoft Access and Excel  (Lida 192 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Online mitsumi

  • Moderador Global
  • ***
  • Mensagens: 115395
  • Karma: +0/-0
How to Log Modbus Data to Microsoft Access and Excel
« em: 17 de Abril de 2020, 10:24 »


h264, yuv420p, 1280x720 |ENGLISH, aac, 48000 Hz, 2 channels | 1h 07 mn | 206.09 MB
Created by: Emile Ackbarali
Set up the Winlog Lite HMI Development application to log data from a Modbus slave to Microsoft Access and Excel

What you'll 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

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 this course is for:

Electrical Engineers
Electrical Technicians
Electrical Tech or Engineering Students
Process Control Technicians and Engineers
Process Automation Engineers
Download link:
Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction