Displaying .xml data in zenon Runtime
Situation:
How to show .xml data in zenon Runtime?
Remedy:
Using a xsl stylesheet data from a .xml file can be shown i.e. in a table form when using an html picture
Demo-Project: (see atachment 2010-03-01_12-49-29 xml_data_table_html.zip)
- project created in zenon 6.50 SP0 Build1
- xsl stylesheet is located in the folder "Others" (Addtional)
- variables are configured in an archive
- via a trigger variable the event-triggered archive is started
- via the function "Export archives" the archived values are exported into a .xml file
- via VBA the definied .xsl stylesheet is applied to the exported .xml file
- via VBA the picture switch function to the HTML-picture is modified an afterwards started
- if a variable has the status "INVALID" the according value will be displayed in red color
------------------------------------------------------------
Situation:
Wie können .xml Daten in der zenon Runtime in einer optisch ansprechenden Form dargestellt werden?
Abhilfe:
Mit der Definition eines Stylesheets (.xsl) können Daten einer .xml Datei z.B. in Tabellenform in einer HTML Seite dargestellt werden
Demo-Projekt: (im Anhang 2010-03-01_12-49-29 xml_data_table_html.zip)- Projekt in zenon 6.50 SP0 Build1 erstellt
- xsl Stylesheet befindet sich im Ordner "Others" (Addtional)
- Variablen sind in einem Archiv definiert
- über eine Trigger-Variable wird das ereignisgesteuerte Archiv ausgelöst
- über die Funktion "Export Archive" werden die Archivdaten in eine .xml Datei exportiert
- über VBA wird das definierte xsl Stylesheet der exportierten .xml Datei hinzugefügt
- über VBA wird die Bildumschaltfunktion zum HTML-Bild modifziert und anschließend ausgeführt
- Auswertung des Variablenstatus "INVALID" wird anhand eines roten Zahlenwertes dargestellt
This is a migrated post! Originally posted on 01.03.2010 by user herberto. Please be aware that information can be outdated.
Disclaimer
This document governs the use of our Community Forum. By registering and using the platform, you accept these conditions.
The COPA-DATA Community Forum serves to encourage the exchange of information and experience about the zenon software between forum users respectively zenon users.
Please mind that any published information on the Community Forum is the subjective opinion and view based on the experience and the level of knowledge of the author. COPA-DATA does not overtake any responsibility for the content and the accuracy of the shared information.
Users of the Community Forum are encouraged to share only well-founded experiences and to point out any risks associated with the implementation of proposed solutions to problems. COPA-DATA at its absolute discretion, reserves the right to moderate the forum. In this connection COPA-DATA may remove any information containing false facts, potentially dangerous solutions, bad language or content that may insult, degrade or discriminate others. COPA-DATA may block a non-complying user from forum access if the user violated this provision.
COPA-DATA reserves the right to change this document from time to time at own discretion.
Ing. Punzenberger COPA-DATA GmbH
Karolingerstraße 7b · 5020 Salzburg · Austria
www.copadata.com