This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



~Fritz Asajumiterli
Jan 27, 2012, 11:33 AM
11 Posts

Convert XML to HML Table

  • Category: Other Domino Designer Tooling
  • Platform: All
  • Release: 8.5.2
  • Role: Developer
  • Tags:
  • Replies: 1
 Hi,
 
I have created a workflow application, In that application there is a form named - Request.  I am showing that form details using an XPage on the web.
 
In that form I have created a field $WorkflowLog. That field contains the workflow log in the XML format.
 
Now I want to show the data stored in the XML format in the HTML table format. Please guide how to do this.   
 
Below is the XML example
 
 
Input XML  
<WorkflowLog><Date>1/26/2012 9:01:33 AM</Date><Actioner>CN=emp3/O=velocis</Actioner><Action>Submit</Action><Comments> </Comments><Date>1/26/2012 12:35:04 PM</Date><Actioner>CN=emp3/O=velocis</Actioner><Action>Unsubmit</Action><Comment s></Comments><Date>1/26/2012 12:39:24 PM</Date><Actioner>CN=emp3/O=velocis</Actioner><Action>Submit</Action><Comments> </Comments><Date>1/26/2012 12:44:37 PM</Date><Actioner>CN=emp3/O=velocis</Actioner><Action>Unsubmit</Action><Comment s></Comments><Date>1/26/2012 12:46:43 PM</Date><Actioner>CN=emp3/O=velocis</Actioner><Action>Submit</Action><Comments> </Comments><Date>1/26/2012 12:49:18 PM</Date><Actioner>CN=emp3/O=velocis</Actioner><Action>Unsubmit</Action><Comment s></Comments><Date>1/26/2012 12:50:35 PM</Date><Actioner>CN=emp3/O=velocis</Actioner><Action>Submit</Action><Comments> </Comments><Date>1/26/2012 7:17:53 PM</Date><Actioner>CN=emp7/O=velocis</Actioner><Action>Approve</Action><Comments ></Comments></WorkflowLog> 
 
Desired Output 
 The HTML Table. 
 
 
Thanks, 
Atin 
~Andy Froresaberggon
Jan 29, 2012, 5:39 PM
2 Posts
Re: Convert XML to HML Table
XSLT is what you need.
See sample for bowser side conversion: http://www.w3schools.com/xsl/xsl_transformation.asp
There are also easy to use java classes to do this transformation server side (recommended).

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal