SSDN - Need help on Processing two xml and updating one among them - using xslt

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Ananda Kumar Maria Paul

Subject: 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

Tony Lavinio

Subject: 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?

James Durning

Subject: 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?

Ananda Kumar Maria Paul

Subject: 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

Tony Lavinio

Subject: 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.

Ananda Kumar Maria Paul

Subject: 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.

(Deleted User)

Subject: Need help on Processing two xml and updating one among them - using xslt
Author: (Deleted User)
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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.