FHM7 HTML Generator

landru22 · 02-20-2021, 08:31 AM

Introducing FHM7 html Generator. This is a vbscript that will create html pages from your FHM7 saves utilizing the csv exports.

***** PLEASE READ THESE INSTRUCTIONS CAREFULLY BEFORE YOU USE *****
***** THIS IS NOT RECOMMENDED FOR LARGE UNIVERSES!!! SAVES WITH A LARGE NUMBER OF LEAGUES AND TEAMS WILL ADD A GREAT AMOUNT OF PROCESSING TIME!!!
***** USE AT YOUR OWN RISK *****

Overview:
The program creates a series of html files for viewing outside of FHM7. The index.html will have a link to the standings screen for each league. From there, you can click on the team name and be brought to the scoring and goaltending page for each team. Finally, from the team scoring/goaltending page there will be a link for each player that played for that team in the current season. For the Top League only, there will be a skater index and a goalie index created, plus a league schedule page with links to boxscores for each game.

Note:
Only the players that the game has generated pictures for will have their images at the top of each player html file.
I hope you find this script useful. Although I am sure it will not suit everyone's needs, I believe that it can be useful for commissioners of online leagues and for players that like to have the ability to view their leagues outside of the FHM game. For those with the know-how, feel free to change the script to suit your needs. I am a novice programmer and my knowledge of html is rudimentary.

This script was written to suit my needs, but I thought that others may find it useful so I decided to share.
It was created for Windows users, but it may work on Linux using the WINE Windows Emulator. Sorry MAC users, I don't know if it will work for you.

***** IT IS HIGHLY RECOMMENDED THAT YOU BACKUP YOUR SAVE PRIOR TO RUNNING THE SCRIPT *****
I don't expect any save destroying issues, but it is better to be safe than sorry!

To USE:
1) While in the FHM7 game, Select "Create CSV Export" from the <WORLD> Menu. Save and exit the program

2) Download and unzip FHM7-htmlGEN.vbs from this link:
https://drive.google.com/file/d/1cDp...ew?usp=sharing

3) I recommend that you copy your league folder (your_league_folder.lg) located in
C:\Users\your_User_Name\Documents\Out of the Park Developments\Franchise Hockey Manager 7\saved_games to a temp directory somewhere on your computer.

4) Place the downloaded script file (FHM7-htmlGEN.vbs) into your league folder directory (the folder with all of the .dat files) that you moved to the temp directory. (For example C:\temp\your_league_folder.lg)

To run:
1) Double-click the FHM7-htmlGEN.vbs file. Processing time will depend on the amount of players and leagues in your save. Be patient, the script may take more than a few minutes to complete (**Note: My league which consists of three 30-team leagues – Major/Minor/Junior - took about 3 - 4 minutes to run on my 6-year-old-laptop**). The program will notify you of its progress as it runs (reading CSV files, Creating Index files, Creating League Standings files, Creating player html files, Creating team html files, Creating Boxscores)

2) When the script is finished you will be notified by a message box that will say “Done”. Click the “OK” on the message box.

To view:
The html files will reside in the exports\html directory contained in your league folder. Double-click on the index.html file and from there you can click on the league you wish to view. Index files for skaters and goalies for your top league are also created (skater_index.html and goalie_index.html) in the html directory. If you wish, you can import these index files into a spreadsheet program and create your own league leaders pages. The index file will also contain a link to each player’s html file.

For more information about the created box scores, see this thread:
https://forums.ootpdevelopments.com/...d.php?t=323839

Here are some screenshots

landru22 · 02-20-2021, 08:50 AM

Here's another screenshot.

landru22 · 02-21-2021, 07:59 AM

There is an issue that I should mention. It seems the standings don't generate properly in the early part of a season. It will omit teams, I think when there are multiple teams with the same record or something along those lines. I haven't been able to pinpoint the trouble yet, but it seems to straighten itself out when teams have played about 10 or so games. Even if the team is omitted from the standings it will still create a team page for them, there just won't be a link to it on the standings page

shelrik · 02-25-2021, 11:05 PM

Thanks for sharing this with us. As much as I want to use it won't work for me. Sets up the folders to create the html files but does not complete.

Get the following....

Line 309
Char 17
Error Overflow "Clint"
Code 800A0006
Microsoft VBScript runtime error

shelrik · 02-25-2021, 11:06 PM

Thanks for sharing this with us. As much as I want to use it won't work for me. Sets up the folders to create the html files but does not complete.

Get the following....

