Which proc/trigger inserts the dates into tx_cust_membership? I have the values in place within t_memb_level to manage the desired date functions for lapsed, suspended, etc. but when we add a gift in our TEST server, I am only seeing the expiration date and initiated date populated. Lapsed, cancel, suspend, etc are not getting populated.
Understood, but when I actually look at the code for the membership update (AP_MEMBERSHIP_UPDATE), I am not seeing any reference to inserting dates, unless I am looking at the wrong procedure. Yes, you are correct about susp_dt and cancel_dt being null but lapsed, renewal, and reinstate should not be.
Thanks.
Matt Winchester Database Administrator Dallas Symphony Orchestra Morton H. Meyerson Symphony Center Schlegel Administrative Suites 2301 Flora Street Dallas, Texas 75201 214-871-4028 - phone 214-953-1218 - fax m.winchester@DalSym.com www.dallassymphony.com
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tom Brown Sent: Tuesday, March 22, 2011 1:27 PM To: Matt Winchester Subject: RE: [Tessitura Technical Forum] How do membership dates get inserted
Matt,
If you are not running the Membership Update Utility you need to get it setup for each membership orginization. We have found that it works best if run at about 11:50pm. Your milage may vary.
That said the columns cancel_dt, susp_dt, are completely empty in our system as well. I do not know if these columns are used. I’d check with support on this issue.
--Tom
From: Matt Winchester <bounce-matthewwinchester1652@tessituranetwork.com> Sent: 3/22/2011 12:52:37 PM
I can verify that but I thought that utility was used to manage the transition from status to status not to actually insert the dates. I will have a look, thanks.
Matt Winchester Database Administrator Dallas Symphony Orchestra Morton H. Meyerson Symphony Center Schlegel Administrative Suites 2301 Flora Street Dallas, Texas 75201 214-871-4028 - phone 214-953-1218 - fax m.winchester@DalSym.com www.dallassymphony.com Error! Filename not specified.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Steve Carlock Sent: Tuesday, March 22, 2011 12:12 PM To: Matt Winchester Subject: RE: [Tessitura Technical Forum] How do membership dates get inserted
Are you running the Membership Update Utility? I think that’s the one that maintains that information.
-steve
Information Technology Manager
Error! Filename not specified.
Santa Barbara Center for the Performing Arts
1330 State Street, Suite 101
Santa Barbara, CA 93101
(805) 899-3000 x 111 (phone)
(805) 899-3081 (fax)
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Winchester Sent: Tuesday, March 22, 2011 8:17 AM To: Steve Carlock Subject: RE: [Tessitura Technical Forum] How do membership dates get inserted
Yes, I have those in place. These are the values that are in t_memb_level.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kendra Struthers Sent: Tuesday, March 22, 2011 9:32 AM To: Matt Winchester Subject: Re: [Tessitura Technical Forum] How do membership dates get inserted
Do you have the rules for lapsed, cancel, suspended, etc. set up for each associated membership level in Test? This can be found under Campaigns/Memberships.
From: Matt Winchester <bounce-matthewwinchester1652@tessituranetwork.com> Sent: 3/22/2011 9:12:06 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!