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

SUMMER SALE - OOTP and FHM are 50% off!

  

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 04-02-2018, 02:07 PM   #61
Eamus Catuli
Minors (Single A)
 
Join Date: Mar 2009
Posts: 70
Thanks: 30
Thanked 4x in 4 posts
is this database still available and if so where can I find it? Will it work in 19?
Eamus Catuli is offline   Reply With Quote
Old 04-02-2018, 03:58 PM   #62
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,298
Thanks: 1,374
Thanked 1,174x in 750 posts
the Negro league players that were in the Spritze database, are now in OOTP minor league database. Just need to have historical minors enabled to have them appear.
__________________
"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
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
2 thanks for this post:
Eamus Catuli (04-03-2018), RANGER11JP (04-02-2018)
Old 04-27-2018, 10:41 AM   #63
nokmirt
Minors (Rookie Ball)
 
Join Date: Mar 2016
Posts: 48
Thanks: 1
Thanked 10x in 7 posts
Quote:
Originally Posted by mitchkenn View Post
the Negro league players that were in the Spritze database, are now in OOTP minor league database. Just need to have historical minors enabled to have them appear.
How come some player ratings are garbage? I tried to import Rube Foster from 1911. He can't pitch himself out of a wet paper bag. The man would roll over in his grave if he saw these ratings.

Then I tried to find an updated Spritze database to add him from the mlb database, and I cannot find a download anywhere. I did find one for OOTP 16, but it keeps telling me the file is corrupt. In any case right now I am stuck. In OOTP 19 there is a master.csv, but it will not import fosteru99h. It keeps saying the import failed. I am so annoyed right now.

Last edited by nokmirt; 04-27-2018 at 10:49 AM.
nokmirt is offline   Reply With Quote
Old 04-27-2018, 11:02 AM   #64
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,298
Thanks: 1,374
Thanked 1,174x in 750 posts
latest spritze db is still available. yes, it works in 19, it's what i am using currently. a little searching:

http://www.ootpdevelopments.com/boar...&postcount=989


foster002rub - from spritze db
__________________
"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
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; 04-27-2018 at 11:27 AM.
mitchkenn is offline   Reply With Quote
Thank you for this post:
RANGER11JP (04-27-2018)
Old 04-27-2018, 01:00 PM   #65
nokmirt
Minors (Rookie Ball)
 
Join Date: Mar 2016
Posts: 48
Thanks: 1
Thanked 10x in 7 posts
Quote:
Originally Posted by mitchkenn View Post
latest spritze db is still available. yes, it works in 19, it's what i am using currently. a little searching:

http://www.ootpdevelopments.com/boar...&postcount=989


foster002rub - from spritze db
Thank. The problem I have now is that I cannot open the historical database to look for player ids. I have nothing that opens a .obd file.
nokmirt is offline   Reply With Quote
Old 04-27-2018, 03:55 PM   #66
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,298
Thanks: 1,374
Thanked 1,174x in 750 posts
to my knowledge, nothing opens those .obd database files, except some magic program the developers have hidden in a dark and secret room. after all, it is their program and database. at least, nothing i've ever tried or read about.

i believe actionjackson sent you a .csv file for 17 ... it'll work, for all but the most recent players added in the Spritze 18 db. Bbref is a source (offten not correct for the game IDs) you might look if the player isn't in the file actionjackon sent you - but i suspect 95% of the players will show up in that older .csv file. Otherwise, maybe look in the minor league .csv file that comes in the game. Almost every player in the Spritze database is in that file, but i can't say if the player IDs are the same. that;s just not something i've looked into. yes, a muddled mess to be certain. best of luck, and hope some of this might help or make sense.
__________________
"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
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; 04-27-2018 at 04:00 PM.
mitchkenn is offline   Reply With Quote
Old 04-27-2018, 06:42 PM   #67
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,151
Thanks: 308
Thanked 3,216x in 1,890 posts
Quote:
Originally Posted by nokmirt View Post
How come some player ratings are garbage? I tried to import Rube Foster from 1911. He can't pitch himself out of a wet paper bag. The man would roll over in his grave if he saw these ratings.
The ratings in the player editor are for a "modern major league environment" not 1911 and not negro leagues.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-27-2018, 06:50 PM   #68
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,151
Thanks: 308
Thanked 3,216x in 1,890 posts
Quote:
Originally Posted by mitchkenn View Post
to my knowledge, nothing opens those .obd database files, except some magic program the developers have hidden in a dark and secret room. after all, it is their program and database. at least, nothing i've ever tried or read about.
i believe actionjackson sent you a .csv file for 17 ... it'll work, for all but the most recent players added in the Spritze 18 db. Bbref is a source (offten not correct for the game IDs) you might look if the player isn't in the file actionjackon sent you - but i suspect 95% of the players will show up in that older .csv file. Otherwise, maybe look in the minor league .csv file that comes in the game. Almost every player in the Spritze database is in that file, but i can't say if the player IDs are the same. that;s just not something i've looked into. yes, a muddled mess to be certain. best of luck, and hope some of this might help or make sense.
ODB files are proprietary to OOTP Developments. They are not readable without being hacked like they do on TV shows and movies. 10 seconds max.

