Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

Read CSV file data stored in DAM

Avatar

Community Advisor

Hi,

I've CSV file stored in DAM and I need to read data programmatically.

How can I do that?

Thanks,

Himanshu

1 Accepted Solution

Avatar

Correct answer by
Level 8

Hi,

I could think of the below :

Have a service user to read the file, which will be probably be placed at a specific DAM location. Sharing few snippets, which might help you.

Node assetNode = session.getNode(damPath);

Use ResourceResolver, adapt it to an Asset and further do the below :

BufferedReader br = new BufferedReader(new InputStreamReader(asset.getRendition(Constants.ORIGINAL).getStream()));

For further processing, the below link might help

https://www.mkyong.com/java/how-to-read-and-parse-csv-file-in-java/ 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 8

Hi,

I could think of the below :

Have a service user to read the file, which will be probably be placed at a specific DAM location. Sharing few snippets, which might help you.

Node assetNode = session.getNode(damPath);

Use ResourceResolver, adapt it to an Asset and further do the below :

BufferedReader br = new BufferedReader(new InputStreamReader(asset.getRendition(Constants.ORIGINAL).getStream()));

For further processing, the below link might help

https://www.mkyong.com/java/how-to-read-and-parse-csv-file-in-java/ 

Avatar

Level 10

cquser is correct - you need to write a custom service using Java and create an OSGi bundle