Deleting a Non-current membership

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!

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!