Reading odb files

ctorg · 06-21-2011, 05:33 PM

So I'd been assuming you could read these with OpenOffice - the odb files in the stats directory. I'd never had a reason to give that a try in OOTP11, but I wanted to open the transaction file for OOTP12. However, OpenOffice wants to open it as an ASCII file.

Does anyone know what program can be used to open these files?

Tony M · 06-22-2011, 04:46 AM

No, the odb files for those features is not an Open Office format - it's a sort of tab delimited file but I can't get it to open with returns/linefeeds

Gambo · 06-22-2011, 09:29 AM

It's a custom format designed by OOTP developments, you won't be able to open it in any program.

What file are you trying to look at?

The historical_database.odb core files are all in the stats directory.

ctorg · 06-22-2011, 11:01 AM

It's not the historical database file. It's the transactions and lineups files. I was just wondering if there were ways of editing them.

My basic reason, though I can think of a million others, is that they don't work for 19th century. I'm guessing that the transactions in the files (I'm not even sure if there are lineups that old in the lineup file) give real-world transactions, whereas the database had to be heavily modified for OOTP to be able to do automatic team movements for 19th century play. I was thinking I might go on in and edit them so that it at least doesn't make it completely unplayable with historical transactions/lineups on (which is the case now).

Carplos · 06-22-2011, 11:05 AM

Looks like Markus turned off the option for pre-1901 leagues in today's update anyway.

ctorg · 06-22-2011, 11:19 AM

Quote:

Originally Posted by Carplos

Looks like Markus turned off the option for pre-1901 leagues in today's update anyway.

I guess that's one way of fixing the problem!

ctorg · 06-22-2011, 11:33 AM

I do still wish we could actually look at these files. I tend to like to make tweaks to history, and it would be cool to be able to do it by tweaking the file.

Gambo · 06-22-2011, 12:01 PM

For the transaction database to work with pre-1901 it would totally have to be reworked from nearly scratch. So many players switched teams and team changed that it is chaotic. I took a look at it when working on the transactions database but time constraints and general confusion made it impractical.

It's something that maybe I will look at at a later date.

The lineups aren't there anyway.

ctorg · 06-22-2011, 01:35 PM

Oh yes, I'd imagine it's a bit of a monster. I remember looking at it when the idea of having this in the game first came up in a thread some months back. I wasn't going to try to replicate history, just make it so that the teams each have enough players to move forward.

I guess that's moot anyway, since Markus disabled it.

But I also wish I could make little edits here and there - add in some fictional players, set up what-ifs like the Red Sox not trading Ruth, etc.

Since when you turn on the historical transactions, it seems to override everything else (as it should), the only way to fiddle with things would be to make changes to that file, but it seems that can't be done. It seems odd to me that this was specifically made to be uneditable, when OOTP has always seemed to go for maximum customizability.

06-21-2011, 05:33 PM	#1
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Reading odb files So I'd been assuming you could read these with OpenOffice - the odb files in the stats directory. I'd never had a reason to give that a try in OOTP11, but I wanted to open the transaction file for OOTP12. However, OpenOffice wants to open it as an ASCII file. Does anyone know what program can be used to open these files? __________________ 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

06-22-2011, 04:46 AM	#2
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156	No, the odb files for those features is not an Open Office format - it's a sort of tab delimited file but I can't get it to open with returns/linefeeds __________________ This signature is intentionally blank

06-22-2011, 09:29 AM	#3
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	It's a custom format designed by OOTP developments, you won't be able to open it in any program. What file are you trying to look at? The historical_database.odb core files are all in the stats directory. __________________ *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

06-22-2011, 11:01 AM	#4
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	It's not the historical database file. It's the transactions and lineups files. I was just wondering if there were ways of editing them. My basic reason, though I can think of a million others, is that they don't work for 19th century. I'm guessing that the transactions in the files (I'm not even sure if there are lineups that old in the lineup file) give real-world transactions, whereas the database had to be heavily modified for OOTP to be able to do automatic team movements for 19th century play. I was thinking I might go on in and edit them so that it at least doesn't make it completely unplayable with historical transactions/lineups on (which is the case 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

06-22-2011, 11:33 AM	#7
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	I do still wish we could actually look at these files. I tend to like to make tweaks to history, and it would be cool to be able to do it by tweaking the file. __________________ 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

06-22-2011, 11:05 AM	#5
Carplos Hall Of Famer Join Date: Feb 2002 Location: Idaho Posts: 2,907 Infractions: 1/0 (0)	Looks like Markus turned off the option for pre-1901 leagues in today's update anyway.

06-22-2011, 12:01 PM	#8
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	For the transaction database to work with pre-1901 it would totally have to be reworked from nearly scratch. So many players switched teams and team changed that it is chaotic. I took a look at it when working on the transactions database but time constraints and general confusion made it impractical. It's something that maybe I will look at at a later date. The lineups aren't there anyway. __________________ *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

06-22-2011, 01:35 PM	#9
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Oh yes, I'd imagine it's a bit of a monster. I remember looking at it when the idea of having this in the game first came up in a thread some months back. I wasn't going to try to replicate history, just make it so that the teams each have enough players to move forward. I guess that's moot anyway, since Markus disabled it. But I also wish I could make little edits here and there - add in some fictional players, set up what-ifs like the Red Sox not trading Ruth, etc. Since when you turn on the historical transactions, it seems to override everything else (as it should), the only way to fiddle with things would be to make changes to that file, but it seems that can't be done. It seems odd to me that this was specifically made to be uneditable, when OOTP has always seemed to go for maximum customizability. __________________ 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