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

Coming soon: Collection Missions

  

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 03-25-2015, 10:42 PM   #21
mm7607
All Star Reserve
 
Join Date: Jun 2006
Location: Originally from Fla, now in Ky
Posts: 710
Thanks: 38
Thanked 144x in 88 posts
nevermind

Last edited by mm7607; 03-26-2015 at 12:14 AM.
mm7607 is offline   Reply With Quote
Old 03-28-2015, 08:13 PM   #22
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Updated 3/28/15. Now includes the correct support and formatting for ootp 16's import to team using text file feature. Create entire rosters using historical players and assign them to the team of your choice.
Updated link is in first post or just click the 3.0 plus link in my sig to navigate there.
Any problems, PM me please. Enjoy.

Last edited by Bigrod; 03-28-2015 at 08:14 PM.
Bigrod is offline   Reply With Quote
Thank you for this post:
pstrickert (03-28-2015)
Old 03-28-2015, 08:25 PM   #23
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,290
Thanks: 2,793
Thanked 3,599x in 2,002 posts
If it has the Bigrod trademark, I know it's quality made. Thanks!
pstrickert is offline   Reply With Quote
Thank you for this post:
Bigrod (03-28-2015)
Old 03-28-2015, 08:47 PM   #24
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,290
Thanks: 2,793
Thanked 3,599x in 2,002 posts
Bigrod, when I click on the bbref link, I get an error. Aaron Miles, for example. The link shows: m-milesaa01.shtml The actual URL for Miles shows: m/milesaa01.shtml
pstrickert is offline   Reply With Quote
Thank you for this post:
Bigrod (03-28-2015)
Old 03-28-2015, 09:14 PM   #25
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by pstrickert View Post
Bigrod, when I click on the bbref link, I get an error. Aaron Miles, for example. The link shows: m-milesaa01.shtml The actual URL for Miles shows: m/milesaa01.shtml
Crap...thanks a ton...I changed the format of the years from using a forward slash to using a dash and forgot the link used the same.
It'll be fixed is a couple minutes.
Thanks again.
Bigrod is offline   Reply With Quote
Old 03-28-2015, 09:18 PM   #26
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,290
Thanks: 2,793
Thanked 3,599x in 2,002 posts
Everything else I tested works like a charm. Many thanks, Bigrod.
pstrickert is offline   Reply With Quote
Thank you for this post:
Bigrod (03-28-2015)
Old 03-28-2015, 09:23 PM   #27
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Fixed and updated Just reverted it back to using the /
Bigrod is offline   Reply With Quote
Old 03-30-2015, 09:36 PM   #28
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
How do you import to team? How should it look, is what I am really asking?

dahlebi01,1891 and then what for the team?

Thanks. Great work, by the way. I made my own text files for the top 1000 players rated by WAR in Baseball Reference and broke it down into 30 players each for each text file. I have never added a team though when importing. I would love to be able to do that, and then release all the players for a proper inaugural draft.

Last edited by Elysian Fields; 03-30-2015 at 09:40 PM.
Elysian Fields is offline   Reply With Quote
Thank you for this post:
Bigrod (04-03-2015)
Old 04-03-2015, 03:53 PM   #29
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,290
Thanks: 2,793
Thanked 3,599x in 2,002 posts
Bigrod, what happens with defunct major league teams? I tried to place someone on the Seattle Pilots roster in 1969, but no Team ID was returned.
pstrickert is offline   Reply With Quote
Old 04-03-2015, 04:00 PM   #30
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,290
Thanks: 2,793
Thanked 3,599x in 2,002 posts
I'm guessing that the Team ID is dependent on it being included in the vlookup table. So, the IDs have not been standardized for use in OOTP historical leagues. Is this correct?
pstrickert is offline   Reply With Quote
Old 04-03-2015, 05:09 PM   #31
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by pstrickert View Post
I'm guessing that the Team ID is dependent on it being included in the vlookup table. So, the IDs have not been standardized for use in OOTP historical leagues. Is this correct?
The team ids in vlookup are for ootp 16 quickstart.
What is it you'd like to have? Is it the historical mlb team ids??
They're not standardized for historicals as I'm Not sure if ootp will use the ones in the master.csv.
We can try it...and see if ootp will use the team ids in the master rather that the game generated team ids.

Last edited by Bigrod; 04-03-2015 at 05:14 PM.
Bigrod is offline   Reply With Quote
Old 04-03-2015, 05:24 PM   #32
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,290
Thanks: 2,793
Thanked 3,599x in 2,002 posts
If I create a .txt file with player ID, year, and three-letter team abbreviation, the players import to the proper teams just fine.
pstrickert is offline   Reply With Quote
Old 04-03-2015, 05:39 PM   #33
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by Elysian Fields View Post
How do you import to team? How should it look, is what I am really asking?

dahlebi01,1891 and then what for the team?

Thanks. Great work, by the way. I made my own text files for the top 1000 players rated by WAR in Baseball Reference and broke it down into 30 players each for each text file. I have never added a team though when importing. I would love to be able to do that, and then release all the players for a proper inaugural draft.
Sorry for the delayed response...
To import to a team, use this format.
player lahmanid,year,teamid.
TeamID can be found from your league settings/edit league structure page.
You can only import players that are in the master.csv., but you can assign them to any team in your game. Real or fictional.
Bigrod is offline   Reply With Quote
Thank you for this post:
Elysian Fields (04-03-2015)
Old 04-03-2015, 05:43 PM   #34
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by pstrickert View Post
If I create a .txt file with player ID, year, and three-letter team abbreviation, the players import to the proper teams just fine.
Thanks for the quick response. Then the link I sent you should work. You've got to add a space + year at the end of the team name. Only way I could make sure vlookup didn't get confused and got the correct team id right. I'll update the original file so the year is no longer needed once I'm positive it works.
Edit: Got to keep the year after the team name as I looked at the teams.csv and some have the same name, but different id so the year is needed. I've updated the file. Updated the comment in Enter team name column.

