Home | Webstore
Latest News: OOTP Update 20.6 - OOTP 20 Available - FHM 6 Available

FHM 6 Available Now!

  

Go Back   OOTP Developments Forums > Prior Versions of Our Games > Out of the Park Baseball 16 > OOTP 16 - New to the Game?

OOTP 16 - New to the Game? If you have basic questions about the the latest version of our game, please come here!

Reply
 
Thread Tools
Old 02-27-2016, 05:05 PM   #1
jcondor
Bat Boy
 
Join Date: Feb 2016
Location: Texas
Posts: 8
Thanks: 3
Thanked 0x in 0 posts
Importing Prior Season into new OOTP game stats/ratings

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?
jcondor is offline   Reply With Quote
Old 02-28-2016, 08:45 PM   #2
OBSL Commish
All Star Reserve
 
OBSL Commish's Avatar
 
Join Date: Aug 2010
Posts: 937
Thanks: 1,959
Thanked 324x in 211 posts
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.
OBSL Commish is offline   Reply With Quote
Old 02-28-2016, 11:38 PM   #3
jcondor
Bat Boy
 
Join Date: Feb 2016
Location: Texas
Posts: 8
Thanks: 3
Thanked 0x in 0 posts
Quote:
Originally Posted by OBSL Commish View Post
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?
jcondor is offline   Reply With Quote
Old 02-29-2016, 07:31 AM   #4
OBSL Commish
All Star Reserve
 
OBSL Commish's Avatar
 
Join Date: Aug 2010
Posts: 937
Thanks: 1,959
Thanked 324x in 211 posts
I'll post it later on tonight after work.
OBSL Commish is offline   Reply With Quote
Old 02-29-2016, 09:51 PM   #5
jcondor
Bat Boy
 
Join Date: Feb 2016
Location: Texas
Posts: 8
Thanks: 3
Thanked 0x in 0 posts
Quote:
Originally Posted by OBSL Commish View Post
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?
jcondor is offline   Reply With Quote
Old 03-01-2016, 09:33 PM   #6
OBSL Commish
All Star Reserve
 
OBSL Commish's Avatar
 
Join Date: Aug 2010
Posts: 937
Thanks: 1,959
Thanked 324x in 211 posts
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 is offline   Reply With Quote
Old 03-01-2016, 11:48 PM   #7
jcondor
Bat Boy
 
Join Date: Feb 2016
Location: Texas
Posts: 8
Thanks: 3
Thanked 0x in 0 posts
Thanks for Macro

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?
jcondor is offline   Reply With Quote
Old 03-02-2016, 07:34 AM   #8
OBSL Commish
All Star Reserve
 
OBSL Commish's Avatar
 
Join Date: Aug 2010
Posts: 937
Thanks: 1,959
Thanked 324x in 211 posts
QS stands for Quickstart. You have the option to make a new quickstart on the OOTP Start screen.
OBSL Commish is offline   Reply With Quote
Old 03-02-2016, 11:26 PM   #9
jcondor
Bat Boy
 
Join Date: Feb 2016
Location: Texas
Posts: 8
Thanks: 3
Thanked 0x in 0 posts
Quote:
Originally Posted by OBSL Commish View Post
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?
jcondor is offline   Reply With Quote
Old 03-03-2016, 08:36 AM   #10
OBSL Commish
All Star Reserve
 
OBSL Commish's Avatar
 
Join Date: Aug 2010
Posts: 937
Thanks: 1,959
Thanked 324x in 211 posts
Quote:
Originally Posted by jcondor View Post
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.
OBSL Commish is offline   Reply With Quote
2 thanks for this post:
endgame (03-03-2016), PoorBoy2001 (04-16-2019)
Old 04-16-2019, 05:03 PM   #11
PoorBoy2001
Bat Boy
 
Join Date: Apr 2010
Posts: 9
Thanks: 1
Thanked 1x in 1 post
Kudos

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.....)

Quote:
Originally Posted by OBSL Commish View Post
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.
PoorBoy2001 is offline   Reply With Quote
Thank you for this post:
OBSL Commish (04-16-2019)
Old 04-16-2019, 05:17 PM   #12
OBSL Commish
All Star Reserve
 
OBSL Commish's Avatar
 
Join Date: Aug 2010
Posts: 937
Thanks: 1,959
Thanked 324x in 211 posts
Quote:
Originally Posted by PoorBoy2001 View Post
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.
OBSL Commish is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:51 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments