Historical database issues go here!

[LansdowneSt]

Weight check request on Miguel Batista. OOTP22 has 158 lbs (and 6'0") and bRef has 210 lbs (also 6'0"). Again, discovered when my revised facegen came out ultra-thin once put in the game. Let me know what weight will be in OOTP23 and I'll make a fg that conforms to it. Thanks as always

[LansdowneSt]

Requesting a check on George Zettlein's Historic Minors ID in the game database (zettle000geo) as it is different than the one in bRef (zettle001geo). I know they don't always perfectly align but had presumed that's largely because it takes time to catch all the ones that don't. Let me know if OOTP will align it with bRef and I'll save my new fg for him with the zettle001geo code so it is ready for OOTP23. Thanks

[Lukas Berger]

Originally Posted by LansdowneSt

Requesting a check on George Zettlein's Historic Minors ID in the game database (zettle000geo) as it is different than the one in bRef (zettle001geo). I know they don't always perfectly align but had presumed that's largely because it takes time to catch all the ones that don't. Let me know if OOTP will align it with bRef and I'll save my new fg for him with the zettle001geo code so it is ready for OOTP23. Thanks

There's no hard and fast rule about whether our id conforms with B-Ref or not. Generally I don't really like to change our id's for no reason other that they don't match B-Ref, as the process right now is a bit of a pain and there's always the change of accidently creating some improperly linked records and stats if we miss the id in a specific file.

Once we get the historical and roster db's merged, (which, as I've discussed a bit in the past, is on our to-do list) this sort of thing will be much easier to sort out.

[Lukas Berger]

The stuff mentioned up till the last page or two here should mostly be updated in the next patch we'll have out soon (including for example the Sosa weight, Oh id issues, several of the minors guys who needed to be switched over to African ethnicity etc). The more recent stuff, not so much but it's on my list for 23, including giving the pitchers from 2020 on more pitch ratings as actionjackson pointed out.

[LansdowneSt]

Originally Posted by Lukas Berger

The stuff mentioned up till the last page or two here should mostly be updated in the next patch we'll have out soon (including for example the Sosa weight, Oh id issues, several of the minors guys who needed to be switched over to African ethnicity etc). The more recent stuff, not so much but it's on my list for 23, including giving the pitchers from 2020 on more pitch ratings as actionjackson pointed out.

It's times like this I miss the forum's old "Thank You" button. The attention to detail, the engagement with the community, and the care given to the core product is - compared to any other game I've ever played - unmatched. Thanks, Lukas, for taking the time to review such things and consider database updates/alterations as appropriate.

[actionjackson]

Originally Posted by Lukas Berger

The stuff mentioned up till the last page or two here should mostly be updated in the next patch we'll have out soon (including for example the Sosa weight, Oh id issues, several of the minors guys who needed to be switched over to African ethnicity etc). The more recent stuff, not so much but it's on my list for 23, including giving the pitchers from 2020 on more pitch ratings as actionjackson pointed out.

AHHH YEEEAAAHHH BUUUOOOYYY!!!





I'll probably do my own to cover the gap, but this is great news! I'll then copy over with yours, whenever you can get them out. Thank you sir! This site is an excellent resource for the modern day hurlers, which is the group we're looking for:

https://www.pitcherlist.com/

[actionjackson]

Originally Posted by LansdowneSt

It's times like this I miss the forum's old "Thank You" button. The attention to detail, the engagement with the community, and the care given to the core product is - compared to any other game I've ever played - unmatched. Thanks, Lukas, for taking the time to review such things and consider database updates/alterations as appropriate.

What happened to that feature? Was it getting abused or something? I can't count the number of times I've reached for it, only to be denied. Just wanna say thanks, man.

[actionjackson]

Originally Posted by actionjackson

AHHH YEEEAAAHHH BUUUOOOYYY!!!





I'll probably do my own to cover the gap, but this is great news! I'll then copy over with yours, whenever you can get them out. Thank you sir! This site is an excellent resource for the modern day hurlers, which is the group we're looking for:

https://www.pitcherlist.com/

