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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Removing multiple contacts from group
Pages: [1]

Author Topic: Removing multiple contacts from group  (Read 637 times)

mukunojn

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Wordpress
  • MySQL version: Not sure
  • PHP version: Not sure
Removing multiple contacts from group
February 20, 2014, 09:14:24 am
A coworker mistakenly added ALL of our Civi contacts into one of our Groups (subscribers to our journal). Is there a quick and easy way to delete multiple contacts from the Group based on the criteria of date added? I don't want to go through the entire group of 4,000 contacts and hand select who to delete. Make sense?

kennedy

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 5
  • CiviCRM version: 4.5.5
  • CMS version: Drupal
  • PHP version: 5.3.10
Re: Removing multiple contacts from group
February 20, 2014, 10:29:59 am
maybe advanced search can help you, on the change log tab, enter your coworker's name on the modified by field, select the modified option and choose a date range when the change was made.
Hit the search button, you should be able to remove the contacts from the group using the action menu.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Removing multiple contacts from group
February 20, 2014, 10:40:05 am
if the above isn't fine tuned enough - then you would have to change via an sql query in the db - the field involved (from memory) is civicrm_subscription_history
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

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: Removing multiple contacts from group
February 20, 2014, 11:38:35 am
Yes, what Pete said!  For non-technical users, my organization will be developing a report that makes use of the subscription history to search in groups based on add/remove date - but that report won't be developed for another 6 weeks, and it likely will take longer than that before it's ready to distribute.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

mukunojn

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Wordpress
  • MySQL version: Not sure
  • PHP version: Not sure
Re: Removing multiple contacts from group
February 20, 2014, 02:22:03 pm
Quote from: petednz on February 20, 2014, 10:40:05 am
if the above isn't fine tuned enough - then you would have to change via an sql query in the db - the field involved (from memory) is civicrm_subscription_history

What's a SQL query?

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: Removing multiple contacts from group
February 20, 2014, 02:33:03 pm
A SQL query is a pretty technical thing to do - it involves working on the underlying database that stores all the CiviCRM data.  It's definitely not the end-user friendly approach!  Whoever installed CiviCRM for you is likely to know how to handle this - and if not, and you can wait a few weeks, we'll have an extension that handles this precise situation.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Removing multiple contacts from group
June 03, 2014, 04:11:45 am
Hi JonGold
Any news on your extension? Sounds like just the thing I need for a client site.
Graham Mitchell
http://mc3.coop
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Removing multiple contacts from group

This forum was archived on 2017-11-26.