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 » Need help on Processing two xml and updating one among them - using xslt
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Remove leading Zeros from a st... (4)
-> + how to parse a html element fo... (2)
-> + Add namespaces to target messa... (2)
-> + XSLT Transformation - insertin... (3)
-> + Convert binary xml (9)
-> + XSLT Transformation (4)
-> + Generating hyperlinks (3)
-> + XSLT to PDF problem (with JAVA... (2)
-> + how to add onclick_ with try/c... (2)
-> + Keep table in one page. xsl-fo... (4)
-> + Cannot find a matching 2-argum... (3)
-> + Creating one string from a sub... (2)
-> + XSLT: Traversing XML twice for... (6)
-> + Copy element without namespace... (5)
-> + Create dynamic elemant name (2)
-> + XSLT: Traversing XML twice for... (3)
-> + Problem including Javascript (2)
-> + Looping through attributes (4)
-> + Transform values into elements... (4)
-> + Problem with deep node copy an... (2)
-> + Comparing Dates With ASP.NET 2... (3)
-> + Converting tree structure to h... (4)
-> + Attributes to element transfor... (2)
-> + XSLT transformation (2)
-> + XSLT transformation (5)
-> + xsl:character-map not working (2)
-> + Removing duplicates entries. (2)
-> + Image issues. (2)
-> + xsl transformation (4)
-> + XSL Question (5)
-> + how to insert xml file as an n... (2)
-> + Document Function (2)
-> + convert seconds to hh:mm:ss (5)
-> + how to remove attribute while ... (3)
-> + XSL-FO question (2)
-> + EDI 997 creation. (7)
-> + Line break within a tag in XML... (2)
-> + Contact Help Needed (2)
-> + ACK 997 (2)
-> + XSLT to output XML( which conf... (11)
-> + Retrieving all nodes where a c... (6)
-> + Verifying XML and XSD within X... (4)
-> + How to validate date format in... (3)
-> + XSLT question (2)
-> + Muenchian grouping (2)
-> + How to remove specific text en... (8)
-> + If Else Condition along with L... (2)
-> + SAXON Problem (2)
-> + comapring global variable valu... (2)
-> + copying the value of xsl in va... (2)
-> + Urgent:XSLT element value sel... (2)
-> + Ignoring first element using f... (2)
-> + EDI X12 to XML (4)
-> + XSLT FOR-EACH HELP (2)
-> + Sorting Help Needed (3)
-> + XSLT help with linking (2)
-> + selecting data into node set b... (2)
-> + Watch and Variable in Debug no... (4)
-> + Transforming XML to XML - grou... (2)
-> + Saxon 9.0 B support in debug m... (2)
-> + Repeating element question (2)
-> + Newly Purchased Version Not La... (2)
-> + xsl:include not finding file (5)
-> + JAXP and XSLT 2.0 / XPATH 2.0 (2)
-> + ASP:DropDownList trigger in Xs... (2)
-> + Auto-Skip empty values (2)
-> + retrieving a javascript functi... (2)
-> + need help (2)
-> + html tag ignored (2)
-> + Quick reply needed (8)
-> + xslt to remove namespaces but ... (2)
-> - Using a WSDL definition in an ... (1)
-> + XSL logic issue for simple inp... (6)
-> + Regarding XML namespace prefix... (4)
-> + Mapper reoganizes itself. (8)
-> + XSL Substring Removal (2)
-> + Regarding XSLT logic for a sim... (3)
-> + XSLT Transform documentation (2)
-> + XSLT stack trace in case of er... (3)
-> + No New Line (2)
-> - No New Line (1)
-> + howto loop through a sequence (2)
-> + xml and xsl and whitespace in... (2)
-> + XSL Date formatting (4)
-> + XSL to XSL Mapping using custo... (4)
-> + flat xml to nested xml comvers... (4)
-> + Including schema in scenario (2)
-> + DTDs and traversing (2)
-> + Help with transformation (2)
-> + Problem running XSLT against X... (2)
-> + Carriage return in the output (5)
-> + Generating XSLT to match a sch... (3)
-> + WYSIWYG editor (2)
-> + Grouping without For-Each (3)
-> + output XML using XSLT (8)
-> + Help configuring Xalan-j proce... (8)
-> + Convert Existing HTML pages to... (2)
-> + Generating Transformation - XS... (4)
-> + DOCTYPE public and system info... (2)
-> + Using EXSLT str:tokenize funct... (5)
-- Previous [661-680] [681-700] [701-720] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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
(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.
   
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.