AEM 6.4 - Asset metadata CSV file upload - metadata update issue

[sujeetsharma]

We are planning to utilize, AEM 6.4 metadata download and update using CSV file.

But we have observe that it does not delete the asset's metadata value if column value is blank in CSV against a property.

Steps to repro are -

1. Download the metadata csv file.
2. Open file and delete a value in csv.
3. Upload it using create > metadata option in dam.
4. Go back in crxde or dam properties to check if value is removed for property against which value was blank in csv.

Kindly share if any workaround. Its one of requirement we have to implement.

Regards,

Sujeet

[smacdonald2008]

I would look at writing a custom workflow step. Invoke that workflow - place the CSV file in a location on the server where it can be read  and have the custom step update asset meta node with a custom step.

That way - you have complete control over the asset and its metadata in the workflow. See this HELPX article where we modify an asset metadata node prop from a workflow - - Scott's Digital Community: Invoking an Adobe Experience Manager Custom 6.4 Workflow from a web page