Home | Webstore
Latest News: Update OOTP 19.8 is online - OOTP 19 Available! - MLB Manager 2018 Available Now - FHM 4 Available

OOTP Baseball 19 is Available Now!

  

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 06-22-2013, 10:53 PM   #81
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by EKomrska15 View Post
So I should update the master.csv with the default one to the gambo spritze db i downloaded too?
Umm ask Spritze/Gambo for clarification but his DB should have everyone for 2012. If its a 14 DB. 2011 for 13. If you overwrite the G/S DB with the default you will lose all the Negro league players.

What are you trying to do exactly? Just import Paige into the game using the S/G DB?

This is from one of their DB's
Robert",,180,76,"R","R",1926,1966,"negro","paigesa 01","paigesa01","paigs101","paigesa01","paigesa01" ,6206,2,1,3,6,0,0,5,0,7,0,0,4,149,,,,,,,,,99,118,1 14,99,,,,, I imported Paige into my ABF paigesa01, 1926 He is #3 all time in wins thru 8 seasons.
The Game is offline   Reply With Quote
Old 06-23-2013, 08:27 AM   #82
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,129
Thanks: 100
Thanked 115x in 81 posts
Quote:
Originally Posted by The Game View Post
Umm ask Spritze/Gambo for clarification but his DB should have everyone for 2012. If its a 14 DB. 2011 for 13. If you overwrite the G/S DB with the default you will lose all the Negro league players.

What are you trying to do exactly? Just import Paige into the game using the S/G DB?

This is from one of their DB's
Robert",,180,76,"R","R",1926,1966,"negro","paigesa 01","paigesa01","paigs101","paigesa01","paigesa01" ,6206,2,1,3,6,0,0,5,0,7,0,0,4,149,,,,,,,,,99,118,1 14,99,,,,, I imported Paige into my ABF paigesa01, 1926 He is #3 all time in wins thru 8 seasons.
Well, I want to have full access to all players in the HOF and some are Negro League players.

However, what I did was put the S/G ODB into the 14 but did nothing with S/G master.csv.

Where should I put that? Or should I just refer to that and not put that in the game itself?
EKomrska15 is offline   Reply With Quote
Old 06-23-2013, 11:05 AM   #83
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by EKomrska15 View Post
Well, I want to have full access to all players in the HOF and some are Negro League players.

However, what I did was put the S/G ODB into the 14 but did nothing with S/G master.csv.

Where should I put that? Or should I just refer to that and not put that in the game itself?
I keep mine separate. When I create a new game I go to advanced options
(where you see Show Summary) and point that new game to the DB master.cvs. If i use it for an existing game I copy & paste using ctrl-c & ctrl-v and paste it into the database path in the game ( League setup - Historical for historical game/ Options for fictional) Now I use the master.cvs and neutralized stats for their DB's. I had thought Spritze mentioned something about deleting teh Historical database.odb for use in 14. i am still on 13. So ask him. i will when i get 14 eventually.
The Game is offline   Reply With Quote
Old 06-23-2013, 03:35 PM   #84
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,791
Thanks: 285
Thanked 356x in 289 posts
When using the original DB from Spritze that was supposed to be compatible with OOTP14, my 1928 draft pool showed only 14 players. There were no Negro League players. Then I downloaded the Spritze/Gambo DB OOTP14 v2. Then I put it in the stats folder without changing anything. It includes the historical odb file and the master.csv file. Then I just pointed to the stats folder, not any specific file within that folder.

I just restarted a saved game prior to the 1928 draft pool being selected. Now the new draft pool has 57 players including Negro League player Josh Gibson.
__________________
I found a delivery in my flaw ~ Dan Quisenberry

Road to the Final Four - Lightweights

1946: MLB Revitalized
Jeff1787 is offline   Reply With Quote
Old 06-23-2013, 08:15 PM   #85
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by Jeff1787 View Post
I just restarted a saved game prior to the 1928 draft pool being selected. Now the new draft pool has 57 players including Negro League player Josh Gibson.
Be careful with him. He sucks for his 1st 5-7 seasons. I had Gibson on my Chicago Fire team. Hit .196 avg 4 HR 23 RBI average in 5 seasons for me. i trade him away to Boston for 2 SP prospects. 1st season for The Fightin; Irish he hit .213 12 HR 45 RBI approx. 2nd season his 7th he finally hit over .250 and had 21 HR. 3rd season he finally made the all star team at .313 29 HR 96 RBI for the season. Charles Johnson replaced Gibson as my C and has made 3 consecutive all star games, with 3 GG's.
The Game is offline   Reply With Quote
Old 06-24-2013, 03:37 PM   #86
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,791
Thanks: 285
Thanked 356x in 289 posts
I don't manage the teams the computer does...
__________________
I found a delivery in my flaw ~ Dan Quisenberry

