since ‎30-05-2017
‎06-01-2020
Jean-Serge_Biro
MVP
Re: Trigger a SOAP call once a record is deleted
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Salvatore,I am not sure how to help with your request, perhaps should you elaborate the exact use case you have in mind.If your purpose is linked to an auditing system, you can activate it at RDBMS level (Postgresql, MySQL, SQL Server, Oracle etc auditing capacity) or by implementing a SQL "after" trigger to record whatever you want Usually the logic is to implement the SQL "before" trigger and allow to cancel a request.At the Adobe Campaign side, doing something "after" deletion ("leave" for...

Views

3.3K

Like

1

Replies

0
Re: Email single click opt-in
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Richard,Double optin mechanism is not only recommended by Adobe but European law GDPR as well.Actually,it doesn't mean a landing page mandatory for confirmation, but only clicking on a CTA link in the pre-registration mail received.Regards.J-Serge

Views

966

Likes

0

Replies

0
Re: Export tracking logs of any email sent on request
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Thibault,The default tracking workflow executes every hour by default.So it is not strictky speaking "realtime"; but usually, by explaining this usual process to marketing managers, it is enough to make understandable the delay to get hourly refresh statistics.Reminder: the technical nlserver module (server-side) reads the web server httpd logs and saves the result in database (nms:trackinglog entity/table), but up to a threshold; if there are plenty of httpd logs, it could happen that the tr...

Views

517

Likes

2

Replies

0
Re: Campaign Delivery- Attachment
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Raaghu,Fine:)Regarding the extract file format, it should be another ticket because it is regarding not the delivery attachement.Anyway, to make it short, even I don't understand what means "column wise", when default csv format is not convenient, you can choose txt format in Extract activity, even though putting a .csv extension, it allows for more choices about separators, etc.Regards.J-Serge

Views

1.6K

Like

1

Replies

0
Re: Campaign Delivery- Attachment
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Raaghu,Please do what I mentioned above:1. add a Delivery activity (NOT a continuous delivery), based on a Delivery Template (model) in which you select the To field as population coming from workflow.2. In the wfk delivery activity, click on the 2nd tab (Script tab), then paste this:delivery.attachment.add( {instance.vars.filename} )delivery.hasAttachments = trueThat's all

Views

1.6K

Likes

2

Replies

0
Re: Campaign Delivery- Attachment
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Raaghu,I didn't want to mislead you.In simple case, one extract activity, followed by a delivery activity: just use vars.filename.In complex cases, with several files to attach to the email delivery, or other operation on files (such as compressing and gathering into the zip several files), you can manage it by different variables, storing the factory vars.filename in instance variables to manage the final filename to use for the delivery.But forget these cases if you don't need them.RegardsJ...

Views

1.6K

Like

1

Replies

0
Re: Campaign Delivery- Attachment
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Raagu,In addition of Jon's answer, and because it seems there is not anymore this tip in the documentation regarding attaching files in a delivery, one way of doing it through a workflow is to write this code in the 2nd tab of the delivery activity, from your workflow:delivery.attachment.add( {instance.vars.yourvariable} )delivery.hasAttachments = trueOf course, as Jon mentioned, you can use vars.filename variable.But take care, in such case, the delivery activity must follow immediately the...

Views

1.6K

Like

1

Replies

0
Re: Scan HTML content for URLs and cURL them
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Sorry for published status, I misleaded you, my bad, I am not English native.Please use the nms:delivery.@status or other delivery fields depending of your goal.When you use the Tracking & Images button, it displays the content of the trackingUrl table for a delivery:

Views

756

Like

1

Replies

0
Re: Scan HTML content for URLs and cURL them
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
No, this table contains all url for delivery "published" (through the delivery button Tracking & Images).URL are available until the purge limit (global instance option value) or per delivery, you can define the resources period of validity, and so for url contents it is written in nms:trackingUrl:tsValidity.Please also have a look on nms:trackingUrlInfo for common fields of nms:trackingUrl.In order to select only deliveries sent (being in or progress or completed or stopped etc), you must use t...

Views

743

Like

1

Replies

