OOTP Developments Forums - View Single Post

tomkmb · 11-30-2022, 05:43 AM

Even if you do have some experience with CSV files the ones dumped from the game are not that straight forward, firstly it's the entire universes info all in one disorganised go.

Also, the 'player_master' csv was a bit of a nightmare to work with for the following reasons:
The output CSV appears to contain characters escaped in the format

Code:

AmpersandHash123semicolon as {

This obviously clashes with the separator used in the CSV file

Code:

.
As a result, the CSV file is effectively invalid unless you first unescape these characters before trying to parse it as a CSV file.
These characters either need to be unesecaped first, or offending fields need to be encapsulated in speech marks "".

It's encoded as 'cp437' too which I've not worked with before which caused some issues too but yeah, it was not simple. Other games like Front Office Football have a very simple and readable dump of CSVs which make working with those a pleasure, I wish FHM could adopt some of that.

I know Jeff mentioned to someone else that the CSV would need sufficient rewriting for it to include something like an interface allowing you to choose the leagues you want to be dumped so I'm not holding my breath for it to happen any time soon but it's a real shame, I wanted to mess with these CSVs and it was more frustrating than anything else even to do the most basic things.

11-30-2022, 05:43 AM	#5
tomkmb All Star Starter Join Date: Jan 2021 Posts: 1,745	Even if you do have some experience with CSV files the ones dumped from the game are not that straight forward, firstly it's the entire universes info all in one disorganised go. Also, the 'player_master' csv was a bit of a nightmare to work with for the following reasons: The output CSV appears to contain characters escaped in the format Code: AmpersandHash123semicolon as { This obviously clashes with the separator used in the CSV file Code: ; . As a result, the CSV file is effectively invalid unless you first unescape these characters before trying to parse it as a CSV file. These characters either need to be unesecaped first, or offending fields need to be encapsulated in speech marks "". It's encoded as 'cp437' too which I've not worked with before which caused some issues too but yeah, it was not simple. Other games like Front Office Football have a very simple and readable dump of CSVs which make working with those a pleasure, I wish FHM could adopt some of that. I know Jeff mentioned to someone else that the CSV would need sufficient rewriting for it to include something like an interface allowing you to choose the leagues you want to be dumped so I'm not holding my breath for it to happen any time soon but it's a real shame, I wanted to mess with these CSVs and it was more frustrating than anything else even to do the most basic things. Last edited by tomkmb; 11-30-2022 at 05:47 AM.