1.6 Import -Updating/Filling Data Error. not working?

[dgreenbergz]

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]

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).