LaurentLam

Re: Long SQL-query processing times - Adobe Campaign 03-11-2021

You're absolutely right the max db connection pool seems to be an outdated parameter from V6.02 I used to check before.Regarding your trigger on soaprouter.jsp, you could perhaps use the NLWS.xtkWorkflow.PostEvent() function in order to call a workflow (Call another workflow in Adobe Campaign | Blog by Florian Courgey)If your trigger is about to retieve and sort data in a jsp page, I would say to use then a workflow that will aggregate / calculate every needed data in a single schema (that would...

337

Re: Long SQL-query processing times - Adobe Campaign 03-11-2021

Hello, using SQLSelect from the jsAPI is too avoid in most cases:as this is considered as SQL injection, ACC does not take it in consideration in the cnx pool for handling requests and preventing deadlocks (cf dbcnx attribute in the serverConf file).Related to the JS engine memory it can also creates issue depending of the amount of data retrieved by the SQL request. That's why we usually put an arbitrary max of 10000 rows when using a queryDef (that is ran with the CNX pool) and paginate over i...

345

Update activity and NOT changing dimension - Adobe Campaign 22-10-2021

DescriptionToday when we use an update activity in a workflow, we force the targeting dimension to change from the actual dimension to the one set in the update activity. It would be great to be able to NOT change automatically the targetting dimensionWhy is this feature important to youThis feature would help to have, visually, a less complex workflow and to encourage best practices in order to use this OOTB activityHow would you like the feature to workA checkbox option, in the update activity...

144

Re: Web Tracking Tags Vs Tracking Clicks under Tracking Logs - Adobe Campaign 21-10-2021

As you can see, web tracking is unsupported in V8:Campaign Classic v7 - Campaign v8 capability matrix | Adobe CampaignThis said, you can implement it on your 6.11 version but think about the future: once 6.11 will be unsupported by Adobe (end of extended support in march 2022), you'll have to upgrade your environment.If you're implementing it today, you'll have to upgrade only on V7

293

Re: Storing Images as Blob in Adobe Campaign Classic - Adobe Campaign 20-10-2021

Hard to answer correctly as you do not explain why those requirements.So, yes there's a blob type for attributes Elements and attributes | Adobe CampaignYes, you can use JS in a workflow to read attribute from a schema... But are you really speaking about the JS from a workflow?Yes you can use a workflow to connect to the SFTP, download the image and do what you want on itI know: the answer doesn't help you... ^_^ but without knowing the needs behind, I cannot do better 😛

145

Re: Web Tracking Tags Vs Tracking Clicks under Tracking Logs - Adobe Campaign 20-10-2021

Web tracking tags are HTML code you paste on your website.Basically, you'll then be able to track (through the trackinglogRcp schema) what your recipients are doing after they've clicked in the emailOne of the best example is, imagine you're sending a promotion for sales on your websiteOn a normal basis, you have the tracking about the openers and the clickers...But that's all: there is no direct link between those figures and tracking on the websiteInserting webtracking tag on your website, wou...

305

Re: Identify target emails/users who did not click on the link or URL? - Adobe Campaign 18-10-2021

Yes, just take a quick look on the trackingLogRcp schema... You'll find a link called "URL" that will provide you the URL that was tracked...

166

Re: Dynamic Date in Subject and email body - Adobe Campaign 18-10-2021

Just open the delivery generated by your template and click on "delivery logs": the error message generated at MTA level will be shownIt seems that your onboarding on ACC has not been finished. You should ask for it or you'll be quickly limited as developper, architect or just simple user

386

Re: Dynamic Date in Subject and email body - Adobe Campaign 16-10-2021

If you cannot provide the error message in the broadlog of your delivery, it will be hard to help you

404

Re: Dynamic Date in Subject and email body - Adobe Campaign 15-10-2021

use this function instead of yours:function month_fr(today){ var monthFr:["Janvier", "Février", "Mars", "Avril", "Mai", "Juin", "Juillet", "Aout", "Septembre", "Octobre","Novembre","Décembre"]; var thisMonthFr = monthFr[today.getMonth()]; return thisMonthFr.toString();}Regarding the toLocalDateString it doesn't work because it isn't implemented natively in ACMy function works a bit the same as here:Formatting | Adobe Campaign

411

Likes given to

User

Count

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe