CiviCRM Community Forums (archive)

We are getting "Invalid value for field(s) : County" and " Invalid value for field(s) : Citizenship; Citizenship" import errors for records even where the data does exactly match the 'name' in the civicrm_country table and from the pattern that has developed  I'm starting to suspect the validation process which enforces this is stumbling on the comma that appears in the names of certain countries. ie. records with these values mapped to country name fail with such an error:
"Korea, Republic of"
"Iran, Islamic Republic of"

Am I correct in assuming this is a bug, and if so, can it be fixed?

Hi it-support,

If you can replicate the bug on the demo server (demo.civicrm.org), which sounds like it should be easy enough, you can file a bug report at issues.civicrm.org with the steps to replicate (and referencing this forum post).

Reporting a bug is no guarantee it'll get fixed - the core team relies on third parties to contribute a lot of bug fixes - but reporting it is certainly the first step, and there's a not-unreasonable chance someone will pick this up.

Thanks for the tip on the country codes; unfortunately our source data uses ISO 3166-1 alpha-3 rather than alpha-2 country codes, so the names are actually the simpler match (where they work), so it might be worth doing the test and submitting the issue after all.