Campaign Classic v7 & Campaign v8

Hi all!I am attempting to make my enrichment activity fetch N amount of rows and only return the amount that equals to the amount of rows in the table I am looking into. I am dynamically fetching data from a database table, that is continously updated. That means that the amount of rows can differ at each send-out. It can range from anything between 10 - 30 records. This data is then used to dynamically enrich the email activity later on as targetData in order to automate an email proces. Issue is, that I can't seem to figure out how I can set it to create only the amount of columns that are actually present in the table. I hope it is just me who is overlooking something? Any help or pointers are much appreciated! Thanks!   

Hello, can somebody explain what this expression .replace(/ /g,'' ) means?

Hi,I want to create the following query:Users who have received this specific delivery and did not open it. Could I use this way you can see below? I can not make it work. 😞  Thanks in advance and kind regards

Hi I am trying to find all recipients with same emails ( I have lot of duplicate..) with different consent type. ex:emailconsent yyperecipient@domain.com   opt outrecipient@domain.com   opt outrecipient@domain.com   opt in And what I need to get is how many emails i have in my database with same email but different consent log

Hello I am trying  to retrieve all recipents with same email but coming with a différent consent type? I am looking for a straight foward approach, to update them with the same value consent type, when the most recent consent date is updated?

Hi All Adobe Specialists,This is my first question on this portal. After checking 10+ questions answer without a proper answer, I thought it is best to ask the question here in hope someone who might have faced the same issue, might be able to help.What I am trying to achieve:I am looking to Encrypt PII values (e.g., AccountID, Name, Surname etc.) in Adobe Campaign Classic V7 so it can be added to the URL of a landing page/WebApp. This will be done on the App Server where all the Email deliveries are generated. Then I want to be able to read/decrypt this encrypted PII value (e.g. Account Number, Name) in the WebApp. Once I have decrypted value, it will allow to search for customer’s record and make necessary amendments to the record. The reason I cannot use Primary key (id) is because there is one to many relationship between Recipient Schema and the other schema I am trying to query.The WebApp runs from Web Server. The Issue I am facing:I can encrypt the value within Email U

In order to match a Recipients column, I need to satisfay this conditions:1.- If customer_cic is length 8, then add 4 spaces at the begging. 2.- If customer cic is length 12, leave it as it is.I tried: Case(When(Length(customer_cic)==12,customer_cic, Else('    '+customer_cic)) But is giving me error. 

Hi everyone I am trying to truncate the contents of a custom table in the Adobe Campaign database. I created that table to hold a set of data that is imported on a daily basis from an external file,but I need to truncate it before loading the data set. I know I could use the Update activity to delete records, but that requires an input. I could build that input by querying all data in the target table first and pass it to the Update activity, then the Update activity would delete the records from the incoming population. However, it would be much more efficient to just truncate the full table. Can someone provide guidance on how to do it? CheersHugo

My recipients codinternocomputacional has 04 white leading spaces for each value. My other source CSV's "customer_cic" , which is the key to make the match, has no leading white spaces. I cannot/should modify recipients. How can I add the 04 when doing the key matching?   

Hello,  I created a delivery using the wave function. The delivery has started, but I need to change 3 waves. Is there a way to do this without the process of stopping the delivery, removing previously sent records, and starting the delivery over again? 

I was just wondering if I have to extend the custom schema to add additional columns or can I simply modify the custom schema instead of extending it again. Thank you in advance.

Hi, I've an importer that loads a CSV in order to fill  a table (schema). We're currently using a test activity to test if there is full data on all columns, but how to do the same of only 1 or n columns?Our current test activity content: vars.recCount > 0 how to do test : if "emailcomercial" is empty or celularcomercial is empty end the workflow?

I have a Recipients tablet extension. It differs in the namespace with the default recipients table: abc:Recipients vs nms:Recipients.I've added columns: flag_correo and flag_sms to abc:Recipients, they are empty. abc:Recipients already has column "codigointernocomputacional" on this table with data.md_preferencias.csv: I've also a file with the values for each column (flag_correo and flag_sms). I need to join on the "codigointernocomputacional" column (on abc:Recipients) and update this column, with the "customer_cic" matches on "md_preferencias.csv". So the information in the file "md_preferencias.csv" should be joined on "customer_cic" and update the columns: flg_correo and flag_sms (on abc:Recipients).Both tables have  flag_correo and flag_sms columns. It is only that the data in abc:Recipients is empty for this newly created column and should be filled with data from the csv file. md_preferencias.csv:+--------------+-------------+----------+--+--+ | customer_cic | flag_c

Hello, we are considering changing the @6761651 field  in the Recipient table since we noticed that today we are using this expression in the Recipients (nms) data schema XML-code: <attribute desc="Age in years" expr="YearsOld([@birthDate])" label="Age" name="age"notNull="false" type="long"/>Our @birthDate is not indexed as of today and this change in the schema would help our database performance since the current YearsOld([@birthDate]) expression is heavy to process and we use it in every wkf.Is there any downside with removing this expression and instead calculate it and populate the @6761651 attribute in a daily workflow?

Hi,We recently configured an SMPP external account in Adobe Campaign classic.At first the SMS setup was working. There were no issues. And suddenly, we started seeing.  SMPP connection with 'IP' deactivated.We contacted vendor about this to which they replied, 1. Please check the posts configured - (Configured as per given details)2. Please check if username and password is set properly (Details configured accurately).3. Please provide TCP dumps. (We shared)4. Please check if IPs whitelisted. IPs got whitelisted hence it was working before. After going back and forth with all these details, we approached Adobe Support team to capture TCP dumps by setting up verbose on live call. We are still unable to figure out what's the issue. Most of the time we are getting this error in campaign - SMPP message cancelled after connection has been closed.And in vendor side they are getting this error - ERROR: Bind for system "xxxxxx" pswd "xxxxxx" type "T

What are the possible reasons, a campaign can run before its scheduled run?

I have many deliveries in a Campaign, they all have the same label, since it is a recurring delivery. However, the differ in the DM part. Example: J_NEWUSERS (DM533015), J_NEWUSERS (DM537239)... and so on. Since I cannot filter by label because the have all the same label. How can I filter by DM in the explorer? In the AllDeliveries part.

Hi All,Please help with the detailed steps and also the  linux commands to access serverConf.xml file and add server changes in it.Thanks

Hi there! I am trying to create  conditional content based on the segment code i have created in my workflow: But when i try to send the delivery, this error happens:JST-310000 Error while compiling script 'content htmlContent' line 4: invalid XML name (line=' if ( <targetData.segmentCode> == <"info"> ) { document.writeraw("info"); ' token='"info"> ) { document.writeraw("info"); '). Could anyone help me? Thank you team  

Hello dear community,does anybody have example ofNLWS.nmsDelivery.BuildMirror() I want to get HTML of particular message sent to a recipient.Marcel

Hello, is there any way to create an Activity using Javascript? Basically, create it in execution  Thanks; 

We're trying yo integrate Adobe Campaign Classic intro mobile application following this documentation: https://github.com/Adobe-Marketing-Cloud/aep-sdks-documentation/blob/master/using-mobile-extensions/adobe-campaignclassic/README.md But we're constantly getting "HandleDeviceRegistration - Cannot send device registration request, Configuration is not available."for push token registration. We checked setup of extension (integration key , marketing & tracking servers) but it did not help.  

Hi, We have observed that Workflow server (wfserver) stopped and the logs are read as below:stop requested (pid=xxxxx)stopping workflow server (pid=xxxxx, tid=xxxxx) We are not aware why this happened? Did someone ran the command to stop the workflow server?How to read those logs? Please help understand these. Regards, Hari Krishna D

Hi, I've 350K recipients that were wrongly put to quarantine. What table should I target to change their status from "Quarantine" to "Valid"? 

Hello,  I'm trying to create and publish resource files dynamically by JS code but I'm not being able to publish them after creating.  My code is as follows:var file = new File("F:\\Attachments\\current\\attach1.pdf"); if(!file.exists) logError ("File '" + file.fullName + "' does not exist."); var extension = /[^.]+$/.exec(file.name); var md5 = digestStrMd5(file.name); if (!file.copyTo("E:\\Adobe\\Campaign\\var\\campaign_tst\\upload\\" + md5 + "." + extension)) logError ("File '" + file.fullName + "' was not copied"); var xmlString = '<fileRes alt="" codepage="0" height="0" name="'+md5+'" nature="" publish="1" storageType="5" useMd5AsFilename="1" userContentType="0" version="" width="0" xtkschema="xtk:fileRes"/>' var fileRes = xtk.fileRes.create( new XML(xmlString)); fileRes.contentType="application/pdf"; fileRes.label = "Attachment 1" fileRes.md5 = md5; fileRes.fileName = md5; fileRes.originalName = md5+".pdf"; fileRes.save(); file