Spritze DB's for OOTP11 - Page 31

Spritze · 04-25-2015, 10:38 PM

Quote:

Originally Posted by actionjackson

Erisbel Arruebarrena (SS LAD) (arrueer01)
Rusney Castillo (CF BOS) (castiru01)
Bryan Price (P CLE) (pricebr01), not Bryan Price the CIN manager (pricebr99)
Chad Smith (P DET) (smithch08)

:

The Lahman files my database uses as its base are a real mess this year and they have been getting messier over the last few years. I think Mr. Lahmans interests have moved on. Change is good though and he is probably growing in new directions. Next year I plan on rewriting the db to use something else or to use my own database. Until then some players may remain missing for awhile. If these are the only ones missing I can hand enter these 4 (none of these have a batting, pitching or fielding record in Lahman but they are in his Master file) but I am guessing there may be more. I am hoping Mr. Lahman might release a non-beta version of his db in the not too distant future. Until that happens or I find a new data source I am a little bit stuck. Sorry for the inconvenience.

actionjackson · 04-25-2015, 11:26 PM

Quote:

Originally Posted by Spritze

The Lahman files my database uses as its base are a real mess this year and they have been getting messier over the last few years. I think Mr. Lahmans interests have moved on. Change is good though and he is probably growing in new directions. Next year I plan on rewriting the db to use something else or to use my own database. Until then some players may remain missing for awhile. If these are the only ones missing I can hand enter these 4 (none of these have a batting, pitching or fielding record in Lahman but they are in his Master file) but I am guessing there may be more. I am hoping Mr. Lahman might release a non-beta version of his db in the not too distant future. Until that happens or I find a new data source I am a little bit stuck. Sorry for the inconvenience.

Please don't apologize, O Lord of the Databases (TM). The leap forward between the previous one (or the previous, previous one I can't recall which ATM) and this one is astronomical. I'm still going over it and I'm simply blown away. Thank You for all of your effort, which is made all the more remarkable by Mr. Lahman's apparent disappearance from the Realm of the Databases, which you've noted here and above. Should I find anymore missing, I will let you know, but so far I'm amazed at the depth and quality.

actionjackson · 04-25-2015, 11:29 PM

Quote:

Originally Posted by etothep

Now I need to figure out which year I want to start

You can even use this to do random debut historical. The possibilities are endless.

Spritze · 04-25-2015, 11:30 PM

Quote:

Originally Posted by actionjackson

Should I find anymore missing, I will let you know, but so far I'm amazed at the depth and quality.)

Please do let me know if you find anymore. I'll add these 4 by hand tomorrow.

actionjackson · 04-25-2015, 11:47 PM

Quote:

Originally Posted by Spritze

Please do let me know if you find anymore. I'll add these 4 by hand tomorrow.

Those are for sure the only four from the 2014 debut set. At least I'm 99% sure on that. The others should be less problematic because the further back you go with debuts, the less messy Mr. Lahman becomes, as you've noted above. I'll keep an eye out though.

actionjackson · 04-26-2015, 12:48 AM

(master) alvarjo01 = Jose L Alvarez
(master) alvarjo02 = Jose R Alvarez

Not sure if you wanted to do stats for Brad Andress (andrebr99 in the master file). It says in the master file that he should have stats beginning in 1980, but it doesn't mention an end date. Ditto for Pierre Arsenault (arsenpi99 in the master file). His stats are supposed to begin in 1981 with no end date.

Just finished off all the "A" surnames in the master. As you can see, the list is pretty freakin' trivial so far.

Awesome job dude!

Spritze · 04-26-2015, 08:13 AM

I found the rest of the 2014's with challenges (26 more) and fixed them. Mostly pitchers with batting or fielding stats but no pitching stats. A few fielders with no batting stats. Next run will include these updates.

Andress and Arsenault are coaches who never played in the minors or majors and so have no stat record.

Added initials to the Alvarez players

MarkInCincy · 04-26-2015, 08:25 AM

A few other oddities I found, some 'funky' debut ages for debuts after 1901

Spritze · 04-26-2015, 10:30 AM

Quote:

Originally Posted by MarkInCincy

A few other oddities I found, some 'funky' debut ages for debuts after 1901

