CiviCRM Community Forums (archive)

I am importing data into my site using Drupal 5.7 and Civicrm 2.0.3. I have set up a mapping and go through the import, and it tells me that it successfully imported the data. But when I look at the tables (and the contacts -- I'm importing individuals), there are no new records.

Not all the data in my csv file is an individual -- some is really organizations -- so some records expectedly don't import because they don't have some required fields. That's what I expect; I mention it only in case this is somehow relevant to why the other records didn't import even though they were reported to have imported successfully.

Is there some log or debugging option that can give me some information as to what's going on?

Thanks; the log file helped me realize that the format for importing data for a Yes/No radio button should be 1/0 instead of strings Yes/No.

I looked at the Error.php that dumped the backtrace, and I wonder why my import didn't end by actually giving me an error. I guess that the errors are intended to be aggregated so that the end report can show successes/failures summed per rows, but somehow this one didn't bubble up.

Sorry; I'd meant also to say that I tried 2.0.4 first, and still encountered the issue.

Peter - Good idea, but not sure what report Chris is pointing u too :-( Maybe he / you can add this to doc (and educate me too!).

Hello,
I am having the same issue with Import reporting success on all rows, but not actually adding/updating the rows in the database.

• My contact matching is set to First Name and Last Name
• My import file contains First, Last, and a Phone Number
• I map First and Last to their respective fields, and map the Phone number to the Phone - Secondary - Phone field in CiviCRM
• All users in the import file already exist as users (I set the import type to Update)

When I run the import it says it's successful, but no additional records are added to the civicrm_phone table in the database.

I have checked all of the log files indicated in this thread (CiviCRM.log as well as the logs associated with the csv file), and there are absolutely no errors reported in any of them.

I am absolutely at a loss and also very concerned because I REALLY need to be able to load our contact data.  I have used import before successfully when creating the Individual records, but now trying to update them is just not working.

Does anyone have ANY ideas about what could be happening?  Or any tricks for enabling additional debug statements so that I can maybe see what the import process is doing?

Any help would be greatly appreciated.

Pretty sure it's an update issue... I can't get Contact update to work no matter what I try.  I finally ended up just deleting all my contacts and reimporting them all with all fields in the same file.

As far as I'm concerned, updating existing contacts via Import is not a function that is provided by CiviCRM.

(And, yes, I upgraded to 2.0.5 during this process and still was not able to get it to work.)

I will try to find some time to do that.  I've seen numerous other posts on these forums that seem to be indicating the same probem.

I was able to recreate on the V2.0 demo site.  I filed a bug.

I had been trying to import Phone numbers, so that's what I recreated on demo.  I realized while recreating that it's possible the bug is specific to Phone numbers... haven't had a chance to try with other fields.  From the number of forum posts about import, though, it seems likely that the problem is not restricted to Phone fields only.

ETA: I should mention that I ran my test on the 2.1 sandbox, and the contact record WAS updated. So, import seems to be working better in 2.1... but that doesn't help all of the 2.0 users right now who need import/update functionality.