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.


Reply via email to