London League results service

Links to other sites of interest.
John Upham
Posts: 4093
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: London League results service

Post by John Upham » Tue Sep 11, 2012 2:24 pm

Roger de Coverly wrote:
John Upham wrote: I will roll this out to all League results systems I manage.
How does the link to the ECF membership data work? If it's by grading code, new players will present a problem.
I've taken that into account already so it won't be a problem. :lol:

The good thing about using PHP or Java (for example) is that inquisitive persons cannot render the code in an HTTP client which will help to maintain their curiosity.

Also, it cannot be "borrowed on a permanent basis" by other sites!

Note the clever way in which some members expiry data has been appended into the same string that contains their membership category. Pure class! :D

I will write code to parse out the expiry date and put it where it should have been in the first place. :roll:

User avatar
Greg Breed
Posts: 714
Joined: Thu Apr 05, 2007 8:30 am
Location: Harrow, Middx, UK
Contact:

Re: London League results service

Post by Greg Breed » Fri Sep 14, 2012 6:21 pm

Slight problem here:
Anthony Fulton: Willesden & Brent .
Fulton Fulton: Willesden & Brent

I know he's a top bloke but Tony can't be allowed to be called Fulton Fulton.
I'd have a hard time not taking the piss in the pub after a match! (not to be confused with "taking a piss", which also occurs in the pub after the match!)
Hatch End A Captain (Hillingdon League)
Harrow Captain (Middlesex League)

Roger de Coverly
Posts: 16816
Joined: Tue Apr 15, 2008 2:51 pm

Re: London League results service

Post by Roger de Coverly » Fri Sep 14, 2012 6:32 pm

Greg Breed wrote:Slight problem here:
Anthony Fulton: Willesden & Brent .
Fulton Fulton: Willesden & Brent
ECF data is the issue. He had a Gold membership expiring 6/9/12 and took out (or someone on his behalf) a Bronze membership to expire 31/8/13. The Bronze membership is in the name of Fulton Fulton

John Upham
Posts: 4093
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: London League results service

Post by John Upham » Fri Sep 14, 2012 6:38 pm

Greg Breed wrote:Slight problem here:
Anthony Fulton: Willesden & Brent .
Fulton Fulton: Willesden & Brent

I know he's a top bloke but Tony can't be allowed to be called Fulton Fulton.
I'd have a hard time not taking the piss in the pub after a match! (not to be confused with "taking a piss", which also occurs in the pub after the match!)
Greg,

This is a consequence of the data being received. I believe the path is:

.csv export created by PaySubsOnline from unknown source
imported into Microsoft Excel
exported in .xls format
uploaded to ECF server
downloaded by Yours Truly (well, a PHP script does it once a day ideally)
Opened in Microsoft Excel
strange left space padding removed
date format converted to YYYY-mm-dd
exported to .csv format
imported into MySQL


It is that easy!

So, we have a clear example of GIGO in some cases.

John Upham
Posts: 4093
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: London League results service

Post by John Upham » Wed Aug 28, 2013 1:20 pm

Fixtures for the London Chess League for the 2013 - 2014 season are on-line at

here :D

with one important warning: the venue information is currently misleading. :(

I am working with Brian and Vic to correct this.

This was my fault as I did not request that this column be updated in the spreadsheet sent to me by Vic: apologies. :oops:

We ought to fix this over the next 24 hours. :D

John Upham
Posts: 4093
Joined: Wed Apr 04, 2007 10:29 am
Location: Cove, Hampshire, England.
Contact:

Re: London League results service

Post by John Upham » Wed Aug 28, 2013 3:05 pm

The venue errors have been corrected and R&Ts fixtures demerged from Pimlico's !

Please let me know if you spot any further errors.

J.

Richard Thursby
Posts: 165
Joined: Wed Feb 25, 2009 11:25 am

Re: London League results service

Post by Richard Thursby » Sun Sep 08, 2013 2:25 pm

Not to do with fixtures, but the "Local Events" page includes one for 26 September 2013 that shouldn't be there.

Post Reply