|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
05-17-2015, 08:13 AM | #41 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,803
|
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.
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
05-17-2015, 03:16 PM | #42 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
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. |
|
06-08-2015, 04:12 PM | #43 |
Minors (Double A)
Join Date: Feb 2015
Location: KANSAS
Posts: 127
|
I am not that good with computers. I have download the files how and where do I open them?
|
06-09-2015, 11:02 PM | #44 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
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. |
|
06-30-2015, 04:56 PM | #45 | |
All Star Starter
Join Date: Jun 2002
Posts: 1,353
|
Quote:
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 |
|
07-01-2015, 04:37 PM | #46 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
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. |
|
07-11-2015, 06:15 PM | #47 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,803
|
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..
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
07-13-2015, 02:27 AM | #48 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
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. |
|
07-13-2015, 02:33 AM | #49 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
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. |
07-13-2015, 02:40 AM | #50 |
OOTP Developments
Join Date: Aug 2007
Location: Nice, Côte d'Azur, France
Posts: 19,883
|
As always Rod, you're the best!
|
07-16-2015, 07:22 PM | #51 |
Bat Boy
Join Date: Nov 2009
Posts: 18
|
How Do I
I have downloaded & unzipped the file. How do I get the program to run?
|
07-16-2015, 08:26 PM | #52 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,803
|
Do you have OpenOffice?
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
08-09-2015, 03:07 PM | #53 |
Minors (Triple A)
Join Date: Jan 2010
Location: Orange City, FL
Posts: 260
|
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 |
11-06-2015, 01:57 PM | #54 | |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,803
|
Quote:
__________________
Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong" |
|
11-12-2015, 02:19 PM | #55 |
All Star Reserve
Join Date: Mar 2002
Location: Queens, NY
Posts: 908
|
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.
|
11-12-2015, 02:36 PM | #56 |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
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
|
09-15-2017, 03:37 PM | #57 |
Minors (Rookie Ball)
Join Date: Jan 2011
Posts: 20
|
Does anyone still have this?I've been looking for a good link foever.
|
Bookmarks |
Tags |
historical import, utility ootp |
|
|