Bhupendra Mehta

Part 2 of the XSL
<xsl:template match="//content-node[@type='page'][@create-type='implicit']/access-control"> <xsl:param name="uid" /> <xsl:copy> <xsl:apply-templates select="@*|node()"> <xsl:with-param name="uid" select="$uid" /> </xsl:apply-templates> </xsl:copy> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit']/access-control/@owner"> <xsl:param name="uid" /> <xsl:attribute name="owner"> <xsl:value-of select="$uid" /> </xsl:attribute> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit']/component"> <xsl:param name="uid" /> <xsl:param name="is-delete-req" /> <xsl:param name="is-update-req" /> <xsl:param name="displayname" /> <xsl:param name="email" /> <xsl:param name="mailhost" /> <xsl:param name="mailport" /> <xsl:param name="outmailhost" /> <xsl:choose> <xsl:when test="$is-delete-req='true'"></xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*|node()"> <xsl:with-param name="uid" select="$uid" /> <xsl:with-param name="is-delete-req" select="$is-delete-req" /> <xsl:with-param name="is-update-req" select="$is-update-req" /> <xsl:with-param name="displayname" select="$displayname" /> <xsl:with-param name="email" select="$email" /> <xsl:with-param name="mailhost" select="$mailhost" /> <xsl:with-param name="mailport" select="$mailport" /> <xsl:with-param name="outmailhost" select="$outmailhost" /> </xsl:apply-templates> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit']/component/portletinstance"> <xsl:param name="uid" /> <xsl:param name="is-delete-req" /> <xsl:param name="is-update-req" /> <xsl:param name="displayname" /> <xsl:param name="email" /> <xsl:param name="mailhost" /> <xsl:param name="mailport" /> <xsl:param name="outmailhost" /> <xsl:copy> <xsl:apply-templates select="@*|node()"> <xsl:with-param name="uid" select="$uid" /> <xsl:with-param name="is-delete-req" select="$is-delete-req" /> <xsl:with-param name="is-update-req" select="$is-update-req" /> <xsl:with-param name="displayname" select="$displayname" /> <xsl:with-param name="email" select="$email" /> <xsl:with-param name="mailhost" select="$mailhost" /> <xsl:with-param name="mailport" select="$mailport" /> <xsl:with-param name="outmailhost" select="$outmailhost" /> </xsl:apply-templates> </xsl:copy> </xsl:template> <xsl:template match="//parameter[@name='mail_imap.userDisplayName']"> <xsl:param name="displayname" /> <xsl:copy> <xsl:apply-templates select="@*" /> <xsl:value-of select="$displayname" /> </xsl:copy> </xsl:template> <xsl:template match="//parameter[@name='mail_imap.userEmail']"> <xsl:param name="email" /> <xsl:copy> <xsl:apply-templates select="@*" /> <xsl:value-of select="$email" /> </xsl:copy> </xsl:template> <xsl:template match="//parameter[contains(@name,'mailProviderHostName')]"> <xsl:param name="mailhost" /> <xsl:copy> <xsl:apply-templates select="@*" /> <xsl:value-of select="$mailhost" /> </xsl:copy> </xsl:template> <xsl:template match="//parameter[contains(@name,'mailProviderHostPort')]"> <xsl:param name="mailport" /> <xsl:copy> <xsl:apply-templates select="@*" /> <xsl:value-of select="$mailport" /> </xsl:copy> </xsl:template> <xsl:template match="//parameter[contains(@name,'outgoingMailServerName')]"> <xsl:param name="outmailhost" /> <xsl:copy> <xsl:apply-templates select="@*" /> <xsl:value-of select="$outmailhost" /> </xsl:copy> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit']/@action"> <xsl:param name="is-delete-req" /> <xsl:choose> <xsl:when test="$is-delete-req='true'"> <xsl:attribute name="action">delete</xsl:attribute> </xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*" /> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit']/@objectid"> <xsl:param name="is-update-req" /> <xsl:param name="is-delete-req" /> <xsl:param name="uid" /> <!-- preserve objectid only if it is an update-request not if an add request --> <xsl:if test="($is-update-req='true') or ($is-delete-req='true')"> <xsl:attribute name="objectid"> <xsl:value-of select="//content-node[@type='page'][@create-type='implicit'][access-control/@owner=$uid]/@objectid" /> </xsl:attribute> </xsl:if> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit']/component/@objectid"> <xsl:param name="is-update-req" /> <xsl:param name="uid" /> <xsl:if test="$is-update-req='true'"> <xsl:attribute name="objectid"> <xsl:value-of select="//content-node[@type='page'][@create-type='implicit'][access-control/@owner=$uid]/component/@objectid" /> </xsl:attribute> </xsl:if> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit']/component/portletinstance/@objectid"> <xsl:param name="is-update-req" /> <xsl:param name="uid" /> <xsl:if test="$is-update-req='true'"> <xsl:attribute name="objectid"> <xsl:value-of select="//content-node[@type='page'][@create-type='implicit'][access-control/@owner=$uid]/component/portletinstance/@objectid" /> </xsl:attribute> </xsl:if> </xsl:template> </xsl:stylesheet>
This code works for about 1000 - 1200 iterations but beyond that I get a StackOverFlow. Thanks for your help and I apologize for the lengthy content.

