|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-log-modbus-data-to-microsoft-access-and-excel/
课程评论：没有评论
课程名称：如何将Modbus数据日志记录到Microsoft Access和Excel 课程概述：过程控制数据的归档对于追踪过程性能和解决工厂问题至关重要。Modbus广泛用于通过人机界面（HMI）采集过程数据。HMI不仅能够读取实时数据，还能够将数据归档以便进一步分析。然而，HMI的一个常见缺点是归档数据通常以专有格式存储，这使得将数据导入其他系统进行进一步分析变得复杂。本课程详细介绍了如何使用Winlog Lite HMI将过程数据直接归档到Microsoft Access数据库和Microsoft Excel工作簿中。通过这种归档方式，数据导入的过程变得更简单、更快速。课程使用Modbus从站模拟器，该模拟器提供一个被视为线压的单一数据点。HMI被配置为每10秒归档一次这一数据点到Microsoft Access数据库和Excel文件中。课程中还引入了结构化查询语言（SQL）以及HMI脚本的示例。课程非常实用，学生可以按照视频中展示的步骤进行操作。事实上，课程鼓励学生积极参与，完成视频中的所有操作以达到最佳学习效果。
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.
