Historical MLB/Minors roster and db issues go here - Page 19

Spritze · 04-29-2016, 04:33 PM

Quote:

Originally Posted by actionjackson

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?

I can only reply that the fix is in for them.

Spritze · 04-29-2016, 05:26 PM

Quote:

Originally Posted by actionjackson

How did R A Dickey get lumped in there then?

This is part of the how:SELECT [750PitchingCareer].playerID, [300/50MinimumBatting].SumOfG AS BattingGames, IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]) AS KillThesePitchingRecords, [300/50MinimumBatting].TooFew300G, CInt(([sumofipouts]/[sumofg])*[toofew300g]) AS NewIPOuts, [750PitchingCareer].SumOfG, [750PitchingCareer].SumOfIPouts, [750PitchingCareer].SumOfW, CInt(([sumofw]/[sumofg])*[toofew300g]) AS NewW, [750PitchingCareer].SumOfL, CInt(([sumofl]/[sumofg])*[toofew300g]) AS NewL, [750PitchingCareer].SumOfGS, CInt(([sumofgs]/[sumofg])*[toofew300g]) AS NewGS, [750PitchingCareer].SumOfCG, CInt(([sumofcg]/[sumofg])*[toofew300g]) AS NewCG, [750PitchingCareer].SumOfNewSHO, CInt(([sumofnewsho]/[sumofg])*[toofew300g]) AS NewSho, [750PitchingCareer].SumOfSV, CInt(([sumofsv]/[sumofg])*[toofew300g]) AS NewSV, [750PitchingCareer].SumOfNewH, CInt(([sumofnewH]/[sumofg])*[toofew300g]) AS NewH, [750PitchingCareer].SumOfnewER, CInt(([sumofnewer]/[sumofg])*[toofew300g]) AS NewER, [750PitchingCareer].SumOfNewHR, CInt(([sumofnewHR]/[sumofg])*[toofew300g]) AS NewHR, [750PitchingCareer].SumOfnewbb, CInt(([sumofnewbb]/[sumofg])*[toofew300g]) AS NewBB, [750PitchingCareer].SumOfnewso, CInt(([sumofnewso]/[sumofg])*[toofew300g]) AS NewSO, [750PitchingCareer].SumOfnewibb, CInt(([sumofnewibb]/[sumofg])*[toofew300g]) AS NewIBB, [750PitchingCareer].SumOfnewwp, CInt(([sumofnewwp]/[sumofg])*[toofew300g]) AS NewWP, [750PitchingCareer].SumOfnewhbp, CInt(([sumofnewhbp]/[sumofg])*[toofew300g]) AS NewHBP, [750PitchingCareer].SumOfnewbk, CInt(([sumofnewbk]/[sumofg])*[toofew300g]) AS NewBK, [750PitchingCareer].SumOfBFP, CInt(([sumofbfp]/[sumofg])*[toofew300g]) AS NewBFP, [750PitchingCareer].SumOfGF, CInt(([sumofgf]/[sumofg])*[toofew300g]) AS NewGF, [750PitchingCareer].SumOfnewr, CInt(([sumofnewr]/[sumofg])*[toofew300g]) AS NewR, [750PitchingCareer].SumOfnewsh, CInt(([sumofnewsh]/[sumofg])*[toofew300g]) AS NewSH, [750PitchingCareer].SumOfnewsf, CInt(([sumofnewsf]/[sumofg])*[toofew300g]) AS NewSF, [750PitchingCareer].SumOfnewgidp, CInt(([sumofnewgidp]/[sumofg])*[toofew300g]) AS NewGIDP
FROM [300/50MinimumBatting] RIGHT JOIN 750PitchingCareer ON [300/50MinimumBatting].playerID = [750PitchingCareer].playerID
WHERE (((IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]))>0.02))
ORDER BY [750PitchingCareer].playerID;

actionjackson · 04-29-2016, 06:03 PM

Quote:

Originally Posted by Spritze

