Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Component Report

Avatar

Level 2

Anyway where we can pull out the components used in a particular page and get it exported to excel file?

1 Accepted Solution

Avatar

Correct answer by
Level 7

Hi,

Please follow the below steps . It worked fine for us -

1) Select your required page to see component report at http://localhost:4502/etc/reports/compreport.html

2) Now hit the below URL. It gives you JSON output.

http://localhost:4502/etc/reports/compreport/jcr:content/report.data.json

3) Copy paste the generated JSON output at below URL and click on JSON to excel

http://www.convertcsv.com/json-to-csv.htm

You should be generating excel report now.

We hope this information helps!

Regards,

TechAspect Solutions

View solution in original post

8 Replies

Avatar

Level 10

You can build a tool that queries that information using JCR SQL2 - similar to how we query users here and dump the JCR Data into Excel -- Adobe Experience Manager Help | Developing Java Swing Applications that displays Adobe Experience Ma...

Avatar

Level 4

yes you can.

go to miscadmin and create a component report.

for exporting in excel you need little change that you can find here.

FAQ: Export AEM6 Reports to Comma Separated Values (CSV)

page.PNGcomp.PNG

Avatar

Level 4

Let me know if you need further help

Avatar

Level 2

I had gone through component report earlier as well but the thing about csv export.It is still not working.the link you sent to export to csv ,it is not getting exported.

Avatar

Level 4

Its working fine for me.

what problem you are facing?

is it not downloading or there is no data in the exported file.

Avatar

Level 2

it is not downloading ..I can see the response in console on debugging but not getting downloaded.

Avatar

Level 2

it is not downloading ..I can see the response in console on debugging but not getting downloaded.

Avatar

Correct answer by
Level 7

Hi,

Please follow the below steps . It worked fine for us -

1) Select your required page to see component report at http://localhost:4502/etc/reports/compreport.html

2) Now hit the below URL. It gives you JSON output.

http://localhost:4502/etc/reports/compreport/jcr:content/report.data.json

3) Copy paste the generated JSON output at below URL and click on JSON to excel

http://www.convertcsv.com/json-to-csv.htm

You should be generating excel report now.

We hope this information helps!

Regards,

TechAspect Solutions