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

  

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

OOTP 14 - New to the Game? If you have basic questions about the game, please come here!

Reply
 
Thread Tools
Old 01-02-2014, 07:51 PM   #21
Ramicus
Minors (Rookie Ball)
 
Join Date: Dec 2013
Posts: 38
Thanks: 34
Thanked 4x in 4 posts
I know how to export rosters.

I don't, but need to, know how to export standings.
I don't, but need to, know how to export a schedule.
I don't, but need to, know how to export a list of game results.
Ramicus is offline   Reply With Quote
Old 01-02-2014, 08:22 PM   #22
Honorable_Pawn
Hall Of Famer
 
Honorable_Pawn's Avatar
 
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
Thanks: 4,129
Thanked 3,899x in 2,140 posts
2. Schedules are in a text file. It is a simple job to copy the text files to Excel. If you have elementary skills with "text to columns" and "concatenate" it is real easy to manipulate. Schedules are here:

Name:  Untitled.jpg
Views: 132
Size:  87.0 KB

As long as you stick to the naming convention you can load your altered schedules here:

Name:  Untitled2.jpg
Views: 117
Size:  219.6 KB

Also note that you can export 2 separate xml reports in this same menu. Good for checking that you didn't screw up the schedule.
__________________
PBA Quickstart for OOTP
Background Images Collection

All PBA games broadcast live on Steam.

Last edited by Honorable_Pawn; 01-02-2014 at 08:41 PM.
Honorable_Pawn is offline   Reply With Quote
Old 01-02-2014, 08:31 PM   #23
Honorable_Pawn
Hall Of Famer
 
Honorable_Pawn's Avatar
 
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
Thanks: 4,129
Thanked 3,899x in 2,140 posts
3. Game results.


First go here:
Name:  1.jpg
Views: 111
Size:  276.3 KB


This will happen:
Name:  2.jpg
Views: 114
Size:  266.0 KB



Then go here and open this file:
Name:  3.jpg
Views: 99
Size:  138.7 KB


Here is your data:
Name:  4.jpg
Views: 110
Size:  281.4 KB
__________________
PBA Quickstart for OOTP
Background Images Collection

All PBA games broadcast live on Steam.
Honorable_Pawn is offline   Reply With Quote
Old 01-02-2014, 08:37 PM   #24
Honorable_Pawn
Hall Of Famer
 
Honorable_Pawn's Avatar
 
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
Thanks: 4,129
Thanked 3,899x in 2,140 posts
1. I dont see a good way to export standings but if you are handy with excel you could probably come up with a way to rebuild the standings directly from the data in the game results spreadsheet.

It would take a little bit of work but it is totally doable. If you are comfortable with recording macros you would only have to do it once. Then you just run the macro every time going forward.


I'm not sure if you know but you can see past current year standings here:

Name:  5.jpg
Views: 98
Size:  169.3 KB
__________________
PBA Quickstart for OOTP
Background Images Collection

All PBA games broadcast live on Steam.

Last edited by Honorable_Pawn; 01-02-2014 at 08:44 PM.
Honorable_Pawn is offline   Reply With Quote
Old 01-02-2014, 08:40 PM   #25
Honorable_Pawn
Hall Of Famer
 
Honorable_Pawn's Avatar
 
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
Thanks: 4,129
Thanked 3,899x in 2,140 posts
I don't know how good you are with excel but I can show you a VLook-up formula and how to use it so that you can replace Team ID Numbers with actual team names and how to replace Player ID Numbers with actual player names.
__________________
PBA Quickstart for OOTP
Background Images Collection

All PBA games broadcast live on Steam.
Honorable_Pawn is offline   Reply With Quote
Old 01-02-2014, 09:42 PM   #26
Ramicus
Minors (Rookie Ball)
 
Join Date: Dec 2013
Posts: 38
Thanks: 34
Thanked 4x in 4 posts
Wow, that's so helpful. I have a baseball world in handy little files now.

This VLook-Up thing would be very helpful.
Ramicus is offline   Reply With Quote
Old 01-02-2014, 10:26 PM   #27
Honorable_Pawn
Hall Of Famer
 
Honorable_Pawn's Avatar
 
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
Thanks: 4,129
Thanked 3,899x in 2,140 posts
Ok, I'll show you how it works tomorrow evening. It's pretty easy once you use it a few times.
__________________
PBA Quickstart for OOTP
Background Images Collection

All PBA games broadcast live on Steam.
Honorable_Pawn is offline   Reply With Quote
Old 01-02-2014, 10:52 PM   #28
NYY #23
Hall Of Famer
 
NYY #23's Avatar
 
Join Date: Jan 2009
Location: Philadelphia
Posts: 12,930
Blog Entries: 17
Thanks: 4,110
Thanked 3,407x in 2,480 posts
For standings you can look at the Team_Record.csv. There are a couple of other pieces of information you will need, although depending on whether you change the structure you probably would need to only get those once from the team_relations.csv (based on the team_id), and the team name/nickname from the teams.csv (based on the team_id). I've found it best to concatenate the league_id, sub_league_id, and division_id (all from team_relations) with the pos (from team_record). That would give you a column to sort by that would produce the correct order per division.

Just as a sample I was producing these standings using that method:
http://www.ootpdevelopments.com/boar...ml#post3615722

I did switch to access and excel to automate it better, but I can help answer any questions too. And I've also got a sample spreadsheet that I can show you with some sample formulas as well if you are interested.

Last edited by NYY #23; 01-02-2014 at 10:59 PM.
NYY #23 is offline   Reply With Quote
Old 01-07-2014, 05:26 PM   #29
Honorable_Pawn
Hall Of Famer
 
Honorable_Pawn's Avatar
 
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
Thanks: 4,129
Thanked 3,899x in 2,140 posts
So are you good with all this?

Anything else you can think of?
__________________
PBA Quickstart for OOTP
Background Images Collection

All PBA games broadcast live on Steam.
Honorable_Pawn 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 11:32 PM.

 

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