Home | Webstore
Latest News: - OOTP 15: Update #6 Released! - OOTP 15 Released! - FHM 2014: Version 1.6.19 Available! - iOOTP Baseball 2014 for iOS Available NOW! - Beyond the Sideline Football Announced! - Title Bout Championship Boxing 2.5 released!

OOTP 15 World Series Special: 50% Off!

  

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

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

Reply
 
LinkBack Thread Tools
Old 03-24-2013, 01:35 PM   #1 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
Spritze's db for OOTP14

There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
13 thanks for this post:
Bigrod (03-25-2013), golander40 (04-06-2013), Jabez54 (03-24-2013), mgom27 (04-20-2013), moonlightmerc (03-24-2013), NYY #23 (04-06-2013), OBSL Commish (07-31-2013), RonP (04-11-2013), szathkey (04-12-2013), tayloraj (03-24-2013), TBPauly (04-01-2013), The Game (03-24-2013)
Old 03-24-2013, 02:53 PM   #2 (permalink)
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 8,101
Thanks: 4,961
Thanked 1,493x in 1,221 posts
Quote:
Originally Posted by Spritze View Post
There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.
This includes all previous custom DB's? Not working with 14 I mean.
The Game is offline   Reply With Quote
Old 03-24-2013, 03:16 PM   #3 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
Yup, more than likely which could be viewed as likely+.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 03-24-2013 at 03:18 PM.
Spritze is offline   Reply With Quote
3 thanks for this post:
Jabez54 (03-24-2013), mgom27 (04-20-2013), The Game (03-24-2013)
Old 03-27-2013, 07:30 PM   #4 (permalink)
Major Leagues
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 498
Thanks: 12
Thanked 6x in 6 posts
Quote:
Originally Posted by Spritze View Post
There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.
So, does that mean, that, doing a import dance, from a previous version wont cut the mustard either?
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel
plannine is offline   Reply With Quote
Old 03-28-2013, 03:42 PM   #5 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
That'd move your current stuff but the next year would bomb without an updated db AFAIK. You'd need to try it to know for sure.

All I know for fact is that the format of the master.csv has changed. Which normally means old db's go dead.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-06-2013, 09:48 AM   #6 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
OOTP14 Database posted in the usual place

I tested a few seasons without any trials nor tribulations. This DB has the new OOTP14 format.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
2 thanks for this post:
golander40 (04-06-2013), Jabez54 (04-06-2013)
Old 04-09-2013, 04:56 PM   #7 (permalink)
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,258
Thanks: 107
Thanked 180x in 167 posts
I am just confirming that the database includes minor league players, Negro League and Japanese (Spritze High School Player database)??

Also, when is the best time to import my saved league to OOTP14? Right now in my dynasty it is February 1st in the off-season.
__________________
It helps if the hitter thinks you're a little crazy ~ Nolan Ryan

MLB Modified

Pro Boxing Modified


Jeff1787 is offline   Reply With Quote
Old 04-09-2013, 05:24 PM   #8 (permalink)
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 8,101
Thanks: 4,961
Thanked 1,493x in 1,221 posts
Quote:
Originally Posted by Jeff1787 View Post
I am just confirming that the database includes minor league players, Negro League and Japanese (Spritze High School Player database)??

Also, when is the best time to import my saved league to OOTP14? Right now in my dynasty it is February 1st in the off-season.
I am sure Spritz will confirm but yes I believe it also has PCL players. OOTP recommends converting right after the regular season or before your new season. I have converted at all points and never had an issue.
The Game is offline   Reply With Quote
2 thanks for this post:
Jeff1787 (04-09-2013)
Old 04-09-2013, 06:01 PM   #9 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
Markus undooded the OOTP14 database changes so now the old databases will still work. Yay!
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
4 thanks for this post:
Gambo (04-11-2013), mgom27 (04-20-2013), OBSL Commish (07-31-2013), The Game (04-09-2013)
Old 04-11-2013, 01:15 AM   #10 (permalink)
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,025
Thanks: 73
Thanked 688x in 365 posts
So Spritze. Do you have an updated HS database for 2014?

Is the one on the site the incorrect/update for OOTP14 that never was?

Basically can we get your DB with the 2012 season and will it work on OOTP14?
__________________
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

Owner - Seattle Mariners - CDL
http://www.cooperstowndiamondlegends.com
100 seasons and going strong!
Gambo is offline   Reply With Quote
Old 04-11-2013, 01:48 PM   #11 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
Yes.
Yes, it is the "incorrect" one.
Yes it works anyway in my single test.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-11-2013, 04:13 PM   #12 (permalink)
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,025
Thanks: 73
Thanked 688x in 365 posts
Okedoke. I'm pretty sure that all those last columns in the master.csv are holdovers from days long gone by anyway so it should work without them. If their needing and update shouldn't be too difficult.

