HR Log Generator - Test Version

[LeafsFan2005NC]

EDIT: I've fixed a few other problems and found a host so now you can download the program and any updates from here:

http://leafsfan2005nc.cabspace.com/H...og/publish.htm

Well, folks, I can't think of anything else to cram into the program at the moment, though I do have some ideas still. So I figured I'd give y'all something to play with and give me some feedback on.

I had to upload the file to a website (since it's well over the 100k limit of here) and you will need the .NET Framework to use it (for which I humbly apologize, but blame MS.)

Remember, you must do a CSV dump at the end of your season for this to work properly. Since some of you most likely play Winter Leagues or such that span different years, I suggest doing a dump after the postseason, though the end of the year will work as well.

Once you open the program, you'll first want to update the database for your particular league. To do this simply choose Update Database and a dialog will appear starting at the default OOTP directory (for reasons of testing, if you installed the game elsewhere, let me know and I'll see about getting the program to search out the directory). Just select your leagues save directory, then the news\html\box_scores directory. Then just click Save (yes, it says Save, but I'm going to fix that somehow, lol) and you'll be returned to the main screen. There you'll choose your league using the drop down box. Even if your league has one league, you'll still need to choose it from the box. After a brief moment where the game gathers the necessary information on the league (# of regular season gams, teams, ballparks, etc.) the Update button will become active. Just press it and the program will begin to update your HR database (depending on your speed, this may take awhile). Once this is complete, the program will alert you and then the Reports button will become active (while at the same time disabling the Update button and league drop down box, but these can be reactivated by repeating the steps to update the database. Granted this could be a pain and can be improved upon which is why I'm seeking input).

Click this and the reports screen will come up. Here you will have ways of generating logs on players and teams, as well as generating webpages for these. At the moment there is only a Generate All function for players. This hasn't been fully tested, but it's safe to say it will take time depending on the size and # of players in your league. The upside is it will not generate pages for players that have no home runs, thus saving space. All reports will be saved to the import_export directory of your league directory (though this may be changed later to create a separate directory).

The team portion of the reports page works similarly to the player portion, allowing you to generate reports and pages for teams by year (ie: 2005 Los Angeles Dodgers), but not for an entire teams history. Franchise reports are something I hope to add later (hence the reason the Franchise portion is completely disabled). Franchise reports won't include one master log (that would be huge!), but links to each year the team played, regardless of the city they played in.

It should be noted here that generating a team report does take time, at least in my initial testing. This greatly depends on the size of your league and the # of players that you've had over the history of your league. Hopefully this is something that can be fixed speed wise.

One last note. If you've already updated your database and then decide to come back later to generate a report, all you have to do is click Open Database on the main window and a dialog will come up letting you do so. This one's more straight forward since it'll open up where the database is already located.

And, in closing, the file is hosted on GeoCities so it may go down no thanks to their not allowing lots of data transfer. If it does, I apologize in advance and will try and find somewhere else to upload this to. Please be aware, though, that this isn't 100% complete and I'm really looking for people to test it for me. There are things that will be added later, such as determining if a game is part of a doubleheader or not, as well as the aformentioned Franchise report portion.

As always, if you have any questions, just post them here. Thanks.

[LeafsFan2005NC]

Updated with ability to generate franchise home run totals. The only thing missing is HRs vs. LH or RH on the franchise pages, but getting those numbers was taking a ridiculously long time due to continuously parsing the players.csv file. This may eventually be fixed. Anyway, enjoy for now.

LeafsFan

[LeafsFan2005NC]

A new version is out. This one fixes a problem where if your league has spring training and then the season ends with a one game playoff for a league or division winner, then the program was putting spring training homers into the database (since OOTP uses a number after the last spring training game for the playoff boxscore). I've also fixed a problem where the final boxscore of the season wasn't even being looked at.

I've also added the ability to generate L/R splits on the franchise totals pages. This has meant a rewrite of some code, meaning old HR databases are now obsolete. Now throwing information for pitchers is incorporated into the database itself instead of being determined when generating a report. This has sped the program up some as well.

I've still yet to get the program to determine if a game is part of a doubleheader, but am working towards a solution for that and hope to add more reports such as homers hit in different stadiums and how lists of pitchers victimized by a team.

EDIT: Fixed a problem with multiple home runs (by team or player) not importing correctly.

[LeafsFan2005NC]

Version 0.1.2.0

Nothing new with this version, just added backwards compatibility for when OOTP 2006 1.0.3 is released. Since they're changing the field divider in the CSV dumps from a semi-colon to a comma, this update will ensure that no matter what version you have, everything will still work properly.

[endgame]

In your link in Post #1, clicking on the Install option generates the html rather than executing the application.

[LeafsFan2005NC]

That's quite odd. I'm thinking it has something to do with the semi-crappy host I chose. Half the time I try to go to the home page I set up and it won't go. But it's just so dang hard to find a free host with a reasonable transfer that will let you upload executables and such.

I just tried it (2:00pm ET) and it installed for me. You may have to try pressing "Install" again to see if it works.

[Kyros]

Originally Posted by endgame

In your link in Post #1, clicking on the Install option generates the html rather than executing the application.

I get the same thing. Is this located anywhere else to download it from?

[LeafsFan2005NC]

I've made a return to the HR Log Generator after a lengthy absence from working on it and am finally turning it into a real database. The hope is to make it faster, at least when it generates a report (since it was taking forever the old text based way), but it will still be slow as it parses boxscores.

Nothing to offer now, but I'll keep working on it and hopefully have something in time for OOTP 2007.

[LeafsFan2005NC]

Things are looking awesome. I've figured how to add links to pages generated by the game and players and teams have separate log directories now.

What I plan next to do is, when you have a league uploaded on a website, you can generate a page under accomplishments that lists every grandslam ever hit in your league.

And I'll eventually get around to creating a routine to list a pitchers home runs given up.

I just love this program.