基于VBS的WinCC数据归档以及报表的导出

WinCC data archiving and report derivation based on VBS

针对WinCC 7.0以下版本不能使用WinCC online table control控件对数据进行存储和接收的问题,通过编写VBScript全局脚本程序,将WinCC过程数据以数据表的形式记录于SQL数据库中,通过WinCC中VBS脚本实现对数据库的查询、筛选、用户归档。以某分板检测生产线归档板卡的信息归档过程为例,介绍了对过程数据的归档策略及具体实现,满足了企业对数据归档的要求,方便查询、统计等处理,同时避免了使用西门子专用归档选件带来的高开发成本。

In view of the problem that WinCC online table control can not be used to store and receive data in the version below 7.0,the data of WinCC process can be recorded in the SQL database in the form of data tables by compiling VBScript global script program,and the query,screening and user archiving of the database can be realized by VBS script in WinCC.The scheme achieves archiving of WinCC process data and facilitates query and statistics.It satisfies the requirement of data archiving for enterprises,and avoids the high development cost brought by using Siemens special archiving components.