FHM2Reports - OOTP-Style Web Reports

breich90 · 10-04-2015, 10:01 PM

Hey everyone,

Thought I would announce FHM2Reports, an online league web report backbone. I've got the bases of the web module covered, including the django-backed database setup and ready to go.

Feature List (to be released as I develop):
Team Page (w/ team stats, player roster)
Player Pages (w/ ratings, stats)
Team Schedule
League Schedule Grid
Draft Module (w/ log-in and draft results output)

My intent is to get player pages followed by team pages live as the first release. I will begin work on the draft module after I create the basic reports framework.

There's a plethora of other features I could (and intend) to add-on to this project, but I'm going to keep it simple to start. Feel free to chalk up any other modules/reports/etc. you'd like to see in subsequent releases and I'll throw them up on a proposed feature list.

Attached is my hello world: displaying the LW rating for player 1. Yes, there's absolutely zero formatting, but from a programming perspective, formatting/UI is much easier than getting the LW rating to display =)

Brett

Rizzo · 10-04-2015, 10:02 PM

As a prospective programmer I'll be very interested to see how your project develops. Good luck!

checkyoursixx · 10-04-2015, 10:46 PM

This would be very useful for any online league!

I definately look forward to this! Good luck!

breich90 · 10-05-2015, 05:25 PM

Quote:

Originally Posted by Rizzo

As a prospective programmer I'll be very interested to see how your project develops. Good luck!

Quote:

Originally Posted by checkyoursixx

This would be very useful for any online league!

I definately look forward to this! Good luck!

Thanks for the support guys.

I'm just about finished with my player page template (skaters only so far). I'll be rolling that out tonight for my online league, will post link/pictures.

If there's anybody interested in the project that has a good understanding of CSS styling and would like to help work on the CSS-side of the project, please PM me. My CSS is stuck in 2007 so the styling will be basic/not sexy for a while.

breich90 · 10-05-2015, 09:26 PM

Update: Basic player page created. Still need to work through CSS (obviously), along with what ratings to display. I'm not sure that all the ratings dumped from the CSV match what's in the game--I actually haven't even played the game yet, other than to create the initial league file for our online league, and to run a couple test sims for the purposes of testing this project.

checkyoursixx · 10-05-2015, 09:52 PM

Quote:

Originally Posted by breich90

Update: Basic player page created. Still need to work through CSS (obviously), along with what ratings to display. I'm not sure that all the ratings dumped from the CSV match what's in the game--I actually haven't even played the game yet, other than to create the initial league file for our online league, and to run a couple test sims for the purposes of testing this project.

This is pretty cool. I was hoping we would see something like this as html is kind of a big deal to me.

I wish I could help in some way, but I am not qualified.

Would this integrate with a league that has already started?

breich90 · 10-05-2015, 10:35 PM

Quote:

Originally Posted by checkyoursixx

This is pretty cool. I was hoping we would see something like this as html is kind of a big deal to me.

I wish I could help in some way, but I am not qualified.

Would this integrate with a league that has already started?

So long as you can click the 'generate csv' in the manage online league menu (the one where you create/download team files) then yes. As of right now, the CSV doesn't generate a table of historical stats, so the player stats would only be from that season and forward. Once I get the base league/team/player pages set, I'll be creating my own historical stats module until they get around to generating more tables from the game's database.

Mike Lowe · 10-09-2015, 10:52 AM

Very excited for this project! Subscribing!

tward13 · 10-12-2015, 08:42 AM

How is this project going? There are some leagues starting up than might be able to make use of web reports.

Appreciate the efforts!

landru22 · 10-12-2015, 09:51 AM

I am very interested in this project. Was wondering if I take the csv the game creates and add to it previous stats from previous seasons, would your utility still be able to create the html pages?

spear · 10-12-2015, 06:31 PM

Definitely interested to learn more!

Breich · 10-13-2015, 03:58 PM

