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

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: Bothell Wa
Posts: 7,254
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
Old 09-24-2017, 03:37 PM   #1002
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 104
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: 30,766
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?
__________________
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 10-06-2017, 08:28 PM   #1004
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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
Old 10-09-2017, 11:28 AM   #1005
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 104
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: Bothell Wa
Posts: 7,254
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
Old 10-09-2017, 09:34 PM   #1007
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 104
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 (Double A)
 
Join Date: Dec 2009
Posts: 104
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
Old 10-12-2017, 09:02 PM   #1009
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
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!
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
"Hello darkness, my old Friend ...." - Paul Simon
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.
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: Bothell Wa
Posts: 7,254
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
Old 10-13-2017, 07:38 PM   #1011
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
Quote:
Originally Posted by Spritze View Post
many thanks! you da man!!!
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
"Hello darkness, my old Friend ...." - Paul Simon
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.

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 (Double A)
 
Join Date: Dec 2009
Posts: 104
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: 173
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 (Double A)
 
Join Date: Dec 2009
Posts: 104
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
Old 11-21-2017, 04:14 PM   #1015
royhobbs
Bat Boy
 
Join Date: Oct 2014
Posts: 6
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: Bothell Wa
Posts: 7,254
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
Old 11-27-2017, 08:41 PM   #1017
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,353
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
RANGER11JP is offline   Reply With Quote
Old 11-27-2017, 09:17 PM   #1018
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
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.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
"Hello darkness, my old Friend ...." - Paul Simon
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.

Last edited by mitchkenn; 11-27-2017 at 09:57 PM.
mitchkenn is offline   Reply With Quote
Old 03-14-2018, 02:17 PM   #1019
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
Quote:
Originally Posted by Spritze View Post
Late to the party. This file (master file for Spritze's latest masterpiece) seems to have disappeared from dropbox. Any idea where to get it? Or do any of you have Dropbox that would be willing to share with your soon to be best friend.

Last edited by actionjackson; 03-14-2018 at 02:18 PM.
actionjackson is offline   Reply With Quote
Old 03-14-2018, 02:39 PM   #1020
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
The master.csv contains some OOTP propriatry information now. I will be making three Masters for the 3 databases that will only contain player names, ID's, debut dates, career end dates. These will appear a few days after the game comes out.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze 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:31 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