OOTP has its own negro league player id schema as many of the players in the game are not included on BBref.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-27-2018, 08:59 PM   #69
nokmirt
Minors (Rookie Ball)
 
Join Date: Mar 2016
Posts: 48
Thanks: 1
Thanked 10x in 7 posts
Quote:
Originally Posted by Spritze View Post
The ratings in the player editor are for a "modern major league environment" not 1911 and not negro leagues.
Then why is it that the ratings for players on teams in my 1871-1875 league came out ok? This is also a fictional historical league. Granted these teams were imported wholesale, but still. Why is it that individual player imports are screwy?

Last edited by nokmirt; 04-27-2018 at 09:04 PM.
nokmirt is offline   Reply With Quote
Old 04-27-2018, 09:47 PM   #70
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,298
Thanks: 1,374
Thanked 1,174x in 750 posts
Quote:
Originally Posted by nokmirt View Post
Then why is it that the ratings for players on teams in my 1871-1875 league came out ok? This is also a fictional historical league. Granted these teams were imported wholesale, but still. Why is it that individual player imports are screwy?
in beta testing last year, using a historical out of box set-up, in the leagues players were created for (ie Negro Leagues), players performed pretty much as they did in real life. Once they were placed out of their "created" environment, the game treated them differently and their number suffered accordingly. Rube Foster, Oscar Charleston, Jud Wilson and Cool Papa Bell were stars in the games' MiLB Negro Leagues. i didn't design or create any of this, i simply tested. And those were the results. So, as designed, things worked fairly well.

personally, when i place Negro League players in my fictional world, i edit their stats for the environment i am placing them in. since it's a fictional world, i keep it fictional.

Good luck.
__________________
"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
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
Thank you for this post:
RANGER11JP (04-27-2018)
Old 04-27-2018, 11:38 PM   #71
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,151
Thanks: 308
Thanked 3,216x in 1,890 posts
Quote:
Originally Posted by nokmirt View Post
Then why is it that the ratings for players on teams in my 1871-1875 league came out ok? This is also a fictional historical league. Granted these teams were imported wholesale, but still. Why is it that individual player imports are screwy?
Negro League players often faced less than stellar competition which can inflate their stats in much the same way MLB expansion years do. So if you start out with grandiose expectations in some cases you may be disappointed. Since your leagues are fictional anyway and you control everything you wish to feel free to adjust things to your liking. OOTP is a game after all. Playing it any way you wish is a positive.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-28-2018, 01:16 AM   #72
nokmirt
Minors (Rookie Ball)
 
Join Date: Mar 2016
Posts: 48
Thanks: 1
Thanked 10x in 7 posts
Quote:
Originally Posted by mitchkenn View Post
in beta testing last year, using a historical out of box set-up, in the leagues players were created for (ie Negro Leagues), players performed pretty much as they did in real life. Once they were placed out of their "created" environment, the game treated them differently and their number suffered accordingly. Rube Foster, Oscar Charleston, Jud Wilson and Cool Papa Bell were stars in the games' MiLB Negro Leagues. i didn't design or create any of this, i simply tested. And those were the results. So, as designed, things worked fairly well.

personally, when i place Negro League players in my fictional world, i edit their stats for the environment i am placing them in. since it's a fictional world, i keep it fictional.

Good luck.
Sounds good thanks for the explanation. And @ Spritze thank you as well and I will keep that in mind.