Line 309
Char 17
Error Overflow "Clint"
Code 800A0006
Microsoft VBScript runtime error

So it starts to work but hangs. Any help is appreciated.

Thanks!

landru22 · 02-26-2021, 10:18 AM

Thank you for showing interest in my mod.. What does your league structure look like? Do you have a very large save with a lit of leagues and teams? Or perhaps you have played many many seasons. That line is reading in the league ID of players from the csv file for career stats. The CInt means that I am converting character data to an integer. Perhaps I need to make that line of code a little different. Is there a way to share your league file with me? Perhaps a drop box or a Google drive?

landru22 · 02-26-2021, 10:42 AM

If you wish, you can PM me and I'll give you my email address, assuming the file isn't too large for an email attachment

shelrik · 02-26-2021, 07:31 PM

Hello,

Thanks for getting back to me. I started a new standard game with the NHL 2020-21 season. It also includes the AHL and Canadian Junior Leagues (3) and no other. I don't have drop box or google drive...sorry...

That said I'm going to start a small historical season and see what happens. The whole file (folder) is 1.2g so way to big for email.

See what happens and will let you know.

Thanks
Rick

Schifty · 03-10-2021, 12:01 AM

Just wanted to know if this tool export only statistic, mean there is any HTML files exported with attribute of those player ?

landru22 · 03-10-2021, 09:39 PM

Quote:

Originally Posted by Schifty

Just wanted to know if this tool export only statistic, mean there is any HTML files exported with attribute of those player ?

No, sorry. Stats only - no ratings.

bwyant32 · 05-26-2021, 08:04 AM

I am seeing the same overflow runtime error on the same line and character.

bwyant32 · 05-26-2021, 08:15 AM

I actually did some research on this error:

This error is caused by the VB Script function CInt, which gives an overflow error when using a number that is greater than its range. CInt only has a range between the integers -32,768 to 32,767. If a number is passed to this function that is out of the range, this error will be displayed.

As a workaround to the limitation of CInt, use the VBScript CLng function which has a range of -2,147,483,648 to 2,147,483,647. This will give a wider data type range to work with.

karg007 · 06-26-2021, 12:29 PM

Any update on this addon? Cause even if we change the CInt to CLng, we still get an error...... :/

landru22 · 06-27-2021, 09:22 AM

Sorry. It just won't work as is with the standard NHL setup. If I remember correctly it was due to the fact that league id #'s for the NHL, AHL, and Junior Leagues were not 0, 1, and 2 as they are in a Fictional save. I wrote this script to be used in my Fictional universe and thought it might work for a basic NHL setup as well, so I shared it. Unfortunately, it will take a major recode to get it to work for most of you and I simply don't have the time to do it. If you have any visual basic coding experience, feel free to edit the script to your needs

RangersKoivu · 08-23-2021, 08:13 AM

Hi, I tried to use this program for my fictional league setup (2 leagues with 4 teams each, first season). However I always get the same error.

Line: 565
Char: 5
Error: Subscript out of range: 'z'
Code: 800A0009
Source: Microsoft VBScript runtime error

This program seems really interesting to use so this error is a bummer for me.

alko · 08-24-2021, 10:48 AM

Any update to count also who won the most Stanley Cups? Most Gagarin Cups. Hart Trophies...

sgrondin98 · 09-27-2021, 05:53 PM

Hi ,

I have a question about your generator.

I think its not working if you create a new team that doesnt exist.

I create a custom league with custom name teams and real teams... but if i try to see the stats of teams i cant see the stats player of those teams but i can see the stats in the players stats index.....

Could you please explain me why the players stats show in the player index but in the team index they dont have the team stats in the team index.....

Example i see the montreal Canadien stats players in the skaters index AND on the team index but if i try to see the players stats of the Seattle kraken the player stats is show on the Skater index but not in the team index and Seattle doesnt appear in the Team index....

Thanx a lot for your answer.

landru22 · 09-27-2021, 09:15 PM

I'm sorry. I am no longer working on this project. Hopefully FHM8 will have something like this as part of the release.

