Description Apart from on panels, it is often difficult to read tag archives and they cannot be displayed graphically without WinCC (TIA Portal). Tag values can be archived and evaluated in a CSV file in WinCC Runtime Advanced and with a panel.
Solution The Excel file "WinCC_TIA_ArchiveViewer" provides a VBA Script with graphical user interface and numerous operator input options.
Evaluation using pivot table
Graphical display of values as pivot diagram
Evaluation only of selected files (value_archiv0.csv, for example)
Changing the diagram types
Showing/hiding time buttons
Selection of value display (mean value, maximum value, total, ...)
Time selection (year/month/day/hour/minute)
The VBA Script is compatible with archives created with the WinCC (TIA Portal) Panel or PC Runtime as well as with the WinCC flexible Panel or PC Runtime.
Copying the archive to a PC
For evaluation the tag archive must be located in the same directory as the Excel file with the VBA Script. For this, the "data_transfer" script copies a tag archive from a USB stick over the local network to a PC. The archive recording of the values is meanwhile not interrupted.
The panel must be integrated in a local network. A detailed description is available in Entry ID 13336639.
Change the archive storage locations in the script to suit your configuration. You can download the txt file "data_transfer" and integrate it as script in your WinCC flexible or WinCC (TIA Portal) project.
Tag archive storage location on the PC Insert the "WinCC_TIA_ArchivViewer_e.xlsm" file together with the archive files (in this example: "value_archiv0.csv") in a folder to start the evaluation.
Start evaluation of the archive data The first time you start the "WinCC_TIA_ArchivViewer_e.xlsm" file you enable the macros and then click "No" in the query that follows.
Enter archive files
You enter the name of the archive file (in this example: "value_archiv0.csv") in column "B", line two under "File name".
In column "A" under "enable" you enter "1" to enable the archive.
Then click 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 (TIA Portal) or WinCC flexible.
Note When using very extensive archives (several hundred thousand data records), depending on your computer configuration there might be Excel runtime errors ("runtime error 1004) when executing the script.
In this case you should reduce the size of your archive.
Creation and test environment
The following table lists the components that have been used to create this entry and verify the functions described.
Each of the three backup options provides you with a quick way of starting up again after a system failure or replacement of devices. The backed-up data is transferred to the new Comfort Panel and the original status is restored.
Note It is not possible to open and process the backup file with WinCC (TIA Portal). The file can only be downloaded to the original or another panel of the same type with a restore procedure.
Automatic backup If you enable automatic backup, the Comfort Panel saves all the data necessary for operation on a SIMATIC HMI memory card. You can slot the SIMATIC HMI memory card into any operator panel of the same type. When you switch on the power on the identical operator panel the "Use system card?" message prompts you to enable the Service concept. The contents of the SIMATIC HMI memory card are copied automatically into the internal memory. Then the operator panel is rebooted.
In the Comfort Panel manual, the section given below informs you how to parameterize automatic backup on the SIMATIC HMI memory card: "Comfort Panels > Commissioning the device > Using the service concept > Enabling the service concept".
The decisive advantage of the automatic backup is that the data is continuously updated automatically on the system memory card.
Backup/Restore with a memory card During saving (backup), the operating system, applications and data are copied from the internal flash memory of the operator panel to the memory card.
When you restore, the flash memory of the operator panel is deleted after a prompt. Then the data backed up on the memory card is copied to the internal flash memory.
Requirements A memory card with sufficient free space is slotted in the operator panel.
Slot the memory card into the operator panel. Start the operator panel and open the "Control Panel".
- "Service and Commissioning" if you are using WinCC V12.
- "Backup/Restore" if your are using WinCC V11.
Preparation First of all you run through the "Preparation" as described above.
Select memory card - WinCC V12:
Click the "Next" button. In the list box you select the memory card that you want to use for the backup and then click "Next". - WinCC V11:
In the list box you select the memory card that you want to use for Backup/Restore. Click "Next" to continue.
Overview of the backup files This overview shows you all the backup files created on the memory card. Click the "Backup" button to continue the backup procedure.
Under the "Choose your settings for Backup" item select the option for how you want the backup to be made from your operator panel. In this case we have chosen "Complete backup with license". Under the "File name" item you specify a name for the backup file. The program automatically attaches the current date and time to the file name. Click "Create" to start the backup procedure.
If the message is displayed indicating that a higher storage capacity is required, then proceed as follows.
Click "OK" to acknowledge the message and interrupt the backup procedure. Slot a memory card with the higher storage capacity into the operator panel. Restart the backup procedure.
Terminate backup The backup is completed when the "Backup operation successfully completed." message is displayed.
Acknowledge the message with "OK". Remove the memory card from the operator panel.
First of all you run through the "Preparation" as described above.
Select memory card
- For WinCC V12: Go to the "Restore" menu and click "Next". In the list box you select the memory card that you want to use for the restore and then click "Next".
- WinCC V11: In the list box you select the memory card that you want to use for the restore and then click "Next".
In the list box you select the backup file that you wish to have transferred to the operator panel. Click the "Restore" button to continue the restore procedure.
Run the restore procedure A message is displayed asking whether the restore procedure is to be continued. Here, all the data of the flash will be deleted on the operator panel.
Acknowledge the message with "Yes" if you want to start the restore procedure.
Acknowledge the message with "No" and then the following message with "OK" if you want to abort the restore.
Once the restore procedure has been completed, the "Restore operation successfully completed" message is displayed and the operator panel restarts. Note
Do not remove the memory card from the operator panel during the restart!
Backup/Restore with ProSave
Establish a connection Use a cable corresponding to the selected transfer to connect the panel to the PC. Switch on your Comfort Panel. Set the Comfort Panel to "Transfer Mode".
General settings Open ProSave and select the the "General" tab. Under "Device type" you select the Comfort Panel used. Under "Connection" you select the connection used to connect the panel to the PC, Ethernet, for example. Under "Connection parameters" you enter the IP address of the panel.
Go to the "Backup" menu and in the "Data type" menu you select the data that you want to have backed up. In this case "Complete backup with licenses". Under "Save as" you specify the path in which the complete configuration is to be saved. Start the backup procedure by clicking the "Start backup" button.
When the backup has been completed successfully, the message "The backup was created successfully" is displayed in the output window of ProSave.
Open the "Restore" menu. Under "Opening..." you open your backup file (*.brf file). Start the restore procedure by clicking the "Start restore" button.
When the restore procedure has been completed successfully, the message "The restore was successful" is displayed in the output window of ProSave.
After a restore, the panel has exactly the same connection parameters as the panel from which the backup originates. Make sure that no other panel has the same network parameters.
Creation environment This FAQ response was created with the software/hardware below.
Software / Hardware
SIMATIC ProSave Version V220.127.116.11
SIMATIC HMI TP900 Comfort
The application presents the service concept of the Comfort Panel and demonstrates your benefits as user.
Content of the application:
Presentation of the service concept.
Step-by-step instructions for creating the automatic backup.
Replacement of a defective operator panel.
Series commissioning of Comfort Panels as sample application.
Description Often, protected screens are configured that can only be operated or opened by people with administrator rights, for example. On a protected screen, you can configure a user administration or access to the Control Panel of the operator panel, for example.
This entry describes how to install the service site with the example of a user administration.
Problems arise if the administrator forgets his/her password or is locked out because of repeated incorrect entries. In this case, the complete project often has to be re-uploaded into the operator panel. This loses all the changes made in the user administration during Runtime. Furthermore, the necessary software might not be available to the customer.
As project author you create your own "service site" to which only you have access via a password without having to use any user administration.
Using the "ProSave" software you can backup/restore your passwords.
Tip 1 After commissioning you must always backup the "user administration". Save the data on a CF card, for example, or possibly in the flash memory of the operator panel. In this way you can always restore the "original state" if it should ever be necessary.
Please note that in this case all the passwords and user names changed subsequently will be overwritten.
To the "Cleared down" event of the screen in which user administration is executed and which contains the user view, you add the "ExportImportUserAdministration" system function for "Export". In addition, in the task planner, for the device settings you create a task with the event "1 hour". To this event you attach the "ExportImportUserAdministration" system function for "Import".
This ensures that all the changes in the user administration are saved. If users lock themselves out, they automatically get their original user rights back after 1 hour at the latest.
In the sample project attached you can only call a "protected" screen after the correct "value" has been entered in an IO field.
In the "Demo_Plant_Data" (Fig. 01), clicking on the company logo (1) opens an input field (2). By entering the correct "password" (value) a button is displayed via which you can call your configured "service site".
Configured on this "service site" is the "Import/Export" function of the user administration, for example. Optionally you can configure a button with the "Open Control Panel" function. You open the "Control Panel" with this button. There you can do a "Backup/Restore" of the configuration, for example. This function is particularly important if you have set the panel's "Autostart" to 0 seconds so that the user cannot access the "Control Panel" after a panel restart.
"Plant Data" screen
Add the internal tag "Password" of the data type "UInt".
In addition, add an "IO field" and assign the tag to this IO field.
Configure button with animation
Configure a button via which you call the relevant screen (service site).
Add the "Visibility" animation under "Properties > Animation > View".
Use the process tag created in Point 1 (Fig. 01) for this animation.
Define a "range" in which the "animation" is to be active. This can be your defined "password".
In this example the value is "12345".
Configure screen changes
Mark the configure "Service Menu" button.
Open the Properties of the button.
Add the "ActivateScreen" function under "Events > Click".
Select "Demo_Service_Site" as screen name.
Function in Runtime
Click the company logo to show the IO field for password input.
Enter the password (12345), which makes the "Service Menu" button visible.
Click the button to go to the Service Menu.
This procedure does not provide the user protection provided by a configured user administration and cannot substitute it.
Graphical button The IO field "Password" can be made visible using a graphical button.
Add the internal tag "Visibility" of the data type "Bool".
Add a button.
Add the "InvertBit" function under "Properties > Events > Click" of the button and as tag use the tag you created previously.
Add the "Visibility" animation as described in Point 2 (Fig. 03), but in this case use "Single bit" as process tag.
Reset to initial state When you click the "Service Menu" button, you switch to the service site. Prior to this, however, you must delete all the entries so that the service site is protected again. You must delete the data prior to changing screens. This is why the data is reset to the initial state when the "Demo_Plant_Data" screen is cleared down.
Add the following functions to the "Cleared down" event of the "Demo_Plant_Data" screen.
"ResetBit" with the "Visibility" tag
"SetTag" with the "Password" tag and the value 0
"Service Site" screen
Via the "Import" button you can import an existing user administration.
Via the "Export" button you can export an existing user administration.
Via the "Back" button you can get back to the previous screen.
Download The attached download contains the archived project with the functions described.
Description In this FAQ answer we describe how to create a screenshot in the WinCC (TIA Portal) configuration environment.
Instructions Follow the instructions in the table below to create a screenshot of the configured screens in WinCC (TIA Portal).
Open the required WinCC (TIA Portal) project.
Open the "HMI_1 > Screens" folder in the project navigation.
Select the menu command "Project > Print ..." (can also be selected with the key combination "Ctrl+P").
Click the "Print" button.
You can use the screenshots as soon as the printing procedure has been completed.
Note In WinCC (TIA Portal), you can also use the normal function of your operating system to create a screenshot. In the "Windows" operating system you simply press the "Print" key to create one screenshot. This is then stored in the Windows clipboard for further processing.
With WinCC Engineering (TIA Portal), how can you transfer an HMI configuration without configuration software to an operator panel (Pack&Go)?
With WinCC Engineering (TIA Portal) you can use the "Pack&Go" function to create a file with which you can transfer an HMI configuration to an operator panel without any configuration software.
The "Pack&Go" file contains:
The compiled project
The operating system image for the configured operator panel
A program for transferring the project to the operator panel
You need the ProSave software to reset (boot) the operator panel to its factory settings. More information is available in Entry ID: 19701610.
The Online Help of WinCC (TIA Portal) tells you in detail how to create a "Pack&Go" file and transfer it to an operator panel.
WinCC Advanced > Visualize processes > Compile and download > Compile and download project > Create "Pack&Go" file.
A configuration office creates a project for a new operator panel. The configuration engineer from the configuration office does not have direct access to the plant. Therefore, the configuration engineer sends the "Pack&Go" file per e-mail to his/her contact on site.
The contact unpacks the "Pack&Go" file on a PC that is linked to the operator panel over a network. Then he/she transfers the project from the PC to the operator panel.
All the operator panels configured in the relevant version are supported.
If the project is to be transferred via USB, you need a USB host-to-host cable or mini USB cable (Comfort Panel). More information about USB transfers is available in Entry ID: 19109408
If the project is to be transferred over PROFIBUS, the hardware interface and driver must be installed on the transfer PC. The driver for an MPI/PROFIBUS card is also installed by ProSave, among others. You can download ProSave in Entry ID: 10347815
If you have Windows Vista installed on your Transfer PC and you want to transfer the project to an operator panel running the Windows CE operating system, then you need administrator rights.
It is not possible to use "Pack&Go" for transfer via Routing.
Install ProSave if you want to transfer a "Pack&Go" file of WinCC (TIA Portal) from a computer to an operator panel. You can download ProSave in Entry ID: 10347815
The version of the configured operator panel must match the operating system image of the operator panel. If necessary use ProSave to do an OS update.
More information about doing an OS update is available in Entry ID: 19701610.
Further information and solutions are available at the following links.
What are the functional differences between the different SIMATIC panels?