Historical database issues go here! - Page 12

actionjackson · 02-08-2022, 06:29 PM

Quote:

Originally Posted by M's rule

OMG, I just discovered this problem too. The fix is to change Bill Clarkson from clarkbi01 to clarkbi02 (his current BBRef ID) and then change Win Clark from clarkwi03 to clarkbi01 (ditto). I've just changed Clarkson's ID in the lineups and transactions files accordingly, as well as the mentions of Win Clark in the transactions file..

The lahman40 IDs are obsolete and all should have been scrubbed a while ago. To the best of my knowledge, these two are the only remaining problems of this sort.

Great minds. Or OOTP nerdly dorks. Maybe both. Hot dang! Just noticed the clarkwi03. Would've saved me tons of time, and would've given me more complete stats (Garlon added a CS to his ledger).

Seven_ · 02-13-2022, 05:42 PM

So a problem I'm running into, which I also made the post about is that certain Negro League players are straight up not coming into the universe that I have set up. For an example I have just finished 1930, Josh Gibson is nowhere to be found. Other Negro Leaguers have come in fine, Turkey Stearnes, Cool Papa Bell, Satchel Paige, all came in on their proper years. Gibson? No where to be found, same with Buck Leonard.

I even tried manually importing him. First using his ID on Baseball reference, which did not work. I looked through my database, and found an alternative player ID for Gibson (I would have to double check but I believe it was GibsonJos002, or something along the lines of that) but when I imported him, he was basically a blank slate. Rated a 20, with a random position, and no real stats.

I'm wondering when exactly he will show up, or if he will show up at all. I've gotten a decade into my Sim and I would hate to have to restart. Any ideas?

LansdowneSt · 02-13-2022, 06:14 PM

The "gibson002jos" code is correct. I assume since the other NeL players came through, the color line is off and that on the manual import, you used "gibson002jos" with the minor league database toggle checked "on" in the player import box. The MLB bRef code was only invented by bRef several months ago once bRef aligned with MLB's new definition of MLB leagues and doesn't align with OOTP (yet?).

I just imported him in 1930 to test the database and he come in at 18 years old fine but given the minor league treatment of him and the partial stats in the database, ... he is terrible. Maybe DM actionjackson and see if he can point you toward Spritze's database file and give you some how-to-steps. Then you can drop that database in the correct folder, select it for importing this one player, and add a modified Josh from there for a better player. He uses that database often for NeL players in his on-going league so could prob easily give you the steps.

schmidtfan · 02-20-2022, 08:41 PM

Hi--I am playing an MLB historical league that started in 1981. I am now in September of 2019. In 2018, the entire draft pool was 31 players, which basically meant I had no draft. I pushed through it, but now, there are only about 69 players. So unless I can resolve this, there will only be 2 rounds of draftable players. Can you please provide information on how I might resolve this? Thank you.

LansdowneSt · 02-20-2022, 09:50 PM

schmidtfan,

In the league drop down menu, go to logs and capture the last draft log and post as an attachment (just edit your post, advanced view, manage attachments, upload). Also, a report showing the 69 players in the pool for the 2019 season. When they get a chance to help, it may be useful to know who is, in fact, showing up so they can isolate why the ones that aren't, aren't.

schmidtfan · 02-20-2022, 10:25 PM

Per the nice person above's suggestion, here's the draft log for last season (which happened in 2018 but i guess it says 2019 because it was in advance of the 2019 season), and the current draft pool. It looks like it's more like 212 players, but that's still pretty low, right? And no SP or Batters with above 2.5 potential...

LansdowneSt · 02-21-2022, 12:35 AM

schmidtfan,

I started an OOTP22 Historical Game in 2016 and counted the players in each draft going forward. The results are for the Sept draft pool announcement of each respective year are as follows:

2016 - 2,091 players
2017 - 1,138 players
2018 - 20 players
2019 - 212 players
2020 - 0 players
2021 - 0 players
2022 - 0 players

By the time I got to 2022, I went into the Game Settings and saw that the number of rounds for the amateur draft was blank. So, it appeared as -1 rounds (first screenshot) and didn't generate any players. For some reason, the game may need to have you go in for each of the upcoming years Game Settings>League Settings>Rules and manually set the number of rounds for the draft (lower right second screenshot) to generate the amateurs properly. Check it in January, preseason, spring training and after the regular season starts as I don't know when the value is resetting to blank and when the value "locks" for the September draft pool announcement.

There aren't going to be any patches for 22 to address but Lukas et al will look at this for OOTP23 for sure. At least you can reset the value as much as a pain as that may be each year as a work around.

