Joel Norman
Oct 30, 2018

Missing players from online database

26 comments

i'm unsure if this has just occurred in the recent database migration for our club but i just did a sanity check between my v11 database and online version and noticed 4 players are missing:

Fleeton, Brent (2 games)

Maver, Jay (26 games)

Miru, Dwaine (75 games)

Scales, Matt (81 games)

 

When i went into the online match report there names are blank on the scorecard for that match and there name is also missing from our players list - eg Matt scales should be in the match below. There is an awful lot of matches to trawl thru to add these players back into the online system...

 

 

 

 

Mark @CricketStatz
Oct 30, 2018

Joel, can you post up a URL link to that match report please? It really helps when you can link it.

Mark @CricketStatz
Oct 30, 2018

OK I think I have worked it out. Go into your v11 database and go into the Player records for each of these. What do you have entered for their first names and last names?

Joel Norman
Oct 31, 2018

your're right in v11 for those 4 players their first name and last name in the Players entry form are blank it just has their report name. Not sure what is going on as those players haven't played for a few years and i can't remember ever editing them...

 

what's the best way forward from here? do i send you my latest v11 database again to reload?

Mark @CricketStatz
Oct 31, 2018

If you want to send me your v11 database with the names corrected then I am happy to re-publish. Just be aware that you need to have all the previous issues sorted as well - the ground name matching, the SMCC 4th team name matching and that player that you had his names backwards.

 

You will also need to add the 4 missing players to the online system and make sure their first name and last name perfectly match with the v11 database:

 

Fleeton, Brent (2 games)

Maver, Jay (26 games)

Miru, Dwaine (75 games)

Scales, Matt (81 games)

Mark @CricketStatz
Oct 31, 2018

And also, if you don't mind, I will move this thread over to the questions section since it is a data issue related to the v11 data and not an online system issue.

Joel Norman
Oct 31, 2018

I've emailed our latest v11 database for upload.

Mark @CricketStatz
Oct 31, 2018

Got half way and got the message "Could not match Peter Blanch" - can you check first names and last names on both sides?

Joel Norman
Oct 31, 2018

yer sorry i changed his name on the updated v11 version but forget to change the online version... I've changed the online version now - so he should be ok.

Mark @CricketStatz
Oct 31, 2018

OK all done. Can you check that the missing players are now there?

Joel Norman
Oct 31, 2018

Yes those players are all there now. thanks.

 

Just running another cross check against my old v11 database (using the the complete player summary report) and a few players (about 12) have found an extra match on their online stats. However their runs, wickets, catches etc are all ok and match with v11. The easiest player to check is Phil Sharman, when i run his Player Pages stats, his total matches says 7 but all the various breakdowns below that all show him with only 6 matches...so i'm unsure where the extra match is coming from.

Mark @CricketStatz
Oct 31, 2018

Have you run the audit report in the admin/reports section that shows players that have fielded but are not in the batting scorecard? I am confident you will find him on the list.

Joel Norman
Oct 31, 2018

Just checking that now - plus i also found in the Reports section that Beta version of the Match by Match for players section which i'm also checking. Will let you know how i go.

Mark @CricketStatz
Oct 31, 2018

Yes, the new match-by-match report would also certainly help

Joel Norman
Oct 31, 2018

In our competition we can have players replaced in the same game from the 1st week to the 2nd week of the match so although you only have 11 batters you can have up to 13 players for a team in the game. To have all players collect a game and they didn't bat or bowl we got around this problem in v11 by adding their name to the bowling section with figs of 0/0/0/0 so they still counted a game. The funny this is all the players with the import in this same situation their correct match totals have come thru ok...although they are not listed on the match report anywhere.

 

But when i try to fix up the issues with the players i raised above that i must have missed giving them the 0/0/0/0 figs in v11, the online system won't let me have a bowler with figs of 0/0/0/0 i need to give them at least 1 ball bowled for them to appear.

Mark @CricketStatz
Nov 1, 2018

Hi Joel,

 

Do me a favour - don't go editing and saving any innings that were published from v11 or it will erase the matches from these players. Let us work out a solution. Give us a couple of days.

Joel Norman
Nov 1, 2018

No worries. I've just been doing some investigation and player Michael Offerman is a good example where he only played 1 match for the club - SMCC 2nd v SKLP on 7 Oct 2017 at Maguire Park and was not listed on the batting card but only the bowling with 0/0/0/0. The match details appear in his Match by Match 'Match Stats by Player' report but not on his 'Players Pages' Report.

 

I'll let you work out a solution.

Mark @CricketStatz
Nov 1, 2018

Can you post up a URL link to this player's page please?

Mark @CricketStatz
Nov 1, 2018

@Joel Norman I am a little confused now. Can you let me know what you are expecting to see on what report that is currently not showing?

Load more replies
Mark @CricketStatz
Nov 1, 2018

OK try adding a player to the bowling now with 0/0/0/0 figures. He/she should stay on the bowling list except if they have taken a catch or completed a runout - in which case they will be given credit for the match anyway.

Joel Norman
Nov 1, 2018

Does this mean you need to reimport our v11 database again to pick the previous players with bowling of 0/0/0/0?

Mark @CricketStatz
Nov 1, 2018

No - they should all be there still provided you have not edited/saved the innings since import. Please confirm.

Joel Norman
Nov 1, 2018

No i haven't gone into any matches since the last import.

Commenting is off for this post.
New Posts
  • Victor Isaacs
    4 days ago

    Hi Mark, After all this time my old laptop has died on me and with my sons help I purchased a Chrome Book laptop (compact and not too heavy). However I have been having an issue in using the Chrome Browser supplied. I am able to get into my admin section of CZ, but trying to look at stats/players/matches etc in the open public site it wont let me: I can get http://www2.cricketstatz.com/ss/web.aspx?club=231522 However when I say click on players http://www2.cricketstatz.com/ss/web.aspx?mode=20&club=231522&team= There is a pre message saying Not secure. And will not let me view any. Do you have any idea on this please ? Thanks
  • Kevin Mitchell
    Nov 8

    I am trying to import matches from Play Cricket to the database - however, it doesn't seem to be working. It seems to get stuck if there is a player/official not in the database - I've tried the 'Quick Add' but the match won't upload any further.
  • Rameaze Raza
    Oct 29

    I notice an issue with the historical stats we imported into the system. Players that have since changed club cannot see their stats on their current profile page. Their profile page only have their stats from their current team; however if they view their profile from the league page their complete stats is visible. Can you look into this for me please.

Top Suggestions

©2019 CricketStatz.Com | Privacy