Solved

Hi All - I am creating a workflow that I hope will be able to map one file layout to another. I am making plenty of progress, but I have hit one sticking point. The inbound data format is something like:Person IDFavorite FoodFavorite ColorFavorite DrinkAChickenRedWaterBVeggiesBlueSoda Ideally, I would like to be able to emulate the "Unpivot Columns" function in Excel Power Query to un-pivot the data so it reads more likePerson IDAttributeValueAFavorite FoodChickenAFavorite ColorRedAFavorite DrinkWaterBFavorite FoodVeggiesBFavorite ColorBlueBFavorite DrinkSodaIf this data were already in the Adobe DB in separate tables (ex. individual, individual-surveys, and surveys), I could use an enrichment activity with a one-to-many link between the tables to load out the rows. However, I am curious if this is something that could be done with an activity entirely within a workflow. Anyone have any good tricks for this? Thanks

I'm curious what happens to the temporary table of a query, when there is another query in the pipe: I have a query (Q1) that has its results in a temporary table (T1).The flow then continues to another query (Q2) that is NOT quering the T1 or even same dimension as T1, it's a completely new, separate query, that just is in the same flow.It will have its results in a new Temporary table (T2). But what exactly happens to T1? Is it dropped?Does it stay in memory until the whole WF is stopped?Something else? I did test this, by storing the name of T1 to a variable, and then after the second query (Q2), tried to do a sql-query on T1.var count = sqlGetInt("SELECT COUNT(*) from "+vars.tempName+"");logInfo(count); This crashed with an error: PGS-220000 PostgreSQL error: ERROR:  relation "wkf1793215150_24_1" does not exist LINE 1: SELECT COUNT(*) from wkf1793215150_24_1 LIMIT 1 OFFSET 0    So, from this, I assume that the T1 was dropped af

I have an issue with the rendering of a barcode in my email.This is what I use for my barcode right now in the email template :<tr><td style="padding: 5px 0 15px;" align="center"><img src="https://campaign.kruidvat.be/barcode/tISBN/h70/s2/v<%= targetData.cardNumber %>/barcode.gif" width="179" height="70" style="min-width: 179px; display: block; color: #6c1a2c; font-family: Helvetica, arial, sans-serif; font-size: 13px; width: 179px; " alt="barcode" border="0"></td></tr>And here is the rendering of the barcode when receiving the delivery :The numbers of the cardNumber are displaying correctly but the first number doesn't want to appear. (the first number should be on the far left of the barcode)That means that only 12 numbers out of the 13 numbers are displayed correctly. For certain purpose, we can only use this type of barcode.Is there something wrong in this part of the HTML or anywhere else ?If you need more information about that, feel free to te

Post campaign deployment I am looking to create reports with regards to performance based on segment codes within the campaign.I can see that this is easily done in Campaign Standard:https://docs.adobe.com/content/help/en/campaign-standard/using/reporting/customizing-reports/creating-a-report-workflow-segment.html However I am having the hardest time with regards to this in Campaign Classic - any assistance would be appreciated  

Hello, Was anyone able to use the simulation module for interaction?Especially the "calculation" part, in order to be able to add more axes in the report? I add some columns but I do not find them in the reporting part.  

So Recently I got a request to create a launch container for 7 websites.The client wanted to use one Launch TMS to track data on the 7 different websites and send production data to oneGlobal report suite for all the sites.Then For one site, lets name is example 1, we send data to its own unique report suiteTo break it down we haveOne Global Report Suite - All websites data including example 1 aboveOne individual report suite - Only example 1 dataHere is how I approached it and I hope it will help someone here! STEP 1. I created a custom data element and named it config_RSID  Within the custom code editor, I created an object with the following property data typesHost -> clients domain hostnamersid -> clients report suites idnote -> clients website nameThe code example below:In this example, I used 2 sites!var my_rsid_config = [{ 'host': 'www.example.com', 'rsid': 'exampleprod', 'note': 'Example Site' }, { 'host': 'www.example.com', 'rsid': 'exampleprod1', 'note

Team, I am trying to integrate my application directly with Adobe MC RT2 instance to send rtEvents. I am calling the Session token API with the credentails shared by Adobe Support team  which is throwing "XSV-350012 Invalid login or password. Connection denied. " error message.  Appreciate  your response.

Hello, Can you help me please? When I start the same workflow in a same day 2 times, why the Delivery ID is the same? I'm trying to do a join between Tracking Logs and Delivery Logs, but because the same PK (Delivery ID) sended in only one day, it's not possible until now. Thanks in Advance

Hi,I want to know about active profiles in the adobe campaign.The adobe document says  'Active profiles are the profiles that are counted for billing purposes. “ Profile ” means a record of information (e.g.: a record in the nmsRecipient table or an external table containing a cookie ID, Customer ID, mobile identifier or other information relevant to a particular channel) representing an end-customer, prospect, or lead.'We have target mapping created for SMS which does not store any data in the recipient table. My question is 'If we are not storing  anything in recipient schema, will that be considered as active profile'   Thanks Vishal

I have requirement where i do need to add Content Disposition as inline for some specific paths. For this,I have added my component implementing Filter interface, i can see its being called (last in chain) and adding content disposition however in final rendering, its being deleted. I think some OOTB implementation is overriding content disposition. Does anyone know any other way to achieve this use case?

Does anyone know of a way to change the color of links? I'm trying to link certain things on a landing page and it's adding a line under the word in blue. I'd like to change that color if possible. I appreciate any suggestions/tips!

Hi all, I'm trying to use the new External API activity to fetch data from an external system. Is there a way to add dynamic query parameters?I have an URL that looks like this: https://api.fakedomain/some-resource?startDate=DYNAMIC_DATE  The startDate parameter is dynamic and is calulated by the workflow. In the activity, I couldn't find a way to add query parameters to generate a query like the one aboveIn the External API activity we can add inbound columns but id does not generate the correct query What is the correct way to use an URL with a dynamic query parameter? https://api.fakedomain/some-resource?startDate=DYNAMIC_DATE   Thank you

Background/Use-case: We are using AEM6.1; have configured AEM to inject log to Splunk tool. For creating SPLUNK dashboards, we need  custom/additional data from dispatcher logs.The  Splunk expects data in a specific format, to filter data from AEM logs- KEY:VALUE pair format(path:/content/us/en_us/testPage.html)ASK:Can we modify Dispatcher config/service to add new KEY:VALUE pair?  appreciate any suggestions/ideas to support the above use case.ThanksGuru

This question is asked in Adobe Classic exam & we need to choose three correct options from below four :1. Mirror Page2. Personalization3. Spam Score4. Opt -out link Please help me with correct three options. 

We are getting 404 errors for rte.min.js, default.min.js and widget.js after migration from AEM 6.2 to AEM 6.5. We are getting this error only in dispatcher so we tried allowing these filters in publish_filters.any file and the occurences of errors reduced but we can still see some errors related to rte.min.js and we got reference error for widgets.min.js. Attaching the screenshot for reference:Before dispatcher changes:After including filters in dispatcher "/libs/cq/ui/*" & "/libs/cq/searchpromote/*" Can someone please give any pointers on how we can resolve this issue? Thanks & Regards,Abhishek

Hi, Just want to check how frequency setup will work once user clears the browser cookies. Let's say, if i set the frequency as 5 to limit the no.of times view user qualify for the segment based on analytics value. If user viewed 5 times, then user should drop out of the segment. When we have this setup "clear cookies every time when i close the browser".. How the frequency setup will work? Will it remove the remove the user after 5 times if we have profile merge rule setup as " Thanks

I have the below requirement: Suppose when the end user enters http://abc-123.co.in , the rewrite rule should be set in such a way that the URL is internally expanded to its home page full URL say http://abc-123.co.in/en/home.html but the full URL should not be visible on the address bar to the end user but rather be seen as http://abc-123.co.in (with .html extension and repo structure upto 'home' removed). How do we set up a rewrite rule for this? Similarily, when the end user clicks on say, http://abc-123.co.in/en/home/about-us.html from the home page, again the full URL should not be visible to the end user but rather be seen as http://abc-123.co.in/about-us (with .html extension and repo structure upto 'home' removed). How do we set up a rewrite rule for this? 

in DTM video % rules not firing properly for cloud videos.firing properly for AEM local videos.can anyone please help how to solve this issue?

Hello,I'm using AEM6.0 with SP3.In javascript we are loading part of the transation with CQ.I18n.getMessage method./libs/cq/i18n/dict.en_us.json returns only custom translation, but /libs/cq/i18n/dict.de_de.json in additional to our custom translation returns also AEM OOTB translations.How I can prevent this for publish instance?Thank you in advance

Anyidea How to hide the workflow models for certain groups or a user in AEM 6.5?runtime workflows are updated in /var/workflow/models,In useradmin console I am unble to set permission to specific workflow model because workflowmodel is in /var/workflow/model is xml file and NOT havingmixnTypes: rep:AccessContrallable property.Adding the system tag to workflowmodel hides the workflow model for all users but to specific groupmy use case is I want hide workflow name in the dropdown option in starworkflow when specific group members trigger workflow

Hi all,I would like to ask if there is a maximum number of Custom Fields that can be added to a Custom Resource.I refer both to Extending Resource and New Resource. If not, are there some best practices or guidelines about the ideal number of Custom Fields? Thank you 

Sorry if this is been asked before and is a bit dumb, but I have a CSV list of emails and two other columns of data that is not in adobe campaign. I want to be able to use these columns of data to personalise an email which is a one off email. How do I achieve this using adobe campaign online?

Hi All, Wanted to integrate Adobe Campaign in dotnet web application to send emails. Can someone please help me with this? Regards,Anita

Hi there,I am trying to populate a custom field with a variable depending on the datetime in a field we have synced from Salesforce. Depending on the date of the Salesforce field, I want the custom field to populate with a specific string, these are different depending on the week.For some reason this flow step is not working as I would suspect and I think it is due to the datetime field not reading as between these dates. The flow step I have set up is as follows:The choices follow on as this so that each lead within each week increment gets a new value. The Segmentation Datetime field also reverts to having "12:00" at the end which I don't want (as I just want leads within these 2 dates inclusive) - I am not sure if this is the cause of my problems.During testing I could not get the flow to work with separate dates and all leads reverted to choice 1. Does anyone have any ideas?

Hi,I can see the Move option for Moving page is disable in TouchUi (sites.html) while in classic UI (siteadmin) it is working as expected in AEM 6.3 and AEM6.5 maybe from product side. what is the best way to enable Move option in TouchUi?which will be compatible with all scenario, not sure maybe we can overlay some node. not sure about approachDid anyone getting the same issue? Thank you @kautuk_sahni  @arunpatidar