Hi all,
Does anyone know of a quick way of updating Constituent Interests based on a list? At the Royal Exchange, we have a list of people who have signed up to email in an external email system and we'd like the Constituent Interests for Data Protection to reflect that.
I've created them as a List in Tessitura so hoped there would be a handy update report (similar to the 'adding an attribute' one). If not, would anyone be happy to share the sql? With Ean Burgon, the only other similar example we found was much more complicated than we need (http://www.tessituranetwork.com/COMMUNITY/forums/t/4082.aspx).
The logic of what we're trying to do is: add a tick to Email_Yes (one of our Constituent Interests) based on a list but leave all the other Constituent Interests the same. It's the logic of 'adding new rows' to the tx_cust_tkw that we're struggling with.
Thanks
Mary
Thanks for this script, worked a treat down here, FYI I did a bulk import of new constituents, saved them as a list then ran the script to update all the users in the list with the required 'interet' updated.