Historical MLB/Minors roster and db issues go here

[Spritze]

Some of these MLB ID's do not exist? clarkbi02 as an example.

[Spritze]

Originally Posted by Hoiles

There are two Scott Stricklands (early 00's Expos-Mets reliever). His historical/Lahman ID is stricsc02, which is weird because there's noone with ID stricsc01 (on baseball reference at least).

Fixed

[Ravi]

Originally Posted by Spritze

Some of these MLB ID's do not exist? clarkbi02 as an example.

That is what I am getting from Bbref. See here: Bill Clarkson Statistics and History | Baseball-Reference.com

But I'll try to be more specific.
1) Stan Gray has an incorrect Minors ID in game, it should be changed to gray--001sta. This is causing him to act as a clone of Sam Gray
2) Sam Gray has the wrong MLB ID in game, it should be graysa01
3) Win Clark has the wrong minors ID in game. It should be clark-012wil . He shouldn't populate the Galveston Sand Crabs in 1923.
4) For Bill Clarkson, I get a BBRef ID Of clarkbi02. His minors ID is correct in game.

[Spritze]

1 and 2 done
3 it is clark-012wil already
4 no clarkbi02 in the MLB database

[Ravi]

Two screenshots of what I see in game

[Spritze]

Originally Posted by Ravi

Two screenshots of what I see in game

fixed

[Ravi]

Originally Posted by Spritze

fixed

Awesome, thanks for solving it. To be honest, I'm not sure if I should be posting the lahman MLB IDs or BBref. Digging around it seems that the Lahman ID for Bill Clarkson is Clarkbi01, which is the BBref ID for Win Clark. That may have caused the problem.

[Spritze]

Win Clark should have been 03

[Hoiles]

To sharpen up my dormant programming skills, I took OOTP 16's master.csv and looked for bbrefID's which skipped the "01" ending the ID. Using a 2015 historical minors import, most of these players are duplicated in a search, or only have major league stats with no attached minor stats. The * are beside players which correctly imported with both minor and major league stats and no duplicates:

Roosevelt Brown brownro02
Rafael Furcal furcara02
Gabe Gonzalez gonzaga02
Rick Greene greenri02
Willie Harris harriwi02
Rodrigo Lopez lopezro02
Brian O'Connor o'conbr02*
Ramon Ortiz ortizra02
Julio Ramirez (CF) ramirju02
Johan Santana santajo02
Steve Schrenk schrest02
Scott Strickland stricsc02
Kevin Walker walkeke02
Mark Watson watsoma03
Matt Watson watsoma02*
Luis Jimenez jimenlu02 (RP with ML batting stats, should link to minor league batting/fielding stats)
Chia-Jen Lo loch02*
Alex Wood woodal02*
Marco Gonzales gonzama02*
Rusney Castillo castiru02
Bryan Price pricebr10

[Spritze]

About half of these were correct as is. I kept the 02 designations in the MLB and changed MiLB to match.

[actionjackson]

Sir Spritze: It appears that the Neutralized Fielding Stats situation is under control in 17.7.51 (with one exception so far), but for some reason there are a bunch of players (this post will just be pitchers, starters at that) missing Neutered Batting Stats seasons that weren't missing them in 17.6.46. To wit:

- Henderson Alvarez 2011
- Brett Anderson 2010, 2012, 2013
- Dylan Axelrod 2011, 2012
- Scott T Baker 2005
- Chris Bassitt 2014
- Aaron Brooks 2014
- Clay Buchholz 2007-2009, 2011, 2013
- Mark Buehrle 2000, 2014
- Fausto Carmona 2006, 2009, 2012
- Carlos Carrasco 2009, 2010, 2013
- Jhoulys Chacin 2009
- Jesse Chavez 2008, 2011
- Bruce Chen 2004, 2007, 2014, 2015
- Wei-Yin Chen 2015
- Bartolo Colon 2009
- Jarred Cosart 2013
- John Danks 2015
- Kyle Davies 2015
- Samuel Deduno 2010-2012, 2015
- Felix Doubront 2010, 2011, 2015
- Kyle Drabek 2010, 2011, 2013-2015
- Danny Duffy 2012, 2013, 2015
- Roenis Elias 2015
- Marco Estrada 2008, 2009
- Buck Farmer 2014
- Scott Feldman 2005-2007, 2011
- Michael Fiers 2011
- Gavin Floyd 2007, 2015
- Michael Foltynewicz 2014
- Matt Garza 2006
- Kevin Gausman 2015
- Kyle Gibson 2013
- Marco Gonzales 2015
- Gio Gonzalez 2008, 2009
- Miguel A Gonzalez 2012
- Kendall Graveman 2014, 2015
- Sonny Gray 2013
- Shane Greene 2014
- Zack Greinke 2006
- Jeremy Guthrie 2004-2006
- Jason Hammel 2006, 2008
- J A Happ 2013
- Matt Harrison 2008, 2013, 2014
- Jeremy Hellickson 2010, 2014
- Felix Hernandez 2005
- Derek Holland 2010, 2011, 2014, 2015
- T J House 2015
- David Huff 2011-2013
- Phil Hughes 2007-2009, 2011
- Drew Hutchison 2015
- Hisashi Iwakuma 2012
- Erik C Johnson 2013, 2015

