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 Import (Moderator: Yashodha Chaku) »
  • Can't import contributions even though it worked fine once today!
Pages: 1 [2]

Author Topic: Can't import contributions even though it worked fine once today!  (Read 4840 times)

LoganBear

  • I post occasionally
  • **
  • Posts: 44
  • Karma: 1
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.67
  • PHP version: 5.3.28
Re: Can't import contributions even though it worked fine once today!
September 13, 2011, 10:19:15 am
Was this resolved?  I'm getting the same results and wondered if the problem had been fixed somewhere. 

miko

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 2
  • CiviCRM version: 3.4.5
  • CMS version: Drupal 6.22
  • MySQL version: 5.0.77
  • PHP version: 5.2.11
Re: Can't import contributions even though it worked fine once today!
September 13, 2011, 12:40:10 pm
I couldn't get anyone to help me because I couldn't easily anonymize our data and I know if I create a whole new small record set from scratch, it'll work.  I think there's a character- visible or hidden- which is the culprit.  I got so depressed that no one here had a clue, I gave up for a while, but I need to get back to it.  I'm going to try re-exporting the data from the source database, but with fewer fields this time.

My reading online tends to indicate that the importer needs everything created as and set to a certain character set- I think it's UTF-8.  And that it needs full records- where the last field in each record is always populated.

I *DID* improve SOME imports when I got rid on empty fields at the end of records by adding a column of zeroes, but it didn't help all imports.

Guy Iaccarino

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 5
    • Greenleaf Advancement
  • CiviCRM version: 4.4.10, 4.5.4
  • CMS version: WordPress 4, Drupal 7, Drupal 6, Joomla 3
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Can't import contributions even though it worked fine once today!
September 15, 2011, 12:44:12 pm
I had this problem too, and I think I've figured out what's going on, at least functionally.

I believe the system is hanging (bombing with the error message you described) if you re importing the transactions as new transactions, and one or more of the transactions is already in the database. When I figured out which transactions were already in the database (tedious) and removed them from the transactions I was importing, the import went fine.

As to why the system might be hanging in this situation, I have to leave that to those with more programming experience.
Guy Iaccarino
www.greenleafadvancement.com

lesley

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 1
Re: Can't import contributions even though it worked fine once today!
December 11, 2011, 04:46:52 am
I had this problem until I stopped mapping to civi field "invoiceid" I had some duplicate invoice numbers which "broke" the import. Once I mapped them to "notes' field (which obviously allows dups, all was good and 3,000+ donations imported fine

sjthespian

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 3
    • The League of Professional System Administrators
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.28
  • MySQL version: 5.1.66
  • PHP version: 5.3.3
Re: Can't import contributions even though it worked fine once today!
December 25, 2011, 01:37:03 pm
I just had this same problem and it also turned out to be duplicate transaction ids. I was importing a bunch of membership payments we had taken with square, and it looks like their transaction IDs aren't unique!

It would be nice to have this treated as an import error rather than it partially working and just returning a blank page in the browser. In my case, I find the following in my apache logs:
Code: [Select]
[Sun Dec 25 13:22:30 2011] [error] [client 76.0.201.60] PHP Fatal error:  Call to undefined method CRM_Core_Error::fields() in /srv/lopsa/www/lopsa.org/sites/all/modules/civicrm/api/v2/utils.v2.php on line 146, referer: https://lopsa.org/civicrm/contribute/import?_qf_Preview_display=true&qfKey=a1496a13654706a4ab529822dc0f524e_2640
Dan Rich <drich@lopsa.org>
    Director, LOPSA - http://lopsa.org/

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can't import contributions even though it worked fine once today!
December 25, 2011, 07:02:50 pm

any chance one of u'll can investigate and file a patch that addresses and fxes this bug

We can help u get started on IRC

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

questions

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 2
  • CiviCRM version: 4.4.6
  • CMS version: Durpal, 7
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Can't import contributions even though it worked fine once today!
March 08, 2012, 04:14:47 pm
I too just hit upon this problem.  Not sure if a bug got file or if anyone is working on it.  I'm pretty sure the import works correctly on duplicates with contacts so it would seem like the code to handle the dups already exists, just not being called or customized for contribution data.

I suppose there is probably some other way for me to see if this fell into a black hole or is on the radar.

Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Can't import contributions even though it worked fine once today!

This forum was archived on 2017-11-26.