Importing Prior Season into new OOTP game stats/ratings

[jcondor]

When OOTP 17 comes out and I import my OOTP 16 league, will the 2015 stats and ratings for the MLB 2015 season be reflected in my old league I imported which had 2014 stats and ratings?

For example, will Jake Arieta of the Chicago Cubs be in his 2015 Cy Young winning form when I play OOTP 17 after I import my old game in OOTP 16?

[OBSL Commish]

No, you'll have to update those yourself. I have an Excel macro that I use to do the ratings. The stats would take a little more time.

[jcondor]

Originally Posted by OBSL Commish

No, you'll have to update those yourself. I have an Excel macro that I use to do the ratings. The stats would take a little more time.

Would you mind to share with me how I can get the macro that would update all the ratings? Or is it somewhere on the forum I can download?


Is the macro hard to run?

[OBSL Commish]

I'll post it later on tonight after work.

[jcondor]

Originally Posted by OBSL Commish

I'll post it later on tonight after work.

Awesome. Thank you so much.

I see your tagline is OBSL Commish. Are you a commissioner of an online OOTP league?

[OBSL Commish]

Sorry it took me so long, but here's the Excel macro I was talking about:

https://www.dropbox.com/s/q2q6dsuguj...ater.xlsm?dl=0

You'll have to do a little bit of setup with this file and your files beforehand to get this to work. I was a commish of an online league for a few years so I have my league's name listed in this file. You'll have to change that to your file's name.

First, when the new version of OOTP comes out, make a QS with the MLB QS they have in-game and then export the MLB rosters to a text file. Do the same with the rosters in the league you want to update. Next, open each file in Excel. When the Text Import Wizard comes up, choose Delimited, then Comma, and Finish. Next, click the square that connects the columns and rows in the upper left of the sheet so that every cell is highlighted. Click Sort, then Custom Sort by Column E and then Column F so that all the data will begin with the players in alphabetical order under the ratings categories. Once you've done that for both files, save them both as .csv files (comma delimited) with the names "obsl_rosters" as your league file and "updated_rosters" as the MLB QS file. For some reason, the macro won't work if you change the names in the code. And make sure you save them in the same folder.

Now, open the Excel macro I've attached here and click "Update OBSL Rosters". When the window pops up, select both .csv files and click Open. The file may run for a few minutes. When it finishes, the file will have two new tabs at the bottom: obsl_rosters and updated_rosters. On the obsl_rosters tab, the players who got updated ratings will be in blue and the untouched players will be in black. On the updated_rosters tab, the updated players will be in black and the untouched players in red. This makes it easy to sort out the players you may want to add into your game. If you want to do that, count the number of players who weren't updated in the updated_rosters file and then add that number of fictional players in your league. You may want to run this macro once just to get a count of those players before you import the new ratings into your league. That way, you can add the fictional players to the league and then copy and paste the untouched players from one file to the other and import everything all at once.

Hopefully, that works well for you. If you have any questions, just ask.

[jcondor]

Thank you for the Macro. However having some difficulty understanding what you are saying. When you say when the new OOTP 17.0 comes out you mention about a "QS" file. What is that?

[OBSL Commish]

QS stands for Quickstart. You have the option to make a new quickstart on the OOTP Start screen.

[jcondor]

Originally Posted by OBSL Commish

QS stands for Quickstart. You have the option to make a new quickstart on the OOTP Start screen.

Thank you very much. Not sure I understand everything you typed. I have not worked with csv files before. When OOTP 17 comes out I may be reaching out to you to help me if you don't mind?

[OBSL Commish]

Originally Posted by jcondor

Thank you very much. Not sure I understand everything you typed. I have not worked with csv files before. When OOTP 17 comes out I may be reaching out to you to help me if you don't mind?

A .csv file is just Excel's version of a comma-separated file, which means that the data in it is separated by commas rather than listed in individual cells. When you export the rosters, they will come out in comma-separated text files. Excel is the easiest way to sort all the data. Let me know if you need any help.

[PoorBoy2001]

Hey OBSL Commish - I just wanted to say a public thank you for posting this utility. I'm involved in a league now entering it's 22nd year and we had really struggled to upgrade the OOTP player ratings from year to year. Your util worked wonderfully for us, saving hours and hours of work that we previously had to do.

Well done! (now if only the rosters.txt file had fields for injury ratings.....)

Originally Posted by OBSL Commish

Sorry it took me so long, but here's the Excel macro I was talking about:

https://www.dropbox.com/s/q2q6dsuguj...ater.xlsm?dl=0

You'll have to do a little bit of setup with this file and your files beforehand to get this to work. I was a commish of an online league for a few years so I have my league's name listed in this file. You'll have to change that to your file's name.

First, when the new version of OOTP comes out, make a QS with the MLB QS they have in-game and then export the MLB rosters to a text file. Do the same with the rosters in the league you want to update. Next, open each file in Excel. When the Text Import Wizard comes up, choose Delimited, then Comma, and Finish. Next, click the square that connects the columns and rows in the upper left of the sheet so that every cell is highlighted. Click Sort, then Custom Sort by Column E and then Column F so that all the data will begin with the players in alphabetical order under the ratings categories. Once you've done that for both files, save them both as .csv files (comma delimited) with the names "obsl_rosters" as your league file and "updated_rosters" as the MLB QS file. For some reason, the macro won't work if you change the names in the code. And make sure you save them in the same folder.

Now, open the Excel macro I've attached here and click "Update OBSL Rosters". When the window pops up, select both .csv files and click Open. The file may run for a few minutes. When it finishes, the file will have two new tabs at the bottom: obsl_rosters and updated_rosters. On the obsl_rosters tab, the players who got updated ratings will be in blue and the untouched players will be in black. On the updated_rosters tab, the updated players will be in black and the untouched players in red. This makes it easy to sort out the players you may want to add into your game. If you want to do that, count the number of players who weren't updated in the updated_rosters file and then add that number of fictional players in your league. You may want to run this macro once just to get a count of those players before you import the new ratings into your league. That way, you can add the fictional players to the league and then copy and paste the untouched players from one file to the other and import everything all at once.

Hopefully, that works well for you. If you have any questions, just ask.

[OBSL Commish]

Originally Posted by PoorBoy2001

Hey OBSL Commish - I just wanted to say a public thank you for posting this utility. I'm involved in a league now entering it's 22nd year and we had really struggled to upgrade the OOTP player ratings from year to year. Your util worked wonderfully for us, saving hours and hours of work that we previously had to do.

Well done! (now if only the rosters.txt file had fields for injury ratings.....)

My pleasure, PoorBoy! I'm glad you were able to use it successfully.