Register  Login  
  February 9, 2012  
Forum    
Forum Minimize
 
ForumForumDiscussionsDiscussionsXMLdb XMLdb problem with XMLDB and Exslproblem with XMLDB and Exsl
Previous Previous
 
Next Next
New Post
 10/10/2008 7:08 AM
 

Hi,

i am trying to use an xml with exml entension with this module and i get this error: 'Cannot find the script or external object that implements prefix 'exsl''

The xsl file i have write is this:

-------------------------

<?xml version="1.0" encoding="iso-8859-1"?><!-- DWXMLSource="../../../Documents and Settings/Sandro/Desktop/Pedigree/topKennel_nTitles.xml" --><!DOCTYPE xsl:stylesheet  [
 <!ENTITY nbsp   "&#160;">
 <!ENTITY copy   "&#169;">
 <!ENTITY reg    "&#174;">
 <!ENTITY trade  "&#8482;">
 <!ENTITY mdash  "&#8212;">
 <!ENTITY ldquo  "&#8220;">
 <!ENTITY rdquo  "&#8221;">
 <!ENTITY pound  "&#163;">
 <!ENTITY yen    "&#165;">
 <!ENTITY euro   "&#8364;">
]>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:exsl="http://exslt.org/common" extension-element-prefixes="exsl" version ="1.0">
 
  <xsl:output method="html" encoding="iso-8859-1" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>

  <xsl:template match="/">
    <xsl:variable name="classes">
        <xsl:for-each select="root/dbdog_rci_fieldtrial_detail">
          <class>
            <xsl:value-of select="desClass"/>
          </class>
        </xsl:for-each>
    </xsl:variable>

   
    <html xmlns="http://www.w3.org/1999/xhtml">
      <head>
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
        <title>Untitled Document</title>
        <link href="pedigree_3.css" rel="stylesheet" type="text/css" />
      </head>

      <body>
        <div align="center">

          <table border="1">
            <tr >
              <th  class="intestaTabella">Batteria</th>
              <th  class="intestaTabella">Pos.</th>
              <th  class="intestaTabella">Giud.</th>
              <th  class="intestaTabella">Tickets</th>
              <th  class="intestaTabella">Nome</th>
              <th  class="intestaTabella"></th>
              <th  class="intestaTabella">Razza</th>
              <th  class="intestaTabella">Allevamento</th>
              <th  class="intestaTabella">Conduttore</th>
              <th  class="intestaTabella">Punti</th>
            </tr>
         
    <xsl:for-each select="root/dbdog_rci_fieldtrial_detail">

      <xsl:variable name="idx" select="position()"/>
         
          <xsl:if test="$idx > 1">
       
        <xsl:variable name="thisclass" select ="desClass"/>
        <xsl:variable name="oldclass" select ="exsl:node-set($classes)/class[$idx - 1]"/>

        <xsl:if test="$thisclass != $oldclass ">
          <tr>
            <td colspan="10"></td>
          </tr>
        </xsl:if>
      </xsl:if>
      
         <tr>
        <td>
          <div align="center">
            <xsl:value-of select="desClass"/>
          </div>
        </td>
        <td>
          <div align="center">
            <xsl:value-of select="nPosition"/>
          </div>
        </td>
        <td>
          <div align="center">
            <xsl:value-of select="desJudgment"/>
          </div>
        </td>
        <td>
          <div align="center">
            <xsl:value-of select="desTicket"/>
          </div>
        </td>

        <td>

          <xsl:variable name="LinkDog" select="LinkDog"/>
          <xsl:choose>
            <xsl:when test="contains($LinkDog,'?')">
              <xsl:value-of select="desName"/>
            </xsl:when>
            <xsl:otherwise>
              <xsl:value-of select="desName"/>
            </xsl:otherwise>
          </xsl:choose>
        </td>
        <td>
          <a>
            <xsl:attribute name="href">
              <xsl:value-of select="LinkEvent"/>
            </xsl:attribute>
            <img  border="0" width="25">
              <xsl:attribute name="src">
                /Portals/rci.it/<xsl:value-of select="desBreed"/>.gif
              </xsl:attribute>
            </img>

          </a>
        </td>
        <td>
          <div align="center">
            <xsl:value-of select="desBreed"/>
          </div>
        </td>


        <td>

          <xsl:variable name="LinkKennel" select="LinkKennel"/>
          <xsl:choose>
            <xsl:when test="contains($LinkKennel,'?')">
              <xsl:value-of select="deskennel"/>
            </xsl:when>
            <xsl:otherwise>
              <xsl:value-of select="deskennel"/>
            </xsl:otherwise>
          </xsl:choose>
        </td>

        <td>
          <div align="center">
            <xsl:value-of select="desHandler"/>
          </div>
        </td>
        <td>
          <div align="center">
            <xsl:value-of select="Punti"/>
          </div>
        </td>

      </tr>

    </xsl:for-each>
    </table>
    </div>
    </body>

    </html>
  </xsl:template>
</xsl:stylesheet>

-------------------------

and the XML is:

---------------------

