Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team is LIVE!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 19 > 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, 10:22 AM   #61
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,363
Thanks: 8,660
Thanked 3,002x in 2,403 posts
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, 12:01 PM   #62
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,356
Thanks: 162
Thanked 900x in 478 posts
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
Thank you for this post:
The Game (04-29-2013)
Old 04-29-2013, 01:27 PM   #63
thehef
All Star Starter
 
Join Date: Jun 2006
Posts: 1,535
Thanks: 784
Thanked 457x in 286 posts
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, 01:57 PM   #64
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
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
Thank you for this post:
thehef (12-09-2013)
Old 05-02-2013, 03:39 PM   #65
Aumakua
Major Leagues
 
Join Date: Apr 2010
Location: Flat lands
Posts: 407
Thanks: 37
Thanked 146x in 88 posts
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, 06:28 PM   #66
ezpkns34
Major Leagues
 
Join Date: Apr 2010
Posts: 438
Thanks: 87
Thanked 162x in 95 posts
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, 09:51 AM   #67
Ty Cobb
All Star Reserve
 
Ty Cobb's Avatar
 
Join Date: Mar 2013
Location: Northern Michigan
Posts: 556
Thanks: 301
Thanked 649x in 212 posts
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 
__________________
"Baseball was one-hundred percent of my life."
Ty Cobb is offline   Reply With Quote
Old 05-24-2013, 04:59 PM   #68
tayloraj
Minors (Double A)
 
tayloraj's Avatar
 
Join Date: Mar 2012
Location: Philadelphia, PA
Posts: 133
Thanks: 75
Thanked 56x in 32 posts
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, 03:11 AM   #69
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
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, 06:44 PM   #70
RMc
All Star Starter
 
RMc's Avatar
 
Join Date: Jan 2004
Posts: 1,017
Thanks: 109
Thanked 154x in 90 posts
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, 09:27 PM   #71
thehef
All Star Starter
 
Join Date: Jun 2006
Posts: 1,535
Thanks: 784
Thanked 457x in 286 posts
Did you remove the .odb file first?
thehef is offline   Reply With Quote
Old 05-30-2013, 01:05 AM   #72
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
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, 12:12 PM   #73
RMc
All Star Starter
 
RMc's Avatar
 
Join Date: Jan 2004
Posts: 1,017
Thanks: 109
Thanked 154x in 90 posts
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, 12:31 PM   #74
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
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, 09:33 AM   #75
RMc
All Star Starter
 
RMc's Avatar
 
Join Date: Jan 2004
Posts: 1,017
Thanks: 109
Thanked 154x in 90 posts
: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, 07:52 PM   #76
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,859
Thanks: 302
Thanked 359x in 292 posts
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
__________________
If you're not practicing, somebody else is, somewhere, and he'll be ready to take your job ~ Brooks Robinson

Road to the Final Four - Lightweights

1946: MLB Revitalized
Jeff1787 is offline   Reply With Quote
Old 06-22-2013, 08:06 AM   #77
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,155
Thanks: 100
Thanked 115x in 81 posts
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, 12:47 PM   #78
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
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, 04:29 PM   #79
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,363
Thanks: 8,660
Thanked 3,002x in 2,403 posts
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, 06:45 PM   #80
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,155
Thanks: 100
Thanked 115x in 81 posts
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 09:49 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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