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 01-14-2014, 02:44 PM   #161
txranger
Hall Of Famer
 
txranger's Avatar
 
Join Date: Dec 2008
Location: "Deep in the Heart Of"
Posts: 8,308
Your answer, you may find, if here you look...


http://www.ootpdevelopments.com/boar...ml#post3620557
__________________
https://drive.google.com/drive/folders/0BxdZAtwhTM3_ZUZHQlVqZGpYM0k?resourcekey=0-H3gEmEfFFsfLLEGvioYC2Q&usp=sharing









Last edited by txranger; 01-14-2014 at 05:53 PM.
txranger is offline   Reply With Quote
Old 01-18-2014, 04:49 PM   #162
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
the ootp community wiki has a page for both the last spritze db (and a download for the last DB I have)

OOTP Community Wiki | Spritze's db for OOTP14

and it has a page for gambo's (but not much of one I admit) it does have links to the page at ootpmods to download

OOTP Community Wiki | Spritze's-Gambo db for OOTP14

plus a spritze vs. gambo db page. hopefully some people join and make them, and the whole thing, useable
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 04-09-2014 at 12:38 AM.
jazzrack is offline   Reply With Quote
Old 01-18-2014, 05:51 PM   #163
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
Wow that page makes me sound harsh!

If anybody wants any clarification...

Even as part of the beta team I'm not in loop as to the changes made to how the game reads the database. It caused some hiccups as to what information I needed to include or not and also some of the formatting. It was cool when I could just plug in some updated data each season and run with it.

Spritze is more knowledgeable and can quickly make changes to his database. Since I use his information and stats for most of my database, the minute he comes up with an update mine is obsolete in comparison.

I also have found as my kids get older I have less time to keep up. This both affected my database and my style of play. I found that spritzes hs database accomplished what I am looking to get out if OOTP at this point. (Well that and fictional).
__________________
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 01-18-2014, 06:02 PM   #164
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Quote:
Originally Posted by Gambo View Post
Wow that page makes me sound harsh!

If anybody wants any clarification...

Even as part of the beta team I'm not in loop as to the changes made to how the game reads the database. It caused some hiccups as to what information I needed to include or not and also some of the formatting. It was cool when I could just plug in some updated data each season and run with it.

Spritze is more knowledgeable and can quickly make changes to his database. Since I use his information and stats for most of my database, the minute he comes up with an update mine is obsolete in comparison.

I also have found as my kids get older I have less time to keep up. This both affected my database and my style of play. I found that spritzes hs database accomplished what I am looking to get out if OOTP at this point. (Well that and fictional).
only because you guys stopped including readme's to copy and paste from

I'll get around to improving it some if somebody doesn't get to it first, but I figured I might as well start with what I use, but feel free to edit it. the passcode to join is ootp (keeps the bots out)
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 01-18-2014 at 06:06 PM.
jazzrack is offline   Reply With Quote
Old 01-18-2014, 09:26 PM   #165
thehef
Hall Of Famer
 
Join Date: Jun 2006
Posts: 5,345
I don't know if this - http://www.ootpdevelopments.com/boar...t-summary.html - would be helpful or not, and I'm sure it's not quite 100% accurate...
thehef is offline   Reply With Quote
Old 01-19-2014, 12:24 AM   #166
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Quote:
Originally Posted by thehef View Post
I don't know if this - http://www.ootpdevelopments.com/boar...t-summary.html - would be helpful or not, and I'm sure it's not quite 100% accurate...
as of now it's the most helpful page on the wiki, by a bit.

OOTP Community Wiki | Historical Databases - summary
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 04-09-2014 at 12:39 AM.
jazzrack is offline   Reply With Quote
Old 01-19-2014, 01:00 AM   #167
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Quote:
Originally Posted by Gambo View Post
Wow that page makes me sound harsh!

If anybody wants any clarification...

Even as part of the beta team I'm not in loop as to the changes made to how the game reads the database. It caused some hiccups as to what information I needed to include or not and also some of the formatting. It was cool when I could just plug in some updated data each season and run with it.

Spritze is more knowledgeable and can quickly make changes to his database. Since I use his information and stats for most of my database, the minute he comes up with an update mine is obsolete in comparison.

I also have found as my kids get older I have less time to keep up. This both affected my database and my style of play. I found that spritzes hs database accomplished what I am looking to get out if OOTP at this point. (Well that and fictional).
I edited the wiki page with that post instead
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Old 01-19-2014, 10:24 AM   #168
dcundy
Minors (Single A)
 
Join Date: Nov 2002
Posts: 71
odb file for OOTP 14

