I have not experience with the book csv output example, but it looks
different than your implementation:
-It has a special view "..../name.csv" to render the function output
-The Content-Type parameter is "application-vnd.ms-excel"
I think you could change the response view parameter on form
validation to .../name.csv, have the function to return a dict object
and use the book example view to return the csv file response.
The example I am refering to is in section 10.1.6
On 14 mar, 18:19, Richard <ml.richard.vez...@gmail.com> wrote:
> Hello,
>
> I strungle with export of csv... I have this function that works great :
>
> def export_csv(tab1_id):
> import gluon.contenttype
> response.headers['Content-Type'] = \
> gluon.contenttype.contenttype('.csv')
> import cStringIO
> stream=cStringIO.StringIO()
> db((db.tab1.id == tab1_id)).select().export_to_csv_file(stream)
> response.headers['Content-disposition'] = 'attachment; filename=%s.csv'
> % 'test12345'
> response.write(stream.getvalue())
>
> def export_default_analysis_request():
> tab1_subset = (db.tab1.bool1 == True)
> form = SQLFORM.factory(
> Field('tab1_id',
> requires=IS_IN_DB(db(tab1_subset),'tab1.id','%(f1)s')),
> submit_button=T('Submit'))
> if form.accepts(request.vars, session):
> response.flash = T('form accepted')
> export_csv(tab1_id = form.vars.tab1_id)
> elif form.errors:
> response.flash = T('form has errors')
> else:
> response.flash = T('please fill out the form')
> return dict(form=form)
>
> The problem is that I am getting the html page below the value I want to
> export...
>
> Do I need to redirect on a blank page? It likes if response contain the
> actual page that get out at the same time as the data...
>
> I just copy stuff from here and there, but I think I will have to better
> understand what is going on...
>
> Thanks
>
> Richard