I'll fix these as well.....fixed only 1 was correct as is, player did begin as a 14 year old. The rest all had incorrect birthdays or debut years

Thanks

actionjackson · 04-26-2015, 02:06 PM

Quote:

Originally Posted by Spritze

I found the rest of the 2014's with challenges (26 more) and fixed them. Mostly pitchers with batting or fielding stats but no pitching stats. A few fielders with no batting stats. Next run will include these updates.

Andress and Arsenault are coaches who never played in the minors or majors and so have no stat record.

Added initials to the Alvarez players

Wow, awesome. Boy was I wrong. Then again, I was only really looking at batting2 and master file. Hard to look at much more for me. I'm a bit slooow.

actionjackson · 04-26-2015, 02:09 PM

Quote:

Originally Posted by Spritze

I'll fix these as well.....fixed only 1 was correct as is, player did begin as a 14 year old. The rest all had incorrect birthdays or debut years

Thanks

14! Who was 14 when they debuted on that list? Holy mother of...Child prodigy?

Spritze · 04-26-2015, 02:17 PM

Quote:

Originally Posted by actionjackson

14! Who was 14 when they debuted on that list? Holy mother of...Child prodigy?

Joe French in the California League. A number of old-timey players started young as well as many old-timey black players. Very few played a lot but quite a number made a brief appearance. Most likely due to a short-handed club that needed local temp help to fill out the necessary 9.

actionjackson · 04-26-2015, 08:00 PM

I've just noticed Christian Yelich has zero fielding stats for 2013, which tends to crash his defensive abilities if you import him in 2014.

(master) adducji01 = Jim D Adduci
(master) adducji02 = Jim C Adduci

Ditto for Dustin Ackley in CF in 2013, no stats = tree stump range. Same for Oswaldo Arcia in LF in 2013. Lots of OF in 2013 have this: Jose A Bautista, Yoenis Cespedes, Yasiel Puig. I doubt I'll be able to track them all down, but you might want to look at 2013 fielding2 stats.

Pitcher Andrew Albers was not given pitching stats for 2013 and enters in 2014 as a LF with zero range and zero hitting ability.

SS Jason Alfaro enters as a RP. I guess he was given too many pitching stats...I got nothing.

(master) carpeda01 = David Carpenter
(master) carpeda02 = David L Carpenter

With regards to the guys with the same names, the OOTP master file did quite a good job of tracking them down this year. I know you work on that too Sir Spritze, but you might want to take a look at it to catch other ones that I may not.

(master) martilu01 = Luis Martinez
(master) martilu02 = Luis M Martinez

Question: When I load up 2014 as a straight historical year, I get a lot of duplicates, mostly Japanese and Korean players (3 Norichika Aokis - two from his Japanese exploits and one from his MLB exploits). Just wonder what's causing this? It won't affect me because I plan to play Random Debut, but it's interesting nonetheless.

RANGER11JP · 04-26-2015, 09:34 PM

Okay, I must have missed something. I downloaded the dropbox DB. I checked the box for historical rookies, but I am getting random debuts. What did I miss?

actionjackson · 04-26-2015, 09:52 PM

Quote:

Originally Posted by RANGER11JP

Okay, I must have missed something. I downloaded the dropbox DB. I checked the box for historical rookies, but I am getting random debuts. What did I miss?

Is the "Use random rookies from all eras" box checked under Game Settings > League Settings > Historical > Historical Rookies Settings? That box needs to be unchecked if you don't want random debut. If it was checked, you'll need to start over again with it unchecked.

MarkInCincy · 04-26-2015, 10:48 PM

Quote:

Originally Posted by Spritze

Joe French in the California League. A number of old-timey players started young as well as many old-timey black players. Very few played a lot but quite a number made a brief appearance. Most likely due to a short-handed club that needed local temp help to fill out the necessary 9.

Then there were the guy that was 80 something and another was somewhere north of 100, like 150 ish or something close...but no fear Spritze will fix it.....

and is it just me or does there seem to be a noticeable increase in RD interest this release/recently???
........

actionjackson · 04-26-2015, 11:08 PM

Quote:

Originally Posted by MarkInCincy

