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