kapilKochar
Community profile kapilKochar MVP
Job title here
Melbourne
22 BADGES
MVP

MVP

Learn more
Joined the community 23-01-2019 1:53:14 AM
Offline
Top badges earned by kapilKochar
Customize the badges you want to showcase on your profile
Re: Export leads from Adobe Campaign Classic to Data Ware...
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi ,Please see below if helps.https://experienceleague.adobe.com/docs/campaign-classic/using/integrating-with-adobe-experience-cloud/aep-sources-destinations/export-campaign-data.html?lang=en

Views

34

Like

1

Replies

0
Re: Renaming a File in ACC using Javascript
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi ,Can you please add below function and try if it's works. I am using this function to rename my csv file using JS script in workflow and it's working fine for me. function test(oldName,newName){try{var temp= new File(oldName);temp.renameTo(newName);}catch(e)logInfo("error " + e)}}

Views

88

Likes

0

Replies

0
Re: Link SMS reply to respective delivery
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Sachin, There is a field in inSMS schema call linkedSmsId. you can use this field to set broadlogId. Since it's not auto populated so for this you can create one tech Workflow which links incoming SMS with originating broadlogs. This workflow runs as delta and picks all data from inSMS as first query and then you can add enrichment with rcpbroadlogs join conditions based on extAccountid and messagetype. This will be 1:N, to restrict the output to 1 use data collected as Limit the count in pro...

Views

64

Likes

0

Replies

1
Re: Any experiences of Postgres "full DB vacuum" in a liv...
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi , As per my experience with full vacuums it's definitely helps. we were facing issue where import jobs were taking too much time ~2/3hr and after running this vacuums there was significant reduce of time for import jobs ~ 30min. There are some best practice which you need to follow if you planning for the same. Also, timing for running this is also very important make sure heavy jobs either import or exports workflows are not running at that time and less number of active users. Note : First ...

Views

52

Like

1

Replies

0
Re: Issue in large data export in custom report
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Please refer below I hope this will resolve https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/adobe-classic-report-exports-only-200-rows/qaq-p/311475

Views

125

Likes

0

Replies

1
Re: Distribution of values Behind code
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Manoj, Thanks for sharing this . I was more kind of interested to find out the view they using to display that grid inside form when we click distribution button. Do you know anything around that as well ? Thanks

Views

189

Likes

0

Replies

0
Re: How to log into journal and store open ratio of deliv...
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
working fine for me.. i tested it on my instance.. also you can try to check value for operationid2 by using below for each (var w in winner.operationId2){logInfo("Operation Id is "+w)}

Views

195

Likes

0

Replies

0
Re: How to log into journal and store open ratio of deliv...
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
working fine for me.. i tested it on my instance.. also you can try to check value for operationid2 by using below for each (var w in winner.operationId2)

Views

199

Likes

0

Replies

0
Re: Distribution of values Behind code
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
I checked that already but that form does not explain how grid is coming up on click of this button and how values are getting calculated

Views

188

Likes

0

Replies

0
Re: Issue in large data export in custom report
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
What error are you getting ?

Views

175

Likes

0

Replies

1
Re: can you have more than one input form per schema?
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/is-it-possible-to-have-two-different-input-forms-to-edit-the/qaq-p/112546 Please check this

Views

161

Like

1

Replies

0
Distribution of values Behind code
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Everyone, Can someone please help me to understand from where I can find the code/logic behind "Distribution of values" option we have in query activity

Views

248

Likes

0

Replies

5
Re: How to log into journal and store open ratio of deliv...
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Akash, Try this this should work inside for loop and rest of your code is fine for each (var w in winner.ratio){logInfo("The value of open ratio is " + w);} Thanks,Kapil Kochar

Views

218

Likes

0

Replies

3
Re: Query Subject Line using querydef
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi , var queryDemo = xtk.queryDef.create( fill the condition you want ); To see the result after above code add below codevar output = queryDemo.ExecuteQuery();for each(var rec in output){logInfo(" Subject line "+ rec.@subject)} Thanks

Views

263

Likes

0

Replies

0
Re: Query Subject Line using querydef
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
fill the condition you want

Views

359

Likes

0

Replies

4
Re: Add custom Flow Control nodes
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi , Yes you can add custom nodes by changing xtk:workflow form but since this form is OOB form so you have to be very careful while doing such changes. As you can see below I have added delivery control activity under Flow control

Views

224

Likes

0

Replies

