Export the AEM tags into Excel sheet

[dragon2A]

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

[smacdonald2008]

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

Hope this helps.

[zeeshanKhan0786 · Accepted solution]

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]

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

[Nestor_de_Dios]

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%2Ft...

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

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

[AdolfoDePaz]

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