Also, remember that originally these ratings were set up for a 1 (a pitcher's best pitch) to X (a pitcher's worst pitch - the most pitches I've ever seen is 7 - Carlos Zambrano and others) scale by Spritze. The ones released after OOTPX, have had a 5 (wipeout pitch, compared to other pitchers' pitches) down to 1 (hitter's delight) scale. If that's the direction we're headed in, that's fine, but just remember the way it was set up. It means that pitches with the same number, will be of the same quality, whereas before, they were all of different qualities.

[Lukas Berger]

Originally Posted by actionjackson

What happened to that feature? Was it getting abused or something? I can't count the number of times I've reached for it, only to be denied. Just wanna say thanks, man.

It had a security glitch that could be exploited by bots/hackers

[Lukas Berger]

Originally Posted by actionjackson

Also, remember that originally these ratings were set up for a 1 (a pitcher's best pitch) to X (a pitcher's worst pitch - the most pitches I've ever seen is 7 - Carlos Zambrano and others) scale by Spritze. The ones released after OOTPX, have had a 5 (wipeout pitch, compared to other pitchers' pitches) down to 1 (hitter's delight) scale. If that's the direction we're headed in, that's fine, but just remember the way it was set up. It means that pitches with the same number, will be of the same quality, whereas before, they were all of different qualities.

Yeah, that's one of those things I think changed somewhere along the way and maybe not everything got updated to match correctly. I'll have to talk to Markus about what the better way to do this is and we can probably work on getting everything sorted to match up throughout the db. Might take some time though.

[actionjackson]

Originally Posted by Lukas Berger

Yeah, that's one of those things I think changed somewhere along the way and maybe not everything got updated to match correctly. I'll have to talk to Markus about what the better way to do this is and we can probably work on getting everything sorted to match up throughout the db. Might take some time though.

What happened (I believe) is that Spritze busted his tail to get all of those individual pitch ratings into OOTPX, and used the 1 to X system, and somebody else came along afterwards, and went with a 5 to 1 system. Spritze's is the one I favour, because the game is programmed for it, and there'd be far less work staying with it, as you're talking about 138 seasons worth of pitchers' pitches (1871-2008), versus 13 seasons (2009-2021 by the time OOTP23 comes out) worth of the 5 to 1 pitch ratings. Makes sense to me, but probably sticking with one system is the best course of action. I am somewhat biased towards Spritze though, so keep that in mind.

[actionjackson]

Originally Posted by Lukas Berger

It had a security glitch that could be exploited by bots/hackers

I. Hate. Bots. Dammit, they ruin everything. I mean, seriously, WTH?

[actionjackson]

Obviously the pitches will take time. That's to be expected. It's not an easy process, as I've learned in fumbling around with it.

[actionjackson]

Oye vey Lukas. This one's a bit of a doozy. For the most part (with few exceptions) Fed League guys only have fielding OF stats, if they happened to play in the outfield during their time in that league. No batting stats, no pitching stats, no non-OF fielding stats. Like I said, for the most part. Some of the better players got everything they need, but most of them have nothing if they didn't play the OF. Weird.

[Tony-OH]

Originally Posted by Markus Heinsohn

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. Garlon, Bigrod and Lukas will do their best to respond and to fix any issues.

Thanks for your help in making OOTP better!
Markus

Trying to create a 1989 historical season and only about 8 minor league pitchers and players are imported instead of the entire system. Tried it like three times.

[LansdowneSt]

C/1B/OF Jack O'Connor (19th c.) has the wrong birthday. Imports as June 2nd but that is the birthday of the other Jack O'Connor (early 80's pitcher). Per bRef the position player Jack O was born on the 20th of April. Thanks

https://www.baseball-reference.com/p...;conja01.shtml

[actionjackson]

Originally Posted by LansdowneSt

C/1B/OF Jack O'Connor (19th c.) has the wrong birthday. Imports as June 2nd but that is the birthday of the other Jack O'Connor (early 80's pitcher). Per bRef the position player Jack O was born on the 20th of April. Thanks

https://www.baseball-reference.com/p...;conja01.shtml

Banging away at correcting the errors in my Master.csv file, and then converting it into the monster historical database.odb file. Started with players that debuted from 1871-1900, 'cause that's where I figured the most errors would be. Boy, was I right. I'm up to Bob McHale (mchalbo01, mchale001bob). It's keeping me busy alright. Bit of a slog, but I like to mess around with spreadsheets the way some folks like to mess around with their cars.

I figure that once the AL joined in 1901, the biographical data got cleaned up a whole bunch, so I may just skip that, and accept the occasional mistake or two. There's still so much we don't know about players in the first 30 seasons of the game though, so that'll be my focus.

[Garlon]

Regarding pitch types, that was something I added to the DB many years ago. I used some references like the book The Neyer/James Guide to Pitchers from 2004. The pitch numbers were there to show the pitches each pitcher used and ranked by frequency, not by quality. This has probably not been updated for quite a while.

[actionjackson]

Originally Posted by Garlon

Regarding pitch types, that was something I added to the DB many years ago. I used some references like the book The Neyer/James Guide to Pitchers from 2004. The pitch numbers were there to show the pitches each pitcher used and ranked by frequency, not by quality. This has probably not been updated for quite a while.

I believe it was done that way up to the feature's debut in OOTPX (stats through 2008 season). After that (2009 through 2019...2020 hasn't been done yet, and it, and 2021 will get a workover during the OOTP23 cycle, according to Lukas), just looking it over, it looks like a guestimate by quality versus the rest of the league thing (ranking from 5 to 1). I know this because Bronson Arroyo had like 6 or 7 pitches that were all given 3s, so it's definitely different from the way it was originally done for OOTPX. If it's ranked by frequency, you've just made everybody's lives a whole lot easier, as that info is much easier to get from sources online. Thanks for the clarification sir!

[Lukas Berger]

The updated public beta has those db changes I mentioned above, if you guys want to check it out and make sure everything looks ok.

https://forums.ootpdevelopments.com/...d.php?t=334261