since ‎25-02-2020
Online
Darren_Bowers
MVP
Re: Need Help with Looping in JS for a usecase
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
@akashaj7696 - you mention you only want to populat the bestZip (12345) for ID1. If the use case is this simple then just use an Enrichment activity that looks for CCT_ID = "ID1" then set the bestZip value to 12345. If its more complex than this, like you have more than one CCT_ID that you need to look for then you probabaly need to use JS to locate and populate the bestZip for the right CCT_ID. Cheers

Views

4

Likes

0

Replies

0
Re: Need Help with Looping in JS for a usecase
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - I have tried to do this and I found that its easier to write back to another schema than the one you are querying in the queryDef. You can then query the temporary table later in the workflow.I could never get the xtk.session.Write() function to actually work correctly so I used sqlExec() instead. Be careful if you are using user-input values as its not database-safe doing direct DB writes, so you should sanitize the inputs.Also, the write operation seems to affect the cursor i...

Views

43

Likes

0

Replies

2
Re: Scheduled workflow getting executed before the assign...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @Greeshma_Sampath1 - There are a couple of strange time entries in there. The first one is when the workflow ran at 02:31:51 PM - that's almost a 2 minute schedule delay. It could indicate your system is under large performance load.The 20 minute delay at 03:50:12 PM is pretty extreme though.The late starts could also be related to other factors like @craigthonis mentioned or if a workflow killed the Campaign Jobs (operationMgt) workflow and required a restart.CheersDarren

Views

20

Likes

0

Replies

0
Re: Unique Identifier of Email
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @gnals12. If you just delete the data in the BroadLog then the primary key will continue where it left off. Its a database sequence and will continue to increase unless you reset it (usually not recommended). Unsure why you want to "clean" the BroadLog. It should be regularly purged as part of the normall instance configuration. You can set the BroadLog history in the configuration. Cheers Darren

Views

13

Likes

0

Replies

0
Re: Administration Node is not showing up
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @gnals12 - The screenshot you showed has the administration folder/node on it.Do you mean the folder is there but you cant access it? If that's the case then talk to your sysadmin - they haven't enabled the admin rights correctly.CheersDarren

Views

16

Likes

0

Replies

0
Re: Add 3 days to script for "Test"
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @drewettj - an easy way to do this is to subtract the last run time from the current time and see if its less than 3 days. e.g. (getCurrentDate().getTime() - getOption("lastRunDate_TECHNICALWORKFLOW").getTime())<=259200000 Date.getTime() returns milliseconds for for 3 days = (3 * 1000 * 60 * 60 * 24) = 259200000 millisecondsCheersdarren

Views

48

Likes

0

Replies

0
Re: Unique Identifier of Email
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @gnals12 - The broadLog primary key (@id) is the unique identifier for a message created in ACC. Every message created (including control, seeds and proofs) will have a unique broadLog identifier. You can find it in the nms:broadLogRcp table.CheersDarren

Views

45

Like

1

Replies

2
Re: How to change a subject line script into an actual subject line in the broadlog
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - a subject that is unique to a recipient can't be stored under the definition for a delivery, because the delivery object doesnt contain all the data per recipient.If you need to see the subject before you send the delivery you can enrich the subject using a formula onto the temporary schema in the workflow. If you need to see the subject after you send the delivery then you can add it to the broadLog as @wodnicki has described below. Cheers Darren

Views

30

Likes

0

Replies

0
Re: How to change a subject line script into an actual su...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
@akashaj7696 - I'm not sure its stored anywhere. I would expect it is calculated on the fly by the SMTP send email function using the data + subject formula and fired off as part of the email

Views

69

Likes

0

Replies

0
Re: ACC not recognizing bracket notation javascript, alwa...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @JoshuelPattersonRM - I tested your code and it works fine in a delivery template.You should probably change the for loop limit to 3 as you only have 2 array items, but otherwise it works fine.CheersDarren

Views

42

Like

1

Replies

0
Re: track mailto: in adobe campaign classic
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @Ketangp - its not actually possible to track a mailto: link since it doesn't open a web browser to the Campaign tracking server. mailto: and tel: links are handled by the mail client natively on the user's local machine or within the browser client.There are some workarounds you can do where you link to a page that opens a mailto: link using Javascript, but the CX on something like that is questionable, but at least it is tracked.CheersDarren