Oddly enough my original account lost it's posting permissions (and there's a support ticket that's been pending another response for a few days now). Here's where I'm at thus far: a little bit of styling.

CodePen - Crisp table

Breich · 10-13-2015, 04:01 PM

Quote:

Originally Posted by Mike Lowe

Very excited for this project! Subscribing!

Thanks!

Quote:

Originally Posted by tward13

How is this project going? There are some leagues starting up than might be able to make use of web reports.

Appreciate the efforts!

I've only got the basic team and league pages to create, and I'll probably make a rudimentary player search function for the first release. I've got to make a script to convert some data that's dumped, however, because the current format of the CSV dumps is bugged.

Quote:

Originally Posted by landru22

I am very interested in this project. Was wondering if I take the csv the game creates and add to it previous stats from previous seasons, would your utility still be able to create the html pages?

The endstate of the utility would be to save the yearly stats as they're updated. If you have previous years' CSV dumps of the stats table, then we could get that inserted into the table, I'd just have to figure out a way to make it user friendly and automated. i.e. the process is easy, but not if you don't know jack about MySQL. =)

Quote:

Originally Posted by spear

Definitely interested to learn more!

Thanks!

Breich · 10-13-2015, 04:03 PM

Not sure why it didn't post, but here's a link to the styling sheet I've been working on for most parts of the page (only the player page portion is shown).

CodePen - Crisp table

Also, my original account doesn't have posting privileges anymore, and I haven't a clue as to why. I've been back and forth on a support ticket for a few days, and nobody seems to understand what the problem is.

Rizzo · 10-13-2015, 10:36 PM

That's a very clean looking page. Love it!

Germaniac · 10-14-2015, 05:08 AM

Looks great !!

spear · 10-28-2015, 07:54 PM

How's this coming along? Would we be able to use a no frills version of this? The last update with the styling looked great!

Forward · 11-01-2015, 04:00 AM

Great project, but i'm just curious....how can you read those dat files....

I'm a programmer and i just wonder how people outside the development team ca 'easily' read their database data and create in-game editors or something like you do.

Lovely project, but if you can tell me how for curiosity i'll be glad :P

Breich · 11-01-2015, 08:56 PM

Quote:

Originally Posted by Forward

Great project, but i'm just curious....how can you read those dat files....

I'm a programmer and i just wonder how people outside the development team ca 'easily' read their database data and create in-game editors or something like you do.

Lovely project, but if you can tell me how for curiosity i'll be glad :P

The csv dumps that are generated are merely tables from the internal database tables (or at least, a subset of what the developers want us to see). Reverse-engineering the schema of the database is pretty easy to do, and from there, mods like my own simply produce different views that manipulate the same core set of data--player ratings, player biographical information, team data, etc.

Forward · 11-02-2015, 08:55 AM

You mean reverse-engineer to the exported csv files right?
Yeah i didn't remember to see the option to export csv data and what it do. :X

10-04-2015, 10:01 PM	#1
breich90 Minors (Double A) Join Date: Mar 2007 Posts: 109	FHM2Reports - OOTP-Style Web Reports Hey everyone, Thought I would announce FHM2Reports, an online league web report backbone. I've got the bases of the web module covered, including the django-backed database setup and ready to go. Feature List (to be released as I develop): Team Page (w/ team stats, player roster) Player Pages (w/ ratings, stats) Team Schedule League Schedule Grid Draft Module (w/ log-in and draft results output) My intent is to get player pages followed by team pages live as the first release. I will begin work on the draft module after I create the basic reports framework. There's a plethora of other features I could (and intend) to add-on to this project, but I'm going to keep it simple to start. Feel free to chalk up any other modules/reports/etc. you'd like to see in subsequent releases and I'll throw them up on a proposed feature list. Attached is my hello world: displaying the LW rating for player 1. Yes, there's absolutely zero formatting, but from a programming perspective, formatting/UI is much easier than getting the LW rating to display =) Brett Attached Images

