XLS formatting based on Complex Element type where Xsi-Type = ??

[robtyketto]

Greetings,

My XML schema defines a customer to be of type UK or Non-UK European making use of xsi:type.

The difference between the complex UK and Non-UK European customer types is they have an additional TWO extra fields from the standard customer type.

UK customer additionaly have CustomerCounty & CustomerPostcode
Non-UK European have CustomerAddressline5(optional) & Timezone(I dont need to print this)

However in my XSL I'm hardcoding the selecting of element names in (see code below).

I've looked at <xsl:if> but dont know how to compare the complex xsi type.

Can anyone help please to suggest away I only print the fields based on the xsi type?

Also as elemnt addresslline5 is optional for complex type NonUKEuropean customer is there a way to check if the field is present i.e. nulls before selectign the value?

I guess I could just reference all fields and if there empty or not present they wont print, but I'm sure there's a much better solution outthere.

Thanks
Rob

Extract from XML file.

<Customer xsi:type="UKCustomer">
 
<CustomerName>Ford Motors</CustomerName>
 
<CustomerCode>123456789A</CustomerCode>
 
<CustomerAddressLine1>10 Harvard Road</CustomerAddressLine1>
 
<CustomerAddressLine2>Fenton</CustomerAddressLine2>
 
<CustomerAddressLine3>Stoke-on-Trent</CustomerAddressLine3>
 
<CustomerAddressLine4>Staffordshire</CustomerAddressLine4>
 
<CustomerCountry>United Kingdom</CustomerCountry>
 
<CustomerSigneeName>Trevor Thames</CustomerSigneeName>
 
<CustomerSigneeSignature>T.Thames</CustomerSigneeSignature>
 
<CustomerPostCode>ST2 9DS</CustomerPostCode>
 
</Customer>

Extract from XSL File

<td align="justify" valign="top">
 
<xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerName"/><br/>
 
<xsl:value-of 
select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine1"/><br/>
 
<xsl:value-of 
select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine2"/><br/>
 
<xsl:value-of 
select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine3"/><br/>
 
<xsl:value-of 
select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine4"/><br/>
 
<xsl:value-of 
select="my:PODBatch/my:POD/my:Customer/my:CustomerCountry"/><br/>
 
<xsl:value-of 
select="my:PODBatch/my:POD/my:Customer/my:CustomerPostcode"/><br/>
 
</td>

[jkmyoung]

If you're going to be printing each non-empty element out, you could do the following:

<xsl:for-each select="my:PODBatch/my:POD/my:Customer/*[.!='']"><!-- select all non-empty elements -->
  <xsl:value-of select="."/><br/>
</xsl:for-each>

Otherwise, you can do the following:
1. Declare the xsi namespace in your stylesheet node.
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

2. If test

<xsl:if test="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine1 != ''"/>
  <xsl:value-of 
select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine1"/><br/>
</xsl:if>

[jkmyoung]

Another possible way is to split out based on the type using a choose-when-otherwise clause. eg:

<xsl:choose>
  <xsl:when test="@xsi:type='UK'">
     Output UK values here
  </xsl:when>
  <xsl:when test="@xsi:type='US'">
     Output US values here
  </xsl:when>
  <xsl:otherwise>
     Output default values here
  </xsl:otherwise>
</xsl:choose>
 

[robtyketto]

I've got the testing for empty strings problem solved.

Having issues with the xsi:type

    <xsl:for-each select="//my:POD/my:Customer">
                                <xsl:choose>    
                                        <xsl:when test ="@xsi:type='my:UKCustomer'">
                                            <xsl:value-of select="my:CustomerCounty"/><br/>
                                            <xsl:value-of select="my:CustomerPostCode"/><br/>
    </xsl:when>    
                                </xsl:choose>    
                            </xsl:for-each>

If I remove the choose and when code the data is being retrieved on the match.

I assumed since its selecing all elements under complex type Customer who's xsi:type = "UKCustomer" the xsl:when type will look for the xsi:type of Customer element.

Syntax wise its all right, just no values selected.

Thanks
Rob

XML data again showing the xsi:type :-

