since ‎16-03-2020
‎23-10-2020
Ramaswami
Level 1
Re: checking complete audit logs Ramaswami - Adobe Campaign Classic
Can we check where this job exist in Adobe. As per your note it's 90days but i can't able to see 30days back data. Can we check why.
44
Views
0
Likes
0
Comments
Re: Adobe and Twilio integration Ramaswami - Adobe Campaign Classic
Yes @sukrity thanks for the support
31
Views
0
Likes
0
Comments
checking complete audit logs Ramaswami - Adobe Campaign Classic
In the deployment wizard we have an option for storing audit logs for 360days : but if i got to workflow journal and filter the logs of last month it shows 0 messages : can i know where i can see the last months logs of workflows?
78
Views
0
Likes
5
Answers and Comments
Re: unsubscribe header Ramaswami - Adobe Campaign Classic
so basically here is where we need to update the headers in email templates- but my question is how to update them in bulk ? and how to do that in typology rules. can you give us an example.
51
Views
0
Likes
0
Comments
unsubscribe header Ramaswami - Adobe Campaign Classic
How can i include a header in emails? Is there any way to bulk update the templates in email to incorporate the headers for any future emails that are sent out.
77
Views
0
Likes
3
Answers and Comments
Re: Adobe and Twilio integration Ramaswami - Adobe Campaign Classic
What are the partners available for SMPP. Has anyone implemented bulk SMS in Adobe, if so what partners they have used for US. What are the steps involved in that. Can you please suggest?
74
Views
0
Likes
0
Comments
Adobe and Twilio integration Ramaswami - Adobe Campaign Classic
Knowing that Twilio has an options for bulk SMS. Our company uses Twilio for different purpose. Now i wanted to know one thing. If in order to send bulk sms querying from adobe do i need to add a twilio setting OR so i need to call the twilio API for that. All i need to know is does Adobe needs an API or is it just settings that needs to be done on Adobe side to send out bulk SMS messages
148
Views
0
Likes
6
Answers and Comments
Re: Connect to mysql/snowflake databases Ramaswami - Adobe Campaign Classic
Hi Partha, thanks for the video. quick question : without extending can't i directly call snowflake tables in adobe javascript ?
59
Views
0
Likes
0
Comments
Connect to mysql/snowflake databases Ramaswami - Adobe Campaign Classic
Hi Team, How can i connect to mysql/snowflake databases which are outside adobe. Can you please let me know the steps for this. Can i execute snowflake/mysql queries from adobe campaign after configuring in adobe. Can you please let me know if there is any documentation.
127
Views
0
Likes
4
Answers and Comments
Database is full alert Ramaswami - Adobe Campaign Classic
Hi Team, i got an alert from adobe saying that database is full upto 82%. What i am doing is applying some data retention rules on the custom tables. For example : in my prod instance it has lot of custom tables with large data and i am applying a delete based on some criteria. i am using a javascript node : and executing a delete function like below : var delete = "delete from tablename where created date > some date"sqlexec(delete); Note : i am not commiting this. i am doing like this for two ...
101
Views
0
Likes
1
Answers and Comments
onBeforeCall and onAfterCall Ramaswami - Adobe Campaign Classic
I see these two functions used in javascript node and written some code under these functions ( they defined the function ) like for example: in the javascript node of a workflow they added : function onBeforeCall() {logInfo("task.activity:" + task.activity);if ((activity.img.indexOf("nms:activities/delivery.png") != -1) || (activity.img.indexOf("nms:activities/email.png") != -1) || ((activity.img.indexOf("nms:activities/notification.png") != -1) && (task.activity == 'notification'))) { // some ...
96
Views
0
Likes
2
Answers and Comments
Re: Date query Ramaswami - Adobe Campaign Classic
Hi @milan tried like this and it says id should be in group by : 09/03/2020 6:00:51 AM query PGS-220000 PostgreSQL error: ERROR: column "n0.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ATED_DATE, 'America/Chicago')), N0.RESPONDENT_ID, N0.ID FROM... if i keep id in group by it is giving me all the counts like : So for each respondent it is giving me min date of the unique id which is not what we need : here the resp is same but because of group by unique i...
75
Views
0
Likes
0
Comments
how to configure SMS channel Ramaswami - Adobe Campaign Classic
Hi Team, Can any one let me know how to configure SMS channel in Adobe classic. Currently we are only using email channel. Questions : 1. is it chargable if we use SMS channel2. Can we configure this channel or is it Adobe's task to configure for us3. Can you provde me some documentations if we can configure ourselfs.
127
Views
0
Likes
1
Answers and Comments
Re: Date query Ramaswami - Adobe Campaign Classic
can we do a count(uniqueid) inside a query component? can you please show me an example
96
Views
0
Likes
0
Comments
Re: Date query Ramaswami - Adobe Campaign Classic
Nope 😞
59
Views
0
Likes
0
Comments
Re: API Call from javascript node in workflow Ramaswami - Adobe Campaign Classic
thanks @david. it worked now
108
Views
0
Likes
0
Comments
API authentication issue Ramaswami - Adobe Campaign Classic
Hi folks, i am writing a javascript code to get the access token from an API using grant_type = password but i am getting the below error : Results = {"reason":"Unknown grant_type"}HTTP header 'WWW-Authenticate' used for proxy authentication not found. script : var http = new HttpClientRequest("https://api.trustpilot.com/v1/oauth/oauth-business-users-for-applications/accesstoken")var buffer = new MemoryBuffer()buffer.fromString("hrIrJQO0rKQdWSf" + ':' + "AK4ceo", "iso-8859-1");http.header["Conte...
193
Views
0
Likes
2
Answers and Comments
Re: API Call from javascript node in workflow Ramaswami - Adobe Campaign Classic
Thanks @david, it worked but after this when i run the script i am getting the below error : Results = {"reason":"Unknown grant_type"}HTTP header 'WWW-Authenticate' used for proxy authentication not found. script : var http = new HttpClientRequest("https://api.trustpilot.com/v1/oauth/oauth-business-users-for-applications/accesstoken")var buffer = new MemoryBuffer()buffer.fromString("hrIrJQO0rKQdWSf" + ':' + "AK4ceo", "iso-8859-1");http.header["Content-Type"] = "application/x-www-form-urlencoded"...
124
Views
0
Likes
0
Comments
Re: HttpClientRequest POST method with parameters Ramaswami - Adobe Campaign Standard
Same here as well
83
Views
0
Likes
0
Comments
Date query Ramaswami - Adobe Campaign Classic
Hi Folks, I want to grab the data from a table whose date is only 2 days ago and ignore if he has more than 1 row in the table. For example : the below is the tableunique idrespondent idclassoccupationcreated date111abcabc11/8/2020121efgo12/8/2020132huup11/8/2020142abcabc11/8/2020153efgo11/8/2020163dfdf9/8/2020 if i run the above table it should return the below : 132huup11/8/2020142abcabc11/8/2020 I want to grab the people of only 11th Aug and if a guy have created date as 11th aug and some oth...
165
Views
0
Likes
7
Answers and Comments
API Call from javascript node in workflow Ramaswami - Adobe Campaign Classic
Hi guys, i am trying to call an API from javascript node in a workflow llike below : var http = new HttpClientRequest("https://xxxxx/accesstoken")var buffer = new MemoryBuffer()buffer.fromString("abc" + ':' + "efg", "iso-8859-1")http.header["Content-Type"] = "application/x-www-form-urlencoded"http.header["Authorization"] = "Basic " + buffer.toBase64()http.body = "grant_type=password&username=conny.roscher@dynata.com&password=PaneL321!@"http.method = "GET"http.execute()var result = http.response....
143
Views
0
Likes
4
Answers and Comments
Bulk update into workflow Ramaswami - Adobe Campaign Classic
Hi Team, i have workflow like the below : i have to add a javascript node after the query activity and change the label of list according to the return function : javascript node has the below : function xx(){...return string;} list update node : label : <%=xx()%> there are some 100's of workflow like this. Can i update the labels in list as well as add javascript in workflow in bulk? currently i am opening each workflow and updating these two things.
108
Views
0
Likes
1
Answers and Comments
global functions to use in workflows Ramaswami - Adobe Campaign Classic
Hi Team, Is there a possibility so that i can store a global function in one place and call it from anywhere in Adobe workflow javascript. i have found there is a node under Administration>Javascript nodes. i have created a new namespace : "cust:new" and written a function in the javascript file -XXX() and i have called this function in one of the workflow javascript and it throws an saying "XXX()" is not defined.
91
Views
0
Likes
1
Answers and Comments
Re: custom filter on the list Ramaswami - Adobe Campaign Classic
Hi @sukrity, i got to know that for temporary lists we can create a predefinied filter 😞
95
Views
0
Likes
0
Comments
Re: Personalization block which populates the value in an... Ramaswami - Adobe Campaign Classic
Hi @anupk2111, There are about 6 columns in the excel where i need to apply some logic for each column. for example : get firstname column from excel and only take first 3 letters and pass in url, get the country name from excel and remove spaces and pass in url and so on.. i don't know if we can write a javascript function and pass the return value into the url. If that functionality supports then it would be easier.
110
Views
0
Likes
0
Comments
Personalization block which populates the value in anchor tag Ramaswami - Adobe Campaign Classic
Hi Team, i am just loading a file and sending emails to the emails which are there in the file loaded and the people which are there in file i am not importing them to recipient schema i am just using the target mapping as external and sending emails. But while sending the emails i will have to pass a link to each profile based on the values loaded from excel. Sample file which i loaded: So in the email there will be a unique link and we need to pass the first letter of the job category in that ...
122
Views
0
Likes
2
Answers and Comments
custom filter on the list Ramaswami - Adobe Campaign Classic
Hi Team, i have a list which is going to update daily through a workflow. Now i want to add a custom filter on this list such as a user can enter a month and year to filter the respondents based on month and year. This is my list : So i want to add a filter on the "date" column so based on month and year of that date we need to show the results in the list. For example : Like in the screenshot below there should be a month drop down and year input box where a user can enter and based on the mont...
127
Views
0
Likes
3
Answers and Comments
Re: Issue in personalization block when added in hyperlink Ramaswami - Adobe Campaign Classic
No relationship, i am directly using the excel sheet to send emails. On delivery i used target mapping as - "External file" with not adding the respondents into recipient schema.
279
Views
0
Likes
0
Comments
Re: issue in personalization block Ramaswami - Adobe Campaign Classic
Hi @Dareen, i can't able to add this in tag. if i use this in href like .. its given me the link as http://xx.com/123 ( it should be 1 or 2 or 3 but not 123 )
152
Views
0
Likes
0
Comments
XTK-170024 The temporary 'temp:notification2' schema is not defined in the current context Ramaswami - Adobe Campaign Classic
Hi Team,Hi Team, i am downloading a file from sftp and loading into Adobe (data load activity) and sending the emails to only those address using external file mapping in delivery template. Every node i have created from scratch.Emails are going fine and everything is looking fine but in the logs and also on the delivery activity i am getting this error : "temp:notification2" There is a javascript code which ties delivery to workflow and campaign as it's getting issues with this js, i have comme...
131
Views
0
Likes
1
Answers and Comments