xsl-list
[Top] [All Lists]

RE: badly need xsl help(prob with accessing child nodes in the script)

2003-10-14 12:35:38
Benjamin,
 I tried your code. But it not working as expected. It is producing ouput like 
this

 <_Item>5302003</_Item>
 <_Item>7302003</_Item>
                        
I tried different things on this. But still couldn't get the required result. 
So posting it again.
What I found on this is:
        $Date variable is not getting anything and it is always going into 
otherwise case and not able to show the s:Separator

am I missing anything?

thanks,

~Mur
 
-----Original Message-----
From: Benjamin Farrow [mailto:lovinjess(_at_)hotmail(_dot_)com]
Sent: Tuesday, October 14, 2003 11:38 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] badly need xsl help(prob with accessing child nodes
in the script)


Murali,
    Here is a full copy of the XSL that seems to account for your different 
date formats...all done in XSLT 1.0.  As far as using Javascript and XSL...I 
would say don't confuse the two.  Either use XSL or use javascript, but the 
use of inserting script like that in XSL is usual not helpful.  Do you 
javascript processing outside of the XSL and pass those modified values into 
the XSL to create your output XML.

   You see questions about benchmarking here a lot, and the general response 
is...try it out.  Benchmarking is related to so many things, processor 
speed, memory, operating system, version of software etc.  The only way to 
see which way is quicker is to try the two out.  For me, pure XSL works 
rather well, but I do some processing outside the scope of XSL.
   I think you are right that it is a question you have to ask yourself, but 
looking at your javascript code, it is not necessary.  I understand you 
don't feel comfortable with XSL yet to replace your javascript knowledge 
with that, but don't try mixing the two and you might come up with some more 
maintainable code.  Good luck,

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:ri="urn:schemas.abcd-com:RepInven"
xmlns:s="urn:schemas.abcd-com:Static"
xmlns:l="urn:schemas.abcd-com:layers">
  <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

  <xsl:variable name="Date" select="l:data/s:RegionalOptions/s:Date"/>

  <xsl:template match="/">
    <_Ctrl xmlns="">
      <xsl:apply-templates 
select="l:data/ri:Rpt_Inven/ri:Inven/ri:EffectiveDate"/>
    </_Ctrl>
  </xsl:template>

  <xsl:template match="ri:Rpt_Inven/ri:Inven/ri:EffectiveDate">
    <_Item>
      <xsl:call-template name="convertDate">
        <xsl:with-param name="date" select="."/>
      </xsl:call-template>
    </_Item>
  </xsl:template>

  <xsl:template name="convertDate">
    <xsl:param name="date"/>
    <xsl:variable name="year" select="substring($date,1,4)"/>
    <xsl:variable name="month" select="substring($date,6,2)"/>
    <xsl:variable name="day" select="substring($date,9,2)"/>
    <xsl:choose>
      <xsl:when test="$date = ''"/>
      <xsl:when test="$Date/s:ShortFormat = '1'">
        <xsl:value-of select="number($month)"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="number($day)"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$year"/>
      </xsl:when>
      <xsl:when test="$Date/s:ShortFormat = '2'">
        <xsl:value-of select="number($day)"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="number($month)"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$year"/>
      </xsl:when>
      <xsl:when test="$Date/s:ShortFormat = '3'">
        <xsl:value-of select="$month"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$day"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$year"/>
      </xsl:when>
      <xsl:when test="$Date/s:ShortFormat = '4'">
        <xsl:value-of select="$day"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$month"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$year"/>
      </xsl:when>
      <xsl:when test="$Date/s:ShortFormat = '5'">
        <xsl:value-of select="$year"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$month"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$day"/>
      </xsl:when>
      <xsl:otherwise>
        <xsl:value-of select="number($month)"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="number($day)"/>
        <xsl:value-of select="$Date/s:Separator"/>
        <xsl:value-of select="$year"/>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>

  <xsl:template match="node()|@*">
    <xsl:apply-templates select="node()|@*"/>
  </xsl:template>

</xsl:stylesheet>


Benjamin

From: "Murali Korrapati" <murali(_dot_)korrapati(_at_)reval(_dot_)com>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: RE: [xsl] badly need xsl help(prob with accessing child nodes in 
the script)
Date: Tue, 14 Oct 2003 10:13:59 -0400

Hi Benjamin,
  Thanks for your reply. It looks like this solution works for me.
But I already have all that code in javascript. I use it in other places.
I have more data types like Date, Currency and Time. I am trying to re-use 
it here.
And I found a stupid work around for my original problem. Like

  loading the xml from RegOpts[0] in the init() function into a new DOM 
and accessing that from there.

I know it is lame but working.

Now I can re-write all that in xsl but question is

1) Which is faster in transformation, xsl or JavaScript?
2) Is it really good maintaining two copies(xsl and javascript) of same 
code?
(I know this second question is not really for the forum. It is for myself)

~Mur

