Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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

View in thread

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

Translate
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)

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

Let me know if you need further help

Translate
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.

Translate
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.

Translate
sugram13Author
Level 2
November 30, 2017

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

Translate
sugram13Author
Level 2
November 30, 2017

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

Translate
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

Translate
Terms & ConditionsAccessibility statement

Loading footer...