02-20-2021, 08:31 AM	#1
landru22 Major Leagues Join Date: Jul 2010 Posts: 462	FHM7 HTML Generator Introducing FHM7 html Generator. This is a vbscript that will create html pages from your FHM7 saves utilizing the csv exports. *** PLEASE READ THESE INSTRUCTIONS CAREFULLY BEFORE YOU USE * * THIS IS NOT RECOMMENDED FOR LARGE UNIVERSES!!! SAVES WITH A LARGE NUMBER OF LEAGUES AND TEAMS WILL ADD A GREAT AMOUNT OF PROCESSING TIME!!! * USE AT YOUR OWN RISK * Overview: The program creates a series of html files for viewing outside of FHM7. The index.html will have a link to the standings screen for each league. From there, you can click on the team name and be brought to the scoring and goaltending page for each team. Finally, from the team scoring/goaltending page there will be a link for each player that played for that team in the current season. For the Top League only, there will be a skater index and a goalie index created, plus a league schedule page with links to boxscores for each game. Note: Only the players that the game has generated pictures for will have their images at the top of each player html file. I hope you find this script useful. Although I am sure it will not suit everyone's needs, I believe that it can be useful for commissioners of online leagues and for players that like to have the ability to view their leagues outside of the FHM game. For those with the know-how, feel free to change the script to suit your needs. I am a novice programmer and my knowledge of html is rudimentary. This script was written to suit my needs, but I thought that others may find it useful so I decided to share. It was created for Windows users, but it may work on Linux using the WINE Windows Emulator. Sorry MAC users, I don't know if it will work for you. * IT IS HIGHLY RECOMMENDED THAT YOU BACKUP YOUR SAVE PRIOR TO RUNNING THE SCRIPT * I don't expect any save destroying issues, but it is better to be safe than sorry! To USE: 1) While in the FHM7 game, Select "Create CSV Export" from the <WORLD> Menu. Save and exit the program 2) Download and unzip FHM7-htmlGEN.vbs from this link: https://drive.google.com/file/d/1cDp...ew?usp=sharing 3) I recommend that you copy your league folder (your_league_folder.lg) located in C:\Users\your_User_Name\Documents\Out of the Park Developments\Franchise Hockey Manager 7\saved_games to a temp directory somewhere on your computer. 4) Place the downloaded script file (FHM7-htmlGEN.vbs) into your league folder directory (the folder with all of the .dat files) that you moved to the temp directory. (For example C:\temp\your_league_folder.lg) To run: 1) Double-click the FHM7-htmlGEN.vbs file. Processing time will depend on the amount of players and leagues in your save. Be patient, the script may take more than a few minutes to complete (Note: My league which consists of three 30-team leagues – Major/Minor/Junior - took about 3 - 4 minutes to run on my 6-year-old-laptop**). The program will notify you of its progress as it runs (reading CSV files, Creating Index files, Creating League Standings files, Creating player html files, Creating team html files, Creating Boxscores) 2) When the script is finished you will be notified by a message box that will say “Done”. Click the “OK” on the message box. To view: The html files will reside in the exports\html directory contained in your league folder. Double-click on the index.html file and from there you can click on the league you wish to view. Index files for skaters and goalies for your top league are also created (skater_index.html and goalie_index.html) in the html directory. If you wish, you can import these index files into a spreadsheet program and create your own league leaders pages. The index file will also contain a link to each player’s html file. For more information about the created box scores, see this thread: https://forums.ootpdevelopments.com/...d.php?t=323839 Here are some screenshots Attached Images

02-20-2021, 08:50 AM	#2
landru22 Major Leagues Join Date: Jul 2010 Posts: 462	Here's another screenshot. Attached Images

05-26-2021, 08:04 AM	#11
bwyant32 Major Leagues Join Date: Dec 2008 Location: Erie, PA Posts: 310	I am seeing the same overflow runtime error on the same line and character. __________________ Commish - Federal Sim League

05-26-2021, 08:15 AM	#12
bwyant32 Major Leagues Join Date: Dec 2008 Location: Erie, PA Posts: 310	I actually did some research on this error: This error is caused by the VB Script function CInt, which gives an overflow error when using a number that is greater than its range. CInt only has a range between the integers -32,768 to 32,767. If a number is passed to this function that is out of the range, this error will be displayed. As a workaround to the limitation of CInt, use the VBScript CLng function which has a range of -2,147,483,648 to 2,147,483,647. This will give a wider data type range to work with. __________________ Commish - Federal Sim League

02-21-2021, 07:59 AM	#3
landru22 Major Leagues Join Date: Jul 2010 Posts: 462	There is an issue that I should mention. It seems the standings don't generate properly in the early part of a season. It will omit teams, I think when there are multiple teams with the same record or something along those lines. I haven't been able to pinpoint the trouble yet, but it seems to straighten itself out when teams have played about 10 or so games. Even if the team is omitted from the standings it will still create a team page for them, there just won't be a link to it on the standings page

