ACS AEM tools | Resource type updater | Community
Skip to main content
December 22, 2023
Solved

ACS AEM tools | Resource type updater

  • December 22, 2023
  • 6 replies
  • 2233 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Kamal_Kishor

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.html#:~:text=Resource%20Type%20Updater%20is%20a,Column%202%3A%20TO%20value

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

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

 

 

 

6 replies

Saravanan_Dharmaraj
Community Advisor
Community Advisor
December 22, 2023

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

 

 

Vinit1Author
December 28, 2023

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
Community Advisor
Community Advisor
January 2, 2024

@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
Community Advisor
Community Advisor
December 22, 2023

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

AEM Groovy Console 

Arun Patidar
Vinit1Author
December 28, 2023

Hi,

 

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

Mahedi_Sabuj
Community Advisor
Community Advisor
December 22, 2023

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/bulk-editor.html?lang=en 

Mahedi Sabuj
Kamal_Kishor
Community Advisor
Kamal_KishorCommunity AdvisorAccepted solution
Community Advisor
December 22, 2023

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.html#:~:text=Resource%20Type%20Updater%20is%20a,Column%202%3A%20TO%20value

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

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
Community Advisor
Community Advisor
December 22, 2023

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
Community Manager
Community Manager
January 2, 2024

@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