since ‎17-05-2018
‎10-12-2019
Alexandros2
Level 2
Re: Target mapping in a delivery cannot read the worktable data Alexandros2 - Adobe Campaign Classic
Thank you Ankur, you had the answer from the start. It was indeed this, in my enrichment the alias did not have the @. I did not realize that was what you were saying before. I also realized that after Vipul's thorough message.How can I mark 3 messages as the correct answer? I really appreciate your time and effort, thank you.
1038
Views
0
Likes
0
Answers
Re: Target mapping in a delivery cannot read the worktable data Alexandros2 - Adobe Campaign Classic
Vipul, first of all thanks so much for your thorough answer.I don't think you should bother installing a different version. We just upgraded our sandbox two weeks ago and I have the same issue.I did notice in your screenshots that the enrichment's column's alias is displayed as '@alexTest', but I don't recall using the @ notation there. It worked fine though. I'll double check that.I will also check other details that you mention in your message in case I'm missing something obvious, and I'll ge...
1010
Views
1
Like
0
Answers
Re: Target mapping in a delivery cannot read the worktable data Alexandros2 - Adobe Campaign Classic
Thank you Vipul for the SQL logs hint, this was very useful.I examined the logs and they seemed to do the correct thing. Here's the INSERT statement during the delivery:INSERT INTO NmsBroadLogRcp (iBroadLogId, iDeliveryId, sAddress, iStatus, iFlags, tsEvent, tsLastModified, iMsgId, sPersadoCampaignName,sPersadoVariationCode,sPersadoGenopediaId,iRecipientId ) SELECT BL.iMessageId, 1136493815, BL.sAddress, CASE WHEN BL.iFailureReason = 0 THEN 6 ELSE 0 END, CASE WHEN BL.iFailureReason = 127 THEN 8 ...
1011
Views
0
Likes
0
Answers
Re: Target mapping in a delivery cannot read the worktable data Alexandros2 - Adobe Campaign Classic
Ankur, could you elaborate a bit? I'm not sure I understand what you mean, especially on the first point.Schema edit shouldn't be needed. I'm adding the proper alias in the enrichment and this adds my column just fine.
1010
Views
0
Likes
0
Answers
Re: Adobe campaign Email tracking Alexandros2 - Adobe Campaign Classic
This is not possible as a tracking feature, not because of any ESP's limitation but because of the way email clients work.Same with forwards. If they forward an email through their email client, you'd have no way of knowing. If they forwarded by clicking an ESP-provided feature "forward this to a friend" and submitting a form, you could track that.Hopefully the replies go back to you, so you could track those through other means.
1224
Views
0
Likes
0
Answers
Re: Target mapping in a delivery cannot read the worktable data Alexandros2 - Adobe Campaign Classic
Bump― would anyone have an insight about this?
1013
Views
0
Likes
0
Answers
Target mapping in a delivery cannot read the worktable data Alexandros2 - Adobe Campaign Classic
Summary: I cannot get my worktable data to get saved to the delivery log (broadLog). I'm using a custom target mapping that uses the [targetData/@fieldName] convention.Detailed Explanation and stepsI have extended the delivery logs schema, nms:broadLogRcp, to include three additional fields that we need to use.I have created this target mapping:And use this in my delivery:Once I run my workflow, I can confirm that the worktable data is there correctly, this is the worktable after the delivery:an...
3175
Views
1
Like
10
Answers and Comments
Re: Personalization block in Email subject Alexandros2 - Adobe Campaign Standard
In case it is of any interest to anyone, I was looking for a solution to this.There is a function called evaluateTemplate() that would have worked for this, but it is not available in the delivery context, but only in a javascript workflow action.So I manually searched and replaced the string that comes with personalization vars, similar to the following:(This assumes that instead of <%= and %> the string comes with %JS_START% and %JS_END%. The reason I do this is that I want to _paste_ this cod...
1202
Views
1
Like
0
Answers
Re: Personalization block in Email subject Alexandros2 - Adobe Campaign Standard
supratim320​ Did you ever manage to find a solution for this issue? I'm facing the same problem. I'm pretty sure that eval'ing the string 'Hi <%= recipient.firstName %>' won't work, so I'm looking into building a search-and-replace kind of solution where I check for probably just '<%='.
1192
Views
0
Likes
0
Answers
Likes given to
Likes from