Quote:
Originally Posted by Vae  I've had thoughts, and a couple of conversations, with our clubs webmaster (Lewney on here who made Archery Organiser) about building a database system (presumably SQL based) into our website. I think this could provide a good way to enter classification changes (if it can read the new data in from an excel file) and be able to look up classifications and handicaps from data files when a score is entered. Also the data export should be a lot better using an SQL based system as I guess you can design the reports to extract whatever info you want from the database in whatever format you want. |
It's not the programming that hampers the task it's the complexity.
Until you run up against it you forget the possibility of (as examples):
second sessions which count for records but not classification or handicaps;
the fact you have to complete all four distances to get distance records;
the need to link the two single rounds to a double round;
you need to know which h2h the match rounds are to work out finals totals records.
In fact issues like this come up constantly and as a result the amount of data you have to enter for just one round can be high (there's over 20 fields) and to be able to do field would mean I'd need to know a lot more.
For displaying tourny reports I've still not got around 9s in FITA rounds perfectly, or when juniors compete as adults, or when the results are based on results over two days but is not a double round.
On your specific points:
I can scroll through the rounds but I actually found you need to use two linked scrolling menus to do this (see what happens if you don't by looking a hants archery asso records, as scrolling through 120 rounds is not fun).
My database will do classifications as it has a table (or now two) to store those and it knows the type of comp the round is shot at for MB and GMB. I still have issues around it working class though as I'm often not sure of an archers age and I've not sorted it for a change in age group properly. Handicaps are another issue as you say.
It is easy enough to get things to export.
However, the main thing is it is a work in progress as sadly for many aspects there's as yet no web interface (ie I'm still using SQL direct)...