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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.