Here is part of the XSL file.
<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:xalan="http://xml.apache.org/xslt"> <xsl :-o utput method="xml" cdata-section-elements="parameter" /> <xsl:variable name="userinfo" select="document('userinfo.xml')" /> <xsl:variable name="exported-users" select="//content-node[@type='page'][@create-type='implicit']/access-control/@owner" /> <xsl:variable name="users-to-import" select="$userinfo/users/user/@uid" /> <xsl:variable name="total-users" select="count($users-to-import)" /> <xsl:template match="/"> <xsl:apply-templates /> </xsl:template> <xsl:template match="@*|*"> <xsl:copy> <xsl:apply-templates select="@*|node()" /> </xsl:copy> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit'][position()=1]"> <xsl:call-template name="process" /> </xsl:template> <xsl:template match="//content-node[@type='page'][@create-type='implicit'][position()>1]" /> <xsl:template name="process"> <xsl :-P aram name="counter" select="1" /> <xsl:choose> <xsl:when test="not($counter > $total-users)"> <xsl:call-template name="build-node"> <xsl:with-param name="index" select="$counter" /> </xsl:call-template> </xsl:when> <xsl :-o therwise><!-- exit --></xsl :-o therwise> </xsl:choose> </xsl:template> <xsl:template name="build-node"> <xsl :-P aram name="index" /> <xsl:variable name="uid_var" select="$userinfo/users/user[$index]/@uid" /> <xsl:variable name="displayname_var" select="$userinfo/users/user[$index]/@displayname" /> <xsl:variable name="email_var" select="$userinfo/users/user[$index]/@email" /> <xsl:variable name="mailhost_var" select="$userinfo/users/user[$index]/@mailhost" /> <xsl:variable name="mailport_var" select="$userinfo/users/user[$index]/@mailport" /> <xsl:variable name="outmailhost_var" select="$userinfo/users/user[$index]/@mailouthost" /> <xsl:variable name="action_var" select="$userinfo/users/user[$index]/@action" /> <xsl:choose> <xsl:when test="$uid_var = $exported-users"> <!-- since the user already exists update the user information from LDAP to reflect any changes. Set the is-update-req attribute to true so the object-ids will be preserved in the resulting XML and the user information will be updated --> <xsl:choose> <xsl:when test="$action_var='delete'"> <!-- if action for a user is set to delete the user data should be marked for deletion --> <xsl:copy> <xsl:apply-templates select="@*|node()"> <xsl:with-param name="uid" select="$uid_var" /> <xsl:with-param name="is-delete-req" select="'true'" /> </xsl:apply-templates> </xsl:copy> </xsl:when> <xsl :-o therwise> <!-- Check here to see if any of the user attributes have changed. Add the user node to the output only if they have changed --> <!-- otherwise ignore the user node. This will limit the amount of data being imported by only filtering the information which --> <!-- has changed. --> <xsl:variable name="users-node" select="//content-node[access-control[@owner=$uid_var]]" /> <xsl:variable name="imported-displayname" select="$users-node/component/portletinstance/parameter[@name='mail_imap.userDisplayName']/text()" /> <xsl:variable name="imported-email" select="$users-node/component/portletinstance/parameter[@name='mail_imap.userEmail']/text()" /> <xsl:variable name="imported-mailhost" select="$users-node/component/portletinstance/parameter[@name='mail_imap.mailProviderHostName']/text()" /> <xsl:variable name="imported-outmailhost" select="$users-node/component/portletinstance/parameter[@name='mail_imap.outgoingMailServerName']/text()" /> <xsl:choose> <xsl:when test="($imported-displayname=$displayname_var)and($imported-email=$email_var)and($imported-mailhost=$mailhost_var)and($imported-outmailhost=$outmailhost_var)"></xsl:when> <xsl :-o therwise> <!-- this is a request to update user information --> <xsl:copy> <xsl:apply-templates select="@*|node()"> <xsl:with-param name="is-update-req" select="'true'" /> <xsl:with-param name="uid" select="$uid_var" /> <xsl:with-param name="displayname" select="$displayname_var" /> <xsl:with-param name="email" select="$email_var" /> <xsl:with-param name="mailhost" select="$mailhost_var" /> <xsl:with-param name="mailport" select="$mailport_var" /> <xsl:with-param name="outmailhost" select="$outmailhost_var" /> </xsl:apply-templates> </xsl:copy> </xsl :-o therwise> </xsl:choose> </xsl :-o therwise> </xsl:choose> </xsl:when> <xsl :-o therwise> <xsl:choose> <xsl:when test="$action_var='delete'"> <!-- do nothing since the user request is to delete and the user does'nt exist --> </xsl:when> <xsl :-o therwise> <xsl:copy> <xsl:apply-templates select="@*|node()"> <xsl:with-param name="uid" select="$uid_var" /> <xsl:with-param name="displayname" select="$displayname_var" /> <xsl:with-param name="email" select="$email_var" /> <xsl:with-param name="mailhost" select="$mailhost_var" /> <xsl:with-param name="mailport" select="$mailport_var" /> <xsl:with-param name="outmailhost" select="$outmailhost_var" /> </xsl:apply-templates> </xsl:copy> </xsl :-o therwise> </xsl:choose> </xsl :-o therwise> </xsl:choose> <xsl:call-template name="process"> <xsl:with-param name="counter" select="$index + 1" /> </xsl:call-template> </xsl:template>
Continued....

