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 CiviMember (Moderator: Deepak Srivastava) »
  • What's a good way to bulk remove a membership type
Pages: [1]

Author Topic: What's a good way to bulk remove a membership type  (Read 754 times)

irvken

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 1
What's a good way to bulk remove a membership type
November 26, 2013, 03:36:35 am
What's a good way to remove to bulk remove a membership type that have other membership types that we want to persist. I can't just delete the members and the profile field for membership only allows me to allocate an alternative membership. Do I have to do it direct on the database?

Cheers and TIA

Sean

irvken

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 1
Re: What's a good way to bulk remove a membership type
November 26, 2013, 05:06:56 am
Ok, I'm using Bulk Operations to cancel the memberships, but I'd rather wipe out all record of their ever existing without deleting them on each individual record (of thousands)

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: What's a good way to bulk remove a membership type
November 26, 2013, 09:24:41 am
are you wanting to delete the Membership Type so all Membership records pertaining to that type are wiped? and are you saying that doesn't happen currently?
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

irvken

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 1
Re: What's a good way to bulk remove a membership type
November 29, 2013, 02:15:26 am
No I don't want to remove the membership type I just want to remove the record of having had that membership type at one point from about 200 records, others will retain that membership type. What I've done is cancel the membership for targets, but it still shows the cancelled membership on their record, a constant reminder of a previous huge error on my part ;(

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: What's a good way to bulk remove a membership type
November 29, 2013, 03:17:33 am
Are there any contributions associated with these memberships?

irvken

  • I post occasionally
  • **
  • Posts: 47
  • Karma: 1
Re: What's a good way to bulk remove a membership type
December 16, 2013, 04:26:19 am
No, there aren't.

Apologies for the delay in replying, it's not an urgent problem, and I have someone manually removing them now, but would be a useful technique to know if this ever arises again

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: What's a good way to bulk remove a membership type
December 16, 2013, 03:26:26 pm
I should have been more precise in my question about contributions.  The critical question is "Was this membership created at the time a contribution was processed?"  If the answer is "yes" then deleting the memberships will probably result in deleting the contribution as well.  (I speak from experience. We had a contribution form that include one compulsory paid membership and another optional no-cost membership - deleting the no-cost membership deleted the contribution also.)

As there are no contributions associated with these membership  you can do a bulk delete of the memberships using the action Delete members available to you after doing a Find Members search  (or an advanced search set to display results as memberships).

I know it says Delete Members, but it won't, it will only delete the memberships  (see http://issues.civicrm.org/jira/browse/CRM-13764).  I have just used it myself to delete 1672 memberships and I can assure you that the contacts are still there.

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: What's a good way to bulk remove a membership type
December 16, 2013, 03:59:54 pm
There was a discussion (which I lost) about calling Find Members etc Memberships to help avoid this confusion and to underline the concept that Contacts have Membership records. Ah well. Can't win them all
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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • What's a good way to bulk remove a membership type

This forum was archived on 2017-11-26.