<dbdog_rci_fieldtrial_detail>
  <desClass>1° Batt. Francese</desClass>
  <desJudgment>M.B.</desJudgment>
  <desTicket></desTicket>
  <desName>Royal Crest Gold-n Blue To Be</desName>
  <deskennel>All. Royal Crest Gold-n</deskennel>
  <desHandler>Ceolin Pierluigi</desHandler>
  <LinkDog>/Default.aspx?tabid=492&amp;idDog=882</LinkDog>
  <LinkKennel>/Default.aspx?tabid=216&amp;idKennel=1</LinkKennel>
  <desBreed>Golden Retriever</desBreed>
  <Punti>3</Punti>
</dbdog_rci_fieldtrial_detail>
<dbdog_rci_fieldtrial_detail>
  <desClass>1° Batt. Francese</desClass>
  <desJudgment>M.B.</desJudgment>
  <desTicket></desTicket>
  <desName>Offlead .</desName>
  <deskennel>All. Offlead</deskennel>
  <desHandler>Aureli Nerina</desHandler>
  <LinkDog>/Default.aspx?tabid=502&amp;idDog=1175</LinkDog>
  <LinkKennel>/Default.aspx?tabid=257&amp;idKennel=92</LinkKennel>
  <desBreed>Labrador Retriever</desBreed>
  <Punti>3</Punti>
</dbdog_rci_fieldtrial_detail>
<dbdog_rci_fieldtrial_detail>
  <desClass>1° Batt. Francese</desClass>
  <desJudgment>B.</desJudgment>
  <desTicket></desTicket>
  <desName>It.Ch. Willow Willow</desName>
  <deskennel>All. Asti Barbara</deskennel>
  <desHandler>Chiara Berzacola</desHandler>
  <LinkDog>/Default.aspx?tabid=492&amp;idDog=20</LinkDog>
  <LinkKennel>/Default.aspx?tabid=216&amp;idKennel=10</LinkKennel>
  <desBreed>Golden Retriever</desBreed>
  <Punti>2</Punti>
</dbdog_rci_fieldtrial_detail>
<dbdog_rci_fieldtrial_detail>
  <desClass>2° Batt. Francese</desClass>
  <nPosition>1</nPosition>
  <desJudgment>ECC.</desJudgment>
  <desTicket>CAC </desTicket>
  <desName>Avjavas Double Dream</desName>
  <desHandler>Diego Del Soldato</desHandler>
  <LinkDog>/Default.aspx?tabid=492&amp;idDog=557</LinkDog>
  <desBreed>Golden Retriever</desBreed>
  <Punti>15</Punti>
</dbdog_rci_fieldtrial_detail>
<dbdog_rci_fieldtrial_detail>
  <desClass>2° Batt. Francese</desClass>
  <nPosition>2</nPosition>
  <desJudgment>ECC.</desJudgment>
  <desTicket></desTicket>
  <desName>Cachecreek</desName>
  <deskennel>All. Castellari</deskennel>
  <desHandler>Luciana Lullini</desHandler>
  <LinkDog>/Default.aspx?tabid=502&amp;idDog=1159</LinkDog>
  <LinkKennel>/Default.aspx?tabid=257&amp;idKennel=99</LinkKennel>
  <desBreed>Labrador Retriever</desBreed>
  <Punti>8</Punti>
</dbdog_rci_fieldtrial_detail>
<dbdog_rci_fieldtrial_detail>
  <desClass>2° Batt. Francese</desClass>
  <desJudgment>ECC.</desJudgment>
  <desTicket></desTicket>
  <desName>It.Ch.,Int.Ch.,V.Ch.Soc.,Ft.W. Royal Crest Gold-n Heart To Heart</desName>
  <deskennel>All. Royal Crest Gold-n</deskennel>
  <desHandler>Sandro De Matteis</desHandler>
  <LinkDog>/Default.aspx?tabid=492&amp;idDog=1</LinkDog>
  <LinkKennel>/Default.aspx?tabid=216&amp;idKennel=1</LinkKennel>
  <desBreed>Golden Retriever</desBreed>
  <Punti>4</Punti>
</dbdog_rci_fieldtrial_detail>
<dbdog_rci_fieldtrial_detail>
  <desClass>2° Batt. Francese</desClass>
  <desJudgment>M.B.</desJudgment>
  <desTicket></desTicket>
  <desName>It.Ch. Newton Dell'Antica Etruria</desName>
  <deskennel>All. Dell'Antica Etruria</deskennel>
  <desHandler>Federico Nonni</desHandler>
  <LinkDog>/Default.aspx?tabid=492&amp;idDog=439</LinkDog>
  <LinkKennel>/Default.aspx?tabid=216&amp;idKennel=46</LinkKennel>
  <desBreed>Golden Retriever</desBreed>
  <Punti>3</Punti>
</dbdog_rci_fieldtrial_detail>    
---------------------

 

Any idea /help ?

 

Thanks,

Sandro De Matteis

 

New Post
 10/13/2008 5:43 AM
 

Hi,

i am also trying with this xsl with no success ! Any help / Idea ?