I have to send these in multiple posts.

Here is the input XML.

XML 1 (input.xml) where I need to replicate the node content-node with attr create-type="implicit" with data populated from userinfo.xml. All other nodes need to be copied as is.
<?xml version="1.0" encoding="UTF-8"?> <request build="wp5101_121" type="update"> <portal action="locate"> <content-node action="update" active="true" allportletsallowed="true" content-parentref="_6_086M6V04DB0QH41I_A" create-type="explicit" objectid="_6_086M6V04DB0QH41I_4SA" type="page" uniquename="email"> <supported-markup markup="html" update="set"/> <localedata locale="en"> <title>My Page</title> </localedata> <parameter name="remote-cache-scope"><![CDATA[NON-SHARED]]></parameter> <component action="update" objectid="_7_086M6V04DB0QH41I_6QT" type="container" width="undefined"> <portletinstance action="update" objectid="_5_086M6V04DB0QH41I_6KH" portletref="_3_086M6V04DB0QH41I_4FP" shareref="undefined"/> </component> </content-node> <content-node action="update" create-type="implicit" objectid="_6_086M6V04DB0QH41I_52H" ordinal="100" type="page"> <access-control externalized="false" owner="uid=111111,ou=0701,o=fakeco" private="true"/> <component action="update" objectid="_7_086M6V04DB0QH41I_713" type="control" width="undefined"> <portletinstance action="update" objectid="_5_086M6V04DB0QH41I_6QR" portletref="_3_083067EKL90SHEDQ_7N6" shareref="undefined"> <parameter name="mail_imap.mailProviderHostName"><![CDATA[aaaaaa.fakeco.com]]></parameter> <parameter name="mail_imap.mailProviderHostPort"><![CDATA[143]]></parameter> <parameter name="mail_imap.outgoingMailServerName"><![CDATA[oooooo.fakeco.com]]></parameter> <parameter name="mail_imap.userDisplayName"><![CDATA[Harry]]></parameter> <parameter name="mail_imap.userEmail"><![CDATA[yosemite.sam@fakeco.com]]></parameter> </portletinstance> </component> </content-node> <content-node action="update" create-type="implicit" objectid="_6_086M6V04DB0QH41I_4VD" ordinal="100" type="page"> <access-control externalized="false" owner="uid=22222,ou=0701,o=fakeco" private="true"/> <component action="update" objectid="_7_086M6V04DB0QH41I_6U0" type="control" width="undefined"> <portletinstance action="update" objectid="_5_086M6V04DB0QH41I_6NN" portletref="_3_083067EKL90SHEDQ_7N6" shareref="undefined"> <parameter name="mail_imap.mailProviderHostName"><![CDATA[aaaaaa.fakeco.com]]></parameter> <parameter name="mail_imap.mailProviderHostPort"><![CDATA[143]]></parameter> <parameter name="mail_imap.outgoingMailServerName"><![CDATA[oooooo.fakeco.com]]></parameter> <parameter name="mail_imap.userDisplayName"><![CDATA[Jack]]></parameter> <parameter name="mail_imap.userEmail"><![CDATA[some.one@fakeco.com]]></parameter> </portletinstance> </component> </content-node> <content-node action="update" create-type="implicit" objectid="_6_086M6V04DB0QH41I_4VE" ordinal="100" type="page"> <access-control externalized="false" owner="uid=33333,ou=0458,o=fakeco" private="true"/> <component action="update" objectid="_7_086M6V04DB0QH41I_6U1" type="control" width="undefined"> <portletinstance action="update" objectid="_5_086M6V04DB0QH41I_6NO" portletref="_3_083067EKL90SHEDQ_7N6" shareref="undefined"> <parameter name="mail_imap.mailProviderHostName"><![CDATA[aaaaaa.fakeco.com]]></parameter> <parameter name="mail_imap.mailProviderHostPort"><![CDATA[143]]></parameter> <parameter name="mail_imap.outgoingMailServerName"><![CDATA[oooooo.fakeco.com]]></parameter> <parameter name="mail_imap.userDisplayName"><![CDATA[John]]></parameter> <parameter name="mail_imap.userEmail"><![CDATA[some.sam@fakeco.com]]></parameter> </portletinstance> </component> </content-node> </portal> </request>