Over the weekend I'm going to get a quasi update to my database based off this one if anybodies interested.

I don't have the time anymore to update it to perfection. I'm figuring everybody will import with the right team and professional debut except for the 2011 and 2012 rookies, who will debut the same time as in SpritzeHSDB (18 years old) and with the team they made their MLB debut. Also, for 2011 and 2012 the team they import on will be the 1st team they made an appearance with.

Since my DB is for historical players mainly this shouldn't be too big a deal for most. (At least for me ). I will keep the setup where neutralized statistics will need to be used so complete accurate histories and stats will be imported. I'll still keep it only containing a limited number of Asian players.

Pretty much everything else will be the same as the original SpritzeDB.
__________________
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

Owner - Seattle Mariners - CDL
http://www.cooperstowndiamondlegends.com
100 seasons and going strong!
Gambo is offline   Reply With Quote
3 thanks for this post:
Jabez54 (04-11-2013), tayloraj (04-12-2013), The Game (04-11-2013)
Old 04-12-2013, 07:54 AM   #13 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
Quote:
Originally Posted by Gambo View Post
Okedoke. I'm pretty sure that all those last columns in the master.csv are holdovers from days long gone by anyway so it should work without them. If their needing and update shouldn't be too difficult.
The extra columns are required for Random Debut play.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-12-2013, 10:55 AM   #14 (permalink)
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,025
Thanks: 73
Thanked 688x in 365 posts
So as long as you dont do random debut it should be fine? I'm assuming so.
__________________
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

Owner - Seattle Mariners - CDL
http://www.cooperstowndiamondlegends.com
100 seasons and going strong!
Gambo is offline   Reply With Quote
Old 04-12-2013, 02:25 PM   #15 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,415
Thanks: 33
Thanked 660x in 446 posts
Quote:
Originally Posted by Gambo View Post
So as long as you dont do random debut it should be fine? I'm assuming so.
I assume you can assume away assumptionally!
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-17-2013, 09:20 PM   #16 (permalink)
Major Leagues
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 498
Thanks: 12
Thanked 6x in 6 posts
Quote:
Originally Posted by Spritze View Post
There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.

Just wonderin.....'

Is it ready for Freddie yet?
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel
plannine is offline   Reply With Quote
Old 04-18-2013, 11:07 PM   #17 (permalink)
All Star Reserve
 
Join Date: Jun 2006
Posts: 691
Thanks: 324
Thanked 177x in 110 posts
Quote:
Originally Posted by Spritze View Post
Markus undooded the OOTP14 database changes so now the old databases will still work. Yay!
Will a modded one that currently works for 12, and (according to other posts) will not work for 13, now work for 14?
thehef is offline   Reply With Quote
Old 04-19-2013, 01:16 AM   #18 (permalink)
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,025
Thanks: 73
Thanked 688x in 365 posts
Quote:
Originally Posted by thehef View Post
Will a modded one that currently works for 12, and (according to other posts) will not work for 13, now work for 14?
I would say no.

BTW, I do have a version of my DB available for OOTP14 here...

https://www.box.com/s/d0yhb4dqoisv6doop012

I'll admit it's only been tested to a limited extent...
__________________
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

Owner - Seattle Mariners - CDL
http://www.cooperstowndiamondlegends.com
100 seasons and going strong!
Gambo is offline   Reply With Quote
Thank you for this post:
The Game (07-20-2013)
Old 04-19-2013, 11:47 AM   #19 (permalink)
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 8,101
Thanks: 4,961
Thanked 1,493x in 1,221 posts
Quote:
Originally Posted by Gambo View Post
I would say no.

BTW, I do have a version of my DB available for OOTP14 here...

https://www.box.com/s/d0yhb4dqoisv6doop012

I'll admit it's only been tested to a limited extent...
what the difference between yours and Spritz, I have an idea, just would like clarification.
The Game is offline   Reply With Quote
2 thanks for this post:
mgom27 (04-20-2013), RANGER11JP (04-19-2013)
Old 04-19-2013, 01:34 PM   #20 (permalink)
Minors (Double A)
 
tayloraj's Avatar
 
Join Date: Mar 2012
Location: Roslindale, MA
Posts: 122
Thanks: 59
Thanked 53x in 30 posts
Quote:
Originally Posted by Gambo View Post
I would say no.

BTW, I do have a version of my DB available for OOTP14 here...

https://www.box.com/s/d0yhb4dqoisv6doop012

I'll admit it's only been tested to a limited extent...
When I go to download, it's telling me that you're out of bandwidth.
tayloraj is offline   Reply With Quote
Thank you for this post:
Jabez54 (04-19-2013)
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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 04:30 AM.


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