Solved

How to remove whitespaces, tabs, and other elements that are not part of the content of the field?I've a column MES of the format: 202309 (for september of 2023) on format string in the schema and string in the configuration of the import activity.I want to remove whitespaces (tabs, etc) , in order to make indexing on this column faster.  What would be the best approache?I'm using Campaign v7 Classic.

I tried deleting 5M records where TIPVENTA column is equal to 23, but got this error:  24/09/2023 17:53:46 WDB-200001 SQL statement 'UPDATE BcpLEAD SET FROM wkf58347283_273_1 OutTbl WHERE BcpLEAD.iLEADId=OutTbl.iPKey_1 AND OutTbl.iRecProcState>:#(1)# AND OutTbl.iRecProcState<=:#(2)# AND OutTbl.iPKey_1<>0' could not be executed. Param(0)=100 Param(1)=101    

I have a servlet class in this class I'm calling sling job from sling job calls service class. Once bundle is deployed, I'm seeing sling job is working as expected after hitting the servlet. But when I hit the servlet for second time sling job is not working.

Team, Can we export data from a given DATASET to external server as FTP or some other method?As I get to see data under a DATASET using query mode and I want those data to export as FF, is this possible? Thanks in Advance.

Several assets share common users who are unable to extract downloaded ZIP files on Windows due to the restricted path length of 256 characters. By default, the asset download process wraps the assets inside a folder with the same title as the asset, effectively doubling the path length when extracting the ZIP file. The "flatStructure" hidden field value  determines whether to wrap the assets inside a folder with the title name or not. When "flatStructure" is set to false, it creates an additional folder hierarchy, whereas setting it to true prevents the creation of an additional folder. Therefore, it would be beneficial to have an option to control the "flatStructure" through the authoring dialog property, providing content authors with the choice to enable or disable it. Can I request the contributors to include this option in future releases?

Hi team, We are getting an error logs like below. Anyone has idea on this why it's coming. 24.08.2023 09:32:37.387 *ERROR* POST /content/dam/dam:batch.metadata.json HTTP/1.1] org.apache.sling.servlets.post.impl.operations.ModifyOperation Exception during response processing. org.apache.sling.api.resource.PersistenceException: Unable to create node at /content/dam/dam:batch.metadata.json at org.apache.sling.jcr.resource.internal.helper.jcr.JcrResourceProvider.create(JcrResourceProvider.java:480) [org.apache.sling.jcr.resource:3.0.18] ... 160 lines omitted ... at java.lang.Thread.run(Thread.java:748) Caused by: javax.jcr.nodetype.ConstraintViolationException: No default node type available for /content/dam/dam:batch.metadata.json

I'm using AEM 6.5 and I'm working on a component that lists published child pages only. At first I used the page properties cq:lastReplicationAction   and  cq:lastReplicationAction to make sure I get only the published pages as needed. The component worked as needed in author instance. However, upon testing in publish instance, the component shows nothing. After some research, I discovered that the page properties I used are not carried over to publish by design. A workaround I found online was to manually disable the component com.day.cq.replication.impl.ReplicationPropertiesFilterFactory in author instance or to use the OSGi Component Disabler (OSGi Component Disabler (adobe-consulting-services.github.io) ). I'm hesitating with this workaround because we have multiple sites on the same AEM instance and that means the ReplicationPropertiesFilterFactory component will be disabled for all sites and I don't know the risks. After much thought and conside

Hi All- we are trying to send MQL notifications to the appropriate sales reps but the issue is that the Sales Owner (Lead Owner/Contact Owner in CRM) or Account owner is not the field that we want to use as the recipient of the emails. So, for now we add the actual recipient of the email to the  'to other emails' section and leave the 'Send to' section as the Sales Owner. This leads to email going out to incorrect people and the appropriate people just being CCed on it.   So, my questions are: 1. Can any other Owner field be added in the 'Send to' drop down? OR 2. Can we set the 'Send to' to 'None' and the recipients mentioned in the 'to other emails' will still get the email?

