Home | Webstore
Latest News: OOTP Update 20.5 - 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-17-2015, 08:13 AM   #41
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,066x in 2,448 posts
Quote:
Originally Posted by Bigrod View Post
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.
Yes you can except in cases where the players 1st name is initials, Like AJ Pierzynski, AJ Burnett etc. BB ref drops the 2nd initial. But if you still use both it still imports them.
__________________
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 05-17-2015, 03:16 PM   #42
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 The Game View Post
Yes you can except in cases where the players 1st name is initials, Like AJ Pierzynski, AJ Burnett etc. BB ref drops the 2nd initial. But if you still use both it still imports them.
Do you want 100% accuracy and have everyone import correctly the first time or 95% and then wonder why that person didn't import??
It's ok if you know what your doing, but if your new to ootp, it's best to do it the right way to avoid problems IMHO.

Last edited by Bigrod; 05-17-2015 at 03:18 PM.
Bigrod is offline   Reply With Quote
Old 06-08-2015, 04:12 PM   #43
THEMURPH
Minors (Double A)
 
Join Date: Feb 2015
Location: KANSAS
Posts: 113
Thanks: 224
Thanked 28x in 22 posts
I am not that good with computers. I have download the files how and where do I open them?
THEMURPH is offline   Reply With Quote
Old 06-09-2015, 11:02 PM   #44
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 THEMURPH View Post
I am not that good with computers. I have download the files how and where do I open them?
The importer is an Open Office spreadsheet file. You would need to install Open Office in order to use it. If you're not that familiar with spreadsheets, or installing software, then you may not want to use this. The version of Open Office I use is here:
Download Apache OpenOffice from SourceForge.net
You only need to install the Calc portion. You don't need the rest of the stuff.
Latest version 4.1.1 is here:
https://www.openoffice.org/download/
It's free and all I use.
Bigrod is offline   Reply With Quote
Old 06-30-2015, 04:56 PM   #45
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
Quote:
Originally Posted by Bigrod View Post
The importer is an Open Office spreadsheet file. You would need to install Open Office in order to use it. If you're not that familiar with spreadsheets, or installing software, then you may not want to use this. The version of Open Office I use is here:
Download Apache OpenOffice from SourceForge.net
You only need to install the Calc portion. You don't need the rest of the stuff.
Latest version 4.1.1 is here:
https://www.openoffice.org/download/
It's free and all I use.
Hello BigRod,
Could you elaborate on the debut columns and use of ID's and such? I am trying to get some control over imports in Spritze's DB (or the OOTP one or others) that start around 1855. I would like to not have do each individually, so I am thinking of other alternatives to doing that.
Any information that you think may be pertinent would be appreciated.
Thank you.
JP
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 07-01-2015, 04:37 PM   #46
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 RANGER11JP View Post
Hello BigRod,
Could you elaborate on the debut columns and use of ID's and such? I am trying to get some control over imports in Spritze's DB (or the OOTP one or others) that start around 1855. I would like to not have do each individually, so I am thinking of other alternatives to doing that.
Any information that you think may be pertinent would be appreciated.
Thank you.
JP
Dubut columns are the year that the actual player first appeared in the MLB. This would be the earliest yr. or if the player has multiple years, it can be any year your want in between those years.
Lahman IDs are what ootp uses to find the player(s) to import and it always uses the Lahman type id. In Spritze's db, he creates the lahman id if it's not already in ootp's master and you have to use his lahman ids.
If you're creating your own master, that lahman id can be anything as long as it's unique to that player.
Note: the ootp and lahman id column headers are reversed. So ootp ids are in the lahman column and lahman ids are in the ootp column. I've no clue why it's like that.
Team ids are used to assign a player to the correct team according to year.
As of ootp16, your can import a player directly to any team in your saved game. Be it fictional or real. Just add the team id found on the edit structure page or from the exported rosters.txt file to the end of your import. If the team is already in the db, ootp will auto find it and place the player on the correct team.
Not sure if any of this info is what your looking for or not so just ask if it isn't.
I'm wicked busy currently, so if I don't respond quickly..PM me and refer to your post..thanks.
Bigrod is offline   Reply With Quote
Thank you for this post:
RANGER11JP (07-02-2015)
Old 07-11-2015, 06:15 PM   #47
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,066x in 2,448 posts
Bigrod, can you include instructions on how to use this? i have used it once before but not with the Spritze dB update. i type in a name and the year and i don't see how to get a txt from it..
Attached Images
Image 
__________________
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
Thank you for this post:
RANGER11JP (07-11-2015)
Old 07-13-2015, 02:27 AM   #48
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 The Game View Post
Bigrod, can you include instructions on how to use this? i have used it once before but not with the Spritze dB update. i type in a name and the year and i don't see how to get a txt from it..
Works the same as the other and instructions are in the column header's comments (Cells with comments will have a tiny red box in the upper right corner).
Spritze's db uses middle initials for some players, just as ootp does for some of them.
You need to use:
Frank E. Thomas for Frank Thomas of the White Sox.
There's a problem with the 2nd row's formulas...that's why Jack doesn't show anything: I've fixed that problem and edited the comment for the Enter Player Column to Warn about middle initials..just redownload it from the first post.
Thanks a ton for catching that...surprised no one else did.

Last edited by Bigrod; 07-13-2015 at 02:36 AM.
Bigrod is offline   Reply With Quote
2 thanks for this post:
Lukas Berger (07-13-2015), The Game (07-13-2015)
Old 07-13-2015, 02:33 AM   #49
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 2,998
Thanks: 2,343
Thanked 2,050x in 1,179 posts
7/13/15: Updated the importer for Spritze's DB. Row 2 had the formulas messed up. Also edited the comment for the "Enter Player's Name Column" to reflect the fact that some players need their middle initials.
Example: Frank Thomas of the White Sox needs to be Frank E Thomas to import him correctly.
Thanks to The Game for catching this.
Link in first post is auto updated..please redownload.
Thanks

Last edited by Bigrod; 07-13-2015 at 02:38 AM.
Bigrod is offline   Reply With Quote
2 thanks for this post:
Lukas Berger (07-13-2015), RANGER11JP (07-13-2015)
Old 07-13-2015, 02:40 AM   #50
Lukas Berger
OOTP Developments
 
Lukas Berger's Avatar
 
Join Date: Aug 2007
Location: Nice, Côte d'Azur, France
Posts: 11,862
Thanks: 18,725
Thanked 8,707x in 4,378 posts
As always Rod, you're the best!
Lukas Berger is offline   Reply With Quote
Thank you for this post:
Bigrod (07-13-2015)
Old 07-16-2015, 07:22 PM   #51
gekko485
Bat Boy
 
Join Date: Nov 2009
Posts: 15
Thanks: 0
Thanked 3x in 3 posts
How Do I

I have downloaded & unzipped the file. How do I get the program to run?
gekko485 is offline   Reply With Quote
Old 07-16-2015, 08:26 PM   #52
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,066x in 2,448 posts
Quote:
Originally Posted by gekko485 View Post
I have downloaded & unzipped the file. How do I get the program to run?
Do you have OpenOffice?
__________________
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-09-2015, 03:07 PM   #53
yazfan67
Minors (Triple A)
 
yazfan67's Avatar
 
Join Date: Jan 2010
Location: Orange City, FL
Posts: 223
Thanks: 347
Thanked 74x in 55 posts
Okay, I have Open Office now and have imported the Historical Importer for Spritze. Now how do I build the league I am trying to make (All HOF, ROY, Cy Young, Gold Glove, MVP, etc) into one league and have them start as rookies? Does It matter what year I start my league? Do I put them in a new database from HI3?
__________________
When they start the game, they don't yell, "Work ball." They say, "Play ball." ~Willie Stargell, 1981
yazfan67 is offline   Reply With Quote
Old 11-06-2015, 01:57 PM   #54
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,066x in 2,448 posts
Quote:
Originally Posted by yazfan67 View Post
Okay, I have Open Office now and have imported the Historical Importer for Spritze. Now how do I build the league I am trying to make (All HOF, ROY, Cy Young, Gold Glove, MVP, etc) into one league and have them start as rookies? Does It matter what year I start my league? Do I put them in a new database from HI3?
Did you ever figure this out?
__________________
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 11-12-2015, 02:19 PM   #55
D Love
All Star Reserve
 
Join Date: Mar 2002
Location: Queens, NY
Posts: 908
Thanks: 5
Thanked 8x in 3 posts
Pardon the possibly dumb question, but having been away from OOTP for 10 years, can this mod help import league history? I am hitting a wall trying to find a way to import OOTP6 historical data into OOTP2007 as I try to convert a particular league all the way to OOTP16. From league history (champs, award winners, etc.) to individual histories, I was looking for a way to do it.
D Love is offline   Reply With Quote
Old 11-12-2015, 02:36 PM   #56
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Covington, KY
Posts: 650
Thanks: 224
Thanked 265x in 182 posts
Unfortunately no
__________________
"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
Old 09-15-2017, 03:37 PM   #57
telarc30
Minors (Rookie Ball)
 
Join Date: Jan 2011
Posts: 20
Thanks: 6
Thanked 8x in 4 posts
Does anyone still have this?I've been looking for a good link foever.
telarc30 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 09:14 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