Hi All,
I am writing an XSL to transform the XML to XML.Only change i need in xml is to add the value for the price element
under book tag for which publisher location is "World".
The value for the price tag should be the sum of the value of price tag of two book tags (location for one is US and location of other is India).
here is the snippets from the code: - book.xml
-
---------------------------------------------------
-
-
<?xml version="1.0" encoding="ISO-8859-1"?>
-
<?xml-stylesheet type="text/xsl" href="test.xsl"?>
-
<booklist>
-
<book>
-
<publisher>
-
<location>India</location>
-
<identity id="111">book.com</identity>
-
</publisher>
-
<title>bookname1</title>
-
<price>80</price>
-
-
</book>
-
-
-
-
<book>
-
<publisher>
-
<location>US</location>
-
<identity id="222">usbook.com</identity>
-
</publisher>
-
<title>bookname2</title>
-
<price>60</price>
-
-
</book>
-
-
<book>
-
<publisher>
-
<location>UK</location>
-
<identity id="333">ukbook.com</identity>
-
</publisher>
-
<title>bookname3</title>
-
<price>50</price>
-
-
</book>
-
-
<book>
-
<publisher>
-
<location>Singapore</location>
-
<identity id="444">sgbook.com</identity>
-
</publisher>
-
<title>bookname4</title>
-
<price>50</price>
-
-
</book>
-
-
-
<book>
-
<publisher>
-
<location>World</location>
-
<identity id="000">worldbook.com</identity>
-
</publisher>
-
<title>bookname5</title>
-
<price></price>
-
-
</book>
-
</booklist>
-
-
-
-
---------------------------------------------------
- ----------------book.xsl--------------------------
-
-
<?xml version="1.0" encoding="UTF-8"?>
-
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
-
<xsl:output method="xml" media-type="text/xml" omit-xml-declaration="yes" version="1.0" />
-
-
<xsl:template match="/ | @* | node()">
-
<xsl:copy>
-
<xsl:apply-templates select="@* | node()"/>
-
</xsl:copy>
-
</xsl:template>
-
-
<xsl:template match="bookList/book" >
-
-
-
<xsl:copy>
-
<xsl:apply-templates select="@* | node()"/>
-
-
<xsl:if test="(publisher/location = 'India')">
-
<xsl:if test="(publisher/identity[@id] = '111')">
-
<xsl:variable name="A1SoloTotal"><xsl:value-of select="//booklist/book/price"/></xsl:variable>
-
</xsl:if>
-
</xsl:if>
-
-
<xsl:if test="(publisher/location = 'US')">
-
<xsl:if test="(publisher/identity[@id] = '222')">
-
<xsl:variable name="A2SoloTotal"><xsl:value-of select="//booklist/book/price"/></xsl:variable>
-
</xsl:if>
-
</xsl:if>
-
-
<xsl:if test="(publisher/location = 'World')">
-
<xsl:if test="(publisher/identity[@id] = '000')">
-
<price><xsl:value-of select='$A1SoloTotal'+'$A2SoloTotal'/></price>
-
</xsl:if>
-
</xsl:if>
-
-
</xsl:copy>
-
-
</xsl:template>
-
-
</xsl:stylesheet>
please get back to me today if you can help in any way.
thanks
Shakil
9  1806  Dormilich 8,658
Recognized Expert Moderator Expert
what exactly is your problem? at the first glance I don't see a mistake in the code (well, I had no time testing yet)
except one writing mistake, 'booklist/book' (template) and the value-of XPath (you're already starting at book, therefore: "price" (not "//booklist/book/price")
when I understand it right, you want: price(world) = price(US) + price(India) ? do you have in <booklist> only one book of US and India? or are there other constraints too?
regards
what exactly is your problem? at the first glance I don't see a mistake in the code (well, I had no time testing yet)
except one writing mistake, 'booklist/book' (template) and the value-of XPath (you're already starting at book, therefore: "price" (not "//booklist/book/price")
when I understand it right, you want: price(world) = price(US) + price(India) ? do you have in <booklist> only one book of US and India? or are there other constraints too?
regards
----------------------------------------------------------------------------------------------------------------
Thanks for your review.
The issue is with the declaration of variable The variable is not getting accessible in the clause where we are looking for the sum.
price(world) = price(US) + price(India) ? this is right
<xsl:if test="(publishe r/location = 'World')">
<xsl:if test="(publishe r/identity[@id] = '000')">
<price><xsl:val ue-of select= '$A1SoloTotal' + '$A2SoloTotal' /></price>
</xsl:if>
</xsl:if>
For first price Constraint is that the location should be US and id=222 .
For second price Constraint is that the location should be India and id=111.
Those two should go as the sum for the book tag having location World and id="000"
I hope it clears the issue?
The first issue is getting access to variable declared in different if clauses.
The other is how to put this as the sum for an element with blank text value?
 Dormilich 8,658
Recognized Expert Moderator Expert
after a bit of testing, I came to the conclusion that all XPath expressions were somehow screwed up. - ----------------book.xsl--------------------------
-
-
<?xml version="1.0" encoding="UTF-8"?>
-
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
-
<xsl:output method="xml" media-type="text/xml" omit-xml-declaration="yes" version="1.0" />
-
-
<xsl:template match="/ | @* | node()">
-
<xsl:copy>
-
<xsl:apply-templates select="@* | node()"/>
-
</xsl:copy>
-
</xsl:template>
-
-
<xsl:template match="bookList/book" >
-
<xsl:copy>
-
<xsl:apply-templates select="@* | node()"/>
-
<xsl:if test="(publisher/location = 'India')">
-
<xsl:if test="(publisher/identity[@id] = '111')">
-
<xsl:variable name="A1SoloTotal"><xsl:value-of select="//booklist/book/price"/></xsl:variable>
-
</xsl:if>
-
</xsl:if>
-
-
<xsl:if test="(publisher/location = 'US')">
-
<xsl:if test="(publisher/identity[@id] = '222')">
-
<xsl:variable name="A2SoloTotal"><xsl:value-of select="//booklist/book/price"/></xsl:variable>
-
</xsl:if>
-
</xsl:if>
-
-
<xsl:if test="(publisher/location = 'World')">
-
<xsl:if test="(publisher/identity[@id] = '000')">
-
<price><xsl:value-of select='$A1SoloTotal'+'$A2SoloTotal'/></price>
-
</xsl:if>
-
</xsl:if>
-
</xsl:copy>
-
</xsl:template>
-
-
</xsl:stylesheet>
I left out the xsl:copy because I didn't know what exactly you want to copy (so I concentrated on the 'world' issue), still
- why defining xsl:copy twice (inside and outside the second template)?
- if you want to copy a node without making any changes consider xsl:copy-of getting the world value:
- the xsl:template and xsl:apply-templates XPath looped for every book element, changed that to loop for every booklist (for the sole computation this was easier to start with)
- the xsl:variable's XPath returned a node-set: //booklist/book/price are all price elements (in your case), changed that to price (book/price respectivly, since I loop now for booklist), which is now relatively declared and thus a single node (resp. its string-value).
- I dropped the xsl:if conditions in favour of one XPath expression in xsl:variable using select attribute
- shortened the 'world' xsl:if to one condition (there's no need of two xsl:ifs)
- the syntax of the computation is wrong (missing quotation marks)
so finally I came up with - <xsl:template match="/">
-
<xsl:apply-templates />
-
</xsl:template>
-
-
<xsl:template match="booklist">
-
<xsl:variable name="A1SoloTotal" select="book/price[../descendant::location = 'India'][../descendant::identity/@id = '111']"/>
-
<xsl:variable name="A2SoloTotal" select="book/price[../descendant::location = 'US'][../descendant::identity/@id = '222']"/>
-
<xsl:if test="book/price[../descendant::location = 'World'][../descendant::identity/@id = '000']">
-
<price><xsl:value-of select="$A1SoloTotal + $A2SoloTotal"/></price>
-
</xsl:if>
-
</xsl:template>
there is still room for improvement (we could even make a parameter-dependent template.... depending on the file).
In the copy case I guess you want to copy the whole xml file with the value for 'World' inserted... there may be adaptions necessary. And I can probably think of a more elegant copy cycle, but this depends on the xml file.
regards
Dormilich 8,658
Recognized Expert Moderator Expert
oops, missed your first reply while posting #4
The issue is with the declaration of variable The variable is not getting accessible in the clause where we are looking for the sum.
- <xsl:if test="(publisher/location = 'World')">
-
<xsl:if test="(publisher/identity[@id] = '000')">
-
<price><xsl:value-of select='$A1SoloTotal' + '$A2SoloTotal' /></price>
-
</xsl:if>
-
</xsl:if>
this is because there's a syntax error. it is - // either
-
<xsl:value-of select="'$A1SoloTotal' + '$A2SoloTotal'" />
-
// which would probably return the values as string
-
// or
-
<xsl:value-of select='$A1SoloTotal + $A2SoloTotal' />
-
// this should do the computation
The other is how to put this as the sum for an element with blank text value?
I would rather create the whole world-book element in the xsl, then you could loop without condition and copy all book elements - <xsl:copy-of select="book" />
but there wouldn't be a problem in adding conditions, though.
for the computation, see my previous post
regards
PS: please use [code] tags when posting code
HI Dormilich,
While i was trying to put your idea to my other xml using the xsl , it didn't produce the desired result.
It converted to just the same original XML file. The transformed xml didn't have the added value.
It seems i had made a mistake somewhere . Please advise the change required.
I am stuck for three days. issue:
abc:TotalMortga gesPrincipalAmo unt Element in the third group should be the sum of MortgagesPrinci palAmount in group 1 and group 2.
group 1 where numericContext@ id = numericABCLevel _1
group 2 where numericContext@ id = numericABCLevel _2
oops, missed your first reply while posting #4
this is because there's a syntax error. it is
- // either
-
<xsl:value-of select="'$A1SoloTotal' + '$A2SoloTotal'" />
-
// which would probably return the values as string
-
// or
-
<xsl:value-of select='$A1SoloTotal + $A2SoloTotal' />
-
// this should do the computation
I would rather create the whole world-book element in the xsl, then you could loop without condition and copy all book elements
- <xsl:copy-of select="book" />
but there wouldn't be a problem in adding conditions, though.
for the computation, see my previous post
regards
PS: please use [code] tags when posting code
Dormilich 8,658
Recognized Expert Moderator Expert
HI Dormilich,
While i was trying to put your idea to my other xml using the xsl , it didn't produce the desired result.
It converted to just the same original XML file. The transformed xml didn't have the added value.
It seems i had made a mistake somewhere . Please advise the change required.
I am stuck for three days.
problem 1: you don't use [code] tags (this makes the code hard to read)
problem 2: you already copy all the nodes in the first template
problem 3: I'm just before going home, I'll look into it tomorrow
regards
problem 1: you don't use [code] tags (this makes the code hard to read)
problem 2: you already copy all the nodes in the first template
problem 3: I'm just before going home, I'll look into it tomorrow
regards
Sorry Dormilich, I missed to put the Code tag in other two files. I had put in the first one. Please look into it and advise the remedy.
Dormilich 8,658
Recognized Expert Moderator Expert
geez, that was givin me the creeps....
problem 1: have a look at your xml, it's not well-formed (though that's a minor problem and easily fixed)
problem2: <xsl:copy-of> didn't work.... until I inserted an additional namespace prefix with the default namespace
note: I'd rename the root node to prevent confusions
solution principle - // this is not valid code!
-
<xsl:template match="/">
-
<xsl:copy-of/> // all nodes except numericABCLevel_0
-
<xsl:call-template/> // numericABCLevel_0
-
</xsl:template>
-
-
<xsl:template>
-
<xsl:copy-of/> // all nodes except TotalMortgagesPrincipalAmount
-
<xsl:value-of/> // TotalMortgagesPrincipalAmount
-
</xsl:template>
if you want to try a bit for yourself, this is the "header" I used (you need not sticking with 'inp' as prefix, choose one to your liking): - <xsl:stylesheet version="1.0"
-
xmlns="http://www.xbrl.org/2001/instance"
-
xmlns:inp="http://www.xbrl.org/2001/instance"
-
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
-
xmlns:abc="http://www.apra.gov.au/statistics/xbrl/2001-11-05"
-
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
-
-
//inp:group <!-- these are the group elements now -->
note: I somehow had problems getting the values
full solution in the next post, because I'll be on vacation for a week
regards
Dormilich 8,658
Recognized Expert Moderator Expert
please use this solution only when you have problems with the code (well, at least try, ok?)
note: maybe some of the XPaths can be simplified in your environment - <?xml version="1.0" encoding="UTF-8"?>
-
<xsl:stylesheet version="1.0"
-
xmlns="http://www.xbrl.org/2001/instance"
-
xmlns:inp="http://www.xbrl.org/2001/instance"
-
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
-
xmlns:abc="http://www.apra.gov.au/statistics/xbrl/2001-11-05"
-
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
-
<xsl:output method="xml" indent="yes"/>
-
-
<xsl:template match="/">
-
<group>
-
<xsl:copy-of select="//inp:group[descendant::inp:numericContext/@id != 'numericABCLevel_0']" />
-
<xsl:call-template name="g1" />
-
</group>
-
</xsl:template>
-
-
<xsl:template name="g1">
-
<xsl:variable name="A1SoloTotal" select="//inp:group/*[name() = 'abc:MortgagesPrincipalAmount'][@numericContext = 'numericABCLevel_1']"/>
-
<xsl:variable name="A2SoloTotal" select="//inp:group/*[name() = 'abc:MortgagesPrincipalAmount'][@numericContext = 'numericABCLevel_2']"/>
-
<group>
-
<xsl:copy-of select="//inp:group/*[local-name() != 'TotalMortgagesPrincipalAmount'][../inp:numericContext/@id = 'numericABCLevel_0']"/>
-
<abc:TotalMortgagesPrincipalAmount><xsl:value-of select="$A1SoloTotal + $A2SoloTotal"/></abc:TotalMortgagesPrincipalAmount>
-
</group>
-
</xsl:template>
-
-
</xsl:stylesheet>
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Sergio del Amo |
last post by:
Hi,
I use the xslt functions provided by php. I am running in my computer
the package xampp(www.apachefriends.org) which includes php/apache/mysql
.. In this package the php includes the sablotron extension responsible
for the xslt functions. The problem i have is that the obtained
transformation is not the waited one. I try to proccess the same XML
file with XSL file with a program called XMLspy and i obtained the
desire and waited...
|
by: pradeep gummi |
last post by:
I have an XML FILE that is to be converted to Plain Text using an XSL
file. Since I just want plain text, I do not want to set any root
element during transformation.And if I do not any root element during
transformation, it return s "java.lang.IllegalStateException: Root
element not set" exception. If I add any element for the enclosed
root, it works.
Note: I am using XMLOutputter object of JDOM API, packages
javax.xml.transform and...
|
by: CK |
last post by:
Hello,
I have the 60 MB XML string and I am coding a program in Visual Basic
to run a XSL transformation on it. Currently, I'm using the Microsoft
standard MSXML 2.0 to create a DOM document, load the XML, and then
run the XSL transformation on it using the MSXML2.IXSLProcessor
interface.
The problem is that it kills my system because of an incredible amount
of memory that it requires to do this (around 850 MB). Are there any
other...
|
by: Will |
last post by:
I was thrust into XML about 2 weeks ago and don't know much yet. From
another department in the corp I am receiving an XML file which
concatenates nodes all on one line i.e.
<car><make>ford</make><color>red</color><year>2001</year></car><car><make><mb>
etc. etc. etc. Some lines are over 300 characters long. I need to
translate this spagetti XML into something which is humanly readable.
I probably need to use XSL however I'm not sure...
|
by: pulvertum |
last post by:
Hello,
I need an org.w3c.dom.Document so I can pass them to do a
transformation of my XML using XSL (to another XML as result).
I've tried several solutions but didn't have the desired result:
SOLUTION 1 using StreamOutput:
StreamSource streamXSL = new StreamSource(new
File(txtFileXSL));
| | |
by: Jain, Pranay Kumar |
last post by:
Hi All,
We have created a simple application that takes a dataset and
generates the data in Excel schema format. It uses an xslt file to do
the transformation for excel 2002 and so on. We are using the
dotnet.xml resource and not the MSXML 4.
The application is golden and works fine with realtively Medium size
of data(around 25MB). We started to see issues if the data is greater
then 25 MB where the transformation takes tooo long and...
|
by: TomekR |
last post by:
Hello !
I was developing xslt sheet lately and - experimenting - I made
mistake resulting in that, the effect of the transformation is not
well-formed xml document.
I made these tests using XmlSpy and in output window I can see two
parallel elements - according to "logic" of me sheet. The error of
that document is that it doesn't have root element.
Here is the contents of XmlSpy output window:
|
by: Thomas Bauer |
last post by:
Hello,
I search a example like that.
(1,0,0,1,4,5 ) -- moving
(1,0,0,1,0,0 ) -- normal matrix
(-1,0,0,1,0,0 ) -- Mirror Y-Axis
(0,-1,0,1,0,0 ) -- Mirror X-Axis
I caluculate all in mm.
|
by: MarkoKlacar |
last post by:
Hi,
My problem is the following:
I've got an XSL transformation, not written by me, and I've got a while bunch of XML files that need to be transformed using the transformation.
Now the script seems to read the files using URLs specified in the XSL script, and output the somehow.
Is there a way to just "call" the XSL transformation without any input files?
|
by: Amit00 |
last post by:
Hi,
I'm performing an xsl transformation in a page I built, and would like to use some custom controls in it (or asp controls, for that matter).
I looked this issue up, and understood that it can be done by adding the attribute "xmlns:tagname="remove"" to the "xsl:stylesheet" node, then performing the transformation, removing that attribute from the resulting html string, and then creating a control using "ParseControl(strHtml)" and adding...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
