[AEM6.5] Unpublish and Removing Bulk Assets [using path from CSV]

Hi @tushaar_srivastava 

You need to write a custom service using Java and create an OSGi bundle.

ACS Util for CSV: https://github.com/Adobe-Consulting-Services/acs-aem-tools/blob/master/bundle/src/main/java/com/adobe/acs/tools/csv/impl/CsvUtil.java

https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp-tools/data-importer/index.html

You can read the file in your custom java code like this: https://stackoverflow.com/questions/58877269/to-read-csv-xlsx-files-present-under-dam-in-aem

Then use the replication API to unpublish and later delete the asset.

Hope this helps.

Thanks,

Kiran Vedantam.

Hi @tushaar_srivastava 

I agree with @santoshsai as it is one time activity, preferable is go with groovy.

Please find the sample code which i used in one of our project to read the CSV.

import com.day.cq.dam.api.Asset;
import com.day.cq.dam.api.Rendition;
import java.util.stream.Collectors;

csvUsersPath = "/content/dam/sample.csv";

Resource csvResource = resourceResolver.getResource(csvUsersPath);

if(null != csvResource){
    Asset asset = csvResource.adaptTo(Asset.class);
    if(null != asset){
        Rendition rendition = asset.getOriginal();
        if(null != rendition){
            InputStream inputStream = rendition.getBinary().getStream();
            BufferedReader reader = new BufferedReader(new InputStreamReader(inputStream));
            List<String> assetRecords = reader.lines().collect(Collectors.toList());
            assetRecords.remove(0);

            Session session = resourceResolver.adaptTo(Session.class);

            for (String record : assetRecords) {
                session.save(); 
                activate(path);
            }
        }
    }
}else {

}

Hope this is helpful.

Thank you @kiran_vedantam . @santoshsai , @mani_kumar_  for your response, I am quite new to groovy script learning how to manage unpublish and delete assets, till now I did some basic operation like reading and removing the assets.

def csvFile = new File('/path/to/csv/file.csv')
def assetPaths = []

// Read the CSV File line by line
csvFile.eachLine { line ->
    def path = line.split(',')[0]
    assetPaths.add(path)
}

// Iterate over the asset paths and remove the assets from AEM
assetPaths.each { path ->
    def resource = resourceResolver.getResource(path)
    if(resource != null) {
        resource.delete()
    }
}

But maybe need help to review and how to accomodate unpublish before deleting.

or is this correct approach to remove bulk assets