Not sure if this is best place to ask this but I herd somewhere that the .odb file is not necessary for OOTP. The reason I ask this is because I modified SpritzHS db for 14 and removed the .odb files and started a using it in historical replay. But for the second time the game just froze around the beginning of a new season. Any help with this would be greatly appreciated.
dcundy is offline   Reply With Quote
Old 01-19-2014, 11:07 AM   #169
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by dcundy View Post
Not sure if this is best place to ask this but I herd somewhere that the .odb file is not necessary for OOTP. The reason I ask this is because I modified SpritzHS db for 14 and removed the .odb files and started a using it in historical replay. But for the second time the game just froze around the beginning of a new season. Any help with this would be greatly appreciated.
I asked him the same question 2 weeks ago. You do need it.
__________________
Go today don't wait for tomorrow
It isn't promised, all the time you get borrowed
Don't live your life for other people
Don't bottle your emotions till they crack and fill a couple just sorrows
Take your mind and refocus go get a paper write your goals out
Throw your middle fingers to all your haters


"Stay Strong"


The Game is offline   Reply With Quote
Old 01-19-2014, 11:48 AM   #170
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The odb file is required UNLESS you are importing players individually. Then you must rename it while you are importing and put it back when done. The odb file is an OOTP compiled form of all the csv files. Without it historical leagues won't load if the individual csv's are too large.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 01-19-2014, 11:55 PM   #171
thehef
Hall Of Famer
 
Join Date: Jun 2006
Posts: 5,345
Quote:
Originally Posted by Spritze View Post
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.
So the above is no longer valid? If using a modded db - one without an odb file - in historical mode/setup - it's a no-can-do?

I am attempting a test and will report back.
thehef is offline   Reply With Quote
Old 01-20-2014, 12:19 AM   #172
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by thehef View Post
If using a modded db - one without an odb file - in historical mode/setup - it's a no-can-do?
Depends on the size of the csv's and whether you try to load any history for the new game. If it works it is small enough, if it don't it aint. If history loads then it is all good, if it don't then it ain't good either.

I don't know where the size/history cut off is. I just know that is the reason the odb exists.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 01-23-2014, 10:02 AM   #173
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,529
I'm having the hardest time importing Martin Dihigo.

I've tried his identifier Dihigma00 but not sure what year I should import as his first year. Basically my league individually imports a random Hall of Famer from the S/G database in their first year in the major leagues.

I'm using the master.csv but keep it separate on my desktop but still point the game to it.

Edit: Nevermind I got him at a later date!


Thanks!

Last edited by EKomrska15; 01-23-2014 at 10:40 AM.
EKomrska15 is offline   Reply With Quote
Old 01-23-2014, 10:58 AM   #174
txranger
Hall Of Famer
 
txranger's Avatar
 
Join Date: Dec 2008
Location: "Deep in the Heart Of"
Posts: 8,308
Quote:
Originally Posted by EKomrska15 View Post
I'm having the hardest time importing Martin Dihigo.

I've tried his identifier Dihigma00 but not sure what year I should import as his first year. Basically my league individually imports a random Hall of Famer from the S/G database in their first year in the major leagues.

I'm using the master.csv but keep it separate on my desktop but still point the game to it.

Edit: Nevermind I got him at a later date!


Thanks!

I got him to import at age 16 in 1922... Seems like I had problems with getting him to import in previous league, not this time though...
__________________
https://drive.google.com/drive/folders/0BxdZAtwhTM3_ZUZHQlVqZGpYM0k?resourcekey=0-H3gEmEfFFsfLLEGvioYC2Q&usp=sharing








txranger is offline   Reply With Quote
Old 01-23-2014, 12:48 PM   #175
dcundy
Minors (Single A)
 
Join Date: Nov 2002
Posts: 71
modified database for OOTP14

I modified the heck out of spritze HS database for OOTP14. I limited the files just to include only the players from CTWATBL's (sorry if I got the name wrong) greatest players quick start. This made the files much smaller. Then modified all the debut years to only include 1910 - 1946. That way I can have all the best players of all time play from 1910 to 1966 or so. Kind of a condensed all time career league. It was hard at first making sure all teams had enough players while trying to keep players on there actual rookie year teams but it has been fun. Only nine years in now but so far so good. This years rookie crop included Ted Williams, Joe DiMaggio, Lefty Gomez, Bob Feller and others. Ruth was rookie of the year in 1914 pitching for the Red Sox. Grove won in 1915. Paul Waner won it in 1917. Mathewson has the most wins with 231 with 9 years of playing time. In 1919 Ruth is 25 yrs old, Williams is 18, and Mathewson is 32.

