CSV to HTML Reports?

[drummerJ99]

Originally Posted by daigle91

Here is a sample HTML boxscore created by my CSV to HTML converter tool.

Just wondering if there's any eta on a release date for this tool?

[daigle91]

Originally Posted by drummerJ99

Just wondering if there's any eta on a release date for this tool?

I don't have an eta just yet, as their is still a lot of little things to do, but I will update as I go along.

If anyone is interested in letting me test their CSVs with this tool, I would need you to e-mail me the following files,

league_data.csv
player_master.csv
team_data.csv
schedules.csv
player_skater_stats_rs.csv
boxscore_summary.csv
boxscore_skater_summary.csv
boxscore_goalie_summary.csv
boxscore_period_scoring_summary.csv
boxscore_period_penalties_summary.csv

e-mail:
mrmikecrawford@rogers.com

[drummerJ99]

Originally Posted by daigle91

I don't have an eta just yet, as their is still a lot of little things to do, but I will update as I go along.

If anyone is interested in letting me test their CSVs with this tool, I would need you to e-mail me the following files,

league_data.csv
player_master.csv
team_data.csv
schedules.csv
player_skater_stats_rs.csv
boxscore_summary.csv
boxscore_skater_summary.csv
boxscore_goalie_summary.csv
boxscore_period_scoring_summary.csv
boxscore_period_penalties_summary.csv

e-mail:
mrmikecrawford@rogers.com

Sent a email for both my WHA franchise and my 2002 historical playthrough. Hopefully either or both can help you along. Thanks again for doing the work on this.

[daigle91]

have a small update... the converter now lists both goalies for each team, as well as stats for the backup goalies if they played any minutes.

[tomkmb]

Originally Posted by daigle91

have a small update... the converter now lists both goalies for each team, as well as stats for the backup goalies if they played any minutes.

Awesome, nice work dude. What language are you working in just out of interest?

[daigle91]

Originally Posted by tomkmb

Awesome, nice work dude. What language are you working in just out of interest?

I started out with Perl but ended up using AutoHotkey for this project. I used it to before on a custom GUI and really liked it.

[tomkmb]

Originally Posted by daigle91

I started out with Perl but ended up using AutoHotkey for this project. I used it to before on a custom GUI interface and really liked it.

Oh dang, I've only ever used AutoHotKey for stuff like moving directories and files etc - Didn't know it was capable of CSV manipulation and HTML output, that's real interesting thanks for the heads up.

[daigle91]

another update!... was able to get batch CSV to HTML conversion implemented along with the corresponding HTML file naming format in place.

[matt#5]

working on a phyton / jupyter notebook solution to analyse player skills (playmaking, shooting, ...) per Positiontype (Goalie, Defense, Forwards) and Team.
Taking Average, Min, Max of each skill type and compare with league average, league min, max...
I´d like to get a better understandig of my teams weeknesses and strenghts with this list.

first prototyp is running (output in Excel as flat list at the moment) with interactive filter option for user (select League, select team, ...) within the notebook.

Will share some screenshots when ready

Next steps:
a) add charts for better visualisation
b) make solution executable without need of jupyter nb (perhaps we could combine it with AutoHotKey)
c) add more elements to compare team/player performance between sprints of 5 games
d) feel free to add something to wishlist ;-)

[daigle91]

update...
Implemented support for multiple leagues, and within each league various CSV to HTML box score reports are possible (Pre-season, Regular Season, and Playoffs etc.)
Have also completed the handling overtime (regular season) and shoot outs.

[hurricanekevin]

This is awesome, I'm here to encourage the development of this project!

[BoiledEgg]

I'd be happy if we can get an export to CSV capability for draft prospects and injury lists for multiplayer leagues. It would facilitate a smoother off-season. Devs are sitting on a gold mine if they can develop a more robust way to export data to better analyze, etc., it would be greatly appreciated.

[daigle91]

Originally Posted by hurricanekevin

This is awesome, I'm here to encourage the development of this project!

Many thanks.
I am hoping to have it complete by the beginning of next week

[fredbeene]

ridiculous thread. UFB 25 years in and HTML reports are the norm with barely any in game reporting analysis. Not new metrics or measures available here

[tomkmb]

Originally Posted by daigle91

Many thanks.
I am hoping to have it complete by the beginning of next week

Awesome!

[drummerJ99]

Originally Posted by daigle91

Many thanks.
I am hoping to have it complete by the beginning of next week

Awesome. Really looking forward to this.

[daigle91]

update... I would say the converter is now about 99% done.
Here is the final box score layout (I have tweaked several things, shuffled some others around. I added Turnovers (TO) and Total face-offs (FO) in the Game Stats box, and Goals Against Average (GAA) in the Goaltending Stats box, and converted a playoff game with double overtime to unveil OT data ... note, OT shots are not stored on a period by period basis, but as an overall combined sum (if more than 1 OT, which I only display in the final OT period).

[tomkmb]

Originally Posted by daigle91

update... I would say the converter is now about 99% done.
Here is the final box score layout (I have tweaked several things, shuffled some others around. I added GAA in the goaltending stats box, and converted a playoff game with double overtime to unveil OT data)

Great stuff!

[daigle91]

Just want to give credit to landru22 for a great html box score design ...

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

from which the basic framework for my current version is modelled after.

[landru22]

Thank you. I am following this thread very closely to monitor your progress. I can't wait to try it out when finished!