Road to the Final Four - Lightweights

1946: MLB Revitalized
Jeff1787 is offline   Reply With Quote
Old 07-02-2013, 10:33 AM   #87
Carlton
Hall Of Famer
 
Join Date: Mar 2002
Posts: 3,712
Thanks: 436
Thanked 425x in 278 posts
Gambo,
A question sir...since I am doing an historical replay, I am using your Database instead of Spritze's HS...so that player import on their MLB debut

Just so I know ahead of time to attempt not to screw it up

I am using OOTP 13

I download your new DB, overwrite the files in my database (saving those to a sub folder called old DB)

Go into league setting...put in the pathfile to the CSV file...and then I click neutrlized stats? Anything else I need to do?

I also have an issue, because I do not use a draft, (not until 1950) players import in November with their D.O.B. a year late, is there anyway to avoid that?

I mean, I usually go in and correct stamina,injury probability, intangibles and defense for players and to see if they have any good tidbits like 1917 Heinie Stafford of the Giants who could have been a great SS according to McGraw, but wanted a steady job...as a research chemist..

So I do change the date...but it be nice if I didn't have to...since I do miss some

Thank you in advance for your help and for the work on this DB
Carlton is offline   Reply With Quote
Old 07-17-2013, 11:32 AM   #88
korme
Minors (Single A)
 
Join Date: Jun 2006
Location: Dayton OH
Posts: 87
Thanks: 12
Thanked 26x in 14 posts
Using the .odb file, teams never seem to change nicknames or cities, despite me enabling that option in the game startup. For instance, if I start in 1901 and fast sim for 10 years, the Yankees should come into existence. They never do. In '31 the Robins should become the Dodgers, they never do, etc.
korme is offline   Reply With Quote
Old 07-17-2013, 01:14 PM   #89
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by korme View Post
Using the .odb file, teams never seem to change nicknames or cities, despite me enabling that option in the game startup. For instance, if I start in 1901 and fast sim for 10 years, the Yankees should come into existence. They never do. In '31 the Robins should become the Dodgers, they never do, etc.
the .odb has nothing to do with that. Check mark League Evolution.
__________________
9/14/18 My GF's dad passed away. His favorite saying was "Stay Strong"
The Game is offline   Reply With Quote
Old 07-17-2013, 02:26 PM   #90
korme
Minors (Single A)
 
Join Date: Jun 2006
Location: Dayton OH
Posts: 87
Thanks: 12
Thanked 26x in 14 posts
Quote:
Originally Posted by The Game View Post
the .odb has nothing to do with that. Check mark League Evolution.
Can't find any of that stuff in OOTP 14. Did it move from the league setup screen?
korme is offline   Reply With Quote
Old 07-17-2013, 03:20 PM   #91
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by korme View Post
Can't find any of that stuff in OOTP 14. Did it move from the league setup screen?
League setup - Options or Rules. Might have to be in Preseason.
__________________
9/14/18 My GF's dad passed away. His favorite saying was "Stay Strong"
The Game is offline   Reply With Quote
Old 07-18-2013, 12:10 AM   #92
korme
Minors (Single A)
 
Join Date: Jun 2006
Location: Dayton OH
Posts: 87
Thanks: 12
Thanked 26x in 14 posts
Quote:
Originally Posted by The Game View Post
League setup - Options or Rules. Might have to be in Preseason.
No, it's not there. League evolution isn't an option I'm seeing in the new game. Am I the only one here?
korme is offline   Reply With Quote
Old 07-18-2013, 04:56 AM   #93
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by korme View Post
No, it's not there. League evolution isn't an option I'm seeing in the new game. Am I the only one here?
Best I can tell in a historical game it is the Automatically expand league option. i was trying to create a new fictional league to check that but OOTP crashed before it loaded.
Attached Images
Image 
__________________
9/14/18 My GF's dad passed away. His favorite saying was "Stay Strong"
The Game is offline   Reply With Quote
Old 07-20-2013, 03:45 AM   #94
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by Gambo View Post
I would say no.

BTW, I do have a version of my DB available for OOTP14 here...

https://www.box.com/s/d0yhb4dqoisv6doop012

