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) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Problem Importing Counties
Pages: [1]

Author Topic: Problem Importing Counties  (Read 1239 times)

AndyHarkness

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 0
    • Andy's Blog
  • CiviCRM version: 4.5.0
  • CMS version: Wordpress 4.0
  • MySQL version: 5.1.61
  • PHP version: 5.3.3
Problem Importing Counties
January 22, 2013, 04:39:52 am
I'm having a problem importing Irish counties when I import organisation addresses. When I go to add an address manually I can see the correct counties, however when I go to import the counties I get the message " County input value not in county table: The County value appears to be invalid. It does not match any value in CiviCRM table of counties." As far as I can see, the county data to be imported appears to match the county dropdown options e.g. "Dublin". I had a look at the mySQL table to check if I could find the values for counties there, but didn't manage to find them  there.

Any tips as to why counties do not appear to be importing would be appreciated. 

Tony Horrocks

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 7
    • Fabriko Limited
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7
Re: Problem Importing Counties
January 22, 2013, 05:10:39 am
Navigate i your site to civicrm/admin/setting/localization?reset=1
Make sure that Ireland and Ireland Counties are available.
Tony Horrocks
Author of the CiviCRM CookBook https://www.packtpub.com/web-development/civicrm-cookbook

AndyHarkness

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 0
    • Andy's Blog
  • CiviCRM version: 4.5.0
  • CMS version: Wordpress 4.0
  • MySQL version: 5.1.61
  • PHP version: 5.3.3
Re: Problem Importing Counties
January 22, 2013, 05:17:42 am
Quote from: Tony Horrocks on January 22, 2013, 05:10:39 am
Navigate i your site to civicrm/admin/setting/localization?reset=1
Make sure that Ireland and Ireland Counties are available.

Thanks Tony, I have checked and Ireland is available in both "countries" and "states and provinces".

Tony Horrocks

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 7
    • Fabriko Limited
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7
Re: Problem Importing Counties
January 22, 2013, 05:55:45 am
Hmm. Bit hard to help. Ive done a test import just adding first name, last name, state, country using Ireland and Limerick as the county. Worked fine.

Check that the file you are importing does not have any spaces or weird characters in it?

The spellings have to be spot on as well
Tony Horrocks
Author of the CiviCRM CookBook https://www.packtpub.com/web-development/civicrm-cookbook

AndyHarkness

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 0
    • Andy's Blog
  • CiviCRM version: 4.5.0
  • CMS version: Wordpress 4.0
  • MySQL version: 5.1.61
  • PHP version: 5.3.3
Re: Problem Importing Counties
January 22, 2013, 06:38:09 am
Aha, found the problem. The Irish counties are not contained in the "county" field in CiviCRM, they are contained in the "state" field. I mapped the counties to "state" and they all imported fine.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Problem Importing Counties

This forum was archived on 2017-11-26.