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.