Lukas Berger · 02-21-2022, 04:36 AM

Quote:

Originally Posted by LansdowneSt

schmidtfan,

I started an OOTP22 Historical Game in 2016 and counted the players in each draft going forward. The results are for the Sept draft pool announcement of each respective year are as follows:

2020 - 0 players
2021 - 0 players
2022 - 0 players

This is to be expected, as in 2020 on you will not get any new players (because the draft in 2020 loads players who debuted in 2021) because the historical db runs out at that point. You need to switch things in the settings from the historical settings to fictional settings and having the game generate fictional players if you want to continue playing a historical game beyond where the db runs out

LansdowneSt · 02-21-2022, 05:11 AM

So the low 2019 number of players is a lack of minor league debuts due to COVID impact on the minors in 2020? What might be the cause of the 2019 dip. Shame the switch to fictional can’t be automatically done when the csv runs out to the last year. I can see users getting g caught unaware that a game settings edit is required. But sure makes sense as to the cause as you lay it out.

.

Lukas Berger · 02-21-2022, 05:50 AM

Quote:

Originally Posted by LansdowneSt

So the low 2019 number of players is a lack of minor league debuts due to COVID impact on the minors in 2020?

Yep.

Quote:

Originally Posted by LansdowneSt

What might be the cause of the 2019 dip. Shame the switch to fictional can’t be automatically done when the csv runs out to the last year. I can see users getting g caught unaware that a game settings edit is required. But sure makes sense as to the cause as you lay it out.

.

The 2018 dip is the one I'm really not sure of atm, will put it on my list of stuff to look into.

schmidtfan · 02-21-2022, 11:36 AM

Quote:

Originally Posted by Lukas Berger

This is to be expected, as in 2020 on you will not get any new players (because the draft in 2020 loads players who debuted in 2021) because the historical db runs out at that point. You need to switch things in the settings from the historical settings to fictional settings and having the game generate fictional players if you want to continue playing a historical game beyond where the db runs out

Thank you! Where is that setting? I tried to do what Lansdowne suggested but it doesn't seem to be changing player generation

Never mind, found it, thanks.

Ctrane · 03-11-2022, 12:23 PM

Join Date: May 2007
Location: Newington, CT
Posts: 2,029
Playing 1927 Season - pitching ratings way off
playing ootp 22. For the first time I created a historical 1927 replay.
After playing the Yankees for a few games with my pitching being bombed I switched to commisioner mode and looked at the internal ratings of the
pitchers by pitch type. They all in the single digits with some being higher than the potential rating. A bunch are rated for knuckle curves which I doubt were a thing in 1927. The batter ratings look OK. Can't figure what if anything I did wrong.

AESP_pres · 03-16-2022, 07:40 PM

I'm doing the FG for the 19th century players and two players use the same historical minor league id (farrel001joe): Jack Farrell (1879) and Joe Farrell (1882).

Going by the game logic Jack should be farrel001jac and joe should be farrel001joe...

luckymann · 03-17-2022, 01:39 AM

Has anyone looked into why Babe Ruth starts getting pitching ratings again in the mid-1920s even when 1-year recalc is being applied? Could there be some stray stats in the DB? Because IRL he last pitched 9 innings in 1921 with an ERA of 9.00 until a small amount of IP in 1930, so there is absolutely no reason why his P ratings should reappear, and certainly not with the strength they do.

It doesn't happen all the time, but regularly enough and it affects his offensive numbers quite dramatically. Irrespective of this, it shouldn't be happening at all.

The Game · 03-20-2022, 02:06 AM

Not sure if this is the right forum for this but minor league player Jesse white, current Illinois secretary of State is black not white. He's also from Alton, IL which is in the database.

AESP_pres · 03-27-2022, 11:02 PM

Wrong Historical minor id, his id at BBref is burns-001jim
https://www.baseball-reference.com/r...d=burns-001jim

AESP_pres · 03-28-2022, 09:30 AM

Wrong Historical minor id, his id at BBref is hoffma001fra
https://www.baseball-reference.com/r...d=hoffma001fra

scarter95 · 03-29-2022, 04:18 PM

I sense I'm a pretty simple user of OOTP. I basically play exhibition series matching teams I remember and manage both teams using end-of-season rosters. I have also loaded the game using start-of-season rosters to see if any of these players show up. Here are a few players I noticed missing from specific teams' rosters:

Roger Clemens on 2007 Yankees
Roger Clemens on 2004 Astros
Chico Walker on 1993 Mets
Mickey Lolich on 1978 Padres

I know I have discovered others randomly but thought I would mention these as OOTP23 is being created/finalized.

Thanks for any attention to detail.

pstrickert · 03-29-2022, 04:49 PM

scarter95, Clemens did not sign with the Yankees until May 2007, so technically he was not on the opening day roster. The other items on your list have already been fixed in the database. Not sure why they didn't make it into an OOTP22 update. Pretty sure they'll be included in OOTP23, however. Plus, I added Clemens to the OD roster for 2007.

scarter95 · 03-30-2022, 01:36 PM

Thank you sir. You guys do a great job on updates.

02-20-2022, 08:41 PM	#224
schmidtfan Bat Boy Join Date: Jun 2020 Posts: 9	Few players in draft Hi--I am playing an MLB historical league that started in 1981. I am now in September of 2019. In 2018, the entire draft pool was 31 players, which basically meant I had no draft. I pushed through it, but now, there are only about 69 players. So unless I can resolve this, there will only be 2 rounds of draftable players. Can you please provide information on how I might resolve this? Thank you.

02-21-2022, 12:35 AM	#227
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,482	schmidtfan, I started an OOTP22 Historical Game in 2016 and counted the players in each draft going forward. The results are for the Sept draft pool announcement of each respective year are as follows: 2016 - 2,091 players 2017 - 1,138 players 2018 - 20 players 2019 - 212 players 2020 - 0 players 2021 - 0 players 2022 - 0 players By the time I got to 2022, I went into the Game Settings and saw that the number of rounds for the amateur draft was blank. So, it appeared as -1 rounds (first screenshot) and didn't generate any players. For some reason, the game may need to have you go in for each of the upcoming years Game Settings>League Settings>Rules and manually set the number of rounds for the draft (lower right second screenshot) to generate the amateurs properly. Check it in January, preseason, spring training and after the regular season starts as I don't know when the value is resetting to blank and when the value "locks" for the September draft pool announcement. There aren't going to be any patches for 22 to address but Lukas et al will look at this for OOTP23 for sure. At least you can reset the value as much as a pain as that may be each year as a work around. Attached Images Last edited by LansdowneSt; 02-21-2022 at 12:37 AM.

03-11-2022, 12:23 PM	#232
Ctrane Hall Of Famer Join Date: May 2007 Location: Newington, CT Posts: 2,305	1927 season pitcher ratings Join Date: May 2007 Location: Newington, CT Posts: 2,029 Playing 1927 Season - pitching ratings way off playing ootp 22. For the first time I created a historical 1927 replay. After playing the Yankees for a few games with my pitching being bombed I switched to commisioner mode and looked at the internal ratings of the pitchers by pitch type. They all in the single digits with some being higher than the potential rating. A bunch are rated for knuckle curves which I doubt were a thing in 1927. The batter ratings look OK. Can't figure what if anything I did wrong.

03-16-2022, 07:40 PM	#233
AESP_pres Hall Of Famer Join Date: Jun 2007 Location: Province of Quebec Posts: 4,053	I'm doing the FG for the 19th century players and two players use the same historical minor league id (farrel001joe): Jack Farrell (1879) and Joe Farrell (1882). Going by the game logic Jack should be farrel001jac and joe should be farrel001joe... __________________ The FGs I did for the Universe Facegen pack if you don't want to download the complete file everytime the pack is updated. The complete set (1871 to 1978) Just the update. Last edited by AESP_pres; 03-16-2022 at 07:41 PM.

03-17-2022, 01:39 AM	#234
luckymann Hall Of Famer Join Date: Nov 2019 Posts: 13,468	Ruth anomalies Has anyone looked into why Babe Ruth starts getting pitching ratings again in the mid-1920s even when 1-year recalc is being applied? Could there be some stray stats in the DB? Because IRL he last pitched 9 innings in 1921 with an ERA of 9.00 until a small amount of IP in 1930, so there is absolutely no reason why his P ratings should reappear, and certainly not with the strength they do. It doesn't happen all the time, but regularly enough and it affects his offensive numbers quite dramatically. Irrespective of this, it shouldn't be happening at all. __________________ HISTORICAL DO-OVERS A'S RED SOX DODGERS CUSTOM SAVES ECLIPSE LEAGUE MOON SHOT LEAGUE EVERYMAN LEAGUE GULF LEAGUE USBA Last edited by luckymann; 03-17-2022 at 01:41 AM.

