Stat Archive FAQ

[Dave L]

Hey Jason, Nick and I have been communicating via pm on this topic. He's got a good handle on the situation and knows that I'd be happy to help in any regard...

[Southpaw Slim]

...it took almost two months to figure out how to translate boxscores so they could be entered into a database...

This was from 2 months ago. So far, I've come across different obstacles preventing me from completing what I thought was stable code at the time. Today, for the 8th time or so, I think I've finally gotten past the hurdle. That makes the total problem a thorn in my side for the past four months! I still need to implement some error-catching in order to avoid obvious discrepancies. Things like more H than AB, 2B with no H, HR with no RBI, RBI with no PA are what I'm looking for. But most important to me is making sure Runs Scored match on both the innings sheet and the scoresheets. Then, any discrepancy is brought to Scott's attention during input and he is able to revise the boxscore before sending it to the database for viewing.

For anyone who's interested, I have the code available if someone has the knowledge and wants to give some advice toward efficiency.

[Southpaw Slim]

It has finally happened! DeFStAr is showing the first glimpse of tangible progress. Behold the very first screenshot of DeFStAr, which is now an active and functional page after a mere two days of debugging!



That's right! First things first, I had to get that out of the way. Now, my focus is ever closer to stat input.

[Baseball=Life]

AWESOME

YOU RULE, NICK!

[Pat K]

Nick,
Thanks for all your work on this project.
See you out on the field.

[Southpaw Slim]

Here's another look at how things are shaping up:



I have yet to beautify it (a la boxscores) but it's nearly functional!

BTW: Notice I have my priorities straight. Oakland Park Baseball 4vr!

[retep]

Awsome!

[Southpaw Slim]

Here's the next screenshot. It's not a realistic game, but you get the idea.

[Dave L]

It looks excellent, Nick!

[Southpaw Slim]

Thanks, everyone! I'm very proud with how it's starting to take form.

If you look at the boxscore screenshot, you'll see buttons on the right that say "Add...". Well, I forgot to put the column header for those, but those are there with the intention to add notes for individual players for the game. They would be like you'd see on the scoresheet; web gems are explained, stolen bases are clarified, ITP homers are noted, and more! Otherwise, I may just add one big NOTES field at the bottom and have it -- like we would see in our current boxscores -- listed at the bottom of the page.

My original intention was to have the "Add..." button add a player's name to the roster, but the code required to keep the already-entered values and add a player while refreshing the page was more work than just having Scott add players before the boxscore process.

Also, even though it wasn't shown in the Add Players screenshot, all players on record are listed alphabetically below the form to double-check spelling errors. I have yet to add buttons to edit players' names after they are entered, but it would only take 10-30 minutes to do that.

This whole process has gotten me really excited. It looks like we'll have some stats to digest by the end of the year, which will keep us occupied during the MLB off-season. ALL HAIL DEFSTAR!

[Baseball=Life]

Need DeFStAr !

[Baseball=Life]

Need DeFStAr !

[retep]

Need DeFStAr !

Spamming bastard

[retep]

Don't be a jerk.

[Southpaw Slim]

Well, I know you've heard a lot of promises from me, and I haven't been able to deliver any of them so far. This time I'm not going to promise any deadline or release date (although I think it might be ready for the Fall season.) This post is to let you all know that the one monkey wrench, the crux of my frustraton throughout the entire project, the final puzzle, etc. is no longer.

I've figured it out! This is like the E=mc² of DeFStAr having been discovered! I have inning-specific output from the form, so my recent concerns of having to trash the inning-specific aspect of our statkeeping are gone. Now we can stick to what we have. I'll get working on finalizing the input process later tonight.