Export the AEM tags into Excel sheet | Community
Skip to main content
dragon2A
Level 5
Jul 12, 2017 3:46 PM UTC
Solved

Export the AEM tags into Excel sheet

Hi Team,

I have a requirement to export the AEM tags to excel. Is there any OOB functionality I can use or which way is there better to do this.

Thanks In Advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
zeeshanKhan0786
zeeshanKhan0786Accepted solution
Level 5
Jul 12, 2017 4:56 PM UTC

Hi

In AEM - tags are typically created manually. However --  you can write a custom service that imports tags using the AEM TagManager API:

TagManager (Adobe AEM 6.0.0 API 6.0.0 API)

You can build the service to fetch all Tags.So you can use getNamespaces() method.This will give you Tag Array and then use getName() method to get the name of the tag and then put into the cell of Excel.

View reply

5 replies

AdolfoDePaz
AdolfoDePaz
Level 2
Jan 18, 2018 7:40 PM UTC

You can simply do http://localhost:4502/etc/tags/geometrixx.4.json (in JSON) or http://localhost:4502/etc/tags/geometrixx.feed.xml in XML feed

After, there are many converters online to transform XML/JSON to CSV

Translate
    Nestor_de_Dios
    New Participant
    Jul 13, 2017 11:15 PM UTC

    If you need to export the tags for reporting purposes, you can use the querydebug, for example:

    http://localhost:4502/libs/cq/search/content/querydebug.html?_charset_=UTF-8&query=path%3D%2Fetc%2Ftags%2Fgeometrixx-media%0D%0Atype%3Dcq%3ATag%0D%0A

    Then export the results as json and use an online tool to convert it to excel:

    http://www.json-xls.com/json2xls

    Translate
      smacdonald2008
      smacdonald2008
      Level 10
      Jul 12, 2017 4:57 PM UTC

      Use the Excel Java API as shown in the article i linked.

      Translate
        zeeshanKhan0786
        zeeshanKhan0786Accepted solution
        Level 5
        Jul 12, 2017 4:56 PM UTC

        Hi

        In AEM - tags are typically created manually. However --  you can write a custom service that imports tags using the AEM TagManager API:

        TagManager (Adobe AEM 6.0.0 API 6.0.0 API)

        You can build the service to fetch all Tags.So you can use getNamespaces() method.This will give you Tag Array and then use getName() method to get the name of the tag and then put into the cell of Excel.

        Translate
          smacdonald2008
          smacdonald2008
          Level 10
          Jul 12, 2017 4:46 PM UTC

          You would have to write a custom tool to do this. Look here - we pull data from the JCR and write out to Excel using Java: Scott's Digital Community: Developing a Java Swing Application that displays Adobe Experience Manager Data

          Hope this helps.

          Translate
            Terms & ConditionsAccessibility statement

            Loading footer...