Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > 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-29-2013, 09:22 AM   #61
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,803
Gambo or Spritz will the new DB's work with 13? I am guessing yes but wanted to be sure.
The Game is offline   Reply With Quote
Old 04-29-2013, 11:01 AM   #62
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
Quote:
Originally Posted by The Game View Post
Gambo or Spritz will the new DB's work with 13? I am guessing yes but wanted to be sure.
Yes it should.
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 04-29-2013, 12:27 PM   #63
thehef
Hall Of Famer
 
Join Date: Jun 2006
Posts: 4,838
Ok, based upon my understanding...

OOTP 12 - Any db with an ODB file or a properly-formatted set of csv files can be used... This is based upon my experience with v12.

OOTP 13 - Only a ODB db can be used... This is based upon info in this thread http://www.ootpdevelopments.com/boar...itze-s-db.html, and this one http://www.ootpdevelopments.com/boar...e-gambo-2.html.

OOTP 14 - Same as v12. Meaning, in my case, where I have created my own db (a set of csv files; IIRC, I wanted a combo of neutralized players importing to their original teams at the time of their MLB debut, but also wanted Negro leaguers a bunch of career minor leaguers; something like that), I will have no problem... This is based upon Gambo's reply in this thread, immediately above... So on this I just wanted to clarify that the modded db that I use in v12 - which does not include an ODB file - should work if I convert to v14 (and I should also have no problems with the interim step of converting to v13 before immediately converting the v14).

Sorry to beat on this poor dead horse, but I just wanted to be clear for my and anyone else's benefit ;-) Thanks
thehef is offline   Reply With Quote
Old 04-29-2013, 12:57 PM   #64
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
12, 13 and 14 all use the same CSV file formats so db's are interchangeably interchangeable.

ODB's are not interchangeable and generally can be removed.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-02-2013, 02:39 PM   #65
Aumakua
Major Leagues
 
Join Date: Apr 2010
Location: Flat lands
Posts: 421
Quote:
Originally Posted by Gambo View Post
You got it.

I also hav done the same thing but what I typically do is delete the lines after the player got hurt. This allows the game engine to take over and the player will develop accordingly.

And an FYI in case u didn't notice the park factor issue was fixed in the patch

So if a player only played 10 seasons and was really good in all 10, retired at 32, and you import him using "career totals" how would their potential compare to a similar player who played 20 seasons and has much higher overall stat totals? would they be rated similar or would the player with higher overall stat totals be rated higher?

I guess I am wondering how OOTP view "career totals", do they look at it as per season or just flat out the higher the stat totals the better the potential will be?
Aumakua is offline   Reply With Quote
Old 05-12-2013, 05:28 PM   #66
ezpkns34
All Star Reserve
 
Join Date: Apr 2010
Posts: 693
Love these since I prefer starting in older seasons