This is part of the how:SELECT [750PitchingCareer].playerID, [300/50MinimumBatting].SumOfG AS BattingGames, IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]) AS KillThesePitchingRecords, [300/50MinimumBatting].TooFew300G, CInt(([sumofipouts]/[sumofg])*[toofew300g]) AS NewIPOuts, [750PitchingCareer].SumOfG, [750PitchingCareer].SumOfIPouts, [750PitchingCareer].SumOfW, CInt(([sumofw]/[sumofg])*[toofew300g]) AS NewW, [750PitchingCareer].SumOfL, CInt(([sumofl]/[sumofg])*[toofew300g]) AS NewL, [750PitchingCareer].SumOfGS, CInt(([sumofgs]/[sumofg])*[toofew300g]) AS NewGS, [750PitchingCareer].SumOfCG, CInt(([sumofcg]/[sumofg])*[toofew300g]) AS NewCG, [750PitchingCareer].SumOfNewSHO, CInt(([sumofnewsho]/[sumofg])*[toofew300g]) AS NewSho, [750PitchingCareer].SumOfSV, CInt(([sumofsv]/[sumofg])*[toofew300g]) AS NewSV, [750PitchingCareer].SumOfNewH, CInt(([sumofnewH]/[sumofg])*[toofew300g]) AS NewH, [750PitchingCareer].SumOfnewER, CInt(([sumofnewer]/[sumofg])*[toofew300g]) AS NewER, [750PitchingCareer].SumOfNewHR, CInt(([sumofnewHR]/[sumofg])*[toofew300g]) AS NewHR, [750PitchingCareer].SumOfnewbb, CInt(([sumofnewbb]/[sumofg])*[toofew300g]) AS NewBB, [750PitchingCareer].SumOfnewso, CInt(([sumofnewso]/[sumofg])*[toofew300g]) AS NewSO, [750PitchingCareer].SumOfnewibb, CInt(([sumofnewibb]/[sumofg])*[toofew300g]) AS NewIBB, [750PitchingCareer].SumOfnewwp, CInt(([sumofnewwp]/[sumofg])*[toofew300g]) AS NewWP, [750PitchingCareer].SumOfnewhbp, CInt(([sumofnewhbp]/[sumofg])*[toofew300g]) AS NewHBP, [750PitchingCareer].SumOfnewbk, CInt(([sumofnewbk]/[sumofg])*[toofew300g]) AS NewBK, [750PitchingCareer].SumOfBFP, CInt(([sumofbfp]/[sumofg])*[toofew300g]) AS NewBFP, [750PitchingCareer].SumOfGF, CInt(([sumofgf]/[sumofg])*[toofew300g]) AS NewGF, [750PitchingCareer].SumOfnewr, CInt(([sumofnewr]/[sumofg])*[toofew300g]) AS NewR, [750PitchingCareer].SumOfnewsh, CInt(([sumofnewsh]/[sumofg])*[toofew300g]) AS NewSH, [750PitchingCareer].SumOfnewsf, CInt(([sumofnewsf]/[sumofg])*[toofew300g]) AS NewSF, [750PitchingCareer].SumOfnewgidp, CInt(([sumofnewgidp]/[sumofg])*[toofew300g]) AS NewGIDP
FROM [300/50MinimumBatting] RIGHT JOIN 750PitchingCareer ON [300/50MinimumBatting].playerID = [750PitchingCareer].playerID
WHERE (((IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]))>0.02))
ORDER BY [750PitchingCareer].playerID;

Whoa!

Hoiles · 05-02-2016, 06:38 AM

Thanks Spritze for your quick response to my previous posts. I ran a quick sim starting in 1961 with the newest rosters to find duplicated players, with the same name (removing special characters and spaces) and birth month. Some were mentioned in my post from last week. Here are the results:

