matchDetails.asp is now in XML format

[Alf]

So hopefully FrogMan will soon be out of a job for the FOFC ratings as Mr Wednesday is working on an automatic ratings builder :D


Once logged you can see it Alf Trickers - Rolling Dolmens (http://195.149.159.156/common/matchDetails.asp?outputType=XML&actionType=view&matchID=10755088)

[FrogMan]

oh, how this would make my day, my week, my month, my year!!!

I don't want to see the ratings die, but they're really becoming a drag, even though many, many people have helped out in the last few weeks. Having deadlines for things that are supposed to be just for fun, well it sometimes make it less fun...

FM

[Poli]

I'm sure having to go back and correct things after a couple of days isn't so fun, either. I do recall that you started this as a "once a week" thing.

[Mr. Wednesday]

I switched over from HTML to XML last night.

I just need to get the output stage working. It's usable for me now as is because I can just hook into the backend using Access, but I really need to get something that will do a tab-delimited data dump from the program itself.

[FrogMan]

I'm not completely computer illiterate, but here, it went like blah...blah... usable ... blah ... Access ... blah ... tab-delimited... :D

Let me know if you need some sort of info from me. I'm really not liking the new match report if I'm gonna keep on doing the copy/paste stuff. These extra lines (sometimes 1, someties 2) right between the team name and the beginning of the ratings are gonna screw me up...

FM

[finkenst]

For Frogman...

If it's not Excel ...

[finkenst]

dola,

we're DOOMED.

[Mr. Wednesday]

More todo stuff that I thought of...
At the moment, my max NSI data is by date, not by season/week. I need to set up a good calculation routine for that.

Oh, one other thing I forgot, I currently have no interface for marking off private cup games, which would be necessary to use FOFC Cup NSIs in the ratings.

[Mr. Wednesday]

dola, here's the situation. My way of working has been to store the ratings in a database (used to be Access), calculate them there, then query the database to produce a raw table. I then copy that into Excel (copying from Access produces nicely delimited data), and on a companion sheet the raw data gets prettied up.

So, what I'm doing in the program right now is producing something to generate that data table and copy it to the clipboard so that it can be pasted into Excel.

If this doesn't look like how you'd want to use it, or if you've got some really particular opinions about what data you want, let me know. Right now, the output is going to look rather like the information that shows up in the FOFC ratings (without the formatting), because I liked it so much I used it for my own.

[FrogMan]

Originally posted by Mr. Wednesday
dola, here's the situation. My way of working has been to store the ratings in a database (used to be Access), calculate them there, then query the database to produce a raw table. I then copy that into Excel (copying from Access produces nicely delimited data), and on a companion sheet the raw data gets prettied up.

So, what I'm doing in the program right now is producing something to generate that data table and copy it to the clipboard so that it can be pasted into Excel.

If this doesn't look like how you'd want to use it, or if you've got some really particular opinions about what data you want, let me know. Right now, the output is going to look rather like the information that shows up in the FOFC ratings (without the formatting), because I liked it so much I used it for my own.

Can your app simply get all the ratings for the week, without the calculation? I mean the straight NSI, and dump it in a comma-separated file that would look like this for the current week:

team1,67
team2,56
team3,33

If it can do this, it would alrady be amazing for me to get the ratings. I could copy this comma-separated file into a tab and do a simple vlookup from it to import it in my excel sheet and the format would simply follow...

FM

[FrogMan]

Originally posted by Mr. Wednesday
Oh, one other thing I forgot, I currently have no interface for marking off private cup games, which would be necessary to use FOFC Cup NSIs in the ratings.

I DO NOT CARE ABOUT FOFC CUP RATINGS!!! :)

This was never part of the ratings at first. My question is can you get National Cup ratings?

What I used to do was use only league match ratings, then I decided to add the National Cup ratings and now people have taken it for granted that I do it for FOFC cup matches too. I do it, if somebody is still in the National Cup. As it is, this week will be the last one where I update the rankings, until next season, since I think pretty much everybody is out of the National Cups, and if not, I don't anybody still in the National Cup has posted their ratings in the thread, denoting not enough interest for me to update the rankings...

FM

[Mr. Wednesday]

Hey, if you don't care about FOFC cup ratings, that's no problem at all. I've generated the form, but I'll worry about coding it in later.


I can add a menu item to dump comma-delimited match ratings to the clipboard. Do you want teamid or teamname on the left of the comma?

[FrogMan]

team name, would work, but I'm thinking that team id is probably better, since if a team ever changes team name, its id is stil the single identifier...

Team ID it is :)

FM

[Mr. Wednesday]

Great, that's easier anyway!

[FrogMan]

yeah, I sort of thought so too. Always easier to work with a number than with a long name, with many chances for mistyping errors and such...

FM

[Mr. Wednesday]

Packaging is going to be trickier than I expected. The program is straightforward enough, but the database that I'm using to store the data could be a bit of a pain to get installed and configured.