XML2 (userinfo.xml) is the xml which holds user data to be used while replicating the node.
<?xml version="1.0" encoding="UTF-8"?> <users> <user uid="uid=188134,ou=0288,o=fakeco" displayname="Harry Potter" email="Harry Potter@fakeco.com" mailhost="aaaaaa.fakeco.com" mailport="143" mailouthost="oooooo.fakeco.com" action="update" /> <user uid="uid=26395,ou=1602,o=fakeco" displayname="Jack Rabbit" email="Jack Rabbit@fakeco.com" mailhost="aaaaaa.fakeco.com" mailport="143" mailouthost="oooooo.fakeco.com" action="update" /> <!-- existing user should not make it to the xformed output file --> <user uid="uid=33333,ou=0458,o=fakeco" displayname="John" email="some.sam@fakeco.com" mailhost="aaaaaa.fakeco.com" mailport="143" mailouthost="oooooo.fakeco.com" action="update" /> </users>

Paul Is there an email I can email you my xmls & xsl

Here is the code which I believe is causing the recursive looping ... this is where I loop through all the users in the users.xml (XML 2)
<xsl:template name="process"> <xsl :-P aram name="counter" select="1" /> <xsl:choose> <xsl:when test="not($counter > $total-users)"> <xsl:call-template name="build-node"> <xsl:with-param name="index" select="$counter" /> </xsl:call-template> </xsl:when> <xsl :-o therwise><!-- exit --></xsl :-o therwise> </xsl:choose> </xsl:template> <xsl:template name="build-node"> <xsl :-P aram name="index" /> <xsl:variable name="uid_var" select="$userinfo/users/user[$index]/@uid" /> <xsl:variable name="displayname_var" select="$userinfo/users/user[$index]/@displayname" /> . . <xsl:call-template name="process"> <xsl:with-param name="counter" select="$index + 1" /> </xsl:call-template>

