CiviCRM Community Forums (archive)

I am trying to import contributions and keep getting "No matching Contact found for (email@domain.com)" when I map the email account to the "External ID (contact matching)" field.

The same input file has already been used to upload contacts, and that worked great.

Is there a way that I can match on email address?

Thanks.  I double checked and didn't see the email field in the contribution import (it was there with contacts, though).  I'm using version 2.0.4.

So instead I updated the external field with the following SQL statement as suggested.  Here's the SQL statement I used if anybody is doing the same thing in the future:

UPDATE civicrm_contact c JOIN civicrm_email e ON c.id = e.contact_id  SET c.external_identifier = e.email WHERE e.is_primary = 1
Interesting side note: the contribution import then worked OK -- sort of.  It seemed to time out, or hit some error, and when it did, it directed me back to /civicrm/contribute/import instead of /en/civicrm/contribute/import (I'm using Drupal with i18n).  This resulted in a "Page Not Found" message on my Drupal site.

I tried again and more records (though still not all) were updated correctly.  I might try breaking the import into very small batches.