Bryan Price 1986-11
CC Sabathia 1980-07
Chuck Smith 1969-10
D'Angelo Jimenez 1977-12
Darren O'Day 1982-10
Eric O'Flaherty 1985-02
Erisbel Arruebarrena 1990-03
Freddy Garcia 1975-06 (the pitcher with majors ID garcifr03 should have minors ID garcia003fre)
Gabe Gonzalez 1972-05
J C Hartman 1934-04
Jeff C D'Amico 1975-12
Jeff M D'Amico 1974-11
Jesus de la Rosa 1953-08
Jim Morris 1964-01
Johan Santana 1979-03
John D'Acquisto 1951-12
Jorge De La Rosa 1981-04
Jose D Ortiz 1977-06
Julio Ramirez 1977-08
Kevin Nicholson 1976-03
La Schelle Tarver 1959-01
Mark Watson 1974-01
Michael Stutes 1986-09
Mike de la Hoz 1938-10
Mike O'Connor 1980-08
Neil Weber 1972-12
Oil Can Boyd 1959-10
Peter O'Brien 1990-07
Rafael Furcal 1977-10
Randy St. Claire 1960-08
RC Stevens 1934-07
Rick Greene 1971-01
Rob Woodward 1962-09
Rodrigo Lopez 1975-12
Roosevelt Brown 1975-08
Ryan O'Rourke 1988-04
Shawn O'Malley 1987-12
Steve Schrenk 1968-11
Tike Redman 1977-03
Tom Jacquez 1975-12
Tony La Russa 1944-10
UL Washington 1953-10
Willie Harris 1978-06
Wily Mo Pena 1982-01

I'll give my computer a rest and look for duplicates pre-1961 in a few days.

Spritze · 05-02-2016, 09:37 AM

It appears from your list that all these players have already been fixed. Those fixes will appear in the next full update due out in a month or two.

Hoiles · 05-02-2016, 11:57 AM

Oh that's good to hear. At least I got some programming practice and my laptop didn't explode in the sim, which I do admit is super fast now, I wouldn't have tried this with older versions.

actionjackson · 05-02-2016, 03:01 PM

Quote:

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

Spritze: I've found by importing these players (Cesar Cabral and Oliver Drake so far) that the reason they aren't showing up in my game is because they have no neutralized stats at all for any season. This is not good for those of us that play with neutralized stats. Could you possibly take a look at this? Thanks. This now includes R A Dickey, who has been in the big leagues since 2001.

EDIT: I can dig up all 174 of them if need be. Thanks.

actionjackson · 05-02-2016, 03:15 PM

Also Will Harris/Willie Harris problem still exists, but Jerome Williams/Jeff Williams issue appears to have been fixed.

Spritze · 05-02-2016, 03:24 PM

These fixes will not be released until the NEXT full update, in a month or two.

You are just looking at the old files that have no changes applied.

actionjackson · 05-02-2016, 03:56 PM

Quote:

Originally Posted by Spritze

These fixes will not be released until the NEXT full update, in a month or two.

You are just looking at the old files that have no changes applied.

By old files, do you mean 17.7.51?

Spritze · 05-02-2016, 06:31 PM

No changes will have been processed until later this summer. I believe .51 is a 3D fix you don't need special glasses for.

grmagne · 05-06-2016, 10:11 PM

When I go to Historical Exhibition and play the 1920 World Series there is a missing player. Steve O'Neill is not on the Cleveland Indians roster even though he was their starting catcher and played 7 games in the 1920 WS. However, if I set up an exhibition game with that Indians team against any other team then O'Neill does appear on the roster.

pstrickert · 05-06-2016, 10:54 PM

grmagne, I'll bet O'Neill is someone whose ID has changed. I'll make the change(s) to the World Series rosters file.

ETA: I made more than a dozen ID changes and sent the updated file to Markus.

Spritze · 05-09-2016, 01:20 PM

The known duplicate players will have been fixed in the next upgrade to be released in a few days. If you find any remaining they will either have been unreported or I messed up when fixing them. Even though a few hundred were reported this lead to several thousand additional fixes.

Thanks!

pstrickert · 05-09-2016, 02:28 PM

Quote:

Originally Posted by grmagne

