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

108 New Member

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 & CustomerPostcod e
Non-UK European have CustomerAddress line5(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.

Expand|Select|Wrap|Line Numbers

 <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

Expand|Select|Wrap|Line Numbers

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

Nov 7 '07 #1

Subscribe Reply

3957

jkmyoung

2,057

Recognized Expert Top Contributor

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

Expand|Select|Wrap|Line Numbers

 
<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

Expand|Select|Wrap|Line Numbers

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

Nov 7 '07 #2

jkmyoung

2,057

Recognized Expert Top Contributor

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

Expand|Select|Wrap|Line Numbers

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

Nov 7 '07 #3

robtyketto

108

New Member

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

Having issues with the xsi:type

Expand|Select|Wrap|Line Numbers

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

Expand|Select|Wrap|Line Numbers

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

Nov 8 '07 #4

jkmyoung

2,057

Recognized Expert Top Contributor

Expand|Select|Wrap|Line Numbers

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

Expand|Select|Wrap|Line Numbers

<Customer xsi:type="UKCustomer">

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

Nov 8 '07 #5

robtyketto

108

New Member

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.

Expand|Select|Wrap|Line Numbers

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

Nov 8 '07 #6

jkmyoung

2,057

Recognized Expert Top Contributor

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.

Nov 8 '07 #7

robtyketto

108

New Member

Thanks for all the help so far :-)

Here's the full code :-
XML

Expand|Select|Wrap|Line Numbers

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

Expand|Select|Wrap|Line Numbers

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

Nov 8 '07 #8

jkmyoung

2,057

Recognized Expert Top Contributor

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.

Nov 8 '07 #9

Similar topics

3398

XSLT: Confusion over adding attributes with xml:element and xml:attribute

by: Jordan Willms | last post by:

Hi there. I am working with lom metadata and I am a little confused with how to form the following xml element: <lom xmlns="http://www.imsglobal.org/xsd/imsmd_v1p2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.imsglobal.org/xsd/imsmd_v1p2 imsmd_v1p2p2.xsd"/>

.NET Framework

7493

How to add xsi:schemaLocation attribute to XML element

by: kaush | last post by:

Hi all, I am trying to serialize a C# object into a XML document using "XmlSerializer" class. One of the elements of the XML document needs a "xsi:schemaLocation" attribute. I am not sure how to add this to the XML element Please help me with if you can. Thanks, kaush

.NET Framework

1742

C# generated .NET stubs break on a null return of a complex object

by: Dan A | last post by:

I have a SOAP written in Java, and being served by Apache Axis - using the wrapped mode. I then used VS 2003 to generate C# client stubs. I have many complex types that are returned - and these work fine for the most part. The current problem I have (Which appears to be a bug with .NET - but I can't seem to find a place to report .NET bugs without paying money) is that when I call a method that returns an array of one of my own...

.NET Framework

1391

using dataset writexml to update data and losing formatting

by: Randall Arnold | last post by:

I have a Microsoft Access report (built on a SQL Server 2000 query) I have exported as xml/html. I include a stylesheet in the original export for formatting of the report. The schema is separate. When I preview this in my Visual web developer Express project it looks almost perfect (VBA generated color formatting is missing, but that's no show-stopper). So it works up to here. For unknown reasons I cannot use the Live Data option in...

ASP.NET

1682

does the order of the attributes in the root element matter?

by: hilz | last post by:

Hi. I have two xml files with the following roots: <MyRootElement xmlns="http://myURI" xmlns:prefixA="http://URI_for_A" xmlns:prefixB="http://URI_for_B" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://myURI http://myURI/mySchema.xsd" prefixA:someAttribute="some value"

.NET Framework

2054

output formatting for classes

by: Russ | last post by:

I'd like to get output formatting for my own classes that mimics the built-in output formatting. For example, >>> x = 4.54 >>> print "%4.2f" % x 4.54 In other words, if I substitute a class instance for "x" above, I'd like to make the format string apply to an element or elements of the instance. Can I somehow overload the "%" operator for that? Thanks.

Python

3515

Cannot find root element in XML file

by: TT (Tom Tempelaere) | last post by:

Hi all, I created an XSD to define the structure of an XML file for my project. I made an XML file linked to the XSD using XmlSpy. The problem is that if I read the file using .NET XmlDocument and then query for the root element, the result is always null (1). However if I strip the root element of all attributes generated by XmlSpy, then there is no problem to find the root element with .NET XML classes (2). (1) The XML for which...

.NET Framework

2486

How to change value of element with known path using XML

by: =?Utf-8?B?VG9uZQ==?= | last post by:

Hi, I need to change a value of an element in an XML file, I have been trying to select the node to edit but can only get as far as component and have to itterate through.. XmlDocument doc = new XmlDocument(); doc.Load("C:\\WINDOWS\\Panther\\Sysprep.xml"); // Create an XmlNamespaceManager to resolve the default namespace.

C# / C Sharp

12929

Removing an attribute from an element in xsl

by: MedIt | last post by:

Hi, I am new in using xsl.I am stuck in a simple task,which is trying to remove an atribute from a node,and keep the rest of the attributes of this element in the xslt. I have tried a couple of options but to no use so far! Can any one shed some light on me? Here's a sample of my original xml: <?xml version="1.0" encoding="UTF-8" ?> <dom xmlns="http://www.cdisc.org/ns/odm/v1.2" xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance"...

XML

1507

Maintain formatting

by: dbuchanan | last post by:

I want to fill a textbox or a label or with lines from a listbox. I want to preserve the lline for line as it comes from the list box. I do not want the test to run-on. I suppose it is okay to wrap if it is longer than the width of the control. This data will later be taken from this control and put into a text box in a report in ReportViewer where I will want to preserve the same formating there. Thank you,

ASP.NET

8876

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8556

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8642

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5666

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4198

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4371

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2774

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2011

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1777

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General