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.