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 CiviContribute (Moderator: Donald Lobo) »
  • contribution export is incomplete
Pages: [1]

Author Topic: contribution export is incomplete  (Read 1216 times)

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
contribution export is incomplete
July 26, 2011, 05:48:17 am
Problem: When I use "Find contributions" without any restrictions 17 contributions found.  When I elect to "export contributions" for all 17 results only 14 results are exported.

Reason: Three contacts have made two contributions each and the export procedure ignores the second contribution for each contact.  This happens even when the only data I elect to export comes from the civicrm_contribution table.

This sounds identical to the problem reported at http://forum.civicrm.org/index.php/topic,11843.msg50826.html#msg50826, however unlike jbachmann in that post, I have just duplicated my results on the 3.4 demo site.

Whilst trawling for the above problem I found this post http://forum.civicrm.org/index.php/topic,15458.msg66255.html#msg66255  and I am wondering if the contribution export also includes a "DISTINCT(contact_a.id)" even though I am not exporting any contact information.  This would certainly cause the problem I have described.

If someone can tell me where I can find the code I will have a look.  I know next to nothing about php, but I do know a reasonable amount of SQL so I might be able to work out what is happening.


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: contribution export is incomplete
July 26, 2011, 08:30:06 am

can you use the drupal devel module to see what the query is for the contribution export. In general export should use the same query as search, but seems from your report,  there is a bug in recent versions of civicrm :(

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

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: contribution export is incomplete
July 28, 2011, 02:23:44 pm
Regression bug affecting Contribution, Participant and Membership exports (probably all component exports). Issue filed:
http://issues.civicrm.org/jira/browse/CRM-8572
Protect your investment in CiviCRM by  becoming a Member!

El.McNab

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
Re: contribution export is incomplete
November 29, 2011, 07:26:23 am
Which patch should be applied here? There's a cross over on issues and it isn't very clear. A point in right direction would be much appreciated.
Thanks,
El

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: contribution export is incomplete
November 29, 2011, 08:38:55 am
If you click the Fisheye tab, the top two commits by Lobo look like they've got the fixes for each component (contribute, membership etc.).
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • contribution export is incomplete

This forum was archived on 2017-11-26.