Lockdown number three in Ireland, so looking as if I have an extra month or so to improve our archive! I'm looking at importing 10000 matches covering the last 100 years. Currently we have the summary of each match - eg date, teams, competition, venue, number of innings and runs and wickets for each innings. My only option for getting these matches into CricketStatz is to import the matches using the current Match Import procedure (which is great - no problems here). But then in order to get the innings totals into CricketStatz, I have to add the innings total to the first "batsman" and then change each of the "How Outs" from dnb to bowled for each wicket. So that's approx 200000 items that need to be entered. Would it be possible to add fields to the Import Fixtures facility that would also have an innings total and innings wickets on?
I'm starting to get to the next phase of this project now. Am I right in thinking that I could run an API to push the team score for our 7000+ old matches to CricketStatz?
Is there any reason why that wouldn't work? One issue that I can think of is as detailed above with the problem of getting the wickets for each innings. The only way is to have "invisible batsmen" , ie the "Batsman1" firstname and lastname as blank, but then have "Howout" as "3". Would that cause problems?
An update on this one. I'm withdrawing this suggestion. as the API is a great way to be uploading results and scorecards. In the end we uploaded 9103 results using the API (full scorecards is a job for the future)
https://www2.cricketstatz.com/ss/runreport2.aspx?mode=72&club=4530&grade=0&ground=&mtype=&pool=Sen&sday=1&smonth=Jan&sYear=1919&eday=30&emonth=Dec&eYear=2020&finals=0&team=0&oppteam=0&round=&mininns=0 You need a bit of coding knowledge, but happy to help if anyone needs to go down this route.