Thanks Mark. Yes to the audit report. I'm trying to work out how to find them without it!

On the road now but will get that done later. Any idea how that could have happened?

Here are a couple Patrick Tice - 64223 Ciaran Divney - 66812 Lots more if you need them

Oddly, most seem to have disappeared, but it looks like still a few keepers there.

Good spot! Yes they are. I never would have spotted that

Morning Mark. Everything is working perfectly

If it doesn't create duplicate, that is perfect. The only match types we use in Leinster are "1 innings" and "T20", And matches can change in type if they are rained off and refixed as a T20 match, so looking back there is no way of working out which match has which type. It's not a big one - everything could be "1 innings", but I use it as en extra filter - so for example I could search for all T20 matches played

Top work. One very minor thing is that I was entering thousands of matches (I used the API t make it easier), but didn't want to ruin the output of the various "Howout" reports, and so added "Unknown" instead of "Caught". But that's only minor

Thanks all. @driseborough - that's sorted now

Our covid delayed season is only getting going this weekend, so I'll report back from the 180 odd teams who input scorecards. As Mark alluded to, now that scorecards are auto-populated from the team lists it makes little sense to have them in alphabetical order - no teams bats its players in alphabetical order. But against that, as everyone has said above, a settled batting order is unheard of in most club cricket teams, so I'm not quite sure that is the ideal solution either. However at least by ordering the team with the core players at the top, you are more likely to have the right players in the auto populated scorecard

Thanks Joel. And would you mark the result in anyway? Or maybe change the format in some way like, "X beat Y by 23 runs batting on"?

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.

Knew I was doing something wrong. Forgot that team list could be ordered manually! Was struggling to see why teams would bat their players in alphabetical order every week. Glad I asked the question

No problem. I’ll stick it up as a suggestion. It would be easier if it defaulted to blank? The chances of it being the correct name in the correct batting position are pretty slim, so everything has to be cleared before you manually enter a card

😁My bad. Thanks Mark

Sounds good. Would love to hear from others as well.

Thanks Mark. You were right! Teaching myself as I go along, but can create a match now. One other thing (can create a new thread if you want). Can I not add the Pool via the API?

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?

Yes the information is in that report. And it's fine for me if I'm trying to get that info. But it's not massively user friendly - I'd need to create the Complete Summary Report, copy the data into Excel, create a column in Excel to add the three types of dismissal, and then sort by that column to see who is top So this one is all about user friendliness rather than accessing the data

Perfect. Thanks for clarifying!