Bulk Editing for SEO

[maheshp]

We have received an excel sheet with list of 500 LIVE URLs .

The ask is to hide them all from indexing (which is possible via SEO tab in page properties).

Please suggest an ideal way to do it  (since all these are random URLs from the sites and microsites), and updating 500 pages manually on a production instance is not possible.

[aanchal-sikka]

Hello @maheshp 

Please refer to the response on https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/update-aem-page-properties... 

One more option would be to use curl:

You can also write a script to read these links from excel, and execute curl command to append the property to each of these pages.

[maheshp]

@aan1 : Can you please share more details on  "You can also write a script to read these links from excel, and execute curl command to append the property to each of these pages."

[aanchal-sikka · Accepted solution]

Hello @maheshp 

1. To read an Excel you can use apache.poi APIs. Example: https://www.javatpoint.com/how-to-read-excel-file-in-java
2. Snippet to execute a curl command from Java program can be referred from https://techrevel.blog/2018/01/19/curl-execution-from-java-program/
3. Curl command to add a property to a page is 

     curl -u admin:admin -FnavRoot="true" http://localhost:4502/content/we-retail/us/en/jcr:content

Here navRoot is property name and true is the value.

I hope it helps.

[Manu_Mathew_]

@maheshp 

1. You could create a utility that updates the page properties in bulk.

2. You could make use of groovy scripting 

you could have a look at this ref. too-

https://github.com/AdobeDocs/experience-manager-65.en/blob/main/help/sites-developing/bulk-editing.m...

https://experienceleague.adobe.com/docs/experience-manager-65/developing/extending-aem/bulk-editing....

[maheshp]

The list of pages is in an excel. Can you point more details on how will these options work with an excel.