RE: [hockeydisk] Data Base
- I would love to share my Access data with others..anything to make life easier. Contact me off list and I will send what you wantEd-----Original Message-----othl@... wrote:
From: D. Atkinson [mailto:bigdog@...]
Sent: Friday, January 04, 2002 9:11 AM
Subject: Re: [hockeydisk] Data BaseI do all my reporting out of Access, too. These days the entire Access database sits on my web site and all of the web reports are generated dynamically from the database. If the game files weren't so freaking big I'd do the same with box scores.
I agree that APBA's report package is pretty bad, but there's only been one sports game that did include a report package that came close to meeting my needs (Pursue the Pennant Baseball, now called Diamond Mind I think). The only way I'd be happy is if they had a built-in report writer and you won't see that without doubling (at least) the cost of the game. Remember, at its peak APBA was only selling for about $25, and that included the season disk that cost $20 by itself!
Also have to keep in mind that the game was obviously (and inexplicably) not designed with leagues in mind. It seems it was designed for the APBA geek who will spend four years replaying a season, game by game, so he can write a summary of his years of work in the APBA Journal. (Not intended as a swipe at those who actually do that sort of thing - I actually was such a geek once only I used a freaking board game!) Career mode was the furthest thing from their minds I'm sure.
So, like Dave said, I'd rather see development time spent on making the game engine better. I prefer to have complete control over what goes on my league's web site.
Spreadsheets and databases make it much easier to handle league history databases. Andrew had a good point in his post: "If a certain app (hockey sim) has an installed base that uses a specific function, and you know about it, you should put it in and not expect them to buy a $200 app to do it." You can't ignore putting some database type functions in a sim. There are those that would scream (rightfully so) if they had to pay extra money for a database if they didn't already own one, and needed one just to handle the stats from a game. Granted, there are free database programs available on the net, but, one could argue that a sim should include one in case the buyer is totally unaware/unwilling to use external programs. But, with that said, I can't see any sports sim coming even close to including the stats handling power of a database like Access. If a sim company tries, they definitely are wasting resources that could be used to enhance the game engine (the usual weakness) or other more important features. So, what a top notch sim really should do is provide a decent basic framework of stats databasing (stats sorting, leaders, etc.), without spending too much resources that detracts from the rest of the game quality. Then, it should also add a customizable export feature (you pick what you want exported) so that those that take advantage of the power of external database programs can have what they need. Since so many of us use Access, perhaps we should start sharing queries and reports in this forum. I have started writing Access report macros to output html files exactly how I want them. I haven't gotten real far yet, but I hope to use this approach to replace some of the utilities that I have written to handle stats output for a web page.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
- Ed Hebscher wrote:
I would love to share my Access data with others..anything to make life easier. Contact me off list and I will send what you wantEd
There is a file upload section of this yahoogroups thing where we can put files
for others. One thing I do recommend is that people post query or report files, or
maybe example database files with 3 or 4 players records as an example. DON'T
post an entire league database with hundreds or thousands of player records. It's
alot of wasted space and bandwidth.