Campaign Classic v7 & Campaign v8

Hello. I'm looking to run a workflow that will output all of our deliveries over a specific time period with metrics such as opens/clicks etc. However, the deliveries I want to look at are sent out every day and create a separate record on the deliveries table as we normally append a date to the delivery label. For example, for each brands welcome email, in a week it will appear 7 times for each brand. How do I build a workflow that will aggregate the sends to one line while bringing in opens/clicks for that set period? For each delivery, the delivery code remains constant so I could group by that. I have tried using counts/group by but not having any luck so far. Thanks. Luke

Learn how to download and install the Adobe Campaign Client console, create and manage your connections to multiple environments, and  verify access to the Adobe Campaign Client console through this explanatory how-to video tutorial now available for Campaign Classic users: Install and setup the Adobe Campaign Client   In case you have any questions after watching this video, please feel free to post them below or reach out through the community Q and A section. In case you have any ideas and/or suggestions regarding the Campaign Classic product, then kindly submit them here. 

Dear All How to identify the usage of schema / table?Example,We have custom data schema which is creating a sql table, but we are unsure how the data is loaded to the table. We were not able to find the WF or WebApp is using the particular schema / table.  CheersUkender  

Hi,How can we embed image with subject line ? Its same as Rich push notification. One should see the image in inbox below Subject line.

Using the Snowflake on CentOS portion of the Adobe Campaign Snowflake install guide ( https://docs.adobe.com/content/help/en/campaign-classic/using/getting-started/accessing-external-database/specific-configuration-database.html#configure-access-to-snowflake) I have installed snowflake on our Adobe Campaign unix host.   When the windows client console is started and connected to the test instance, snowflake does not appear as a type under external database when creating a new external account.   The install completed normally and the server has been restarted, there no additional configuration instructions.    

Hi all,I created a folder of type WFs. What if I put anything other than WFs in that folder?Will it raise error then and there itself?How is this rule of folder type enforced?Appreciate all your responses.Thanks,Rama.

Check out this blog post by QBurst giving an introduction to SOAP services. This blog  explains about web service calls, and how you can call Adobe Campaign SOAP APIs using a client app like Postman: A FRIENDLY INTRO TO SOAP WEB SERVICES IN ADOBE CAMPAIGN   Blog Abstract: The option to communicate with external systems is a cool feature to have in any platform. In Adobe Campaign, daily updates from external systems are made via a CSV or TXT file. But what if we want to push real-time data to Adobe Campaign, and more specifically to the recipient table? Then we have to make use of SOAP web services. SOAP methods and SOAP calls can seem tricky to master if you are new to them. Adobe has some documentation but unfamiliarity with XML can cause you to stumble. Being new to Adobe Campaign, you might be new to XML as well because most of the recent developments had a JSON and REST inclination. Also, you may not find documentation that explains all those steps you need

Hi All, Hope you guys are doing well.I want to disable users who left the organization or no longer on project. If I disable users who already left, all the workflow which are created by them and running will throw error and go on paused state. I do not want this to happen. Is there any way to achieve this by not doing lot of manual work(restart  workflow by another user).One of the solution could be change "created by" attribute. Can anyone help me how to change created by attribute of workflow. Any other solutions are welcome. Thanks in advanced..!  

Hi guys,do you know if there is a way to sync schema definition of a custom table where index is already created directly in database?There are several custom tables for which indexes are created directly in database (custom names) and whenever option Update database structure is started, AC is offering to drop existing indexes and create new ones with ugly names 🙂Just looking how sync schemas with existing setup in db.Regards,Milan

If there a way to configure Broadcom (former CA) APM agents on Adobe Campaign Classic servers (web) so we can monitor transactions on Adobe Campaign Apps and Forms? I was not able to find anything obvious in documentation.

Hi, Please suggest me how can I add wildcard operator LIKE in the delivery input form.I tried below code but getting error when open SMS delivery template: <if expr="EV(@messageType, 'sms')"><check expr="[../content/sms/source] LIKE '%Adobe Campaign' "><error>"SMS content shoulf contain Adobe Campaign."</error></check></if>   So I tried below login in nms:delivery input form to send alert message if Adobe Campaign text not present in the SMS content: <if expr="EV(@messageType, 'sms')"><soapCall name="CheckSMSContent" service="lf:SMSContent"><param exprIn="[../content/sms/source]" type="string"/></soapCall></if>  Please let me know what logic I should add in the javascript file. 

Hi all,Does Adobe Campaign support both Inbound and Outbound Campaigns? How?Outbound is a normal Campaign we send out I think.How does it support Inbound Campaigns? By Subscriptions?Thanks,Rama.

Hi All,I am looking for some way to generate the ER diagram on the Adobe campaign v7 database. Tried to use the ERD tools available like DB viewer etc.but it is not showing any cardinality or linking between the tables on the keys.Can someone please guide me on how can we generate the ER diagram from underlying database used by Adobe Campaign. Showing the links is very important in this case.Thanks,

Hi all I noticed something weird, I'm on Adobe Campaign classic 7.0.19.1 server build 9032. I'm having issues uploading non-standard files (want to upload fonts like *.eot files) but it will error out.In the web@default log journal I see errors such as: 2020-08-31 15:26:16Error exception : Downloaded file '43157417dd8926cc1da5ad304d86620a.eot' is not authorized. Assuming there was some restriction on the upload file type, from documentation online I see that the attribute is supposed to be uploadAllowlist=".+".When checking the serverConf.xml on the server, I see that it's set up as uploadWhitelist=".+" Which one should it be?

Hi all, Below is default case:Exculde duplicate addresses(deduplicate field) is selected by default.  1. I need to make "Keep duplicate records" as the default one as below:2. I can do this manually, but the goal here is to set the Keep duplicate records(@noRcpIdDedup field) by default. These fields are defined in the nms:delivery schema:Can you please help me achieve this. Thank you in advance,Anoop 

I saw a great webinar posted by Ananya Kuthiala​ and Pooja Singh Devanadan of Adobe Support regarding Adobe Campaign Sequence Exhaustion (Adobe Campaign: Sequences Exhaustion - Adobe Campaign Classic ). In the video, there was discussion of the scripts demonstrated as being posted for those attending the live session. Would it be possible to get those scripts or ppt deck used during the presentation? Unfortunately the video quality has made it extremely difficult to read the code and reproduce it.I am trying to utilize the code to get a measurement of how many of the key sequences within various schemas have been exhausted.Thanks!Lee

Hi, I added logic in the nms:delivery input form hence the text message is rendering automatically in the sms delivery template inside text content. But its coming at the starting position.   Please suggest how to display text at the ent of the content.  

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 or three tables and checked the database capacity and it is still 82%  So now i am getting doubt that should we use commit statement after "sqlexec(delete)" like ( sqlexect("commit")) OR is it okay to execute without commit.  Does my assumption is correct ? ( that since i am not using commit the database percentage is not changing ) OR is it some other reason the percentage usage is not changing. &n

Hi all,I need to display some more columns in the list view of recipients.FirstName, LastName, Email and account are default columns. Without using configure list I need to display few more attributes by default. Could you please guide me what changes need to be done to display new colunms by default. Which Input form modifications need to be done? Thanks inAdvanceRegards,Ram. 

I have a workflow that is grouped by a numeric indicator (Sponsor External ID) and zip code.  I then count the customers by zip code and display in relation to the total customers associated with the indicator.  My next step, which is tripping me up, is that i'm trying to sort descending by count of customers (count of CONTACT_ID) and then calculate a rolling percentage so that any zip codes that fall after 85% of the total are removed (i.e. i'm trying to capture the zip codes that have the most customers and make up 85% of the base).  Is there a way to do achieve this within the workflow? Hopefully my explanation is clear.  If not please let me know and i'll provide additional info. 

Hi all, In recipient input form I need to create a tab called contact under general tab. Need display few attributes under new tab. The attributes are in different table contactPoint which is  linked with recipient table. I had created a new tab in the recipient input form and through the link I am able to display the attributes. My question is, this newly created tab should visible for the recipients if contactpoint link exists. If there is no contactpoint to the particular recipient, then Contact tab should not visible to that recipients in the Input form. Please help me here.Thanks in Advance BR,Ram.

Hi, Can we display warning message in Adobe campaign classic through input form? if yes then how? Please suggest. Since don't know how to display warning message in input form I tried for error message.I have written below code in nms:delivery input form- <if expr="EV(@messageType, 'sms')"><check expr="[../content/sms/source] !='' "><error>"Sure? you not added consumer number."</error></check></if> The above code is working fine when I open sms delivery template and when click on save its showing error message if text content is not empty. But when I tried below code its not showing any error message even when text content is not equal to ABC: <if expr="EV(@messageType, 'sms')"><check expr="[../content/sms/source] !=''ABC"><error>"Sure? you not added consumer number."</error></check></if> Please guide here. 

I have a peculiar issue with the campaign console. I don't see a detailed view of any object selected on Explorer. The panel on the right with detailed attributes are not seen. Tried logging in on other machine, it works fine. Let me know how to solve this issue.  EDIT - Solved - Thank you @isahore , your suggestion solved this issue. Clearing cache wont help.  

Hello all and happy Monday, I am doing the registration of the servers per the documentation, entered the internal URLs, and uncheck the Externalize option, enter the internal URLs, and register the servers:                 I do the registration and everything looks good. However, whenever I go back to it I see that the Externalize Tracking Management box is selected again (see below). Does anyone have any idea why this is happening?                  Thank you so much for your time. -sergio-     

Hi all,In Tracking Reports I am reading 0X0 Pixels Download.What is 0X0 Pixels?Thanks,Rama.