I guess I'm looking for a better way to loop through all the records in XML 2 without having to do a recursive loop like above.

Thanks for your response

Assume node2 from XML 1 as a template for the node I am trying to replicate. The attribute values for that node/children viz sub-node2/@attr3 and sub-node3/@attr are to be picked up from XML 2 (dynamic values) based on some condition. Lets say sub-node2/@attr3 will be populated by users/user/@name.

Hope this better explains it. Thanks.

What I mean is that these are two separate files. for e.g. data.xml (XML 1) and users.xml (XML 2) just means of labelling.

I need to replicate a node from an XML with attribute values read from another XML file. Both the input XMLs are huge aprrox 10 - 50 M. What is the best way to accomplish this. With my current stylesheet I get a Stackoverflow error for records over 1400. Here is a sample XML

XML 1 <root-node> <node1 attr1="val1"/> <node2 attr2="val2" .....> <sub-node2 attr3="dynamic value" ....> <sub-node3 attr="dynamic value" ..../> </sub-node2> <node2> </root-node> XML 2 <users> <user name="abc" .... /> . . </users>

obviously the dynamic values are read from XML 2.

Thanks for any response.


Edit Comment: Close the code tag.

- m
[ February 15, 2006: Message edited by: Madhav Lakkapragada ]

Madhav,
Thanx a lot that worked like a charm.

Madhav,
Thanx for the suggestion but i can't get the substring'd value. This is what I changed the rule to

<xsl:variable name="distinctdate" select="//row[not(substring(col[1],1,7)=substring(preceding-sibling::row/col[1],1,7))]/col[1]"></xsl:variable>

but I can't substring the final value that I'm retrieving //row[condition]/col[1]

Thanx again.

I have an xml of the form
<data>
<row>
<col>2003-05-04</col>
</row>
<row>
<col>2003-05-07</col>
</row>
<row>
<col>2003-05-04</col>
</row>
<row>
<col>2003-05-08</col>
</row>
<row>
<col>2004-06-08</col>
</row>
<row>
<col>2004-07-08</col>
</row>
.
.
.
</data>
The col element has dates in the form of yyyy-mm-dd. I am trying to find distinct yyyy-mm values from the above XML in a "variable". I can get distinct date values by using
<xsl:variable name="distinctdate" select="//row[not(col[1]=preceding-sibling::row/col[1])]/col[1]"></xsl:variable>
which gives me
2003-05-04
2003-05-07
2003-05-08
2004-06-08
2004-07-08

but what i'd really like is
2003-05
2004-06
2004-07
Any reponses will be greatly appreciated. Thanx