Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

OOTP Baseball 20 - Pre-Order Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 19 > OOTP Mods

OOTP Mods Logos, roster packs, historical databases, OOTP tools, FaceGen files... it's all here!

Reply
 
Thread Tools
Old 09-01-2018, 12:10 PM   #1
tylertoo
Major Leagues
 
tylertoo's Avatar
 
Join Date: Sep 2009
Posts: 308
Blog Entries: 6
Thanks: 292
Thanked 105x in 65 posts
Excel help needed -- dates before 1900

I'm attempting to roll back the birth years of my fictional league from the 23rd second back to the 19th century.

The simple way should be to export the player data to excel (which I've done) and use a formula to subtract 400 years from the birth year). This works perfectly if the resulting birth year is after 1/1/1900. Excel does not recognize dates before 1/1/1900.

Anyone know how to work around this? I see that OOTP's historical league exports 19th century birth years as a text string, not an actual date (e.g. 1849-1-29 [text] and not 1/29/1849 [data]).

Would it import dates properly if I left them as a text string? If so, the answer would be:
  • Convert original 23rd century date to text string.
  • Pull out year as a value. Subtract 400 from the valute.
  • Convert result to a text string, and place it into the full text string with mm/dd/yyyy for import back into OOTP.

Would this work? Would any of you Excel experts know how to accomplish this? Thanks.
__________________
Check out my OOTP-inspired novel "Lord Bart and the Leagues of SIP and ALE"!
tylertoo is offline   Reply With Quote
Old 09-01-2018, 03:46 PM   #2
tylertoo
Major Leagues
 
tylertoo's Avatar
 
Join Date: Sep 2009
Posts: 308
Blog Entries: 6
Thanks: 292
Thanked 105x in 65 posts
It took a few hours, but I was able to successfully update players.csv to include the pre-1900 dates.

Problem is... I have no idea how to re-import the revised players.csv file into the game. I searched and searched and don't see how. I'm sure its obvious, but does anyone know?
__________________
Check out my OOTP-inspired novel "Lord Bart and the Leagues of SIP and ALE"!
tylertoo 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 05:27 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