David__Garcia

Re: Query for delivery logs and account activation date - Adobe Campaign Classic

I can only suggest that you try running the query and see what you get, only by trying, trial and error, you will learn these different queries. perhaps try on a staging environment, learn the schema attributes available in the delivery schema and look at the list of available functions (https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/filtering-data/list-of-functions.html?lang=en)

Re: Query for delivery logs and account activation date - Adobe Campaign Classic

1- Will fetch deliveries whose delivery code is xyz (not delivery label), so if multiple deliveries happen to be configured with the same delivery code, it will pull records for them also.2- There is no such thing as recipient activation date ootb, unless you add it as a custom field and setup a custom process to update the flag based on a particular action such as email confirmation, double optin, etc etc.

Re: Calculated fields using XML memo data - Adobe Campaign Classic

Thanks!

Re: Calculated fields using XML memo data - Adobe Campaign Classic

@Darren_Bowers @LaurentLam @Marcel_Szimonisz @Adhiyan @Jonathon_wodnicki @CedricRey @Milan_Vucetic @Manoj_Kumar_ @Florian_Courgey @Jean-Serge_Biro

Re: Several Web service modules are getting created in a day in adobe application other than the daily auto restart at 6:00 AM - Adobe Campaign Classic

What version of Adobe Campaign you are running? I noticed this issue on older builds, and it was fixed by updating to the latest version, as a means of automated service recovery, I developed a powershell script to monitor unresponsive neolane services and to hard kill these services and restart them as the server was on premise, this was a possible short mitigation.

148

Calculated fields using XML memo data - Adobe Campaign Classic

Given that I have the following recipient mData/data structure I tried using the following expression in a calculated field and in queryDef as well as [changes/@changeDate] in the where clause to no avail, I have a timestamp stored in the mData field and I need to calculate which records are over 72 hours old. "Iif(Abs([changes/@changeDate] - GetDate()) / 36e5) >= 72, 'Expired','Pending'" The following error is generated 24/12/2021 04:51:43 js6 QUE-370015 The node of path '/changes/@changeD...

Re: Despite receipt failure recipients are retained in the delivery! - Adobe Campaign Classic

These documents may help at understanding delivery failures soft/hard bounces and the retry mechanisms. https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/monitoring-deliveries/understanding-delivery-failures.html?lang=enhttps://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/monitoring-deliveries/understanding-quarantine-management.html?lang=enhttps://experienceleague.adobe.com/docs/campaign-standard/using/testing-and-sending/monitoring-messa...

Re: how to stop spam email from IP 130.248.176.196 ? - Adobe Campaign Classic

