Darren Taylor
Jul 15, 2018

Historical data import - file size

5 comments

When importing historical data is there any relevance to the size of the csv file? When importing a 239KB csv file the "oops something went wrong message" appeared resulting in not all of the data being imported

Mark @CricketStatz
Jul 15, 2018

There is no relevance of the size of the CSV.

 

I suspect it will be one line in your CSV that has some big or strange value associated with it. We need to work out what line that is.

 

How far through the import does it get? Do you know which is the last player that gets imported successfully? If yes, then the problem will be with the next player. If you can work out which one that is then let us know with the line from the CSV that is the issue.

Darren Taylor
Jul 15, 2018

It gets up to M - the player before this line was imported.

 

0,Michael,Moulton,BPCA A Grade,BHCC A Grade,11,11,2,162,,,,1,,,,,,,,,11,,,05/10/2002

Mark @CricketStatz
Jul 15, 2018

So I just imported that single line into your database and it imported fine.

 

I suggest you try and continue the import - delete all lines out prior to Michael Moulton and keep going with it.

Darren Taylor
Jul 15, 2018

Thanks Mark - that was successful.

New Posts
  • Victor Isaacs
    5 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