Is anyone out there using Contact Permissions as part of a WordFly output set (to keep WordFly in sync with what's in Tessitura?) We are on v15.1.4 and I'm onboarding a new consortium organization with WordFly and they're the first ones to try to use Contact Permissions...but if I put the Contact Permission elements into the Output Set, the "could have multiple rows" indicator shows up so WordFly doesn't recognize the output set (at least, I *think* that's why I can't see it in WordFly but I'm not positive that's the reason.)
Any tips/tricks/troubleshooting help you can provide is greatly appreciated.
Thank you!
Hi Mindee, No problem <![if !vml]><![endif]>
Your code looks very similar to ours, which works as expected, for example:
IF @response_code = 5
BEGIN
if exists (select 1 from TX_CUST_CONTACT_PERM_TYPE where customer_no = @customer_no and [type_id] = 1)
begin
update TX_CUST_CONTACT_PERM_TYPE
set [answer] = 'N',
last_asked_dt = getdate()
where customer_no = @customer_no and
[type_id] = 1
end
else
insert into TX_CUST_CONTACT_PERM_TYPE ([answer], customer_no, last_asked_dt, [type_id])
select 'N',
@customer_no,
getdate(),
1
End
My only question would be to check your response code, as the system default is 5, and I notice yours is 26?
We do have a similar issue to you though, in the sense that our hard bounces are not being updated (response code 2), even though they are correctly recorded in Tessitura, my custom code is not triggered. If I trigger this manually it works correctly. In the meantime I am updating hard bounces manually, as we don’t get many. Have you tried running your code manually? I have a script that allows you to do this, if you would like me to dig through my files and find this, let me know if it would be of use? This will at least check that your code works.
You may get 3 similar replies from me on the forum, it didn’t seem to be posting earlier.
Hi, Matt -
That "26" is because each member of the consortium that uses WordFly has their own response code. We finally got it to write back the Unsubscribe correctly but now I'm struggling with trying to use a combination of Contact Permissions and Contact Point Purposes with the WordFly "Preferences" feature. It works, but I'm not happy with *how* so we're trying to tweak our messaging to work around it.
But what I'm wondering is...maybe I ought to tweak LP_WF_PREFERENCE_UPDATE_CUSTOMER instead? Does anyone know whether it's *legal* to set a contact permission to "Yes" if, when facing the "don't unsubscribe, just update your preferences," landing page, they choose to update instead of confirm the unsubscribe? If that's not forbidden, I wonder if I can basically add the preference update code to the purpose update code section?