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

  

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 06-03-2011, 09:20 AM   #1
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
C▓ PCL Database

ctorg and myself are in the midst of compiling the data to create a Pacific Coast League 'lahman style' db for use with OOTP.

You can follow the progress here as we move through the 1903-1957 seasons of the PCL.
Cooleyvol is online now   Reply With Quote
5 thanks for this post:
AESP_pres (06-03-2011), jmm8356 (06-04-2011), mjj55409 (06-03-2011), No Pepper (06-03-2011), Rastafreaky (07-01-2011)
Old 06-04-2011, 08:46 AM   #2
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
UPDATE:

We have completed 1903-1919 and hope to have a test db for testing available soon.

We would like 2-3 people who would volunteer to test this initial database for us. If you're interested contact myself or ctorg. You could also post here.
Cooleyvol is online now   Reply With Quote
Old 06-04-2011, 08:51 AM   #3
spleen1015
Hall Of Famer
 
spleen1015's Avatar
 
Join Date: Jan 2002
Location: Indianapolis, Indiana
Posts: 5,776
Thanks: 610
Thanked 723x in 344 posts
I'll help you test it.
__________________
spleen1015 is offline   Reply With Quote
Old 06-10-2011, 01:55 PM   #4
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
UPDATE:

1903-1919 are complete and are being coverted to lahman db format for testing.


Data gathering has commenced on 1920-1929 and 1930-1939.

As far as 1920-1929 goes.........1920, 21, 22, 23, 24, and 25 are completed.

ctorg has 1930-39.
Cooleyvol is online now   Reply With Quote
Old 06-10-2011, 02:49 PM   #5
tarmer
Major Leagues
 
tarmer's Avatar
 
Join Date: May 2005
Location: Out in Leftfield
Posts: 479
Blog Entries: 1
Thanks: 108
Thanked 122x in 72 posts
Quote:
Originally Posted by Cooleyvol View Post
UPDATE:

We have completed 1903-1919 and hope to have a test db for testing available soon.

We would like 2-3 people who would volunteer to test this initial database for us. If you're interested contact myself or ctorg. You could also post here.
Mark - I can give it a shot if you like
tarmer is offline   Reply With Quote
Old 06-12-2011, 02:40 PM   #6
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
UPDATE:

1903-1909 -- Complete
1910-1919 -- Complete
1920-1929 -- Complete
1930-1939 -- Complete
1940-1949 -- Complete
1950-1957 -- Complete


It is hoped that all data will be mined this week, so we are hoping to have a test db very soon for those willing to help.

Thanks to Spleen/tarmer for volunteering to help us on that part of the project.

Last edited by Cooleyvol; 06-17-2011 at 03:01 PM.
Cooleyvol is online now   Reply With Quote
Old 06-15-2011, 03:13 PM   #7
Dr. P.R. Park III
All Star Reserve
 
Dr. P.R. Park III's Avatar
 
Join Date: Jul 2006
Posts: 972
Thanks: 328
Thanked 322x in 141 posts
Would it be possible to help test as well?
Dr. P.R. Park III is offline   Reply With Quote
Old 06-15-2011, 03:36 PM   #8
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
Quote:
Originally Posted by Dr. P.R. Park III View Post
Would it be possible to help test as well?
Sure. That'll give us three testers plus ctorg and myself. We'll be in touch once I finish the 40s. I'm hoping by Thursday, all data mining will be finished. Its mined in a format very close to what we need it in in order to convert it to a lahman style db, so I don't anticipate much time after that.
Cooleyvol is online now   Reply With Quote
Old 06-17-2011, 03:04 PM   #9
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
All data is gathered. We hope to have something for testing very soon, so if Spleen, Tony (have it already), and the Doc would PM their email addresses to me, I'll be in touch with a download link very soon.

Instructions on what we're looking for will also be included.


