CiviCRM Community Forums (archive)

In April I was at the User/Administrator's training in San Francisco and one of the trainers helped me out by adding a hook that allowed the custom data fields that I had added to contact information show up as fields that I could choose to make visible when I run an activity report. When I export the report to CSV these custom fields appear as columns on the spreadsheet but there is no data below. None of the information added to theses custom fields ever makes it to the reports. Does anybody know what I can do to fix this?

Thank you so much in advance for you help!

Maddie
National Clearinghouse on Abuse in Later Life

Here is the message from Michael McAndrew describing what was done:

You wanted to be able to search for activities based on custom data that extends the contact (as well as custom data that extends the activity). To do this I needed to customize a php file.  I followed the best practice for customising php files, which is...
 
1) create a new folder for you customisations - I created this at '/home8/wcadvlis/www/ncall_civicrm_custom_files/php/' and told CiviCRM where to find customisations on this screen: http://www.ncall.us/civicrm/admin/setting/path?reset=1
 
2) copy the file you want to customise (in this instance it was civicrm/CRM/Report/Form/Activity.php) to the customisations folder so it ends up at /home8/wcadvlis/wcadv/html/ncall_civicrm_custom_files/php/CRM/Report/Form/Activity.php
 
3) edited line 41 of the file...
 
It used to read
    protected $_customGroupExtends = array( 'Activity' );
It now reads
    protected $_customGroupExtends = array( 'Activity', 'Contact', 'Individual', 'Organization' );


So now when I go to run a report I have the option of turning this custom data on and when I export the report to CSV the custom data fields show up as columns on the spreadsheet but none of the data that has been inserted into these custom fields in the contact information shows up below. However, custom fields and data from activities DO appear.  Any idea what could be happening?

Thank you so much.

Yes, he was very sweet and mighty helpful!

No, just like in the spreadsheet, the columns appear but the data that corresponds with these fields is nowhere to be found.

Here is a description of the 5 screen-shots attached to these few posts:

1. The custom data settings for this set
2.  The settings for one of the custom fields within the set
3.  An empty new-individual form with the custom set (Grant Reporting Information) expanded
4. The report criteria I can choose from when I go to run a report with the custom set expanded and the fields within the set checked.
5. A test report with the custom fields from the set appearing (Discipline, If Other, specify, OVW Relation) with the data excluded. (Should read "Adult Protective Services" under discipline for this particular contact)


I am able to get to our database with a database management tool although I may need to call reinforcements.

Any ideas?

Again, thank you for your time.

3

5

Hi Madeline,

hmmm difficult without actually looking at the site (and the code itself). In your screen prints I did notice that the Discipline showed up, both contains no data for the contact? Or is that just a question of the print you made? Still, the column heading should show up. Is there a possibility to get access to the site, or alternatively do you have a support deal with Michael McAndrew so that he can log on to your site?