Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

Export the AEM tags into Excel sheet

Avatar

Level 6

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

1 Accepted Solution

Avatar

Correct answer by
Level 5

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 solution in original post

5 Replies

Avatar

Level 10

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.

Avatar

Correct answer by
Level 5

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.

Avatar

Level 10

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

Avatar

Level 1

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

Avatar

Level 2

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