• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 359 views
  • Users 0 members are here
Related

Wordfly and Contact Permissions

Former Member
Former Member $organization

HI,

Just wondering if anyone has successfully managed to get unsubscribes to write back into Tessitura from wordfly?  We are trying to get this to work and have hit a stumbling block when it comes to the output sets.  My understanding is they need to have contact permissions included but i'm having a bit of difficulty setting it up.

Any advise greatly received

Thanks

Kerry

Parents
  • $organization

    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

Reply
  • $organization

    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

Children
No Data