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.
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
From: Suzanne Bridger <bounce-suzannebridger5228@tessituranetwork.com> Sent: 3/30/2009 11:06:09 AM
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!
Thank you so much!
Sabina
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Monday, November 02, 2015 3:40 PM To: Sabina Spilkin Subject: Re: [Tessitura Technical Forum] Attributes
Absolutely! We've got a few of those.
Basically, you would set it up in T_KEYWORD like any regular old attribute except don't fill out anything for the columns that start with Ref. So nothing in Ref Tbl, Ref Idcol, Ref Desccol, Ref Where, or Ref Sort.
For example, we created one to track Disability type with a free text field and in T_KEYWORD this is how it looks:
Description: Disability Data Type: String Edit Mask: Alphanumeric Detail Tbl: TX_CUST_KEYWORD Detail Col: !.key_value Ref Tbl: (blank) Ref Idcol: (blank) Ref Desccol: (blank) Ref Where: (blank) Ref Sort: (blank) Category: Constituent Use For List: Attributes Multiple Value: unchecked etc... with pretty much everything else blank.
There's also great info about that table if you find the help documentation for your Tess version on T_KEYWORD.
Hope that helps!
From: Sabina Spilkin <bounce-sabinaspilkin7252@tessituranetwork.com> Sent: 11/2/2015 4:28:35 PM
Hello Tessiturians!
Is it possible to create an attribute where value is NOT defined by a pull-down list - just a text entry.
Thank you so much,
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!
What was the name of this attribute?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sabina Spilkin Sent: Tuesday, November 03, 2015 11:21 AM To: Sabina Spilkin Subject: RE: [Tessitura Technical Forum] Attributes
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!