Skip to main content
Himanshu_Singhal
Community Advisor
Community Advisor
May 2, 2017
Risolto

Read CSV file data stored in DAM

  • May 2, 2017
  • 2 risposte
  • 6287 visualizzazioni

Hi,

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

How can I do that?

Thanks,

Himanshu

Questo argomento è stato chiuso alle risposte.
Migliore risposta di cquser1

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/ 

2 risposte

cquser1
cquser1Risposta
Level 7
May 3, 2017

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/ 

smacdonald2008
Level 10
May 3, 2017

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