Historical MLB/Minors roster and db issues go here

[actionjackson]

Spritze: 17.6.46 looks really good so far. When playing a 2015 historical with neutered stats, players are now importing to their correct teams, so kudos to whoever got that fixed. Also, the innings played in neutered stats have been patched up for fielders, so thanks for that as well.

Just saw Will Harris in there, but unfortunately he's followed by his evil twin Willie Harris. Will has played as a RP from 2012-2016. Willie played from 2001-2012 and was an OF/PH/2B, but he's showing up in 2015 as a reliever with Will's pitching stats so he needs to be shown the door as it were. I'll let you know if I see anymore, but so far we're off to a really good start. Thank you.

EDIT: Noticed that Will Harris has Willie Harris' Neutralized Batting and Fielding Stats (2001-2012) as well as his own neutered batting and fielding stats if that helps, and Will Harris has no Neutralized Pitching Stats or Fielding Stats for 2015.

[actionjackson]

Jeff Williams (willije02) is a pitcher in 2015 historical, but he only pitched from 1999 through 2002. It appears that his stats have been confused with Jerome Williams (willije01) (2003-2015) and Jeff Williams has received Jerome Williams' 2013 and 2015 seasons as well as 2003 through 2012 and 2014 neutralized stats to fill in a gap which does not exist because it's two different blokes. Don't ask me how Jeff Williams is willije02 on BB-Ref while Jerome is willije01 because Jeff was pre-Jerome, but that's how it appears to be. Jerome Williams is missing some stats (I think 2013) which appear to have been given to Jeff. They're kinda jumbled up together, but I have faith that you can get them sorted out and get them to stop stealing each other's stats because you're the man.

[actionjackson]

The following pitchers require neutralized pitching stats to "fill in the gaps" with the years that are missing:

- Mat Latos is missing 2015 Neutralized Pitching Stats with Miami only, he has his LAD and LAA stats, just not his MIA ones
- Andrew Albers missing 2014 Neutered Pitching Stats
- Dellin Betances missing 2012 Neutered Pitching Stats
- Danny Farquhar missing 2012 Neutered Pitching Stats
- Casey Fien missing 2011 Neutered Pitching Stats
- Will Harris (in addition to confusion with his evil twin) is missing 2015 Neutered Pitching Stats
- David Hernandez missing 2014 Neutered Pitching Stats
- Steve Johnson missing 2014 Neutered Pitching Stats
- Michael Kohn missing 2012 Neutered Pitching Stats
- Jo-Jo Reyes missing 2012-2014 Neutered Pitching Stats
- Fernando Rodriguez missing 2010, 2013 Neutered Pitching Stats
- Enny Romero missing 2014 Neutered Pitching Stats
- Chad Smith missing 2015 Neutered Pitching Stats
- Junichi Tazawa missing 2010 Neutered Pitching Stats
- Everett Teaford missing 2014 Neutered Pitching Stats
- Jerome Williams (partly because of mix-up with Jeff Williams I suppose) missing 2008-2010, 2013, 2015 Neutered Pitching Stats
- Barry Zito missing 2014 Neutered Pitching Stats

- Reliever/Starter Frankie Montas is importing as a 2B because he has no neutralized fielding stats - Don't know why the game is picking 2B for him, but I guess it has to choose something right?
- Reliever Scott Alexander is importing as a SS because he has no neutralized fielding stats as well
- SS Josh Wilson has a ton of innings pitched in his neutralized pitching stats for 2007, 2009, and 2015. IRL, he has 4.0 IP. His Neutered Stats give him 160.0 IP. Wouldn't want him importing as a pitcher due to so many innings.

[actionjackson]

Peter O'Brien is still 147 years old and is called Pete J O'Brien in 2015 historical. In history, there have been 2 Pete J O'Briens (1887-1890, 1901-1907), a Pete M O'Brien (1982-1993), and now we have Peter O'Brien (2015). Looks like one of the Pete J O'Briens is crossing over onto Peter's turf, and making him like, really old and giving him all kinds of Neutralized Batting Stats that he's not responsible for. Your choice as to how you want to handle this naming issue.

[actionjackson]

The Neutralized Batting Stats are exceptionally well done. I could only find three Neutralized Batting Seasons missing, they are all pitchers, and they are all from 2015. They are as follows:

Colton Murray, Frankie Montas, and Scott Alexander.

[Spritze]

Originally Posted by actionjackson

Just saw Will Harris in there, but unfortunately he's followed by his evil twin Willie Harris.

This has already been fixed and will be in the next update. It takes an update or two get or get rid of the willies.

However: This was one of the first updates I did with the new SQL form. I plan on revisiting the other older ones just to be sure since I was focused on fixing the bbref / lahman differences to start with.

I recently changed all the names to match the bbref versions in every table. Should either make things easier or harder to spot.

[actionjackson]

Originally Posted by Spritze

This has already been fixed and will be in the next update. It takes an update or two get or get rid of the willies.

However: This was one of the first updates I did with the new SQL form. I plan on revisiting the other older ones just to be sure since I was focused on fixing the bbref / lahman differences to start with.

I recently changed all the names to match the bbref versions in every table. Should either make things easier or harder to spot.

Thank you Sir Spritze.

I'll just continue with Neutralized Fielding Stats Seasons that need to have the gap filled in starting with starting pitchers:

- Bartolo Colon 2010
- Jarred Cosart 2013
- R A Dickey 2002, 2007
- Gavin Floyd 2015
- Jaime Garcia 2009
- Kyle Gibson 2013
- Drew Hutchison 2013
- Erik C Johnson 2013, 2015
- Scott Kazmir 2012
- John Lackey 2012
- Mat Latos 2015 (just LAA, MIA and LAD are already there)
- Colby Lewis 2008, 2009, 2013
- Francisco Liriano 2007
- Brandon McCarthy 2010
- Vidal Nuno 2013
- Michael Pineda 2012, 2013
- Matt Shoemaker 2013
- Marcus Stroman 2015
- Eric Stults 2010
- Jason Vargas 2008
- Yordano Ventura 2013
- Ryan Vogelsong 2007-2010
- Adam Wainwright 2011
- Taijuan Walker 2013

Some of these are gap seasons due to injury/playing in other leagues, some were just missed along the way.

[Spritze]

Originally Posted by actionjackson

Peter O'Brien is still 147 years old and is called Pete J O'Brien in 2015 historical. In history, there have been 2 Pete J O'Briens (1887-1890, 1901-1907), a Pete M O'Brien (1982-1993), and now we have Peter O'Brien (2015). Looks like one of the Pete J O'Briens is crossing over onto Peter's turf, and making him like, really old and giving him all kinds of Neutralized Batting Stats that he's not responsible for. Your choice as to how you want to handle this naming issue.

Fixed? Only time will tell.

[Spritze]

Originally Posted by actionjackson

The following pitchers require neutralized pitching stats to "fill in the gaps" with the years that are missing:

The vast majority of these are caused by a pitching data table with a blank line in it. I have not found it yet. I did figure out what to look for though.

[actionjackson]

Relief pitchers with Neutralized Fielding Stats gaps, and the years of gappage:

- David Aardsma 2005, 2011
- Nathan Adcock 2013
- Andrew Albers 2013, 2014
- Scott Atchison 2008, 2009
- John Axford 2013 (just his STL fielding stats, his MIL stats are there)
- Scott T Baker 2012
- Collin Balester 2013, 2014
- Grant Balfour 2002, 2005, 2006
- Joe Beimel 2012, 2013
- Ronald Belisario 2011
- Matt Belisle 2004
- Joaquin Benoit 2009
- Dellin Betances 2012
- Rafael Betancourt 2014
- Blaine Boyer 2012, 2013
- Craig Breslow 2007
- Cesar Cabral 2013
- Chris Capuano 2008, 2009
- Buddy Carlyle 2001-2004, 2006, 2012, 2013
- Kevin Chapman 2013
- Bruce Chen 2008
- Randy Choate 2008
- Louis Coleman 2015
- Neal Cotts 2010-2012
- Kyle Davies 2012-2014
- Ross Detwiler 2008
- Ryan Dull 2015
- Dana Eveland 2013
- Danny Farquhar 2012
- Casey Fien 2011
- Jeff Francis 2009
- Christian Friedrich 2013
- Steve Geltz 2013
- Jason Grilli 2002, 2003, 2010
- Preston Guilmet 2013
- Will Harris 2015
- David Hernandez 2014
- J P Howell 2010
- Daniel Hudson 2013
- Luke Jackson 2015
- Casey Janssen 2008
- Cesar Jimenez 2009, 2010, 2012
- Steve Johnson 2015

