Importing Matches

Cricket Statz allows you to import matches from online sources such as PlayHQ, Play-Cricket (Eng), Cricket Archive, cricheroes.in and CricHQ.

Step 1 - Logging In
Log in to Cricket Statz administration at https://www2.cricketstatz.com/ss . Your username is your email address and your password would have arrived in an email. If you have lost your password then click on ‘Lost Password’ to reset your password.

Step 2 - Commencing the Import

Click on the Import link on the top menu. You will require at least access level 7 to select the Import option.

Enter the external source MatchID into the respective service entry and then Import to commence the process. The external source MatchID can be found in the URL (web page address) of the match report page from the respective service. It will be shown as a set of numbers and or letters towards the end of the URL or in the middle of the URL for PlayCricket(Aus).

Click here for help with locating the PlayHQ MatchID

Click here for help with locating the PlayCricket (Aus) MatchID

Step 3 - Matching Divisions, Teams and Venues

If it is your first time importing matches then it is likely you will need to set up the aliases for your divisions, teams and venues since Cricket Statz will warn you if it cannot match the name of these when it does an import.

If it can't match the entries then you have two options:

Add the division, club, team or venue if it is not in your database already or
If it is there, then go and edit the respective record and add an alias to the alias field that matches what the import is looking for (don't put any quotes around the alias).

You only need to set an alias up once. All subsequent imports will use these aliases.

Step 4 - Matching Players and Officials

Finally, you will need to make sure players and officials are correctly matched.

For PlayHQ and PlayCricket (Aus):

When a batter, bowler or fielder cannot be found then you will be given the option to either Assign Play[HQ/Cricket]ID - which will allow you to add a the Play[..]ID to an existing player record or Add New - which will add a new player/official record. The Play[..]ID is the unique string of characters next to the Player's name. For example: 39e59b16-a5f5-4275-a23d-1fe446b746ac. Copy this and paste it into the Play[..]ID field of the corresponding player record. Note that player matching will also try to use the player alias field but the Play[..]ID method will give more reliable results.

For Play-Cricket (Eng), Cricket Archive, CricHQ, cricheroes.in:

When a batter, bowler or fielder cannot be found then you will be given the option to either Assign Alias - which will allow you to add an alias to an existing player record or Add New - which will add a new player/official record. An alias is a way to match the name on the external service with the player in the database. Each player can have multiple aliases - separated with a ; and no spaces. Each alias must be unique. Aliases are not case sensitive.

Once you have added the player or their alias/ID, you will need to hit Re-try to import the match again so that the newly added players can be found. You will only need to set this up once - all subsequent importing will use this information to match the player records.

When all players are correctly matched then your match import is complete.

Congratulations! You have now imported the match in to Cricket Statz.

In detail - how does player name matching work?

Cricket Statz will try a variety of ways to match a player record in the database. When presented with a player name such as John Smith of Team ABC (of Club ABC) it will do the following player record searches:

Look for Firstname=John AND Lastname=Smith AND Current Club=Club ABC
Look for Alias=John Smith AND Current Club=Club ABC
For PlayHQ: Also look for ANY player across all clubs with a matching PlayHQID

For Cricket Archive: Also look for ANY player across all clubs with a matching ExternalID (CA playerID)