.csv Files

Makonnen · 05-22-2020, 11:40 PM

So ... I had a theory that if a player existed in master.csv, if I added them to players.csv, they would be made available to a league in the DEBUT year from master.csv.

So far I am unable to make that theory work. Anyone have a guide or some hints or a reference source for how to manipulate these files to customize when and how players enter a league?

tomnov · 05-26-2020, 09:41 PM

That would indeed make importing players or creating a player pool for a game or a universe MUCH easier, but if you compare the format of the master.csv file with any individual game's players.csv file, you'll see that it's a completely different format.
You have to use the import players function as described in the online game menu (either 1 player at a time or from a .txt file) to get them into your current game.
And the master.csv file itself just exists as sort of a reference to one of the unreadable .odb files contained in the game.

Oh, I could envision a much more enjoyable version of "random debut", if I could create a file with a pool of pre selected players to randomly debut in my league. I could filter by teams or leagues, easily include random Negro League players instead of just when they entered the major leagues, if at all, and many more scenarios I couldn't yet think of.
**hmm, wonder if I could do such a thing with an 'edited' version of master.csv (if anyone wants to experiment with that, remember to back up the original or you may lose access to any players you delete out)

Makonnen · 05-27-2020, 03:24 PM

Yeah, I gave up on this direction.

The challenge throughout is an the (as far as I can tell) total in ability to change what OOTP thinks PlayerX should be--that is, you have to learn how to manually edit the players so their career fits what you want.

Clearly only an issue for NeL and/or fantasy players. But a huge issue there--the NeL players are wildly underrated (imo).

tomnov · 05-27-2020, 10:43 PM

That's another thing I would like to change.
Let there be a way to more easily adjust individual players abilities based on stats, not guessing at the ratings, or even mass adjust entire leagues.or groups of players, such as your example with the Negro Leagues; doing a what-if based on a player NOT suffering a career ending injury or one stuck behind a superstar. Also when intermixing players from different eras, or young prospects that aren't getting the chance you feel they deserve IRL, or ones performing above their ratings this year in their rookie seasons....
I know many many statistics have gone into creating the player rating system and in the opinion of the game creators and its statisticians they got them all right, but dammit, if I want to play in god mode (commissioner mode) then I want an easier way to play god

DrDoom · 08-06-2020, 03:37 PM

You can try the database tools I created. 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 if you want to give them a try.

05-22-2020, 11:40 PM	#1
Makonnen All Star Reserve Join Date: May 2020 Posts: 910	.csv Files So ... I had a theory that if a player existed in master.csv, if I added them to players.csv, they would be made available to a league in the DEBUT year from master.csv. So far I am unable to make that theory work. Anyone have a guide or some hints or a reference source for how to manipulate these files to customize when and how players enter a league?

05-26-2020, 09:41 PM	#2
tomnov Minors (Double A) Join Date: Nov 2017 Posts: 118	That would indeed make importing players or creating a player pool for a game or a universe MUCH easier, but if you compare the format of the master.csv file with any individual game's players.csv file, you'll see that it's a completely different format. You have to use the import players function as described in the online game menu (either 1 player at a time or from a .txt file) to get them into your current game. And the master.csv file itself just exists as sort of a reference to one of the unreadable .odb files contained in the game. Oh, I could envision a much more enjoyable version of "random debut", if I could create a file with a pool of pre selected players to randomly debut in my league. I could filter by teams or leagues, easily include random Negro League players instead of just when they entered the major leagues, if at all, and many more scenarios I couldn't yet think of. **hmm, wonder if I could do such a thing with an 'edited' version of master.csv (if anyone wants to experiment with that, remember to back up the original or you may lose access to any players you delete out)

05-27-2020, 03:24 PM	#3
Makonnen All Star Reserve Join Date: May 2020 Posts: 910	Yeah, I gave up on this direction. The challenge throughout is an the (as far as I can tell) total in ability to change what OOTP thinks PlayerX should be--that is, you have to learn how to manually edit the players so their career fits what you want. Clearly only an issue for NeL and/or fantasy players. But a huge issue there--the NeL players are wildly underrated (imo).

05-27-2020, 10:43 PM	#4
tomnov Minors (Double A) Join Date: Nov 2017 Posts: 118	That's another thing I would like to change. Let there be a way to more easily adjust individual players abilities based on stats, not guessing at the ratings, or even mass adjust entire leagues.or groups of players, such as your example with the Negro Leagues; doing a what-if based on a player NOT suffering a career ending injury or one stuck behind a superstar. Also when intermixing players from different eras, or young prospects that aren't getting the chance you feel they deserve IRL, or ones performing above their ratings this year in their rookie seasons.... I know many many statistics have gone into creating the player rating system and in the opinion of the game creators and its statisticians they got them all right, but dammit, if I want to play in god mode (commissioner mode) then I want an easier way to play god

08-06-2020, 03:37 PM	#5
DrDoom Minors (Single A) Join Date: Jul 2004 Posts: 75	You can try the database tools I created. 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 if you want to give them a try.