02-13-2022, 05:42 PM	#222
Seven_ Bat Boy Join Date: Dec 2020 Posts: 16	So a problem I'm running into, which I also made the post about is that certain Negro League players are straight up not coming into the universe that I have set up. For an example I have just finished 1930, Josh Gibson is nowhere to be found. Other Negro Leaguers have come in fine, Turkey Stearnes, Cool Papa Bell, Satchel Paige, all came in on their proper years. Gibson? No where to be found, same with Buck Leonard. I even tried manually importing him. First using his ID on Baseball reference, which did not work. I looked through my database, and found an alternative player ID for Gibson (I would have to double check but I believe it was GibsonJos002, or something along the lines of that) but when I imported him, he was basically a blank slate. Rated a 20, with a random position, and no real stats. I'm wondering when exactly he will show up, or if he will show up at all. I've gotten a decade into my Sim and I would hate to have to restart. Any ideas?

02-13-2022, 06:14 PM	#223
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,482	The "gibson002jos" code is correct. I assume since the other NeL players came through, the color line is off and that on the manual import, you used "gibson002jos" with the minor league database toggle checked "on" in the player import box. The MLB bRef code was only invented by bRef several months ago once bRef aligned with MLB's new definition of MLB leagues and doesn't align with OOTP (yet?). I just imported him in 1930 to test the database and he come in at 18 years old fine but given the minor league treatment of him and the partial stats in the database, ... he is terrible. Maybe DM actionjackson and see if he can point you toward Spritze's database file and give you some how-to-steps. Then you can drop that database in the correct folder, select it for importing this one player, and add a modified Josh from there for a better player. He uses that database often for NeL players in his on-going league so could prob easily give you the steps.

02-20-2022, 09:50 PM	#225
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,482	schmidtfan, In the league drop down menu, go to logs and capture the last draft log and post as an attachment (just edit your post, advanced view, manage attachments, upload). Also, a report showing the 69 players in the pool for the 2019 season. When they get a chance to help, it may be useful to know who is, in fact, showing up so they can isolate why the ones that aren't, aren't.

02-21-2022, 05:11 AM	#229
LansdowneSt Global Moderator Join Date: Feb 2004 Location: From Duxbury, Mass residing Baltimore Posts: 7,482	So the low 2019 number of players is a lack of minor league debuts due to COVID impact on the minors in 2020? What might be the cause of the 2019 dip. Shame the switch to fictional can’t be automatically done when the csv runs out to the last year. I can see users getting g caught unaware that a game settings edit is required. But sure makes sense as to the cause as you lay it out. .

03-20-2022, 02:06 AM	#235
The Game Hall Of Famer Join Date: Feb 2012 Location: Inside The Game Posts: 30,937	Not sure if this is the right forum for this but minor league player Jesse white, current Illinois secretary of State is black not white. He's also from Alton, IL which is in the database. Attached Images __________________ Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong"

03-27-2022, 11:02 PM	#236
AESP_pres Hall Of Famer Join Date: Jun 2007 Location: Province of Quebec Posts: 4,053	Wrong Historical minor id, his id at BBref is burns-001jim https://www.baseball-reference.com/r...d=burns-001jim Attached Images __________________ The FGs I did for the Universe Facegen pack if you don't want to download the complete file everytime the pack is updated. The complete set (1871 to 1978) Just the update.

03-28-2022, 09:30 AM	#237
AESP_pres Hall Of Famer Join Date: Jun 2007 Location: Province of Quebec Posts: 4,053	Wrong Historical minor id, his id at BBref is hoffma001fra https://www.baseball-reference.com/r...d=hoffma001fra Attached Images __________________ The FGs I did for the Universe Facegen pack if you don't want to download the complete file everytime the pack is updated. The complete set (1871 to 1978) Just the update.

03-29-2022, 04:18 PM	#238
scarter95 Minors (Rookie Ball) Join Date: Aug 2020 Posts: 34	I sense I'm a pretty simple user of OOTP. I basically play exhibition series matching teams I remember and manage both teams using end-of-season rosters. I have also loaded the game using start-of-season rosters to see if any of these players show up. Here are a few players I noticed missing from specific teams' rosters: Roger Clemens on 2007 Yankees Roger Clemens on 2004 Astros Chico Walker on 1993 Mets Mickey Lolich on 1978 Padres I know I have discovered others randomly but thought I would mention these as OOTP23 is being created/finalized. Thanks for any attention to detail.

03-29-2022, 04:49 PM	#239
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 16,435	scarter95, Clemens did not sign with the Yankees until May 2007, so technically he was not on the opening day roster. The other items on your list have already been fixed in the database. Not sure why they didn't make it into an OOTP22 update. Pretty sure they'll be included in OOTP23, however. Plus, I added Clemens to the OD roster for 2007.

03-30-2022, 01:36 PM	#240
scarter95 Minors (Rookie Ball) Join Date: Aug 2020 Posts: 34	Thank you sir. You guys do a great job on updates.