XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Two XML files. Two Tables. One XSLT file. NEED to populate on webpage
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> - Two XML files. Two Tables. One... (3)
-> ->Two XML files. Two Tables...
-> ->Two XML files. Two Tables...
-> + Saxon 9.3 with XSLV (2)
-> - How do I remove the text strin... (1)
-> + Xpath of each element (3)
-> + Attributes - required vs optio... (2)
-> + XML schema to XML schema with ... (2)
-> + how to preserve the & in X... (2)
-> + how to use variables within (2)
-> + need help in XSLT programming (3)
-> + XSLT Mapper Option... Where i... (3)
-> - Selecting element based on att... (1)
-> + replace question (2)
-> - select other node based on one... (1)
-> - XSLT question... (1)
-> - Mapper and XSL (1)
-> - Copying XML as is with one cha... (1)
-> - Help with XSLT (1)
-> - XSL repeat the parent node for... (1)
-> - xls to xml (1)
-> - Stylus support non-backreferen... (1)
-- Previous [121-140] [141-160] [161-180] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
mike nicholsSubject: Two XML files. Two Tables. One XSLT file. NEED to populate on webpage
Author: mike nichols
Date: 14 Jul 2011 05:55 PM
Hello I have two xml files that I want to populate into two tables on a webpage. I am not sure how to do this? Is it best to merge the xml files into one and then use the template method to call out different parts of the xml? Any help would be very appreciated...

----------------------------------------
Files:
delivery_and_activity.xsl
delivery.xml
activity.xml
-----------------------------------------

delivery_and_activity.xsl
----------------------------------------------
<?xml version="1.0" encoding="utf-8"?><!-- DWXMLSource="delivery.xml" -->
<!DOCTYPE xsl:stylesheet [
<!ENTITY nbsp "&#160;">
<!ENTITY copy "&#169;">
<!ENTITY reg "&#174;">
<!ENTITY trade "&#8482;">
<!ENTITY mdash "&#8212;">
<!ENTITY ldquo "&#8220;">
<!ENTITY rdquo "&#8221;">
<!ENTITY pound "&#163;">
<!ENTITY yen "&#165;">
<!ENTITY euro "&#8364;">
]>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="utf-8" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>
<xsl:template match="/">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>test</title>
</head>
<body>
<h2>Delivery Summary</h2>
<table >
<thead>
<tr>
<th width="165" scope="col">Type</th>
<th width="209" scope="col">% of Attempted to Deliver</th>
<th width="90" scope="col">Total</th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<xsl:for-each select="DELIVERY/SUMMARY">
<tr>
<td><xsl:value-of select="TITLE"/></td>
<td><xsl:value-of select="ATTEMPTED"/></td>
<td><xsl:value-of select="TOTAL"/></td>
</tr>
</xsl:for-each>
</tbody>
</table>
<h2>Activity Summary</h2>
<table >
<thead>
<tr>
<th width="165" scope="col">Type</th>
<th width="209" scope="col">% of Successfully Delivered</th>
<th width="90" scope="col">Total</th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<xsl:for-each select="DELIVERY/SUMMARY">
<tr>
<td><xsl:value-of select="TITLE"/></td>
<td><xsl:value-of select="ATTEMPTED"/></td>
<td><xsl:value-of select="TOTAL"/></td>
</tr>
</xsl:for-each>
</tbody>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>


delivery.xml
---------------------------------------------
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="delivery_and_activity.xsl"?>
<DELIVERY>
<SUMMARY>
<TITLE>Attempted to deliver</TITLE>
<ATTEMPTED>100</ATTEMPTED>
<TOTAL>21256</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Hard Bounces</TITLE>
<ATTEMPTED>.68</ATTEMPTED>
<TOTAL>145</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Soft Bounces</TITLE>
<ATTEMPTED>4.48</ATTEMPTED>
<TOTAL>953</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Successfully delivered</TITLE>
<ATTEMPTED>94.8</ATTEMPTED>
<TOTAL>20158</TOTAL>
</SUMMARY>
</DELIVERY>


activity.xml
--------------------------------
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpy® -->
<ACTIVITY>
<SUMMARY>
<TITLE>Opened</TITLE>
<ATTEMPTED>22.96</ATTEMPTED>
<TOTAL>4629</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Clicked Through</TITLE>
<ATTEMPTED>4.10</ATTEMPTED>
<TOTAL>829</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Replied</TITLE>
<ATTEMPTED>0.12</ATTEMPTED>
<TOTAL>24</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Unsubscribed</TITLE>
<ATTEMPTED>0.25</ATTEMPTED>
<TOTAL>51</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Forwarded</TITLE>
<ATTEMPTED>0.00</ATTEMPTED>
<TOTAL>0</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>Subscribed</TITLE>
<ATTEMPTED>0.00</ATTEMPTED>
<TOTAL>0.00</TOTAL>
</SUMMARY>
<SUMMARY>
<TITLE>SpamComplaints</TITLE>
<ATTEMPTED>0.3</ATTEMPTED>
<TOTAL>6</TOTAL>
</SUMMARY>
</ACTIVITY>


Documentdelivery_and_activity.xsl
xsl

Unknownactivity.xml
Activity XML

Unknowndelivery.xml
Delivery XML

UnknownXML_DOM_Javacript.html
Javascript
Postnext
Ivan PedruzziSubject: Two XML files. Two Tables. One XSLT file. NEED to populate on webpage
Author: Ivan Pedruzzi
Date: 04 Aug 2011 10:34 AM

Change the second loop as follow

<xsl:for-each select="document('activity.xml')/ACTIVITY/SUMMARY">
Posttop
mike nicholsSubject: Two XML files. Two Tables. One XSLT file. NEED to populate on webpage
Author: mike nichols
Date: 05 Aug 2011 01:26 PM
Originally Posted: 05 Aug 2011 01:22 PM
Thanks alot. Multiple feeds are coming in now. Works great in FireFox and Opera. In IE8 nothing loads. Should I not be using a javascript to load the page? Would you load it with something else?

Anyway thanks and I like your sailing pic. If you make it out to Monterey CA I will take ya out on my boat.. hahha cheers.


This is the javascript that I am using to load the page
---------------------------------------------------------------

<html>
<head>
<script>
function loadXMLDoc(dname)
{
if (window.XMLHttpRequest)
{
xhttp=new XMLHttpRequest();
}
else
{
xhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xhttp.open("GET",dname,false);
xhttp.send("");
return xhttp.responseXML;
}

function displayResult()
{
xml=loadXMLDoc("delivery.xml");
xsl=loadXMLDoc("delivery_and_activity.xsl");
// code for IE
if (window.ActiveXObject)
{
ex=xml.transformNode(xsl);
document.getElementById("example").innerHTML=ex;
}
// code for Mozilla, Firefox, Opera, etc.
else if (document.implementation && document.implementation.createDocument)
{
xsltProcessor=new XSLTProcessor();
xsltProcessor.importStylesheet(xsl);
resultDocument = xsltProcessor.transformToFragment(xml,document);
document.getElementById("example").appendChild(resultDocument);
}
}
</script>
</head>
<body onload_="displayResult()">
<div id="example" />
</body>
</html>
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.