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 CiviCampaign (Moderators: Kiran Jagtap, xavier) »
  • Editing the campaign in existing contributions does not update the activity.
Pages: [1]

Author Topic: Editing the campaign in existing contributions does not update the activity.  (Read 963 times)

WYSS

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Wordpress 3.8
  • MySQL version: 5.5
  • PHP version: 5.3
Editing the campaign in existing contributions does not update the activity.
July 24, 2013, 06:50:49 am
We are just getting CiviCRM up and running. We entered 100s of contributions and then realized the value of Campaigns. So we are back tracking a bit by going back to edit the contributions and associate them with a campaign we set up. The problems seems to be that it is not updating the activity when we edit the contribution. So when we run the activity report by campaign the contributions will not show up. If we recreate the contribution it works fine and will show up in the activity report.  Maybe someone knows why this is happening. We appreciate any help that would save us from recreating all the contributions. Thank you in advance.



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: Editing the campaign in existing contributions does not update the activity.
July 24, 2013, 01:49:24 pm

i would compare the DB records when u create a new contribution with a campaign vs editing an existing contribution. that will give you a clue as to whats happening and why

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

WYSS

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Wordpress 3.8
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Editing the campaign in existing contributions does not update the activity.
July 24, 2013, 06:04:14 pm
Thank you for your quick response. I did check the activities table like you suggested and the campaign id is not updating. The campaign id stays null even after the update. I went on the demo sight and got the same results. If I create a new contribution and assign it to a campaign id and then save, I can go to the Activity Report and filter by that campaign and the contribution activity will show up. If I create a contribution, save it and then go back and edit it by assigning it to a campaign, that activity will not show up in the Activity Report. I am new to CiviCRM (and very appreciative for CiviCRM) and I thought the Activity Report would be where you would see the whole picture of your campaign...all the activities together, but maybe there is something I am not understanding.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Editing the campaign in existing contributions does not update the activity.
July 24, 2013, 06:55:56 pm
The Activity Report is indeed meant to provide a "complete" picture of your campaign (although it would be great to see 1 or more dedicated Campaign reports IMO). This is a bug / missing feature in the contribution update logic. If you only need to reference 1 (or a few) campaigns  in your 'historical' contributions (the ones you've already entered), one approach might be to update civicrm_activity.campaign_id directly in the DB.

Going forward it would be good to get this fixed. You can file a bug report in the issue tracker AND if you have tech resources to investigate and submit or suggest a patch that would be great.
Protect your investment in CiviCRM by  becoming a Member!

WYSS

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Wordpress 3.8
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Editing the campaign in existing contributions does not update the activity.
July 25, 2013, 06:28:30 am
Thank you for this information. I entered the campaign id directly into the activities table and that works. I will report the issue as suggested. I would love to see this fixed in the future. When you have multiple people entering data there is always a need to go back and edit. This fix would ensure that the end report is accurate with all details included.

Thanks again...very much appreciated!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCampaign (Moderators: Kiran Jagtap, xavier) »
  • Editing the campaign in existing contributions does not update the activity.

This forum was archived on 2017-11-26.