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