0
Re: Hide part of the text mail body.
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi , If I understand your question correctly, then yes you can use JS code within HTML file. If you have any column which contains user terms then you can use that to create conditional content https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/personalizing-deliveries/conditional-content.html?lang=en#creating-multilingual-email

Views

266

Likes

0

Replies

1
Re: Recipient Versus Distinct Clicks
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hey Luke, Please refer below link to get details of each indicator calculation Tracking indicators Thanks,Kapil

Views

530

Likes

2

Replies

1
Re: Define automatically the folder id in an input form
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Salvatore, I understand what you saying now. I replied based on initial question where you were getting error from that tag under form . I checked the nms:core Navigation hierarchies and over there you can see for nodeModel of recipient,groups and Reports they have used to call another form and there they have might set the folderId Not sure exactly how it is working. But something you can look into .

Views

425

Likes

0

Replies

0
Re: Email Bounce/Alert Report By Domain
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hey Luke, Go to Administration ->Configuration->Reports->Non-deliverables and bounces Thanks,Kapil

Views

417

Likes

0

Replies

0
Re: External file - Target mapping
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hey,Answer to your questions1. Can we track the action performed on the links in the email based on the email id's(as its not part of recipient table) Under Storage tab of External file target mapping you can see message schema is linked with Recipient delivery logs and tracking logs is linked with Recipient tracking logs. So, even if you do not have that email ID in recipient table but still there will be one record for this email ID in nms:broadLogRcp and trackinglogRcp. So yes, you can track ...

Views

375

Like

1

Replies

0
Re: Email Bounce/Alert Report By Domain
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hey , Just thinking out loud , Can you try using one of the workflow for OOB report call "Non-deliverables and bounces". This workflow is using a cube - "Delivery and tracking statistics (deliveryLogStats)" and have one output column name as "@domain_domain" which contains all the domains and breakup of values for each domain. So, try to copy this report and change in such a way after reading data from this cube in next JS activity read the value for each domain and check for contribution percen...

Views

452

Likes

2

Replies

3
Re: Define automatically the folder id in an input form
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Salvdangelo, Just to replicate the issue I have created custom schema for Theme and also one form and navigation hierarchy for this custom schema. Schema Definition: Form : Navigation Hierarchy : Folder created by using above navigation hierarchy and also after creating folder ,click on advance properties and check for template name for me it's 'kkktheme'. This name have to be same in your schema and form screenshot shared above. Using form to enter values , result is below. You can see Folde...

Views

404

Like

1

Replies

0
Re: Create a Predefined Filter
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
That's for Offer... Basically for any query if you want to save it for future use you can save it as filter.

Views

448

Likes

0

Replies

0
Re: Create a Predefined Filter
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Rama, You can create Predefined filter either by using1. Direct option under Profile and Target 2. If you have a query activity which you are using quite frequently and wants to use as Predefined filter then you can save that as well- Click on a query in your campaign workflow, click Edit query and then Save3. Also, if you have any folder on which you have defined any conditions as Restrictions and you want top save that as filter to use on more than one folder then again click on save button...

Views

461

Like

1

Replies

3
Re: If I have multiple typology rules with the same 'exec...
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi stephen, In that case order will play a role to deciding which one to select first

Views

373

Likes

0

Replies

0
Re: Inconditional stop on workflow - Error message
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi ,  can you try below  xtk.worfklow.Stop.Kill Thanks,kapil

Views

405

Likes

0

Replies

0
Re: If I have multiple typology rules with the same 'exec...
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi Stephen, Execution Order is one of the field in nms:typologyRule and default value for this column is 50 that's why you can see lot of '50' .While creating any rules you can change this field value if required. Since,there are different type of rule type like Control rules,Filtering rules,Pressure rules and Capacity rules. If you have two rules with same type defined in typology with execution order like 10 and 20 then rule with order value 10 will execute before 20. Thanks,Kapil

Views

406

Like

1

Replies

2
Re: Edit Unsubscribe Page
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi, You can build your custom rendering using "Form Rendering" section under Administration .Here your webapp is using default "Form Rendering". You can change it to your customized one in the webapp properties. Thanks,Kapil

Views

423

Likes

0

Replies

0
Re: Question about Split workflow into different segments
Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

130 likes

Total Posts

144 posts

Correct reply

45 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
- Adobe Campaign Classic
Hi,Can you check option "keep the results of interim population" and display the result set to see if you are getting expected results for all the different segments. Also check if you are using the same field added in the initial query as a part of additional data for all these record types in the split activity. Thanks,Kapil

Views

350

Likes

0

Replies

0