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

OOTP Baseball 20 - AVAILABLE NOW!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 05-19-2016, 09:36 PM   #1
majik1989
Minors (Rookie Ball)
 
Join Date: Apr 2016
Posts: 23
Thanks: 0
Thanked 13x in 5 posts
Adding career stats to a database for historical player import

Hello - I am looking to add player career totals for each team the player appeared with into the lahman or Spiritze database to import players into an all time franchise best league based off career totals. (ex,Barry Bonds could be a Pirate based off his 1986-1992 stats and a Giant based on 1993-retirement stats) . The Fangraphs site makes it easy to create files for batting, pitching, and fielding to export to excel then over to a database. I tired this and placed the year at 2050 for all players and I can get players to import but their ratings are all at the min across the board while nothing shows in real life stats. (I also wouldn't mind creating decade teams that used ones stat totals from x0-x9)

I am hoping it is something easy I am missing. Also, I have the spreadsheets from fangraphs and could post if somebody would like to help ($$$)

I would love to create some leagues based off totals from particular timeframes then share as a quickstart but am lacking some excel and database knowledge needed to get ootp to pull over the career stats with the id.

Any suggestions would be great.

Thanks
majik1989 is offline   Reply With Quote
Old 05-20-2016, 09:53 AM   #2
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,120
Thanks: 295
Thanked 3,205x in 1,879 posts
I'd post a sample of your 4 spreadsheets to give people something to work from. There is not enough info in your post for successful helpings.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-20-2016, 10:18 PM   #3
majik1989
Minors (Rookie Ball)
 
Join Date: Apr 2016
Posts: 23
Thanks: 0
Thanked 13x in 5 posts
Good idea - I attached a quick sample of a partial batting spreadsheet that may give an idea of what I am looking to accomplish. For player id, I would need to use the BigRod Historical Tool but for year/team/league was not sure what would go here to get the program to pull the career stats. I know the actual team name would not work but that is how fan graph identifies.

I mainly don't want to do excessive work if there is an easy way to accomplish this and admit that I am not an excel or database expert by any means.

Also, thanks so much for the reply.

(In the meantime I am working on a league using single season bests for each franchise to fill mlb/aaa/aa/a/r rosters.)
Attached Files
File Type: xls career batting sample.xls (191.0 KB, 160 views)

Last edited by majik1989; 05-20-2016 at 10:19 PM.
majik1989 is offline   Reply With Quote
Old 05-20-2016, 11:21 PM   #4
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,120
Thanks: 295
Thanked 3,205x in 1,879 posts
For starters the format of this file needs to be an exact match to the Lahman 2014 version of the batting.csv or it will not import. Same with the Pitching/Fielding/Master files.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-21-2016, 08:42 AM   #5
majik1989
Minors (Rookie Ball)
 
Join Date: Apr 2016
Posts: 23
Thanks: 0
Thanked 13x in 5 posts
Thanks - I'll keep playing around with it and can see if I can get things to sync. I need to become more familiar with the Lahman format first. I am sure there is a way to do what I am wanting but I will work my way to it as I learn how everything connects.
majik1989 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 07:02 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