Historical database issues thread
 

Hi guys:

Please post any issues with the historical db's here. Players importing multiple times, not importing, crazy ratings, wrong stats or other stuff like this. Spritze and Bigrod will do their best to respond and to fix and issues.

Thanks for your help in making OOTP better!
Markus

Is there any chance that we can get this issue resolved?

http://www.ootpdevelopments.com/boar...d.php?t=269366

I could be wrong, but a few of the WAR's from past seasons seem off. For example, Addison Russell's 2016 WAR is listed as 1.8, but between Reference, Fangraphs, and BP, his lowest number was 3.9.

Not at this time.

The historical database has no control over service time calculations. That is a horse of a different color. This type of request goes one level up in general bug reports.

This also goes one level up.

Thanks. I'll repost it there.

Just playing through MLB to see what happens and I noticed a guy called Thomas Meara (actual minor performance - 32hr in 11 games in 1887 http://www.baseball-reference.com/re...d=meara-001tho) showed up in the majors in 1887 and hit 15-88-75-59 HR in the next four seasons.

I had neutralized stats on and development engine rather than recalc, but still that's a hell of a development jump from season 1 to 2 for a guy that had 136 minor league ABs. Is this courtesy of his insane minor league HR record?

Update: Started again with a non-neutralized game and he's just whipped home 87 long balls in 1888. Checked his stats and he has a 255 power rating against both L and R pitchers. By comparison second in HR was Jack Clements with 23 and his power rating is 80 vs LHP and 99 vs RHP.

Fixed

Thank you, and apologies to the distant relatives of Mr. Meara for wrecking his shot at historical immortality.

Actually this might be a typo on baseball reference.
He shows only 16 hits and 11 runs but 32 hr.
So I think he maybe had 3 that year.

Minor League db has players first / last names reversed
 

Firstly, THANK YOU! for the MiLB csv file!!! Secondly, after a quick pass through of the information on it, I have found 2,700 players who's first and last names are reversed. Just a couple quick steps of adding "=left" formulas columns next to the minor league ID column and the last name column and seeing what doesn't match. Who can I send this information to?

Out of curiosity, how many of them were first-year players in 2016?

attach here and I'll pick it up.

Red Hoff shows up as Red 'Red' Hoff when nicknames are checked off. Kind of nitpicky, perhaps, but it seems redundant.

Also a lot of the pitchers seem to have contact potential that are really low despite pretty high power potential ratings (due to small sample sized minor league hitting numbers it seems). Not sure if this is a case of how BA potential is computed and if it's erring on the side of caution re: low Contact Potential?

Example #1: RP Joseph Kemis - kemis-001jos
IRL: Has 106 PA and hit .287/.352/.489 but with 5 Doubles and 4 HR

Yet he has a 13 Contact Potential against a 66 Power Potential?

Example #2: RP Russell Fritsch - fritsc001rus
IRL: Has just 71 PA but hits .313/.371/.531 with 4 Doubles, 2 Triples, and 2 HR

Yet he has a 6 Contact Potential vs. a 34 Gap/61 HR/36 Eye

I'm not advocating they get like 60-70 Contact potential or anything but even 20-25 or 25-30 would seem to be more realistic. Low enough that they don't become superstars but high enough that they could hit a little in 'No DH' leagues.

Instead I'm seeing a ton of SP/RP types with 1 Contact Potential or variations hewing closer to that number than say 20.

I wanted to do a league with the 2005 White Sox, but a few guys showed up throughout the organizational roster multiple times. For example, there was a Willie Harris, a Willy Harris, and a Will Harris all on different minor league teams in the organization. There were two Josh Fields as well. Also, a lot of the jersey numbers were way off. Frank Thomas was #80 something, AJ Pierzynski was #70 something, etc.

This goes one level up. Not a database issue. I will Fix Red Red.

The Harris's are 3 different people with different birthplaces and birthdays. Same with the Josh's= 2 dudes. Jersey numbers are not controlled by the database

Here is the file (couldn't get the .zip to be small enough so I put it in my dropbox):

https://www.dropbox.com/s/xobb0lhzw8...r-gm.xlsx?dl=0

You'll see I added columns to do a lookup, and it's filtered on the mistakes I found.

Almost all - 2,500 of 2,700.

I cannot download this file

Dropbox only displays it open

I need it as a file not a bunch of individual lines

Sorry. Please try again?