My bad.
db[form.vars.table].import_from_csv_file(request.vars.csvfile)
should be
db[form.vars.table].import_from_csv_file(request.vars.csvfile.file)
On Sunday, 29 July 2012 10:32:29 UTC-5, Alec Taylor wrote:
>
> On Mon, Jul 30, 2012 at 12:11 AM, Massimo Di Pierro <
> massimo.dipie...@gmail.com> 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 <
>>> 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,
>>>>>
>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>
>>
>>
>>
>
>
--
