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

Offseason Discount! SAVE 50%!

  

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 07-27-2014, 12:32 AM   #1
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Historical Importer 2.0

EDIT 1/915: Updated to 3.0 plus.
Find it here:
http://www.ootpdevelopments.com/boar...-3-0-plus.html

Had completely forgotten I had created this for ootp 14 until I saw it mentioned in the knowledge thread and realized I never posted it in Mods, so I thought I'd beef it up a bit and released 2.0. This can be used with any version of ootp that allows the importing historical players from a text file. (I think it starts with ootp 13. not sure bout 12).
It now auto creates the correct bbref player page link. Click it and it will take you to the bbref player page. Very handy if you want to look up any MLB player data.
Other than that, it includes every MLB player in ootp's database as well as their correct lahman ID.
Simply input the player's name and year and it auto creates the data needed to create the correct .txt file. Once you have all the players entered that you want to import, copy it and paste to any text editor and save. Then use ootp's import from text file option to auto import all your historical players at once.
Works great for creating historical teams, what if scenarios, or just importing several players at once.
Another feature is that it auto creates the player's bbref majors link. Click it to auto open your browser and open the correct player's page. A lot of these player pages have their pic in 90x135 jpg format which is usefule if you want to use real player pics in ootp.

The zip file contains versions for Open Office (it's free), Excel 5.0 and Excel 97/2000 XP.
I don't have Excel so I can't guarantee the Excel versions work. The utility is designed for use in Open Office only and converted to excel format within OO. The individual files are named so no mistake on which is which.
Instructions and info are in the Read Me file. Any problems, let me know and if you like it, click the thanks.
Enjoy.
Historical Importer 2.0
https://www.dropbox.com/s/frc0qlkfv8...202.0.zip?dl=1

Last edited by Bigrod; 01-09-2015 at 06:44 PM.
Bigrod is offline   Reply With Quote
7 thanks for this post:
gRaider2001 (03-20-2016), Ike348 (12-13-2014), MarkInCincy (07-27-2014), OBSL Commish (12-09-2014), RANGER11JP (07-28-2014), The Game (08-03-2014), txranger (07-27-2014)
Old 07-28-2014, 01:37 AM   #2
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,280
Thanks: 1,755
Thanked 222x in 161 posts
BigRod,

This sounds useful, but I am a bit dense. Where does the bbref endup and how do I manage the text of olayers? Could you post an example of these great features, please?

Thanks for your great work.

Regards,

JP
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 07-28-2014, 04:44 AM   #3
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by RANGER11JP View Post
BigRod,

This sounds useful, but I am a bit dense. Where does the bbref endup and how do I manage the text of olayers? Could you post an example of these great features, please?

Thanks for your great work.

Regards,

JP
Download this again as I fixed a major bug in one of the formulas..
It's very simple.
1. Enter the player's name you want to import into the first blank cell in Column F and the year in the adjacent cell in Column G (the year can be any year between and including the debut and final years the player played).
The correct import format will be created in Column H and the player's Baseball Reference link is created in Column J.
2. Repeat step 1 for the other player's you want to import into ootp.
3. Once you entered all the player's you want to import, Copy all the name & year data in Column H and paste it to notepad and save it. I usually save it in a folder called Historical Imports which I created in ootp's stats folder.
4. Multiple text files can be created by clearing out the data in Column F & G and repeating the above steps.
Here's an example screenshot of how it should look once you enter your players.
Attached Images
Image 

Last edited by Bigrod; 08-05-2014 at 05:23 PM.
Bigrod is offline   Reply With Quote
3 thanks for this post:
Jabez54 (08-03-2014), RANGER11JP (08-03-2014), txranger (07-28-2014)
Old 08-03-2014, 04:44 PM   #4
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,280
Thanks: 1,755
Thanked 222x in 161 posts
Thank you for the detailed illustration! So being as dense as I am, after I have saved my note, then what do I do to get those players into the game on a team of my choosing?

I know this is a feature, but I have yet to be able to use it.

Thank you for you help.

JP
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 08-03-2014, 06:21 PM   #5
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,846
Thanks: 9,325
Thanked 3,095x in 2,474 posts
Quote:
Originally Posted by RANGER11JP View Post
Thank you for the detailed illustration! So being as dense as I am, after I have saved my note, then what do I do to get those players into the game on a team of my choosing?

I know this is a feature, but I have yet to be able to use it.

Thank you for you help.

JP
in game under Fa or Draft screen import Historical player
A screen will load and you want to navigate your way to the My documents (my library for MAC) OOTP 15 stats folder and select the historical database.odb
Then put in the players ID example ruthba01 1927 set the other options and import. With Bigrod's program it makes using a notepad file really easy.

Bigrod thanx for redoing this i am going to make my version of Captain Walrus' All Time Baseball League over the next 2 weeks. and this will come in handy. Big is this an open office or Excel program?
__________________
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


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Old 08-05-2014, 04:26 PM   #6
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by The Game View Post
in game under Fa or Draft screen import Historical player
A screen will load and you want to navigate your way to the My documents (my library for MAC) OOTP 15 stats folder and select the historical database.odb
Then put in the players ID example ruthba01 1927 set the other options and import. With Bigrod's program it makes using a notepad file really easy.

Bigrod thanx for redoing this i am going to make my version of Captain Walrus' All Time Baseball League over the next 2 weeks. and this will come in handy. Big is this an open office or Excel program?
As it says in the first post, it's open office. However I converted it to 2 different excel formants, but I highly doubt that they work as MS likes to change things.
I forgot and left dropbox open and it auto updated the wrong file..it's using the name rather than the lahman ID in Column H..I'll update the link ASAP and let you know here as soon as it's ready. So sorry bout that..
Bigrod is offline   Reply With Quote
Old 08-05-2014, 05:03 PM   #7
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Link updated in my sig and first post..It now adds the player id and not the player name to column H.
Bigrod is offline   Reply With Quote
Old 08-05-2014, 05:42 PM   #8
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by RANGER11JP View Post
Thank you for the detailed illustration! So being as dense as I am, after I have saved my note, then what do I do to get those players into the game on a team of my choosing?

I know this is a feature, but I have yet to be able to use it.

Thank you for you help.

JP
First, if you downloaded historical importer before 8/5/14 redownload as that file was messed up.
Once you've copied the data in Column H and pasted to text editor and saved, simply import the players using ootp's auto import historical players from text file option.
Pretty sure they will go to the free agents pool.
Now you have to manually assigned them to the team you want if you didn't want them to go to their actual team for that year.
Another alternative if you've imported a lot of players, is to:
1. export the rosters.
2. open the rosters in any spreadsheet and make note of the team ids. They're the top portion of the rosters file.
2. locate the free agents sections. It's always at the bottom portion of the file.
3. Now locate the players that you imported and change the team ID from zero (no team) to the team's id that you want them to play for.
4. Save the rosters file as either a txt or csv (you can import either type).
5. Reimport the rosters and all the players you imported should be on their correct team.
Hope this helps
Bigrod is offline   Reply With Quote
Thank you for this post:
RANGER11JP (10-28-2014)
Old 08-08-2014, 11:00 AM   #9
jparker2112
All Star Reserve
 
Join Date: Nov 2012
Posts: 539
Thanks: 651
Thanked 206x in 142 posts
Do you have a version that works with Macs?
Im borderline a moron when it comes to this stuff and am having one hell of a time getting a file to use to import random era rookies into a draft pool. Any help would be SOOOOO appreciated!
Thanks!
jparker2112 is offline   Reply With Quote
Old 08-08-2014, 03:50 PM   #10
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by jparker2112 View Post
Do you have a version that works with Macs?
Im borderline a moron when it comes to this stuff and am having one hell of a time getting a file to use to import random era rookies into a draft pool. Any help would be SOOOOO appreciated!
Thanks!
Here's the link to the Mac version of open office. supports Apple MacOS X version 10.7 (Lion) - 10.9 (Mavericks).
Apache OpenOffice for MacOS X
My utility needs to be opened in a spreadsheet (open office) to work, even if the formulas don't work, the columns should still show so that you could look up the player info and manually add it to any text editor and save.
Or, if you don't want to bother with the fuss, just post or attach the player names and years you want to import here (just a simple text file will do) and I'll make the file for you..it's very simple.

Last edited by Bigrod; 12-10-2014 at 08:23 AM.
Bigrod is offline   Reply With Quote
Old 12-09-2014, 08:12 AM   #11
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Blog Entries: 25
Thanks: 395
Thanked 852x in 395 posts
created a OOTP Community Wiki | Historical Importer 2.0 page and loaded the file into the file gallery, i'll add it to ootpmods later, it's finally bedtime
__________________
.
"Never confuse composure for ease"
visit ootphub.com - The OOTP Community Hub, Home of OOTPmods.com
Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Thank you for this post:
Jabez54 (12-28-2014)
Old 12-10-2014, 08:22 AM   #12
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by jazzrack View Post
created a OOTP Community Wiki | Historical Importer 2.0 page and loaded the file into the file gallery, i'll add it to ootpmods later, it's finally bedtime
Thanks.. very nice of you...I'll be updating it to 3.0 as I do this years stats..3.0 will include all players up 2014 whereas 2.0 only goes to 2012 so it's missing a couple of years.
Bigrod is offline   Reply With Quote
Thank you for this post:
jazzrack (12-10-2014)
Old 12-12-2014, 05:53 AM   #13
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Blog Entries: 25
Thanks: 395
Thanked 852x in 395 posts
Quote:
Originally Posted by Bigrod View Post
Thanks.. very nice of you...I'll be updating it to 3.0 as I do this years stats..3.0 will include all players up 2014 whereas 2.0 only goes to 2012 so it's missing a couple of years.

now on OOTPmods

please let me know and we'll create new pages, ect.
__________________
.
"Never confuse composure for ease"
visit ootphub.com - The OOTP Community Hub, Home of OOTPmods.com
Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Thank you for this post:
Jabez54 (12-28-2014)
Old 12-28-2014, 11:04 AM   #14
MJDore
Minors (Rookie Ball)
 
Join Date: May 2004
Location: Nashville
Posts: 27
Thanks: 2
Thanked 2x in 2 posts
Bigrod...first of all, thanks for this. Very cool.

I'm following the steps laid out here and trying to test a few players as imports using your importer utility. I copy them to a txt file, import them as instructed and OOTP15 tells me they imported successfully and are available as free agents. However, i don't see the players. They don't show up anywhere. Any thoughts?

My goal is to put a league together of World Series participants of the last 30 years. I tried to do this using the built-in historical team features of OOTP15 but, for example, when I select 1995 Atlanta Braves, it's the Braves team as of the beginning of the 95 season. In other words, the ratings are based on 1994 stats so someone like Chipper Jones won't fare well (in my opinion). What I'm wanting is the stats and team for the completed 1995 season. So, I tried using your importer to accomplish this and got nothing. Any thoughts?
__________________
"Throw some groundballs. They're more democratic." - 'Crash' Davis, Bull Durham
MJDore is offline   Reply With Quote
Old 12-28-2014, 02:25 PM   #15
MJDore
Minors (Rookie Ball)
 
Join Date: May 2004
Location: Nashville
Posts: 27
Thanks: 2
Thanked 2x in 2 posts
Thinking it has something to do with my starting year but I can't seem to find the help I need in the manual. If I have, say, 60 different teams from the last 30 years, does the year I select for starting the league matter? Trying to figure this thing out. I've played OOTP a long time and I'm comfortable with the functions but I've never done a historical league.
__________________
"Throw some groundballs. They're more democratic." - 'Crash' Davis, Bull Durham
MJDore is offline   Reply With Quote
Old 12-28-2014, 08:06 PM   #16
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Quote:
Originally Posted by MJDore View Post
Bigrod...first of all, thanks for this. Very cool.

I'm following the steps laid out here and trying to test a few players as imports using your importer utility. I copy them to a txt file, import them as instructed and OOTP15 tells me they imported successfully and are available as free agents. However, i don't see the players. They don't show up anywhere. Any thoughts?

My goal is to put a league together of World Series participants of the last 30 years. I tried to do this using the built-in historical team features of OOTP15 but, for example, when I select 1995 Atlanta Braves, it's the Braves team as of the beginning of the 95 season. In other words, the ratings are based on 1994 stats so someone like Chipper Jones won't fare well (in my opinion). What I'm wanting is the stats and team for the completed 1995 season. So, I tried using your importer to accomplish this and got nothing. Any thoughts?
Glad you like it.
Your free agents are there..best way to find them and do what you want is after you import all players....export that lgs. rosters..the/your imported free agents will all be at the bottom of the rosters file under the //free agents section.
Now to assign them to actual teams, look at the top of the rosters and get the team ids. Enter the correct team id in the team id column for each free agent. Once done, reimport the rosters.
Hint: Easiest way to assign players to teams is to open the rosters.txt file in a spreadsheet and create a vlookup table. It'll save a ton of time.

As for your game's starting year...it doesn't matter and does not affect your import of historical players.

Last edited by Bigrod; 12-28-2014 at 08:15 PM.
Bigrod is offline   Reply With Quote
Thank you for this post:
MJDore (01-01-2015)
Old 12-31-2014, 10:04 AM   #17
MJDore
Minors (Rookie Ball)
 
Join Date: May 2004
Location: Nashville
Posts: 27
Thanks: 2
Thanked 2x in 2 posts
Ok. I figured out what was going on. Even after the game was telling me I successfully uploaded the players, exported the roster files, and looked for them in the free agents section of the export they weren't there. Then I noticed what OOTP15 is looking for in terms of the structure of the upload. Check out the pic. The format is wants is player01,1998 not player01.1988. Comma, not a period. Once I fixed this the upload was perfect and everything worked fine. Just FYI. I can fix the Excel file but thought I'd let you know for others who may be struggling.

Happy New Year.
__________________
"Throw some groundballs. They're more democratic." - 'Crash' Davis, Bull Durham
MJDore is offline   Reply With Quote
Thank you for this post:
Jabez54 (12-31-2014)
Old 12-31-2014, 08:16 PM   #18
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,344
Thanked 2,050x in 1,179 posts
Thanks MJ hard to believe I or others didn't catch that error before now.
It's fixed and dl link updated. A newer version will be out soon.
Bigrod is offline   Reply With Quote
2 thanks for this post:
Jabez54 (12-31-2014), MJDore (01-01-2015)
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:44 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