Admin>Day to Day>Members>Members Database
This section allows the site administrator to manage the membership of the site. Using the options in the sub-menu, he can add and remove members, and assign them roles within the site, create ‘groups’ of members and use the system to contact them by email.
He can, if he already has a database of members, upload that to the site to get everyone on the site in one go, and similarly download the site members to his own computer to use in other programs.
The upload is intended as a quick method for site administrators to get their member database online at site start-up, or to add a substantial number of new members. It only adds records - it does not replace, amend or delete. The download feature is in a different format to the upload, and is intended to allow administrators to extract the data in their member database for use in other applications; it cannot be used in the ‘reverse’ manner as an upload file. If you wish to make amendments, then the simplest and safest way is to do it via the functionality provided online.
Here is the initial view of the Member Database - this will not contain any entries until you perform a search.
The member database allows you to:
- Control which members have access to ‘sensitive’ areas of the site Grant rights to update the site to certain members
- Add and amend information about your members.
Member Database search
The Advanced tab section of the Member Database page allows you to search the list by a number of different variables:
Search for: Enter part or all of a member’s surname, first name, email address or username.
In: Select ‘Surname’, ‘First name’, ‘Email’ or ‘username’ from the drop down list. Role: The default is All but other roles are available from the drop down list.
User Type: The default is ‘All’ but you may choose ‘Registered’ or ‘Unregistered’ from the drop down list.
A ‘Registered’ member is one who has signed up to the Play-Cricket system. They will have a username and password. This person may be assigned administrator rights.
An ‘Unregistered’ member is one whose record has been added by an administrator. The record is 'temporary' i.e. not registered with play-cricket. The person will appear in the Member Database with the abbreviation TMP next to his/her name. These members cannot be assigned any administrative role.
Status: The default is ‘Active’. The other option is ‘Pending’.
Sub-Role: Some roles have a further drop-down list available to further refine a search. The Roles with Sub-Roles are:
- Squad Players and team names (Status can be 'Active' or 'Historic')
- League Registered Players and league name
- Messaging Groups and name of group
Date of Birth After: Use this to find junior players
Date of Birth Before: Self explanatory - useful for senior roles
Passport / Visa Type: Select from the drop down list
You can also filter by members not having particular roles. e.g. Role = Member of Website to find players still on your member database who may still be on a messaging group or have a squad role, but do not have a member of the website role.
Click Search when the criteria have been selected.
All ‘Main Administrators’ for the club site – this is a good housekeeping exercise to find out who has access to all of the personal data on your club’s Play-Cricket database. How many of these people do you know? There should be more than one person with full administrator rights in case of emergency, holiday or sickness but not too many.
Please do not allow your details to be accessed by others and do not create a ‘general’ login with main administrator rights.
If people need to make updates, they must have internet access. They must therefore be able to create their own username and password and have admin rights granted to that login, rather than creating a 'generic' one which is fraught with dangers.
For example, what do you do if you no longer wish a person to whom you have given these 'generic' details to have any admin access? You then must change the login details, and try to notify everyone else who you think might have access of that change.
What do you do if someone amends the login details and locks out everyone else who was using the login? How do you control who else these details might find their way on to?
Logins like this are notorious for being passed on to other people without your knowledge. People tend to treat their own login details much more carefully than a shared login.
All ‘Squad Players’ for a selected team – the list that is returned will be for all who have an ‘active’ role in say, the 1st XI squad.
Having obtained a list, you could use the following buttons to perform further actions:
- Download Members – get the list in Microsoft Excel (.xlsx) format downloaded to your computer
- Add New Member With This Role – create a ‘temporary’ record for a new player in the squad. If the person has already registered with PlayCricket, ask him to apply for membership of your site. He should not register again.
- Apply This Role To Other Members – select this option to see all members of your site without the role that you searched for, tick the box against the selected member(s), then save the change.
- Send Group Email – rather than create a Messaging Group, you could issue an email to everyone in the search results.
To the right of each member’s name are their email address (if one is provided), plus four icons. from left to right the functions of these icons are listed below
View/edit a member’s details
The member’s details may be edited by clicking the View icon (Eye symbol) in the member’s row.
User details and player profile are shown, and details of their different roles on the site are listed via the config panel
This is the place to correct any misspelled names created by other teams when adding scorecards as it will allow the data input for that name to be retained.
There are some scenarios where areas of a user record will be locked out from editing.
1) If a user ins not marked by the TMP abbreviation then they have claimed the record and must make any amendments which are locked to an admin.
2) If the user record has been registered to a league then it cannot be modified until un registered.
3) If the user record belongs to a junior who is linked to their parents account, this is indicated by the top line of the parental contact details also being locked to an admin. Parents have direct control over this record and can make changes
Selecting this icon gives you a list of all the games associated with this player based on the team selection list. This means that the match will appear in the list even if it was cancelled. Note that the club’s teams will always appear in the first column, regardless of the venue. Click the View link to see the full fixture details.
Match (Match Records function)
The Question mark icon, allows the administrator to remove any duplication in the list. It may be that he has loaded all the players in his own database onto the site, and some players in that database were already site members. By matching them, the two records are merged so that information is not lost and statistics for the player are kept together. It is always preferable to match member records rather than delete them. When the icon is clicked, a list of possible matches is displayed, and the administrator can choose whether or not to match this record with one of the names on that list.
To match safely and accurately, follow these instructions:
Under Admin Home>Members>Member Database, your players are listed. Some are registered play-cricket users (no asterisk by their name) and others are temporary (marked with *). You should begin the matching with the record that you wish to keep; so if you have an entry for a registered user, begin with that, otherwise pick the one that has the best version of their name, or that is the most ‘current’ in terms of email address. If you attempt to match a registered user to a temporary user, then the registered entry will always be kept. Otherwise, the match will keep the record that you begin with, so be sure that you start with the right record.
Next to the record you decide to start with, click on the Question mark and you will get a list of possible matches. Choose the one that you wish to merge with your selected player and click on the 'Propose match' link next to their name
To confirm your choice, a pop-up window appears with details of the players to be matched and the resulting merger. Click the ‘Yes’ button to continue the matching process.
If for any reason the players cannot be matched, an error message will be displayed and the match will not take place.
You should never try to 'recycle' entries by amending the name in them to someone else's or by matching entries for two entirely different people - this will cause errors in scorecards and statistics as well as the roles of those individuals within their clubs and leagues.
If there are more than two entries for a player, repeat the process and always begin with the registered entry if one exists.
You should always match entries in the list offered to a relevant entry if possible.
The player to be matched is not in the club’s database
A common problem is that you see two entries for the same person in the batting or bowling statistics for your site but you can only see one record for the person in your member database.
If the record can’t be found, it is likely that one of the records has been removed from the site at some point so you will need to gather some information before contacting the Play-Cricket Helpdesk
When you hover over a player’s hyperlink name, and your browser allows it, a URL with the player’s ID should show at the bottom left corner of the browser window.
Please supply the names of the players to be matched as shown in the statistics, and the corresponding player ID where possible.
The Pencil icon, allows the administrator to assign various roles within the site to the user. When this is clicked, the potential roles are displayed by category via the config panel
These roles can then be used within searches to limit the list for emailing, or in the case of website roles to give the user administration access so that he can update the site himself. If a user's Member of the Website role is de-activated, all assigned roles remain in place. e.g. Squad member. In this case, the user's details will only appear on the member database if a search is carried out for 'All' roles or a specific role that includes the non-active user.
If the player had League Registered Player status, then this should be removed when the player leaves the club.
Additional functions enabled via the tick box
Selecting a record via the tick box will activate the following options
Remove roles: if a role has not been listed via the advanced filter this will remove the users record from your site, all of their stats will be maintained however you will no longer have access to the users record.
If you wish to just remove a squad role or Admin role, then filter the role first using the advanced button, this will allow you to remove the role and not the record from your site
Send Email: Clicking the button at the top will allow you to email the user if they have an email address in their record
Some Leagues require players to be registered with them before they are allowed to take part in a match. The tab will appear only if your club plays in a league that has specified player registration.
This topic has been dealt with in a separate document that may be found by searching for ‘League Registration’ in the Helpdesk Knowledge base.
Select this option to check the status of nominated players for league registrations.
If the player is still in the Pending Nominations list, the league administrator has yet to process the application.
The Rejected Nominations tab will display rejected nominations with the league administrator’s reason for rejection.
A club administrator may withdraw a nomination at any time by viewing the League Registration tab for the player and selecting withdraw.
Admin>Set Up>Messaging Groups
An administrator may set up and maintain groups to which he can assign members, in order that he can email them according to those groups. He may, for instance, set up a ‘Committee’ group, to which he can add everyone who is a club committee member to give them notice and minutes of monthly meetings. He could set up another group called ‘juniors’ that contains everyone under 16, so that he can send them newsletters.
Some administrators use this to contact parents – they can be set up in a Messaging Group without a Member of the Website role.
There is no limit to the number of different groups, or to how many different groups a person can belong.
Add a new group by clicking the ‘Add New Messaging Group’ link at the top of the page. All that is required is to enter the group name and click the ‘Save’ button.
Messaging groups can also be used effectively as an extra role or field.
For example you want to have a role of Coach for some people. It isn’t easy for Play-Cricket to set up extra roles, but by simply adding a messaging group with that title and adding the relevant records from your member database to that group, that is effectively what you have.
Similarly you might want to indicate if a person has paid (or not paid) their subscription, or is attending the club dinner. Again, add a messaging group and you can add and remove people as necessary.
The number of different roles and fields that individual clubs and leagues require is almost infinite, and a field set up for one site would show on everyone’s; but this method allows you to create the fields that you want in your database without affecting other people’s.
This function allows the site administrator to load a large number of entries into the member database very quickly. He may already have all his club members’ details on his computer in a different format e.g. an Access database or Excel spread sheet. The data from his computer can be transferred to the play-cricket database, thus saving the effort of re-typing it all or getting the members to do it all.
The facility is intended for uploads only, such as when setting up a new site i.e. existing members of the database will be duplicated if they are already present. You can neither update nor delete a person's details by this means.
To use the function:
- Download the template by clicking the Download template button
- Complete the fields in the spread sheet according to the column headings
- Upload the file using the Upload File button
The email log shows the administrator a list of emails sent by the Club to the different groups.
Emails appearing in the log include those sent by Play-Cricket when:
- An email is sent from the Teams page;
- A group email is sent from the Member Database;
- A league administrator is informed that a player registration has been removed;
- A pending nomination to a league has been withdrawn;
- An email from the Team Picker is sent to the players including the notes that have been added. Note that there will be a separate record for each player in the team because the acceptance/declination to play has a different link for each player;
- An email from the Team Picker is sent to the officials including the notes that have been added. In this case, the officials will be grouped together since they receive the same email content.
The email list is in date order and may be searched using the dropdown boxes at the top of the page. View individual items on the list below by clicking on the magnifying glass icon next to the item
Note that the names of the recipients are listed in the log in alphabetical order. Each person gets his own copy of the email, without seeing another recipient’s email address.