Using ACS Commons => Manage Controlled Processes => Data Importer tool to bulk update nodes.
ACS Commons - Data Importer
It's a great tool but I'm not able to use it to clear a value.
Here's an example:
A .csv or .xlsx file contains
Column1 Column2
path propertyName
/nodelocation1 Some String1
/nodelocation2 Some String2
I would like to remove the property value for all nodes in column1.
Desired solution 1: there is an escape character that will replace the value with a null or empty space.
Desired solution 2: there is a different tool that lets me delete the specific property from nodes in bulk (NOT delete the node. Just the property on the node)
Limitations:
- solution must be available for users who do not have access to backend. it must be accessible through AEM interface. CRXDE is accessible. the old CQ (siteadmin#/cf#) interface is accessible.
- solution must work on arbitrary list of nodes. solution involving a query means the targeted nodes need to have a common property. sometimes the nodes I need to update are products that are hand selected by marketing people which do not have a common property I can query for. also, other users who need to learn the method are not technical enough for queries.
I would like to ask the community for help because I can't find anywhere in the documentation on how to do this. I've searched the forum for similar questions but wasn't able to find any. So far, it seems to me like my only option is to ask my backend to build a custom tool. Although, it seems like it would be a very common operation. I'm surprised it's not built into AEM somewhere?
