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) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • List of new group subscribtion / unsubscription
Pages: [1]

Author Topic: List of new group subscribtion / unsubscription  (Read 581 times)

samuelsov

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 2
    • Coop SymbioTIC
  • CiviCRM version: 3.x, 4.x
  • CMS version: Drupal 6 & 7
List of new group subscribtion / unsubscription
December 05, 2014, 09:49:12 am
I'd like to be able to create a report of all recent group subscription / unsubscription.
I think just adding a date in civicrm_group_contact that store the date of the latest status change should be enough to let people build search or report.

Also, not my priority but it could be good to also be able to see a trend of how many subscription / unsubscription there is in a group over time.
For this one, we might need to have a full history of the changes. It could be done with a table "civicrm_group_contact_history" with columns : id, foreign key to civicrm_group_contact,  state change, date of state change. If we do so, it could also answer the first need.

Does those changes make sense in the core or is it better to make an extension for it ?
Is there a better way to do it ?
Consultant @ SymbioTIC.coop

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: List of new group subscribtion / unsubscription
December 05, 2014, 10:04:10 am
Hi samuelsov,

There's already a table that stores this, civicrm_subscription_history.  I think I have an extension that does this, let me know if you want me to post it on Github.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

samuelsov

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 2
    • Coop SymbioTIC
  • CiviCRM version: 3.x, 4.x
  • CMS version: Drupal 6 & 7
Re: List of new group subscribtion / unsubscription
December 05, 2014, 10:19:18 am
Thanks JonGold, i was not aware of this table.
Yes please, it could be good to share your extension on github.

If the table is already there, I think we should be able to do search or report on it so i think it should be added to core CiviCRM.
Consultant @ SymbioTIC.coop

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: List of new group subscribtion / unsubscription
December 05, 2014, 10:50:16 am
Hi samuelsov,

Here you go! https://github.com/PalanteJon/org.cpehn.subscriptionhistory
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

samuelsov

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 2
    • Coop SymbioTIC
  • CiviCRM version: 3.x, 4.x
  • CMS version: Drupal 6 & 7
Re: List of new group subscribtion / unsubscription
December 05, 2014, 11:04:51 am
Whoa, thanks a lot !
Consultant @ SymbioTIC.coop

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • List of new group subscribtion / unsubscription

This forum was archived on 2017-11-26.