Wordfly and Contact Permissions

I've been having the same problems too Kerry so I'm very interested to hear if anyone has gotten it to work.

Historically this has worked.  You should probably get a TASK ticket opened on this.

We've also had quite a lot of difficulty with this - it feels like we've been going in circles with Tessitura and WordFly staff for forever on this issue, but we still aren't getting the data to report back. If anyone has been able to get this to work, I would love to hear how you have this set up.

Has anyone played with LP_UPDATE_EMAIL_PROMOTION? We've been using it with great success. In part, our documentation says the following:

Wordfly is designed to talk to Tessitura via a web procedure called WP_UPDATE_EMAIL_PROMOTION. As part of that standard tessitura procedure, it also calls a local one that we are freely able to modify. That procedure is called LP_UPDATE_EMAIL_PROMOTION. When email blasts are sent, wordfly has the ability to recognize the status of that email

Yes, we've managed to get unsubscribes to write back to a contact permission. I'm not sure what you mean by output sets?

You need to edit LP_UPDATE_EMAIL_PROMOTION with to handle the unsubscribe response (which by default is response_code = 5 but may be different if you're in a consortia):

if @response_code = 5 -- MFES UNSUBSCRIBE/COMPLAINT: set the emarketing indicator on the customer record

-- Change flag on customers' Contact Permissions records to MIAF Email = 'N'
-- The email address flagged for unsubscribe (can affect several customer records with the same email address)
-- are also being unsubscribed rather than just the customer account.

BEGIN
UPDATE TX_CUST_CONTACT_PERM_TYPE
SET answer = 'N',
last_asked_dt = @response_dt
FROM TX_CUST_CONTACT_PERM_TYPE
WHERE type_id = 8 -- MFES Email
and customer_no in (SELECT distinct customer_no from #all_emails)
END

You'll need to update the type_id to your CONTACT_PERM_TYPE.

dgh