WINCC
Export of WinCC / CAS Archive Data using the WinCC OLE DB Provider
PurposeExport of the Tag and Alarm Logging archives and provision of the information in an appropriate way (e.g. as *.csv or *.xls).
Background
The WinCC Runtime database is segmented for WinCC V6.0 and higher. This means that the data is stored in several archive segments (several databases), partly in compressed, binary form.
Both WinCC and the WinCC “WinCC Connectivity Pack” option provide the WinCC OLE DB Provider. It enables direct reading of the Tag Logging and Alarm Logging Runtime data. The WinCC OLE DB Provider provides the data from the respective archive segments in decompressed, decrypted form. Thus the user does not have to worry about the segmentation of the archives and their encryption when accessing the Tag Logging and Alarm Logging data.
Realization
To cover a maximum of the use cases two applications have been developed, whereas each has its own focus:
1. The Excel Application "OLE-DB Tag and Alarm Export.xls"
2. The C# Application "WinCCcopack.exe"
In the following the basic characteristics of both solutions will be explained.
Excel Application
PurposeExport of the Tag and Alarm Logging archives and provision of the information in an appropriate way (e.g. as *.csv or *.xls).
Background
The WinCC Runtime database is segmented for WinCC V6.0 and higher. This means that the data is stored in several archive segments (several databases), partly in compressed, binary form.
Both WinCC and the WinCC “WinCC Connectivity Pack” option provide the WinCC OLE DB Provider. It enables direct reading of the Tag Logging and Alarm Logging Runtime data. The WinCC OLE DB Provider provides the data from the respective archive segments in decompressed, decrypted form. Thus the user does not have to worry about the segmentation of the archives and their encryption when accessing the Tag Logging and Alarm Logging data.
Realization
To cover a maximum of the use cases two applications have been developed, whereas each has its own focus:
1. The Excel Application "OLE-DB Tag and Alarm Export.xls"
2. The C# Application "WinCCcopack.exe"
In the following the basic characteristics of both solutions will be explained.
Excel Application
Purpose of this applicationC# Application
These are the basic features of this application:
The documentation focuses on the description of the function and application as well as on the illustration of the main adjustment options.
- Realization as an Excel macro
- Automatic readout of most of the information which are required to establish the connection
- Communication via the OLE DB provider
- Reading out the data from the WinCC Runtime database of an OS server or a CAS (Central Archive Server)
- Individual combination of the process value and message information
- Possibility of interpolation for missing values (process values)
- Accessing the archives of different languages (messages)
- Using filters such as time interval and message type (messages)
- Interpreting the wildcards in the message texts (messages)
Validation
- Created with MS Excel 2003
- Tested with SIMATIC WinCC V6.0 SP3a to V7.0 SP1
Purpose of this application
These are the basic features of this application:
The documentation focuses on the description of the function and application as well as on the development of such an application.
- Stand-alone application
- Communication via the OLE DB provider
- Reading out the data from the WinCC Runtime database of an OS server or a CAS (Central Archive Server)
- Accessing the archives as database user with password
- Can read user archives
- Using the time filter
- Can export the gathered information as *.csv or via CrystalReports
Validation
- Created with Visual Studio 2005 Professional and Crystal Report 2008
- Tested with SIMATIC WinCC V6.2 and V7.0
Komentar
Posting Komentar