Last edited by nokmirt; 04-28-2018 at 01:17 AM.
nokmirt is offline   Reply With Quote
Old 04-28-2018, 08:53 AM   #73
nokmirt
Minors (Rookie Ball)
 
Join Date: Mar 2016
Posts: 48
Thanks: 1
Thanked 10x in 7 posts
I know why Rube Foster gives out bad ratings. First I noticed the game does not display his real life stats. Then I noticed in the Spritze database that his line of data is unfinished or incomplete. The in game database has the same discrepancy. Hopefully in the future these can get fixed. I wish people back then had kept better records.
nokmirt is offline   Reply With Quote
Old 04-28-2018, 11:05 AM   #74
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,151
Thanks: 308
Thanked 3,216x in 1,890 posts
I just reviewed the database records for Andrew (Rube) Foster in both the OOTP and the Spritze databases and do not find any incomplete nor unfinished records. His IRL stats display perfectly in OOTP.

Please expand on your comments and provide screenshots?

Be sure to set the Scope to All rather than MLB when viewing Fosters IRL data.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-28-2018 at 11:14 AM.
Spritze is offline   Reply With Quote
Old 04-28-2018, 08:04 PM   #75
nokmirt
Minors (Rookie Ball)
 
Join Date: Mar 2016
Posts: 48
Thanks: 1
Thanked 10x in 7 posts
Quote:
Originally Posted by Spritze View Post
I just reviewed the database records for Andrew (Rube) Foster in both the OOTP and the Spritze databases and do not find any incomplete nor unfinished records. His IRL stats display perfectly in OOTP.

Please expand on your comments and provide screenshots?

Be sure to set the Scope to All rather than MLB when viewing Fosters IRL data.
I found him. Just have to get used to this again. I am having fun though.

Last edited by nokmirt; 04-28-2018 at 08:48 PM.
nokmirt is offline   Reply With Quote
Old 05-08-2018, 04:07 AM   #76
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
Might it be possible to import the minor league players but not the teams?
If you wanted to run your own minor leagues instead of the historic ones?
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-08-2018, 04:48 PM   #77
txranger
Hall Of Famer
 
txranger's Avatar
 
Join Date: Dec 2008
Location: "Deep in the Heart Of"
Posts: 6,482
Thanks: 4,634
Thanked 19,312x in 5,251 posts
Quote:
Originally Posted by RANGER11JP View Post
Might it be possible to import the minor league players but not the teams?
If you wanted to run your own minor leagues instead of the historic ones?

Somewhat explained here:

http://www.ootpdevelopments.com/boar...1&postcount=33
txranger is offline   Reply With Quote
Thank you for this post:
RANGER11JP (05-10-2018)
Old 05-10-2018, 06:19 PM   #78
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
Quote:
Originally Posted by txranger View Post
I'll have to read this a few dozen times and make sure I have the correct files. I don't want to import individuals, so I'm still puzzled as to minor players and when they debut and if just having them become available somewhere is possible.
This sounds like something I need to ask the master, Spritze!!!
__________________
BASEBALL, HOCKEY AND BOXING FAN

Last edited by RANGER11JP; 05-10-2018 at 06:22 PM.
RANGER11JP is offline   Reply With Quote
Old 05-10-2018, 08:21 PM   #79
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,151
Thanks: 308
Thanked 3,216x in 1,890 posts
Well I must say I am also confused. All the negro leaguers are in the OOTP minor league database. Did Lukas ever release a master list for that? It seemed like he was going to but I just don't know what is actually provided with the game.

My copy shows everything rather than just what comes with the game. That is because I use it for testing porpoises.

There was also a negro league list last year. That would still be fairly accurate. For 19 there are 137 new negro leaguers, most from 1945 and 1946 plus a very few fixes.

I can easily create lists but only with OOTP approval.
__________________
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:
RANGER11JP (05-11-2018)
Old 05-11-2018, 03:47 AM   #80
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
So my real question is if it is possible to have major and minor league players import yearly without using the historic minor league teams? I do not want to individually import each player because I am too old and impatient for that kind of thing! We can create up to five levels of minors when creating a league, so I'd like that option for employing minor league guys. Is anyone with me on this? Or am I missing something totally?
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Thank you for this post:
RMc (05-11-2018)
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 12:54 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