|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
01-09-2015, 05:29 PM | #1 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Historical Importer 3.0 Plus
Updated 4/11/15:
Now fully supports Spritze's latest database.(28,291 players) Fixed: 36 duplicate player names. Added middle initial/name. Expanded formulas to accomodate up to 30,000 players. Previous updates: 1.Added the import to team feature using text file introduced in ootp16. It's now possible to create entire team rosters. Just import the correct players and if their in the master.csv, Enter the team name plus year and they'll import to the correct team. 2.Added all Team IDs in ootp16 to vlookup table. You'll have to add your own teams and their correct ID to the vlookup sheet for fictional lgs or historical minor lg. teams. 3. Added the year to the end of the team names in vlookup to make sure players go to the correct team. Make sure you add the year to the team name when assigning players to teams else it won't auto add the team id. Download links 7zip file: Historical 3.0 Plus OOTP Default Database 3.0 For Spritze's Database Last yr. I released Historical Importer 2.0 for ootp that automated the creation of text files that ootp can use to auto import historical players. 3.0 Plus does the same and has more features. Works with all versions of ootp that allows you to import data via text file as well as Spritze's latest database here: Spritze Note: Import to team only works in ootp 16. Previous versions did not have this feature. Unfortunately, I don't have excel so one will need Apache Open Office (it's free) as this is just a simple spreadsheet utility. The features in 3.0 Plus so far are: 1. Updated to include all players with a lahman ID up to & including 2014 MLB debuts. 18,414 players in all. Fully sortable by name, year, country, state, city. Formulas will auto adjust so that data and links will/should always be correct. 2. Auto creates the correct text format (lahmanID,Year,TeamID) in its own column for use with ootp's historical import from text file feature. Just copy your finished results from that column to any text program and save. No limit on the number of players that can be imported at once. 3. You can create multiple text files on one sheet. No need to add separate sheets. Just clear the columns after you've copied it to your text editor. 4. Auto creation of the players bbref MLB page link. Just click the link to goto the player's bbref page. 5. Search players, teams, team affiliates, etc. on bbref's site. Simply input the players name or team abbreviation in caps (BOS,BAL). You can search teams by year as well. 6. Auto generated player page links can be used internally (using open office's built in Import data from external source) to automate importing any players/teams bbref stats (hitting, fielding, pitching, rosters and more) to a separate sheet in Open Office. Once imported, format them to ootp's specs and save as .txt files for import to ootp. 7. Fully expandable and editable by users. No data is locked or hidden that can't be unlocked and shown as nothing is password protected. 8. All columns that I felt needed them, have help comments and you need to read them. (Hidden by default). just hover your mouse over the cell to see them or unprotect the sheet & right click the column title and click show comment. Any comments, problems, questions or suggestions. Post them here. If I don't respond within 24hrs. send me a PM please. Note: 1. Although this is an Open Office file, it may well import to excel, but I highly doubt that the formulas will work so you'll have to get creative with that. 2. All sheets are protected and some columns are hidden. Read the comments if you don't know how to show the columns or unprotect the sheets. Enjoy. Last edited by Bigrod; 04-11-2015 at 12:57 AM. |
01-09-2015, 05:34 PM | #2 |
All Star Starter
Join Date: May 2013
Location: Philadelphia
Posts: 1,245
|
I get Error(403), from Dropbox. Did you actually share the file, or did you just copy your own personal link?
|
01-10-2015, 07:11 AM | #3 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
Should work fine now...not sure what happened. Last edited by Bigrod; 01-10-2015 at 07:30 AM. |
|
01-10-2015, 04:51 PM | #4 |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
It just worked for me
__________________
"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
|
01-10-2015, 05:24 PM | #5 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
|
01-11-2015, 09:02 PM | #6 |
All Star Starter
Join Date: May 2013
Location: Philadelphia
Posts: 1,245
|
Just worked. Thanks!
|
01-16-2015, 02:47 PM | #8 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
1. Give all players without a lahman ID a fake ID and make sure it's not the same as any other player's lahman id(you can use their bbref minors id for this purpose if you want it doesn't matter as long as it's unique). OOTP only imports player's according to their lahmanID irregardless of what other's may say. 2. Make sure those players have a Debut Year in the Debut Column (for those that don't have a lahman ID it would be the year they first appeared on any team in our database) and last yr. played in the Last yr. played column. For players still playing, last yr. is the current yr. (for ootp 15 it would be 2013 and for 16 it would be 2014). BTW: I add the minor lg. stats every year for ootp and any player born during and after 1986, have their complete real life stats in our db. Only exceptions are the new leagues (DSL, VSL, Mexican as well as Int'l lgs.) that were added in 15. Those players may only have their 2013 stats as I didn't do those. Ootp's process when importing from a text file, is to first lookup the lahman id in the master, then it looks for the year. It uses the year to import the player's associated data in other files (hitting, pitching, fielding, etc.) according to your import settings. You don't need to do anything with the "other" files. I didn't include a modded master because once ootp 16 is out, I'm going to rewrite the utility...I got Markus to add a new feature which I can't say anything about until then. It's going to be awesome...I'll be testing it when beta starts and if it works like it's supposed to, I'll include a modded master.csv. Current plans are to have it ready for release same day as ootp16 Last edited by Bigrod; 01-16-2015 at 02:54 PM. |
|
01-21-2015, 02:57 PM | #9 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,803
|
Does this include any Negro league players from their rookie year and not just ones who played MLB?
__________________
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" |
01-22-2015, 12:38 PM | #10 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
It'll be a new feature and will also add more players. Can't say anymore than that at the moment. If you have a special request, now's the time to let me know. I'll do my best to include it. |
|
01-23-2015, 10:43 PM | #11 | |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
Quote:
__________________
"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
|
|
01-24-2015, 03:44 AM | #12 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
What the heck. Doubt Markus will fire me..
Got him to add a feature...you'll be able to import historical players directly to teams as long as those teams have a lahman team id. Works only when importing with a text file. Gonna need to test it out as soon as beta starts. If all goes well, should be able to import complete historical rosters. No more messing with moving free agents to teams. Not sure yet if I'll be able to get it to work with historical minor lg. teams or not. Sure gonna try though. Plus all the new 2014 players will be added. |
01-24-2015, 06:35 AM | #13 | |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
Quote:
__________________
"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
|
|
01-24-2015, 02:42 PM | #14 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Yes as long as that team is in ootp's historical files. I'll know more for sure once testing starts in a few days.
Last edited by Bigrod; 01-24-2015 at 02:47 PM. |
02-03-2015, 11:31 PM | #15 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
So the new answer to your question is: Yes on the players lahman ID. No they don't have to be in the historical lg. your importing them to. Team ID is the ID that you see on the edit league structure page or you can get them by exporting the roster files. So to import a player(s) to a team, you would use: LahmanID,year,teamID. As long as the players are in the Master.csv your using, you can import them directly to the team rosters whether it's fictional, historical or anything in between. Last edited by Bigrod; 02-03-2015 at 11:42 PM. |
|
02-04-2015, 05:35 AM | #16 | |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
Quote:
BIG THANKS to Bigrod +100
__________________
"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
|
|
02-04-2015, 10:20 PM | #17 | |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Quote:
One thing...when I tested this out I had to add some players to the master.csv (the master.csv only contains players that have debuted in MLB)...cause I was creating historical minors. I also had to rename the historical.odb file as it conflicted with the master.csv. Renaming or moving the historical.odb file isn't necessary if you just copy all the other files in the stats folder to another folder and set ootp's path to use it. I'll try to release the updated version when 16 preorder is released so's not to violate my DNR contract or whatever its called. |
|
02-05-2015, 12:36 PM | #18 | |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
Quote:
__________________
"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
|
|
03-07-2015, 10:14 PM | #19 |
All Star Reserve
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
|
So still the plan to release the next version when OOTP pre-order day arrives (soon but not soon enough)
__________________
"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
|
03-24-2015, 04:05 PM | #20 |
OOTP Stats Master
Join Date: Mar 2009
Location: Maine
Posts: 3,075
|
Within the next week or so, I'll be updating and adding the 2014 debuts and facilitating the import to team so that the correct format auto fills as you add players.
|
Bookmarks |
Tags |
historical import, utility ootp |
|
|