When I go to Historical Exhibition and play the 1920 World Series there is a missing player. Steve O'Neill is not on the Cleveland Indians roster even though he was their starting catcher and played 7 games in the 1920 WS. However, if I set up an exhibition game with that Indians team against any other team then O'Neill does appear on the roster.

This is confirmed fixed in the next patch.

Hoiles · 05-10-2016, 09:19 PM

I just downloaded the beta, thanks for the updates on the duplicated players (Johan Santana, Furcal, etc). In a 2001 import, there are some fringy players I reported a bit later, like D'Angelo Jimenez, Jeff D'Amico (both of them), Willie Harris with two copies. Are these going to be fixed in the official patch coming up soon?

Spritze · 05-11-2016, 05:18 PM

There are two major league Willie Harris's and one minor league one. I just renamed one of the major league ones Willie R. Harris so you can tell them apart easier. There are also several William, Will, Bill and Billy Harris's.

D'Angelo Jimenez, Jeff D'Amico (both of them) are in the update and were corrected.

I do not know when the newer files will show up in the game. Not my call.

risp2out · 05-13-2016, 10:55 AM

Historical with affiliated minors. Started in 1988. Now, it's the first day of the off-season. Minors database loads and a second Oil Can Boyd appears as a free agent. After checking, I see that regular Oil Can has only MLB stats in his real stats, and new Oil Can has only MiLB stats in his. I'm guess that somehow the two should be merged into a genuine Oil Can.

