Home | Webstore
Latest News: OOTP 18.8.76 Update Available - OOTP 18 Available - FHM 4 Available - MLB Manager 2017 Available Now

Offseason Discount: OOTP Baseball 18 is 50% Off!

  

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

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

Reply
 
Thread Tools
Old 09-23-2017, 10:34 PM   #1001
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,980
Thanks: 112
Thanked 2,445x in 1,442 posts
Quote:
Originally Posted by dpd376 View Post
so if i install an earlier version of ootp18 and set the draft for feb.10 and the import for jan.10 it should import correctly right? Do you know which was the last version that imported players a year late instead of not at all?
ootp17
__________________
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:
dpd376 (09-24-2017)
Old 09-24-2017, 03:37 PM   #1002
dpd376
Minors (Single A)
 
Join Date: Dec 2009
Posts: 87
Thanks: 58
Thanked 13x in 11 posts
For some reason I thought it was an earlier build of OOTP18. Thanks.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 10-06-2017, 02:33 PM   #1003
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 17,541
Thanks: 7,701
Thanked 2,760x in 2,213 posts
Spritze, refresh my memory. When using your dB, what changes do i need to make for how stats are imported? Real or Neutralized.
Also any problems with importing players as FA or using historical minor leagues? Also your DB does have Drew Henson, MJ, Brien taylor and others correct?
__________________
I'm a fighter like Rocky
Put you flat on your back like Ali
Yeah, I'm the greatest, I'm stronger
Paid my dues, can't lose, Imma own ya, ay
The Game is offline   Reply With Quote
Old 10-06-2017, 08:28 PM   #1004
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,980
Thanks: 112
Thanked 2,445x in 1,442 posts
Quote:
Originally Posted by The Game View Post
Spritze, refresh my memory. When using your dB, what changes do i need to make for how stats are imported? None Real or Neutralized. They are the same
Also any problems with importing players as FA or using historical minor leagues? No but you will get players in twice Also your DB does have Drew Henson, MJ, Brien taylor and others correct?
So does the historical minors. Really at this point all you get that is not already in the historical minors are Japanese and Korean players
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
2 thanks for this post:
froghair (12-05-2017), The Game (10-14-2017)
Old 10-09-2017, 11:28 AM   #1005
dpd376
Minors (Single A)
 
Join Date: Dec 2009
Posts: 87
Thanks: 58
Thanked 13x in 11 posts
Spritze, are your 18 yr old in the major or minor league databases? Only asking because I'm running a fictional league.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 10-09-2017, 05:13 PM   #1006
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,980
Thanks: 112
Thanked 2,445x in 1,442 posts
There is no Spritze minor league database
__________________
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:
dpd376 (10-09-2017)
Old 10-09-2017, 09:34 PM   #1007
dpd376
Minors (Single A)
 
Join Date: Dec 2009
Posts: 87
Thanks: 58
Thanked 13x in 11 posts
OK, I was confused because there was one in the download.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 10-11-2017, 04:17 PM   #1008
dpd376
Minors (Single A)
 
Join Date: Dec 2009
Posts: 87
Thanks: 58
Thanked 13x in 11 posts
Spritze, would it be possible for you to include your master.csv file, so we can import draft classes manually? Thanks.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Thank you for this post:
mitchkenn (10-11-2017)
Old 10-12-2017, 09:02 PM   #1009
mitchkenn
All Star Starter
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon
Posts: 1,383
Thanks: 834
Thanked 624x in 400 posts
Quote:
Originally Posted by dpd376 View Post
Spritze, would it be possible for you to include your master.csv file, so we can import draft classes manually? Thanks.
i agree. this would be great!
__________________
Before Mays, before DiMaggio, there was Oscar Charleston.
"I'd play for half my salary if I could hit in this dump [Wrigley] all the time." - Babe Ruth
"I don't put no foreign substances on the baseball. Everything I use is from the good old U.S.A." - George Frazier, Yankee pitcher 1981-83
"All the lies about Babe Ruth are true." - Waite Hoyt
Avatar is the great Oscar Charleston.
mitchkenn is offline   Reply With Quote
Old 10-13-2017, 06:41 PM   #1010
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,980
Thanks: 112
Thanked 2,445x in 1,442 posts
https://www.dropbox.com/s/8nrb78y7a1...aster.zip?dl=0
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
5 thanks for this post:
dpd376 (10-14-2017), JT_Dutch (11-21-2017), mitchkenn (10-13-2017), royhobbs (11-21-2017), szathkey (10-14-2017)
Old 10-13-2017, 07:38 PM   #1011
mitchkenn
All Star Starter
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon
Posts: 1,383
Thanks: 834
Thanked 624x in 400 posts
Quote:
Originally Posted by Spritze View Post
many thanks! you da man!!!
__________________
Before Mays, before DiMaggio, there was Oscar Charleston.
"I'd play for half my salary if I could hit in this dump [Wrigley] all the time." - Babe Ruth
"I don't put no foreign substances on the baseball. Everything I use is from the good old U.S.A." - George Frazier, Yankee pitcher 1981-83
"All the lies about Babe Ruth are true." - Waite Hoyt
Avatar is the great Oscar Charleston.

Last edited by mitchkenn; 10-13-2017 at 07:59 PM.
mitchkenn is offline   Reply With Quote
Old 10-14-2017, 10:22 AM   #1012
dpd376
Minors (Single A)
 
Join Date: Dec 2009
Posts: 87
Thanks: 58
Thanked 13x in 11 posts
Quote:
Originally Posted by Spritze View Post
Thanks for all your hard work on the database.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 10-28-2017, 06:10 AM   #1013
lawrence97
Minors (Double A)
 
Join Date: Aug 2008
Location: England
Posts: 123
Thanks: 3
Thanked 16x in 6 posts
Can I ask a really silly question, i'm coming back to this game since 2010....I remember using the gambo db that could import players from age 18 rather than their actual start year....is it the same with this db?? Also great work btw Spritze
lawrence97 is offline   Reply With Quote
Old 10-28-2017, 07:04 PM   #1014
dpd376
Minors (Single A)
 
Join Date: Dec 2009
Posts: 87
Thanks: 58
Thanked 13x in 11 posts
Yes with Asian players added.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James

Last edited by dpd376; 10-28-2017 at 10:12 PM.
dpd376 is offline   Reply With Quote
Thank you for this post:
lawrence97 (10-29-2017)
Old 11-21-2017, 04:14 PM   #1015
royhobbs
Bat Boy
 
Join Date: Oct 2014
Posts: 6
Thanks: 6
Thanked 2x in 2 posts
Thanks

Spritze:

First off, this database is great. The Master.csv you shared is exactly what I've been trying to create (unsuccessfully) by combining the Master.csv and MilbMaster.csv that ship with the game. I really hope you can find the time to update this! But even if not, it is a phenomenal product. A truly master list from which I can create a sublist of players to manually import in a particular year is critical to my league setup. Trying to deduplicate the two CSVs that come with the game is proving too time consuming. Plus, the additional players here are great!

Second, I noticed one thing that I think might be a mistake. Mike Flanagan is listed as having a debut year of 1917. I'm not sure how you set your debut years, but Baseball Reference has him debuting in 1973 at age 21. Given that his birthday was December 16, 1951, does that mean you would have him debut in 1971, the first season during which he was 18?

Thanks!

-Roy
royhobbs is offline   Reply With Quote
Old 11-22-2017, 02:30 PM   #1016
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,980
Thanks: 112
Thanked 2,445x in 1,442 posts
Quote:
Originally Posted by royhobbs View Post

Given that his birthday was December 16, 1951, does that mean you would have him debut in 1971, the first season during which he was 18?
Yes
__________________
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:
royhobbs (11-22-2017)
Old 11-27-2017, 08:41 PM   #1017
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,086
Thanks: 1,365
Thanked 173x in 120 posts
Quote:
Originally Posted by dpd376 View Post
Spritze, would it be possible for you to include your master.csv file, so we can import draft classes manually? Thanks.
So just how do you do that?
__________________
BASEBALL, HOCKEY AND BOXING FAN
VISIT TBCB 2013!...ENTER HERE
VISIT P.I.S.D.!->->->ENTER HERE
RANGER11JP is offline   Reply With Quote
Old 11-27-2017, 09:17 PM   #1018
mitchkenn
All Star Starter
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon
Posts: 1,383
Thanks: 834
Thanked 624x in 400 posts
Quote:
Originally Posted by RANGER11JP View Post
So just how do you do that?
get the player IDs from the csv file, cut/paste into a notepad (or notepad ++) and add ", 1925" (or whatever year) (space between the coma and year - without quotes.) (what i do is after i get the player IDs. i go to the "z" column (at least on my computer) which tells you the year the player debuts in baseball and copy all the players from lets say 1925 - then paste them to notepad ++ and then add the , 1925 after each player and then save that file in a folder that's in my stats file in OOTP documents ... i call that folder "players to import 1925 or players to import 1912 etc.)

here's a bit of what my first few 1925 players would look like:
alliso000moo, 1925
almas-000---, 1925
arango000lui, 1925
Arango049Ped, 1925
Arm Ty049Ste, 1925
Armas049Fel, 1925
backelo41, 1925
baker-003hen, 1925
bakeral01, 1925
baldwi004rob, 1925

when ready to import into the game go to free agents, click on import historical players, make certain Spritze data base is selected .....check box to include historical minors
- click on include file (or something like that. in my game it's highlights in blue.) then find the file where you placed the players from 1925 in note pad. Click on that file and if all goes well, they should import into the next draft class. (i've been using this method for the last year or so and it works well.)
i found through error and trial, not to have auto import historical rookies boxed check in the historical tab if you manually add them, or you'll get doubles of lots of players.

hope this helps, or is what you were asking about... if not, maybe it'll help someone.
__________________
Before Mays, before DiMaggio, there was Oscar Charleston.
"I'd play for half my salary if I could hit in this dump [Wrigley] all the time." - Babe Ruth
"I don't put no foreign substances on the baseball. Everything I use is from the good old U.S.A." - George Frazier, Yankee pitcher 1981-83
"All the lies about Babe Ruth are true." - Waite Hoyt
Avatar is the great Oscar Charleston.

Last edited by mitchkenn; 11-27-2017 at 09:57 PM.
mitchkenn is offline   Reply With Quote
Thank you for this post:
RANGER11JP (12-15-2017)
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 11:47 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 - 2018, vBulletin Solutions, Inc.
Copyright © 2015 Out of the Park Developments