Export the AEM tags into Excel sheet | Community
Skip to main content
Level 5
July 12, 2017
Solved

Export the AEM tags into Excel sheet

  • July 12, 2017
  • 5 replies
  • 6049 views

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.
Best answer by zeeshanKhan0786

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.

5 replies

smacdonald2008
Level 10
July 12, 2017

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.

zeeshanKhan0786
zeeshanKhan0786Accepted solution
Level 5
July 12, 2017

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.

smacdonald2008
Level 10
July 12, 2017

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

July 13, 2017

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

AdolfoDePaz
Level 2
January 18, 2018

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