Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Export the AEM tags into Excel sheet

dragon2A
Level 6
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
zeeshanKhan0786
Correct answer by
Level 5
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
smacdonald2008
Level 10
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.

zeeshanKhan0786
Correct answer by
Level 5
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

smacdonald2008
Level 10
Level 10

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

Nestor_de_Dios
Level 1
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

AdolfoDePaz
Level 2
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