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

Collection Missions for Perfect Team Released!

  

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-11-2018, 02:54 PM   #81
RMc
All Star Starter
 
RMc's Avatar
 
Join Date: Jan 2004
Posts: 1,050
Thanks: 119
Thanked 173x in 103 posts
^ This is what I want!

EDIT: ...oh, hell. What I want is the last post of the previous page:

Quote:
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?
__________________
"We're all behind our baseball team..."

Last edited by RMc; 05-11-2018 at 02:55 PM.
RMc is offline   Reply With Quote
Thank you for this post:
RANGER11JP (05-11-2018)
Old 05-11-2018, 04:00 PM   #82
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,297
Thanks: 1,373
Thanked 1,172x in 749 posts
Quote:
Originally Posted by RANGER11JP View Post
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?
the only way i know, well, is a lot of work. by going through the .csv files, year by year, creating a text file and importing the players to either the draft pool or Free Agency (i put them in the draft pool.). i also just use the minor league .csv so i don't get duplicate names - probably missing a few that never played in minors ... but it's easier than trying to go through the lists and editing out duplicate player names.
but that way i can import real minor/major leaguers into my fictional world.

but i don't know of an easier way to do this. my method is lots of editing and typing, probably more time creating the lists than playing the game. not what your looking for i realize, but i thought i'd share at least one way it could be done ... i do have a small write up somewhere on my computer on how i do it, if you're ever interested.

good luck and hope someone has a quicker way and shares it.
__________________
"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 (05-11-2018)
Old 05-11-2018, 05:06 PM   #83
txranger
Hall Of Famer
 
txranger's Avatar
 
Join Date: Dec 2008
Location: "Deep in the Heart Of"
Posts: 6,450
Thanks: 4,626
Thanked 19,268x in 5,233 posts
Just a quick thought here...
Could you start a historical game with the minors... Change names of teams to your fictional names, disable automatic evolution of the leagues and have your rookies import as free agents... Then release all players MLB and MILB to free agent pool, have a free agent draft or assign players to teams... Sound like this might work???
txranger is offline   Reply With Quote
Thank you for this post:
RANGER11JP (05-11-2018)
Old 05-11-2018, 05:47 PM   #84
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
I appreciate everyone's input and suggestions. The bottom line is that this should not be such a challenge. It's not like the data is not available. We need a bit more flexibility between the OBD files and some CSV's that can open up some options. At least that's how I see it.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-12-2018, 01:31 AM   #85
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
If you click on the real minor league check box for years where there are no minor leagues or teams all MILB players automagically enter as free agents or appear in a draft depending on other settings. OOTP would therefore need to include a function that turns off MILB teams and leagues but leaves everything else as is. Would that work for anyone?

Also during beta a request was made to be able to use the mass select function already in the game for imports which would have allowed for easy imports without all the typing. Would that be helpful?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-12-2018, 06:48 AM   #86
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
Quote:
Originally Posted by Spritze View Post
If you click on the real minor league check box for years where there are no minor leagues or teams all MILB players automagically enter as free agents or appear in a draft depending on other settings. OOTP would therefore need to include a function that turns off MILB teams and leagues but leaves everything else as is. Would that work for anyone?

Also during beta a request was made to be able to use the mass select function already in the game for imports which would have allowed for easy imports without all the typing. Would that be helpful?
The short answers would be YES and YES.

Anything that opens up more options for importing players.is a good thing. Being able to funnel minor league guys to their debut organization would be super.as well. Presently, we can only EXPORT a league structure to a CSV file. Maybe a CSV file IMPORT to edit/update/store/share a custom minor league structure is possible. You would be the most qualified to answer that question, since it borders on quantum physics.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-15-2018, 05:34 PM   #87
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,668
Thanks: 124
Thanked 493x in 301 posts
Quote:
Originally Posted by Spritze View Post
If you click on the real minor league check box for years where there are no minor leagues or teams all MILB players automagically enter as free agents or appear in a draft depending on other settings. OOTP would therefore need to include a function that turns off MILB teams and leagues but leaves everything else as is. Would that work for anyone?

Also during beta a request was made to be able to use the mass select function already in the game for imports which would have allowed for easy imports without all the typing. Would that be helpful?
PLEASE...
I have been asking for this since the minor league DB came out- the ability to turn off the "follow history box" but still have the next year of players get to the draft (or free agents if playing that way)...would love if you could help us get this for 19. Would open up that great DB to all sorts of possabilities for constructing leagues
sprague is offline   Reply With Quote
2 thanks for this post:
JaBurns (05-16-2018), RANGER11JP (05-16-2018)
Old 05-16-2018, 04:28 PM   #88
JaBurns
All Star Starter
 