Thanks to you three for helping us work the kinks out (if there are any). This has been a very smooth process thusfar and I want to thank ctorg for helping out on the data side of this. I think we're going to provide something that many will find interesting to use in whatever way they choose to use it.
Cooleyvol is online now   Reply With Quote
Thank you for this post:
jmm8356 (06-18-2011)
Old 06-21-2011, 12:13 PM   #10
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
Latest update is that the data is now in Access db form and has been sent to be 'Spritzinated'.
Cooleyvol is online now   Reply With Quote
Old 06-21-2011, 01:34 PM   #11
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,186
Thanks: 314
Thanked 3,230x in 1,899 posts
I has questions that I have posed in a very long, boring and nearly pointless e-mail I sent you earlier today.

To all interested parties......the Lahman portion of the PCL database should take only a little time to complete BUT to add all the extra stuff OOTP12 requires to recreate history will take a small modicum of time. I did the easy one this morning so the PCL batting.csv is essentially done. The rest will take more time as they have a much larger number of funktions that need to funktion funktionally. Plus we've got to lay down the boogie.
Spritze is offline   Reply With Quote
Thank you for this post:
Kobeck (07-01-2011)
Old 06-21-2011, 01:50 PM   #12
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
Quote:
Originally Posted by Spritze View Post
I has questions that I have posed in a very long, boring and nearly pointless e-mail I sent you earlier today.

To all interested parties......the Lahman portion of the PCL database should take only a little time to complete BUT to add all the extra stuff OOTP12 requires to recreate history will take a small modicum of time. I did the easy one this morning so the PCL batting.csv is essentially done. The rest will take more time as they have a much larger number of funktions that need to funktion funktionally. Plus we've got to lay down the boogie.
I do believe that I answered in that boring email you speak of. I tried to do it equally as boring.
Cooleyvol is online now   Reply With Quote
Old 06-21-2011, 04:23 PM   #13
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,186
Thanks: 314
Thanked 3,230x in 1,899 posts
The question then becomes "Did you lay down that boogie til you die?"
Spritze is offline   Reply With Quote
Old 06-21-2011, 04:36 PM   #14
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
Quote:
Originally Posted by Spritze View Post
The question then becomes "Did you lay down that boogie til you die?"
Still being alive, I am in the process.

"Driven to Tears" by the Police presently.
Cooleyvol is online now   Reply With Quote
Old 06-21-2011, 06:54 PM   #15
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,186
Thanks: 314
Thanked 3,230x in 1,899 posts
Quote:
Originally Posted by Cooleyvol View Post
I do believe that I answered in that boring email you speak of. I tried to do it equally as boring.
One from this morning with 6 attachments?
Spritze is offline   Reply With Quote
Old 06-21-2011, 08:43 PM   #16
Charlie Hough
Hall Of Famer
 
Charlie Hough's Avatar
 
Join Date: May 2006
Posts: 2,986
Thanks: 109
Thanked 1,118x in 585 posts
Wow, this will be a phenomenal addition to OOTP! Is this database going to be real stats, neutralized, or will there be options for either one?
Charlie Hough is offline   Reply With Quote
Old 06-21-2011, 09:37 PM   #17
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,186
Thanks: 314
Thanked 3,230x in 1,899 posts
Real. Because the point is to have the PCL be on par with the Majors. Neutered to ML equivalents is possible though if more than nobody wanted/needed that.

Now who is going to do the International League?
Spritze is offline   Reply With Quote
Old 06-21-2011, 10:47 PM   #18
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
Quote:
Originally Posted by Spritze View Post
One from this morning with 6 attachments?
I didnt receive an email with attachments.
Cooleyvol is online now   Reply With Quote
Old 06-24-2011, 08:02 PM   #19
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,186
Thanks: 314
Thanked 3,230x in 1,899 posts
If anyone is following the hillbilly construction of this......

The Lahman style Master and Batting and Pitching CSV files are complete.

Still to do..... Fielding (which I don't completely have yet)

AND The various OOTP additions to the Lahman files.
Spritze is offline   Reply With Quote
Old 06-24-2011, 08:21 PM   #20
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,319
Thanks: 67
Thanked 651x in 381 posts
Quote:
Originally Posted by Spritze View Post
If anyone is following the hillbilly construction of this......

The Lahman style Master and Batting and Pitching CSV files are complete.

Still to do..... Fielding (which I don't completely have yet)

AND The various OOTP additions to the Lahman files.
I'm workin' on it, Chief.

Slavedriver
Cooleyvol is online now   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:17 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