I want to use ITextRenderer to generate a PDF so I have added maven depdency in parent POM and core module POM, Parent POM <dependency> <groupId>org.xhtmlrenderer</groupId> <artifactId>flying-saucer-pdf-itext5</artifactId> <version>9.0.1</version> </dependency>  Core POM <dependency> <groupId>org.xhtmlrenderer</groupId> <artifactId>flying-saucer-pdf-itext5</artifactId> </dependency> I am importing import org.xhtmlrenderer.pdf.ITextRenderer in java class. I dont see any error in compilation but after deployment in AEM, the core bundle is in "INSTALLED" state. when I check error it says "org.xhtmlrenderer.pdf -- Cannot be resolved"  Do I need to add any import package in order to resolve the dependency issue ? if yes where should i add ? Below is my  bnd-maven-plugin plugn in core POM,  <plugin> <groupId>biz.

I have a table called: LEAD, with namespace: abc. I'm using V7 Classic.I've to remove all rows, since data is flawed and load new data. 1.- Create workflow that: Loads Table Lead:  with no filtering condition since I want to remove all rows from all columns, right? 2.- In a SQL Activity just use:  only LEAD or abc:LEAD (adding the namespace)?3.-  Should I TRUNCATE and RESTART IDENTITY?TRUNCATE TABLE table_nameRESTART IDENTITY;My Lead schema is: <srcSchema _cs="LEAD (abc)" created="2020-11-18 16:13:03.156Z" createdBy-id="0" entitySchema="xtk:srcSchema"img="xtk:schema.png" label="LEAD" lastModified="2022-08-12 19:59:36.347Z"md5="9031FA3A1C8D10C7DCAD432B12E1F32B" modifiedBy-id="0" name="LEAD" namespace="abc"xtkschema="xtk:srcSchema"><element autopk="true" label="LEAD" name="LEAD"><attribute label="Id Recipient" name="RECIPIENTID" type="long"/><attribute label="Segmento Comercial" name="DESSEGMENTOCOMERCIAL" type="string"/><element i

I was thinking about creating a QR code but I was wondering how it would work with Marketo. For example, we have a trade show coming up and we want to have QR codes by the machines so they can watch YouTube videos of our products straight from their phone. What would be the best way to go about doing this so we can track who exactly watches the video, uses the QR code, etc.?Any help would be appreciated! Thanks so much! 

Hi Community, I have a requirement where we want to track login and logout of author users in the AEM author instance , How can we do that ? I tried creating a sling filter where we can check for login and logout URL, for this i am targeting j_security_check as login URL and /system/sling/logout as logout URLI am able to get logout URL but not able to get login URL in sling filter Please Help me with this or suggest some ideas to track login activity for a user 

HiIs there a way to make a shared dashboard showing traffic from a single CID-trackingcode, that is appended to the URL of the very dashboard.So if https://URL-to dashboard?CID-trackingcode, then the dashboard fetch the queryString CID-trackingcode and filter the dashboard, so only relevant data for this specific CID-tracking code is shown in the dashboard. Is it possible and how?Hope anyone knows:-)

Hello All,I had the same question as [1] , and from the response to that and a very good article regarding this topic at [2] , makes me conclude that for AEM as a cloud service using AEM community Sites without support may not be feasible and wise. So based on this fact my actual question here is -Has anyone explored other alternatives for implementing social communities in AEM cloud? There is a mention of using  Disqus, Hyvor Talk, Discourse etc in [2], if someone has implemented these or any other solutions please update here with some initial set up info.@arunpatidar - Did you end up using something for this?[1] -https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-community-sites-supports-in-aem-as-a-cloud-service/td-p/362935[2] -  https://www.opsinventor.com/whats-the-future-of-aem-communities/cc @kautuk_sahni P.S AEM communities implementation is one of the favorite features of our user

<tr><td class="w100p_m hauto_m show_m bg-mob-image" align="center" valign="top" aria-hidden="true" height="329px" background="https://bmw-eu-apac-mkt-prod1-m.adobe-campaign.com/res/img/2F955E062A5EBD0BD8F4C8F2A0C0372F.jpg" style="background-image: url('https://bmw-eu-apac-mkt-prod1-m.adobe-campaign.com/res/img/2F955E062A5EBD0BD8F4C8F2A0C0372F.jpg'); background-position: center center; background-repeat: no-repeat; background-size: cover; font-size:2px; line-height:2px; mso-hide: all; "><img src="<%= targetData.optionsCode %>" class="w100p_m hauto_m show_m" width="100%" height="100%" border="0" style="display:none; visibility:hidden; mso-hide: all;" alt=""></td></tr>Hi above is the my code used in emailer. img src="<%= targetData.optionsCode %>" this is not working properly. I got this code from ACC tester & image not seen. I don't know what the issue 