My needs is to have a blank line each change of desClass value:

desClass  Value

Class1        X
Class1        Z

Class2       Y
Class2       W

ClassX     ....
.....

-------------

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"  version ="1.0">

  <xsl:template match ="/">
    <html xmlns="http://www.w3.org/1999/xhtml">
      <head>
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
        <title>Untitled Document</title>
        <link href="pedigree_3.css" rel="stylesheet" type="text/css" />
      </head>

      <body>
        <div align="center">

          <table border="1">
            <tr >
              <th  class="intestaTabella">Batteria</th>
              <th  class="intestaTabella">Pos.</th>
              <th  class="intestaTabella">Giud.</th>
              <th  class="intestaTabella">Tickets</th>
              <th  class="intestaTabella">Nome</th>
              <th  class="intestaTabella"></th>
              <th  class="intestaTabella">Razza</th>
              <th  class="intestaTabella">Allevamento</th>
              <th  class="intestaTabella">Conduttore</th>
              <th  class="intestaTabella">Punti</th>
            </tr>

            <xsl:for-each select="root/dbdog_rci_fieldtrial_detail">

              <xsl:variable name="idx" select="position()"/>

              <xsl:if test="$idx > 1">

                <xsl:variable name="thisclass" select ="desClass"/>
                <xsl:variable name="oldclass" select ="//dbdog_rci_fieldtrial_detail[$idx - 1]/desClass"/>

                <xsl:if test="$thisclass != $oldclass ">
                  <tr>
                    <td colspan="10"></td>
                  </tr>
                </xsl:if>
              </xsl:if>

 

              <tr>
                <td>
                  <div align="center">
                    <xsl:value-of select="desClass"/>
                  </div>
                </td>
                <td>
                  <div align="center">
                    <xsl:value-of select="nPosition"/>
                  </div>
                </td>
                <td>
                  <div align="center">
                    <xsl:value-of select="desJudgment"/>
                  </div>
                </td>
                <td>
                  <div align="center">
                    <xsl:value-of select="desTicket"/>
                  </div>
                </td>

                <td>

                  <xsl:variable name="LinkDog" select="LinkDog"/>
                  <xsl:choose>
                    <xsl:when test="contains($LinkDog,'?')">
                      <xsl:value-of select="desName"/>
                    </xsl:when>
                    <xsl:otherwise>
                      <xsl:value-of select="desName"/>
                    </xsl:otherwise>
                  </xsl:choose>
                </td>
                <td>
                  <a>
                    <xsl:attribute name="href">
                      <xsl:value-of select="LinkEvent"/>
                    </xsl:attribute>
                    <img  border="0" width="25">
                      <xsl:attribute name="src">
                        /Portals/rci.it/<xsl:value-of select="desBreed"/>.gif
                      </xsl:attribute>
                    </img>

                  </a>
                </td>
                <td>
                  <div align="center">
                    <xsl:value-of select="desBreed"/>
                  </div>
                </td>


                <td>

                  <xsl:variable name="LinkKennel" select="LinkKennel"/>
                  <xsl:choose>
                    <xsl:when test="contains($LinkKennel,'?')">
                      <xsl:value-of select="deskennel"/>
                    </xsl:when>
                    <xsl:otherwise>
                      <xsl:value-of select="deskennel"/>
                    </xsl:otherwise>
                  </xsl:choose>
                </td>

                <td>
                  <div align="center">
                    <xsl:value-of select="desHandler"/>
                  </div>
                </td>
                <td>
                  <div align="center">
                    <xsl:value-of select="Punti"/>
                  </div>
                </td>

              </tr>

            </xsl:for-each>


          </table>
        </div>
      </body>

    </html>
  </xsl:template>
</xsl:stylesheet>

-------------

New Post
 10/13/2008 9:32 AM
 

Some background, XMLDB was developed to meet a specific need... back in V2.1 of DNN ... I updated it for DNN V3 and will do so once V5 is officially out.

I am not very good with XML  and XSL other than the basics, so I can't really comment on the problems.  As for "unable to find" problems, the XML and XSL specificed are passed to Microsoft's standard XML parser, so I would check there.

Also, I would start small... and get something working and slowly add to the XLS until you have a issue, then you can determine the specific issue.

Hope this helps.
Paul.

New Post
 10/23/2008 9:14 AM
 

Hi Paul,

thanks for replay. I have resolved my issue, it was an xsl syntax problem.

I use a lot you free module XMLDB and i am very interesed in V 5 version.
Any idea about release date ? Do you need my help for beta testing ?

Can you send me please the source code for V3 ? ( i n f o _a t_ s a n d r o d e m a t t e i s _d o t_ c o m  )

Thanks in advance

Previous Previous
 
Next Next
ForumForumDiscussionsDiscussionsXMLdb XMLdb problem with XMLDB and Exslproblem with XMLDB and Exsl

Print  

  Home | Blog | Forum | Subscriptions | Free Modules | Videos   Page generated in 0.093984 seconds.
  Copyright 2010 by TressleWorks   Terms Of Use | Privacy Statement