since ‎11-04-2019
3 hours ago
Milan_Vucetic
MVP
linkedin.com/in/themilanceros
Re: Inserting rows into worktables using APPEND (bulk loa... Milan_Vucetic - Adobe Campaign Classic
Hi @Klaster ,This is nice idea as direct-path insert can perform significantly better than conventional insert.However, there are some constraints here:Data is written directly into datafiles, bypassing the buffer cache;Free space in the table is not reused;Rreferential integrity constraints are ignored. Regards,Milan
29
Views
0
Likes
0
Answers
Re: Multiple Approvers Required- Adobe Campaign Classic Milan_Vucetic - Adobe Campaign Classic
Hi Jordan, I have not tested but check documentation below.In the event of single approval, the transition corresponding to the choice of operator is activated and the task is finished: the other operators cannot reply.In the event of multiple approvals, transitions corresponding to the choice of each operator are enabled. The task is finished when all operators of the group have replied, or when the task has expired.This activity does not block processing, and the workflow can perform other tas...
38
Views
0
Likes
0
Answers
Re: Is it possible to change an image after an email got... Milan_Vucetic - Adobe Campaign Classic
Hi @thibaultb473199 I do not think that mentioned aproach is worth at all. Image is in most cases already downloaded in customer inboxes.This would make sense with new Interactive Email Content with AMP (link).However, let's hear the opinion of others. Regards,Milan
51
Views
1
Like
0
Answers
Re: Tests for Adobe Campaign Classic Upgrade Milan_Vucetic - Adobe Campaign Classic
Hi @EllyLfind a Build Upgrade Checklist for Campaign Classic file on this link.However, you should extend this with a lot of others/smaller checks (public resources upload, login via IMS...)Regards,Milan
137
Views
2
Likes
3
Answers
Get monitor report on email Milan_Vucetic - Adobe Campaign Classic
Hi all,Adobe Campaign offers a nice health report on https://your-domain/nl/jsp/monitor.jsp address.In case you want this report to be sent on your email address, this is one of the ways how to do it.In JavaScript node paste the following lines (adjust bold text): function getToken(url, username, password) {var cnx = new HttpSoapConnection(url);var session = new SoapService(cnx, 'urn:xtk:session');session.addMethod("Logon", "xtk:session#Logon",["sessiontoken", "string", "Login", "string", "Passw...
79
Views
1
Like
0
Replies
Re: Date query Milan_Vucetic - Adobe Campaign Classic
Hi @Ramaswamiexclude id like this:Regards,Milan
74
Views
0
Likes
0
Comments
Re: Date query Milan_Vucetic - Adobe Campaign Classic
Hi @Ramaswami,set up like this:Count(@unique_id)Max(DateOnly(@created_date))@respondent_idRegards,Milan
93
Views
0
Likes
0
Comments
Re: Get records count Milan_Vucetic - Adobe Campaign Classic
Hi @mak_007, you must provide more information or screenshoot of what you maked. Provided aggregation will work for described problem but we cannot see what or how you created everything. Regards, Milan
126
Views
0
Likes
0
Comments
Re: Get records count Milan_Vucetic - Adobe Campaign Classic
Hi @mak_007,add one more Enrichment node and set these:Regards,Milan
150
Views
0
Likes
3
Answers
Re: Custom modifications in delivery Input form Milan_Vucetic - Adobe Campaign Classic
Hi @ramprakasht3196, please test it.If not, try with AddDays(getDate(), 30)Regards,Milan
75
Views
0
Likes
0
Comments
Re: Registering Tracking Servers Milan_Vucetic - Adobe Campaign Classic
Hi @sergio_NYC looks like a small bug.Just empty two fields in Externalize (External account and Instance name) and then de-check Externalize option and make Save.If you ensure that these two fields are emtpy, it will work for you otherwise will show this option enabled.Regards,Milan
84
Views
1
Like
0
Answers
Re: Custom modifications in delivery Input form Milan_Vucetic - Adobe Campaign Classic
Hi @ramprakasht3196you should edit nms:delivery and nms:newDelivery forms.lower or equal to - @your_date_field <= GetDate()equalt to or grater - @your_date_field >GetDate()Regards,Milan
88
Views
1
Like
2
Answers
Re: Help -- Temporary Work Table Limit by Percent of Total Milan_Vucetic - Adobe Campaign Classic
Hi @wpomeroyif understood correctly, you may add one Enrichment node after node (you provided screenshoot) and calculate percent with following formula:(count of CONTACT_ID * 100) / total_base_count - to get percentage per Zip codeFinaly, add one Split node and query percent column (percent which are above 85).Regards,Milan
70
Views
1
Like
0
Answers
Re: IOS Channel Tracking Configuration Milan_Vucetic - Adobe Campaign Classic
Hi @moseenCCthis actualy depends from your arhitecture.Assume that you have separate app and tracking servers for transactional messaging. If yes, then option 3 is correct.Regards,Milan
64
Views
0
Likes
0
Answers
Re: Address substitution in proofs Milan_Vucetic - Adobe Campaign Classic
Hi @stpias you mentioned it works perfectly with Recipient target mapping.However, with "Subscriptions" target mapping you probably getting something like a Cartesian product. Check what are reconciliations keys for mentioned mapping and you will probably identify what cause the issue.Regards,Milan
66
Views
1
Like
0
Answers
Re: Automating Package Movement in Adobe Campaign Milan_Vucetic - Adobe Campaign Classic
Hi @d12kp,here you go:var specfileXml = ' ';var fileName = "location_of_export" + "your_package_name " + formatDate(getCurrentDate(), "%4Y-%2M-%2D %2H:%2N:%2S") + ".xml";var specFile = xtk.specFile.create(specfileXml);var package = specFile.GenerateDoc();saveXmlFile(package, fileName);RegardsMilan
96
Views
0
Likes
0
Answers
Re: Primary Foreign relation in ACM Milan_Vucetic - Adobe Campaign Classic
Hi @abhiseks1679239,cardinality 1-N is created by default always. In order to create 1-1 relation add the following: revCardinality="single"If you want to create ref. integrity consider this: integrity (optional): referential integrity of the occurrence of the source table to the occurrence of the target table. Possible values are as follows:define : it is possible to delete the source occurrence if it is no longer referenced by a target occurrence,normal : deleting the source occurrence initial...
65
Views
0
Likes
0
Comments
Re: Leave element not working as expected | Adobe Campaig... Milan_Vucetic - Adobe Campaign Classic
Hi @rahuladwani you should check:if you updated database structure with your new schema extensionwhy you have one tag more then it is needed in provided code (just after )if form can access provided paths (@campaignType,@campProduct, etc...)try with separate tag for each fieldRegards,Milan
88
Views
0
Likes
1
Answers
Re: Performance Issues in Recomputing logic Milan_Vucetic - Adobe Campaign Classic
Hi @rohanpat,this query is realy "hard" and make recompute for each delivery ever sent. Not sure why you use this, as AC will do it (not in realtime of course).Tracking tables have link to the delivery table and this is a way to fetch impacted Delivery ID.One way can be to use Incremental query to fetch all tracking logs since last execution of the workflow. Based on previously mentioned link, use distinct delivery IDs from result and pass it to your JS script (adapt script to read temp query ta...
193
Views
0
Likes
4
Answers
Re: Using Dynamic Javascript page with API URL call for l... Milan_Vucetic - Adobe Campaign Classic
Hi @hetfiddcheck if your external account is changed or deleted.Data Source : enter the following syntax nms:extAccount:ID of your external database account in the execution instance .As the error says, rtServerInfo.extAccount[0] does not exist. Regards,Milan
59
Views
0
Likes
0
Answers
Re: Display sms content Milan_Vucetic - Adobe Campaign Classic
Hi @tejashriw155148, now is clear what is your requirement. From my perspective, this could be done by editing form and hard coding mentioned text if specific connector is used. However, this is not good solution at all but can be done. For this kind of requests delivery templates are used. Regards, Milan
158
Views
0
Likes
0
Comments
Re: Inconditional stop on workflow - Error message Milan_Vucetic - Adobe Campaign Classic
Hi @noemielebautIf you are sure there is only one server it could be that you had a DNS change (new certificate maybe) or even server name change. It is strange that server or services restart did not helped. You did not mention if there is a load balancer in the architecture.You may try:put directly this endpoint (ibcrmr18.srv-ib.dev) to console and try again. It could be that you currently point DNS entry on IBCRMR18 and something stuckSee on what node workflow stopped. If it is database relat...
85
Views
0
Likes
0
Answers
Re: Adobe Campaign Classic Vocabulary/Definitions Milan_Vucetic - Adobe Campaign Classic
Hi @DMartz unfortunately, you must use ACC general documentation for such thing: Link Here you can find tables descriptions: AC Database parameters Regards,Milan
94
Views
0
Likes
0
Answers
Re: Exception Handling in Javascript Milan_Vucetic - Adobe Campaign Classic
Hi @nitesha38268385assume that you have whitelisted URLwhich you are hitting bellow.Make some debuging by yourself. Call part of this function from the workflow within JS node with logInfo(http.execute()) where you will get more info about exception.Hopefully, the new error you may find in this list: Error codes AC Regards,Milan
106
Views
0
Likes
0
Answers
Re: Negative values in autopk field Milan_Vucetic - Adobe Campaign Classic
Hi @ukender, my sugestion is to open an Adobe Support ticket for this. Of course, update on latest stable build should resolve your problem. There is not too much documentation, but you can swith to some dedicated sequence Id. Check this link: https://helpx.adobe.com/campaign/kb/sequence_auto_generation.html#Switchtoadedicatedsequence Regards, Milan
121
Views
0
Likes
0
Comments
Re: Display sms content Milan_Vucetic - Adobe Campaign Classic
Hi @tejashriw155148 just create an SMS delivery template with prefered connector and put prefered text in the Text content. Whenever you use this template, text will be show automaticaly.Check this link Regards,Milan
192
Views
0
Likes
2
Answers
Re: Negative values in autopk field Milan_Vucetic - Adobe Campaign Classic
Hi @ukenderyou have probably reached maximum for xtkNewId. Instead of reseting (counting from 0 again) you have enabled negative sequence generation.Check this: Link Regards,Milan
136
Views
0
Likes
3
Answers
Re: Converting month to its number Milan_Vucetic - Adobe Campaign Classic
Hi @Raaghuik1996create new column with this expresion:Iif(@column='January','1' , Iif(@column='February','2' ,Iif(@column='March','3' ,Iif(@column='April','4' ,Iif(@column='May','5' ,'Other')))))Adjust source column name and other months.In case you have dates in some column you can use built in function for month number Month ()Regards,Milan
177
Views
0
Likes
1
Answers
Re: Real Time Pricing in Email Milan_Vucetic - Adobe Campaign Classic
Hi @raghavc small update on this topic as Adobe introduced AMP feature to accomplish these things.https://docs.adobe.com/content/help/en/campaign-classic/using/sending-messages/sending-emails/defining-interactive-content.html#targeting-amp-emailRegards,Milan
85
Views
0
Likes
0
Answers
Re: Transpose data adobe campaign classic Milan_Vucetic - Adobe Campaign Classic
Hi @Chinnitry to explore posibilities of Change dimension node in AC.Check this similar example: Pivot and unpivot functions Regards,Milan
98
Views
0
Likes
0
Answers