Feel free to post your suggestions below
Regarding the player registration system I have been provided with this data from the LFA which originated from Sam
Can I ask how do I identify duplicates on the system for the future in order to ensure that we clean up our data, ensure compliance with the FA and our league requirements as I have also come across players who have been registered to more than one team.
A lot of this I believe was because we only used the WGS Player registrations this season for the first time and as a number of committee members had the ability to authorise players and the sheer volume we had to deal with (from zero to over 8000) meant that some slipped through the net which probably shouldnt have.
Going forward I would like the ability to do a data check to identify issues. Is this possible?
|County Name||League Name||No of Teams In the League||No of Players Registered||No of Registrations||All Players Registered||All Registrations||Offline Consent||Online Consent (Email)||Online Consent (Portal)||No of Adult Players||No of Adult Players with Email||No of Youth Players||No of Youth Players with Email||No of Female Players||No of Female Players with Email||No of Deduplicated FAN Records|
|Lancashire FA||Bolton, Bury & District Football League||572||8064||8246||8248||8633||7450||532||0||1714||607||6292||1751||860||407||97|
Thanks for your post; firstly I'd just let you know the work we are currently doing on duplicates (which is more than ever).
a) We are running an automatic de-duplication process based on Name, DOB and Address
b) The new login page is already drastically reducing the number of duplicate accounts by moving from a unique identifier of a "FAN" to using "Email address" we've already got rid of 1000's of duplicates using this new system
c) You may be aware that The FA is currently undergoing a 5-6 year update of Whole Game System and this includes Player Registration, a large part of this work is around duplicate FAN's and minimising the amount created. At the moment I can't give too many details but can assure work is ongoing from our side.
It's also worth mentioning that when you go to approve players at the start of the season the system will inform you of any potential duplicates based on name and date of birth.
For your issues, the easiest way to do this would be to identify them within excel.
Step One: If you login to WGS and go to Player Registration tab then click "Export Players" (it may take a little while for excel spreadsheet to download due to volume of players, just leave it running)
Step Two: Open the players in excel, click on the "Player Name" column then click "Conditional Formatting"
Step Three: under "conditional formatting" > Highlight Cells Rules > Duplicate Values
Step Four: this will then highlight all duplicate values within your Name column.