Author Topic: Imported contributions lost but still there? (Read 1868 times)

prickeke · June 16, 2007, 01:06:15 pm

I think I imported some contributions incorrectly and am now missing them.

I wanted to import a set of contributions for a few users. So I searched for the users and went to the bottom of the summary page where there is a "CiviCRM ID:." I put this in my csv file as the user ID for import. When I imported these 11 records (to 2 or 3 existing contacts) the total amount increased on the main CiviContribute page, along with the "total #" of contributions. However, when I went to the contacts contribution page they were not there. I went to CiviContribute and searched for these contributions, then all contrubtions and they did not show up! The total number found when searching for all contributions is 11 less than what I see on the main CiviContribute page.

Any idea what happened and how I can reconcile these records/assign them to my contacts? I CAN go into the database and delete the records if I am told where to look (if that is the solution).

Also, for future reference, when importing contributions and assigning them to a contact, how should it be done (using ID? Name? Email? etc?).

Thanks,

--
Keith Prickett

Dave Greenberg · June 16, 2007, 06:02:24 pm

When importing "transaction info" for contacts (e.g. Contributions, Event Registrations, Memberships) - it is best to use the CiviCRM (internal) Contact ID as you are doing. This "guarantees" that the transaction will get linked to the correct contact.

There is a bug in 1.7 with regard to Contribution Imports which don't have valid Contribution Type values. The import should reject these records but doesn't (and I believe they behave as you've described - they don't show up in any of the rows returned).

This has been fixed for 1.8:
http://issues.civicrm.org/jira/browse/CRM-1926

If this is your problem - look for civicrm_contribution records where contribution_type_id is NULL or 0. These are your problem records and you can either update them to a valid contribution_type_id value or delete them and start again (check also for related Activity History records for these).

prickeke · June 18, 2007, 01:22:33 pm

Dave,

This was the issue. I specified the contribution type by its name, rather than by the type ID. During import it just ignored the text and happily imported these. The strange thing was that the contact ID was still associated with the record, but they didn't show up when I clicked on contributions by that contact.

I think it would be great (and I suggested this on that bug report) if CiviContribute would accept the text name of the contribution OR the ID.

I couldn't find a good way of looking up the contribution type ID, except for going into the MySQL admin and looking in the tables.

--
Keith

Dave Greenberg · June 19, 2007, 07:03:54 am

Keith - The contribution import DOES expect contribution type "name" - and works fine with those values in my testing. If it does NOT work with contribution type name w/ your import file - please recreate on our demo and file an issue w/ specifics for recreating and a sample data file that triggers/demonstrates the problem.

CiviCRM Community Forums (archive)

News:

Author Topic: Imported contributions lost but still there? (Read 1868 times)

prickeke

Imported contributions lost but still there?

Dave Greenberg

Re: Imported contributions lost but still there?

prickeke

Re: Imported contributions lost but still there?

Dave Greenberg

Re: Imported contributions lost but still there?