Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

ACS AEM tools | Resource type updater

Avatar

Level 1

Hi,

 

We have a requirement to update page properties meta data in bulk. For example, the text entered into the fields within the basic tab (title, description, etc...).

 

Adobe suggested us to go through Resource type updater in ACS AEM tools (https://adobe-consulting-services.github.io/acs-aem-tools/features/csv-resource-type-updater/index.h...). However when I tried to do some implementation in my local based on the description provided in above link, it didn't work. I am not sure what to put in "From" and "To" columns of the csv file. 

 

Could anyone please help.

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Vinit1 : As stated in documentation, ACS tool/utility will update the sling:resourceType OR cq:template property for your components based on what you will specify in the CSV file.

'From' is the current value of these properties and 'To' will be the updated value.
https://adobe-consulting-services.github.io/acs-aem-tools/features/csv-resource-type-updater/index.h...

Based on your first statement, what you should be using is 'Data Importer' where you can specify the property-name and the value for each page. Please refer these ACS links on how to work with this.
https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp-tools/data-importer/index.h...

This one has details on how to prepare your data for bulk import.
https://adobe-consulting-services.github.io/acs-aem-tools/features/csv-asset-importer/index.html

 

 

 

View solution in original post

9 Replies

Avatar

Community Advisor

@Vinit1 You just need to create 2 columns(1st: From, 2nd : To) in csv file as shown in the pic and upload the csv and do the remaining things in the UI.

 

Saravanan_Dharmaraj_0-1703261175769.png

 

Avatar

Level 1

Hi,

 

I had this question only that what should I put in From and To value in case of updating the title, description fields. From the screenshot, It is not clear.

 

If you can give any example which you tried, that would be helpful

Avatar

Community Advisor

@Vinit1: I think you can do this easily using ACS Data Importer data-importer . You just have to create a excel sheet with title, desc etc values for each page and provide the name of properties in excel sheet columns. This should be easier for your content authors as well.

Please refer the link and let me know if you need any clarification.

Avatar

Community Advisor

Hi @Vinit1 
You can try Groovy to update properties using json data(from and to mapping as json).

AEM Groovy Console 



Arun Patidar

Avatar

Level 1

Hi,

 

From author perspective, it will be difficult for them to work with Groovy console.

Avatar

Community Advisor

Hi @Vinit1,

Resource Type Updater is designed to bulk update sling:resourceType and cq:Template properties. To update page properties such as Title, Description; you can utilise AEM Bulk Editor.

Adobe Documentation: https://experienceleague.adobe.com/docs/experience-manager-65/content/sites/administering/operations... 

Avatar

Correct answer by
Community Advisor

Hi @Vinit1 : As stated in documentation, ACS tool/utility will update the sling:resourceType OR cq:template property for your components based on what you will specify in the CSV file.

'From' is the current value of these properties and 'To' will be the updated value.
https://adobe-consulting-services.github.io/acs-aem-tools/features/csv-resource-type-updater/index.h...

Based on your first statement, what you should be using is 'Data Importer' where you can specify the property-name and the value for each page. Please refer these ACS links on how to work with this.
https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp-tools/data-importer/index.h...

This one has details on how to prepare your data for bulk import.
https://adobe-consulting-services.github.io/acs-aem-tools/features/csv-asset-importer/index.html

 

 

 

Avatar

Community Advisor

Hi @Vinit1 

Previous project, I followed the same approach, and it worked successfully.

You can try using Groovy to update properties using JSON data with mappings for 'from' and 'to'.

AEM Groovy Console 



Avatar

Administrator

@Vinit1 Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.



Kautuk Sahni