Home | Webstore
Latest News: OOTP Update 20.8 - OOTP 20 Available - FHM 6 Available

Announcing OOTP 21, Pre-Order Now!

  

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 05-03-2018, 08:46 PM   #21
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 21,558
Thanks: 9,484
Thanked 3,135x in 2,496 posts
Quote:
Originally Posted by Spritze View Post
Update:

Slight pause before I release this.

While I was creating the player list for those that import I decided it was too confusing to have some different player ID's in OOTP and the Spritze database so I will change mine to match OOTP. If OOTP does not have one, like for most Japanese and Korean players I will be making my own.
Any chance of releasing an easy to find/read player ID for the non MLB players?
Or does yours match baseball ref, primarily NNL players like Paige who is paige001-ler
__________________
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

"Stay Strong"
The Game is offline   Reply With Quote
Old 05-03-2018, 09:06 PM   #22
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,274
Thanks: 358
Thanked 3,271x in 1,934 posts
Quote:
Originally Posted by The Game View Post
Any chance of releasing an easy to find/read player ID for the non MLB players? That is what I was doing when I noticed the ID challenge
Or does yours match baseball ref, primarily NNL players like Paige who is paige001-ler
Negro players come from Seamheads not BBref as BBref is a poopy diaper full of blubber and beer as far as completeness goes. No sir I don't like it and I do not have a negro league player list from them anyways. Gotta go with what I got and what I got is a Seamheads-OOTP negro league player list.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
4 thanks for this post:
actionjackson (05-05-2018), JaBurns (05-04-2018), Khephren (05-04-2018), mitchkenn (05-03-2018)
Old 05-05-2018, 12:34 PM   #23
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,274
Thanks: 358
Thanked 3,271x in 1,934 posts
Here is the Master List.

Newest Japanese and Korean players not added yet. I'll figure that out next. Way too many Koreans with the same name but they look to be separate players in many cases.
Attached Files
File Type: zip MasterList.zip (400.1 KB, 233 views)
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
7 thanks for this post:
actionjackson (05-05-2018), drambrosini (05-05-2018), JaBurns (05-05-2018), mitchkenn (05-05-2018), mpoloni23 (11-11-2018), szathkey (05-05-2018), txranger (05-05-2018)
Old 05-05-2018, 03:40 PM   #24
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,350
Thanks: 1,395
Thanked 1,201x in 771 posts
Quote:
Originally Posted by Spritze View Post
Here is the Master List.

Newest Japanese and Korean players not added yet. I'll figure that out next. Way too many Koreans with the same name but they look to be separate players in many cases.
Ye be Thanked, for this and the many others ....
__________________
"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; 05-05-2018 at 04:25 PM.
mitchkenn is offline   Reply With Quote
Thank you for this post:
JaBurns (05-05-2018)
Old 05-05-2018, 03:44 PM   #25
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 5,311
Thanks: 7,726
Thanked 3,184x in 1,959 posts
Thank you so much for this and everything else Spritze. Enjoy your retirement. I'm sorry for the few times we butted heads, and I am tremendously grateful for everything you've contributed to this game.
actionjackson is offline   Reply With Quote
2 thanks for this post:
JaBurns (05-05-2018), mitchkenn (05-05-2018)
Old 05-05-2018, 05:55 PM   #26
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,366
Thanks: 69
Thanked 688x in 399 posts
So now, you have to either use OOTPs db or replace it with this, correct?
Cooleyvol is offline   Reply With Quote
Old 05-05-2018, 10:04 PM   #27
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,274
Thanks: 358
Thanked 3,271x in 1,934 posts
I have been working on the ability to use them together.

The Spritze DB moves the super-star minor league, negro league, Korean and Japanese players to the main database. In the past they did not exist at all anywhere. Now only the Japanese and Korean players are left out. So I have been considering making the Spritze database Korean and Japanese only and moving the few missing minor/negro league players into the standard minor league database. The more I work with the old Spritze db the more I remember about why I stopped updating it and why most of it's raw IRL data was moved to the OOTP minor league database. Markus then built an OOTP version of MLE'S into the program. You don't see it but it is why players magically appear at the correct level based on their skills.

This does not apply to Japanese nor Korean players yet. Whenever they appear in historicals it will.

So if I update the OOTP minor league database with the 121 missing minor league players that would make the Spritze database Asians only. I'm thinking on it since the ODB files have changed the landscape for customization and the ability to create ones own leagues and structures. If OOTP would allow the missing minor leagues to extend back to 1882 or even 1871 or even extra-even into the 1850's, well gee that would be swell.

The deeper I get into thinking about how all this Spritze stuff fits together with the game the more I think it does not anymore.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-05-2018, 10:25 PM   #28
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,350
Thanks: 1,395
Thanked 1,201x in 771 posts
Quote:
Originally Posted by Spritze View Post
I have been working on the ability to use them together.

The Spritze DB moves the super-star minor league, negro league, Korean and Japanese players to the main database. In the past they did not exist at all anywhere. Now only the Japanese and Korean players are left out. So I have been considering making the Spritze database Korean and Japanese only and moving the few missing minor/negro league players into the standard minor league database. The more I work with the old Spritze db the more I remember about why I stopped updating it and why most of it's raw IRL data was moved to the OOTP minor league database. Markus then built an OOTP version of MLE'S into the program. You don't see it but it is why players magically appear at the correct level based on their skills.

This does not apply to Japanese nor Korean players yet. Whenever they appear in historicals it will.

So if I update the OOTP minor league database with the 121 missing minor league players that would make the Spritze database Asians only. I'm thinking on it since the ODB files have changed the landscape for customization and the ability to create ones own leagues and structures. If OOTP would allow the missing minor leagues to extend back to 1882 or even 1871 or even extra-even into the 1850's, well gee that would be swell.

The deeper I get into thinking about how all this Spritze stuff fits together with the game the more I think it does not anymore.
what a wonderfully complicated situation.
Is it possible any of this moving/restructuring the minor's DB could/might/should happen in 19, or is that something to look at for 20 and beyond? And IF it could happen sooner than later, does it alter the plans of releasing the database associated with the .csv file from this morning? Just curious. i've sort of put my games on hold until i understand which database i might need to use in order to progress. i import all my historical players from text files.
from your note above, it's obvious the work you do on these databases is much more involved and complex than i ever imagined. i (for one) like the games' and your DB being different, but however you decide will be appreciated and used.
take care and have a good evening.
__________________
"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
Old 05-06-2018, 12:20 AM   #29
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,274
Thanks: 358
Thanked 3,271x in 1,934 posts
Quote:
Originally Posted by mitchkenn View Post
what a wonderfully complicated situation.
Is it possible any of this moving/restructuring the minor's DB could/might/should happen in 19, or is that something to look at for 20 and beyond? I suppose the new lead can request whatever he likes but Markus would need to approve And IF it could happen sooner than later, does it alter the plans of releasing the database associated with the .csv file from this morning? Just curious. i've sort of put my games on hold until i understand which database i might need to use in order to progress. i import all my historical players from text files.
from your note above, it's obvious the work you do on these databases is much more involved and complex than i ever imagined. i (for one) like the games' and your DB being different, but however you decide will be appreciated and used.
take care and have a good evening.
If the Spritze database goes full Asian only then you would have 3 lists.
__________________
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:
mitchkenn (05-06-2018)
Old 05-06-2018, 09:04 AM   #30
JaBurns
All Star Starter
 
Join Date: Sep 2015
Location: Regina, Saskatchewan
Posts: 1,241
Thanks: 3,700
Thanked 580x in 447 posts
Quote:
Originally Posted by Spritze View Post
I have been working on the ability to use them together.

The Spritze DB moves the super-star minor league, negro league, Korean and Japanese players to the main database. In the past they did not exist at all anywhere. Now only the Japanese and Korean players are left out. So I have been considering making the Spritze database Korean and Japanese only and moving the few missing minor/negro league players into the standard minor league database. The more I work with the old Spritze db the more I remember about why I stopped updating it and why most of it's raw IRL data was moved to the OOTP minor league database. Markus then built an OOTP version of MLE'S into the program. You don't see it but it is why players magically appear at the correct level based on their skills.

This does not apply to Japanese nor Korean players yet. Whenever they appear in historicals it will.

