The charitable Club of which I'm the unpaid voluntary secretary, runs a "Fantasy" horse racing competition based on a "12 to follow" principle.
Members contact details and their list of 12 horses are currently stored on an access database, which generates various reports.
However we now want to populate a new website with some of this data and most importantly of all to extract results information from a csv file generated daily and allocate scores to each members horse on a LSP basis.
In other words we have the data for the 220 +/- members in mdb format and their list of twelve horses. We also have the results for each of those horses - we "just" need to get all this information into a correctly formatted, attractive website.
Further information will be supplied via PPH to interested parties only, who should have a knowledge of horseracing.
The current website is at [url removed, login to view] which is run by the horseracing portal and odds comparison website Gg.com.
You can log into the site as and “password”.
The Twelve Club (as a charitable club) paid GG no fees and they used us as a test-bed for their own “Fantasy Software” which was linked to their own results and entry database.
This allowed members to get notifications of when their horse selections were running as well as keeping the score and allowed for the creation of League Tables and so on.
This relationship has worked well for three years, but their own software is now in need of serious maintenance (you’ll see how slow it is) and I suspect has always suffered from serious cache issues.
In addition the results feed they take from the Press Association has become notoriously unreliable and I’m told that PA now employ three people full time to check results both current and retrospective.
So as a result GG no longer want or need us and are instead concentrating on building Tote systems for various racing authorities.
WHAT WE HAVE IN TERMS OF DATA
• Currently we have an Access Database (a sample is in Dropbox to which I will send you an invite) which generates various reports via various queries.
o Please play with this and for example enter yourself as a Member (ensuring you are “current”) and give yourself a list of horses. If you then click on Horses (left hand side) you will generate under allocated horses, three files, 2 PDFs which produce members lists in an A5 formatted booklet format which goes straight to the printer AND an Excel list of Members unique competition ID (comprising for example M=Male plus sequential numbering based on Surname); their Names and their list of twelve horses.
• Each year we run two competitions – one for the Flat and one for National Hunt (jump) racing.
o The Flat competition runs from x March to x November
o and the National hunt competition runs from x November or December to March the following year.
• Each one of the 100 or so Male Members and 90 or so Female Members picks a list of 12 horses for the current competition which will run between the two chosen dates.
• Every time a horse runs in a race it wither wins or it does not.
o If it wins it gets a score based on the price (starting price) a bookmaker would have paid expressed in either fractions or decimals (thus 5/1 or 5.0 – 15/2 or 7.5)
o If it loses its score is -1
The issue therefore is: How do we transfer and extrapolate AUTOMATICALLY and/or EASILY and at least TWICE A YEAR all the members lists of horses to the two different competitions so that we end up with a display similar to those shown on the existing website.
Ok, so now we have on the website two different groups - Gentlemen and Ladies (two Leagues) - competing in the same competition, using the same scoring system extracted from the same results source.
But what is the results source?
Every day or week or month, I am able to generate a set of results that appear in two csv data files (copies in DropBox). The date range is manually decided by me – so would simply be set from date of last update