Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 03-26-2007, 05:30 PM   #1
redmarkYankees
All Star Starter
 
redmarkYankees's Avatar
 
Join Date: Nov 2003
Posts: 1,283
GAMBO Database - Auto setup

Save the GAMBO database files in their subfolders (2007Import, 2007Yearly, Lahman) to a new folder (e.g. 'Gambo'). Unzip the attached file into the 'Gambo' folder. Open it up, enable macros, enter the year you want your league to start, click the button. It takes about 20 seconds to complete.

- Copies full set of database files to 'Gambo' folder
- Follows the readme instructions automatically: Merges history from 'Lahman', year of import from 'Import'
- Also merges years after import from 'Yearly', so you don't need to have a separate path in-game for subsequent years

In-game, set the database path to the 'Gambo' database. No need to change it after import. Original files are not altered.
Attached Files
File Type: zip GAMBO setup.zip (14.3 KB, 384 views)
__________________
In times of universal deceit, telling the truth will be a revolutionary act.
George Orwell
redmarkYankees is offline   Reply With Quote
Old 03-26-2007, 07:27 PM   #2
majesty95
All Star Starter
 
majesty95's Avatar
 
Join Date: Apr 2005
Location: San Antonio, TX
Posts: 1,746
Excellent! Nice utility.
majesty95 is offline   Reply With Quote
Old 03-26-2007, 10:01 PM   #3
Rastafreaky
Minors (Double A)
 
Join Date: Jun 2002
Location: Seattle, WA
Posts: 104
Nice!
Rastafreaky is offline   Reply With Quote
Old 03-26-2007, 10:16 PM   #4
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
Redmark... You Are The Man!
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 03-27-2007, 12:03 AM   #5
PadresFan
All Star Starter
 
PadresFan's Avatar
 
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 1,151
Adding to my site tonight.... Great job!
PadresFan is offline   Reply With Quote
Old 03-27-2007, 03:45 PM   #6
stellar
Minors (Double A)
 
Join Date: Jul 2006
Posts: 108
Is it safe to assume that this utility won't work on a Mac?

I want to use Gambo's DB, but am confused on the EXACT steps to take.
stellar is offline   Reply With Quote
Old 03-27-2007, 06:03 PM   #7
redmarkYankees
All Star Starter
 
redmarkYankees's Avatar
 
Join Date: Nov 2003
Posts: 1,283
Quote:
Originally Posted by stellar View Post
Is it safe to assume that this utility won't work on a Mac?

I want to use Gambo's DB, but am confused on the EXACT steps to take.
Correct. Sorry, I should have said in the first post, it's Excel/vba and uses the Windows scripting host object model, so no good for Macs.

If you want to do the same manually: you need to create each of the batting.csv, pitching.csv, fielding.csv and fieldingOF.csv from a combination of (in order):

- the records for years upto the year before your league will start from the Lahman folder files.

- the records for the year the league will start from the Import folder files.

- the records for the years after your league start year from the Yearly folder files.

Do all of this on a new copy, not overwriting the originals from any of the subfolders.

(edit: for fieldingOF.csv, use the Import file for the years before import).
__________________
In times of universal deceit, telling the truth will be a revolutionary act.
George Orwell

Last edited by redmarkYankees; 03-27-2007 at 06:04 PM.
redmarkYankees is offline   Reply With Quote
Old 03-28-2007, 11:53 AM   #8
stellar
Minors (Double A)
 
Join Date: Jul 2006
Posts: 108
Quote:
Originally Posted by redmarkYankees View Post
If you want to do the same manually: you need to create each of the batting.csv, pitching.csv, fielding.csv and fieldingOF.csv from a combination of (in order):

- the records for years upto the year before your league will start from the Lahman folder files.

- the records for the year the league will start from the Import folder files.

- the records for the years after your league start year from the Yearly folder files.

Do all of this on a new copy, not overwriting the originals from any of the subfolders.

(edit: for fieldingOF.csv, use the Import file for the years before import).
These are the steps I have been told before, and I don't understand them. Has anyone written out an actual step by step guide?
stellar is offline   Reply With Quote
Old 04-04-2007, 10:13 PM   #9
bigboss
Minors (Rookie Ball)
 
Join Date: Jun 2006
Posts: 39
gambo file

can't get new gambo file to download...anyone else have a better link?

Big Boss
bigboss is offline   Reply With Quote
Old 04-05-2007, 12:14 AM   #10
Kronos
Major Leagues
 
Kronos's Avatar
 
Join Date: Mar 2002
Location: Northern Ky.
Posts: 318
Awesome, thanks
Kronos 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 01:27 PM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments