On printing the fields based on the xsi type in XLS formatting

On printing the fields based on the xsi type in XLS formatting

Author Name Status Posted Time

Akshay Devsi 1/7/2008 1:09:29 AM

Author is Offline

Hi all,
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

Subject Author Status Date

Re: On printing the fields based on the xsi type i
n XLS formatting
Philippe Henderson 1/7/2008 3:08:25 AM

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

Code: ( xml )

<xsl:for-each select="my:PODBatch/my:POD/my:Customer/*[.!='']">

<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

Code: ( text )

<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>

Post Comments

Re: On printing the fields based on the xsi type i
n XLS formatting
Philippe Henderson 1/7/2008 3:09:00 AM

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

Code: ( xml )

<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>

Post Comments

Re: I've got the testing for empty strings
Akshay Devsi 1/7/2008 3:10:50 AM

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

Having issues with the xsi:type

Code: ( text )
<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
Post Comments

Re: I removed
Philippe Henderson 1/7/2008 3:19:02 AM

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.

Code: ( text )

<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>

Post Comments

Re: the xmlns:xsi namespace
Philippe Henderson 1/7/2008 3:22:09 AM

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.

Post Comments

Re: Thanks for all the help
Akshay Devsi 1/7/2008 3:23:31 AM

Thanks for all the help so far :-)

Here's the full code :-
XML

Code: ( text )
<?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

Code: ( text )
<?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: 01782 880 8899<br/>

E-Mail: westrad@supanet.co.uk

</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>

Post Comments

Re: the xmlns:xsi namespaces are defined different
ly.
Philippe Henderson 1/7/2008 3:25:04 AM

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.

Post Comments

Related Forums
Optimizing Images
Get a Website Template for Free!!!
Get a Website Template for Free!!!
Reply to Hesus!!!
Do You Sell Your Templates on Ebay?

Home | About Us | Site Map | Privacy Policy