Hi Joanne, I agree with Gawain that you may have a script that is scheduled to run at a certain interval via a SQL Job which is making these changes from the backend. It may not help your particular case but to give you an idea how we are coping up with the new Canadian Anti Spam law:
1. We ran an ad-hoc SQL script to set E-Market Restriction to “Unsubscribe” (one of the dropdown choices we have) for all our customers. Then we sent a special news letter to all our customers if they want to opt-in and based on their replies we are re-subscribing them or keeping them un-subscribed.
2. We used to have a SQL script before to run at a fixed interval via a SQL Job to keep the E-Market Restriction and Email Purposes (Constituents>Contact Details>Electronic Addresses>Purposes) in sync (suppose, if a customer has un-checked all the email preferences/purposes from our website, we would mark that customer’s E-Market Restriction to “un-subscribe”). Anyway, we disabled that script as it’s almost impossible to keep these two items in sync – since a customer may have more than one email address and each email address may have different set of email purposes checked whereas E-Market Restriction is for the customer as a whole; in a household more than one person can have the same email address attached to their accounts; and also both E-Market Restriction and Email Preferences can be updated from many different sources – like from the website by the customers, via Box Office, Call centre or Audience & Donor Services users or via Word Fly. If we wouldn’t have disabled that script we would end up having a similar situation like you.
3. Now we are looking for an individual email based simpler solution, keeping the new v12 Constituent Communication functionalities in mind, which is ongoing. I will write another post if we can find a simpler solution and rules to follow.
Best,
Mo
National Ballet of Canada
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers Sent: Friday, July 25, 2014 3:13 PM To: Mohiuddin Faruqe Subject: RE: [Tessitura Technical Forum] dbo is making changes
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.
From: Joanne Madeley <bounce-joannemadeley8475@tessituranetwork.com> Sent: 7/25/2014 1:30:33 PM
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!
-- View this message online at http://www.tessituranetwork.com/Community/forums/p/11970/36963.aspx#36963 or reply to this message -- 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!