• Replies 2 replies
  • Subscribers 412 subscribers
  • Views 146 views
  • Users 0 members are here
Related

Deleting a Non-current membership

Former Member
Former Member $organization

Have any of you found a way to delete a membership that is "deactivated"?  We have one constituent whose gift was processed to the wrong fund which created a membership that was incorrect.  The gift was adjusted out accordingly and the membership became deactivated but still shows on their record which may be confusing.  Has anyone else come up with a solution to this?

Thanks! Kristin

  • $organization
    Hi Kristin,

    As far as I know, you're pretty much unable to delete it once the membership has been deactivated.  I do find that making a note in the notes area of that membership is helpful, since they're easily visible when you look at the history tab.  Depending on your business practices, you might consider deleting the membership in such cases before you adjust the gift, so the errant membership won't appear in the history.

    Beth

    * * * * *
    All aboard to experience a legendary journey on the world’s most famous ship.  Titanic: The Artifact Exhibition is now open at the Science Museum of Minnesota.   Log on to www.smm.org/titanic today to reserve your boarding pass.

    Be social!  Find the Science Museum on Facebook, Twitter, MySpace and more.  Log on to www.smm.org/social for more information.

    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829

    ----- "Kristin Smithson" <bounce-kristinsmithson5077@tessituranetwork.com> wrote:
    | From: "Kristin Smithson" <bounce-kristinsmithson5077@tessituranetwork.com>
    | To: bvarro@smm.org
    | Sent: Wednesday, August 12, 2009 9:43:52 AM GMT -06:00 US/Canada Central
    | Subject: [Tessitura Development Forum] Deleting a Non-current membership
    |
    |

    Have any of you found a way to delete a membership that is "deactivated"?  We have one constituent whose gift was processed to the wrong fund which created a membership that was incorrect.  The gift was adjusted out accordingly and the membership became deactivated but still shows on their record which may be confusing.  Has anyone else come up with a solution to this?

    Thanks! Kristin

    |

    |
    | --
    | View this message online at: http://www.tessituranetwork.com/COMMUNITY/forums/p/946/3168.aspx#3168
    | --
    | This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization
    Someone with SQL access can delete the membership. There are a lot of things to check for before doing such a thing, though, to make sure that you are deleting only the correct line in the table.

    I run a query looking for everything in tx_cust_membership for that constituent, then limit the results to the proper membership organization, then to the particular line (using the cust_memb_no, a unique number in the table that identifies the particular record). I then modify that query to delete the record.

    Once you've done the deletion, it is gone.

    For the membership to have become deactivated, someone deactivated it. A better option, if you don't want to keep the record of the bad membership in the constituent record, is to delete it before putting in the new contribution, or, better, to update it properly in the process of making the gift adjustment.

    Lucie

    ================================
    Lucie Spieler
    IT Development and Training Manager
    Editor, Season Program
    Florida Grand Opera
    ---------------------------
    8390 NW 25th Street
    Miami, FL 33122-1504

    305-854-1643 x.1521 phone
    305-856-1042 fax
    800-741-1010 ticket office
    lspieler@fgo.org
    www.fgo.org

    P please don't print this e-mail unless you really need to.

    ________________________________

    From: Tessitura Development Forum on behalf of Kristin Smithson
    Sent: Wed 8/12/2009 10:43 AM
    To: Lucie Spieler
    Subject: [Tessitura Development Forum] Deleting a Non-current membership



    Have any of you found a way to delete a membership that is "deactivated"? We have one constituent whose gift was processed to the wrong fund which created a membership that was incorrect. The gift was adjusted out accordingly and the membership became deactivated but still shows on their record which may be confusing. Has anyone else come up with a solution to this?

    Thanks! Kristin




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!