Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

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

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

Reply
 
Thread Tools
Old 07-22-2013, 10:59 PM   #101
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,079
Thanks: 9,073
Thanked 3,069x in 2,450 posts
Quote:
Originally Posted by tdmsu View Post
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!
The base Potential Ratings will give them basically their career averages. Might want to turn Player Development off. League setup - Global Setup.
The year is just the year you want them to start from. You can do rookie year and have them play like an all star from year one with Career on. Remaining years and they develop for the most part as they did IRL. Don't be surprised when players dont live up to RL expectations. Best Ruth ever did for me was 600 or so HR. Best I have seen him at was I think 690 HR.
What do you mean by your last statement? Or did i explain that part?
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Old 07-23-2013, 01:16 AM   #102
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,079
Thanks: 9,073
Thanked 3,069x in 2,450 posts
I am having issues with a league. I started a 1901 league. There are 1157 FA. I have players that retired 10+ seasons ago. I have Max Carey whose rookie season is 1910. Gambo DB, neutralized stats.
Attached Images
Image Image Image 
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Old 07-23-2013, 12:42 PM   #103
tdmsu
Minors (Rookie Ball)
 
tdmsu's Avatar
 
Join Date: Jun 2011
Posts: 33
Thanks: 51
Thanked 15x in 9 posts
Ok. I got it now... I can make a txt file with each team's roster and import them that way... I thought I could just import the whole database of players and then just sign them to teams.
This way is more controlled and keeps the app running smoother, since there won't be many extraneous players.

Thanks for your help!!
tdmsu is offline   Reply With Quote
Old 07-27-2013, 03:09 AM   #104
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
random debut

I download spritze's ootp 14 from his webpage. I want to play a historical career play with random debut. When I go to draft there are no players in the database. What am I doing wrong? I selected random debut.

Last edited by Elysian Fields; 07-27-2013 at 03:21 AM.
Elysian Fields is offline   Reply With Quote
Old 07-27-2013, 03:44 AM   #105
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,079
Thanks: 9,073
Thanked 3,069x in 2,450 posts
Quote:
Originally Posted by Elysian Fields View Post
I download spritze's ootp 14 from his webpage. I want to play a historical career play with random debut. When I go to draft there are no players in the database. What am I doing wrong? I selected random debut.
select import historical rookies also. RD wont work without both checked.
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Thank you for this post:
Elysian Fields (07-27-2013)
Old 07-27-2013, 04:09 AM   #106
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Quote:
Originally Posted by The Game View Post
select import historical rookies also. RD wont work without both checked.
Thanks man. Is it possible to have players random debut all at the first actual debut to start off with? So the players would all be 18 or whatever youthful age.
Elysian Fields is offline   Reply With Quote
Old 07-27-2013, 01:58 PM   #107
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,079
Thanks: 9,073
Thanked 3,069x in 2,450 posts
Quote:
Originally Posted by Elysian Fields View Post
Thanks man. Is it possible to have players random debut all at the first actual debut to start off with? So the players would all be 18 or whatever youthful age.
Start as a fictional league and then after league creation pout the draft date for June (can keep it for NOV) go under League Setup - check import historical rookies & ED and then change the database path under Options to whichever DB you want to use. Another way is to start fictional with draft to debut before the season. delete all active fictional players on draft day then start with 25+ 18 yr old rookies. But everyone did poorly last time I tried that. Highest avg was .280 by Willie Mays.
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Thank you for this post:
Elysian Fields (07-27-2013)
Old 07-27-2013, 02:20 PM   #108
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Quote:
Originally Posted by The Game View Post
select import historical rookies also. RD wont work without both checked.
Stupid question. Where is the select import historical rookies? On historical play/replay setup there is only a box for random debut. Import career history is the other box I'm seeing. Thanks.
Elysian Fields is offline   Reply With Quote
Old 07-27-2013, 04:03 PM   #109
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,079
Thanks: 9,073
Thanked 3,069x in 2,450 posts
Quote:
Originally Posted by Elysian Fields View Post
Stupid question. Where is the select import historical rookies? On historical play/replay setup there is only a box for random debut. Import career history is the other box I'm seeing. Thanks.
This is for a fictional league. For a historical league it is under Historical.
Attached Images
Image 
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Thank you for this post:
Elysian Fields (07-27-2013)
Old 07-27-2013, 04:51 PM   #110
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
the Game,

I see now. I went to that page, but failed to check one of the boxes. Thanks again.
Elysian Fields is offline   Reply With Quote
Old 07-27-2013, 05:19 PM   #111
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
the Game,

I still can't get the players to show in the draft pool. I have both of those boxes clicked. Spritze 14 Database struggles to load up I might add. It goes in and out responding and not responding. When the games loads after about a 10 minute load, it has no players.

Thanks.

Haven't tried Gambo/Spritze database yet. Works fine with normal in-game database. Also Spritze's 14 database works when doing a regular historical start with no random player debuts.