(By limiting the database I don't find some dude that only played 10 games in real life leading the darn league in wins after playing 10 years.)

I have been getting an error message every now and then because the game can't find the odb file which I deleted. But I just ignore and move on. So far the stats are looking pretty good. Just checked the historical simulation accuracy and all the numbers are green and have been in every year except year 1. It seems every time I do any historical replay the 1st year seems to be out of wack but I make some minor adjustments and things get back to normal by the end of the year.

Another thing that is not working correctly with this database is the rookies do not go to their respective rookie teams. But I get around this by monitoring the draft. The largest draft so far only had about 200 players. I make sure the top rookies go where they belong then auto draft the rest.

As for the untouchable players on the rosters I keep it pretty low at only 12 per team. I have no problem with mixing it up a little. That seems to reduce some of the rediculious trades the AI makes.

Wanted to use the latest version of the game because I like the new playoff screen and the new simulation mode. I like the 120 setting while watching the championship series. Sorry for the ramble… Just thought I'd share that it just maybe possible to modify a current database without messing with the .odb files.
dcundy is offline   Reply With Quote
Old 01-24-2014, 10:41 AM   #176
George_Bell
All Star Starter
 
George_Bell's Avatar
 
Join Date: Dec 2013
Posts: 1,988
I started a dynasty using the Spritze-Gambo Database. I started in 1901 and i wanted to include negro league players, guys who never made it and some Japanese players like the description says.

I'm now in 1913, and i have not noticed any of these players in my league so far.

A few questions.

1. I downloaded the file, and copied it contents to the stats folder, which is the destination ootp has as the location. Correct?

2. I tried to manually import Rube Foster, and after finding is code, every time he imports, he's terrible, at any age. Am I doing this right?

3. What could i be doing wrong? I'm not getting any of the non mlb players i hoped for? Could I have screwed up neutralized stats? Can i change something at this point?

Any help would be amazing
thanks!
George_Bell is offline   Reply With Quote
Old 01-24-2014, 11:16 AM   #177
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by George_Bell View Post
I started a dynasty using the Spritze-Gambo Database. I started in 1901 and i wanted to include negro league players, guys who never made it and some Japanese players like the description says.

I'm now in 1913, and i have not noticed any of these players in my league so far.

A few questions.

1. I downloaded the file, and copied it contents to the stats folder, which is the destination ootp has as the location. Correct?

2. I tried to manually import Rube Foster, and after finding is code, every time he imports, he's terrible, at any age. Am I doing this right?

3. What could i be doing wrong? I'm not getting any of the non mlb players i hoped for? Could I have screwed up neutralized stats? Can i change something at this point?

Any help would be amazing
thanks!
I am in 1909 and have a handful of Negro leaguers, and tons of player who i have no clue who they are but they are real.
Move the .ODB from the stats file when you import or rename it. I tried importing Tanaka for someone to see what he would look like and Spritze told me to rename the .ODB. I was going to move it out of the folder and move it back when I was done.
Can you post a SS of you historical screen? Maybe Spritze will answer quickly and have a different fix.
__________________
Go today don't wait for tomorrow
It isn't promised, all the time you get borrowed
Don't live your life for other people
Don't bottle your emotions till they crack and fill a couple just sorrows
Take your mind and refocus go get a paper write your goals out
Throw your middle fingers to all your haters


"Stay Strong"


The Game is offline   Reply With Quote
Old 01-24-2014, 11:42 AM   #178
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
Quote:
Originally Posted by George_Bell View Post
I started a dynasty using the Spritze-Gambo Database. I started in 1901 and i wanted to include negro league players, guys who never made it and some Japanese players like the description says.

I'm now in 1913, and i have not noticed any of these players in my league so far.

A few questions.

1. I downloaded the file, and copied it contents to the stats folder, which is the destination ootp has as the location. Correct?

2. I tried to manually import Rube Foster, and after finding is code, every time he imports, he's terrible, at any age. Am I doing this right?

3. What could i be doing wrong? I'm not getting any of the non mlb players i hoped for? Could I have screwed up neutralized stats? Can i change something at this point?

Any help would be amazing
thanks!
Hmmm....

Make sure you move this .odb file into the directory. If you are not using the Ga/Sp.odb remove it. (The game defaults to the .odb file if it is in the directory). Other than that, make sure neutralized stats is selected in the options. If you use real stats the negro/japan/minor guys will be bad because they have no "real" stats.
__________________
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 01-24-2014, 01:55 PM   #179
George_Bell
All Star Starter
 
George_Bell's Avatar
 
Join Date: Dec 2013
Posts: 1,988
OK, i think i have done everything you guys have suggested but for 1.

I don't remember if i choose neutralized stats, and i obviously want to check, change it. I've looked but don't see where i can change of even see that option. Any idea where it could be?

Thanks
George_Bell is offline   Reply With Quote
Old 01-24-2014, 02:04 PM   #180
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The odb file is required UNLESS you are importing players individually. Then you must rename it while you are importing and put it back when done. The odb file is an OOTP compiled form of all the csv files. Without it historical leagues won't load if the individual csv's are too large.

Neutered stats are chosen at league creation.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 01-24-2014 at 02:05 PM.
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 05:30 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