Also, Kendall Graveman is missing Neutered Pitching and Fielding Stats for 2014. Thank you very much for all your efforts with this. I'll keep hammering away at it, but that's all for today.

[Spritze]

The files have not changed between 46 and 51 but I'll see if I can tell what may have changed in the program.

I checked 7 of these and they are purrfect so I suspect something changed in OOTP but I have no idea what. Let me know if you get any suspicions.

These players had no AB's IRL and so have no neutered batting stats. This is by request of the powers that be.

Graveman gets dunked in 2014 by the Ted Williams formula. Fixed these by rejiggering the formula.

[swampdragon]

I do see a lot of American League pitchers on that list.

[actionjackson]

Originally Posted by swampdragon

I do see a lot of American League pitchers on that list.

That's because that's all I've been able to wade through so far.

[actionjackson]

Originally Posted by Spritze

The files have not changed between 46 and 51 but I'll see if I can tell what may have changed in the program.

I checked 7 of these and they are purrfect so I suspect something changed in OOTP but I have no idea what. Let me know if you get any suspicions.

These players had no AB's IRL and so have no neutered batting stats. This is by request of the powers that be.

Graveman gets dunked in 2014 by the Ted Williams formula. Fixed these by rejiggering the formula.

I thought the whole point of neutered stats was to fill in the gaps left by seasons without stats. Why would the powers that be not want stats for said seasons? So is that what changed between 17.6.46 and 17.7.51?

[actionjackson]

Also, a bunch of players have disappeared since 17.6.46 if you start a historical in 2015 (in order to see how current players are affected historically). 174 players to be exact. There were 1352 players in the 2015 historical I used to check for bugs in 17.6.46, and there are now 1178 players in 17.7.51. R A Dickey is one of the players missing and he pitched 200 innings in 2015, so it's not necessarily a matter of guys who didn't play in 2015 that are missing.

[actionjackson]

Originally Posted by actionjackson

Also, a bunch of players have disappeared since 17.6.46 if you start a historical in 2015 (in order to see how current players are affected historically). 174 players to be exact. There were 1352 players in the 2015 historical I used to check for bugs in 17.6.46, and there are now 1178 players in 17.7.51. R A Dickey is one of the players missing and he pitched 200 innings in 2015, so it's not necessarily a matter of guys who didn't play in 2015 that are missing.

Here are players from the AL East who have "been disappeared" since 17.6.46:

BAL: Cesar Cabral, Oliver Drake, Jason Garcia, Mychal Givens, Steve Johnson

BOS: Jonathan Aro, Heath Hembree, Dalier Hinojosa, Brian Johnson, Noe Ramirez

NYY: Andrew Bailey, Danny Burawa, Caleb Cotham, Jose De Paula, Nick Goody, Jacob Lindgren, Chris Martin, Diego Moreno, Rico Noel, James Pazos, Jose A Ramirez, Nick Rumbelow, Matt Tracy, Mason Williams

TBR: Jeff Beliveau, Andrew Bellatti, Preston Guilmet, Jake McGee, C J Riefenhauser, Enny Romero, Everett Teaford, Kirby Yates

TOR: Andrew Albers, Miguel Castro, Steve Delabar, R A Dickey, Colt Hynes, Rob Rasmussen, Marcus Stroman, Ryan Tepera

If you're counting, that's 40 so far from one division.

[Spritze]

Originally Posted by actionjackson

I thought the whole point of neutered stats was to fill in the gaps left by seasons without stats. Why would the powers that be not want stats for said seasons? So is that what changed between 17.6.46 and 17.7.51? YES

The stats are based on zero AB's and zero will always be the AB so there is no point to these zero batting records.

[Spritze]

Originally Posted by actionjackson

Here are players from the AL East who have "been disappeared" since 17.6.46:

BAL: Cesar Cabral, Oliver Drake, Jason Garcia, Mychal Givens, Steve Johnson

BOS: Jonathan Aro, Heath Hembree, Dalier Hinojosa, Brian Johnson, Noe Ramirez

NYY: Andrew Bailey, Danny Burawa, Caleb Cotham, Jose De Paula, Nick Goody, Jacob Lindgren, Chris Martin, Diego Moreno, Rico Noel, James Pazos, Jose A Ramirez, Nick Rumbelow, Matt Tracy, Mason Williams

TBR: Jeff Beliveau, Andrew Bellatti, Preston Guilmet, Jake McGee, C J Riefenhauser, Enny Romero, Everett Teaford, Kirby Yates

TOR: Andrew Albers, Miguel Castro, Steve Delabar, R A Dickey, Colt Hynes, Rob Rasmussen, Marcus Stroman, Ryan Tepera

If you're counting, that's 40 so far from one division.

Fixed when I rejiggered the Ted Williams formula to take account of Pitchers who never batted while still dumping batters who pitched very little while keeping batters who really were 2-way players or switched to or from being a pitcher

[actionjackson]

Originally Posted by Spritze

Fixed when I rejiggered the Ted Williams formula to take account of Pitchers who never batted while still dumping batters who pitched very little while keeping batters who really were 2-way players or switched to or from being a pitcher

How did R A Dickey get lumped in there then? Or Rico Noel who was an utility player (DH/RF) for the Yankees in 2015? Or Mason Williams (CF) for the Yankees in 2015?