Views

44

Like

1

Replies

0
Re: How to change a subject line script into an actual su...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - I'm not sure what you mean by "try something inside the delivery"? @wodnicki has given you a response above on how to store the computed subject in the BroadLog. Unfortunately this is the only way to retrieve it after the delivery have been sent. Does this help you get what you need? Cheers

Views

120

Likes

0

Replies

0
Re: Get recipients from a API to delivery and send an email
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @ags - Yes you can do this but it would be up to you how you want to treat the incoming targets. You can choose to add them as Recipients in the Javascript, then load them from the Recipient table further in the workflow. You can also save the new targets into a temporary table and again retrieve them as your targets before the send. There are a few options you have available.Typically what you also want to do (whichever way you choose) is have some way to identify them again, either by putti...

Views

75

Likes

0

Replies

0
Re: How to change a subject line script into an actual su...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - you can compute the subject during the workflow and create a workflow attribute to store the subject. Then in the delivery you just put the variable that you computed earlier. This way you can extend the broadLog schema and store the subject so you can find it again in the broadLog. Once common way to see what the email subject you sent was is to use the same text in the HTML or in some preview header text. That way you can pull up the MirrorPageUrl and look at the title in th...

Views

164

Likes

0

Replies

0
Re: How to change a subject line script into an actual su...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @akashaj7696 - You don't mention the context for this or why you need this. Generally speaking, you cant accurately reconstruct the subject line from the template at a later date as you don't know if the data that was used in the targeting for the delivery is still current. If the underlying target data changes, so does the dynamic subject line script.If you store the data attributes used in the subject in the broadLog at the time of the delivery, you could do this accurately as well.If the u...

Views

197

Like

1

Replies

6
Re: Regarding Enterprise ID and Federated ID
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Experience Cloud
Hi @Roxie423 - most of these points can be answered by the corporate/company IT services team. Larger companies will usually use or require Federated logins via Azure AD etc as part of any external integration. Some companies have security policies that require all SaaS offerings use SSO where possible as it helps keep company & customer data secure by disabling service logins (like Experience Cloud) when the directory user is disabled. If you use Adobe ID's then its possible that the user can a...

Views

31

Likes

0

Replies

