I have opened ticket 1368: http://code.google.com/p/web2py/issues/detail?id=1368
In the meantime, do you have any suggestions for how to proceed? I'm considering putting the statement in a controller and triggering it from the web so I get a ticket with a stack trace and more info about the data being processed at that time. Does web2py use the logging framework at all? >From what I can see in dal.py, it doesn't appear to be. Thanks, Shawn On Thursday, March 7, 2013 12:42:27 PM UTC-5, Massimo Di Pierro wrote: > > Please open a ticket asking for better info on failed import. > > On Wednesday, 6 March 2013 22:58:47 UTC-6, Shawn Wheatley wrote: >> >> 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.