CSV to HTML Box Score Converter

[daigle91]

Compatible with: FHM7, FHM8, FHM9, FHM10.

Click on the following link to download the converter (version 0.48b),

https://1drv.ms/u/c/4bb83e655445e4b5...QWQjQ?e=19uR66

It is on the Microsoft OneDrive cloud storage service.

File name: CSV_to_HTML_Box_Score_Converter.7z

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

- readme.html
- config.txt
- run_script.png
- config.png
- task_manager.png
- html_dir.png
- converter_dir.png
- logo_resize_and_name.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.

Check out the following threads to see its pre-release development history,

https://forums.ootpdevelopments.com/...d.php?t=350886

https://forums.ootpdevelopments.com/...d.php?t=350476

Version history:

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

ver. 0.2b:
- February 14, 2024.
- full name is now displayed for players who assisted on a goal.

ver. 0.3b:
- February 16, 2024.
- fixed issue where OT info wasn't being displayed when a game ended in a tie, for a league that is configured for OT but not a shootout.

ver. 0.4b:
- March 10, 2024.
- 3 new stats: [SQA] shot quality average per team, [SA/60] shots against per 60 minutes, to show a levelled workload comparison between multiple goalies with various minutes played, [QoO] quality of opposition index (0-150+) = opposing [SQA] x [SA/60].
- option for team logo icons to replace the abbreviated team name in the box score report, as well as the option to display the league logo.
- show cumulative season goal and assist totals for players on each goal scored.
- use of colored highlighting for some key stats.
- converter now creates a "Schedule_Results.html" file for websites/on-line leagues, as well as for off-line organizing and archiving of your league's box score history.
- GTG label now displays on the final goal in a regular season tie game, for leagues with no shootout.
- added 2 new batch modes: convert the previous 7, and the previous 30 game days worth of box scores from the current date (to help minimize the number of required CSV exports, while maintaining conversion coverage and performance)
- season [game #] added to the filename of each converted box score .html file for improved referencing.
- box score output style option,
(1) classic (compact/newspaper style),
(2) standard (double spaced, support for league/team logos)
- a few more layout tweaks.

ver. 0.45b:
- April 6, 2024.
- this is a performance update. Through various tweaks and optimizations, I was able to get the converter to scale much more efficiently with very large databases. This will also give smaller databases a speed boost as well.
- added turbo mode option in the config.txt that will double the CPU utilization cap from approximately 25% to 50%.
- added option in the config.txt to focus on a single team. This also provides a speed bonus, as the converter will skip creating boxscores that don't have this specific team in it.
- raised the database size cap to accommodate very large databases.

ver. 0.46b:
- April 10, 2024.
- fixed issue where converter would hang with an FHM7 database when it got to a pre-season/regular season game with overtime penalties where the overtime period was defined as 'OT' rather than the newer 'OT#' format, in the boxscore_period_penalties_summary.csv

ver. 0.47b:
- April 14, 2024.
- some more optimization, and lowered memory usage.
- added option to turn off cumulative season goal and assist totals for players on each goal scored (which also improves conversion speed).
- fixed cumulative goal and assist totals issue with conversions for FHM 7.

ver. 0.48b:
- April 24, 2024.
- further optimization improved pre-processing speed (cumulative goal/assist calculations) up to 25% on leagues that have less than 500 games played, and up to 50% on leagues that have over 1000+ games played.
- removed shot quality references from the boxscore report for FHM7, FHM8 (set application_ID=7, or application_ID=8. You can choose this option even if you have FHM9 or higher). If you combine that choice with the option to turn off cumulative season goals and assist totals, the converter will create a simple (circa pre 1980s) newspaper style boxscore report.
- fixed issue with the odd game here or there not showing updated cumulative goals or assists in the boxscore report.
- added the option for a web based schedule/results page, #######_Schedule_Results_On-line.html (requires the URL path for your website to be defined in config.txt).
- FHM7 specific: fixed issues with a goal scorer's team sometimes not correctly identified in the boxscore report.

[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