Hi everyone,We are in the process of updating and cleaning our records to conform to the recent Canadian anti-spam laws. We are updating the e-marketing field of our constituents to reflect whether or not they have recently opted into our newsletter. We make the change, save the changes, and then about a week later the file is reverted back to its previous state by dbo. Has anyone else encountered this problem? We need this information to save properly so that we can pull accurate lists. How can I stop dbo from making these changes?Thanks!
No, we don’t have any custom script …
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers Sent: July-25-14 11:58 AM To: Joanne Madeley Subject: Re: [Tessitura Technical Forum] dbo is making changes
Do you perhaps have a custom script in LP_CUSTOMER_RANK ?
From: Joanne Madeley <bounce-joannemadeley8475@tessituranetwork.com> Sent: 7/25/2014 11:38:10 AM
Hi everyone, We are in the process of updating and cleaning our records to conform to the recent Canadian anti-spam laws. We are updating the e-marketing field of our constituents to reflect whether or not they have recently opted into our newsletter. We make the change, save the changes, and then about a week later the file is reverted back to its previous state by dbo. Has anyone else encountered this problem? We need this information to save properly so that we can pull accurate lists. How can I stop dbo from making these changes? Thanks!
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!
If these changes are all happening at the same time, then perhaps it is the work of an errant SQL Server Agent job, or a scheduled utility. If they are happening at different times, perhaps it is the work of an API call when the customers are logging in to the website, or some other user or customer-driven process.
Hi Joanne,
Yes you do have a custom script! I set one up to link TNEW to Wordfly to the client app when I was there a couple years ago. That's probably what's giving you the trouble.
Give me a call and I can walk you through it: 780-401-2549.
Court