Baseball On A Stick Activity
Brought to you by:
willkoky
Activity for Baseball On A Stick
-
Michael Thain posted a comment on discussion Help
I have looked over the statsapi python package, which is supposed to pull data from the new MLB API. However, it doesn't pull game data, only things like leaderboards and box scores. I would really like to have something like BBOS, to simply translate that API into MySQL. I asked around and searched everywhere, and it doesn't seem to exist. And I actually tried to build something myself. I got as far as getting the JSON text into a program but I just don't have coding skills to parse it. There were...
-
Baseball On A Stick released /temp/Canada074.jpg
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Brian L Cartwright posted a comment on discussion Help
Word from MLB was that the dware would be discontinued once all teams moved to the new api, and the dware folder was removed in late November. They will no longer be including Diamond Ware (Gameday) play strings as data recording is now done by touch screen. "Not supported" means that these gameday files that BBOS scrapes will not be upgraded. They may go away at some point but I'm not aware of any impending moves. All the data for each game is now in a single json file, publicly accessible at the...
-
Deez Nutz posted a comment on discussion Help
if gd2 is retired then BBOS should be officially closed. and, if it will not load all games there is no time to fix it anymore unless someone else would like to take over. however, I still see data https://gd2.mlb.com/components/game/mlb/year_2019/month_09/day_28/gid_2019_09_28_atlmlb_nynmlb_1/inning/inning_1.xml remember that if you navigate to https://gd2.mlb.com/components/game/mlb/year_2019/month_09/day_28 you will get data but this, with the / at the end, will not https://gd2.mlb.com/components/game/mlb/year_2019/month_09/day_28/...
-
Sorry if I'm beind the times... I haven't attempted to use BBOS in a few years and so I went poking around the gd2 gameday links and they have a message saying those pages are no longer supported and they are now using something called the "MLB Stats API". It has a link to that, but it asks me for a login and password. So I'm confused. Are we supposed to start pointing to a new API and who do we get login credentials from? Will the newest version of BBOS fetch from the new API or is it still pointing...
-
Ryan Smiley modified a comment on discussion Help
UPDATE: Fixed. didn't realize I was using an older version. Works now. Is anyone else stilling having issues with 2019....
-
Is anyone else stilling having issues with 2019.... C:\Users\smiley\Desktop\Baseball\BBOS6\src>bbos.py mlb -y 2019 INFO 2019-07-09 20:19:20,538 MainThread log.init.23 Logging to c:\temp\bbos.py.log INFO 2019-07-09 20:19:20,538 MainThread loggingSetup.initializeLogging.7 INFO 2019-07-09 20:19:20,538 MainThread loggingSetup.initializeLogging.8 Starting bbos! INFO 2019-07-09 20:19:20,663 MainThread bbos.main.19 Starting bbos! INFO 2019-07-09 20:38:05,198 MainThread bbos.main.43 Distributing 1843 urls...
-
Mark O'L posted a comment on discussion Help
Thanks man, it's working again. Sorry for the late reply, this is the first chance I got to try this out. I wanted to let you know that I appreciate your work! Cheers, Mark
-
6.7.1
-
Ok, all the issues I could find with uploading 2019 have been fixed as well as anything I could find that erred for 2018. 2018 has games that are missing the game_pk also. Mostly spring games. Those should now load as well if you grab version 6.7.1. There was also an issue that Python's urllib class starting taking forwever to download a single files. I had to swap out the use of that library for urllib2. This seems to work but I have only run it against 2019 and 18 as mentioned. Let me know if you...
-
-
I don't believe mlbam had a game_pk field in the early years. I'd suggest testing whether each of the keys exists in the downloaded data before trying to reference it. Brian -----Original Message----- From: Deez Nutz willkoky@users.sourceforge.net To: 820145 820145@discussion.baseballonastic.p.re.sourceforge.net Sent: Wed, Mar 13, 2019 3:58 pm Subject: [baseballonastic:discussion] Re: Error Loading 2019 Games I did get the same error on 2019. no timeline to fix it though. April I hope...?On Wed,...
-
I did get the same error on 2019. no timeline to fix it though. April I hope...? On Wed, Mar 13, 2019 at 7:34 AM Addison addy@users.sourceforge.net wrote: same error for me. also, the 2007 and earlier games seem to have an issue with the park attributes which prevents loading any games at all. i've dug into the code a bit but still cannot resolve - has anyone else been successful fixing this bug? Attachments: bbos_gamepk_error.PNG https://sourceforge.net/p/baseballonastic/discussion/820145/thread/3005a7284e/f9dd/attachment/bbos_gamepk_error.PNG...
-
Addison posted a comment on discussion Help
same error for me. also, the 2007 and earlier games seem to have an issue with the park attributes which prevents loading any games at all. i've dug into the code a bit but still cannot resolve - has anyone else been successful fixing this bug?
-
I do plan on loading data from 2019 in the coming weeks but I have not yet. I'll see if i get an error at that time also On Sun, Mar 3, 2019 at 9:37 PM Mark O'L phunpolo@users.sourceforge.net wrote: Hi folks, Seeing the following error while trying to load 2019 games. Is anyone else dealing with this? ERROR 2019-03-03 23:18:16,392 Thread-6 bbos.consume.83 Died with Exception: Exception in thread Thread-6: Traceback (most recent call last): File "C:\Python27\lib\threading.py", line 801, in bootstrap_inner...
-
Hi folks, Seeing the following error while trying to load 2019 games. Is anyone else dealing with this? ERROR 2019-03-03 23:18:16,392 Thread-6 bbos.consume.83 Died with Exception: Exception in thread Thread-6: Traceback (most recent call last): File "C:\Python27\lib\threading.py", line 801, in __bootstrap_inner self.run() File "C:\mark\mlb\BBOS6.6.2\src\threadit\threadIt.py", line 25, in run self.worker.consume(item) File "C:\mark\mlb\BBOS6.6.2\src\bbos.py", line 79, in consume gameLoader.loadGame()...
-
Colin posted a comment on discussion Help
Resolved. I downloaded bitnamp and install myphpadmin with '330X' port. And changed ID/PW/Port/mysql location in 'bbosconfig' file. it almost took two days to set up gameday and retrosheet schema. Excited to store data in DB ! thanks for great resource! :-)
-
Hello All, Thank you for the great resourse and help When I try to run “createGamedaySchema.py”, I got the below error. Please give me your insight to resolve it! C:\BBOS\src>createGamedaySchema.py INFO 2018-10-29 02:07:30,243 MainThread log.init.23 Logging to c:\temp\createBBOS.py.log INFO 2018-10-29 02:07:30,243 MainThread loggingsetup.initializeLogging.7 INFO 2018-10-29 02:07:30,244 MainThread loggingsetup.initializeLogging.8 Starting bbos! INFO 2018-10-29 02:07:30,303 MainThread creategamedayschema.<module>.25...
-
Erin Bristow posted a comment on discussion Help
Thank you! I appreciate it, sorry about the late response :)
-
In this example, I filtered by gamename, but you can by pitcher as well The duplicates were coming from incomplete parameters in the table joins. I've rearranged the order so that atbats is the primary table being scanned and filtered, while pitches and players are then reference files. Pitches needs both gamename and gameatbatid. Players needs both gamename and (player) id SELECT ab.pitcher, concat(r.last,", ",r.first) as name, ab.gameName, p.gameatbatid, p.pitch_type, p.ID, p.spin_rate, p.start_speed,...
-
it is hard using the gameday data as is. it will also include spring and post season if you loaded those games. but i believe what you have is the general idea. this is why the "normalize" sql script is there. it makes nice relational tables out of the data. you could try running that and then query the "mlb" schema it creates. it basically makes a whole new nicer database and cleans up lots of junk data. if you want to use the gameday schema as is then the sql in the normalize.sql can help you see...
-
Been trying to figure this one out for a little while. This query sort of works but not really- I get about a third of the pitches from a certain pitcher and the rest are duplicates. Does anyone have a script that works for them? SELECT t1.first, t1.last, t3.spin_rate, t3.start_speed, t3.end_speed, t3.pitch_type, t3.gamedayPitchID, t3.pfx_z, t3.gameName, t1.id, t2.pitcher, t2.gameName, t2.num, t3.gameAtBatID FROM gameday.players t1, gameday.atbats t2, gameday.pitches t3 WHERE t1.id = t2.pitcher AND...
-
Steven J Tighe posted a comment on discussion Help
I think that fixed it. I followed the guidance here: https://stackoverflow.com/questions/36647058/removing-duplicates-with-unique-index Replaced this around line 125 ALTER IGNORE TABLE mlb.tGames ADD UNIQUE INDEX idx_temp (gameName); with CREATE TABLE mlb.tGames_t SELECT * FROM mlb.tGames; TRUNCATE TABLE mlb.tGames; ALTER TABLE mlb.tGames ADD UNIQUE INDEX idx_temp (GameName); INSERT IGNORE INTO mlb.tGames SELECT * FROM mlb.tGames_t; DROP TABLE mlb.tGames_t; and around line 200 ALTER IGNORE TABLE...
-
Here's the answer: https://dba.stackexchange.com/questions/143862/mysql-alter-ignore-add-index-removed-in-mysql-5-7-4-what-to-use-instead The IGNORE clause for ALTER TABLE ( http://dev.mysql.com/doc/refman/5.6/en/alter-table.html ) is now deprecated and will be removed in a future version of MySQL. ALTER IGNORE TABLE causes problems for replication, prevents online ALTER TABLE for unique index creation, and causes problems with foreign keys (rows removed in the parent table). I'm using 5.7.20. I'll...
-
So I ran the sql script again today and had a LOT more luck, though not complete success. I wonder if there was some data that just didn't get picked up out of gameday the first couple times I ran the bbos.py script? At the moment, as best I can tell, here are what appear to be the "permanent" tables (i.e. not like mlb.tpitches or something) that the script doesn't put in the database: pitches hits atbats atbatresults pitchlocation pitchresult batterhand Also the four temp tables t<base>Umps are...
-
each db statement relies on the previous succeeding. so what is the first statement that throws an actual error (non-group by/table does not exist) and what is that error? also watch out for those lines that say 0 rows effected. that could mean a query that is supposed to find some data didn't and that the gameday data didn't actually all load On Mon, May 21, 2018 at 12:22 AM, Steven J Tighe resumeman@users.sourceforge.net wrote: So for the record I found the "group by" error - the server was set...
-
So for the record I fixed the "group by" error - the server was set to have very strict group-by restrictions. I reset the default: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Not sure about the syntax errors tho.
-
So for the record I found the "group by" error - the server was set to have very strict group-by restrictions. I reset the default: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Not sure about the syntax errors tho.
-
Ah ok, thanks. I didn't realize that I should expect those "table does not exist" errors as normal. The other errors look like "ERROR 1055 (42000): Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tmp.abbreviation' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" and "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version...
-
i think your best bet it to run it by hand. you can make it work but it requires changing coding. the table does not exist error is normal, because it deletes each table and then creates it. so if the script has yet to work it will always give those errors. i think you want to look for the errors it is giving that are not "table doesn't exist" cause if you only have two tables then it went wrong at some point. you could also pick apart the file and run one part at a time to make sure each part works...
-
I'm just getting BBOS set up now. This is great, and is exactly what I was looking for (Baseball Hacks had a script to do this but I couldn't get it to work). I am running this on Ubuntu. I'm generally a MySQL noob and even less than a noob in Python. I was able to work around a few things to get things installed and import Gameday data using BBOS. I'm running into a problem running the NormalizeIntoMLB script, which I think is related to the fact that the script thinks I'm in Windows. In the bbos...
-
Nate Walker posted a comment on discussion Help
Hi! Big fan of the BBOS software! I was hoping someone could help me with the Retro downloads. Every time I run the \retrosheet.py command the code executes, however, it fails to unzip the files and load the data into MySQL. When I check the command shell, it looks like the code gets to the 7ZIPController thread where it establishes a file for the zipped CSV, but in the next line the code says "The system cannot find the path specified." Does anyone know why this occurs or how to fix it? Thanks in...
-
Derek Carty posted a comment on discussion Help
Okay, thanks! So here's what I get when I try "-r" C:\Scripts\bbos6.6.2\src>bbos.py -r INFO 2018-04-19 22:37:44,986 MainThread log.init.23 Logging to c:\temp\bbos.py.log INFO 2018-04-19 22:37:44,987 MainThread loggingSetup.initializeLogging.7 INFO 2018-04-19 22:37:44,989 MainThread loggingSetup.initializeLogging.8 Starting bbos! INFO 2018-04-19 22:37:45,099 MainThread bbos.main.19 Starting bbos! DEBUG 2018-04-19 22:37:45,099 MainThread bbos.main.26 startup options:{'league': 'mlb', 'month': None,...
-
there is a file called bbosConfig.py. please open it with notepad or another text editor. it contains a line that has the word INFO in it. change that to DEBUG please. save the file then rerun and we will see what it is doing more closely. thank you On Thu, Apr 19, 2018 at 1:23 PM, Derek Carty dcbb14@users.sourceforge.net wrote: Yup, 2/24 is the last date I get data for as well pitchfx data seems to be unavailable https://sourceforge.net/p/baseballonastic/discussion/820145/thread/d67e82ee/?limit=25&page=2#d737/c493/14f4/dfc7/afb9/5358/3721...
-
Yup, 2/24 is the last date I get data for as well
-
Thomas White posted a comment on discussion Help
I'm experiencing the same thing, playerBios seems to load data through about 2/24 then it stops loading, although it looks like it works for all dates up to the current date
-
Oh, also, "-r" still doesn't appear to work :\
-
Awesome, I installed the new version and minor league data appears to be working great now. The playerbios thing is still a problem, though. I run it, it appears to work, but nothing gets loaded. I run it a few seconds later, it appears to reload the same data again, but nothing gets loaded. Any idea what could cause this? (not sure what you meant by changing INFO to DEBUG and if that would help here or not) Thanks! C:\Scripts\bbos6.6.2\src>bbosPlayerBio.py -d (2018,4,15) INFO 2018-04-19 00:52:27,489...
-
boxscores - putting records into batters and pitchers If you don't want to bother with this it's OK. I was using an older version and this week wrote my own scraper instead. Brian -----Original Message----- From: Deez Nutz willkoky@users.sourceforge.net To: [baseballonastic:discussion] 820145@discussion.baseballonastic.p.re.sourceforge.net Sent: Tue, Apr 17, 2018 2:27 am Subject: [baseballonastic:discussion] Re: pitchfx data seems to be unavailable what table are you referring to in 2)? I think you've...
-
i tried a month of bios and it was working. i also tried the minors and it was working. so, can you grab the latest version 6.6.2 i just posted to ensure we have the same stuff. then when you run first please go to bbosConfig.py and change INFO to DEBUG. this will make a lot more stuff print to the screen. you will be able to see more if it is hung or just chugging away at something. then try the -d or -m month option please so it isnt trying to chug through a year before it loads anything. then...
-
what table are you referring to in 2)? I think you've explained this before but a long time ago. gameday marks the home and away teams so im not sure what the numbering is for. 3) it does not use inning_all and never has. it uses the individual inning files because the inning_all didn't used to exist I believe. i also believe they have the exact same stuff or did in the past. i tried a sample day and I got rows in my feedplays table and actions. "Pitching Change: Pedro Baez replaces Clayton Kershaw,...
-
6.6.2
-
-
gave all options to bios also
-
gave bios same url opions
-
added by month option
-
removed some bad defaults
-
added some spring tables
-
Geoff Messier posted a comment on discussion Help
This is an old thread but I recently downloaded 6.6.1 and found this issue still exists with MySQL 5.7. The fix suggested above works but here's the patch if folks are looking for the details. --- /Users/gmessier/Downloads/BBOS6.6.1 2/sql/createGamedaySchema.sql 2018-02-24 11:16:10.000000000 -0700 +++ createGamedaySchema.sql 2018-04-16 19:27:03.000000000 -0600 @@ -29,7 +29,7 @@ DROP TABLE IF EXISTS hits; CREATE TABLE hits ( - hitID mediumint(8) DEFAULT NULL AUTO_INCREMENT, + hitID mediumint(8) NOT...
-
Hey! Just wanted to check back in and see if you've been able to make any progress here. I know you're busy, so I hate to bring it up, but I just noticed another issue :\ When I try to load player bios (bbosPlayerBio.py -y 2018), it acts as if it's loading them, but nothing actually seems to get added to the table. If I run it again, it will once again act as if it's loading the same set of games (i.e. it doesn't give the "game already loaded" spiel) but still adds nothing to the table. Thanks!
-
1) We had the issue with the folder names. I downloaded 6.6 and copied directorystructure.py into the folder for the older version I'm running. It didn't download any games using 'recent' but did when getting the whole year 2) There's one main reason I'm still using the old version. When downloading the boxscores BBOS doesn't assign a record ID number. When I process the data it must be in the correct order to determine away & home teams (when BO resets to 1, it's the home team) Multithreading the...
-
No worries at all, I understand you have other responsibilities. I appreciate all the help. I'll keep checking back for an update.
-
First, thank you for the donation! Second, I will look into it. I did fix -r also but have not published it yet. Its a busy week in my real job unfortunately. Sorry to make you wait. the JSON data is where the speed off the bat and distance stuff comes from. if there is none for a particular game it is supposed to ignore it. apparently it is not. On Wed, Apr 4, 2018 at 9:37 PM, Derek Carty dcbb14@users.sourceforge.net wrote: Hey DeezNuts, was hoping you might have a suggestion for why I'm getting...
-
Hey DeezNuts, was hoping you might have a suggestion for why I'm getting the "ValueError: No JSON object could be decoded" for minor league games ^. Any help would be very much appreciated. Thanks!
-
So major league games are working perfectly now, but it seems like minor league games are creating issues. Any idea why this could be? Thanks! C:\Scripts\bbos6.6.1\src>bbos.py aaa -y 2018 INFO 2018-04-01 02:30:51,203 MainThread log.init.23 Logging to c:\temp\bbos.py.log INFO 2018-04-01 02:30:51,203 MainThread loggingSetup.initializeLogging.7 INFO 2018-04-01 02:30:51,203 MainThread loggingSetup.initializeLogging.8 Startin g bbos! INFO 2018-04-01 02:30:51,266 MainThread bbos.main.19 Starting bbos!...
-
So major league games are working perfectly now, but it seems like minor league games are creating issues. Any idea why this could be? Thanks! ERROR 2018-04-01 02:31:07,594 Thread-1 bbos.consume.79 Died with Exception: ERROR 2018-04-01 02:31:07,671 Thread-5 bbos.consume.79 Died with Exception: Exception in thread Thread-1: Traceback (most recent call last): File "C:\Python27\lib\threading.py", line 801, in __bootstrap_inner self.run() File "C:\Scripts\bbos6.6.1\src\threadit\threadIt.py", line 25,...
-
Awesome, it looks like I have it working. You're the best, thank you so much for the great support.
-
i think you do not have the latest changes to the database. basically you would have to go through the createGameday.sql file and find the columns that have been added or expanded so they do not fail and either add them to your DB or alter them to be larger. personally i always just start with a fresh database by running createGameday.sql. it takes days to reload the db if you want past years, but its the computer's time for the most part, not yours. alternatively you can go in gamedayConfig.py and...
-
Thanks so much for the quick reply, I really appreciate all the help. So I'm using 6.6.1 now and using -y 2018 instead of -r ... it looks like it loaded a couple games but is finding errors with most of them C:\Scripts\bbos6.6.1\src>bbos.py -y 2018 INFO 2018-03-30 23:02:23,384 MainThread log.init.23 Logging to c:\temp\bbos.py.log INFO 2018-03-30 23:02:23,384 MainThread loggingSetup.initializeLogging.7 INFO 2018-03-30 23:02:23,384 MainThread loggingSetup.initializeLogging.8 Starting bbos! INFO 2018-03-30...
-
there is a 6.6.1 cause when I tried 6.6 on 2018 it had a blank field it wouldnt load in one game. however, your issue is that it did not find games. i tried it, doesn't work for me either. I would say that -r does not work currently. and i would guess it is because of the bug that started this thread with the / needing to be not there now. but i am leaving for the weekend. so i will fix next week. for now I would just do bbos.py -y 2018. it will take longer cause it will check every day of the year,...
-
I just tried to download data for yesterday's games, but it didn't seem to work. C:\Scripts\bbos6.6\src>bbos.py -r INFO 2018-03-30 14:23:25,390 MainThread log.init.23 Logging to c:\temp\bbos.py.log INFO 2018-03-30 14:23:25,390 MainThread loggingSetup.initializeLogging.7 INFO 2018-03-30 14:23:25,390 MainThread loggingSetup.initializeLogging.8 Starting bbos! INFO 2018-03-30 14:23:25,608 MainThread bbos.main.19 Starting bbos! INFO 2018-03-30 14:23:25,750 MainThread bbos.main.39 Distributing 0 urls to...
-
i don't personally use those values so maybe someone else has more information, but I don't believe they are present in the data, and that is why there are no values. I picked a random game from last year and you can see there is a break y for each pitch but no X and Z in the data. http://gd2.mlb.com/components/game/mlb/year_2017/month_07/day_14/gid_2017_07_14_phimlb_milmlb_1/inning/inning_4.xml On Thu, Mar 29, 2018 at 11:26 PM, Erin Bristow baseballgal@users.sourceforge.net wrote: It's working!...
-
It's working! Yay! But all the values for break_z and break_x are missing. Are those supposed to be there? Also, some of the games in the games table are clearly missing. What do I do when there are missing values/rows in the tables?
-
well if you run createGameday.sql it will delete the entire database and create a blank one. so you could do that and then download 2017 again. On Thu, Mar 29, 2018 at 6:08 PM, Erin Bristow baseballgal@users.sourceforge.net wrote: Thanks for putting together a new version of this! I have all of 2017 in my DB, but I downloaded files that someone else exported for me (because of the links issue) and there's errors in the data, so I definitely need to start fresh. You said that it's as simple as deleting...
-
I have different versions in different folders and run a batch file that points to the one I want to use Brian -----Original Message----- From: Erin Bristow baseballgal@users.sourceforge.net To: [baseballonastic:discussion] 820145@discussion.baseballonastic.p.re.sourceforge.net Sent: Thu, Mar 29, 2018 7:08 pm Subject: [baseballonastic:discussion] pitchfx data seems to be unavailable Thanks for putting together a new version of this! I have all of 2017 in my DB, but I downloaded files that someone...
-
Thanks for putting together a new version of this! I have all of 2017 in my DB, but I downloaded files that someone else exported for me (because of the links issue) and there's errors in the data, so I definitely need to start fresh. You said that it's as simple as deleting all of the old BBOS files and replacing them with the new ones. Does that mean I need to go through the whole installation process again? Thanks
-
Lon C. Thomas, Jr. posted a comment on discussion Help
Wild guess, but that last text "... has no attribute 'statsapiURL' is easy to fix. May be other problems as well, though. Check your file ..\bbos\src\bbos\config.py, first few lines class BBOSConfig: #Gameday gamedayURL = 'http://gd.mlb.com/components/game/' statsapiURL = 'http://statsapi.mlb.com/api/v1/game/' gamedayDaysBackToLoad = 2
-
6.6.1
-
-
bug for no position and a coupld fantasy baseball tables
-
im through march and on to april loading the 2016 bios and am not having an issue. the error you have is saying it can't find a setting in the BBOSConfig.py file. is yours missing a line somehow? it should look like this import logging import osandio.fileUtils import os from osandio._7ZipController import _7ZipController class BBOSConfig: #Gameday gamedayURL = 'http://gd2.mlb.com/components/game/' statsapiURL = 'http://statsapi.mlb.com/api/v1/game/' gamedayDaysBackToLoad = 2 dbUser = 'bbos' dbPass...
-
Quinn Coldiron posted a comment on discussion Help
Downloaded 6.6 and did the recommended changes to bbosPlayerBio.py and I tried changing the unsigned on the schema, and making a new schema. I'm trying to load 2016 data, but keep getting these errors: python ./bbos.py --year=2016 INFO 2018-03-23 15:19:40,673 MainThread log.init.23 Logging to /tmp/bbos.py.log INFO 2018-03-23 15:19:40,674 MainThread loggingSetup.initializeLogging.7 INFO 2018-03-23 15:19:40,675 MainThread loggingSetup.initializeLogging.8 Starting bbos! INFO 2018-03-23 15:19:41,047...
-
removed all years option that should not be used and was broken
-
It's working now. Thanks so much for your help! Much appreciated :)
-
remove this from bbosPlayerBio.py elif options.all != None: gamedayGameURLs = gamedayDirectory.getGameURLsForAllAvailable() it is a relic of loading all years at once. you were probably using -y before and so never ran into the issue. On Mon, Feb 26, 2018 at 11:08 PM, Derek Carty dcbb14@users.sourceforge.net wrote: Thanks! I want to keep my old databases and just use the updated scripts to continue adding new data to them. I didn't download data to the playerbios table for 2017 yet, though, so I'm...
-
Thanks! I want to keep my old databases and just use the updated scripts to continue adding new data to them. I didn't download data to the playerbios table for 2017 yet, though, so I'm trying to do that now and keep getting an error. I think I've done everything correctly to set up the new version, but maybe I'm missing something. I removed "unsigned" from each column in each table that had it I updated src/bbos/config/bbosConfig.py with my MySQL database info I changed the paths I reference in...
-
it depends on if you want to keep the data in your gameday database or replace it with new stuff. also I would be careful with deleting anything without a backup as I have not had time to run it against older years yet. if you are keeping your old DB intact then you need to know the database changes that were needed. i removed UNSIGNED from every database column that had it. but you probably only need to remove it from the columns on the pitches table. apparently there are now negative values for...
-
-
Thanks for putting together a new version of this, I was wondering what was going on today when I was getting error messages. What's the best way to install the new version? Is it as simple as just deleting the old files and replacing them with the new ones? Thanks!
-
Thanks for putting together a new version of this, I was wondering what was going on today when I was getting error messages. What's the best way to install the new version? Is it as simple as just deleting the old files and replacing them with the new ones? Thanks!
-
Thanks for putting together a new version of this, I started freaking out today when I was getting error messages. What's the best way to install the new version? Is it as simple as just deleting the old files and replacing them with the new ones? Thanks!
-
updated for null pitch type and new year
-
removed cvs dirs
-
new version posted. sourceforge was having issues today but it seems back online now. On Sat, Feb 24, 2018 at 11:20 AM, Deez Nutz willkoky@users.sourceforge.net wrote: I think I have it working for all of 2017 mlb now. I will put out a new version hopefully later today. There wasn't just one thing that changed. aside form the directory structure several new data values were too long or needed massaging within the 2017 data. thanks On Wed, Feb 14, 2018 at 9:00 AM, Beth Woerner woerneea@users.sourceforge.net...
-
-
added pycs
1 >
