Re: [baseballonastic:discussion] Problem with gid_2013_05_07_indaaa_swbaaa_1

[Brian L Cartwright]

if you have height defined as an integer in your database it will reject a blank or null value as non-numeric. It's best to keep the fields for the downloaded data varchar as much as possible, to avoid these kind of download errors. The fields can be converted to numbers later when building a warehouse from the downloaded data.

Brian

 

 

On 07/17/14, Michael Thain<mikethain@users.sf.net> wrote:

 

It just says KeyError: 'height'. I looked at every batter and pitcher and they all have valid heights except the last batter on the list who has some blank fields. Is height a required field and the blank is an error?

INFO 2014-07-16 21:42:20,513 log.init.23
Logging to c:\temp\bbosPlayerBio.py.log
INFO 2014-07-16 21:42:20,513 loggingSetup.initializeLogging.7
INFO 2014-07-16 21:42:20,513 loggingSetup.initializeLogging.8 Starting bbos!
INFO 2014-07-16 21:42:20,622 bbosPlayerBio.main.27 Starting bbosPlayerBio!
INFO 2014-07-16 23:54:28,147 bbosPlayerBio.main.57 loading:gid_2013_05_07_indaaa_swbaaa_1
ERROR 2014-07-16 23:54:40,951 bbosPlayerBio.main.64 Died with Exception:
ERROR 2014-07-16 23:54:40,951 bbosPlayerBio.main.65 'height'
Traceback (most recent call last):
File "C:\Users\Mike\workspace\BBOS\src\bbosPlayerBio.py", line 69, in <module>
main()
File "C:\Users\Mike\workspace\BBOS\src\bbosPlayerBio.py", line 66, in main
raise e
KeyError: 'height'

---

Problem with gid_2013_05_07_indaaa_swbaaa_1

---

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/baseballonastic/discussion/820145/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

[Michael Thain]

It was Char(1) for feet and Char(2) for inches. I changed it to Varchar(4) for both. But when I tried to run playerbios again it gave me the same error.

[Michael Thain]

Has anyone else been able to get the aaa 2013 playerbios to import? This is a fatal error that ends the script so I can't import any player bios after May 7. I don't even care if I lose one day of bios but I don't want to lose the whole season. Is there an easy workaround to skip this game?