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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • 1.6 Import -Updating/Filling Data Error. not working?
Pages: [1]

Author Topic: 1.6 Import -Updating/Filling Data Error. not working?  (Read 25730 times)

dgreenbergz

  • Guest
1.6 Import -Updating/Filling Data Error. not working?
May 03, 2007, 12:03:18 pm
I'm trying to import individuals after changing all "Smythes" in the last name field to "Smith", (for example : } )

But Smythe is still there, whether I use the update or the fill option. I checked the actual database, no values were changed. I checked the import file, there's not one Smythe in there.

Although the import process appears to work, and I get the "done" button, and/or message. No data is changed. Anyone have experience with this? Where could I start looking to fix this issue?

Is the import -update/fill function a javascript?

I ask because we had a problem with the premium settings not expanding, which is javascript, and we did fix it. The problem was that our Drupal design company had put in certain div tags related to the lightbox module which interfered with javascript functionality. I found a clue to that on the Drupal.org forum. I remember there was some recent questions about javascript, check the html coding of your site pages/css styles.

doug

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: 1.6 Import -Updating/Filling Data Error. not working?
May 03, 2007, 01:45:36 pm
Import / update is not a javascript function.

If you're doing updates via import, you need to make sure that the fields needed to "match" your CSV (import) record to your database record are mapped in the import and are doing what you expect.

In the case you describe - this could be problematic if you're using the default settings - which is to "match" on first_name + last_name + email. If your incoming CSV data has last names ("Smythe") that don't match what's in the DB records ("Smith") - then the records don't get updated. You can work around this by changing your duplicate matching rules (Administer CiviCRM >> Duplicate Matching) to just match on email (assuming that you have matching email addresses in the import data and the DB).
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • 1.6 Import -Updating/Filling Data Error. not working?

This forum was archived on 2017-11-26.