• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 93 views
  • Users 0 members are here
Related

Re-naming a Membership Level

Matthew Hodge
$organization

Here's a question: If I want to re-name a membership level (as in the three-character code), I know it needs to be changed in T_MEMB_LEVEL and TX_CUST_MEMBERSHIP (because you can’t change it in the front-end). But there’s a foreign key constraint that catches you if you change either one of those. Is there a quick and easy way to get around that?

 

Cheers,

 

 

Matt

Parents
  • $organization

    I would not change the 3 letter codes. In either TX_CUST_MEMBERSHIP or T_MEMB_LEVEL.  Particularly if you have membership still active with the old codes.

     

    Also be careful about creating new member level codes.  The documentation notes that they must be unique for your entire system regardless of membership organization.  Some versions of the client did not enforce this uniqueness.

     

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Monica Martin
    Sent: Thursday, May 14, 2015 3:51 PM
    To: Thomas Brown
    Subject: RE: [Tessitura Technical Forum] Re-naming a Membership Level

     

    When we renamed our levels, I inactivated the old levels & created new ones…

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Arthur Curtis
    Sent: Wednesday, May 06, 2015 7:26 AM
    To: Monica Martin
    Subject: Re: [Tessitura Technical Forum] Re-naming a Membership Level

     

    Hi Matt,

         I am in a similar situation and was wondering what you did?

    Arthur

    From: Matthew Hodge <bounce-matthewhodge3604@tessituranetwork.com>
    Sent: 12/1/2013 7:00:34 PM

    Here's a question: If I want to re-name a membership level (as in the three-character code), I know it needs to be changed in T_MEMB_LEVEL and TX_CUST_MEMBERSHIP (because you can’t change it in the front-end). But there’s a foreign key constraint that catches you if you change either one of those. Is there a quick and easy way to get around that?

     

    Cheers,

     

     

    Matt




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

    I would not change the 3 letter codes. In either TX_CUST_MEMBERSHIP or T_MEMB_LEVEL.  Particularly if you have membership still active with the old codes.

     

    Also be careful about creating new member level codes.  The documentation notes that they must be unique for your entire system regardless of membership organization.  Some versions of the client did not enforce this uniqueness.

     

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Monica Martin
    Sent: Thursday, May 14, 2015 3:51 PM
    To: Thomas Brown
    Subject: RE: [Tessitura Technical Forum] Re-naming a Membership Level

     

    When we renamed our levels, I inactivated the old levels & created new ones…

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Arthur Curtis
    Sent: Wednesday, May 06, 2015 7:26 AM
    To: Monica Martin
    Subject: Re: [Tessitura Technical Forum] Re-naming a Membership Level

     

    Hi Matt,

         I am in a similar situation and was wondering what you did?

    Arthur

    From: Matthew Hodge <bounce-matthewhodge3604@tessituranetwork.com>
    Sent: 12/1/2013 7:00:34 PM

    Here's a question: If I want to re-name a membership level (as in the three-character code), I know it needs to be changed in T_MEMB_LEVEL and TX_CUST_MEMBERSHIP (because you can’t change it in the front-end). But there’s a foreign key constraint that catches you if you change either one of those. Is there a quick and easy way to get around that?

     

    Cheers,

     

     

    Matt




    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