........and is it just me or does there seem to be a noticeable increase in RD interest this release/recently???
........

Personally, I blame that David Watts fellow for spreading the gospel along with his mentor VanillaGorilla.

RANGER11JP · 04-27-2015, 12:02 AM

Quote:

Originally Posted by actionjackson

Is the "Use random rookies from all eras" box checked under Game Settings > League Settings > Historical > Historical Rookies Settings? That box needs to be unchecked if you don't want random debut. If it was checked, you'll need to start over again with it unchecked.

I had the box checked for "automatically import real historical rookies". I was hoping to get my first import in 1856 in my fictional league that started in 1850. So, I am stumped.

Spritze · 04-27-2015, 12:10 AM

Quote:

Originally Posted by MarkInCincy

Then there were the guy that was 80 something and another was somewhere north of 100, like 150 ish or something close...but no fear Spritze will fix it..... Did fix them all

and is it just me or does there seem to be a noticeable increase in RD interest this release/recently???
........

Did fix all the rest

Spritze · 04-27-2015, 12:13 AM

Quote:

Originally Posted by RANGER11JP

I had the box checked for "automatically import real historical rookies". I was hoping to get my first import in 1856 in my fictional league that started in 1850. So, I am stumped.

Does not work until 1871 at the earliest is my sincere belief. Most options don't work well if at all until then.

04-26-2015, 12:48 AM	#606
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,163	(master) alvarjo01 = Jose L Alvarez (master) alvarjo02 = Jose R Alvarez Not sure if you wanted to do stats for Brad Andress (andrebr99 in the master file). It says in the master file that he should have stats beginning in 1980, but it doesn't mention an end date. Ditto for Pierre Arsenault (arsenpi99 in the master file). His stats are supposed to begin in 1981 with no end date. Just finished off all the "A" surnames in the master. As you can see, the list is pretty freakin' trivial so far. Awesome job dude! Last edited by actionjackson; 04-26-2015 at 02:31 AM.

04-26-2015, 08:13 AM	#607
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	I found the rest of the 2014's with challenges (26 more) and fixed them. Mostly pitchers with batting or fielding stats but no pitching stats. A few fielders with no batting stats. Next run will include these updates. Andress and Arsenault are coaches who never played in the minors or majors and so have no stat record. Added initials to the Alvarez players __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 04-26-2015 at 08:25 AM.

04-26-2015, 08:00 PM	#613
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,163	I've just noticed Christian Yelich has zero fielding stats for 2013, which tends to crash his defensive abilities if you import him in 2014. (master) adducji01 = Jim D Adduci (master) adducji02 = Jim C Adduci Ditto for Dustin Ackley in CF in 2013, no stats = tree stump range. Same for Oswaldo Arcia in LF in 2013. Lots of OF in 2013 have this: Jose A Bautista, Yoenis Cespedes, Yasiel Puig. I doubt I'll be able to track them all down, but you might want to look at 2013 fielding2 stats. Pitcher Andrew Albers was not given pitching stats for 2013 and enters in 2014 as a LF with zero range and zero hitting ability. SS Jason Alfaro enters as a RP. I guess he was given too many pitching stats...I got nothing. (master) carpeda01 = David Carpenter (master) carpeda02 = David L Carpenter With regards to the guys with the same names, the OOTP master file did quite a good job of tracking them down this year. I know you work on that too Sir Spritze, but you might want to take a look at it to catch other ones that I may not. (master) martilu01 = Luis Martinez (master) martilu02 = Luis M Martinez Question: When I load up 2014 as a straight historical year, I get a lot of duplicates, mostly Japanese and Korean players (3 Norichika Aokis - two from his Japanese exploits and one from his MLB exploits). Just wonder what's causing this? It won't affect me because I plan to play Random Debut, but it's interesting nonetheless. Last edited by actionjackson; 04-27-2015 at 01:02 AM.

04-26-2015, 09:34 PM	#614
RANGER11JP All Star Starter Join Date: Jun 2002 Posts: 1,363	Okay, I must have missed something. I downloaded the dropbox DB. I checked the box for historical rookies, but I am getting random debuts. What did I miss? __________________ BASEBALL, HOCKEY AND BOXING FAN