Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

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

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

Reply
 
LinkBack Thread Tools Display Modes
Old 06-19-2006, 02:40 AM   #1 (permalink)
All Star Starter
 
Eric's Avatar
 
Join Date: May 2002
Location: Folsom, CA
Posts: 1,121
Thanks: 2
Thanked 8x in 5 posts
Looking for a Database tool

I'm interested in playing with a database tool to generate some OOTP reports. I've dabbled with Access at work but don't have it at work. What do people use at home and how much does it usually cost?

I'm thinking of creating a report that will give you the standings of a specific date during the season. Retrosheet has that for major league baseball. For example, the standings at the end of Aug. 18, 2005 can be found at the bottom of this page: http://www.retrosheet.org/boxesetc/08182005.htm

I'm also thinking of creating a chart that would graph the team's position in the standings during the year.
Eric is offline   Reply With Quote
Old 06-19-2006, 02:51 AM   #2 (permalink)
Administrator
 
Steve Kuffrey's Avatar
 
Join Date: Jul 1999
Location: S.E. TN - Georgia born and raised
Posts: 16,924
Thanks: 11
Thanked 4x in 3 posts
Well the Open Office suite is free and will do all and more of what MS Office will do. You can get it http://www.openoffice.org/
__________________
Steve Kuffrey
DABS Atlanta Braves - 2008 Eastern Division Champ
*DBLC Atlanta Braves - 2011, 2014 East Division Champ, 2012, 2013 NL Wildcard
Baseball Maelstrom-Montreal Expos-2013 Tourney winner, 2014 WC Team
Sparky's League - Tampa Bay D'Rays

*No longer an active league.
Steve Kuffrey is offline   Reply With Quote
Old 06-20-2006, 02:20 AM   #3 (permalink)
All Star Starter
 
Eric's Avatar
 
Join Date: May 2002
Location: Folsom, CA
Posts: 1,121
Thanks: 2
Thanked 8x in 5 posts
Thanks. That worked.

Now I know why it's not possible to view the standings of a pariticular day in a previous year - the data just doesn't exist! Aha!
Eric is offline   Reply With Quote
Old 06-20-2006, 04:05 AM   #4 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Quote:
Originally Posted by Eric
Thanks. That worked.

Now I know why it's not possible to view the standings of a pariticular day in a previous year - the data just doesn't exist! Aha!
Does not make it impossible though. You can examine the game results file and tabulate the standings using that.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 06-20-2006, 12:36 PM   #5 (permalink)
All Star Starter
 
Eric's Avatar
 
Join Date: May 2002
Location: Folsom, CA
Posts: 1,121
Thanks: 2
Thanked 8x in 5 posts
Quote:
Originally Posted by Comedian2004
Does not make it impossible though. You can examine the game results file and tabulate the standings using that.
I checked the game results file and it's only for the present year. It doesn't have it for previous years. I supposed that at the end of the season, I can append the game results file to a different table.
Eric is offline   Reply With Quote
Old 06-20-2006, 05:19 PM   #6 (permalink)
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,923
Thanks: 0
Thanked 6x in 4 posts
Quote:
Originally Posted by Eric
I checked the game results file and it's only for the present year. It doesn't have it for previous years. I supposed that at the end of the season, I can append the game results file to a different table.
I know you can manually... but that's a lot of work. I'm sure someone knows how to automate it... someone, somewhere...
tysok is offline   Reply With Quote
Old 06-20-2006, 05:40 PM   #7 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Quote:
Originally Posted by tysok
I know you can manually... but that's a lot of work. I'm sure someone knows how to automate it... someone, somewhere...
This sounds like a job for ANDERSON UTILITIES!
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 06-20-2006, 11:54 PM   #8 (permalink)
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,494
Thanks: 41
Thanked 45x in 24 posts
Quote:
Originally Posted by Comedian2004
This sounds like a job for ANDERSON UTILITIES!
*Enter Superman Music Here*
fantom1979 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 07:49 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments