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 08-04-2017, 01:57 AM   #1
bulldog55
Hall Of Famer
 
bulldog55's Avatar
 
Join Date: Sep 2002
Location: California's Canada Warnings: 17
Posts: 2,475
Create custom database?

Is this even possible anymore? It seems like the ODB files are proprietary. Is there any way to edit/create them? Does it still work with CSV files, and if so, what is the format? Any help would be greatly appreciated.
__________________
Commissioner, Trans-Continental Base Ball Association
Owner/GM, Los Angeles Electrics (TCBA), Beaverton Rangers (OTBL), Portland Mavericks (Union League), and Los Angeles Superbas (Century League)

Being smart, don't always make you popular.
bulldog55 is offline   Reply With Quote
Old 08-04-2017, 09:40 PM   #2
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,766
Spritze can guide you better then most. i tried this years ago so i can have accurate stats for my players in my EBL league but i gave up after a few tests and had issues with getting it right.
__________________
Go today don't wait for tomorrow
It isn't promised, all the time you get borrowed
Don't live your life for other people
Don't bottle your emotions till they crack and fill a couple just sorrows
Take your mind and refocus go get a paper write your goals out
Throw your middle fingers to all your haters


"Stay Strong"


The Game is offline   Reply With Quote
Old 08-05-2017, 08:15 AM   #3
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by bulldog55 View Post
Is this even possible anymore? It seems like the ODB files are proprietary. Is there any way to edit/create them? Does it still work with CSV files, and if so, what is the format? Any help would be greatly appreciated.
This boat has sailed.
__________________
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-2018, 05:30 PM   #4
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Aw, that stinks!

I just came back to playing OOTP for the first time in a couple of years. I used to set up league "histories" for fictional leagues ahead of time because it was easier (and less error-prone) than making lots of changes manually as the years went by. I was hoping to do that again and tried to get it to work, but I couldn't.

This is one of the things I feared would happen when the game got official sanctioning from MLB.
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 04-11-2018, 05:38 PM   #5
bulldog55
Hall Of Famer
 
bulldog55's Avatar
 
Join Date: Sep 2002
Location: California's Canada Warnings: 17
Posts: 2,475
Quote:
Originally Posted by ctorg View Post
Aw, that stinks!

I just came back to playing OOTP for the first time in a couple of years. I used to set up league "histories" for fictional leagues ahead of time because it was easier (and less error-prone) than making lots of changes manually as the years went by. I was hoping to do that again and tried to get it to work, but I couldn't.

This is one of the things I feared would happen when the game got official sanctioning from MLB.
Well howdy, hotdog man. Long time no see.

I don't know if it really has anything to do with the MLB sanction. I think they just switched to some sort of proprietary database format. It would be great if they could provide some sort of tool for translating an Access db or something to that odb format. How did they create their database in the first place? ODB is an Open Office format but it doesn't open in that.

Sent from my VS986 using Tapatalk
__________________
Commissioner, Trans-Continental Base Ball Association
Owner/GM, Los Angeles Electrics (TCBA), Beaverton Rangers (OTBL), Portland Mavericks (Union League), and Los Angeles Superbas (Century League)

Being smart, don't always make you popular.
bulldog55 is offline   Reply With Quote
Old 04-11-2018, 05:44 PM   #6
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Quote:
Originally Posted by bulldog55 View Post
Well howdy, hotdog man. Long time no see.

I don't know if it really has anything to do with the MLB sanction. I think they just switched to some sort of proprietary database format. It would be great if they could provide some sort of tool for translating an Access db or something to that odb format. How did they create their database in the first place? ODB is an Open Office format but it doesn't open in that.

Sent from my VS986 using Tapatalk
Howdy! Yeah, it's been a loooong time since I last posted here. I hadn't played OOTP since a few years ago but got the urge when 19 was released for some reason, and I'm feeling the old juices flowing.

When they first switched to the odb files, you could still use csv files. If you had a directory with no odb files, it would just read from csv. I tried that - I copied over an old historical DB I used in a previous version. No dice.

Another good thing I liked to used that ability to do was to fix 19th century info so that it looked more like reality than what is in the database now (which makes no attempt to capture real teams/leagues). I guess that ability is all gone now.
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 04-15-2018, 12:30 PM   #7
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 7,478
FWIW the ODB files appear to be SQLite databases. That's a guess because I can open them (to a point) using a "DB Browser for SQLite". Unfortunately, they are encrypted since the first the program does when I try to open it is give me a window about SQLCipher encryption, asking for a passphrase.

So...yeah. ODBs are a black box unless you're an 3L33T haXXor.
__________________
eriqjaffe is offline   Reply With Quote
Old 05-21-2020, 01:18 PM   #8
WPBExpo
Bat Boy
 
Join Date: May 2020
Posts: 18
Noob here.

It seems to me that, if the database structure is knowable, then it should still be possible to roll your own custom databases. Or does some mechanism, prevent starting with a database other the game defaults?
WPBExpo is offline   Reply With Quote
Old 08-06-2020, 04:29 PM   #9
DrDoom
Minors (Rookie Ball)
 
DrDoom's Avatar
 
Join Date: Jul 2004
Posts: 44
I've created two command line utilities that will allow you to create custom databases. ODBtoCSV converts the historical_*.odb files into lahman-esque CSV files. CSVtoODB converts those csv files back into odb files.

They're currently beta but I have posted them in the OOTP Mods forum for anyone to start playing around with.
DrDoom is offline   Reply With Quote
Old 08-09-2020, 11:09 AM   #10
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,766
Quote:
Originally Posted by DrDoom View Post
I've created two command line utilities that will allow you to create custom databases. ODBtoCSV converts the historical_*.odb files into lahman-esque CSV files. CSVtoODB converts those csv files back into odb files.

They're currently beta but I have posted them in the OOTP Mods forum for anyone to start playing around with.
I want to create an accurate AAGPBL database, eventually.
__________________
Go today don't wait for tomorrow
It isn't promised, all the time you get borrowed
Don't live your life for other people
Don't bottle your emotions till they crack and fill a couple just sorrows
Take your mind and refocus go get a paper write your goals out
Throw your middle fingers to all your haters


"Stay Strong"


The Game is offline   Reply With Quote
Old 04-08-2021, 02:47 PM   #11
WPBExpo
Bat Boy
 
Join Date: May 2020
Posts: 18
Quote:
Originally Posted by DrDoom View Post
I've created two command line utilities that will allow you to create custom databases. ODBtoCSV converts the historical_*.odb files into lahman-esque CSV files. CSVtoODB converts those csv files back into odb files.

They're currently beta but I have posted them in the OOTP Mods forum for anyone to start playing around with.
I've been playing around with them, and so far they work great! Thank you so much for putting this together!
__________________
WPBExpo is offline   Reply With Quote
Old 04-17-2021, 08:03 PM   #12
blackrussian
All Star Reserve
 
blackrussian's Avatar
 
Join Date: Apr 2002
Posts: 954
Quote:
Originally Posted by WPBExpo View Post
I've been playing around with them, and so far they work great! Thank you so much for putting this together!
what kinds of things have you been able to do? i just managed to convert the files so im just poking around for now.
__________________
v'
blackrussian is offline   Reply With Quote
Old 04-27-2021, 12:11 AM   #13
Supermercado
Minors (Triple A)
 
Join Date: Apr 2002
Location: Left Field
Posts: 251
A pre-game database editor would be helpful. Without going into editing files and using utilities, it's frustrating that if you want to create a custom universe, assign a player his correct nationality etc... all your work gets wiped when you start a new game.

I know editors are less important to the devs than Perfect Team customers but I'm sure somebody would create a third party tool for them if given basic access.
Supermercado 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 02:28 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