Campaign Classic v7 & Campaign v8

HelloI'm trying to run a workflow based on an option that stores the last run of the workflow.I'm querying the Recipient tracking logs for "logDate" and comparing that with the option as "on on after"I have a delivery that has its tracking logs all on 8:ish, so 8:05, 8:30 and 8:55.The option is, double confirmed in the workflow log, set at "Mon Jul 08 2019 09:28:53 GMT+0100 (BST)".When I run the query then, it should not find any records because 8:05, 8:30 and 8:55 are not 'on or after' Mon Jul 08 2019 09:28:53 GMT+0100 (BST).However when run, it shows one record, the one from 8:55.How is that possible?ps. The server time is set on Europe/London Timezone, so BST as well.what am I doing wrong?

Hi,I am facing some issues with accessing the data at the initialization level while creating a web app. Actually, I am trying to fetch an user detail from the nms recipient before loading the web page and will be uploading the status after the page load. I need some help on the same.Thanks in advanceRegardsDhanvanthi

Hi All,I need to personalize an email with the information of an N table linked to recipient. This must be done without a workflow.I am able to extract the information using the "Extra script objects" in the personalization tab of the delivery:But i need this query to be dynamic and filtered for the specific recipient. Currently I am able to get information but i must hardcode the recipient ID or email, is there a way to make this dynamic?FYI, this would be sent using the method SubmitNotification that passes the target's ID.Appreciate any help.Kind Regards,Jose

Hello, I am trying to count of Number of Customer Contact Rule ID's per Contact Rule grouped by Name and Value from with a temporary table which i have createdwith the workflow.The number of Customer Contact Rule ID's per Contact Rule within the temp table have already under gone some deduplication criteria before getting to the aggregate stage in the workflow. Therefore i wish to count the total of Customer Contact ID's within the temp table.Grouped by 2 values: Contact Rule Name (Customer ContactTable)Customer Contact Value (Contact Rule Table) - Different tables I can count the number of Customer Contact Rule ID's when looking at the linking using the add data function: Data Linked to filter dimension. However this of course returns the total number of product id's with no reference to the population within the temp table. When i select the criteria within the enrichment: Data of the filtering dimension.  I proceed to count on the Id's from the temp table and then group on the

Hi there,I'm attempting to import a package containing a delivery workflow from one Campaign instance into another however the package import fails due to a conflict.The conflict in this case is a delivery.How can I go about resolving this?Thanks,C

Hi All,I am testing technical WF's which is designed with Scheduler , JS script, Audit logs, File Collector, Data loading , deDuplication, Insert or Update data and some alerts . Can you advice some major validations to consider when testing a WF and above activities mentioned?Thanks1

Hi Experts,There is a requirement from one of the client in Hybrid (on-prem) where any new user will be onboarded,the Admin will run a "Database Script" to create folder structure. Fo example, input parameter of the "DB script" can be a name of a Bank or any Organization_Name. The sub-folder structure will be fixed for all other users. Please see the below example and it would be great if any one can help me with the "Database Script".Wells Fargo -- > (This name will change everytime and it will be taken as param for example to create the folder structure)AdministrationAccess ManagementOperatorsOperator GroupNamed RightsConfigurationCampaign ManagementDeliveriesTypology ManagementTypologiesTypology RulesCampaignsCampaign WorkflowProfiles and TargetSeed AddressesRecipientsListsResourcesCampaign TemplatesXSL StylesheetsFiles ResourcesWeb AppsDelivery TemplatesThanks and regards,Kaustav

Hi,I am trying to use WSDL using Loading (SOAP) activity. But after entering Access URL and clicking on Generate Skeletal Code, I don't see any functions in function list popup from WSDLIf I use same WSDL URL in SOAP UI just to validate the WSDL and its functions, I can see all.Do I need to perform any additional configuration to use this activity or WSDL option?What could be the alternate option to make API call here?I already tried Javascript using following code,var http = new HttpClientRequest("https://...");  http.header["UserName"] = strLogin;  http.header["Password"] = strPwd;  http.method = "GET"  http.execute();  var resp = http.response;This gives me following error,INT-150012 The HTTP query returned a 'Method Not Allowed' type error (405)

Greetings,We have a use case to personalize the email content in real time based on the mobile device used. We are using Adobe Campaign Classic as our Campaign management platform across Email, SMS and DM.  I am new to Adobe Target and based on my understanding I assume that integrating AC and AT would allow us to personalize the email content in real time based on Segments, Geo location etc.What I am not very sure of is, can we personalize the content based on device type as well? E.g if the user opens the email on an iOS device the content will be different compared to if they open the email on an Android device.Would love to hear some views on this.Thanks in advanceCheersPS

Hi,We have a server - when we define a webservice, every parameter name in the WSDL is prefixed by the type e.g. "str", "dom" etcThis looks like it is a server config, but we can't find where (nothing obvious in options)See the below image for an example - two WSDLs created from the same schema on two separate serversThe top shows as expected - parameter names are as they are defined in the schemaThe bottom shows the parameter names being prefixed automaticallyIs there a configuration we can set to remove the prefixes?Schema definition (snippet) here  <methods>    <method library="xxx:leadEvent.js" name="LeadEvent" static="true">      <help>Insert an XXX Lead event.</help>      <parameters>        <param desc="Source System" inout="in" label="sourceSystem" name="sourceSystem"            &nbs

