Adobe Experience Manager Sites & More

rahul234dabas · 10/10/22

I have a csv file placed in dam , I want to write a groovy script to update the csv file with the new data,

the data I am able to fetch with the script only thing that is require is to push it into csv file

e.g : how to push "demo data " to csv file

Please help me out here, what could be the possible solution for this

Thank you

arunpatidar · 10/11/22

@rahul234dabas
Use Asset API to get the binray data of csv, IO API will not work here.

Resource rs = resourceResolver.getResource(path);
Asset asset = rs.adaptTo(Asset.class);

// We have the inputstream
InputStream data = asset.getOriginal().getStream();

Arun Patidar

View solution in original post

arunpatidar · 10/10/22

Please check if this helps https://blogs.apache.org/groovy/entry/reading-and-writing-csv-files

Arun Patidar

rahul234dabas · 10/10/22

@arunpatidar I am getting file not found error even when I have placed the file at the same place

:

filePath = "/content/dam/demo/output.csv";

File file = new File(filePath);
def rows = file.readLines().tail()*.split(','); // getting exception here as file not found exception
println "the file is : "+ rows;

The file is present in the location and is published also not sure why it's not picking it up

arunpatidar · 10/11/22

@rahul234dabas
Use Asset API to get the binray data of csv, IO API will not work here.

Resource rs = resourceResolver.getResource(path);
Asset asset = rs.adaptTo(Asset.class);

// We have the inputstream
InputStream data = asset.getOriginal().getStream();

Arun Patidar

rahul234dabas · 11/2/22

@arunpatidar thank you for the solution , I am now able to access the file in dam , I want to update data with my script in the mentioned file , can you tell me how to do it?

thank you