Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 04-25-2015, 10:38 PM   #601
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by actionjackson View Post
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.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-25-2015 at 10:42 PM.
Spritze is offline   Reply With Quote
Old 04-25-2015, 11:26 PM   #602
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
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 is offline   Reply With Quote
Old 04-25-2015, 11:29 PM   #603
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by etothep View Post
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.
actionjackson is offline   Reply With Quote
Old 04-25-2015, 11:30 PM   #604
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by actionjackson View Post
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.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-25-2015, 11:47 PM   #605
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
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 is offline   Reply With Quote
Old 04-26-2015, 12:48 AM   #606
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
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.
actionjackson is offline   Reply With Quote
Old 04-26-2015, 08:13 AM   #607
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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.
Spritze is offline   Reply With Quote
Old 04-26-2015, 08:25 AM   #608
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
A few other oddities I found, some 'funky' debut ages for debuts after 1901
Attached Files
File Type: txt spritz_db_funky_ages.txt (979 Bytes, 102 views)
__________________
"A baseball fan has the digestive apparatus of a billy goat. He can, and does, devour any set of statistics with insatiable appetite and then nuzzles hungrily for more." - Sportswriter Arthur Daley
"Who says there's an unemployment problem in this country? Just take the five percent unemployed and give them a baseball stat to follow." - Outfielder Andy Van Slyke

Last edited by MarkInCincy; 04-26-2015 at 08:40 AM. Reason: EDIT: Looked like crap in line, see attached txt file , csv format
MarkInCincy is offline   Reply With Quote
Old 04-26-2015, 10:30 AM   #609
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by MarkInCincy View Post
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
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-26-2015 at 11:42 AM.
Spritze is offline   Reply With Quote
Old 04-26-2015, 02:06 PM   #610
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
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 is offline   Reply With Quote
Old 04-26-2015, 02:09 PM   #611
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
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?
actionjackson is offline   Reply With Quote
Old 04-26-2015, 02:17 PM   #612
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by actionjackson View Post
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.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-26-2015, 08:00 PM   #613
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
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.
actionjackson is offline   Reply With Quote
Old 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
RANGER11JP is offline   Reply With Quote
Old 04-26-2015, 09:52 PM   #615
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by RANGER11JP View Post
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.

Last edited by actionjackson; 04-26-2015 at 09:53 PM.
actionjackson is offline   Reply With Quote
Old 04-26-2015, 10:48 PM   #616
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Quote:
Originally Posted by Spritze View Post
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???
........
__________________
"A baseball fan has the digestive apparatus of a billy goat. He can, and does, devour any set of statistics with insatiable appetite and then nuzzles hungrily for more." - Sportswriter Arthur Daley
"Who says there's an unemployment problem in this country? Just take the five percent unemployed and give them a baseball stat to follow." - Outfielder Andy Van Slyke
MarkInCincy is offline   Reply With Quote
Old 04-26-2015, 11:08 PM   #617
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by MarkInCincy View Post
........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.
actionjackson is offline   Reply With Quote
Old 04-27-2015, 12:02 AM   #618
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by actionjackson View Post
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.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 04-27-2015, 12:10 AM   #619
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by MarkInCincy View Post
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
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-27-2015, 12:13 AM   #620
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
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.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:35 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments