Campaign Standard

Hi! I am trying to do a Random sampling limited to 50 % of the segment. On random sampling from entire incoming target, I get no error (considering Split activity set up would not differ too much) but this is not what I need For instance: my target population has 75 recipients; I filter by gender Code of targeting dimension equal to 'F'; then select Random sampling, limited to 50 % of the segment. On running the WF, the Split activity fails. This is what I get in the journal: 02/10/2018 11:26:15 PM       extract Only 0 record(s) have been selected while 9 were requested for result 'Female' of extraction 'Split'.02/10/2018 11:26:15 PM       extract SQL statement 'INSERT INTO wkf63278912_53_1(iId,sGENDER,sSegmentCode) SELECT   W0.iId FROM wkf63278912_52_1 W0 JOIN NmsRecipient R1 ON (R1.iRecipientId = W0.iId) WHERE (R1.sGENDER = E'F') ORDER BY random() LIMIT 9' could not be executed.02/10/2018 11:26:15 PM       extract PostgreSQL error: ERROR:  INSERT has more target columns than expressi

Hi all, Can anyone help me with how to  import HTML content to text in email delivery of adobe campaign Standard.

Hi,Your help would be appreciated. I have the following query to display the unique opens . Unfortunately count distinct (for broadlog id)is not working. Is there any other way to achieve this.var opensQuery = xtk.queryDef.create(       <queryDef schema="nms:trackingLogEventHisto" operation="select"> <select >                      <node expr="countdistinct(@id)" alias="@opensCount" />               <node expr="[event/@journalDistributionID]" alias="@opensJD_id"/>            <node expr="date([event/@created])" alias="@opensDate"/>                                                        </select> <where> <condition bool-operator="AND"> <condition expr="[url/@type]='2'" /> <condition expr="[event/@journalDistributionID] IS NOT NULL" /> </condition> </where> <orderBy/>           <groupBy> <node expr="[event/@journalDistributionID]" /> <node expr="date([event/@created])" />                   </

Can anyone give an example of how one would use a sub-item inside the Add data/edit additional data option the query activity?As per Adobe's documentation, the add sub-item option lets you attach computed data to the collection. This lets you select the additional data from the collection or define aggregate calculations on collection elements.Can anyone give use case examples?

I want to check if Adobe campaign is available in Microsoft Azure. I unable to find that in Azure Marketplace. Also in Enterprise Application in Azure I can find Azure Experience Manager but not Adobe campaign. Please confirm on it.

Hi,I am trying rename the file which has been placed in to vendor SFTP using file transfer activity. Could anyone help on this?!

I am trying to install Adobe Campaign version 6.1.1 build 8594. I am facing issue while integrating IIS with Adobe Campaign. Methods which I have done are:1. Enabled ISAPI filters and ISAPI extentions in control panel.2. Created new site in IIS manager.3. Run the iis_neolane_setup.vbs as administrator.However, I was not able to integrate it. I am getting error as:When I run nlserver pdump on command prompt, I do not get webmdl@default as integration failed.I am running this script on windows 10 and IIS version is 10. As per my understanding, VB script is designed only for IIS7 and IIS8.Please suggest what can be done to resolve this issue.Thanks,Jyoti Yadav

Hi Team,Can you please let me know how should i replace <%= new Date().getFullYear() %>. Correct script is <%= "<" + "%= new Date().getFullYear() %" + ">" %> in javascript code workflow.Regards,Nidhi

How would you track URLs that are not included in deliveries?  but rather on a website.So I am producing an export of data to be uploaded on a page and each one has a link, so I want to track this link. I thought maybe I can create a web tag and do something with the recipient ID in the workflow that is generating the extract.TagIdworkflow JS02/02/2018 17:18:27 js https://redir.xxx.xxx.com/r/UG19fX1qPiqQSRNN1isJ1VbGl%2FvHI3WNRJV0xnExPZ4mOGdX0lF7qhJCVCACAA%3D%3D?tagid=3bbb47e7Upon clicking on this link, isnt it supposed to redirect to my tag url http://www.google.com and track the click? also where are the tracking logs stored for this? (nmswebtrackinglog, nmswebtrackinglogeventhisto?)Anyone has an idea of doing this as it isn't working for me.florentlb​ Amit_Kumar​ Vipul Raghav​ Jean-Serge Biron​

I need to export data out in the unix format of only having a line feed at the end of each line rather than the windows format of carriage return + line feed. How would I go about do this?

Hi Team / Vipul Raghav​Amit_Kumar​I am working on creating a separate schema in which we are loading Import/Export workflow's data.In that schema, Fields are Like  Date&Time, Count(In file), Successful (Inserted/Updated), Unsuccessful()Reject.Can you please help me with that JS which will capture Successful and Unsuccessful  Counts after Updating or Rejecting data in Update activity of workflow . So, that I can use it for Updating Our Tracking schema with that.Regards,Sourabh Kumar

I have a website with 2000 users. I need to link my website with Adobe ACS throught the REST API.Before testing or implementing that, I read the documentation and I have several questions about the documentation https://docs.campaign.adobe.com/doc/standard/en/api/ACS_API.html#introductionEach user will be create one by one by calling the CREATE method. But each night, I need to update data of all users and send the changes to ACS.Do I need to call 2000 times the PATCH method for each user or is there a way to pass a list of users data to update with an unique request ?Can we use the method CREATE in order to update the data of an user if he is already known by ACS (from is email, id ?) or have I to send a GET request to know if my users already exist in ACS and after that make a CREATE or a PATCH ?Thank you

I am using the following sql query to remove some unwanted strings.  select case when sSource like '%<%%' then SUBSTRING(sSource, 1,charindex('<' ,SSource)-1) else sSource end  from [xx].[xx].NmsTrackingUrlIt will cleanse the record and remove the string (<%   }                                         %>)Now I am trying to do the same on a worflow but I am having trouble converting the expression.Case(When(@source LIKE '<%', Substring(@source,1 , Charindex('<', @source)-1), Else(@source)))The error is the following.. anyone can give me a hand?I can see that the case expression is being interpreted wrongly by Neolane and it should be 'Case When' not 'Case(When' so I used the following expression instead, it also performs a CASE but the error is differen

Hi all,I'm using continuous delivery, and I would like to personalize data in the message with variables. My data are not linked to the recipient dimension. I tried to use variable defined in the delivery (delivery properties, variables tab) but I'm not able to assign a value to my delivery variable in my workflow. I don't find the syntax to use in the initialization script of my continuous delivery.Could someone help me with this ?Best regards,Celine

We are trying to create a landing page (for internal use only) that allows us to directly change (add or update) an email address stored in an excising Adobe campaign profile. There are certain requirements:Unidentified visitors need to be identifiedWe lookup the profile using the client numberThis service is only available for internal useIt seems that this function is not available out of the box in campaign standard. Currently landing pages allow us to make changes to subscriptions, the blacklist list, and the creation of a new profile using the acquisition landing page.   Any suggestions?

Hi,quite often I see that my deliveries are in Retry pending status for a while. Because of that I have to wait for 10 minutes or even an hour before emails are sent. In Adobe's docs I found this page: https://docs.campaign.adobe.com/doc/AC/en/DLV_Tracking_deliveries_Monitoring_your_delivery.html.According to it I should check if  MTA modules are launched by type proper command: nlserver pdump. Next I should type: nlserver start mta@<INSTANCENAME>. My question is quite basics: where I can type these commands? Where I can find console?Thanks,Marcin

Is there any way to capture the http request header that is sent to a webapp(hosted in ACM)? I need to modify the content of the webApp according to http request header values and modify the response header also.Thanks in advance.RegardsSaikat

Hi,I have generated a WSDL from this URL https://<myserver>/nl/jsp/schemawsdl.jsp?schema=nms:rtEvent for the Message CenterAfter, I've imported the XML file in a SOAP UI proejct and modified pushEvent request in a semi-customized request.I will have SOAP requestS written like this:<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:nms:rtEvent">   <soapenv:Header/>   <soapenv:Body>      <urn:PushEvent>         <urn:sessiontoken>user/pwd</urn:sessiontoken>         <urn:domEvent>            <rtEvent type="nameEvent" email="name.surname@mail.com">            <ctx>                 <param1>stringField</param1>                 <param2>intergerField</param2>                 <param3>dateField</param3>            </ctx>            </rtEvent>         </urn:domEvent>      </urn:PushEvent>   </soapenv:Body></soapenv:Envelope>All

Hi All,I am looking for material/sample exam questions for the Adobe Campaign Developer certificate, could someone point me in the right direction please?Thanks,Ash

Hey, I just built a get function that calls on a https API, but the server-department at my office wants me to use a proxy for this. Im relativily new to proxies, so my question is if anyone has an idea of how to wrap this get function in to a https proxy?loadLibrary("cus:json3.js");//Require temp Schema to match against cityvar query = xtk.queryDef.create(  <queryDef operation="select" schema={vars.targetSchema}>    <select>      <node expr="@smartcity"/>    </select>  </queryDef>);var res = query.ExecuteQuery();function getCall(){  var http = new HttpClientRequest();  http.url = "https://url..." + line.@smartcity + "...restoftheurlandkey";  http.method = "GET"; //The GET request  http.execute();  var response = http.response;  logInfo( response.body.toString());};for each (var line in res) {  getCall();};In regards, Martin!

how should i solve this problem? i dont know where to look for

When I attempt to log in to the rich client, I'm getting an error message that reads: Invalid 'US/Eastern' time zone file. Any ideas on what may have caused this? Has happened for the first time this morning.

Hi All,How to automatically export all the error logs to a google spreadsheet or any other external file over an SFTP?Thanks,Gunjan

Hi,What is the process for adding new currencies into the nms.currency table? I can't seem to find any documentation detailing this.Thanks in advance

Good Morning!We're hoping to utilize Enumerations within Campaign in order to avoid the potential fat finger/extra space/capital letter issue in our querying. However, after following the necessary set-up here: Managing enumerations  i'm running into some unexpected behavior (to me) and i'm looking to confirm whether or not it is how the system should perform.We updated the schema so that one field is listed as: <attribute dbEnum="wbmItemTypeGroupDescription" desc="Item Type Group Description Enum"               label="Sales Category" length="100" name="ItemTypeGroupDescription"               type="string"/>This maps correctly to the Enumeration built in the system:- As you can see in the screenshot the enumeration is listed as 'Open' so that more values can be added in the entry screen.However in a query activity, i have the dropdown op