web2py follows standards....a CSV is a Comma Separated Value file, that by 
default are separated by a comma: your's is with semicolons, so I'd advise 
parsing it with csv.reader (fiddling with separator and quotechar) and then 
make your own import algo (once parsed, it's just a loop iterating inserts)
http://docs.python.org/2/library/csv.html

On Tuesday, December 24, 2013 4:20:39 PM UTC+1, Gael Princivalle wrote:
>
> Hi all.
>
> I have to import a lot of CSV files that have fields separated by ";".
> In web2py it seems that only "," is accepted.
>
> How can I upload a file and replace all ";" by "," ?
>
> I've tried like that with replace but this attribute is not valid:
>     form = SQLFORM.factory(
>         Field('table',requires=IS_IN_SET(db.tables)),
>         Field('csvfile','upload',uploadfield=False))
>     form.process()
>     if form.accepted:
>         table = form.vars.table
>         csvfile = request.vars.csvfile.file
>         csvfile = csvfile.replace(';',',')
>         db[table].import_from_csv_file(csvfile)
>
> Someone have a suggestion ?
>
> Best regards.
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
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.

Reply via email to