CSV to HTML?

[reverist]

Does anyone know of anything that would make my CSV info usable? I have no clue what I am looking at, and I had heard rumors that a CSV to HTML tool was in the works by someone.

[drummerJ99]

Originally Posted by reverist

Does anyone know of anything that would make my CSV info usable? I have no clue what I am looking at, and I had heard rumors that a CSV to HTML tool was in the works by someone.

I contacted landru22 he's the one that made the FHM7 html Boxscore Creator . He emailed me one that worked with FHM8. I don't see it posted anywhere here on the forums. Not sure if it works for FHM9. I mainly use it for box score. Wish the game would just export to html like OOTP or give us a official CSV to HTML converter.

[reverist]

Originally Posted by drummerJ99

I contacted landru22 he's the one that made the FHM7 html Boxscore Creator . He emailed me one that worked with FHM8. I don't see it posted anywhere here on the forums. Not sure if it works for FHM9. I mainly use it for box score. Wish the game would just export to html like OOTP or give us a official CSV to HTML converter.

Thanks for this! I will check it out.

EDIT: Could not get it to work on FHM7 or 9.

[sgrondin98]

Yes i have this tool and it works with FHM 7 buts its very limited. And if you changed the structure of your league you will miss a lot of stats....And i ask Landru for an update or something like this but he dont want to work on this tool anymore.

I hope to see in the future that kind of tool but with more information like

Attributs - Salary - contract - Stats - Records - Standings - More information on the boxscore and lot more

CSV to html or directly an export to html is a must.

CSV are for people who know how to work with those files and need to know how work a database.

html is more simple.

Anyway i hope every year to see this tool add to the game.....

[tomkmb]

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

AmpersandHash123semicolon as {

This obviously clashes with the separator used in the CSV file

;

.
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.

[drummerJ99]

Originally Posted by reverist

Thanks for this! I will check it out.

EDIT: Could not get it to work on FHM7 or 9.

I couldn't get the FHM7 one to work with FHM8. But I private messaged him and he emailed me one for FHM8 that supposedly also works with 9. I don't see that one actually listed anywhere here on the forums.

Originally Posted by sgrondin98

Attributs - Salary - contract - Stats - Records - Standings - More information on the boxscore and lot more

Is all that exported in the CSV now?

Originally Posted by tomkmb

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

AmpersandHash123semicolon as {

This obviously clashes with the separator used in the CSV file

;

.
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.

Jeff has also mentioned he has no interest in HTML as the OOTP guys said "it was a nightmare", so I doubt we will ever get more then CSV. And as you said, it'd need sufficient rewrite to select what gets dumped.I'd be highly surprised if we ever get anything more then we have now.

[halldorr]

Originally Posted by tomkmb

Also, the 'player_master' csv was a bit of a nightmare to work with

This is what I was finding as well. I wrote something where I could upload a zip of the CSVs, it would unzip the CSVs, then insert it into temporary tables.

I still had to code up all the HTML reports stuff but ran into this very issue you mention with the ampersands causing issues.

[tomkmb]

Originally Posted by halldorr

This is what I was finding as well. I wrote something where I could upload a zip of the CSVs, it would unzip the CSVs, then insert it into temporary tables.

I still had to code up all the HTML reports stuff but ran into this very issue you mention with the ampersands causing issues.

Yeah, this is an issue which I cant help but feel must just be an oversight in how that dump feature works. Unless there is a reason for those HTML escape characters to just be included on the end of some lines and I'm just ignorant of that (which is entirely possible). Even if they made an amendment to change the encoding to something like 'latin-1' and got rid of the unescaped HTML that would be a huge improvement for the player_master.csv when it comes to trying to do anything with Pandas/Python with it.