Last edited by Bigrod; 04-04-2015 at 04:47 AM.
Bigrod is offline   Reply With Quote
Thank you for this post:
MarkInCincy (04-03-2015)
Old 04-11-2015, 12:46 AM   #35
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
All new version posted...it now fully support Spritze's latest database. Link is in first post and is a separate download.
Any problems, let me know and enjoy
Bigrod is offline   Reply With Quote
2 thanks for this post:
MarkInCincy (04-11-2015), The Game (04-11-2015)
Old 04-11-2015, 08:30 AM   #36
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Covington, KY
Posts: 650
Thanks: 224
Thanked 265x in 182 posts
Quote:
Originally Posted by Bigrod View Post
All new version posted...it now fully support Spritze's latest database. Link is in first post and is a separate download.
Any problems, let me know and enjoy
This is TOTALLY awesome. Thank you for doing this, I can now do my Dream League...

Your utility is now officially my favorite mod
__________________
"A baseball fan has the digestive apparatus of a billy goat. He can, and does, devour any set of statistics with insatiable appetite and then nuzzles hungrily for more." - Sportswriter Arthur Daley
"Who says there's an unemployment problem in this country? Just take the five percent unemployed and give them a baseball stat to follow." - Outfielder Andy Van Slyke
MarkInCincy is offline   Reply With Quote
2 thanks for this post:
Bigrod (04-11-2015), prisonerno6 (04-11-2015)
Old 05-13-2015, 04:17 PM   #37
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Explanation on how to use

I am not sure how we are meant to use the importer. How do we import?

Am I just finding players manually and placing them in a text file?

And the search function with the program doesn't allow you to search players. Is there an easy way to find players?

Last edited by Elysian Fields; 05-13-2015 at 04:35 PM.
Elysian Fields is offline   Reply With Quote
Old 05-15-2015, 11:25 PM   #38
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by Elysian Fields View Post
I am not sure how we are meant to use the importer. How do we import?

Am I just finding players manually and placing them in a text file?

And the search function with the program doesn't allow you to search players. Is there an easy way to find players?
Sorry for the delayed response.
1. Simply add the player(s) name(s) in Column J. Once entered, Available years will show up in Column L. Enter a year from that selection in Column K. To import directly to a specific team, enter a team name with year as it appears in the vlookup table column I.
Now the correct format you need to import that player is shown in Column N. Repeat the above for all players your importing.
When done, simply copy the data in Column I to notepad or any text editor and use that text file to import the players into ootp.
2. Yes. You copy the results in Column I as it says to your text editor and save it as a .txt file.
3. The easiest way to find players would be to use the Find feature (ctrl+F) on the vlookup page and copy/paste that players name in Column J on the player import sheet.
If you hover your mouse over any of the column headings, it should bring up the comment instructions showing exactly what one needs to do.
Hope this helps and if you have any other questions, feel free to ask..for a more immediate response, pm me when you post here and I'll get right on it.
Bigrod is offline   Reply With Quote
Thank you for this post:
Elysian Fields (05-16-2015)
Old 05-16-2015, 05:40 AM   #39
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Quote:
Originally Posted by Bigrod View Post
Sorry for the delayed response.
1. Simply add the player(s) name(s) in Column J. Once entered, Available years will show up in Column L. Enter a year from that selection in Column K. To import directly to a specific team, enter a team name with year as it appears in the vlookup table column I.
Now the correct format you need to import that player is shown in Column N. Repeat the above for all players your importing.
When done, simply copy the data in Column I to notepad or any text editor and use that text file to import the players into ootp.
2. Yes. You copy the results in Column I as it says to your text editor and save it as a .txt file.
3. The easiest way to find players would be to use the Find feature (ctrl+F) on the vlookup page and copy/paste that players name in Column J on the player import sheet.
If you hover your mouse over any of the column headings, it should bring up the comment instructions showing exactly what one needs to do.
Hope this helps and if you have any other questions, feel free to ask..for a more immediate response, pm me when you post here and I'll get right on it.
Thanks for the response. I appreciate it. I have just been copying and pasting the lahman names and typing in year and team numbers. Love the list especially because baseball-reference and lahman don't match up on a few players.
Elysian Fields is offline   Reply With Quote
Old 05-17-2015, 07:15 AM   #40
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by Elysian Fields View Post
Thanks for the response. I appreciate it. I have just been copying and pasting the lahman names and typing in year and team numbers. Love the list especially because baseball-reference and lahman don't match up on a few players.
That's correct. lahman ids and bbrefs MLB ids aren't always the same. The utility only uses lahman ids when it creates the import format and the player urls. Which is also why some of those urls bring up the wrong player on bbref's site.
I did it that way to prove a point as some users think you can get a player's id from bbref and use it to import historical players and you CANNOT do that with 100% accuracy.

Last edited by Bigrod; 05-17-2015 at 03:20 PM.
Bigrod is offline   Reply With Quote
Reply

Bookmarks

Tags
historical import, utility ootp

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:13 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 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments