CiviCRM Community Forums (archive)

Is there anyone out there that would be willing to help us with our CiviCRM and Drupal problems and updates. The current issue at hand, which was responded to by the CiviCRM group is:
Whenever I download the information collected from CiviContribute it doesn't show the In Honor of or In Memory of Information we set up the form to include. This information can be found if you click through to the detail screen, but that's a very time consuming. We just want to be able to have it in the spreadsheet. What step am I missing? I've also tried going through Contact to Contribute but there is even less information available there. Thanks for your help with this.

 
 
Donald Lobo

Administrator
I’m (like) Lobo


Karma: 247
[applaud] [smite]
Online

CiviCRM: 2.2
CMS: Drupal 6.x, Joomla 1.5.x
MySQL: MySQL 5.0.67
PHP: PHP 5.2.6


--------------------------------------------------------------------------------


Posts: 6349






 
 Re: Exporting In Honor and In Memory of Data from CiviContribute

« Reply #1 on: September 14, 2009, 11:59:28 am »
 Quote
 


--------------------------------------------------------------------------------

You will need to write a custom search (http://wiki.civicrm.org/confluence/display/CRMDOC/Custom+Search+Components, php/mysql coding skills needed) to export honor and in memory of information

if you do so, please publish your custom search so other folks can benefit.

Another better option might be to write a custom report for this and expose this information via that. This would be super cool

thanx

lobo
 
 
 
 

 

 

 

 

RE: custom search or report to allow export of this data.... would be great for your or someone to do this. The join is fairly straightforward...

Simple example might be something like this (of course you may need/want more columns):
SELECT d.sort_name as 'Donor Name', c.id, c.total_amount, c.receive_date, h.sort_name as 'Honoree Name'
FROM civicrm_contribution c
LEFT JOIN civicrm_contact d ON c.contact_id = d.id
LEFT JOIN civicrm_contact h ON c.honor_contact_id = h.id

Regarding merge - I did a quick test on 3.0 and the in honor of contribution linkages were moved from the "duplicate" into the merged contact as expected. I would test in your environment with some test data first if you're not on 3.0.

hi jday,

your error free query might be look like :

SELECT
c.contact_id as contact_id,
d.display_name as donor_name,
h.display_name as honoree_name,
c.honor_contact_id as honoree_id,
c.receive_date as receive_date,
sum(c.total_amount) as amount
FROM   
      civicrm_contribution c
      INNER JOIN civicrm_contact d ON d.id = c.contact_id
      INNER JOIN civicrm_contact h ON h.id = c.honor_contact_id
WHERE  d.contact_type = 'Individual'
AND h.contact_type = 'Individual'
AND c.honor_contact_id IS NOT NULL
GROUP BY c.honor_contact_id

kiran

I tried to replicate this search on my site.  I am using CiviCRM 3.1.3.

I copied the attached file to my site into CRM/Contact/Form/Search/Custom/

I registered the custom search component.  I added the custom search to the navigation menu.

When I run the search, I get:

    Sorry. A non-recoverable error has occurred.

    QuickForm Error: the rule does not exist as a registered rule

    Return to home page.

Error Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => QuickForm Error: the rule does not exist as a registered rule
    [mode] => 16
    [debug_info] => Rule 'qfDate' is not registered in HTML_QuickForm::addRule()
    [type] => HTML_QuickForm_Error
    [user_info] => Rule 'qfDate' is not registered in HTML_QuickForm::addRule()
    [to_string] => [html_quickform_error: message="the rule does not exist as a registered rule" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="QuickForm Error: " info="Rule 'qfDate' is not registered in HTML_QuickForm::addRule()"]
)
Can you suggest how to fix this?
[/code]

I changed the date search form fields to:

        $form->addDate('start_date',
                    ts('Contribution Date From'),
                    false, array('formatType' => 'custom' ) );

        $form->addDate('end_date',
                    ts('...through'),
                    false, array('formatType' => 'custom' ) );

and it seemed to work great.  I have one remaining small problem: when I run the search, I have a small section at the top of the results which says:

n Results
Select Records: o All n records  o Selected records only

with a box right below this which is grayed out: more actions - followed by - Go

The problem is that if I select "All n records," the "more actions" box and the Go button are still grayed out.  See attachment for an example.  I have to select the "selected records only" in order to get the "more actions" box to be active, and then I can select "all n records" and the "more actions" box is still active.  What is needed to get the "more actions" box to be active if I just select "all n records?"