On Mon, Jul 30, 2012 at 12:11 AM, Massimo Di Pierro <
[email protected]> wrote:
> 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)
>
I tried that on Windows, and the upload field gave an open command, so I
right-clicked "New File->New Text Document" and create "foo.csv".
Selecting it then clicking open then clicking "Submit" gave me the "invalid
file" error.
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 <
>> [email protected]> 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,
>>>>
>>> --
>>>
>>>
>>>
>>>
>>
>> --
>
>
>
>
--
