Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XSLT
|
XSLT General questions and answers about XSLT. For issues strictly specific to the book XSLT 1.1 Programmers Reference, please post to that forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XSLT section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 13th, 2015, 01:03 PM
Registered User
 
Join Date: Feb 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default XSLT: multiple xml input and matching value

Hi to all !!!!
i'm using saxon: i have an xhtml,practically is a table with a token like this:

Code:
<?xml version="1.0" encoding="windows-1252"?>

<!DOCTYPE html
   PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >

<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <title></title>
    <meta name="GENERATOR" content="OpenOffice.org 3.3  (Win32)" />
    <meta name="CREATED" content="0;0" />
    <meta name="CHANGED" content="20150212;12040469" />
    <style type="text/css" xml:space="preserve">

        BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small }

    </style>
  </head>
  <body text="#000000">
    <table frame="void" cellspacing="0" rules="none" border="0">
      <colgroup>
        <col width="78" />
        <col width="379" />
        <col width="370" />
        <col width="165" />
        <col width="165" />
        <col width="120" />
        <col width="135" />
        <col width="135" />
      </colgroup><tbody>
        <tr>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="78" height="82" align="center">
            <b>CODE </b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="379" align="center">
            <b>DISPLAY NAME </b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="370" align="center">
            <b><font color="#000000">
            2013 </font></b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="165" align="center">
            <b>TYPE</b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="165" align="center">
            <b>2013 FORECAST</b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="120" align="center">
            <b>2014 FORECAST<br /></b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="135" align="center">
            <b>2015 FORECAST</b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="135" align="center">
            <b>2016 FORECAST</b>
          </td>
        </tr>
        <tr>
          <td style="border-top: 1px solid #000000; border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
          </td>
          <td style="border-top: 1px solid #000000; border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            2 001
          </td>
          <td align="left">
            SOME TEXT TO DISPLAY 1</td>
          <td align="left">

            <br />
          </td>
          <td align="left">
            some type 1</td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td align="left">
            SOME TEXT TO DISPLAY 2</td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            2 002
          </td>
          <td align="left">
            SOME TEXT TO DISPLAY 3</td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            some type 3</td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
      </tbody>
    </table>
    <!-- 
      ************************************************************************** -->
  </body>
</html>
In this xhtml i have a code in a td element like : 2 001, 2 002.

Now I have an xml file that allows you to map data like this:

Code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<certificati>
    <certificato anno="2014" codiceEnte="#CODICE_ENTE#"
        tipoCertificato="P" tipoValuta="E">

        <elemento>
            <colonne quadro="02" voce="001">
                <colonna num="1">123</colonna>
                <colonna num="2">456</colonna>
                <colonna num="3">789</colonna>
                <colonna num="4">10112</colonna>
                <colonna num="5">1312</colonna>
            </colonne>
            <colonne quadro="02" voce="002">
                <colonna num="1">2123</colonna>
                <colonna num="2">3456</colonna>
                <colonna num="3">567</colonna>
                <colonna num="4">876</colonna>
                <colonna num="5">8765</colonna>
            </colonne>

        </elemento> 
    </certificato>
</certificati>
The out file must be an xhtml with value matched in the value xml file: for matching value u have to use this key for example :
Code:
<colonne quadro="02" voce="001">
for 2 001 in the TD element in xhtml and fill the other value.

The out put file must be:

Code:
<?xml version="1.0" encoding="windows-1252"?>

<!DOCTYPE html
   PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >

<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <title></title>
    <meta name="GENERATOR" content="OpenOffice.org 3.3  (Win32)" />
    <meta name="CREATED" content="0;0" />
    <meta name="CHANGED" content="20150212;12040469" />
    <style type="text/css" xml:space="preserve">

        BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small }

    </style>
  </head>
  <body text="#000000">
    <table frame="void" cellspacing="0" rules="none" border="0">
      <colgroup>
        <col width="78" />
        <col width="379" />
        <col width="370" />
        <col width="165" />
        <col width="165" />
        <col width="120" />
        <col width="135" />
        <col width="135" />
      </colgroup><tbody>
        <tr>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="78" height="82" align="center">
            <b>CODE </b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="379" align="center">
            <b>DISPLAY NAME </b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="370" align="center">
            <b><font color="#000000">
            2013 </font></b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="165" align="center">
            <b>TYPE</b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="165" align="center">
            <b>2013 FORECAST</b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="120" align="center">
            <b>2014 FORECAST<br /></b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="135" align="center">
            <b>2015 FORECAST</b>
          </td>
          <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" width="135" align="center">
            <b>2016 FORECAST</b>
          </td>
        </tr>
        <tr>
          <td style="border-top: 1px solid #000000; border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
            <br />
          </td>
          <td style="border-top: 1px solid #000000" align="left">
          </td>
          <td style="border-top: 1px solid #000000; border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">2 001</td>
          <td align="left">
            SOME TEXT TO DISPLAY 1</td>
          <td align="left">

            <br />
            123
          </td>
          <td align="left">
            some type 1</td>
          <td align="left">
            <br />
            456
          </td>
          <td align="left">
            <br />
            789
          </td>
          <td align="left">
            <br />
            10112
          </td>
          <td style="border-right: 1px solid #000000" align="left">

            <br />
            1312
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            <br />
          </td>
          <td align="left">
            SOME TEXT TO DISPLAY 2</td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td align="left">
            <br />
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
          </td>
        </tr>
        <tr>
          <td style="border-left: 1px solid #000000" height="17" align="left">
            2 002
          </td>
          <td align="left">
            SOME TEXT TO DISPLAY 3</td>
          <td align="left">
            <br />
            2123
          </td>
          <td align="left">
            some type 3</td>
          <td align="left">
            <br />
            3456
          </td>
          <td align="left">
            <br />
            567
          </td>
          <td align="left">
            <br />
            876
          </td>
          <td style="border-right: 1px solid #000000" align="left">
            <br />
            8765
          </td>
        </tr>
      </tbody>
    </table>
    <!-- 
      ************************************************************************** -->
  </body>
</html>
The question is: how to do this output with a single stylesheets?

Thank you.
Dave





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to process multiple input xml files with a single xslt ? Divya XSLT 12 October 9th, 2018 03:01 AM
handling multiple input xml feeds stolte XSLT 5 March 3rd, 2010 06:21 PM
to remove namespace prefix form input xml using xslt robin_stringss XSLT 4 May 17th, 2009 06:50 AM
Multiple input xml / get data from other xml file elayaraja.s XSLT 3 July 25th, 2008 06:59 AM
xml and xsl templates as input to xslt gives xml rameshnarayan XSLT 5 August 3rd, 2005 01:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.