<Customer xsi:type="UKCustomer">
            <CustomerName>Ford Motors</CustomerName>
            <CustomerCode>123456789A</CustomerCode>
            <CustomerAddressLine1>10 Harvard Road</CustomerAddressLine1>
            <CustomerAddressLine2>Fenton</CustomerAddressLine2>
            <CustomerAddressLine3>Stoke-on-Trent</CustomerAddressLine3>
            <CustomerAddressLine4></CustomerAddressLine4>
            <CustomerCountry>United Kingdom</CustomerCountry>
            <CustomerSigneeName>Trevor Thames</CustomerSigneeName>
            <CustomerSigneeSignature>T.Thames</CustomerSigneeSignature>
            <CustomerCounty>Staffordshire</CustomerCounty>
            <CustomerPostCode>ST2 9DS</CustomerPostCode>
        </Customer>

[jkmyoung]

<xsl:when test ="@xsi:type='my:UKCustomer'">

<Customer xsi:type="UKCustomer">

Your xsi:type attribute has no my: in front of it.
Could it be as simple as that?

[robtyketto]

I removed the my: and still runs without retrieving data :-(

I've ruled out a problem with the match as ="//my:POD/my:Customer" will print the elements out if removing the choose and when options.

<xsl:for-each select="//my:POD/my:Customer">
                                <xsl:choose>    
                                        <xsl:when test ="@xsi:type='UKCustomer'">
                                            <xsl:value-of select="my:CustomerCounty"/><br/>
                                            <xsl:value-of select="my:CustomerPostCode"/><br/>
                                            </xsl:when>    
                                    </xsl:choose>    
                            </xsl:for-each>

[jkmyoung]

Only thing that comes to mind is that the xmlns:xsi namespace might be defined slightly differently in each file. Other than that you'd need to post your full xsl and xml to determine why.

[robtyketto]

Thanks for all the help so far :-)

Here's the full code :-
XML

<?xml version="1.0" encoding="UTF-8"?>
<PODBatch xmlns="http://my-pod/namespace" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://my-pod/namespace POD02.XSD">
<POD>
        <DeliveryInfo>
            <DeliveryNoteNo>DN012345</DeliveryNoteNo>
            <DeliveryDateTime>01/11/07 10:35</DeliveryDateTime>
            <DeliveryDrivername>Bill Egg</DeliveryDrivername>
            <DeliveryDriverSignature>B.Egg</DeliveryDriverSignature>
            <DeliveryStatus>In transit</DeliveryStatus>
        </DeliveryInfo>
        <Customer xsi:type="UKCustomer">
            <CustomerName>Ford Motors</CustomerName>
            <CustomerCode>123456789A</CustomerCode>
            <CustomerAddressLine1>10 Harvard Road</CustomerAddressLine1>
            <CustomerAddressLine2>Fenton</CustomerAddressLine2>
            <CustomerAddressLine3>Stoke-on-Trent</CustomerAddressLine3>
            <CustomerAddressLine4></CustomerAddressLine4>
            <CustomerCountry>United Kingdom</CustomerCountry>
            <CustomerSigneeName>Trevor Thames</CustomerSigneeName>
            <CustomerSigneeSignature>T.Thames</CustomerSigneeSignature>
            <CustomerCounty>Staffordshire</CustomerCounty>
            <CustomerPostCode>ST2 9DS</CustomerPostCode>
        </Customer>
        <OrderDetails>
            <ItemDescription>Radiator Large Type 1</ItemDescription>
            <ItemCustomerRef>RL01</ItemCustomerRef>
            <ItemQty>5</ItemQty>
        </OrderDetails>
        <OrderDetails>
            <ItemDescription>Radiator Small Type 1</ItemDescription>
            <ItemCustomerRef>RS01</ItemCustomerRef>
            <ItemQty>5</ItemQty>
        </OrderDetails>
        <OrderDetails>
            <ItemDescription>Valve</ItemDescription>
            <ItemCustomerRef>Val001</ItemCustomerRef>
            <ItemQty>20</ItemQty>
        </OrderDetails>
    </POD>
</PODBatch>

XSL

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xsi ="http://www.w3.org/2200/10/XMLSchema-instance"
xmlns:my="http://my-pod/namespace">
 
