show the entry list
WinCC flexible RT -- Product information -- General information
What support does Siemens AG offer to make products comply with FDA regulations?
Why does the "Lock program switching" function no longer work after upgrading from SIMATIC WinCC flexible Runtime 2008 SP2 to SP3?
What new features do Intel® Atom™ processors have and what advantages do SIMATIC IPCs with Intel® Atom™ processors offer when used with SIMATIC software?
Which licenses do you need to upgrade from WinCC flexible 2008 or WinCC V7 to WinCC V11 and in WinCC V11?
What should you watch out for when installing WinCC flexible 2008 SP3 or WinCC V11 SP2 on an HP notebook?
How resistant to chemicals are the SIMATIC HMI operator panels and Industrial PCs?
What options are there for creating a screenshot in WinCC flexible ES, WinCC flexible Runtime or on panels?
What support does Siemens AG offer to make use of WinCC flexible, WinCC flexible Runtime and panels that can be configured with WinCC flexible comply with FDA regulations?
What should you watch out with regard to licenses for WinCC flexible and panels?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
Which ports are used by WinCC flexible?
WinCC flexible Options -- Product information -- WinCC flexible /Sm@rtService (Teleservicing)
What options are there for creating a screenshot in WinCC flexible ES, WinCC flexible Runtime or on panels?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
How can you use a PC to simulate or realize sending e-mails in the case of an HMI station message?
What should you watch out with regard to licenses for WinCC flexible and panels?
What are the options for remote maintenance of a WinCC flexible Runtime system (Panel/PC) via the Internet (WAN)?
Connection to the SIMATIC WinCC flexible Sm@rtServer gets lost (with active screensaver or "Shut Down")
Why are not all the tabs visible under "Internet Settings" of the SIMATIC operator panels (only Windows CE devices)?
Why do you get the message "Under Construction" in WinCC flexible when attempting to connect to the MiniWeb with the HTML viewer?
Why, when you call the Sm@rtClient, is only an empty page displayed in the Internet Explorer?
How do you send e-mails from a Windows CE panel or PC with SIMATIC WinCC flexible?
How do you send short messages (SMS) from an SIMATIC WinCC flexible HMI station to a mobile phone?
WinCC flexible ES -- Creating HMI configurations -- Using archives
How do you use a script to determine whether a storage drive with removable media (USB stick, SD/MMC card) is ready for writing on an HMI device?
How can you safely copy or move archives in WinCC flexible?
How can you output batch data or archived data via an HMI operator panel?
How do you do long-term archiving with WinCC flexible?
How can you output tags from an SQL database via a trend archive?
What special points are there in the WinCC flexible function "Archive log file" in the "Move" mode?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
How can you have a trend archive displayed continuously updated after calling Trend View?
What do you need to watch out for when naming archives and when archiving tags in a csv file on Windows-based systems?
How can you store tags/data records event-triggered with date and time in a CSV file?
How are tags archived in WinCC flexible STRING?
Which external storage locations are available on the various operator panels (TIA Portal/WinCC flexible/ProTool) for archiving data?
How are tags and alarms logged in WinCC flexible?
How do you log tags in an SQL database and read them out again with WinCC flexible?
How can you have data from a tag log displayed in table form for panels or the WinCC flexible PC Runtime?
How can you read texts from and write texts to a CF card with a Windows CE Panel?
Micro Panels -- Operation and maintenance -- Saving data
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
How do you backup/restore with a Windows-based panel?
How can you make a project backup from an operator panel?
Mobile Panels -- Operation and maintenance -- Saving data
How do you backup/restore with a Windows-based panel?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
How can you make a project backup from an operator panel?
Exporting a password list without path specification
Touch Panel / Operator Panel -- Operation and maintenance -- Saving data
How do you backup/restore with a Windows-based panel?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
How can you make a project backup from an operator panel?
Exporting a password list without path specification
Multi Panel -- Operation and maintenance -- Saving data
How do you backup/restore with a Windows-based panel?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
How can you make a project backup from an operator panel?
Exporting a password list without path specification
WinCC flexible Options -- Product information -- WinCC flexible /Archives
What support does Siemens AG offer to make products comply with FDA regulations?
What support does Siemens AG offer to make use of WinCC flexible, WinCC flexible Runtime and panels that can be configured with WinCC flexible comply with FDA regulations?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
What should you watch out with regard to licenses for WinCC flexible and panels?
How do you have csv archive files exported from WinCC flexible RT or a panel displayed graphically on the PC?
Part number:

Introduction:
In the Runtime mode of WinCC flexible, you can store tag values in archives and evaluate them later. These tag archives are difficult to read outside the panel and cannot be evaluated graphically without WinCC.

Solution:
The Excel file "WCf-ArchivViewer" provides a graphical user interface via VBA script, which provides numerous operator input options. In the "WCf-ArchivViewer", all you have to do is enter the names of the archive files. Here, when reading in the archive files, it is also possible to select just the data you require. The "WCf-ArchivViewer" provides numerous options for evaluating the archive files, e.g.:

  • Graphical user interface as pivot diagram
  • Evaluation using pivot table
  • Compression of time values (removal of time buttons)
  • Compression of value display (mean value, maximum value, buzzer, ...)
  • Time selection (year/month/day/hour/minute)
  • Change the diagram types
  • Selection of desired trends

Attachment 1: WCf_ArchivViewer.xls ( 52 KB )

Sample program:
The example describes how the tag archives created can be evaluated in the "WCf-ArchivViewer" without interrupting their recording.
The "Temp_1" tag archive has been created in the example, in which the tag "test_tag" is archived.
The archive is stored on a USB stick on the panel. It should be possible to evaluate the archive at any time with the "WCf-ArchivViewer" without interrupting recording of the values.
For this, you must integrate the panel into an existing local network. A detailed description of this is available in Entry ID: 13336639.

The sample project contains a script that you have to change to suit your configuration. Here you change your paths for the storage locations.


Fig. 01

Procedure for evaluating the archive on the PC:

  1. When you first start the Excel table, the following query is displayed. Click on the "No" button.

    Fig. 02
  2. On the operator panel you use the "Copy to PC" button to copy the archive file from the panel to the computer specified.
  3. Place the "WCf-ArchivViewer" with the archive files in a folder to start evaluation.
  4. Open the "WCf-ArchivViewer" and enter the archive file "Temp_10.csv" in the second row (under File name). In the left column, you enter a "1" (under Enable) to active the archive.
    Then lick on the "Read in archive data and create graphics" button. Acknowledge the dialog displayed with "Yes".
    Now, you can visually evaluate the recorded values without needing any component of WinCC flexible.


Fig. 03

Note:
Another option is to use Sm@rtService.
Using Sm@rtService you can connect to the operator panel and download individual files to your local PC and then evaluate them.

Attachment 2: Archiv_Viewer_Beispielprojekt.zip ( 2028 KB )
 
Components Product and version designation
HMI software WinCC flexible 2008 SP1
HMI Panel MP 277 10" Touch
Office software MS Excel 2003 (German version and Regional Options)

Runnability and test environment:
The tables above list the components that have been used to create this entry and verify the functions described.

 Entry ID:35929465   Date:2009-10-26 
I regard this article....as helpfulas not helpful                                 
mySupport
My Documentation Manager 
Newsletter 
CAx-Download-Manager 
Support Request
To this entry
Print
Create PDF 
Send to a friend
QuickLinks
Compatibility tool 
Help
Online Help
Guided Tour