Hello,
Is there a way to populate global changes to the e-marketing field throughout all the constituents in the database? I want to re-set all the constituent e-marketing fields in the general tab to "no marketing/soliciting" without having to go through every constituent one by one.
Can this be done?
Much obliged,
Tonya
I have never used SQL scripts before, so I don’t know if I have the access or capability. Could you tell me more?
Thanks for replying!
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Ken McSwain Sent: July-10-14 5:45 PM To: Tonya Rae Chrystian Subject: Re: [Tessitura Marketing Forum] Global changes to the e-marketing field in general tab
Hi Tonya
That would be a fairly simple update script in SQL, if you have that capability, but I don't think it's possible in the front end.
Ken
From: Tonya Rae Chrystian <bounce-tonyaraechrystian3504@tessituranetwork.com> Sent: 7/10/2014 5:58:08 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!
If you don't know, then you don't have the access or capability, sadly. That's more of an IT thing - I see that yours is a pretty small org, without internal IT support, so your best option for this sort of thing is to get either your external IT support folks involved, or your Tessitura Network consultant. You certainly can get a lot more value out of Tess if you have access to someone who can do some simple SQL scripting, but it's also kind of dangerous - you can easily break things if you don't know what you're doing.
.. or maybe you should take your helpful neighbour Beth Hawryluk to lunch, and she could tell you how they go about this sort of stuff at the Symphony :-).