• Replies 2 replies
  • Subscribers 413 subscribers
  • Views 110 views
  • Users 0 members are here
Related

Extending membership expiration dates

Jacob Houser
$organization

Hello,

Our volunteer guild is changing it's membership period from a start date of July 1 and ending June 30 of the following year to a calendar year, i.e. beginning Jan 1 and ending Dec 31.

This means I need to extend their memberships from and end date of June 30, 2009 to December 31, 2009. Is there a way to automatically do this? I'm trying to avoid having to open each record and manually adjusting the expiration dates.

Any tips would be most appreciated. Thanks!

Jacob Houser

  • $organization

    Hi Jacob,

    If you have access to your database server you can run a query to do that for you.

    UPDATE TX_CUST_MEMBERSHIP SET expr_dt = '12/31/2009' WHERE expr_dt = '6/30/2009'

    WHERE memb_org_no = 'org no of your volunteer guild'

    This is pretty general, but gives you the idea.  You may need to add in more filters such as membership level depending on the membership levels you want to limit this to.

    Kevin.

  • $organization in reply to Kevin Holmes

    Hi Kevin,

     

    Thanks for your response to my question on memberships. I have since manually updated the membership expiration dates, but I will pass your query on to our database administration folks in case we have this issue in the future.

     

    Kind regards,

     

    Jacob Houser

    Development Associate

     

    Omaha Performing Arts

    1200 Douglas

    Omaha, Nebraska 68102

    Tel   402-345-0202

    Fax  402-345-0222

    jhouser@omahaperformingarts.org

     

    For tickets, call Ticket Omaha at 402-345-0606

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Kevin Holmes
    Sent: Friday, July 31, 2009 1:41 PM
    To: Jacob Houser
    Subject: Re: [Tessitura Development Forum] Extending membership expiration dates

     

    Hi Jacob,

    If you have access to your database server you can run a query to do that for you.

    UPDATE TX_CUST_MEMBERSHIP SET expr_dt = '12/31/2009' WHERE expr_dt = '6/30/2009'

    WHERE memb_org_no = 'org no of your volunteer guild'

    This is pretty general, but gives you the idea.  You may need to add in more filters such as membership level depending on the membership levels you want to limit this to.

    Kevin.

    From: Jacob Houser <bounce-jacobhouser9534@tessituranetwork.com>
    Sent: 7/17/2009 3:05:04 PM

    Hello,

    Our volunteer guild is changing it's membership period from a start date of July 1 and ending June 30 of the following year to a calendar year, i.e. beginning Jan 1 and ending Dec 31.

    This means I need to extend their memberships from and end date of June 30, 2009 to December 31, 2009. Is there a way to automatically do this? I'm trying to avoid having to open each record and manually adjusting the expiration dates.

    Any tips would be most appreciated. Thanks!

    Jacob Houser




    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!