0
Re: createElement - document.createElement is not a function.
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi szymons,As replied in this post:Scan HTML content for URLs and cURL them it is better/easier to achieve the same by using JS activity with queryDef or Query activity with the table (schema) nms:trackingUrl.RegardsJ-Serge

Views

2.6K

Like

1

Replies

0
Re: Adobe Campaign Classic configuration documentation - Data model
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Hansangy,Please find below Adobe Campaign classic Technical Documentation for data models, English version, valuable for ACC 6.1.1 and 7.0 :Description of the main tables RegardsJ-Serge

Views

1.2K

Likes

0

Replies

0
Re: Scan HTML content for URLs and cURL them
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Szymons,Of course you could manage to use content/html/source and regex expression in Javascript (as Jon Wodnicki explained recently for other purposes).But the easy way is to use the xtk:trackingUrl schema with workflow query activity or Javascript activity (or underlying table in SQL for direct SQL queries) to achieve the same.RegardsJ-Serge

Views

760

Like

1

Replies

0
Re: Campaign Delivery
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Raaghuik,Please click on the "To" link of the delivery form / delivery model form, then change the Target Mapping from Recipients (nms:recipient) to Operators (xtk:operator)RegardsJ-Serge

Views

600

Likes

0

Replies

0
Re: How to load one file at a time from FTP activity in adobe campaign
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Adithya,If you select the checkbox mentioned, it should take only 1 file, but you have no control on which file, there is no place for regular expression (as there is in the file collector activity).It is why I mentioned doing it by Javascript coding if you need a precise control based on file name.Otherwise the easier way is to use the checkbox in the Transfer file activity Planification tab.Regards.J-Serge

Views

1.7K

Likes

0

Replies

0
Re: Schedulers for recurring email send
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Danielle,In your workflow, please use this activity to pilot your delivery recurrent activity: RegardsJ-Serge

Views

513

Likes

0

Replies

0
Re: File transfer error: Unsupported protocol
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi,There is a mistake somewhere.For SFTP you must use the according SFTP type in the External account settings (in Administration/Platform/External accounts).So it will generate the sftp:// protocol in the activity logs; you should use the debug log checkbox in the Transfer file activity to verify it.Please don't mislead with FTP with SSL protocol, ftps://, that is an old way to secure connection but not so secure by now so please forget it; FYI it is managed through External account FTP type, a...

Views

1.2K

Like

1

Replies

0
Re: How to load one file at a time from FTP activity in adobe campaign
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Adithya,At the time being, the ACC workflow activity Transfer File (using FTP/SFTP) can manage to stop after having transferred 1 file, through the Planning tab, with the checkbox Execution planned , then select the checkbox Stop planification as soon as 1 file has been transferred.But you don't have control on what file is taken, based for example on a pattern on file basename, or size or whatever.Moreover the planification being activated, it is not a precise control on what/when it is done...

Views

1.3K

Like

1

Replies

0
Re: Limit for HTTP request via JS activity on workflow
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi David,Are you hosted on Cloud or on Premise?If On Premise, I wonder if your slow performance is due to the machine, the Adobe Campaign configuration, the internal network bandwith or whatsoever.could you manage some CURL script or SOAP UI or Postman tool on the server in order to check response time? So you could know if it comes from Adobe Campaign or not. Do you use a proxy server or direct internet connection? Etc.RegardsJ-Serge

Views

5.3K

Like

1

Replies

0
Re: Seed Address Issue with incorrect FirstName in Email Delivery
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Arvind,With your additional explanations, by now I understand your mistake:because you don't use Firstname standard field (used by the 1st and 2nd tab of Seed address form) but Smart(FirstName) in Additionnal data (targetData XML element). Hence you must fill the value in the corresponding "field" in the 5th tab of Seed address form, by using an XML syntax. The better is to give an alias to Smart(FirstName) so the XML element is clearer. Regards.J-Serge

Views

545

Like

1

Replies