Join Date: Sep 2015
Location: Regina, Saskatchewan
Posts: 1,227
Thanks: 3,622
Thanked 569x in 440 posts
Quote:
Originally Posted by sprague View Post
PLEASE...
I have been asking for this since the minor league DB came out- the ability to turn off the "follow history box" but still have the next year of players get to the draft (or free agents if playing that way)...would love if you could help us get this for 19. Would open up that great DB to all sorts of possabilities for constructing leagues
If you turned off the “follow history box”, had random debut of players, controlled the number of teams with access to both the major and minor databases you would have enough players for a very long time.

I could play my random debut with unaffiliated AAA teams for almost ever, I must be dreaming....
JaBurns is offline   Reply With Quote
Thank you for this post:
RANGER11JP (05-16-2018)
Old 05-18-2018, 02:00 PM   #89
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
AFAIK As the internal processes of OOTP now stand you cannot have your wishes. Does not work worth a golly gosh dam. I spent about 40 hours testing various setups. Perhaps in a future version but this might not be a trivial change.

Easier importation of MLB players remains an achievable goal though.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-18-2018 at 03:51 PM.
Spritze is offline   Reply With Quote
2 thanks for this post:
JaBurns (05-19-2018), RANGER11JP (05-18-2018)
Old 05-18-2018, 03:00 PM   #90
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
Quote:
Originally Posted by Spritze View Post
AFAIK As the internal processes of OOTP now stand you cannot have your wishes. Does not work worth a golly gosh dam. I spent about 40 hours testing. Perhaps in a future version but this might not be a trivial change.

Easier importation of MLB players remains an achievable goal though.
Hi Spritze,

Well thanks for your efforts on this and all you create. I am sure down the road your knowledge and influence will help our cause!
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Thank you for this post:
JaBurns (05-19-2018)
Old 05-19-2018, 02:44 AM   #91
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,668
Thanks: 124
Thanked 493x in 301 posts
Quote:
Originally Posted by Spritze View Post
AFAIK As the internal processes of OOTP now stand you cannot have your wishes. Does not work worth a golly gosh dam. I spent about 40 hours testing various setups. Perhaps in a future version but this might not be a trivial change.

Easier importation of MLB players remains an achievable goal though.
Hey Spritze,
Maybe the solution, since it might be so hard to alter how the Minor Db is used by the game
is for OOTP to give us a notepad file of all the players that the game imports each year. It would take some time to make that list for each year, but once it is done it is done, then we have the 120 or so text files to bring in the players manually each year.
That would be a working way around having access to all minor league players yet allowing us to have the league structue we want.
It would be easier if there was a master list like in the old DB, ..\
sprague is offline   Reply With Quote
3 thanks for this post:
JaBurns (05-19-2018), mitchkenn (05-19-2018), RANGER11JP (05-19-2018)
Old 05-19-2018, 08:05 PM   #92
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
the issue is that those players will not perform in any realistic way.

That was fixed during ootp17 historicals beta testing but still applies if minor league players are imported to fictional leagues, fictional teams and random debuts. mitchkenn was one of the testers but I notice he is endorsing this so maybe he has updated information.

The list would be easy but the results would be crap to put it bluntly. In my tests the fail was epic.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-19-2018, 09:41 PM   #93
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,297
Thanks: 1,373
Thanked 1,172x in 749 posts
i've never gotten the Negro League players to perform well, outside of the Negro League minor league set-up, without much editing. In that minor league setting, they seemed to do just fine when i beta tested them last year. Somewhere i've got partial notes on the early results, but they're probably haphazard and cryptic now that they are out of context of that testing.
The idea Sprague offered, a huge notepad entry of all the players Ids and names, broken down by year, i think would be a good thing for those of us who import players in that manner. However, it's not something i expect to happen. i've tinkered with a couple dozen files for the years i'd been playing, both the games milb and the older Spritze 17. but the folders are very incomplete - made specifically for a couple of tests i tried and didn't follow up on.
still, for a fictional league with real historical players, the importing players via year by year text file is the only way i know will work. but, to gather the info for that file is very time consuming, at least the way i've been doing it.
__________________
"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:
JaBurns (05-20-2018)
Old 05-19-2018, 10:07 PM   #94
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
Making the list is a trivial matter.

Somehow I have not found a way to convey that importing players from the minor league database does not generate players with the proper skill levels. Basically all you get are fictional players with real names. That is why your negro league example happens, it happens to 100% of imported minor league players.

Imported major league players work fine as do players from my database because those are all major league equivalences. Without that step imported players lose all connection to reality.
__________________
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-20-2018), RANGER11JP (05-23-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 01:20 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