XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Ananda Kumar  Maria PaulSubject: Need help on Processing two xml and updating one among them - using xslt
Author: Ananda Kumar Maria Paul
Date: 21 Sep 2007 06:36 AM
i got a doubt in xslt that needs to process two xmls.

src.xml

<?xml version="1.0" encoding ="ISO-8859-1"?>
<Products>
<product name="OS - Windows 2000 " >
<region name="south" sales="20M"/>
<region name="north" sales="10M"/>
</product>
<product name="OS - Windows NT" >
<region name="south" sales="10M"/>
<region name="north" sales="15M"/>
</product>
<product name="OS - Windows XP" >
<region name="south" sales="35M"/>
<region name="north" sales="15M"/>
</product>
</Products>

Report.xml

<xpath xmlns:saxon="http://saxon.sf.net/ "
xmlns:deltaxml="http://www.deltaxml.com/ns/well-formed-delta-v1 ">
<change type="WFmodify" >Products/product[1]/region[1]</change>
<change type="unchanged" >Products/product[3]/region[1]</change>
</xpath>
now, the question is that...

i need to take the xpath from Report.xml and find the match with the src.xml. The xpath is the value of the node change

once i found the match, i have to update the src.xml or create a new xml with the attribute added and the value of it will be that of the attribute type in Report.xml.

The output.xml should look like,

<?xml version="1.0" encoding ="ISO-8859-1"?>
<Products>
<product name="OS - Windows 2000 " >
<region name ="south" sales="20M" Change=" WFmodify"/>
<region name="north" sales="10M"/>
</product>
<product name="OS - Windows NT" >
<region name="south" sales="10M"/>
<region name="north" sales="15M"/>
</product>
<product name="OS - Windows XP" >
<region name= "south" sales="35M" Change="unchanged"/>
<region name="north" sales="15M"/>
</product>
</Products>
i tried in doing that. but i am not able to do it... moreover, i am new to XSLT.

please, help me in this.

Thanks in Advance.



Regards,

Ananda Kumar M

Postnext
Tony LavinioSubject: Need help on Processing two xml and updating one among them - using xslt
Author: Tony Lavinio
Date: 21 Sep 2007 09:57 AM
Which version of Stylus Studio are you using?

Postnext
James DurningSubject: Need help on Processing two xml and updating one among them - using xslt
Author: James Durning
Date: 21 Sep 2007 10:12 AM
Is it always a region that changes?
Is there any other way you can simplify the problem?

Postnext
Ananda Kumar  Maria PaulSubject: Need help on Processing two xml and updating one among them - using xslt
Author: Ananda Kumar Maria Paul
Date: 24 Sep 2007 01:59 AM
hi,

i am not using the stylus studio tool.
just using the notepad and executing with the java program to create the output xml.

Problem is:

XPaths of the src.xml will be given in the Report.xml as the value (PCData) of the node <change>. Task is to get the xpath(value of change node) from Report.xml and then try to find a match in src.xml.
once the match is found, then we need to generate a new xml(say output.xml). The node in src.xml that matched Xpath in Report.xml has to be appended with an attribute "Change" and the value of this will be from Report.xml.

Briefly saying, we need to take the value (xpath) of the node "change" and value of the attribute "type" from Report.xml and then update the src.xml with these values.

i have given an example of Src.xml and Report.xml and the output.xml also.

Waiting for the reply

Postnext
Tony LavinioSubject: Need help on Processing two xml and updating one among them - using xslt
Author: Tony Lavinio
Date: 24 Sep 2007 09:23 AM
This is the support forum for Stylus Studio.
If you are not using Stylus Studio, you will need to look
elsewhere for answers.
We suggest the xsl-list email list run by Mulberry Technologies.

Postnext
Ananda Kumar  Maria PaulSubject: Need help on Processing two xml and updating one among them - using xslt
Author: Ananda Kumar Maria Paul
Date: 25 Sep 2007 01:45 AM
Hi,

I have downloaded and started using "Stylus Studio 2006 Release 3 XML Enterprise Edition". My company will go for buying this later.

Now, help me on this.

Posttop
Alberto MassariSubject: Need help on Processing two xml and updating one among them - using xslt
Author: Alberto Massari
Date: 25 Sep 2007 05:54 AM
Hi,
I would use the Saxon extensions to parse all the XPath expressions and store their results in a node set; then write an identity transform that would check if the current node is in that node set, and add the appropriate attribute.

Hope this helps,
Alberto

P.S. You may want to download Stylus Studio 2007 release 2; the version you have (2006 rel 3) is one year old.

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
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.