Last edited by Elysian Fields; 07-27-2013 at 07:13 PM.
Elysian Fields is offline   Reply With Quote
Old 07-27-2013, 08:16 PM   #112
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
Quote:
Originally Posted by Elysian Fields View Post
Spritze 14 Database struggles to load up I might add. It goes in and out responding and not responding.
This is abnormal behavior, perhaps the file got corrupted on download? None of the old in and out should be happening and does not when tested on my home computer. It does take about 10 minutes the first time one runs an import in a new game. Subsequent years are much fasterer.
__________________
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:
Elysian Fields (07-27-2013)
Old 07-27-2013, 11:47 PM   #113
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,079
Thanks: 9,073
Thanked 3,069x in 2,450 posts
Quote:
Originally Posted by Elysian Fields View Post
the Game,

I still can't get the players to show in the draft pool. I have both of those boxes clicked. Spritze 14 Database struggles to load up I might add. It goes in and out responding and not responding. When the games loads after about a 10 minute load, it has no players.

Thanks.

Haven't tried Gambo/Spritze database yet. Works fine with normal in-game database. Also Spritze's 14 database works when doing a regular historical start with no random player debuts.
What year are you starting with? When is your draft set for? Did you start as fictional or historical? i will test it myself.
Spritze does your DB require Neutralized stats? for either historical or RD?
I have yet to try either for a RD league on 14.
I use Gambo's for my History of the White Sox league but have had problems which Gambo has yet to respond to.
Loading takes 5-15 mins. Great time to go get some coffee, make lunch take a dump, etc.
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Old 07-27-2013, 11:56 PM   #114
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Quote:
Originally Posted by Spritze View Post
This is abnormal behavior, perhaps the file got corrupted on download? None of the old in and out should be happening and does not when tested on my home computer. It does take about 10 minutes the first time one runs an import in a new game. Subsequent years are much fasterer.
I don't think the file is corrupted. It may have just have been the first time doing the in and out. It's only when trying to start with a historical replay with random debut where no players show up. If I start, say a 1915 season, which I have open right now, everything works fine and looks good.
Elysian Fields is offline   Reply With Quote
Old 07-27-2013, 11:58 PM   #115
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Quote:
Originally Posted by The Game View Post
What year are you starting with? When is your draft set for? Did you start as fictional or historical? i will test it myself.
Spritze does your DB require Neutralized stats? for either historical or RD?
I have yet to try either for a RD league on 14.
I use Gambo's for my History of the White Sox league but have had problems which Gambo has yet to respond to.
Loading takes 5-15 mins. Great time to go get some coffee, make lunch take a dump, etc.
Modern 2005+ and either in 2005 or 2012.

Draft is set to go when the game loads up.

Historical, or custom and then I choose historical replay

Last edited by Elysian Fields; 07-28-2013 at 12:03 AM.
Elysian Fields is offline   Reply With Quote
Old 07-28-2013, 12:01 AM   #116
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Thumbs down

Quote:
Originally Posted by Spritze View Post
This is abnormal behavior, perhaps the file got corrupted on download? None of the old in and out should be happening and does not when tested on my home computer. It does take about 10 minutes the first time one runs an import in a new game. Subsequent years are much fasterer.
I don't think the file is corrupted. It could be, but it works on a regular historical play startup with no random debut. It may have just have been the first time when it did the in and out. It's only when trying to start with a historical replay with random debut where no players show up. If I start, say a 1915 season with no random debut, which I have open right now, everything works fine and looks good.

Last edited by Elysian Fields; 07-28-2013 at 01:50 PM.
Elysian Fields is offline   Reply With Quote
Old 07-28-2013, 01:17 AM   #117
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
I'm not sure OOTP will let you be random in 2012. Try a random but start in 1950. If that works you can try 2000 and creep forward until it don't work.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-28-2013, 05:38 PM   #118
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
I'm just going to un-install and re-install the game. If it is working fine for Spritze it must be something with my files.
Elysian Fields is offline   Reply With Quote
Old 07-30-2013, 03:55 PM   #119
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Best Way to use Spritze's or Gambo/Spritze DB?

In past years I just copied and pasted Spritze's database into the stats folder (having saved the original files first). What's the best setup to use you think?

Also how do you go about importing specific players from one of the databases into a fictional or MLB 2013 league?

Thanks.
Elysian Fields is offline   Reply With Quote
Old 07-31-2013, 07:05 AM   #120
clamel
All Star Reserve
 
Join Date: Apr 2008
Location: Across the Pond
Posts: 895
Thanks: 92
Thanked 46x in 30 posts
Am I correct that this latest version GamboSpritze14v2 doesn´t include players that made their MLB debut during 2012 ??

I had a look at Adam C. Eaton and he wasn´t in the master.csv file.

The new Lahman DB 2012 include this player and of course all players that made their MLB debut for 2012.

If they are not included in 14v2 how do I get them into the game (if I reach the year 2012 soon enough in my game)

I understand that since the odb-file was included mixing and editing by oneself in the master.csv and other important csv-files wasn´t very good.

What is your advice ?

In this Adam C. Eaton case he did start his pro-career in 2010, so getting him in as Gambos DB adjustments must be made to original Lahman DB.

Last edited by clamel; 07-31-2013 at 07:07 AM.
clamel 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 05:06 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 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments