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

Collection Missions for Perfect Team Released!

  

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 08-04-2017, 12:57 AM   #1
bulldog55
Hall Of Famer
 
bulldog55's Avatar
 
Join Date: Sep 2002
Location: California's Canada Warnings: 17
Posts: 2,394
Thanks: 82
Thanked 165x in 94 posts
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.
__________________
Being smart, don't always make you popular.

Trans-Continental Base Ball Association (est. 1870)
bulldog55 is offline   Reply With Quote
Old 08-04-2017, 08:40 PM   #2
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,030
Thanks: 9,064
Thanked 3,067x in 2,448 posts
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.
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Old 08-05-2017, 07:15 AM   #3
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,150
Thanks: 308
Thanked 3,216x in 1,890 posts
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, 04:30 PM   #4
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
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, 04:38 PM   #5
bulldog55
Hall Of Famer
 
bulldog55's Avatar
 
Join Date: Sep 2002
Location: California's Canada Warnings: 17
Posts: 2,394
Thanks: 82
Thanked 165x in 94 posts
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
__________________
Being smart, don't always make you popular.

Trans-Continental Base Ball Association (est. 1870)
bulldog55 is offline   Reply With Quote
Old 04-11-2018, 04:44 PM   #6
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
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, 11:30 AM   #7
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,765
Thanks: 329
Thanked 3,218x in 1,029 posts
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.
__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!
eriqjaffe 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 12:24 PM.

 

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