CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.0 Release Testing »
  • Possible to Manage Country Names?
Pages: [1]

Author Topic: Possible to Manage Country Names?  (Read 4524 times)

kenlyle

  • I post occasionally
  • **
  • Posts: 116
  • Karma: 7
Possible to Manage Country Names?
September 26, 2009, 06:32:08 pm
I got an import error because USA is not in the Country Names/Codes list...
"country input value not in country table: The Country value appears to be invalid. It does not match any value in CiviCRM table of countries."

But couldn't find where to manage this list in the Joomla backend....oh, here it is...

Administer-Configure-Global Settings-Localization, under "Contact Address Fields - Selection Values"

There is a related really tiny bug in the great error message that's included in the download, when the country is not available.  Try importing a record where the country is United Kingdom, but United Kingdom is not available.  I believe that that error message in the CSV file is just a little off, relative to the above path to make United Kingdom available.

Best,
Ken
« Last Edit: September 27, 2009, 08:41:23 am by kenlyle »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Possible to Manage Country Names?
September 27, 2009, 07:40:46 am

The country names/abbreviations are in the civicrm_country table

note that civicrm follows the ISO-3166 standard, and the abbreviation is US

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

kenlyle

  • I post occasionally
  • **
  • Posts: 116
  • Karma: 7
Re: Possible to Manage Country Names?
September 27, 2009, 08:43:10 am
Thanks, Donald.

Ken

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.0 Release Testing »
  • Possible to Manage Country Names?

This forum was archived on 2017-11-26.