• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 56 views
  • Users 0 members are here
Related

Lifetime Memberships & Fixed No. of Memberships

Simon Davidson
$organization

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!

  • $organization

    Unknown said:

    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.

    What if you give it an expiry date, but set it far into the future, e.g. 01/01/2100 or some such? The membership update utility would probably leave the records alone, plus a date like that would make the records easy to find.

  • $organization

    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).

  • $organization
    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

    * * * * *

    "Tornado Alley will blow you away," said Pioneer Press movie critic Chris Hewitt about the new Omnitheater film. Audiences will ride along with storm chasers in the Tornado Intercept Vehicle (TIV) and experience "how thrilling it can be to chase after big storms." Make plans to see Tornado Alley in the Omnitheater, and see the TIV in the lobby of the Science Museum.  Reserve your tickets and watch the trailer at www.smm.org.

    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829
    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!