-----Original Message-----
From: Benjamin Farrow [mailto:lovinjess(_at_)hotmail(_dot_)com]
Sent: Monday, October 13, 2003 8:19 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] badly need xsl help(prob with accessing child nodes
in the script)


Murali,
    It's past my time to head home, but it appears that your javascript is
not really needed.  All of what you do there could be done in XSL.  If my
quick glance was correct, you have different date formats defined by the
element Date/ShortFormat.  I didn't have a chance to look close enough to
how each of these formats are defined in your switch statement in your
javascript , but perhaps this gives an idea of how to go about it...

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:ri="urn:schemas.abcd-com:RepInven"
xmlns:s="urn:schemas.abcd-com:Static"
xmlns:l="urn:schemas.abcd-com:layers">
  <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

  <xsl:variable name="Date" select="l:data/s:RegionalOptions/s:Date"/>

  <xsl:template match="/">
    <_Ctrl xmlns="">
      <xsl:apply-templates
select="l:data/ri:Rpt_Inven/ri:Inven/ri:EffectiveDate"/>
    </_Ctrl>
  </xsl:template>

  <xsl:template match="ri:Rpt_Inven/ri:Inven/ri:EffectiveDate">
    <_Item>
      <xsl:call-template name="convertDate">
        <xsl:with-param name="date" select="."/>
      </xsl:call-template>
    </_Item>
  </xsl:template>

  <xsl:template name="convertDate">
    <xsl:param name="date"/>
    <xsl:variable name="year" select="substring($date,1,4)"/>
    <xsl:variable name="month" select="substring($date,6,2)"/>
    <xsl:variable name="day" select="substring($date,9,2)"/>
    <!-- put a choose/when for each of your different formats and use the
variables as needed... -->
    <xsl:value-of select="$month"/>
    <xsl:value-of select="$Date/s:Separator"/>
    <xsl:value-of select="$day"/>
    <xsl:value-of select="$Date/s:Separator"/>
    <xsl:value-of select="$year"/>
  </xsl:template>

  <xsl:template match="node()|@*">
    <xsl:apply-templates select="node()|@*"/>
  </xsl:template>

</xsl:stylesheet>

again, I just whipped this together and realized, it's time to head home 
for
me...so if you don't get an answer by tomorrow morning I'll try to
understand your javascript better then...

Benjamin


From: "Murali Korrapati" <murali(_dot_)korrapati(_at_)reval(_dot_)com>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: RE: [xsl] badly need xsl help(prob with accessing child nodes in
the script)
Date: Mon, 13 Oct 2003 15:27:08 -0400

Hi guys,
  Lets try to forget everything that started b'cos of me. We are here to
help each other, not to fight.
Try to be as friendly as possible and help each other.

I tried the namespace(you can see that in my modified code in init()
function) as Michael Kay said. But I have no luck.
This is what I am exactly doing and want to do. Can anybody give any
suggestions?

Thanks.

xml:

<data xmlns="urn:schemas.abcd-com:layers">
    <Rpt_Inven xmlns="urn:schemas.abcd-com:RepInven" >
            <Inven>
                    <EffectiveDate>2003-05-30</EffectiveDate>
            </Inven>
            <Inven>
                    <EffectiveDate>2003-07-30</EffectiveDate>
            </Inven>
    </Rpt_Inven>
    <RegionalOptions xmlns="urn:schemas.abcd-com:Static">
            <Date>
                    <Calendar>
                    <TwoDigitYear>79</TwoDigitYear>
                    </Calendar>
                    <Separator>/</Separator>
                    <ShortFormat>3</ShortFormat>
            </Date>
            <Currency>
                    <DecimalSymbol>.</DecimalSymbol>
                    <GroupingSymbol>,</GroupingSymbol>
                    <DigitGrouping>2</DigitGrouping>
            </Currency>
            <Locale>1033</Locale>
    </RegionalOptions>
</data>


xsl :

<xsl:stylesheet version="1.0" xmlns=""
xmlns:lay="urn:schemas.abcd-com:layers"
xmlns:rep="urn:schemas.abcd-com:RepInven"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:scrdt="urn:schemas.abcd-com:datatypes"
xmlns:stat="urn:schemas.abcd-com:Static">
    <xsl:output method="xml" encoding="UTF-8"/>
    <xsl:template match="lay:data">
            <_Ctrl>
                    <xsl:call-template name="callInit">
                            <xsl:with-param name="regOptNode" 
select="stat:RegionalOptions"/>
                    </xsl:call-template>
                    <xsl:for-each 
select="rep:Rpt_Inven/rep:Inven/rep:EffectiveDate">
                            <_Item>
                                    <xsl:call-template name="genItem">
                                            <xsl:with-param name="attrNode" 