However, seems like all the historical rookies come in ready for at least AA which kind of makes R & A pointless (& makes good veterans secondary options when they shouldn't be). Is this something I can alter with the player creation modifiers?
ezpkns34 is offline   Reply With Quote
Old 05-20-2013, 08:51 AM   #67
Ty Cobb
Hall Of Famer
 
Ty Cobb's Avatar
 
Join Date: Mar 2013
Location: Grayling, MI
Posts: 3,941
Blog Entries: 65
Error in DB

Was just perusing players for a trade when I noticed Kiki Cuyler listed as born in Harrisville, UT. Actually, Harrisville is in Northern Michigan, about 80 miles from me. You can still have dinner at Cuyler's restaurant there, though since the slamon are no longer planted there, it isn't the destination it once was.
Attached Images
Image 
__________________

“What’s the most you ever lost on a coin toss?”

“Everyone is an atheist until Templars begin marching in the rain.”
Absinthe makes the heart grow fonder.
Society's tolerance for violent criminals is dumbfounding.
"Colonics for EVERYONE!"
Ty Cobb is offline   Reply With Quote
Old 05-24-2013, 03:59 PM   #68
tayloraj
Minors (Double A)
 
tayloraj's Avatar
 
Join Date: Mar 2012
Location: Philadelphia, PA
Posts: 162
Quote:
Originally Posted by Ty Cobb View Post
Was just perusing players for a trade when I noticed Kiki Cuyler listed as born in Harrisville, UT. Actually, Harrisville is in Northern Michigan, about 80 miles from me. You can still have dinner at Cuyler's restaurant there, though since the slamon are no longer planted there, it isn't the destination it once was.
This is actually a pretty common issue with any of the DBs available for OOTP, both the standard historical DB that ships with the game or any of the custom ones; I think it's partly a function of not all municipalities in the US being part of the game's database (which explains why the game says Ty Cobb was born in Narrows, Virginia instead of Narrows, Georgia. I also don't believe that Harrisville, Michigan is in the game; I make a semi-concerted effort to correct player birthplaces in my historical leagues and I've definitely tried to modify his before) but there are plenty of cases where players are simply listed in the wrong state despite the availability of the proper municipality. Does anyone know how birthplaces are assigned in the databases?
tayloraj is offline   Reply With Quote
Old 05-25-2013, 02:11 AM   #69
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by tayloraj View Post
Does anyone know how birthplaces are assigned in the databases?
For the Spritze db's it is the Lahman master.csv file.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-28-2013, 05:44 PM   #70
RMc
All Star Starter
 
RMc's Avatar
 
Join Date: Jan 2004
Posts: 1,418
Can't load Spritze DB into game

This is embarrassing, because I know I've gotten this right before, but...I'm trying to start a historical fictional game starting in 1871, but I can't seem to get the new Spritze DB going properly. I set up the game, point it to the correct db (NOT the one in the stats folder), and instead of the expanded group of players, I get the standard 115 guys who actually played in the NA that year.

Li'l help?
__________________
"We're all behind our baseball team..."
RMc is offline   Reply With Quote
Old 05-29-2013, 08:27 PM   #71
thehef
Hall Of Famer
 
Join Date: Jun 2006
Posts: 4,838
Did you remove the .odb file first?
thehef is offline   Reply With Quote
Old 05-30-2013, 12:05 AM   #72
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Must choose neutered stats not "real" since their ain't nuthin' strictly real.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-30-2013, 11:12 AM   #73
RMc
All Star Starter
 
RMc's Avatar
 
Join Date: Jan 2004
Posts: 1,418
Did you remove the .odb file first?

Remove it from where, the 'Spritze for OOTP14' file or someplace else?
__________________
"We're all behind our baseball team..."
RMc is offline   Reply With Quote
Old 05-30-2013, 11:31 AM   #74
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
The Spritze db comes with it's own ODB file so you don't need to remove it unless you'd like to.

There is an odb file in the stats folder that comes with the game. I believe that is the one the posterizer is referring to.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-31-2013, 08:33 AM   #75
RMc
All Star Starter
 
RMc's Avatar
 
Join Date: Jan 2004
Posts: 1,418
:confused:

Why would I need to remove the .odb file from the stats folder if I'm not pointing to game to the stats folder in the first place?
__________________
"We're all behind our baseball team..."
RMc is offline   Reply With Quote
Old 06-21-2013, 06:52 PM   #76
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,419
Spritze:

I just started 1928 and for the game only imported 14 players for the draft pool. I have OOTP14 and I am using your High School DB. What I am doing wrong?

Thanks, Jeff
Jeff1787 is offline   Reply With Quote
Old 06-22-2013, 07:06 AM   #77
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,477
So here is what I'm trying to do....

Import players that are in the HOF maybe 1-2 per year in my fictional league.

I'm importing most okay, however, when it comes to Satchel Paige or other players from the Negro Leagues I'm having trouble with their identifier. If I type in his baseball reference id it says failed.

What am I doing wrong?
EKomrska15 is offline   Reply With Quote
Old 06-22-2013, 11:47 AM   #78
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Lahman ID not B-R ID

Look in the Master.csv for the ID's
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-22-2013, 03:29 PM   #79
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,803
Quote:
Originally Posted by EKomrska15 View Post
So here is what I'm trying to do....

Import players that are in the HOF maybe 1-2 per year in my fictional league.

I'm importing most okay, however, when it comes to Satchel Paige or other players from the Negro Leagues I'm having trouble with their identifier. If I type in his baseball reference id it says failed.

What am I doing wrong?
paige I belive is paigesa01,1926 If that doesn't work let me know i have Paige Gibson & Buck O'Neill in my ABF. I will check them in game, but if you do a Find of Paige in Sprtize DB master.cvs it will eventually find him
The Game is offline   Reply With Quote
Old 06-22-2013, 05:45 PM   #80
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,477
Quote:
Originally Posted by The Game View Post
paige I belive is paigesa01,1926 If that doesn't work let me know i have Paige Gibson & Buck O'Neill in my ABF. I will check them in game, but if you do a Find of Paige in Sprtize DB master.cvs it will eventually find him
So I should update the master.csv with the default one to the gambo spritze db i downloaded too?
EKomrska15 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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 02:38 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 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments