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

Emailid
Password


Forgot password
New user Sign Up

ASP

Classic Asp
Asp.Net 1.1
Asp.Net 2.0
Asp.Net 3.5

OFFSHORE

Outsourcing
Development
Training

PROJECT MANAGEMENT

Time Management
Stress Management
Issue Management
Project Planning
Leadership Skills
Resource Management

Products

Software Products
Hardware Products

.NET

C#.Net
VB.Net
VC.Net
J#.Net

PHP

PHP 3.x
PHP 4.x
PHP 5

VS 6.0

VB
VC

C,C++

MFC
VC++

SCRIPTING

JavaScript
VBScript

OTHER

General Article
Ajax
Ajax.Net
SEO

DATABASE

Sql Server
MySQL
Oracle

JAVA

Java Core

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