Hi All, I've been trying to track down an issue importing data from a legacy application I'm converting over to web2py. I have exported the data as described in the documentation (Table Foo, header line, data, 2 rows in-between, END at the end) but I'm getting this traceback when trying to import:
web2py Shell (2, 4, 2, 'stable', datetime.datetime(2013, 3, 4, 3, 26, 21))In [1] : db.import_from_csv_file(open('testout.csv', 'rb')) Traceback (most recent call last): File "/home/mdipierro/make_web2py/web2py/gluon/contrib/shell.py", line 234, in run File "<string>", line 1, in <module> File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 7936, in import_from_csv_file File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 8596, in import_from_csv_file File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 8568, in fix ValueError: invalid literal for int() with base 10: '' Unfortunately, the exception does tell me which line the import bailed on, so I can't tell where to start looking for bad data. I'm currently running this through the shell. Would I be better off putting this in a controller so I could get better traceback information from a ticket? Thanks, Shawn -- --- 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.