A conversion using XSLT.

[luthriaajay]

I have an Source XML called SubOrderMessage.xml which needs to be transformed

 
Source 'SubOrderMessage.xml'
---------------------------
<?xml version="1.0" encoding="UTF-8"?>
<FIXML xmlns="http://www.fixprotocol.org/FIXML-4-4">
<Order Acct="1" ExDest="ExchDest" ><Hdr Snt="2007-04-05T13:34:47" /><Instrmt Issr="Barclays" MMY="200903" /></Order></FIXML>
 
 

to be converted into:

 
OUTPUT XML
----------
 
<?xml version="1.0" encoding="UTF-8" ?> 
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.fixprotocol.org/FIXML-4-4" 
xmlns:i="http://www.ABC.com/interests:i">
<xsl:output method="xml"/>
 
<i:ID>1</i:ID>
<i:Date>2007-04-05</i:Date>
<i:Issuer>Barclays</i:Issuer>
 
 

Even though the above elements are in namespace 'i:',I am trying the below,but am unable to get the output

My xsl is:

 
<?xml version="1.0" encoding="UTF-8" ?> 
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.fixprotocol.org/FIXML-4-4" 
xmlns:i="http://www.ABC.com/interests:i">
<xsl:output method="xml"/>
<xsl:template match="/">
 
<i:ID><xsl:value-of select="Order@Acct" /> </i:ID>
 
 
 

Can someone please help me out to get the above output please?
No offence meant.

[dorinbogdan]

Something is wrong in the XML with xmlns="http://www.fixprotocol.org/FIXML-4-4"
Remove the xmlns attribute from <FIXML> element and then
<xsl:value-of select="FIXML/Order/@Acct" /> works.

[luthriaajay]

Yes,thats what I had guessed and removed it off.

How do I get the value of Hdr which is an element under Oder?
Have I done the right way as below?

 
<?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"/>
 
<xsl:template match="FIXML">
<xsl:apply-templates  select ="Order"/>
<xsl:apply-templates  select ="Order/Hdr"/>
</xsl:template>
 
<xsl:template match="Order">
<ID>
<xsl:value-of select="@Acct"/> 
</ID>
</xsl:template>
 
<xsl:template match="Order/Hdr">
<SD>
<xsl:value-of select="@Snt"/> 
</SD>
</xsl:template>
 
</xsl:stylesheet>
 

[dorinbogdan]

If want to see the <ID and <SD> tags in browser, then update the code like this:

<xsl:template match="FIXML">
    <xsl:apply-templates  select ="Order"/>
</xsl:template>
 
<xsl:template match="Order">
    &lt;ID&gt;    
        <xsl:value-of select="@Acct"/> 
    &lt;/ID&gt;
 
    &lt;SD&gt;     
        <xsl:value-of select="Hdr/@Snt"/> 
    &lt;/SD&gt;
</xsl:template>