Issue 13643

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

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

Comment: Ignoring unknown countries in portal addresses for now:
Created: 2013-08-26 10:59:10.125
Updated: 2013-08-26 10:59:10.125

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

Comment: the current implementation expects a 2 letter ISO code, but the SQL returns the english name. Returning iso codes fixes it:
Created: 2013-09-12 16:33:35.202
Updated: 2013-09-12 16:33:35.202

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