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) »
  • Importing International Addresses
Pages: [1]

Author Topic: Importing International Addresses  (Read 601 times)

cvining

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.05
  • CMS version: Drupal 7
  • MySQL version: 5.0.92-50
  • PHP version: 5.2.17
Importing International Addresses
September 20, 2011, 04:07:04 pm
It's a pain!  Somehow you have to regularize your data to match the Province & Country data in CiviCRM.  OK, CiviCRM uses international standardized place names, and I don't have a good fix, but it's still a pain!  I only have a few hundred records, once a year.  I munge them in by hand fixing rejected records.  With a really large DB, it just wouldn't be practical.

OK, two notes from my latest exercise:

1. Munich is in Bavaria, but there is no Bavaria province in CiviCRM
2. Singapore has no Province records in the database, so it's not possible to import a Singapore address.  I added a dummy record, just to get it to move forward. 

OK, on the whole it's really working pretty well!

 -- Cronin

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Importing International Addresses
September 20, 2011, 11:33:26 pm
As far as the states go, we do not use provinces or states in The Netherlands either, so I just untick the field in the settings? Then the province will not bother you any more. I am not sure if that does it for your import, I hardly ever use the import function. You might want to develop a specific script for your import? It should not be too much work using the API.
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing International Addresses

This forum was archived on 2017-11-26.