search

magicbug / Cloudlog

Web based amateur radio logging application built using PHP & MySQL supports general station logging tasks from HF to Microwave with supporting applications to support CAT control.
http://www.cloudlog.co.uk
MIT License
450 stars 189 forks source link

US Counties filtering #1345

Open ofadam opened 2 years ago

ofadam commented 2 years ago

On the US Counties page under Awards, I've noticed that things can get messy depending on the source ADIF imports to Cloudlog:

Screen Shot 2022-01-02 at 11 12 37 PM

Some (like Gridtracker) use the "XX, County" format (where XX = state abbreviation.) Other software (like Log4OM) seem to just use the county.

Although I believe the ADIF spec asks for the "XX, County" format, would it be possible to have some filtering happen to basically combine both formats and ignore any upper-case/lower-case differences?

(From ADIF spec: CNTY | US County in the format STATE,COUNTY. For example GA,BARROW)

AndreasK79 commented 2 years ago

I see your problem, but I don't know how this can easily be fixed. I followed the ADIF spec when adding auto-complete for counties, and saving/editing them. Anyone having any ideas, please feel free to pitch in.

ofadam commented 1 year ago

Could some filtering be used before tabulating this stats page?

Would need to do the following:

That should fix things up, I think?