This is indeed an adobe campaign instance, you can add emailcenter@crm.magalu.com on your email provider blacklist. Also, there must be an opt-out flag in the bottom of your email? search for it, which updates adobe campaign and you will be automatically excluded from further marketing campaigns. You must have interacted with this website (https://www.magazineluiza.com.br) for them to acquire your email/details information, do you have an accont with them? send out an email to their support team...

Re: Storing data in mData / Memo XML - Adobe Campaign Classic

I was able to get it done by extending the recipient schema and adding more attributes to the new changes element In this way, I can use the following script to access the mData field and store data in an xml format. var recipient = NLWS.nmsRecipient.create( This is a test ) recipient.save();Available fieldsxpath to xml fields [changes/@firstName] However, I cannot get it to work with my JSON variant?var recipient = NLWS.nmsRecipient.create( {recipient:{ email : 'dummy@dummy.com', la...

Storing data in mData / Memo XML - Adobe Campaign Classic

Currently, am using the sqlExec function to access the mData field of the recipient schema to store tmp data such as below, while this works, I do not want to rely on this method. /** store tmp changes in xml field **/ xmlData = '' +'' +'This is a test' +'' +'' sqlExec("UPDATE NmsRecipient SET mData = '"+xmlData+"' WHERE iRecipientId='"+parseInt(ctx.recipient.@id)+"' "); The first test was the JSON method (recipient.comment actually stores the string in the mData field) var recipient = NLWS.nmsR...

Re: Why takes time to update RCH and RCHH multiple times in a loop process in a single execution. - Adobe Campaign Classic

What is RCH?

Re: tracking workflow failing without details - Adobe Campaign Classic

There is another client with the same version and deployment model facing the same issue, I will try to find out if this is a known issue.

Re: tracking workflow failing without details - Adobe Campaign Classic

Whats your acc server version and deployment model? hybrid?

Re: Authorized addresses in urlPermission - Adobe Campaign Classic

look for it using the search function, can't remember exactly which folder. "serverConf"

Re: Authorized addresses in urlPermission - Adobe Campaign Classic

The location path of the serverconf varies depending on version and Operating System, but look for it somewhere inconfig.xml or serverConf.xml C:\Program Files (x86)\Adobe Campaign\Adobe Campaign v7\conf (windows)/usr/local/neolane/nl6/conf/ng/ (linux)you need to whitelist the domain/ip you are connecting to in the section mentioned Here are some support referenceshttps://experienceleague.adobe.com/docs/campaign-classic/using/installing-campaign-classic/additional-configurations/url-permissions....

Re: tracking workflow failing without details - Adobe Campaign Classic

How often is your tracking workflow executing? every 1h?

102

Re: Tracking Workflow taking very long times to execute after GS 11 upgrade - Adobe Campaign Classic

Did you find the root cause?

Re: Filtering Email Bot Activity in Adobe campaign Classic - Adobe Campaign Classic

Given there are virtually unlimited number of domains and email addresses attached to them, bots are engineered to crawl email links in an attempt to find malicious links, there are virtually limitless number of bots with different kind of configuration on all email platforms which makes any attempt at detecting bots worthless. You could perform a small scale research by doing the following. Create set of addresses on major email providers (outlook, yahoo, gmail) they will be unmonitored (noone ...

Re: How to read mData data memo field xpath, javascript sqlGetMemo fromXMLString DOMDocument - Adobe Campaign Classic

After a lot of testing trial and error, the following worked; it was the xpath was wrong. var recipientId = 13241267; var x = sqlGetMemo('SELECT mData FROM nmsRecipient WHERE iRecipientId ='+recipientId); var y = DOMDocument.fromXMLString(x); var z = y.root.getValue('/changes/@firstName'); //now works var za = y.getElementsByTagName('recipient')[0].getValue('/changes/@firstName'); //now works

How to read mData data memo field xpath, javascript sqlGetMemo fromXMLString DOMDocument - Adobe Campaign Classic

I am using the data/mData field in the recipient schema to store some data which has the following structure. Here is my script to write the data above to the recipient schema /** store tmp changes in xml field **/ xmlData = '' +'' +'' +'' +'' sqlExec("UPDATE NmsRecipient SET mData = '"+xmlData+"' WHERE iRecipientId='"+parseInt(ctx.recipient.@id)+"' "); Now I want to read the data stored by converting the mData to DOMdocument so that I can use xpath to traverse through the nodes and get the...

Re: Dashboard report - Adobe Campaign Classic

Try recomputing delivery statistics, the how to is listed under this blog https://blog.floriancourgey.com/2019/03/recompute-delivery-stats-adobe-campaign Javascript codevar nmsDeliveryDirtyFlags_tracking = 1; // tracking logs (1) var nmsDeliveryDirtyFlags_messageCounters = 8; // broad logs (1) var flags = nmsDeliveryDirtyFlags_tracking | nmsDeliveryDirtyFlags_messageCounters; // bit operation (2) NLWS.nmsDelivery.RecomputeStats(vars.deliveryId, flags); nmsDeliveryDirtyFlags_tracking and nmsDeliv...

Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId - Adobe Campaign Classic

Thanks Manoj,It was all down to the bloody template which had the wrong target mapping set. both scripts actually work.

Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId - Adobe Campaign Classic

Update 3 Both scripts actually work, after double checking the configuration of my template, the target mapping had been set to nms:subscription rather than nms:recipient which is what the error code was pointing to, I can now sleep in peace.

Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId - Adobe Campaign Classic

Hey Manoj, I've already tried and I get the same error, please see update 2, I am wondering why the audit log states attribute id unknown and to check the definition of the nms:subscription schema, could you please test both scripts on your side and let me know if you get the same error?

102

Re: How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId - Adobe Campaign Classic

@Darren_Bowers @LaurentLam @Marcel_Szimonisz @Adhiyan @Jonathon_wodnicki @CedricRey @Milan_Vucetic @Manoj_Kumar_ @Florian_Courgey @Jean-Serge_Biro

119

How to create and trigger a delivery using js activity webapp / workflow CreateFromModel, PrepareFromId - Adobe Campaign Classic

Hi All,I am working on a preference centre with the aim of notifying users on profile changes so that these can then be approved or cancelled, normally, I would trigger a command from the webapp to start a workflow and submit a few variables to personalize a delivery and execute it, however, I want to test out an alternative way of triggering the notification but I am short in time to go deep into testing and finding out how it works. How do you personalize, and execute a delivery on the fly usi...

136

Re: Error code Momen_Code50_MailBlock - Adobe Campaign Classic

Find out the domain refusing emailsApply for whitelist (if you control your instance's mtas)Get details from refusing domain administrators as to why emails generating from your instance is being refused and request whitelisting.if hybrid solution, then involve deliverability team to act on your behalf and they will find out why email is being refused by the 1% of your population and possibly request whitelisting.Raise a ticket to Adobe Support and get deliverability involved.

Re: How to calculate average number of deliveries - Adobe Campaign Classic

One way would be: query broadlogrcp count by @ID group by DateOnly(@eventDate), refine query by @eventDate on or after DaysAgo(7), add enrichment then use avg() expression on the @count ( such as avg(@count)

Re: Passing a Distinct Workflow Variable to Alert - Adobe Campaign Classic

You can count the records (count(@id) and group by project field on your querydef The plan is to count the records and display the project those belong to RecordsProject25SDPROJ 456712SDPROJ 4567154SDPROJ 485653SDPROJ 6598 Here are some supporting docshttps://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/distinct-opens-and-clicks/m-p/265641https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/xtk-querydef-create-question/td-p/317948https://blog.f...

Re: Adobe Campaign Classic V8 Non Admin user not able to run query on nms recipient - Adobe Campaign Classic

The next issue could be folder rights as the SQL error is doing a join on xtkrights with your two operators (xr.iOperatorId IN (258970, 258974)) ) Can you check the web@default logs and look for an error code QUE-370030 perhaps there are some missing rights on some folders, something like the following QUE-370030 You do not have the rights needed on folder of identifier xxx (documents of type 'Workflow (workflow)') to complete the operation. (iRc=-53) So search for all instances of "QUE-370030 Y...

134

Likes given to

User

Count

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe