OOTP Developments Forums - View Single Post

thehef · 05-10-2024, 03:26 AM

I don't think such a thing exists. But you can probably create your own. If you have some basic Excel skills, you can try this:

1. Navigate to your ...Out of the Park Baseball 25\data\stats folder
2. Find the MilbTeams.csv file and make a copy of it
3. Open the copy (it will open in Excel) and save it as an Excel file
4. Highlight cells H thru AP and then Hide them; highlight cells AU thru AW and hide those, too; and highlight cells AZ thru BB and hide them (since you are working with a copy saved to Excel, you'd be safe deleting these fields instead of hiding them). This will leave you with structure type fields...
5. Sort the data by the following fields: yearID, LeagueName, TeamID
6. Using your filter, de-select (filter out) all years prior to 1919 (this is when OOTP begins including minor leagues; if you are interested in seeing Federal League teams, then filter years prior to 1914)
7. Using your filter on the TeamID column, de-select blank values (these teams won't be in OOTP)

This will basically leave you with all of the minor league teams that OOTP includes (plus some: the above steps will still likely result in a few more teams in your file than OOTP actually includes, but it'll be close enough).

The TeamID field is the same as OOTP's abbreviation field... Note that the above steps are fairly generic. For steps 4 through 7 you can easily modify those so the results of the filtering suit your preferences. For example, you might not want to see the Park name nor have any use for the MiLBFranchise id. If so, you can include those fields in the ones you hide or delete in step 4. Or maybe you are only interested in current era minors, so in step 5 you could de-select all years prior to, say, 2016...

This may work for you. However, if a) you just want a TeamID-to-(team)name conversion and have no use for you 30 interations of the Hollywood Stars (one for each year of their existence), and b) you also have some more advanced knowledge and can do pivot tables, then you could create a smaller file that merely includes each abbreviation used in OOTP, and the corresponding team name...

05-10-2024, 03:26 AM	#2
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,380	I don't think such a thing exists. But you can probably create your own. If you have some basic Excel skills, you can try this: 1. Navigate to your ...Out of the Park Baseball 25\data\stats folder 2. Find the MilbTeams.csv file and make a copy of it 3. Open the copy (it will open in Excel) and save it as an Excel file 4. Highlight cells H thru AP and then Hide them; highlight cells AU thru AW and hide those, too; and highlight cells AZ thru BB and hide them (since you are working with a copy saved to Excel, you'd be safe deleting these fields instead of hiding them). This will leave you with structure type fields... 5. Sort the data by the following fields: yearID, LeagueName, TeamID 6. Using your filter, de-select (filter out) all years prior to 1919 (this is when OOTP begins including minor leagues; if you are interested in seeing Federal League teams, then filter years prior to 1914) 7. Using your filter on the TeamID column, de-select blank values (these teams won't be in OOTP) This will basically leave you with all of the minor league teams that OOTP includes (plus some: the above steps will still likely result in a few more teams in your file than OOTP actually includes, but it'll be close enough). The TeamID field is the same as OOTP's abbreviation field... Note that the above steps are fairly generic. For steps 4 through 7 you can easily modify those so the results of the filtering suit your preferences. For example, you might not want to see the Park name nor have any use for the MiLBFranchise id. If so, you can include those fields in the ones you hide or delete in step 4. Or maybe you are only interested in current era minors, so in step 5 you could de-select all years prior to, say, 2016... This may work for you. However, if a) you just want a TeamID-to-(team)name conversion and have no use for you 30 interations of the Hollywood Stars (one for each year of their existence), and b) you also have some more advanced knowledge and can do pivot tables, then you could create a smaller file that merely includes each abbreviation used in OOTP, and the corresponding team name...