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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Component Report

sugram13
Level 2
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
Techaspect_Solu
Correct answer by
Level 7
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

0 Replies
smacdonald2008
Level 10
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...

Amit-Tiwari
Level 4
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

Amit-Tiwari
Level 4
Level 4

Let me know if you need further help

sugram13
Level 2
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.

Amit-Tiwari
Level 4
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.

sugram13
Level 2
Level 2

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

sugram13
Level 2
Level 2

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

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