Nearly all contacts have an UNKNOWN country zz whi...

13643
Reporter: mdoering
Assignee: mdoering
Type: Bug
Summary: Nearly all contacts have an UNKNOWN country zz whi...
Description: Nearly all contacts have an UNKNOWN country zz which is rendered as "unknown or invalid". This should be empty and maybe not even we countryCode ZZ in the contact json at all? A question whether country is a required field or not.
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2013-08-26 10:43:41.889
Updated: 2013-10-30 15:51:51.987
Resolved: 2013-09-12 16:33:40.881
        
    

Attachment PeopleDatabase.png

Author: mdoering@gbif.org
Comment: Ignoring unknown countries in portal addresses for now: https://code.google.com/p/gbif-portal/source/detail?r=1858
Created: 2013-08-26 10:59:10.125
Updated: 2013-08-26 10:59:10.125

Author: ahahn@gbif.org
Comment: Contacts do have countries in the IMS; question is where the zz comes in?
Created: 2013-08-28 11:47:12.954
Updated: 2013-08-28 11:47:12.954

Author: mdoering@gbif.org
Comment: the current implementation expects a 2 letter ISO code, but the SQL returns the english name. Returning iso codes fixes it: https://code.google.com/p/gbif-labs/source/detail?r=591
Created: 2013-09-12 16:33:35.202
Updated: 2013-09-12 16:33:35.202

Author: ahahn@gbif.org
Comment: In addition, there is a data issue in the IMS, where some contacts have country names instead of numerical ids in the foreign key. Creating separate issue for IMS info.
Created: 2013-10-03 12:08:19.583
Updated: 2013-10-03 12:08:19.583