select="."/>
                                    </xsl:call-template>
                            </_Item>
                    </xsl:for-each>
            </_Ctrl>
    </xsl:template>
     <xsl:template name="callInit">
             <xsl:param name="regOptNode"/>
             <xsl:value-of select="scrdt:init($regOptNode)"/>
             <xsl:value-of select="scrdt:getValue($attrNode)"/>
    </xsl:template>
    <xsl:template name="genItem">
            <xsl:param name="attrNode"/>
            <xsl:value-of select="scrdt:getValue($attrNode)"/>
    </xsl:template>
<msxsl:script language="JScript" implements-prefix="scrdt"><![CDATA[
var  _xDate_ShortFormat;
var  _xDate_Separator;

function init(RegOpts)
{
    if( !RegOpts.length) return "length 0";
    var dateNode = RegOpts[0].selectSingleNode("stat:Date");
    if(dateNode != null )
    {
            _xDate_ShortFormat = dateNode.selectSingleNode("ShortFormat");
            _xDate_Separator = dateNode.selectSingleNode("Separator");
    }
    else
    {
            //It seems it is always going here.
            _xDate_ShortFormat = 5;
            _xDate_Separator = "-";
    }

    return "";
}
function getValue(nodes)
{
try
{
    var node  = nodes[0];
    var val, def;
    switch (node.nodeType)
    {
    case 1:
            val = node.text;
            def = node;
            break;
    case 2:
            val = node.nodeValue;
            def = null;
            break;
    case 3:
            val = node.nodeValue;
            def = node.parentNode;
            break;
    }

    if (def!=null)
    {
            val = xVal.formatValue(val);
    }

    return val;
}
catch(e)
{
    return e.description;
}
}
function formatValue()
{

    var     dt;
    var fmt = new RegExp("^([0-9]{4})-([0-9]{2})-([0-9]{2})$","");
    var res = dStr.match(fmt);
    if (res!=null)
    {
            var y = parseInt(res[1],10);
            var m = parseInt(res[2],10);
            var d = parseInt(res[3],10);
            dt = new Date(y,m-1,d);
            if (dt.getFullYear()!=y || dt.getMonth()!=(m-1) || 
dt.getDate()!=d)
                    return "";
    }
    else
            return "";

    if (dt!=null)
    {
            var     y       =       dt.getFullYear();
            var     m       =       dt.getMonth()   +       1;
            var     d       =       dt.getDate();
            switch(_xDate_ShortFormat)
            {
            case 1:
                    return  m.toString() + _xDate_Separator +
                                                    d.toString() + 
_xDate_Separator +
                                                    y.toString();
            case 3:
                    return  (m<10?"0":"")   +       m.toString() + 
_xDate_Separator +
                                                    (d<10?"0":"")   +       
d.toString() + _xDate_Separator +
                                                    y.toString();
            case 2:
                    return  d.toString() + _xDate_Separator +
                                                    m.toString() + 
_xDate_Separator +
                                                    y.toString();
            case 4:
                    return  (d<10?"0":"")   +       d.toString() + 
_xDate_Separator +
                                                    (m<10?"0":"")   +       
m.toString() + _xDate_Separator +
                                                    y.toString();
            case 5:
                    return  y.toString() + _xDate_Separator +
                                                    (m<10?"0":"")   +       
m.toString() + _xDate_Separator +
                                                    (d<10?"0":"")   +       
d.toString();
            default:
                    return  m.toString() + _xDate_Separator +
                                                    d.toString() + 
_xDate_Separator +
                                                    y.toString();
            }
    }
    else
            return "";
}
    ]]></msxsl:script>

</xsl:stylesheet>

    With this xml and xsl, I am expecting my out some thing like

<_Ctrl xmlns="" xmlns:lay="urn:schemas.abcd-com:layers"
xmlns:rep="urn:schemas.abcd-com:RepInven"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:scrdt="urn:schemas.abcd-com:datatypes"
xmlns:stat="urn:schemas.abcd-com:Static">
    <_Item>
            05/30/2003
    </_Item>
    <_Item>
            07/30/2003
    </_Item>
</_Ctrl>

   But it is always producing something like

   <_Ctrl xmlns="" xmlns:lay="urn:schemas.abcd-com:layers"
xmlns:rep="urn:schemas.abcd-com:RepInven"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:scrdt="urn:schemas.abcd-com:datatypes"
xmlns:stat="urn:schemas.abcd-com:Static">
    <_Item>
            2003-05-30
    </_Item>
    <_Item>
            2003-07-30
    </_Item>
</_Ctrl>


      I think this b'cos I am not able to get access to the <Date/> node
in the script function. And whenever I say RegOpts(i).firstChild , I am
getting the result I want.

Any ideas about. I am very desperate for this.

thanks,

~Mur


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


_________________________________________________________________
Surf and talk on the phone at the same time with broadband Internet access.
Get high-speed for as low as $29.95/month (depending on the local service
providers in your area).  https://broadband.msn.com


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


_________________________________________________________________
Page a contact's mobile phone with  MSN Messenger 6.0. Download it now FREE! 
   http://msnmessenger-download.com


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list