export JCR properties to excel sheet

Avatar

Avatar
Give Back 5
Level 2
sivas61374651
Level 2

Likes

2 likes

Total Posts

37 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile

Avatar
Give Back 5
Level 2
sivas61374651
Level 2

Likes

2 likes

Total Posts

37 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
sivas61374651
Level 2

24-08-2018

Hi All,

I want to export the jcr:content of the page including all the component details like property name and value to the excel sheet. I need to do this in AEM 6.1. Can anyone already did like this? Appreciate your help.

Feike Vissersmacdonald2008Arun Patidar

Thanks,

Vijay

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 25
MVP
Ratna_Kumar
MVP

Likes

159 likes

Total Posts

755 posts

Correct reply

134 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give Back 50
Give Back 5
View profile

Avatar
Validate 25
MVP
Ratna_Kumar
MVP

Likes

159 likes

Total Posts

755 posts

Correct reply

134 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give Back 50
Give Back 5
View profile
Ratna_Kumar
MVP

24-08-2018

Hi Siva,

Yes, we can do it. We have an HELPX article that talks about your use case.

Adobe Experience Manager Help | Creating a Custom Reporting Service for Adobe Experience Manager

Thanks,

Ratna Kumar.

Answers (2)

Answers (2)

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,409 likes

Total Posts

12,671 posts

Correct reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,409 likes

Total Posts

12,671 posts

Correct reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

24-08-2018

To write out data to Excel -- yOu need to write a custom service that uses Excel API. It does not matter where the data comes from - a relational database, the JCR, etc, You still need to write an AEM Service that uses the Excel API as specified in that link that Ranta provided. AEM does not offer an OOTB Excel endpoint.

Avatar

Avatar
Give Back 5
Level 2
sivas61374651
Level 2

Likes

2 likes

Total Posts

37 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile

Avatar
Give Back 5
Level 2
sivas61374651
Level 2

Likes

2 likes

Total Posts

37 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
sivas61374651
Level 2

24-08-2018

Hi Ratnakumar,

Thanks for your reply. I have read the link and that link is for reading the data from DB using datasourcepool and export into Excel. But my requirement is, I'm having some contents in page and just want to export the content in to Excel/txt file. I believe, to achieve this I no need to go with an any costly operation like the link which you provided.

Thanks,

Vijay