Ahh. Works wonderful now. Thanks
On Wednesday, January 30, 2013 5:02:16 PM UTC-8, Massimo Di Pierro wrote:
>
> I think
>
> 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 Wednesday, 30 January 2013 14:29:08 UTC-6, Jack wrote:
>>
>> Hi all,
>>
>> I've recently started playing around with web2py and i have encountered a
>> problem with the csv importing function.
>> I have a table defined called 'production' and i have already implemetned
>> a smartgrid that will allow me to view,edit each row in the table.
>> However, I want to implement a function for the users much like the one
>> in appadmin where I can upload a csv file and have its data appended to the
>> existing table. If someone can tell me how to do it or show me a direction
>> as to where to start it'd be much appreciated.
>>
>> EDIT:
>> I found a block of code while browsing the forums:
>>
>> 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)
>>
>> but I get an error saying invalid file when I try to upload.
>>
>>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