10-05-2015, 09:26 PM	#5
breich90 Minors (Double A) Join Date: Mar 2007 Posts: 109	Update: Basic player page created. Still need to work through CSS (obviously), along with what ratings to display. I'm not sure that all the ratings dumped from the CSV match what's in the game--I actually haven't even played the game yet, other than to create the initial league file for our online league, and to run a couple test sims for the purposes of testing this project. Attached Images

10-09-2015, 10:52 AM	#8
Mike Lowe Hall Of Famer Join Date: Dec 2001 Location: San Diego, CA Posts: 2,163	Very excited for this project! Subscribing! __________________ Franchise. Sliders. @MikeLowe47 \| YouTube \| Discord

10-13-2015, 04:03 PM	#14
Breich Minors (Rookie Ball) Join Date: Oct 2015 Posts: 29	Not sure why it didn't post, but here's a link to the styling sheet I've been working on for most parts of the page (only the player page portion is shown). CodePen - Crisp table Also, my original account doesn't have posting privileges anymore, and I haven't a clue as to why. I've been back and forth on a support ticket for a few days, and nobody seems to understand what the problem is. Last edited by Breich; 10-13-2015 at 04:05 PM.

10-14-2015, 05:08 AM	#16
Germaniac Hall Of Famer Join Date: Apr 2011 Location: Frankenthal, Germany Posts: 3,054	Looks great !! __________________ I'm going to have to meet my Maker some day. And if He asks me why I didn't let this boy play, and I say it's because he's black, that might not be a satisfactory answer. Happy Chandler, 1947

10-04-2015, 10:02 PM	#2
Rizzo Minors (Triple A) Join Date: Feb 2008 Posts: 254	As a prospective programmer I'll be very interested to see how your project develops. Good luck!

10-04-2015, 10:46 PM	#3
checkyoursixx Minors (Triple A) Join Date: Jun 2009 Location: Toronto, Ontario Posts: 282	This would be very useful for any online league! I definately look forward to this! Good luck!

10-12-2015, 08:42 AM	#9
tward13 All Star Starter Join Date: Jan 2003 Posts: 1,964	How is this project going? There are some leagues starting up than might be able to make use of web reports. Appreciate the efforts!

10-12-2015, 09:51 AM	#10
landru22 Major Leagues Join Date: Jul 2010 Posts: 461	I am very interested in this project. Was wondering if I take the csv the game creates and add to it previous stats from previous seasons, would your utility still be able to create the html pages?

10-12-2015, 06:31 PM	#11
spear Minors (Rookie Ball) Join Date: May 2009 Location: Toronto, ON Posts: 47	Definitely interested to learn more!

10-13-2015, 03:58 PM	#12
Breich Minors (Rookie Ball) Join Date: Oct 2015 Posts: 29	Oddly enough my original account lost it's posting permissions (and there's a support ticket that's been pending another response for a few days now). Here's where I'm at thus far: a little bit of styling. CodePen - Crisp table

10-13-2015, 10:36 PM	#15
Rizzo Minors (Triple A) Join Date: Feb 2008 Posts: 254	That's a very clean looking page. Love it!

10-28-2015, 07:54 PM	#17
spear Minors (Rookie Ball) Join Date: May 2009 Location: Toronto, ON Posts: 47	How's this coming along? Would we be able to use a no frills version of this? The last update with the styling looked great!

11-01-2015, 04:00 AM	#18
Forward Bat Boy Join Date: Jan 2013 Posts: 3	Great project, but i'm just curious....how can you read those dat files.... I'm a programmer and i just wonder how people outside the development team ca 'easily' read their database data and create in-game editors or something like you do. Lovely project, but if you can tell me how for curiosity i'll be glad :P

11-02-2015, 08:55 AM	#20
Forward Bat Boy Join Date: Jan 2013 Posts: 3	You mean reverse-engineer to the exported csv files right? Yeah i didn't remember to see the option to export csv data and what it do. :X