*FWIW, I started this league with one of the previous builds (don't remember which now) and I am currently in the new build 54.

Spritze · 05-13-2016, 11:04 AM

This was fixed a while ago. Don't know when OOTP will release it.

Hoiles · 05-13-2016, 06:02 PM

Quote:

Originally Posted by risp2out

Historical with affiliated minors. Started in 1988. Now, it's the first day of the off-season. Minors database loads and a second Oil Can Boyd appears as a free agent. After checking, I see that regular Oil Can has only MLB stats in his real stats, and new Oil Can has only MiLB stats in his. I'm guess that somehow the two should be merged into a genuine Oil Can.

*FWIW, I started this league with one of the previous builds (don't remember which now) and I am currently in the new build 54.

In case you're wondering, I made a somewhat comprehensive list of duplicate players (1961 onwards) from an older build a few posts up... many of them (like Johan Santana and Rafael Furcal) have been corrected in the latest OOTP release.

05-02-2016, 06:38 AM	#364
Hoiles All Star Reserve Join Date: Dec 2001 Location: Canada Posts: 574	Thanks Spritze for your quick response to my previous posts. I ran a quick sim starting in 1961 with the newest rosters to find duplicated players, with the same name (removing special characters and spaces) and birth month. Some were mentioned in my post from last week. Here are the results: Bryan Price 1986-11 CC Sabathia 1980-07 Chuck Smith 1969-10 D'Angelo Jimenez 1977-12 Darren O'Day 1982-10 Eric O'Flaherty 1985-02 Erisbel Arruebarrena 1990-03 Freddy Garcia 1975-06 (the pitcher with majors ID garcifr03 should have minors ID garcia003fre) Gabe Gonzalez 1972-05 J C Hartman 1934-04 Jeff C D'Amico 1975-12 Jeff M D'Amico 1974-11 Jesus de la Rosa 1953-08 Jim Morris 1964-01 Johan Santana 1979-03 John D'Acquisto 1951-12 Jorge De La Rosa 1981-04 Jose D Ortiz 1977-06 Julio Ramirez 1977-08 Kevin Nicholson 1976-03 La Schelle Tarver 1959-01 Mark Watson 1974-01 Michael Stutes 1986-09 Mike de la Hoz 1938-10 Mike O'Connor 1980-08 Neil Weber 1972-12 Oil Can Boyd 1959-10 Peter O'Brien 1990-07 Rafael Furcal 1977-10 Randy St. Claire 1960-08 RC Stevens 1934-07 Rick Greene 1971-01 Rob Woodward 1962-09 Rodrigo Lopez 1975-12 Roosevelt Brown 1975-08 Ryan O'Rourke 1988-04 Shawn O'Malley 1987-12 Steve Schrenk 1968-11 Tike Redman 1977-03 Tom Jacquez 1975-12 Tony La Russa 1944-10 UL Washington 1953-10 Willie Harris 1978-06 Wily Mo Pena 1982-01 I'll give my computer a rest and look for duplicates pre-1961 in a few days. Last edited by Hoiles; 05-02-2016 at 06:41 AM.

05-02-2016, 09:37 AM	#365
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	It appears from your list that all these players have already been fixed. Those fixes will appear in the next full update due out in a month or two. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

05-02-2016, 03:24 PM	#369
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	These fixes will not be released until the NEXT full update, in a month or two. You are just looking at the old files that have no changes applied. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

05-02-2016, 06:31 PM	#371
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	No changes will have been processed until later this summer. I believe .51 is a 3D fix you don't need special glasses for. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

05-06-2016, 10:54 PM	#373
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 16,374	grmagne, I'll bet O'Neill is someone whose ID has changed. I'll make the change(s) to the World Series rosters file. ETA: I made more than a dozen ID changes and sent the updated file to Markus. Last edited by pstrickert; 05-06-2016 at 11:29 PM.

05-02-2016, 11:57 AM	#366
Hoiles All Star Reserve Join Date: Dec 2001 Location: Canada Posts: 574	Oh that's good to hear. At least I got some programming practice and my laptop didn't explode in the sim, which I do admit is super fast now, I wouldn't have tried this with older versions.

05-02-2016, 03:15 PM	#368
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,163	Also Will Harris/Willie Harris problem still exists, but Jerome Williams/Jeff Williams issue appears to have been fixed.

05-06-2016, 10:11 PM	#372
grmagne Minors (Triple A) Join Date: Apr 2016 Location: Toronto Posts: 250	When I go to Historical Exhibition and play the 1920 World Series there is a missing player. Steve O'Neill is not on the Cleveland Indians roster even though he was their starting catcher and played 7 games in the 1920 WS. However, if I set up an exhibition game with that Indians team against any other team then O'Neill does appear on the roster.

05-09-2016, 01:20 PM	#374
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The known duplicate players will have been fixed in the next upgrade to be released in a few days. If you find any remaining they will either have been unreported or I messed up when fixing them. Even though a few hundred were reported this lead to several thousand additional fixes. Thanks! __________________ It's madness, madness, I tell you! For the love of God, don't do it!

05-10-2016, 09:19 PM	#376
Hoiles All Star Reserve Join Date: Dec 2001 Location: Canada Posts: 574	I just downloaded the beta, thanks for the updates on the duplicated players (Johan Santana, Furcal, etc). In a 2001 import, there are some fringy players I reported a bit later, like D'Angelo Jimenez, Jeff D'Amico (both of them), Willie Harris with two copies. Are these going to be fixed in the official patch coming up soon?

05-11-2016, 05:18 PM	#377
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	There are two major league Willie Harris's and one minor league one. I just renamed one of the major league ones Willie R. Harris so you can tell them apart easier. There are also several William, Will, Bill and Billy Harris's. D'Angelo Jimenez, Jeff D'Amico (both of them) are in the update and were corrected. I do not know when the newer files will show up in the game. Not my call. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 05-11-2016 at 05:41 PM.

05-13-2016, 10:55 AM	#378
risp2out All Star Reserve Join Date: Apr 2009 Posts: 648	So many Oil Cans Historical with affiliated minors. Started in 1988. Now, it's the first day of the off-season. Minors database loads and a second Oil Can Boyd appears as a free agent. After checking, I see that regular Oil Can has only MLB stats in his real stats, and new Oil Can has only MiLB stats in his. I'm guess that somehow the two should be merged into a genuine Oil Can. *FWIW, I started this league with one of the previous builds (don't remember which now) and I am currently in the new build 54. Attached Images

05-13-2016, 11:04 AM	#379
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	This was fixed a while ago. Don't know when OOTP will release it. __________________ It's madness, madness, I tell you! For the love of God, don't do it!