Thanks
On Wed, Jun 21, 2017 at 2:50 PM, XSL-List: The Open Forum on XSL <
xsl-list-service(_at_)lists(_dot_)mulberrytech(_dot_)com> wrote:
This message contains the recent posts to the XSL-List: The Open Forum on
XSL
mailing list managed by Mulberry Technologies, Inc. (
http://lists.mulberrytech.com).
---------- Forwarded message ----------
From: Rahul Singh <rahulsinghindia15(_at_)gmail(_dot_)com>
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Cc:
Bcc:
Date: Tue, 20 Jun 2017 18:59:40 +0530
Subject: XSL Condition is not working
My xsl code is not working as per given expected output. I need data from
merge1.xml if Alert_Type__c='Document Downloaded' and
Document_Name__c='abcTest.txt' is match with merge2.xml with
Document_Name__c='abcTest.txt' and Alert_Type__c!='Document Downloaded'
Input
Merge1.xml:
<?xml version="1.0" encoding="UTF-8"?>
<objects>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>b (2).txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>w.txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>w.txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>file 1.pdf</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>abcTest.txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
</Alert__c>
</objects>
Merge2.xml:
<?xml version="1.0" encoding="UTF-8"?>
<objects>
<Data__c>
<Document_Name__c>abcTest.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>w.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>q.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>file 1.pdf</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>DealRoomData.csv</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>b (2).txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>w.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
</objects>
XSL:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:xs="http://www.w3.org/2001/XMLSchema";
exclude-result-prefixes="xs" version="2.0">
<xsl:output method="xml" indent="yes"/>
<xsl:param name="XMLMerge2" select="document('merge2.xml')"/>
<xsl:template match="objects">
<objects>
<xsl:if test="
$XMLMerge2/objects != ''">
<xsl:for-each select="Alert__c">
<xsl:variable name="Email_from_merge1"
select="Alert_Type__c"/>
<xsl:variable name="Email_from_merge2"
select="Document_Name__c"/>
<xsl:if
test="not(exists($XMLMerge2/objects/Data__c[Alert_Type__c
= $Email_from_merge1]))">
<xsl:if
test="exists($XMLMerge2/
objects/Data__c[Document_Name__c = $Email_from_merge2])">
<xsl:copy>
<xsl:apply-templates select="@* | node()"/>
</xsl:copy>
</xsl:if>
</xsl:if>
</xsl:for-each>
</xsl:if>
</objects>
</xsl:template>
<xsl:template match="@* | node()">
<xsl:copy>
<xsl:apply-templates select="@* | node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
Expected output:
<?xml version="1.0" encoding="UTF-8"?>
<objects>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>abcTest.txt</Document_Name__c>
</Alert__c>
</objects>
---------- Forwarded message ----------
From: Priscilla Walmsley <pwalmsley(_at_)datypic(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Cc:
Bcc:
Date: Tue, 20 Jun 2017 13:22:52 -0400
Subject: XSLT at the XML Summer School 2017
Hello,
We have announced the program for the XML Summer School, which takes place
September
17-22 in Oxford, UK.
The XSLT and XQuery course may be of particular interest. It is an
intermediate
to advanced course with the goal of helping developers who are currently
using XSLT to be more effective and efficient. It's a great opportunity
to spend some time with XSLT and XQuery experts like Michael Kay, Florent
Georges and Adam Retter (and me!). The classes are:
- XSLT and XQuery Performance Workshop (taught by Michael Kay)
- Refactoring XSLT (taught by Priscilla Walmsley)
- Querying XML Databases with XQuery (taught by Adam Retter)
- XSLT 3.0 and XQuery 3.0 (taught by Florent Georges)
There is also quite a lot of XSLT in the Hands-on Digital Publishing
course for slightly less experienced XSLT developers. Taught by Norm
Walsh, Peter Flynn, Lauren Wood and Matt Patterson, the classes teach
practical methods for transforming both XML and Word documents to HTML5
for Web and ePub publishing.
Of course, the rest of the curriculum and faculty are excellent also. You can
find out more at:
*http://xmlsummerschool.com/curriculum-2017/*
<http://xmlsummerschool.com/curriculum-2017/>
Consider travelling to the beautiful town of Oxford this summer to further
advance
your XSLT skills and socialize with people with the same interests and
challenges in a relaxed setting.
Please feel free to contact me if you have any question about the
curriculum or the Summer School in general. Hope to see you there!
Priscilla
---------- Forwarded message ----------
From: "Imsieke, Gerrit, le-tex" <gerrit(_dot_)imsieke(_at_)le-tex(_dot_)de>
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Cc:
Bcc:
Date: Tue, 20 Jun 2017 20:03:22 +0200
Subject: Re: [xsl] XSL Condition is not working
I don’t understand it fully. The output comprises all of merge1.xml’s
Alter__c items because all meet your conditions.
Why do you expect that the output objects element contains only
Alert__c[Document_Name__c = 'abcTest.txt']]?
For example, take
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>w.txt</Document_Name__c>
</Alert__c>
$Email_from_merge1 is 'Document Downloaded'
not(exists($XMLMerge2/objects/Data__c[Alert_Type__c =
$Email_from_merge1])) is true
because all Data__c in merge2.xml have an Alert_Type__c of 'Document
Viewed'
$Email_from_merge2 is 'w.txt'
$XMLMerge2/objects/Data__c[Document_Name__c = 'w.txt'] exists (there are
two Data__c with Document_Name__c = 'w.txt').
So for this example both 'if' conditions are true, and for all other
Alert__c elements, too.
This explains the output, yet it doesn’t explain why it is different from
your expectations.
Gerrit
On 6/20/17 3:30 PM, Rahul Singh rahulsinghindia15(_at_)gmail(_dot_)com wrote:
My xsl code is not working as per given expected output. I need data from
merge1.xml if Alert_Type__c='Document Downloaded' and
Document_Name__c='abcTest.txt' is match with merge2.xml with
Document_Name__c='abcTest.txt' and Alert_Type__c!='Document Downloaded'
Input
Merge1.xml:
<?xml version="1.0" encoding="UTF-8"?>
<objects>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>b (2).txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>w.txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>w.txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>file 1.pdf</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>abcTest.txt</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
</Alert__c>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
</Alert__c>
</objects>
Merge2.xml:
<?xml version="1.0" encoding="UTF-8"?>
<objects>
<Data__c>
<Document_Name__c>abcTest.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>w.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>q.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>file 1.pdf</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>DealRoomData.csv</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>b (2).txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>w.txt</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
<Data__c>
<Document_Name__c>VICS_810_004010_US.pdf</Document_Name__c>
<Alert_Type__c>Document Viewed</Alert_Type__c>
</Data__c>
</objects>
XSL:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:xs="http://www.w3.org/2001/XMLSchema";
exclude-result-prefixes="xs" version="2.0">
<xsl:output method="xml" indent="yes"/>
<xsl:param name="XMLMerge2" select="document('merge2.xml')"/>
<xsl:template match="objects">
<objects>
<xsl:if test="
$XMLMerge2/objects != ''">
<xsl:for-each select="Alert__c">
<xsl:variable name="Email_from_merge1"
select="Alert_Type__c"/>
<xsl:variable name="Email_from_merge2"
select="Document_Name__c"/>
<xsl:if
test="not(exists($XMLMerge2/objects/Data__c[Alert_Type__c
= $Email_from_merge1]))">
<xsl:if
test="exists($XMLMerge2/objects/Data__c[Document_Name__c
= $Email_from_merge2])">
<xsl:copy>
<xsl:apply-templates select="@* |
node()"/>
</xsl:copy>
</xsl:if>
</xsl:if>
</xsl:for-each>
</xsl:if>
</objects>
</xsl:template>
<xsl:template match="@* | node()">
<xsl:copy>
<xsl:apply-templates select="@* | node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
Expected output:
<?xml version="1.0" encoding="UTF-8"?>
<objects>
<Alert__c>
<Alert_Type__c>Document Downloaded</Alert_Type__c>
<Document_Name__c>abcTest.txt</Document_Name__c>
</Alert__c>
</objects>
XSL-List info and archive <http://www.mulberrytech.com/xsl/xsl-list>
EasyUnsubscribe <-list/225679>
(by email <>)
--
Gerrit Imsieke
Geschäftsführer / Managing Director
le-tex publishing services GmbH
Weissenfelser Str. 84, 04229 Leipzig, Germany
Phone +49 341 355356 110, Fax +49 341 355356 510
gerrit(_dot_)imsieke(_at_)le-tex(_dot_)de, http://www.le-tex.de
Registergericht / Commercial Register: Amtsgericht Leipzig
Registernummer / Registration Number: HRB 24930
Geschäftsführer: Gerrit Imsieke, Svea Jelonek,
Thomas Schmidt, Dr. Reinhard Vöckler
--~----------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
EasyUnsubscribe: http://lists.mulberrytech.com/unsub/xsl-list/1167547
or by email: xsl-list-unsub(_at_)lists(_dot_)mulberrytech(_dot_)com
--~--