On Friday, February 3, 2012 6:16:09 PM UTC-5, Omi Chiba wrote:
>
> Do I need to rewrite this "export_csv" function completely ? or Can I
> just add import csv and set QUOTE_ALL ?
>
>
> Controller
> --------------------------
> def export_csv():
> import gluon.contenttype
> response.headers['Content-Type'] = \
> gluon.contenttype.contenttype('.csv')
> db = request.args[0]
> query = 'db.IQWAGFTY.TYPRCD!=""'
> response.headers['Content-disposition'] = 'attachment;
> filename=IQWAGFTY.csv'
> return str(db(query,ignore_common_filters=True).select())
>
Instead of:
return str(db(query,ignore_common_filters=True).select())
I think you could do something like:
import csv
import cStringIO
rows = db(query,ignore_common_filters=True).select()
s = cStringIO.StringIO()
rows.export_to_csv_file(s, quoting=csv.QUOTE_ALL)
return s.getvalue()
str(rows) actually does exactly the same as the above, but the above method
allows you to pass additional arguments to export_to_csv_file().
Anthony
