something is wrong with the code....
zipf.writestr('ExportAllWorkers.csv', rows)
you can't pipe in to writestr "rows", which in your case is the uber-rich
Rows object spitted by DAL, as writestr expects a file-like object or a
string.
Maybe what you're trying to do is to pipe in the default representation of
a Rows, which is a csv-like string.... but you need to force it as
str(rows).
On Saturday, January 23, 2016 at 7:54:11 PM UTC+1, Yebach wrote:
>
> Hello
>
> I have the following problem
>
> I need to download a csv and an excel file together in a zip file
>
> I would like to skip the part to create file(s) on server and then serve
> it and remove it.
>
> I am getting an error while using
>
> import csv, cStringIO
> import zipfile
> exported_chunks_zip = cStringIO.StringIO()
> rows.export_to_csv_file(exported_chunks_zip, delimiter=';',
> quoting=csv.QUOTE_NONNUMERIC)
> zipf = zipfile.ZipFile(exported_chunks_zip, "w",
> compression=zipfile.ZIP_DEFLATED)
> zipf.writestr('ExportAllWorkers.csv', rows)
>
> must be string or read-only buffer, not Rows
>
>
> rows is value from db.
>
> Also when I try to make an excel file how do i serve it to zip?
>
> Any suggestions?
>
> Thank you
>
>
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
