Highlighted

Using Bulk Editor to target all descendants within directory

ryanhal

20-11-2019

Hi!

I'm using Bulk Editor to import TSV files in order to add image paths to content pages in AEM, similar to this example:

jcr:path
imageUrl
/content/parent1/child1/jcr:content/typeA/content/dam/image1.jpg
/content/parent1/child2/jcr:content/typeA/content/dam/image1.jpg
/content/parent1/child3/jcr:content/typeA/content/dam/image1.jpg
/content/parent2/child1/jcr:content/typeA/content/dam/image2.jpg
/content/parent2/child2/jcr:content/typeA/content/dam/image2.jpg
/content/parent2/child3/jcr:content/typeA/content/dam/image2.jpg

Instead of six rows where each subdirectory is specified ("/child1/", "/child2/", "/child3/"), is there a way to accomplish this same thing by targeting the parent directories ("/parent1/", "/parent2/"), thus affecting all descendant directories contained within?

The solution I'm hoping for might look something like this:

jcr:path
imageUrl
/content/parent1/jcr:content/typeA/content/dam/image1.jpg
/content/parent2/jcr:content/typeA/content/dam/image2.jpg

...for example, where by targeting /parent1/, files within descendent directories /parent1/child1/, /parent1/child2/, and /parent1/child3/ are all updated with the same image URL.

Hope that's clear. Thanks in advance for any help!