OOTP Developments Forums - View Single Post

Bigrod · 01-09-2015, 05:29 PM

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.

01-09-2015, 05:29 PM	#1
Bigrod 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.