Alex Vishnev wrote:
>Marcelo,
>I tried to configure everything that you suggested. When I try to open
>DEMOj.excel (or whatever it resolves to), the browser does not display any
>data. It almost looks like the process is hung. Can you enclose all of your
>files? BTW, as far as I understand dbprism does not play a role in this
>transformation. Is that correct?
>
>Alex
>
>
>
DB Prism is custom Generaror for Cocoon2, then XSP could play the same
role in the xml generation.
DB Prism returns an XML as the source.xml file attached.
Then is transformed by the excel.xsl stylesheet, attached too.
But requires the special configuration into sitemap.xmap file to
return an correct mime type for excel.
The sitemap modifications are:
In a serializer sections:
<map:serializer name="excel" mime-type="application/vnd.ms-excel"
src="org.apache.cocoon.serialization.XMLSerializer">
<encoding>iso-8859-1</encoding>
</map:serializer>
In pipelines section:
<map:match pattern="xmlj/DEMOj.excel">
<map:generate type="db" src="/xmlj/DEMOj.excel"/>
<map:transform src="stylesheets/dbprism/excel.xsl"/>
<map:serialize type="excel"/>
</map:match>
Replace the pattern attribute according to your installation
configuration and the generate type to serverpages type for XSP
generation. Note that in this match section the serializer is "excel"
defined into the previous part.
Best regards, Marcelo.
--
Marcelo F. Ochoa - [EMAIL PROTECTED]
Do you Know DB Prism? Look @ http://www.plenix.com/dbprism/
More info?
Chapter 21 of the book "Professional XML Databases" (Wrox Press
http://www.wrox.com/)
Chapter 8 of the book "Oracle & Open Source" (O'Reilly
http://www.oreilly.com/catalog/oracleopen/)
-----------------------------------------------
Lab. de Sistemas - Fac. de Cs. Exactas - UNICEN
Paraje Arroyo Seco - Campus Universitario
(7000) Tandil - Bs. AS. - Argentina
Te: +54-2293-444430 Fax: +54-2293-444431
<?xml version='1.0' encoding='iso-8859-1'?>
<ROWSET><ROW empno="1"><name>Velasquez</name>
<job>President</job>
<sal>2500</sal>
</ROW>
<ROW empno="2"><name>Ngao</name>
<job>VP, Operations</job>
<sal>1450</sal>
</ROW>
<ROW empno="3"><name>Nagayama</name>
<job>VP, Sales</job>
<sal>1400</sal>
</ROW>
<ROW empno="4"><name>Quick-To-See</name>
<job>VP, Finance</job>
<sal>1450</sal>
</ROW>
<ROW empno="5"><name>Ropeburn</name>
<job>VP, Administration</job>
<sal>1550</sal>
</ROW>
<ROW empno="6"><name>Urguhart</name>
<job>Warehouse Manager</job>
<sal>1200</sal>
</ROW>
<ROW empno="7"><name>Menchu</name>
<job>Warehouse Manager</job>
<sal>1250</sal>
</ROW>
<ROW empno="8"><name>Biri</name>
<job>Warehouse Manager</job>
<sal>1100</sal>
</ROW>
<ROW empno="9"><name>Catchpole</name>
<job>Warehouse Manager</job>
<sal>1300</sal>
</ROW>
<ROW empno="10"><name>Havel</name>
<job>Warehouse Manager</job>
<sal>1307</sal>
</ROW>
<ROW empno="11"><name>Magee</name>
<job>Sales Representative</job>
<sal>1400</sal>
</ROW>
<ROW empno="12"><name>Giljum</name>
<job>Sales Representative</job>
<sal>1490</sal>
</ROW>
<ROW empno="13"><name>Sedeghi</name>
<job>Sales Representative</job>
<sal>1515</sal>
</ROW>
<ROW empno="14"><name>Nguyen</name>
<job>Sales Representative</job>
<sal>1525</sal>
</ROW>
<ROW empno="15"><name>Dumas</name>
<job>Sales Representative</job>
<sal>1450</sal>
</ROW>
<ROW empno="16"><name>Maduro</name>
<job>Stock Clerk</job>
<sal>1400</sal>
</ROW>
<ROW empno="17"><name>Smith</name>
<job>Stock Clerk</job>
<sal>940</sal>
</ROW>
<ROW empno="18"><name>Nozaki</name>
<job>Stock Clerk</job>
<sal>1200</sal>
</ROW>
<ROW empno="19"><name>Patel</name>
<job>Stock Clerk</job>
<sal>795</sal>
</ROW>
<ROW empno="20"><name>Newman</name>
<job>Stock Clerk</job>
<sal>750</sal>
</ROW>
<ROW empno="21"><name>Markarian</name>
<job>Stock Clerk</job>
<sal>850</sal>
</ROW>
<ROW empno="22"><name>Chang</name>
<job>Stock Clerk</job>
<sal>800</sal>
</ROW>
<ROW empno="23"><name>Patel</name>
<job>Stock Clerk</job>
<sal>795</sal>
</ROW>
<ROW empno="24"><name>Dancs</name>
<job>Stock Clerk</job>
<sal>860</sal>
</ROW>
<ROW empno="25"><name>Schwartz</name>
<job>Stock Clerk</job>
<sal>1100</sal>
</ROW>
<ROW empno="26"><name>áéíóúñ</name>
<job>null</job>
<sal>100</sal>
</ROW>
<ROW empno="41"><name>º xx</name>
<job>null</job>
<sal>null</sal>
</ROW>
</ROWSET>
<?xml version="1.0"?>
<!-- Written by Marcelo F. Ochoa "[EMAIL PROTECTED]" -->
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:template match="/">
<xsl:processing-instruction name="cocoon-format">type="application/vnd.ms-excel"</xsl:processing-instruction>
<html>
<table>
<tr><th>Emp Number</th><th>Name</th><th>Job</th><th>Sal</th></tr>
<xsl:for-each select="ROWSET/ROW">
<xsl:sort select="sal"
data-type="number"
order="ascending"/>
<tr>
<td><xsl:value-of select="@empno"/></td>
<td><xsl:value-of select="name"/></td>
<td><xsl:value-of select="job"/></td>
<td><xsl:value-of select="sal"/></td>
</tr>
</xsl:for-each>
</table>
</html>
</xsl:template>
</xsl:stylesheet>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
