cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Vishnev <avish...@optonline.net>
Subject RE: Cocoon2:XSP->Excel?
Date Wed, 14 Nov 2001 15:27:25 GMT
Marcelo,

Thanks for the files. BTW, there is a couple of garbage data lines on the
bottom of source.xml. Looks like the file was not generated properly, or
maybe the data is not in English and it only looks like garbage to me. In
any case, just wanted to give you heads up on that. I did exactly as you
outlined in your email. I copied excel.xls into stylesheets directory and
source.xml into one of my project directory. I kept serializer stanza
unchanged and inserted that into my sitemap file. I changed map:match stanza
to match the installation keeping serializer as excel. However, I still get
the same results, the process looks like it is hung or maybe just taking an
extremely long time (over 5 min). Is this your experience as well? Anyone
else is having the same problem?

Alex

-----Original Message-----
From: Marcelo F. Ochoa [mailto:mochoa@ieee.org]
Sent: Wednesday, November 14, 2001 7:18 AM
To: cocoon-users@xml.apache.org
Subject: Re: Cocoon2:XSP->Excel?

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 - mochoa@ieee.org
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




---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message