Sorry. My advice was about downloading all tabes at once. If you want import one table you could do:
def import_table(): form = SQLFORM.factory(Field('table',requires=IS_IN_SET(db.tables)), Field('csvfile','upload',uploadfield=False)) form.process() if form.accepted: try: db[form.vars.table].import_from_csv_file(request.vars.csvfile) except: form.errors.csvfile = 'invalid file' return dict(form=form) On Sunday, 29 July 2012 07:18:02 UTC-5, Hassan Alnatour wrote: > > Thank you a lot massimo but what is tempfile and how can i give it > a certain table to import ?? > > > Best Regards, > > > On Sun, Jul 29, 2012 at 5:14 AM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> In view: >> <a href="{{=URL('download_all')}}">download all</a> >> >> In controller >> >> def download_all(): >> import tempfile >> tmp = tempfile.TemporaryFile() >> db.export_to_csv_file(tmp) >> tmp.seek(0) >> return response.stream(tmp) >> >> On Sunday, 29 July 2012 03:07:40 UTC-5, Hassan Alnatour wrote: >>> >>> Dear ALL, >>> >>> How can i make a button that lets the user download a scv file for on of >>> my tables ? >>> >>> >>> best regards, >>> >> -- >> >> >> >> > > --