Component Report | Community
Skip to main content
S
sugram13
Level 2
November 30, 2017
Solved

Component Report

  • November 30, 2017
  • 8 replies
  • 10880 views

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

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 Techaspect_Solu

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

8 replies

smacdonald2008
smacdonald2008
Level 10
November 30, 2017

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 Manager 6.3 Data

Amit-Tiwari
Amit-Tiwari
Level 4
November 30, 2017

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)

Amit-Tiwari
Amit-Tiwari
Level 4
November 30, 2017

Let me know if you need further help

S
sugram13Author
Level 2
November 30, 2017

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.

Amit-Tiwari
Amit-Tiwari
Level 4
November 30, 2017

Its working fine for me.

what problem you are facing?

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

S
sugram13Author
Level 2
November 30, 2017

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

S
sugram13Author
Level 2
November 30, 2017

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

Techaspect_Solu
Techaspect_SoluAccepted solution
Level 7
November 30, 2017

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

Terms & ConditionsAccessibility statement

Loading footer...