Bulk Editing for SEO | Community
Skip to main content
ParakhMa
Level 3
Jun 9, 2023 10:24 AM UTC
Solved

Bulk Editing for SEO

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.
aanchal-sikka
aanchal-sikkaAccepted solution
New Participant
Jun 10, 2023 2:06 PM UTC

Hello @parakhma 

 

  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.

 

Aanchal Sikka
View reply

5 replies

Manu_Mathew_
Manu_Mathew_
New Participant
Jun 10, 2023 6:06 AM UTC

@parakhma 

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

https://experienceleague.adobe.com/docs/experience-manager-65/developing/extending-aem/bulk-editing.html?lang=en

 

Translate
    ParakhMaAuthor
    Level 3
    Jun 10, 2023 8:21 AM UTC

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

    Translate
      aanchal-sikka
      aanchal-sikka
      New Participant
      Jun 9, 2023 1:12 PM UTC

      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.

      Translate
      Aanchal Sikka
        ParakhMaAuthor
        Level 3
        Jun 10, 2023 9:49 AM UTC

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

        Translate
          aanchal-sikka
          aanchal-sikkaAccepted solution
          New Participant
          Jun 10, 2023 2:06 PM UTC

          Hello @parakhma 

           

          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.

           

          Translate
          Aanchal Sikka
            Terms & ConditionsAccessibility statement

            Loading footer...