ACS AEM tools | Resource type updater

[Vinit1]

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.

[Saravanan_Dharmaraj]

@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.

[Vinit1]

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

[Kamal_Kishor]

@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.

[arunpatidar]

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

AEM Groovy Console 

[Vinit1]

Hi,

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

[Mahedi_Sabuj]

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... 

[Kamal_Kishor · Accepted solution]

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

[Raja_Reddy]

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 

[kautuk_sahni]

@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.