So if I update the OOTP minor league database with the 121 missing minor league players that would make the Spritze database Asians only. I'm thinking on it since the ODB files have changed the landscape for customization and the ability to create ones own leagues and structures. If OOTP would allow the missing minor leagues to extend back to 1882 or even 1871 or even extra-even into the 1850's, well gee that would be swell.

The deeper I get into thinking about how all this Spritze stuff fits together with the game the more I think it does not anymore.
May as well be talking Greek to me and have it written in hieroglyphics.I would need the rune stone to figure this out; I have neither the time, patience, nor the skills to provide any ideas. I am sure you will perform some of your wizardry and "poof" the world will be right again with your new database. Thanks again for everything you do for all of us in the beautiful game.
JaBurns is offline   Reply With Quote
Old 05-07-2018, 12:12 PM   #31
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,350
Thanks: 1,395
Thanked 1,201x in 771 posts
Quote:
Originally Posted by Spritze View Post
If the Spritze database goes full Asian only then you would have 3 lists.
while i fully understand very little of how all this fits together behind the screens, actually 3 databases might not be as restrictive as i first thought. in fact, (as a dim light flickers on and off) it might be a good thing and be very workable, at least in my contorted OOTP world.

no idea how you wrestle all these swirling and twisted numbers, but dangnabit, you do a good job of it once it gets out to we peons in the meadows. thanks again for the work and products.
__________________
"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
Old 05-07-2018, 12:45 PM   #32
jparker2112
All Star Reserve
 
Join Date: Nov 2012
Posts: 549
Blog Entries: 1
Thanks: 674
Thanked 209x in 145 posts
ugh...im a moron at this it seems. So do i take the new linked masterlist.csv and put that in the game in place of the master.csv? Ive tried to import josh gibson every which way and it always fails...what am i doing wrong?
jparker2112 is offline   Reply With Quote
Old 05-07-2018, 01:18 PM   #33
txranger
Hall Of Famer
 
txranger's Avatar
 
Join Date: Dec 2008
Location: "Deep in the Heart Of"
Posts: 6,682
Thanks: 4,766
Thanked 20,191x in 5,446 posts
Quote:
Originally Posted by jparker2112 View Post
ugh...im a moron at this it seems. So do i take the new linked masterlist.csv and put that in the game in place of the master.csv? Ive tried to import josh gibson every which way and it always fails...what am i doing wrong?
The masterlist.csv is just that a list of names and id's and a couple of other columns... The id for Gibson in the masterlist must be if you are using the SpritzeHS database for it is not the same id as is in the database that comes with the game... I used gibson002jos with 1930 as the debut year and he imported... Using the id from the masterlist, he did not import... Select the historical_database.odb and be sure to check the box to include players in minor league database for that is where he resides... I got that id from a list that Spritze published called NegroLeaguePlayersList, see the attached file...
Attached Images
Image Image 
Attached Files
File Type: xls NegroLeaguePlayersList.xls (451.0 KB, 194 views)
txranger is offline   Reply With Quote
Thank you for this post:
jparker2112 (05-07-2018)
Old 05-07-2018, 01:37 PM   #34
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 5,311
Thanks: 7,726
Thanked 3,184x in 1,959 posts
Quote:
Originally Posted by jparker2112 View Post
ugh...im a moron at this it seems. So do i take the new linked masterlist.csv and put that in the game in place of the master.csv? Ive tried to import josh gibson every which way and it always fails...what am i doing wrong?
If using Spritze HS DB, ID is gibsonj99, and import year is 1928 (year before debut because draft takes place year before debut). If using the minor league database, check the box to include players in the minor league database as txranger said above. His ID in there is gibson002jos (as txranger mentioned), and I would go with a debut of 1929 (again year before actual debut because draft takes place year before actual debut). If you're not putting him in the draft pool, you could probably go with 1929 and 1930 respectively for his debut seasons, but if he's going in the draft pool, I would use 1928 and 1929.

Last edited by actionjackson; 05-07-2018 at 01:39 PM.
actionjackson is offline   Reply With Quote
Thank you for this post:
jparker2112 (05-07-2018)
Old 05-07-2018, 01:40 PM   #35
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 5,311
Thanks: 7,726
Thanked 3,184x in 1,959 posts
Spritze, I'll just paraphrase the great and underrated Warren Zevon and say "Enjoy every tasty morsel of calamari" in your retirement.
actionjackson is offline   Reply With Quote
Old 05-08-2018, 02:24 AM   #36
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,274
Thanks: 358
Thanked 3,271x in 1,934 posts
Here is what I decided to do.

