I think
<a href="{{=URL(r=request,f='evaluation_data.csv')}}">Download as csv-
file</a>
On 10 Lug, 15:54, Johann Spies <[email protected]> wrote:
> I would appreciate help to get csv-download to work please.
>
> The following in my controller:
>
> def search_filled_in_forms():
> sp = request.vars.sp
> form_id = request.vars.form_id.lower()
> title = request.vars.title.lower()
> date = request.vars.date
> query = (db.evaluation_form.service_provider == sp) &\
> (db.evaluation_form.form_id.lower() == form_id) &\
> (db.evaluation_form.title_of_training.lower() == title) &\
> (db.evaluation_form.date == date)
>
> rows = db(query).select(db.evaluation_form.ALL)
>
> return dict(rows=rows)
>
> def evaluation_data():
> title = 'Evaluation data'
>
> form = SQLFORM.factory(
> Field('sp', label='Service Provider',
> requires = IS_IN_DB(db,db.service_provider.id, '%(name)s')),
> Field('form_id', requires = IS_IN_DB(db,db.evaluation_form.form_id)),
> Field('title',label='Title of workshop/training',
> requires = IS_IN_DB(db,db.evaluation_form.title_of_training)),
> Field('date','date',requires = IS_DATE(format=T('%Y-%m-%d'),
> error_message=T('must
> be YYYY-MM-DD!'))))
> if form.accepts(request.vars, session):
> redirect(URL(r=request, f='search_filled_in_forms',vars=request.vars))
> elif form.errors:
> response.flash = 'form has errors'
> else:
> pass
> return dict(form=form,title=title)
>
> and the following views:
>
> evaluation_data.html:
>
> {extend 'layout.html'}}
> <h2 align="center">
> {{=title}}
> </h2>
> <div class="ez-box" align="center">
>
> {{=BEAUTIFY(form)}}
> </div>f
>
> evaluation_data.csv:
> {{
> import cStringIO
> stream=cStringIO.StringIO()
> rows.export_to_csv_file(stream)
> response.headers['Content-Type']='application/vnd.ms-excel'
> response.write(stream.getvalue(), escape=False)
>
> }}
>
> and lastly
>
> search_filled_in_forms.html:
>
> {{extend 'layout.html'}}
> <h1 align='center'>Evaluation forms </h1>
>
> {{=BEAUTIFY(rows)}}
>
> <a href="evaluation_data.csv">Download as csv-file</a>
>
> But in this case evaluation_data.csv does receive "rows". And I am
> not sure how to build the url in the line above.
>
> Regards
> Johann
>
> --
> "Finally, brethren, whatsoever things are true, whatsoever things are
> honest, whatsoever things are just, whatsoever things are pure,
> whatsoever things are lovely, whatsoever things are of good report; if
> there be any virtue, and if there be any praise, think on these
> things." Philippians 4:8