0
Re: How to use divide "/" function and between (50 to 100...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Since you are converting the targetData attributes to numbers using Number() to perform a calculation (Men-Women)/Men then you need to compare the result of that to a number. If you add the quotes in, it will try to compare a number to a string. You also dont want an if else() statement in the since you only have two options (i.e. between 50 and 100 or everything else). To debug things like this, you can output the calculation part to the email as plain text and see what value you are getting. T...

Views

99

Likes

0

Replies

0
Re: How to use divide "/" function and between (50 to 100...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @alik98709228 - you can try something like this:<% if ( ((Number(targetData.Men) - Number(targetData.Women)) / Number(targetData.Men)) >= 50 && ((Number(targetData.Men) - Number(targetData.Women)) / Number(targetData.Men)) <= 100 ) {...} else {...} %> CheersDarren

Views

94

Likes

0

Replies

0
Re: How to personalized the image link
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @alik98709228 - your HTML is incorrect. You don't have a href value for your anchor tag.Try something like this:ThanksDarren

Views

79

Like

1

Replies

0
Re: How to use greater than '>' to compare to data values
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
I would just use Number() instead of parseInt() in that case. They should do the same as far as the logic goes. Cheers Darren

Views

125

Likes

0

Replies

0
Re: How to use greater than '>' to compare to data values
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @alik98709228 - you don't say what the data type of your attributes are so I'll assume since it isn't working that they are StringsYou can try something like this:<% if (Number(targetData.Men) > Number(targetData.Women)) { %> ... <% } else {} %> or <% if (parseInt(targetData.Men) - parseInt(targetData.Women)) > 30) { %> ... <% } else {} %>https://gomakethings.com/converting-strings-to-numbers-with-vanilla-javascript/CheersDarren

Views

146

Like

1

Replies

4
Re: Error: Credential with service type already exists in...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe I/O Console
We found a fix for the below issue: delete the project and re-create it.It's likely that the issue was caused by the old Project name containing dashes. When I recreated the Project it wouldn't allow dashes as valid characters. There must have been a code change during creation of the project and configuration.Thanks @devconsoleDarren

Views

48

Likes

0

Replies

0
Error: Credential with service type already exists in the workspace
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe I/O Console
I am trying to create two projects for Adobe Campaign Classic to Analytics Triggers using this guide: https://experienceleague.adobe.com/docs/campaign-classic/using/integrating-with-adobe-experience-cloud/experience-triggers/configuring-adobe-io.html?lang=en#adobe-io-prerequisitesI have two servers (Stage & Prod) that use two different Analytics report suites via different Analytics Product Profiles. I have configured the Stage project with an Analytics API / JWT auth no problems and it is worki...

Views

78

Likes

0

Replies

1
Re: Not able to login via adobe-id in Adobe campaign Classic
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi Shashank,Have you configured Adobe IMS connectors within Campaign?https://experienceleague.adobe.com/docs/campaign-classic/using/integrating-with-adobe-experience-cloud/connecting-via-an-adobe-id/configuring-ims.html?lang=en#integrating-with-adobe-experience-cloudThanksDarren

Views

86

Like

1

Replies

0
Re: Need to understand what delivery mode means for exter...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi @dgdg - there is some discussion about Delivery Modes here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/purpose-of-delivery-mode-description-in-external-account/qaq-p/360841Its likely a flag for the Routing to perform certain functions when it processes the delivery send. It seems likely that for Bulk Delivery the send is handled by Campaign and External is where you have to write how the delivery is handled using your own Javascript APIs.ThanksDarren

Views

99

Like

1

Replies

0
Re: Issue saving string value with character > 1023 chara...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Hi@SachinDhir - schema attributes of type string are limited to 1024 characters. If you want to save > 1024 chars then you need to use a memo or html element in your schema.I vaguely remember there was a bug in workflows where you can store > 1024 chars in a memo/html element, but when you try to enrich it onto a workflow it gets truncated back to 1024 characters anyway.ThanksDarren

Views

85

Likes

0

Replies

0
Re: Adobe Campaign Classic Triggers / Analytics product p...
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Analytics
Hi Andrey 🙂Thanks for this - I believe this is part of the setup documentation that is missing. I think I have found this option and also linked the API credentials within the Analytics Profile, but there is also a lot of permissions within the Product Profile that need to be set up.I am assuming that the Triggers API should not be given ALL permissions to the Analytics instance, but I am unsure what permissions we should be giving it as there is no documentation.The legacy Analytics API oAuth ...

Views

63

Likes

0

Replies

0
Re: Configuring Adobe I/O JWT connectors for Triggers
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
Croos posted request in Analytics forum: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/adobe-campaign-classic-triggers-analytics-product-profile/qaq-p/397597

Views

99

Likes

0

Replies

0
Adobe Campaign Classic Triggers / Analytics product profile
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Analytics
I am cross-posting this in the remote chance that someone from Analytics knows the answer to this question.Adobe Campaign Triggers implementation uses Adobe I/O to create the JWT authentication between Analytics and Campaign : https://experienceleague.adobe.com/docs/campaign-classic/using/integrating-with-adobe-experience-cloud/experience-triggers/configuring-adobe-io.html?lang=en#adobe-io-prerequisitesStep 9 in the instructions selects an Analytics Product Profile that has been configured speci...

Views

98

Likes

0

Replies

2
Re: Configuring Adobe I/O JWT connectors for Triggers
Avatar

Darren_Bowers

MVP

Darren_Bowers
- Adobe Campaign Classic
FYI - We are still working out how to do this with Adobe Consulting and Adobe Support - It seems nobody in Adobe knows how to do Step #9 and its crucial to how to set this up or migrate from the legacy connectors.I have multiple requests for better documentation with the Adobe docs team that wrote the documentation which have also not been looked at in Github.If anyone in Adobe knows anything that could help complete this, please reach out via DM and help out Consulting.ThanksDarren

Views

109

Likes

0

Replies

1