Bulk editor is a highly functional tool for efficient editing of multiple node properties in AEM. It lets you add new properties and edit the existing ones. The searching of nodes is also optimized with the use of GQL (Google Query Language).
At Argil DX, we were using the bulk editor for quick data updates when we came across two obvious and relevant issues:
Bulk editor’s inability to add multi-value node properties
Only ‘String’ datatype is allowed
Seems like Adobe has also stopped any further development for the bulk editor post AEM 6.4
An Extension that Makes the Existing Bulk Editor More Functional
We thought of making some minimal (but important) changes to the existing code base to rectify the above-mentioned issues.
Here you can see the changed interface for “Column Properties”. Now you can add “Property Name” along with the data-type (selectable from the dropdown) and continue editing the existing ones (Refer img-2).
To add multi-value properties, you’ll just have to surround your data (comma separated values ) with ‘[‘ and ‘]’ (Refer “prop1” in img-3).
The exported .tsv file looks like:
If you wish to import a new .tsv file, design it similar to “img-4”.