Bulk Editing for SEO

Forum|Forum|2 years ago
June 9, 2023
2 replies
1310 views

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.

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 aanchal-sikka

Hello @parakhma

To read an Excel you can use apache.poi APIs. Example: https://www.javatpoint.com/how-to-read-excel-file-in-java
Snippet to execute a curl command from Java program can be referred from https://techrevel.blog/2018/01/19/curl-execution-from-java-program/
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.

aanchal-sikka

Community Advisor

Hello @parakhma

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

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.

Aanchal Sikka

P

ParakhMaAuthor

Level 3

@9540315 : 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."