[Zope] RE: Perl scripts

[Andreas Tille]

On Wed, 9 Oct 2002, Charlie Reiman wrote:

> Yes, this is pretty easy. Some python script to get you going:
> ---------------
> rs = some_sql_query()
>
> for item in rs:
>   result_str += (str(item.DATE) + ',' +
>                  str(item.STUFF) + ',' +
>                  str(item.MORESTUFF) + '\n')
>
> response.setHeader('Content-type', 'application/vnd.ms-excel')
> response.setHeader('Content-Length', len(result_str))
> response.setHeader('Content-Disposition',
> 'attachment;filename=filename.csv')
> return result_str
> ----------------
>
> Be warned that mozilla doesn't handle this quite right. It launches excel
> and hands it the data but seems to translate the EOL characters in the
> process so excel refuses to split the columns. Ironically, Excel 2000 only
> accepts the unix EOL character for csv data. So: it works fine from IE but
> not so fine from Mozilla. If anyone has a dual browser solution I'd like to
> see it.
This hins quite helpful - at least I get reasonable effects under Linux
with Galeon - this handles the resulting file with Gnumeric as default.
(I have not tested it with Excel - because of a lack of a running Excel
installation but it seems promissing.)

The only drawback is that I did not found a way to specify sane table
headings like

      "DATE"   |    "STUFF"   |   "MORESTUFF"
   ---------------------------------------------
    2002-7-17  | some stuff   | some more stuff
      ...      |   ...        |    ...

Any way to do this with csv??

Kind regards and thanks for the hint

         Andreas.