epeeme / web Goto Github PK
View Code? Open in Web Editor NEWWeb site that presents results & ranking data from LPJS, Elite Epee, BYC, EYC and other UK youth, cadet & junior fencing competitions.
Home Page: https://epee.me/
Web site that presents results & ranking data from LPJS, Elite Epee, BYC, EYC and other UK youth, cadet & junior fencing competitions.
Home Page: https://epee.me/
Investigate a way of pulling results from the British Fencing page. I recall they are stored in XML or JSON in the source, so it may he possible to run a query on all the data and then parse that for the result needed.
FIE have updated their web site and the old page parser no longer works. This parser needs updating and bringing in line with the other new parsers. Example;
First task is to see if the existing parsing modal with read out the data in the same way. If not, create new class, otherwise use existing cadet class.
U23 - https://fencing.ophardt.online/en/display-ranking/html/eur/u23/m/e/i
Jnr - https://fencing.ophardt.online/en/display-ranking/html/fie/u20/m/e/i?id=37
Snr - https://fencing.ophardt.online/en/display-ranking/html/fie/senior/m/e/i?id=34
Graphs to show year on year average finishing position, number of competitions, active fencers, ...
Create an XML site map that has links to every result and fencer. Should run as a (weekly) cron job in line with Google Search console settings for frequency.
Consider also showing the number of competitions entered.
https://www.amcharts.com/demos/column-and-line-mix/
https://www.amcharts.com/demos/stacked-area/
Pull all the DoB data from the EFC ranking pages on Ophardt;
https://fencing.ophardt.online/en/show-ranking/html/26433
https://fencing.ophardt.online/en/show-ranking/html/26419
Run this script as a cron job to automatically update after the ranking list has been updated.
Start to track down and import data between 2005 & 2010 based on Rodneys archive of what was a selected cadet event. Non selected events should also be found but will need to compile a list somehow of all seasons - possibly from the waybackmachine archives of the EFC site.
Describe in detail the formats that can be imported as standard and those that are not acceptable. To be used to send to anyone that requests results be included from pdf attachments, region web sites, word docs and CSV files / spreadsheets.
Google is identifying some pages as having duplicate content - this may be down to either scripts being blocked by robots.txt (removed) or not having a <link rel="canonical" href="https://example.com/page.php" />
tag in the header. This tag needs adding to at least the fencer, event & result pages.
Long or multiple fencer names force the display on mobile devices to show only the Firstname column.
https://epee.me/event.php?e=173&d=2007
Look at wrap option, concat names or other alternatives.
via Google Analytics
First detected: 30-Oct-2019 08:13:28
Property epee.me is receiving data from redundant hostnames. Some of the redundant hostnames are:
epee.me
Redundant hostnames are counted as separate rows in reports, so hits that are going to the same page on your site from different hostnames will be split into multiple rows. With data split across multiple rows, traffic to specific pages will appear lower than it actually is.
To avoid this problem, consider setting up a 301 redirect from one of your redundant hostnames to the other, or create a search-and-replace filter that strips "www." from hostnames.
Google Tag Assistant Recordings can help you verify that your redirect is set up correctly, or that your filter is working as intended.
Replace with a standard (free) png flag pack preferable using ISO 3166-1 alpha-3 naming or look at a way of using ISO 3166-1 alpha-2 as an alternative.
The solution could be this - https://kfpun.com/flag-css/
Produce a graph that shows the percentage +- for all UK Open entries to indicate whether there is a decline across all comps. Needs expanding. Graph type yo be identified on am charts.
See https://www.facebook.com/groups/630771407062384/permalink/1602366956569486/ for assertions
The following are missing from the FIE site and weren't found on the waybackmachine scrape of the FIE archive.
Championnats d’Europe juniors | Amsterdam(NED) | Start: 03-11-2008 End: 08-11-2008
Championnats d’Europe juniors | Prague(CZE) | Start: 29-10-2007 End: 04-11-2007
Championnats d’Europe juniors | Poznan(POL) | Start: 04-11-2006 End: 09-11-2006
Make it easier to find club fencers with a dropdown for all clubs that loads the club page directly, rather than having to navigate via the results pages.
Create a simple interface that speeds up the process of merging duplicate fencer records.
/tools
include secure pass key
Recreate the club pages and link appropriately from all other pages. New format to be implemented that expands on what was offered on the old site.
Review the need for contact data - maybe just social links?
https://www.engarde-service.com/files/hunfencing/2019_11_22-24_pbt/
Define the age groups as per - https://www.olimpici.hu/?page_id=5
Highland Open
Alice Ruggles 2018
Cambs Open Air
Norfolk
African Championships
After producing this spreadsheet - https://docs.google.com/spreadsheets/d/14tOrA82JnrIYgW_rXpnY2pF3Ht04A39rAZrRsqB31ZA/edit?usp=sharing - I feel it would be useful to have this data for all seasons
Complete the ranking page for The Youth Series of events and add link to the home page.
Table of EFC cadet events each broken down by place finish (1st, 2nd, 3rd, L8, L16, etc) and total average finishing position at country level. Experiment with heat map to see if that improves visualisation. Also, find old code that sort of produced this data but at a much higher level.
In essence, recreate what Rodney does ... including BRC events and nominated EFC/JWC events. As the mechanism for ranking changes almost every year, a considerable amount of flexibility needs to be built into this to allow for future changes to the ranking and selection formula.
Import these results from the PDF docs located http://www.wingerworthfencingclub.co.uk/results.html?fbclid=IwAR2NV9MYFtOva4KRp0KjGE1G8FoxZoJUSI0vyvl6x5AkfGWx9tXvYMmzTU0
Was 2020 GBRs best ever?
SELECT Year, results.dateID, CAST(AVG(entries) AS Integer) AS entries, CAST(AVG(eventPosition) AS Integer) AS position, AVG((100 / entries) * eventPosition) AS averagePosition, SUM(CASE WHEN eventPosition = 1 THEN 1 ELSE 0 END) AS first, SUM(CASE WHEN eventPosition = 2 THEN 1 ELSE 0 END) AS second, SUM(CASE WHEN eventPosition = 3 THEN 1 ELSE 0 END) AS third, SUM(CASE WHEN eventPosition > 3 AND eventPosition < 9 THEN 1 ELSE 0 END) AS last8, SUM(CASE WHEN eventPosition > 8 AND eventPosition < 17 THEN 1 ELSE 0 END) AS last16, SUM(CASE WHEN eventPosition > 16 AND eventPosition < 33 THEN 1 ELSE 0 END) AS last32, SUM(CASE WHEN eventPosition > 32 AND eventPosition < 65 THEN 1 ELSE 0 END) AS last64, SUM(CASE WHEN eventPosition > 64 AND eventPosition < 129 THEN 1 ELSE 0 END) AS last128 FROM results INNER JOIN eventData ON eventData.eventID = results.eventID AND results.dateID = eventData.dateID AND eventData.catID = results.eventCat INNER JOIN eventDates ON eventDates.eventID = eventData.eventID AND eventDates.ID = results.dateID WHERE results.eventID = 199 AND results.fencerClubID = 415 AND results.eventCat = 21 GROUP BY Year ORDER BY
averagePosition ASC
Warwick Age Group Epee
Beds, Bucks .... County
Hertfordshire County Youth
......
Create a table that shows a season breakdown of (GBR) cadet performances in EFC U17 events expressed as an average finishing position.
Each table cell will need to be heat mapped for an easy visualisation. Heat Map code;
https://github.com/DLarsen/jquery-hottie
Code example for percentages can be found at https://epee.me/cadet.php
Create various sized logo assets for use on all social media platforms.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.