Lifetime Memberships & Fixed No. of Memberships

At the Science Museum, we do as Chris suggested: we just set up memberships that expire on 1/1/2090.  We don't have a separate level for them, because we actually want to use the level to clarify expected benefits.  We also give them a constituency of Lifetime Member.  I can't think of any way to automate a limit on the number of people, but having a dedicated expiration date and constituency for it makes it easy to keep track of how many you have at any given time with lists.  Another bonus: if you allow any changes of names on memberships, "lifetime" memberships can become multi-generational unless you have strict controls to keep children from being added to their parents' memberships. Having a set expiration date protects the institution from future claims that benefits need to continue to be offered indefinitely.

Beth

---

From: "Gawain Lavers" <bounce-gawainlavers9512@tessituranetwork.com>
To: bvarro@smm.org
Sent: Tuesday, October 30, 2012 12:18:56 PM
Subject: Re: [Tessitura Technical Forum] Lifetime Memberships & Fixed No. of Memberships

As to the limited number of lifetime memberships: that's a procedural issue, not a technical one: if two solicitors are simultaneously talking to potential members while only one membership remains then the first to file the contribution will get it and the second will be in the embarrassing position of walking back the offer.  The solicitors will have to have their own controls (i.e. reserving a set of memberships for each solicitor and only coming back for more when those have been fullfilled).

From: Simon Davidson <bounce-simondavidson9902@tessituranetwork.com>
Sent: 10/30/2012 11:42:24 AM

Hi,

I'm trying to find out if its possible to have lifetime memberships in Tessitura (i.e. Memberships that don't have an expiry date).  I have tried setting this up in Tessitura and it always throughs a tantrum.  The only way I've found of doing it is by manually deleting the expiry date in the customer history tab.  I suppose I could write a stored proc that deletes this automatically every night for a specific membership organisation, but I was wondering if there is another way of doing this?

Also, this lifetime membership scheme is only going to be open to a fixed number of people, so I was wondering if its possible to make it inactive once a certain number have been sold.  I don't want to rely on agents having to keep count as several agents could be working on this at once.  Unfortunately going over by any amount is not an option as we wouldn't have the merchandise to provide for this particular membership scheme, so a nightly procedure for this probably isn't a brilliant option.

Thanks in advance for any help you can provide!

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!