Hello,
We are updating our email preferences and looking to add keywords to multiple constituents at once.
We are wondering if this is something someone has done recently, seems like there would be a way to do it that just escapes me.
Regards,
Ian McDonnell
Massey Hall & Roy Thomson Hall
Hi Ian - when you mention keywords - are you talking attributes (set up in the system table T_KEYWORD)? If so then there is a standard utility called 'manage attributes' - documentation is here: https://www.tessituranetwork.com/Help_System_v151h/Tessitura.htm#Attributes/Manage%20Attributes%20Utility.htm?Highlight=manage%20attributes
Jo
Thank you for the reply!
I should have been more specific, it is actually the interests created in the TR_TKW system table. We essentially want to take everyone how hand one of our old TNEW_ key words that show in the interest section of the account and add the new interest keyword.
Ian we created a utility to add interests for the exact same reason as you. works exactly the same as the Manage attributes utility - happy to share if you send me your email address.
You are amazing, I just sent you a private message.
Hey Jo
I'd love to have a look as well if that's ok
If you just need some SQL to insert entries into TX_CUST_TKW from a list I can pass that on - it used to be a weekly job when I was matching 2 databases.