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
Register Blogs FAQ Calendar Today's Posts Search

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: 30,807
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?
__________________
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 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: 30,807
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 
__________________
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 07-23-2013, 12:42 PM   #103
tdmsu
Minors (Rookie Ball)
 
tdmsu's Avatar
 
Join Date: Jun 2011
Posts: 44
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: 470
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: 30,807
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.
__________________
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 07-27-2013, 04:09 AM   #106
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 470
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: 30,807
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.
__________________
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 07-27-2013, 02:20 PM   #108
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 470
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: 30,807
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 
__________________
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 07-27-2013, 04:51 PM   #110
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 470
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: 470
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: Bothell Wa
Posts: 7,254
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
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: 30,807
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.
__________________
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 07-27-2013, 11:56 PM   #114
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 470
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: 470
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: 470
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: Bothell Wa
Posts: 7,254
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: 470
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: 470
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 Starter
 
Join Date: Apr 2008
Location: Across the Pond
Posts: 1,033
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


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:45 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