Hello, I’m trying to figure out why some of my percentages when using eVars are adding up to > 100%.For example, in one of my eVars, "Is Using Push Notifications", the numbers are:- NO = 76.8%- YES = 30.6%- Total = 107.4%Since this is state, how is that possible that a user could occupy both yes and no? Don't eVars store the state and then replace it when it's updated? Thanks! 

Hi there! I'm trying to create a view or report that will show me which custom forms are tied to each of our project templates (vise versa) and can't seem to figure out a solution. Is this possible?

I was doing some practises, and without knowing i modify the node of html5page in the lib folder, i tried to revert all changes but it seems that i wasn't at all success. A cowork of mine, export the json of that node, so i was wondering if i could reimport it in that folder? Is it possible to do that?thanks 

HI i am learning about AEM and doing some practices, but i am having some issues with following some steps as i do it as it says but the result is not the one expected.In this case i created a site in crxlite but when i truy to add the properties in the AEM "admin" it is totally blank, here is the example:  the node improntus is in the file /content/imrpontus and this is what i see when i try to access its properties:  can anyone guide me what could be the issue here?thanks

I am new one to adobe campaign classic it is possible to create more than one primary key in custom schema? 

Hi Team, I get the following error, when ingesting data to AEP. I am attaching the code that I am using. Could you please guide meError ingesting data: 403{"type":"/placeholder/type/uri","status":"403","title":"Forbidden","detail":"Unable to execute [Response Status Code = 403] @ uri: https://platform.adobe.io/data/foundation/catalog/dataSet/650c8fb325ed3928d3cc08e2?properties=id%2CimsOrg%2Cdescription%2Cname%2Cupdated%2CcreatedClient%2CviewId%2Ctags%2CfileDescription%2Cschema%2CschemaRef due to: {\"type\":\"/placeholder/type/uri\",\"status\":403,\"title\":\"ForbiddenError\",\"detail\":\"Given user does not have permission to resource [object Object] action read status 403\"}"}PS 

Hi, The source data is sending the date in format: "May 28 2020 8:07AM". I have to map this field to a dateTime field. How can I do it?I tried using this as a calculated field with logic: date(Last_Status_Update_Date,"L dd yyyy h:mma"), but my field didn't get any values.I will appreciate any help on how to transform this field to zoned dateTime format. Thanks,Swastika.

I want to make the report with the filter of date when the task status changed to X, how do I do that as I don't see any option like that in the filter and there is no solution anywhere?  It's such a basic function and we continue to struggle to use workfront like this.

Hello, what happens is that I am following the guide of:https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-modify-a-crxde-file-from-the-ide-code/m-p/619862#M155450To modify a just a file called fileupload.js that is in charge of validating information and uploading the asset in AEM using DAM.What happens is that I am in the final step where only remains to add the path of the file that I created in filter.xml.But when I add the complete path that would be the following one:/apps/dam/gui/coral/components/commons/fileupload/clientlibs/fileupload/jsI get the following error:is not covered by any of the specified dependencies nor a valid rootBut when I add the path in short version it allows me to do the following:/apps/damBut when I do the DAM when I click on create to upload an asset, the button does not work anymore.What can I do in this case?, I already try to add the differents mode (replace, merge and update) and add the complete path but nothing of this

Hey Community 🙂 We utilize a system of (really two) numeric IDs in the URL string after a user clicks on an ad that represents which exact creative (d_creative=) and which advertising channel, audience, etc (sc_dcm=) the user saw/clicked on to make it to our website.So a final URL string could look as such for two different users:URL: http://www.example.com/path1/path2/path3?d_creative=12345&sc_dcm=678910URL 2: http://www.example.com/path1/path2/path3?d_creative=34567&sc_dcm=78911These IDs all then live in flat, simple (automatically updated) data lookup tables that translate the numeric values to a human readable name.e.g. for the two creative values:Creative ID | Creative Name12345 | product1_cta-example-a34567 | product2_cta-example-a... | .... (~ 10,000 rows) or the two Media Placement values:Placement ID | Placement Name678910 | facebook_audience178911 | youtube_audience1... | ... (~ 8,000 rows) These two tables get pushed into Adobe Analyt