Hi,I want to prepare a form and save its data to a table in an external database, is this possible with Campaign Classic? I can use web forms but I wonder If I can use another schema rather than recipient? I want to create a basic application page for a gift card and save its data to external db.

Hi All,I'm building a custom adobe campaign classic function to convert current date to UTC. But irrespective of what method I use, I'm getting nowhere. Getting below errors.Where am I going wrong? Can we convert Local time to UTC in postgres?Note: I can do it using JS activity but won't be able to create a custom function.I have also tried with: select Timestamp with '2019-07-01 10:30:00-05' AT TIME ZONE 'UTC'.Thanks,Vidya Shivakumar

Is there and API executable command for importing packages and exporting packages. I am looking for something like nl.execute command.ThanksSaurabh

While reading on A.com you have mentioned that the open rate is calculated at the point the images are downloaded.Reports on deliveries Please, can you confirm if this is also applicable for email which is only viewed in the preview pane of the ISP. E.g. Outlook and Hotmail both have preview pane. Does Adobe Campaign class my previews (all images have downloaded at this point) as an open or do I actually have to double click and open the email to register as an Opener.

Hello All,Before there was a checkbox where you could exclude id from the main set when doing aggregate functions. Now that is gone you always get error saying enrich WDB-200001 SQL statement 'INSERT INTO wkf631156212_14_1 (sBrowserName,iMax__id_,iCount__id_,iId) SELECT   U2.sBrowserName, max(W0.iId), Count(W0.iId), W0.iId FROM wkf631156212_13_1 W0 JOIN NmsTrackingLogRcp T1 ON (T1.iTrackingLogId = W0.iId) JOIN NmsUserAgent U2 ON (U2.iHashKey = T1.iUserAgent) WHERE ((T1.iTrackingLogId > 0 OR T1.iTrackingLogId < 0)) GROUP BY U2.sBrowserName' could not be executed. enrich PGS-220000 PostgreSQL error: ERROR:  column "w0.iid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...422,iId) SELECT   U2.sBrowserName, count(W0.iId), W0.iId FRO...                                                       It always add the primary key to the aggregate function how i am supposed to do the queries now. Do you guys have workaround other than select all and then do the ag

Hi,Could any one tell me know what type of testing can we do for campaign ? or post me any document related to campaign testing.

Hello guys. I'm trying to send an email with an attachment that is in a specific directory, the idea is not to upload the file on the application server. In the preview it appears all right, but when I run the delivery I see a read access error. Does anyone know where the error might be? When I upload to the application server works, but this is not the ideal scenario. Thank you very much in advance.

I have a question on Adobe sub domain configuration and one of the requirements is related to email masking i.e. e.g. If we delegate domain email.abc.co.nz but at the same time for some of the campaigns we would want to send few comms that shows email of relationship manager which means sender address shows xyz@abc.co.nz (parent domain) rather than xxx@email.abc.co.nz. Though this can be achieved by email masking but I have few questions to clarify: Does Adobe supports email masking.Is this recommended approach in terms of deliverability best practice and can have any deliverability impact?Will this break any of the authentication for any ISP specifically DKIM?Is there any doc around it showcasing the impact or recommendations. I reckon if masking is in place the sender name for above scenario will show as xyz@abc.co.nz via xxx@email.abc.co.nz in the email header?

Hi,I'd like to configure Adobe Campaign so that all addresses from a specific domain are authorised to send mails (so essentially I want <%= recipient.firstName %>.<%= recipient.lastName %>@domain.com to be authorised to send emails). How do I configure the 'Authorized masks for the sender address' to allow an entire domain rather than defining specific single addresses?Thanks in advance

I'm looking to create a daily report with a overview of email delivery metrics (i.e sents, opens, clicks). Is there an option to create an automation to export this data?

HiI want to know the difference between difference between instance.vars.someVar and vars.someVar.

Hi,I have a campaign Delivery setup. When I ran the workflow, everything ran fine but Delivery status is showing as Personalization Pending. What could be the reason for this and how to fix this.Thanks,Saurabh

Is there a way to pass a generic sms message back to users if respond via SMS is other than standard response (STOP, QUIT, HELP)?We are handling the automated response via external account definition.

var query =  <queryDef schema = "temp:enrich32" operation="select">                             <select>                                 <node expr="@firstName"/>                            </select>                            <where>                             </where>                    </queryDef>var condition =   <condition boolOperator="AND">                            <condition>                            <condition boolOperator="OR" internalId="0" expr="@gender = 'M'"/>                            <condition boolOperator="OR" internalId="1" expr="@gender = 'F'"/>                           </condition>I want to add the condition into the where in query in a javascript activity.

Hello,We are using the Recipient table to store the customer attributes and also created a custom table to store several customer extension attributes. This is a 1:1 relationship.I'm trying to insert records into the Recipient and the Custom table in a single workflow. Is this possible or do i need separate workflows for each Target dimension?Any other suggestions on how to insert records into Recipients and the Custom table??Thanks for your helpSree