Recompile the Spritze 17 db for 00TP19 as is. That should remove the weird errors OOTP18 introduced. It did that in my tests. I should have that posted by Wednesday.

Looking back on the origin of the Spritze database it existed to fix the following missing information.

1) No 19th century minor leagues. This was a problem as the game required more players as a minimum (15) than most teams had. This is still the case and so this will remain in the database. In the last few months I have found a second source for this information and will combine the two.

2) No minor league players. These are now in the game and so will be removed.

3) No negro league players. These are now in the game and so will be removed.

4) No Japanese nor Korean players. These are still not in the game and so will be kept and updated with 2016 and 2017 data.

That is the new plan man.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
3 thanks for this post:
JaBurns (05-08-2018), mitchkenn (05-08-2018), txranger (05-09-2018)
Old 05-08-2018, 04:28 AM   #37
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,707
Thanks: 126
Thanked 501x in 307 posts
I feel your DB still serves a great purpose.
As I understand it, the current MinorLDB can not be used for random debut.
And the MinorLDB can not be used with an altered structure to the MLB or to the minor leagues. We must use it historically exactly as real life was with no even minor tweeks.

With your DB, not only do we get ALL the players, they come in at an early age, the DB "real stats" allows us to play with any structure that we like.

Wishing you the best in your final run of this DB. I have been contemplating for years making a Davenport Translation DB...maybe with you finally stepping back after this year, it might be time to get off my butt and try that out.
Cheers
sprague is offline   Reply With Quote
Old 05-08-2018, 12:13 PM   #38
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,274
Thanks: 358
Thanked 3,271x in 1,934 posts
I have not yet figured out what to do about the 18 year old thing.

The reason for the ODB files OOTP was forced to go to is that many of the csv files were reaching their data capacity. I guess I need to figure out what the data capacity of an ODB file is. Then I'd know if I can create an all-in-one database for RD and custom settings.

So I will attempt to blow up an ODB file this week.
__________________
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:
JaBurns (05-08-2018), mitchkenn (05-08-2018)
Old 05-08-2018, 01:10 PM   #39
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,350
Thanks: 1,395
Thanked 1,201x in 771 posts
Quote:
Originally Posted by Spritze View Post
I have not yet figured out what to do about the 18 year old thing.

The reason for the ODB files OOTP was forced to go to is that many of the csv files were reaching their data capacity. I guess I need to figure out what the data capacity of an ODB file is. Then I'd know if I can create an all-in-one database for RD and custom settings.

So I will attempt to blow up an ODB file this week.
what a gargantuan undertaking ye speaks of!
i thought the first version of Sprtize i found was incredible (14). But it's gotten bigger/better. Seems it has function for nearly every style of play. that has to be a challenge ... somehow that echoes of an Abe Lincoln quote ..... "You can please some of the people some of the time, all of the people some of the time, some of the people all of the time, but you can never please all of the people all of the time."
best of luck in ye ODB file blow-up/research. we should be pleased with whatever you decide to release unto us.
__________________
"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; 05-08-2018 at 09:02 PM.
mitchkenn is offline   Reply With Quote
Old 05-09-2018, 11:46 AM   #40
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,274
Thanks: 358
Thanked 3,271x in 1,934 posts
https://www.dropbox.com/s/huimrk5jab...abase.zip?dl=0
Attached Files
File Type: zip masterlist17_18_19.zip (469.8 KB, 212 views)
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-09-2018 at 11:54 AM.
Spritze is offline   Reply With Quote
13 thanks for this post:
actionjackson (05-21-2018), bugman (11-15-2018), doors11 (05-09-2018), drambrosini (05-11-2018), JaBurns (05-09-2018), jparker2112 (05-09-2018), mitchkenn (05-09-2018), Mokk Rodder (05-14-2018), Someguy1785 (05-10-2018), sprague (05-28-2018), TribeWarpath (07-16-2018), txranger (05-09-2018), WahooSam309 (12-16-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 03:01 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 - 2020, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments