CSV to HTML Box Score Converter

[daigle91]

Compatible with: FHM7, FHM8, FHM9, FHM10, FHM11 only.

Copy the following link to your browser's address bar to download the converter (version 0.55b),

https://1drv.ms/u/c/4bb83e655445e4b5/EV33JjktNHNFuyaBHcNLFIcB9x_1OxDqv0aZJk-Bi69goQ?e=AUY3iy

It is on the Microsoft OneDrive cloud storage service (It does not require a login to download).

File name: CSV_to_HTML_Box_Score_Converter.7z

It was archived with the free software, 7-Zip, and contains
the following (12) files:

- readme.html
- config.txt
- title.png
- run_script.png
- config.png
- task_manager.png
- html_dir.png
- converter_dir.png
- logo_resize_and_name.png
- standings.png
- roster_Export_period.png
- CSV_to_HTML_Box_Score_Converter.ahk

(The installation of AutoHotkey v1.1 is required to run the converter, you will need to download that from their website seperately).

All required setup details are in the readme.html file.

If you need any help or have any requests, please post in this thread.

Version history:

ver. 0.1b:
- February 11, 2024.
- initial beta release.

ver. 0.2b - ver. 0.52b history available in readme.html.

ver. 0.53b:
- August 15, 2024.
- fixed issue with Shootout goals not adding to a team's overall GF/GA totals.
- fixed issue with a loss in overtime being treated as a (T) rather than a (L) in a league setup for no (OTL) in a team's record (only W, L or T). ***Requires display_OT_in_standings=0 in config.txt for the converter to make the distinction, as well as to show T in standings rather than OT.

ver. 0.54b:
- November 3, 2024
- added check for players with ID (-1), which can cause various data to display incorrectly.
- Now fully compatible with FHM 11 (fixed issue with goalie stats).

ver. 0.55b:
- November 10, 2024
- updated the "check for player's with ID (-1)" code to allow the converter to continue on (rather than exiting) if a player with ID (-1) is found in the player_master.csv, but not in the league you are converting.

ver. 0.6b:
- ETA: April 30, 2025 (85% complete)

[drummerJ99]

Have not had a chance to use this yet between work and being sick. But just want to say a huge thanks for all the time you put into this. Really looking forward to it.

[daigle91]

Originally Posted by drummerJ99

Have not had a chance to use this yet between work and being sick. But just want to say a huge thanks for all the time you put into this. Really looking forward to it.

Many thanks, I really enjoyed the process of building it (its actually part of another CSV project I am working on ).

some ideas for a later version,

- option for team logo icons to replace the abbreviated team name in the box score reports.

- show cumulative season goal and assist totals for players on each goal scored (would require more coding and parsing of CSVs to calculate this info, as it is not available directly in the CSVs).

- optimize the code to improve converting performance.

[drummerJ99]

Finally got around to downloading it tonight. Works great!. My one suggestion if possible would be list the full name for the assits. So for example it's currently:
0:55 CBJ, Andrew Cassels (R.Nash, M.Sillinger), PP

I know that is Rick Nash and not say Riley, since that's my team. But it'd be awesome if that was called out if possible to say:
0:55 CBJ, Andrew Cassels (Rick Nash, Mike Sillinger), PP

And of course, as you mentioned on your wishlist, goals and assist totals would be awesome if possible.

[daigle91]

Originally Posted by drummerJ99

Finally got around to downloading it tonight. Works great!. My one suggestion if possible would be list the full name for the assits. So for example it's currently:
0:55 CBJ, Andrew Cassels (R.Nash, M.Sillinger), PP

I know that is Rick Nash and not say Riley, since that's my team. But it'd be awesome if that was called out if possible to say:
0:55 CBJ, Andrew Cassels (Rick Nash, Mike Sillinger), PP

Very easy to do, I will definitely change that in the next update

[daigle91]

Originally Posted by drummerJ99

Finally got around to downloading it tonight. Works great!. My one suggestion if possible would be list the full name for the assits. So for example it's currently:
0:55 CBJ, Andrew Cassels (R.Nash, M.Sillinger), PP

I know that is Rick Nash and not say Riley, since that's my team. But it'd be awesome if that was called out if possible to say:
0:55 CBJ, Andrew Cassels (Rick Nash, Mike Sillinger), PP.

Its now updated to show the full name for players with an assist on a goal (see version 0.2b)

[sgrondin98]

Je pense que je peut te répondre en français

Bref je voulais te remercier pour ce travaille formidable et je vais le tester dès la prochaine saison (Je suis en saison morte)

J'espère voir dans tes projets que tu parle voir un outil qui pourra y intégrer pleins de trucs interessant comme les classements les menerus les records etc.....

Des idées j'en ai en masse mais c'est la connaissance que j'ai pas

En passant ton boxscore fonctionne pour des ligues fictivesavec plus de 32 équipes et des noms n'existant pas ?

Merci encore pour ce travail c'est grandement apprécier.

[daigle91]

a work in progress update for version 0.4b, more layout tweaks and graphics support for league, and team logos
(credit to Wabba for use of the NHA Alternate Universe league/team name and logos)
https://forums.ootpdevelopments.com/...d.php?t=351461

[drummerJ99]

Originally Posted by daigle91

a work in progress update for version 0.4b, more layout tweaks and graphics support for league, and team logos
(credit to Wabba for use of the NHA Alternate Universe league/team name and logos)
https://forums.ootpdevelopments.com/...d.php?t=351461)

Nice addition. Looks great.

[daigle91]

Originally Posted by drummerJ99

Nice addition. Looks great.

Many thanks!

Here is a look at the revamped game stat boxes (for version 0.4b) with three new stats: [SQA] shot quality average, [SA/60] shots against per 60 mins., [QoO] quality of opposition index (0-150+) = opposing [SQA] x [SA/60].

[QoO] >100 would mean the goaltender faced an All-Star level of offensive skill.

[drummerJ99]

Is there any plans in the future to do standings or stats?

And not sure if you know the answer but is there a way to upload and turn these into a website?


Sent from my iPhone using Tapatalk

[daigle91]

Originally Posted by drummerJ99

Is there any plans in the future to do standings or stats?

This and much more will be part of my next project, which is already in progress.

Originally Posted by drummerJ99

And not sure if you know the answer but is there a way to upload and turn these into a website?

That's an easy process... after you find a website hosting service and get a domain name, you would simply need to upload your main website page (usually called index.htm or index.html) to the website hosting server (most likely through a web based app provided by the website host or with an FTP client). This index file can link to all the other uploaded html files (like the ones generated by this converter) that make up your website, including any images you upload as well. I could have the converter create a basic index.html file to do just that.

[drummerJ99]

Originally Posted by daigle91

This and much more will be part of my next project, which is already in progress.

That's an easy process... after you find a website hosting service and get a domain name, you would simply need to upload your main website page (usually called index.htm or index.html) to the website hosting server (most likely through a web based app provided by the website host or with an FTP client). This index file can link to all the other uploaded html files (like the ones generated by this converter) that make up your website, including any images you upload as well. I could have the converter create a basic index.html file to do just that.

All that sounds awesome. Thanks so much for all the hard work you've put into this. When it comes to coding, i'm lost. LOL

[sgrondin98]

Its awesome.

Can i ask to add like in your choice of simulation match you want to export to last 7 days ??

My league simulation rythm is one days i simulated 7 days. If its a big trouble no problem.

I see you have project for standings - stats etc.... Look i create and copy a littel bit some design to have something nice but im a newbie in coding so i know my website have a lot of bug and i dont have knowledge about DB so i do EVERYTHING manually and it take me a LOT of TIME

Maybe if i shared you some of my page maybe you could implemented some of my need (Stats-standings-records etc...) on your tools in future update ??

I dont know if it will show correctly but if not you have to remove the s in the https...

Here are some link:

A roster page:
http://hf.hockeyhq.net/HockeyFederat...osAngeles.html

A career leader page:
http://hf.hockeyhq.net/HockeyFederat...e/Meneurs.html

A career leader page:
https://hf.hockeyhq.net/HockeyFedera...e/Records.html

Trophy page:
https://hf.hockeyhq.net/HockeyFedera.../Trophees.html

Top 5 Teams:
http://hf.hockeyhq.net/HockeyFederat...que/Top5E.html

Power rankings:
http://hf.hockeyhq.net/HockeyFederat...rRankings.html

Salaries:
http://hf.hockeyhq.net/HockeyFederat...ue/Masses.html

I will put every player here:
http://hf.hockeyhq.net/HockeyFederat...Listes2/A.html

Draft:
http://hf.hockeyhq.net/HockeyFederat.../Saison12.html

Season Stats:
http://hf.hockeyhq.net/HockeyFederat...ucks_HF20.html

Career team standings:
http://hf.hockeyhq.net/HockeyFederat...s/Anaheim.html

Career team leader:
http://hf.hockeyhq.net/HockeyFederat...s/Anaheim.html

Remember i do everything manually ... each update i do it manually so you understand why your tool is a must form me

Thanx for everything and hope to see the future update

[drummerJ99]

Originally Posted by sgrondin98

Its awesome.

Can i ask to add like in your choice of simulation match you want to export to last 7 days ??

My league simulation rythm is one days i simulated 7 days. If its a big trouble no problem.

I see you have project for standings - stats etc.... Look i create and copy a littel bit some design to have something nice but im a newbie in coding so i know my website have a lot of bug and i dont have knowledge about DB so i do EVERYTHING manually and it take me a LOT of TIME

Maybe if i shared you some of my page maybe you could implemented some of my need (Stats-standings-records etc...) on your tools in future update ??

I dont know if it will show correctly but if not you have to remove the s in the https...

Here are some link:

A roster page:
http://hf.hockeyhq.net/HockeyFederat...osAngeles.html

A career leader page:
http://hf.hockeyhq.net/HockeyFederat...e/Meneurs.html

A career leader page:
https://hf.hockeyhq.net/HockeyFedera...e/Records.html

Trophy page:
https://hf.hockeyhq.net/HockeyFedera.../Trophees.html

Top 5 Teams:
http://hf.hockeyhq.net/HockeyFederat...que/Top5E.html

Power rankings:
http://hf.hockeyhq.net/HockeyFederat...rRankings.html

Salaries:
http://hf.hockeyhq.net/HockeyFederat...ue/Masses.html

I will put every player here:
http://hf.hockeyhq.net/HockeyFederat...Listes2/A.html

Draft:
http://hf.hockeyhq.net/HockeyFederat.../Saison12.html

Season Stats:
http://hf.hockeyhq.net/HockeyFederat...ucks_HF20.html

Career team standings:
http://hf.hockeyhq.net/HockeyFederat...s/Anaheim.html

Career team leader:
http://hf.hockeyhq.net/HockeyFederat...s/Anaheim.html

Remember i do everything manually ... each update i do it manually so you understand why your tool is a must form me

Thanx for everything and hope to see the future update

Very nice. May have to try and figure out how to do that to spice up the online league I’m in.


Sent from my iPhone using Tapatalk

[daigle91]

sgrondin98,

Your website is very impressive... great work

Originally Posted by sgrondin98

Can i ask to add like in your choice of simulation match you want to export to last 7 days ??

My league simulation rythm is one days i simulated 7 days. If its a big trouble no problem.

I created a new batch mode to handle this.

Originally Posted by sgrondin98

Maybe if i shared you some of my page maybe you could implemented some of my need (Stats-standings-records etc...) on your tools in future update ??

Well my next update (version 0.4b) is almost ready. I am going to have the converter generate a "schedule_results.html" that would link to all the box score reports generated by the converter (which would be helpful for both on-line and off-line scenarios). Do you have a link on your website for that? If so, I could use your schedule/results page as a template for the converter.
For the other areas of your website, which would be the highest priority to do first?

Originally Posted by sgrondin98

Remember i do everything manually ... each update i do it manually so you understand why your tool is a must form me

Thanx for everything and hope to see the future update

Many thanks!

[sgrondin98]

Thanx for your answer and thanx for your comments.

First i forgot to tell you that im still not using FHM 10 ... im still with version 7.... i know im far behind but i didn't want to change the version because for me and the league its fine.

second: I dont have website where i put the csv files or dat files like i said everything im doing is by myself (like printscreen) manually so maybe to help you just tell me which files you need from my saves and ill pack it up on a zip files and send it to you ?

I have a forum where you can go and check every link i send you but you will not have access to any csv files because i dont upload those files on the server.

here is the league link (French league)

http://www.hockeyfederation.com/forum

[daigle91]

Originally Posted by sgrondin98

Thanx for your answer and thanx for your comments.

First i forgot to tell you that im still not using FHM 10 ... im still with version 7.... i know im far behind but i didn't want to change the version because for me and the league its fine.

I just checked the converter, and it works great with FHM7.
Shot attempts, and shot quality stats are missing in the box score report because they were not kept track of in that version (or FHM8). The new stat I am introducing, [QoO] quality of opposition index, would also be missing, as it is dependent on shot quality stats.

Originally Posted by sgrondin98

second: I dont have website where i put the csv files or dat files like i said everything im doing is by myself (like printscreen) manually so maybe to help you just tell me which files you need from my saves and ill pack it up on a zip files and send it to you ?

Do you have a link or screen shot of your league's schedule/results? If so, post it in this thread and I will try to match its layout in an HTML format for the converters output. You can then upload this generated schedule/results HTML file to your website. It wouldn't require any .csv or .dat files, only the .html box scores generated by the converter for it to hyperlink to.

[daigle91]

an update on the box score layout tweaks with color highlighting...

[daigle91]

an update on the layout for the schedule_results.html file...
(credit to Wabba for use of the NHA Alternate Universe league/team name and logos)
https://forums.ootpdevelopments.com/...d.php?t=351461