Start a new topic

Enhancements

Feel free to post your suggestions below


2 people have this question

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

Hi Warren,


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.



1 person likes this
Login or Signup to post a comment