0
Re: Copy of attribute data (or) Loss of data in a schema
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Venur,This question is more related to the underlying database engine (RDBMS) than Adobe Campaign itself.So take care and check carefull,For most database engines (SQL Server, Oracle etc), alter table modify column instruction would loose data if the datatype is not in the same family, and a supersed.For instance, short int to long int, ok but long int to short you could loose values by the casting. The same from varchar(100) to varchar(200), no problem.And from very different types such as i...

Views

553

Like

1

Replies

0
Re: Table created by List is deleted
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Aalokitoaami,Please may you display and check the @expirationDate value (SQL field tsExpiration) of your List (recipient group or other type of list)?The easiest is to add expirationDate field as a column when you display the lists in the User Interface.Usually by default expirationDate is set to be empty, and you can set it to a specific date through the UI. By using the List update activity in the workflow, you don't have to define it usually, but perhaps something has been done for this so...

Views

1.2K

Like

1

Replies

0
Re: Seed Address Issue with incorrect FirstName in Email Delivery
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
In your screenshot, do the 2nd tab blurred correspond to a custom contact table replacing nms:recipient?As in this screenshot of ACC documentation for Seed address:https://docs.campaign.adobe.com/doc/AC/en/CFG_Use_a_custom_recipient_table_Seed_addresses.html In that case, the firstname should be rather filled in the 2nd tab instead.Do you use FDA for custom contact table instead?

Views

432

Like

1

Replies

0
Re: Seed Address Issue with incorrect FirstName in Email Delivery
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Arvindg,Please share a screenshot of your seed address forms so we can be sure that the first name is filled at the right place (of course, blur the confidential information).Thanks

Views

429

Like

1

Replies

0
Re: Issue in delivery when using mirror page url
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Maheswarik,You must use this link from delivery broadlogs (the messages sent really to customers) not from a delivery template.RegardsJ-Serge

Views

2.0K

Like

1

Replies

1
Re: Issue in displaying content of email delivery
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Maheswarik,Most of the time, it happens when the character set differs between your AC instance and your template delivery and/or HTML charset declaration.For instance if your database/AC instance uses Win1252 or ISO8859P13 (or some tables/columns) while the html template/delivery is made with utf8 encoding/charset. Or vice&versa for charsets.In order to be sure, you can check real encoding of your html code by using an editor as Notepad++ or Ultraedit or other editor tools with their encodin...

Views

4.5K

Like

1

Replies

2
Re: Force logout through a workflow
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Dominik,Sorry I don't know at all how to achieve the list of all active connection, most of all with ACS which is an On Cloud environment managed directly by Adobe. The ACS REST API is limited to standard use cases.As for KillSession that seems not supported by ACS nor ACC On Cloud but only ACC in On Premise mode, I wonder how Adobe would allow such list active session; in ACC there is not such function in JSAPI.So for ACC On premise only it would need either a workflow activity "nlserver mod...

Views

1.0K

Likes

3

Replies

0
Re: Force logout through a workflow
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Dominik,Please may you confirm that you are using ACS?For ACC (v6/v7) with OnPremise hosting only, there is an API function of xtk:session:KillSession and this function is the one called in the postSave section of the xtk:operator form.Unfortunately with ACS or ACC Cloud hosting, it seems that you are not allowed to manage the soap/http session by your own, for security reasons (that I can easily understand).RegardsJ-Serge

Views

1.0K

Likes

2

Replies

0
Re: Seed Address Issue with incorrect FirstName in Email Delivery
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Arvind,Please may you share more information?Do your delivery population/target come from:a workflow with delivery contacts defined by the incoming events from a workflow with delivery contacts specified in the delivery a direct deliveryI assume you filled correctly the First name field in the Seed address control (1st tab of your delivery or delivery model)?Actually, it can be a normal behavior, depending on what you did for your seed information. If you didn't fulfill some information in th...

Views

428

Like

1

Replies

0
Re: Add a new costant field with an Import
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Alice,Not in the Upload file activity but in the Update activity, add a new element (here the country code), and in Source Expression type it as static value.RegardsJ-Serge

Views

1.3K

Like

1

Replies

1
Re: Split activity -complementary set is not working correct
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
can you try the 3rd checkbox please ?

Views

8.1K

Like

1

Replies

1