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) »
  • Changing PCP Honor Roll status
Pages: [1]

Author Topic: Changing PCP Honor Roll status  (Read 1114 times)

bdanza

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 3
  • CiviCRM version: 3.4.6
  • CMS version: Joomla 1.5, Drupal 6.2x
Changing PCP Honor Roll status
February 08, 2010, 12:07:40 pm
If someone opted out of being on the honor roll for a PCP donation, is there a way to change their status if they change their mind?

B.

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: Changing PCP Honor Roll status
February 08, 2010, 02:03:51 pm
UPDATE: You should be able to modify this by editing their Contribution record. You can find all contributions associated with a given PCP from Find Contributions (select the Personal Campaign page in dropdown bottom left of search criteria). Click Edit for the contribution you need to modify. You should see a checkbox - "Honor Roll" - uncheck that and their name will be removed from Honor Roll.

=============

u'll need to edit the value in the database directly

civicrm_contribution_soft, field: pcp_display_in_roll

lobo
« Last Edit: February 08, 2010, 05:18:26 pm by Dave Greenberg »
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bdanza

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 3
  • CiviCRM version: 3.4.6
  • CMS version: Joomla 1.5, Drupal 6.2x
Re: Changing PCP Honor Roll status
February 09, 2010, 08:43:57 pm
Thanks Lobo,

I am not sure I understand your answer, I looked in the PCP donation records and there is no option for that (3.0.3), so I assume I have to do it all in the DB?

B.

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Changing PCP Honor Roll status
February 09, 2010, 10:10:32 pm
bdanza :
Yes, for 3.0.x you will have to make changes in the db as lobo suggested.
However, in 3.1 you could do it on the contribution form, check for more details :
http://issues.civicrm.org/jira/browse/CRM-4671

HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

bdanza

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 3
  • CiviCRM version: 3.4.6
  • CMS version: Joomla 1.5, Drupal 6.2x
Re: Changing PCP Honor Roll status
February 10, 2010, 12:53:09 pm
Hey guys,

I had some special reporting features on the site i was afraid of breaking, but installed 3.1.1 and it worked perfectly.

Thanks

B.

SueCline

  • Guest
Re: Changing PCP Honor Roll status
February 10, 2010, 02:37:27 pm
I have a similar but slightly different issue; I have a donor who gave via the primary contribution page and elected to not be on the honor role, versus the individual PCP she meant to give through and be on the honor role. I know I could reverse the credit card charge and re-run it correctly, but I'd prefer not to have to do that. Is there a workaround for that option? I tried following the steps above but there is no honor role option if they don't go through a pcp.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Changing PCP Honor Roll status
February 10, 2010, 04:13:33 pm
I think the only 'workaround' is to manually insert a corresponding record in civicrm_contribution_soft table - with the correct contribution_id, contact_id (pcp owner), and pcp_id (pcp page). If you're comfortable w/ SQL, not to big a deal, but otherwise I'd skip.
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) »
  • Changing PCP Honor Roll status

This forum was archived on 2017-11-26.