<xsl:template match="/">
    <html>
        <Header>    
            <img src="http://i140.photobucket.com/albums/r13/robtyketto/truck-clipart-icon2_ys61.gif" align="left"/>
        <h1>Proof-of-Delivery</h1>
        <br></br>
 
        <table border ="0" width="880">
            <tr>
                <td align="left" width="440"><font size="4"><b>Delivery note no: </b><xsl:value-of select="my:PODBatch/my:POD/my:DeliveryInfo/my:DeliveryNoteNo"/></font></td>
                <td align="left" width="440"><font size="4"><b>Delivery date: </b><xsl:value-of select="substring(my:PODBatch/my:POD/my:DeliveryInfo/my:DeliveryDateTime,1,8)"/>  <b> delivery time: </b><xsl:value-of select="substring(my:PODBatch/my:POD/my:DeliveryInfo/my:DeliveryDateTime,10,5)"/> </font></td>
            </tr>
        </table>
 
        <hr align="left" width="880"></hr>    
 
        </Header>
        <body>
 
        <table border = "0" width="880">
        <tr>
            <td width="400"><b>VAT No: </b>GB7778564</td>
            <td width="400"><b>Customer no: </b><xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerCode"/></td>
        </tr>
        </table>
 
 
            <table border = "1" width="880">
                <tr bgcolor = "#FFFFFF">
                    <th align="left" width="440">Sender:</th> 
                    <th align="left" width="440">Receiptant:</th> 
                </tr>
 
                <tr>
                        <td>Robs Company<br/>
                        Hersham Place<br/>
                        Walton-on-Thames<br/>
                        Surrey<br/>
                        KT19 4ZZ<br/>
                        United Kingdom<br/>
                        <br/>
                        Telephone: [phone]<br/>
                        E-Mail: [e-mail]
                        </td>    
 
                    <td align="justify" valign="top">
                        <xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerName"/><br/>
                        <xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine1"/><br/>
                        <xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine2"/><br/>
                        <xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine3"/><br/>
 
                            <xsl:if test="string-length(my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine4) >0 ">
                                <xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerAddressLine4"/><br/>
                            </xsl:if>
 
                            <xsl:for-each select="//my:POD/my:Customer">
                                <xsl:choose>    
                                        <xsl:when test ="@xsi:type='UKCustomer'">
                                            <xsl:value-of select="my:CustomerCounty"/><br/>
                                            <xsl:value-of select="my:CustomerPostCode"/><br/>
                                            </xsl:when>    
                                    </xsl:choose>    
                            </xsl:for-each>
 
                            <xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerCountry"/><br/>
                    </td>
                </tr>        
        </table>
 
        <hr align="left" width="880"></hr>
 
        <table border = "1" width="880" >
            <tr> 
                <th align="left"><b>Order line</b></th> 
                <th align="left"><b>Item desc</b></th>
                <th align="left"><b>Item ref</b></th>
                <th align="right"><b>Item quantity</b></th> 
            </tr> 
 
            <xsl:for-each select="//my:POD/my:OrderDetails">
                <tr>
                        <td width="100"><xsl:value-of select="position()"/></td>
                        <td width="325"><xsl:value-of select="my:ItemDescription"/></td>
                        <td><xsl:value-of select="my:ItemCustomerRef"/></td>
                        <td align ="right"><xsl:value-of select="my:ItemQty"/></td>
                </tr>
            </xsl:for-each>
 
            <tr>
                <td></td>
                <td></td>
                <td><b>Total</b></td>
                <td align="right"><xsl:value-of select="sum(/my:PODBatch/my:POD/my:OrderDetails/my:ItemQty)"/></td>
            </tr>
 
        </table>
    </body>
 
    <hr align="left" width="880"></hr>
 
    <footer>
        <table border = "0"  width="880">
            <tr>
                    <td width="220"><b>Driver name: </b></td>
                    <td width="220"><xsl:value-of select="my:PODBatch/my:POD/my:DeliveryInfo/my:DeliveryDrivername"/></td>
                    <td width="220"><b>Customer signee name: </b></td>
                    <td width="220"><xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerSigneeName"/></td>
            </tr>
                <tr>
                    <td><b>Driver signature: </b></td>
                    <td ><xsl:value-of select="my:PODBatch/my:POD/my:DeliveryInfo/my:DeliveryDriverSignature"/></td>
                    <td><b>Customer signature: </b></td>
                    <td><xsl:value-of select="my:PODBatch/my:POD/my:Customer/my:CustomerSigneeSignature"/></td>
            </tr>
        </table>
    </footer>
 
</html>
</xsl:template>
 
</xsl:stylesheet>

[jkmyoung]

As I thought, the xmlns:xsi namespaces are defined differently.
Should be using
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance
in both instances.
The version in your xslt in incorrect.