02-25-2021, 11:05 PM	#4
shelrik Minors (Single A) Join Date: Feb 2017 Location: Ontario, Canada Posts: 65	Thanks for sharing this with us. As much as I want to use it won't work for me. Sets up the folders to create the html files but does not complete. Get the following.... Line 309 Char 17 Error Overflow "Clint" Code 800A0006 Microsoft VBScript runtime error

02-25-2021, 11:06 PM	#5
shelrik Minors (Single A) Join Date: Feb 2017 Location: Ontario, Canada Posts: 65	Thanks for sharing this with us. As much as I want to use it won't work for me. Sets up the folders to create the html files but does not complete. Get the following.... Line 309 Char 17 Error Overflow "Clint" Code 800A0006 Microsoft VBScript runtime error So it starts to work but hangs. Any help is appreciated. Thanks!

02-26-2021, 10:18 AM	#6
landru22 Major Leagues Join Date: Jul 2010 Posts: 462	Thank you for showing interest in my mod.. What does your league structure look like? Do you have a very large save with a lit of leagues and teams? Or perhaps you have played many many seasons. That line is reading in the league ID of players from the csv file for career stats. The CInt means that I am converting character data to an integer. Perhaps I need to make that line of code a little different. Is there a way to share your league file with me? Perhaps a drop box or a Google drive?

02-26-2021, 10:42 AM	#7
landru22 Major Leagues Join Date: Jul 2010 Posts: 462	If you wish, you can PM me and I'll give you my email address, assuming the file isn't too large for an email attachment

02-26-2021, 07:31 PM	#8
shelrik Minors (Single A) Join Date: Feb 2017 Location: Ontario, Canada Posts: 65	Hello, Thanks for getting back to me. I started a new standard game with the NHL 2020-21 season. It also includes the AHL and Canadian Junior Leagues (3) and no other. I don't have drop box or google drive...sorry... That said I'm going to start a small historical season and see what happens. The whole file (folder) is 1.2g so way to big for email. See what happens and will let you know. Thanks Rick

03-10-2021, 12:01 AM	#9
Schifty Major Leagues Join Date: Jan 2019 Posts: 443	Just wanted to know if this tool export only statistic, mean there is any HTML files exported with attribute of those player ?

06-26-2021, 12:29 PM	#13
karg007 Bat Boy Join Date: Jun 2021 Posts: 4	Any update on this addon? Cause even if we change the CInt to CLng, we still get an error...... :/

06-27-2021, 09:22 AM	#14
landru22 Major Leagues Join Date: Jul 2010 Posts: 462	Sorry. It just won't work as is with the standard NHL setup. If I remember correctly it was due to the fact that league id #'s for the NHL, AHL, and Junior Leagues were not 0, 1, and 2 as they are in a Fictional save. I wrote this script to be used in my Fictional universe and thought it might work for a basic NHL setup as well, so I shared it. Unfortunately, it will take a major recode to get it to work for most of you and I simply don't have the time to do it. If you have any visual basic coding experience, feel free to edit the script to your needs

08-23-2021, 08:13 AM	#15
RangersKoivu Minors (Rookie Ball) Join Date: May 2021 Location: Singapore Posts: 27	Hi, I tried to use this program for my fictional league setup (2 leagues with 4 teams each, first season). However I always get the same error. Line: 565 Char: 5 Error: Subscript out of range: 'z' Code: 800A0009 Source: Microsoft VBScript runtime error This program seems really interesting to use so this error is a bummer for me.

08-24-2021, 10:48 AM	#16
alko Major Leagues Join Date: Aug 2020 Posts: 476	Any update to count also who won the most Stanley Cups? Most Gagarin Cups. Hart Trophies...

09-27-2021, 05:53 PM	#17
sgrondin98 Minors (Double A) Join Date: Mar 2013 Posts: 123	Hi , I have a question about your generator. I think its not working if you create a new team that doesnt exist. I create a custom league with custom name teams and real teams... but if i try to see the stats of teams i cant see the stats player of those teams but i can see the stats in the players stats index..... Could you please explain me why the players stats show in the player index but in the team index they dont have the team stats in the team index..... Example i see the montreal Canadien stats players in the skaters index AND on the team index but if i try to see the players stats of the Seattle kraken the player stats is show on the Skater index but not in the team index and Seattle doesnt appear in the Team index.... Thanx a lot for your answer.

09-27-2021, 09:15 PM	#18
landru22 Major Leagues Join Date: Jul 2010 Posts: 462	I'm sorry. I am no longer working on this project. Hopefully FHM8 will have something like this as part of the release.