I'll admit it's only been tested to a limited extent...
Just to be clear since i always seem to mess this up. For either DB Spritze or Gambo I would use the Master.cvs not the historical database.odb correct? For both versions do I use real stats or neutralized? Gambo is yours real debut or 18 like Spritze?
__________________
9/14/18 My GF's dad passed away. His favorite saying was "Stay Strong"
The Game is offline   Reply With Quote
Old 07-20-2013, 12:03 PM   #95
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,663
Thanks: 189
Thanked 2,920x in 1,709 posts
Quote:
Originally Posted by The Game View Post
Just to be clear since i always seem to mess this up. For either DB Spritze or Gambo I would use the Master.cvs not the historical database.odb correct?
you can use the included odb unless you want to change things by hand, then you would use the csv's.

Quote:
Originally Posted by The Game View Post
For both versions do I use real stats or neutralized?
Neutered is best.

Quote:
Originally Posted by The Game View Post
Gambo is yours real debut or age 18 like Spritze?
Real, the Spritze db is College or Pro debut, Gambo is Pro debut.
__________________
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:
The Game (07-20-2013)
Old 07-21-2013, 02:32 PM   #96
Nick Soulis
Hall Of Famer
 
Nick Soulis's Avatar
 
Join Date: Feb 2010
Location: Chicago IL
Posts: 2,735
Blog Entries: 2
Thanks: 132
Thanked 239x in 211 posts
This database is almost perfect, thanks for the continual great work. I had a quick question however; Are modern young talents like Puig and Harvey included or will they be in the next release?

Thanks
Nick Soulis is offline   Reply With Quote
Old 07-21-2013, 09:00 PM   #97
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,663
Thanks: 189
Thanked 2,920x in 1,709 posts
Next year. OOTP15
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-22-2013, 08:55 PM   #98
tdmsu
Minors (Rookie Ball)
 
tdmsu's Avatar
 
Join Date: Jun 2011
Posts: 33
Thanks: 51
Thanked 15x in 9 posts
Spritze's db for OOTP14

Thanks for all the hard work on this db!
I have been reading this forum and thinking about ootp for years, and finally took the plunge over the AS break.
I have been running a league with a friend for over 20years using only retired players at their career average level on different programs.
I could just type in all the players again 44 teams worth... But I would love to be able to import the whole historical db instead of one player at a time.
I've been trying today, and ootp says the import worked and the players are all free agents, but there are no players there. I also tried to import into the draft pool with similar results. I'm sure it's something simple that I am missing... Any suggestions?

Thanks either way,
Paul
tdmsu is offline   Reply With Quote
Old 07-22-2013, 09:38 PM   #99
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,010
Thanks: 8,384
Thanked 2,948x in 2,365 posts
Quote:
Originally Posted by tdmsu View Post
Thanks for all the hard work on this db!
I have been reading this forum and thinking about ootp for years, and finally took the plunge over the AS break.
I have been running a league with a friend for over 20years using only retired players at their career average level on different programs.
I could just type in all the players again 44 teams worth... But I would love to be able to import the whole historical db instead of one player at a time.
I've been trying today, and ootp says the import worked and the players are all free agents, but there are no players there. I also tried to import into the draft pool with similar results. I'm sure it's something simple that I am missing... Any suggestions?

Thanks either way,
Paul
You can do more then one player at a time. Create a text file. Use Notepad. enter in the players baseball reference ID plus the year you want to import them from. Example ruthba01,1927 and so on. (really cool cheat double click on that ID and right click copy and paste into the text file)
When you get to the import screen (reopen OOTP so this works this way)
Select the historical databse.odb file (if you are using a custom DB navigate to where it is saved)
Select the text file that you saved all your players on.
Select your options and Draft or FA.
Click import should be good to go.
If you have issues I will post screenshots.
__________________
9/14/18 My GF's dad passed away. His favorite saying was "Stay Strong"
The Game is offline   Reply With Quote
Old 07-22-2013, 10:16 PM   #100
tdmsu
Minors (Rookie Ball)
 
tdmsu's Avatar
 
Join Date: Jun 2011
Posts: 33
Thanks: 51
Thanked 15x in 9 posts
Thanks for the fast reply... Am I limited to choosing one season for each player? OOTP implies that it can average out their career? This is what I mean:


I was hoping that I missed an easy way to do a mass import, but it seems that I have to average them myself, or use baseball-reference?

Thanks again!
Attached Images
Image 
tdmsu 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 10:27 PM.

 

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 - 2018, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments