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) »
  • Import of state suddenly all wrong
Pages: [1]

Author Topic: Import of state suddenly all wrong  (Read 1243 times)

sypl

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
Import of state suddenly all wrong
January 06, 2011, 12:05:15 am
I do an import every month of new donors and their addresses. We use common abbreviations for US states, so CA = California, etc. This month it's all gone wrong and I'm getting 'Canelones' instead. Any idea why the behaviour would suddenly change?

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import of state suddenly all wrong
January 06, 2011, 03:12:57 am
What did you change between the previous import (that worked) and this one ?

Either the format of the file, the code, the environment on the server or the process has changed. (assuming that IT is a deterministic system, bit of an act of faith ;)

Good luck

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

sypl

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
Re: Import of state suddenly all wrong
January 06, 2011, 03:26:33 am
Honest to god, didn't change a darn thing! I noticed that when I went in to edit the records manually that the state is not selected/defined, probably as the system recognises Canelores isn't a state of the US. So it seems that during the import the state is getting set first, with the first match to 'ca', and then the country. Again, I really don't think I've changed any settings.

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: Import of state suddenly all wrong
January 06, 2011, 09:00:07 pm
This thread describes similar behavior, and I think I had found the cause, but haven't looked further.
http://forum.civicrm.org/index.php/topic,16227.msg71582.html#msg71582

lanetterm

  • I’m new here
  • *
  • Posts: 8
  • Karma: 1
  • CiviCRM version: 3.3
  • CMS version: Drupal
  • MySQL version: 5
  • PHP version: 4.2
Re: Import of state suddenly all wrong
January 26, 2011, 06:50:02 am
We have been bitten by this bug also -- Is there a fix available? -- I changed the ones I have imported but I am looking at importing another 9000 names with multiple addresses --

thanks

Lanette

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: Import of state suddenly all wrong
January 26, 2011, 08:14:55 am

No.

Would be great if you can investigate and submit a patch to fix this issue and/or hire someone to do the same

thanx

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import of state suddenly all wrong

This forum was archived on 2017-11-26.