search

BernhardWebstudio / DataShot_DesktopApp

Desktop application client intended to support an object-precapture-image-data workflow for capture of natural science collections data. See the wiki (https://github.com/MCZbase/DataShot_DesktopApp/wiki) for user documentation, or the README below for developer documentation.
0 stars 0 forks source link

Wrong names with auto-fill when entering Lat/Long #34

Closed EntomologicalZivi closed 3 years ago

EntomologicalZivi commented 3 years ago

We use this excel table to determine the correct names. The correct names of the countries are in column A. The correct names of the provinces are in column B.

Countries_primary_divisions_ISO3166_xls.xlsx

Do you want me to put only wrong names in the .csv list or all of them?

GenieTim commented 3 years ago

Excel is fine too. I just need some way to know what wrong to replace with what right. So, e.g. one column "wrong" and one column "right". Or similar.

EntomologicalZivi commented 3 years ago

Ok. So as i said the column A and B are always "right". And in column C i put the "wrong" names. Right now we know of only six wrong names, but we have to use them a lot.

Countries_primary_divisions_TIM.xlsx

We'll keep you updated if more come along.

EntomologicalZivi commented 3 years ago

I've made a Goole-Sheets file out of it. Is that ok? You could just delete our wrong names in the column C when you updated them. Like this we would always be up to date and won't have to send files around.

The sheet: https://docs.google.com/spreadsheets/d/19Z4SiynHQmaoLqqz2SgMpOn-EcZim333hWq-Oov90g8/edit?usp=sharing