That's it for now...More when I get a chance...Hope this helps.

[Spritze]

I've got plenty. They will all get fixed in one fell swoop when I find the table and delete the blank line.

[actionjackson]

Originally Posted by Spritze

I've got plenty. They will all get fixed in one fell swoop when I find the table and delete the blank line.

Neutralized Batting, Pitching and Fielding Stats? I ask because I noted that you referred to a pitching data table with a blank line in it, so I'm figuring that would only affect Neutered Pitching Stats. What I've been posting lately is Neutered Fielding Stats for pitchers.

[Spritze]

Depends on the table. They share a lot of stuff.

[Habsfan18]

Not sure if it's an error or a bug or what, but when I use the 2015 Jays in historical exhibition mode, Edwin Encarnacion is listed as 3 stars in both overall and potential. But when I play a historical 2015 season with him (tested with dev engine on) he's listed as 5 stars.

Aaron Sanchez is also 1 potential and 1 overall. Is it normal that the OSA ratings for these players aren't matching up with their historical mode selves?

[Spritze]

Originally Posted by Habsfan18

Not sure if it's an error or a bug or what, but when I use the 2015 Jays in historical exhibition mode, Edwin Encarnacion is listed as 3 stars in both overall and potential. But when I play a historical 2015 season with him (tested with dev engine on) he's listed as 5 stars.

Aaron Sanchez is also 1 potential and 1 overall. Is it normal that the OSA ratings for these players aren't matching up with their historical mode selves?

The ratings structures are completely different so they will not always match up. The contexts are different.

[Spritze]

Originally Posted by actionjackson

The following pitchers require neutralized pitching stats to "fill in the gaps" with the years that are missing:

Done. I actually reworked neutering a bit while I was at it as some drift had happened since 2010 when it was introduced.

[clamel]

I started a historical league in 1987.
and found Oil Can Boyd never played in the MLB, and only had some MiLB stats plus a minor league contract at the startup ????
The RealLife Stats is also blank.

What I can see all other big stars I have looked at are correct with their MiLB and MLB stats.

[Spritze]

Originally Posted by groberts619

I couldn't help but notice, when customizing minor league teams for two new MLB expansion teams for my 2017 season, that so much of the Minor League info is not up to date. For example, in the AA Eastern League, it is still structured as the Northern Division and Southern Division, when in 2010 the two divisions were renamed and restructured to the Eastern Division and Western Division. This structure has been used ever since. Also, the A+ Northwest League is divided into the East Division and West Division, when in real life, it is currently divided into the North Division and South Division, with teams assigned to a division based on their location in the region. So, for example the Vancouver Canadians would be in the North Division, instead of the West Division as it is in the game, and etc.

I did not change these as they are correct in the database already. I do not know what you are seeing in your game but the database is up to date.

[actionjackson]

Originally Posted by Spritze

Done. I actually reworked neutering a bit while I was at it as some drift had happened since 2010 when it was introduced.

Do you want me to keep digging up the Neutralized Fielding Stats gaps? I've found a whole bunch of them since I left off with Steve Johnson. Lots and lots of relievers, but once you get to position players it slows down a bit. I've got about 120 different players with missing seasons of Neutralized Fielding Stats and I'm through SS, so I just have OF left. Will probably hit 150 by the time I'm done. Not bad when you consider that these are players that missed these seasons IRL due to injury or playing in other leagues. The Neutralized Batting Stats are just about perfecto in the 2015 historical that I'm basing this off of, just gotta work on the fielding stats so we don't get a whole bunch of DHs. Thanks for your tireless efforts and patience.

[Spritze]

I have plenty of information. Gaps should be all filled now. Keep in mind that 2016 is not factored in so a player who last played in 2014 and now plays in 2016 won't get neutered stats for 2015 until next year.