|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
08-04-2017, 12:57 AM | #1 |
Hall Of Famer
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. |
08-04-2017, 08:40 PM | #2 |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
|
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" |
08-05-2017, 07:15 AM | #3 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
This boat has sailed.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
04-11-2018, 04:30 PM | #4 |
Global Moderator
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 |
04-11-2018, 04:38 PM | #5 | |
Hall Of Famer
Join Date: Sep 2002
Location: California's Canada Warnings: 17
Posts: 2,475
|
Quote:
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. |
|
04-11-2018, 04:44 PM | #6 | |
Global Moderator
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
|
Quote:
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 |
|
04-15-2018, 11:30 AM | #7 |
Hall Of Famer
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 7,487
|
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. |
05-21-2020, 12:18 PM | #8 |
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? |
08-06-2020, 03:29 PM | #9 |
Minors (Rookie Ball)
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. |
08-09-2020, 10:09 AM | #10 | |
Hall Of Famer
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
|
Quote:
__________________
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" |
|
04-08-2021, 01:47 PM | #11 | |
Bat Boy
Join Date: May 2020
Posts: 18
|
Quote:
__________________
|
|
04-17-2021, 07:03 PM | #12 |
All Star Reserve
Join Date: Apr 2002
Posts: 954
|
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' |
04-26-2021, 11:11 PM | #13 |
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. |
Bookmarks |
|
|