AEM 6.1 Asset Reporting

Avatar

Avatar
Validate 1
Level 1
andrewl26728945
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
andrewl26728945
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
andrewl26728945
Level 1

27-09-2018

Is there a way in AEM version 6.1 to get a list of all assets and associated meta data into an excel file?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
raj_mandalapu
MVP

Likes

125 likes

Total Posts

203 posts

Correct reply

72 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
raj_mandalapu
MVP

Likes

125 likes

Total Posts

203 posts

Correct reply

72 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 5
Give Back 3
View profile
raj_mandalapu
MVP

10-10-2018

AEM 6.4 :

There is not OOTB functionality in AEM 6.1 but it is available in AEM 6.4

https://helpx.adobe.com/experience-manager/kt/assets/using/metadata-import-feature-video-use.html

ACS-Commons :

If you are using acs-commons then you can use CSV Asset Importer, check below link

CSV Asset Importer

There are so many open source tools are available in the market to convert CSV to excel, so you can use those along with the ACS-Commons CSV Asset Importer.

I prefer this for single time execution or multiple times because it involves a manual approach

Custom solution ;

If you want to avoid converting CSV to Excel using a tool and you want to run this as cron job then it is better to write custom job

If the above step does not meet your requirement then you need to write custom code which reads all assets metadata and export it into excel format.

Answers (1)

Answers (1)

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

10-10-2018

YOU can write a custom service and use Excel API - see this older community article for a discussion on use of Excel API - Adobe Experience Manager Help | Creating a Custom Reporting Service for Adobe Experience Manager