Lapsed Memberships becoming Active

Beth,

Tessitura considers lapsed as still active. It is a grace period if you will. They still show up in list builder when you look for current memberships etc... Without changing the rules in your membership table setup, there is no way to put them back to active.

Christian

Beth,

Tessitura considers lapsed as still active. It is a grace period if you will. They still show up in list builder when you look for current memberships etc... Without changing the rules in your membership table setup, there is no way to put them back to active.

Christian

Someone with sql access can edit the TX_CUST_MEMBERSHIP table through the back end, but you should test, test, test, and be very careful that you know what you're updating.

I've done this when a membership has been deactivated in error and then a renewal received, to change the membership from deactivated to inactive and then link the new membership to the un-deactivated one and mark it as a renewal, increase, upgrade, whatever. (I put a note in the membership to explain my meddling.)

So, you could change the expiration dates and status using a sql query.

--to see an affected membership:
select * from tx_cust_membership
where memb_org_no=1 --choose correct membership organization here
and customer_no = #######

--to change status and expiration date:
update tx_cust_membership
set current_status = 2, --active
expr_dt = '2010-12-31 23:59:59.000', --pick your future expiration date here
notes = 'Manually activated and extended membership [date] [initials]'
where customer_no = #######
and memb_org_no=1 --choose correct membership organization here
and current_status=7 --lapsed
and cust_memb_no = ##### --choose correct row with this parameter

/***
select * from tr_current_status

1 Inactive
2 Active
3 Pending
4 Awaiting Payment
5 Suspended
6 Cancelled
7 Lapsed
8 Deactivated
9 Merged

***/

================================
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 Beth Ann Mencher
Sent: Thu 6/11/2009 7:39 PM
To: Lucie Spieler
Subject: RE: [Tessitura Development Forum] Lapsed Memberships becoming Active



Thanks Christian. I was afraid of this. Time to address our membership set up rules, I suppose.

Thanks again for your reply,

Beth Ann





From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christian Mauri
Sent: Thursday, June 11, 2009 4:15 PM
To: Beth Ann Mencher
Subject: Re: [Tessitura Development Forum] Lapsed Memberships becoming Active



Beth,

Tessitura considers lapsed as still active. It is a grace period if you will. They still show up in list builder when you look for current memberships etc... Without changing the rules in your membership table setup, there is no way to put them back to active.

Christian

From: Beth Ann Mencher
Sent: 6/11/2009 5:56:01 PM

Hi All,

How can we make 'Lapsed' memberships 'Active' again for those with multi-year memberships?

We have a few multi-year memberships that may have been extended manually (manipulating the expiration dates) during their Lapsed status. These memberships should be Active now and no longer Lapsed. The Membership Update Utility Report moves Lapsed to Inactive but not from Lapsed to Active.

How is best to change their status? Should we deactivate and add a new membership?

Thanks in advance for your help,

Beth Ann




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!




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!

Thanks very much for this Lucie! I am the one with the SQL access although I am a novice. I will absolutely test this and greatly appreciate your extending the script. We have a more than few of these lapsed confused accounts so if this works it would help us immensely. I will let you know how it works out!
Thanks again,
Beth Ann

________________________________________
From: Tessitura Development Forum [forums-development@tessituranetwork.com] On Behalf Of Lucie Spieler [bounce-luciespieler8144@tessituranetwork.com]
Sent: Thursday, June 11, 2009 6:59 PM
To: Beth Ann Mencher
Subject: RE: [Tessitura Development Forum] Lapsed Memberships becoming Active

Someone with sql access can edit the TX_CUST_MEMBERSHIP table through the back end, but you should test, test, test, and be very careful that you know what you're updating.

I've done this when a membership has been deactivated in error and then a renewal received, to change the membership from deactivated to inactive and then link the new membership to the un-deactivated one and mark it as a renewal, increase, upgrade, whatever. (I put a note in the membership to explain my meddling.)

So, you could change the expiration dates and status using a sql query.

--to see an affected membership:
select * from tx_cust_membership
where memb_org_no=1 --choose correct membership organization here
and customer_no = #######

--to change status and expiration date:
update tx_cust_membership
set current_status = 2, --active
expr_dt = '2010-12-31 23:59:59.000', --pick your future expiration date here
notes = 'Manually activated and extended membership [date] [initials]'
where customer_no = #######
and memb_org_no=1 --choose correct membership organization here
and current_status=7 --lapsed
and cust_memb_no = ##### --choose correct row with this parameter

/***
select * from tr_current_status

1 Inactive
2 Active
3 Pending
4 Awaiting Payment
5 Suspended
6 Cancelled
7 Lapsed
8 Deactivated
9 Merged

***/

================================
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 Beth Ann Mencher
Sent: Thu 6/11/2009 7:39 PM
To: Lucie Spieler
Subject: RE: [Tessitura Development Forum] Lapsed Memberships becoming Active



Thanks Christian. I was afraid of this. Time to address our membership set up rules, I suppose.

Thanks again for your reply,

Beth Ann





From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christian Mauri
Sent: Thursday, June 11, 2009 4:15 PM
To: Beth Ann Mencher
Subject: Re: [Tessitura Development Forum] Lapsed Memberships becoming Active



Beth,

Tessitura considers lapsed as still active. It is a grace period if you will. They still show up in list builder when you look for current memberships etc... Without changing the rules in your membership table setup, there is no way to put them back to active.

Christian

From: Beth Ann Mencher
Sent: 6/11/2009 5:56:01 PM

Hi All,

How can we make 'Lapsed' memberships 'Active' again for those with multi-year memberships?

We have a few multi-year memberships that may have been extended manually (manipulating the expiration dates) during their Lapsed status. These memberships should be Active now and no longer Lapsed. The Membership Update Utility Report moves Lapsed to Inactive but not from Lapsed to Active.

How is best to change their status? Should we deactivate and add a new membership?

Thanks in advance for your help,

Beth Ann




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!




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!


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!

Beth Ann,

You could do what Lucy suggested and update the tables manually, but be careful. When I was just learning, I accidentally changed all the program names to 1 name. Luckily it was the test database. hehe

 

Christian