Memberships in History

One of my colleagues in Development asked me something I'm not entirely clear about:  I have a number of customer records under the Memberships radial button on the History tab that have a Current Status of Inactive but also have the little check mark graphic next one of the memberships.  Does the check mark not mean that it's an active membership or does it merely designate the most recent one regardless of status?

Any advice would be helpful so I can put this woman's fevered mind at rest.

Thank you, Tessiturians.

On this day in history: Coronation of Queen Elizabeth II (1953)

Parents
  • You might want to double-check your Membership Update report schedule.  I believe that utility is what moves your memberships from "active" status to the various other options within that table.  Perhaps you are only running it occasionally, and you've just now stumbled across some records which haven't been updated yet?  We have memberships that expire every day, so the Update report is scheduled to run nightly to avoid just this problem.  (Item #1 on my Next Gen wishlist for membership functionality: don't make us run a utility to get these changes to happen!)

    Beth

    * * * * *

    Get ready for an unforgettable encounter 3,000 years in the making. Tutankhamun: The Golden King and the Great Pharaohs opens at the Science Museum of Minnesota on February 18, 2011, bringing priceless artifacts from the tomb of the Boy King to Minnesota for the first time. Don’t miss this opportunity; visit www.smm.org/tut to purchase tickets today.

    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829


    From: "Bob Bell" <bounce-bobbell2200@tessituranetwork.com>
    To: bvarro@smm.org
    Sent: Friday, June 3, 2011 7:51:26 AM
    Subject: RE: [Tessitura Technical Forum] Memberships in History

    The red checkmark appears next to a Membership on the History/Memberships tab when the cur_record column in the TX_CUST_MEMBERSHIP table row for the Membership has a value of 'Y'.  This indicates that the membership is a Current membership where the status is one of the following:

     

    -- Active

    -- Awaiting Payment

    -- Suspended

    -- Lapsed

     

    For all other Membership statuses, the cur_record value should be 'N' in which case the checkbox should not appear.  Is it possible that Memberships that display the checkbox but which are not in a current status were converted records that may have had the cur_record column imported with the incorrect value?

     

    Network Support will be happy to help you if you find non-current memberships that have a cur_record value of 'Y' and therefore display the checkbox next to the Membership so please submit a TASK help ticket if you need advice.

     

    Bob

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark Steel
    Sent: Friday, June 03, 2011 5:41 AM
    To: Robert Bell
    Subject: Re: [Tessitura Technical Forum] Memberships in History

     

    This is something that we have experienced too. Its like the membership is the active (current one) whilst being inactive as it has expired. This normally comes to our attention when the customer tries to book and their renewed membership is yet to start because the previous one is still active when it should have become fully inactive and the new membership should have started.

    Has anyone else come across this, the reason and is there a solution?

    From: Matt Gonzales <bounce-mattgonzales9808@tessituranetwork.com>
    Sent: 6/2/2011 5:12:52 PM

    One of my colleagues in Development asked me something I'm not entirely clear about:  I have a number of customer records under the Memberships radial button on the History tab that have a Current Status of Inactive but also have the little check mark graphic next one of the memberships.  Does the check mark not mean that it's an active membership or does it merely designate the most recent one regardless of status?

    Any advice would be helpful so I can put this woman's fevered mind at rest.

    Thank you, Tessiturians.

    On this day in history: Coronation of Queen Elizabeth II (1953)




    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!




    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!

Reply
  • You might want to double-check your Membership Update report schedule.  I believe that utility is what moves your memberships from "active" status to the various other options within that table.  Perhaps you are only running it occasionally, and you've just now stumbled across some records which haven't been updated yet?  We have memberships that expire every day, so the Update report is scheduled to run nightly to avoid just this problem.  (Item #1 on my Next Gen wishlist for membership functionality: don't make us run a utility to get these changes to happen!)

    Beth

    * * * * *

    Get ready for an unforgettable encounter 3,000 years in the making. Tutankhamun: The Golden King and the Great Pharaohs opens at the Science Museum of Minnesota on February 18, 2011, bringing priceless artifacts from the tomb of the Boy King to Minnesota for the first time. Don’t miss this opportunity; visit www.smm.org/tut to purchase tickets today.

    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829


    From: "Bob Bell" <bounce-bobbell2200@tessituranetwork.com>
    To: bvarro@smm.org
    Sent: Friday, June 3, 2011 7:51:26 AM
    Subject: RE: [Tessitura Technical Forum] Memberships in History

    The red checkmark appears next to a Membership on the History/Memberships tab when the cur_record column in the TX_CUST_MEMBERSHIP table row for the Membership has a value of 'Y'.  This indicates that the membership is a Current membership where the status is one of the following:

     

    -- Active

    -- Awaiting Payment

    -- Suspended

    -- Lapsed

     

    For all other Membership statuses, the cur_record value should be 'N' in which case the checkbox should not appear.  Is it possible that Memberships that display the checkbox but which are not in a current status were converted records that may have had the cur_record column imported with the incorrect value?

     

    Network Support will be happy to help you if you find non-current memberships that have a cur_record value of 'Y' and therefore display the checkbox next to the Membership so please submit a TASK help ticket if you need advice.

     

    Bob

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark Steel
    Sent: Friday, June 03, 2011 5:41 AM
    To: Robert Bell
    Subject: Re: [Tessitura Technical Forum] Memberships in History

     

    This is something that we have experienced too. Its like the membership is the active (current one) whilst being inactive as it has expired. This normally comes to our attention when the customer tries to book and their renewed membership is yet to start because the previous one is still active when it should have become fully inactive and the new membership should have started.

    Has anyone else come across this, the reason and is there a solution?

    From: Matt Gonzales <bounce-mattgonzales9808@tessituranetwork.com>
    Sent: 6/2/2011 5:12:52 PM

    One of my colleagues in Development asked me something I'm not entirely clear about:  I have a number of customer records under the Memberships radial button on the History tab that have a Current Status of Inactive but also have the little check mark graphic next one of the memberships.  Does the check mark not mean that it's an active membership or does it merely designate the most recent one regardless of status?

    Any advice would be helpful so I can put this woman's fevered mind at rest.

    Thank you, Tessiturians.

    On this day in history: Coronation of Queen Elizabeth II (1953)




    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!




    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!

Children
No Data