Attributes

What is the best way of making an Attribute inactive?

I want old attributes to remain on accounts and I'd like to be able to pull that information through list builder etc, I just want to make sure that they can't continue to be added to accounts. I've looked in the system documentation but inactivating isn't mentioned.

I could mess about in Test and find out for myself but I wondered if anyone knew and could save me the time!

Thanks, Suzanne.

Parents
  • The place to do this is tx_keyword_cust_type

  • Brilliant, thanks for your help.

     

     

    www.glyndebourne.com

    P Please don't print this email unless you really need to.

     

    Glyndebourne Productions Ltd is a limited company registered in England and Wales.

    Registered number: 00358266. Registered office: Glyndebourne, LEWES, Sussex BN8 5UU

     

    Please note that Glyndebourne Productions Ltd may monitor email traffic data and also the content of email for the purposes of security and staff training.

     

    This message contains confidential information and is intended only for forums-technical@tessituranetwork.com. If you are not forums-technical@tessituranetwork.com you should not disseminate, distribute or copy this e-mail. Please notify suzanne.bridger@glyndebourne.com immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Suzanne Bridger therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. The contents of this message may contain personal views which are not the views of Glyndebourne Productions Ltd unless specifically stated.

     


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: 30 March 2009 17:19
    To: Suzanne Bridger
    Subject: Re: [Tessitura Technical Forum] Attributes

     

    The place to do this is tx_keyword_cust_type

    From: Suzanne Bridger <bounce-suzannebridger5228@tessituranetwork.com>
    Sent: 3/30/2009 11:06:09 AM

    What is the best way of making an Attribute inactive?

    I want old attributes to remain on accounts and I'd like to be able to pull that information through list builder etc, I just want to make sure that they can't continue to be added to accounts. I've looked in the system documentation but inactivating isn't mentioned.

    I could mess about in Test and find out for myself but I wondered if anyone knew and could save me the time!

    Thanks, Suzanne.




    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.

  • I tried deleting the customer types in the system tables but this does remove the attribute from the constituent record. 

    I can see that it is still saved information because they come back if you re-add the customer types but I need them to still display in the attribute tab, is there any way of achieving this?

    Thanks again.

  • Hi Suzanne,

    What happens if you go to the system table tx_keyword_cust_type, and make the attribute inactive?

    It should stop that attribute being used, but keep the existing ones against the customer's record.

     

  • Thanks David, I can't believe I've never noticed that there is an inactivate column in that table.  I'm blind and stupid!

  • Hi would you happen to know how to swap one attribute to the other but retain the original attribute value? I need to do this to a list of people. Thanks!

  • Hi would you happen to know how to swap one attribute to the other but retain the original attribute value? I need to do this to a list of people. Thanks!

Reply Children
No Data