Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Coral UI based Bulk Editor

Avatar

Avatar
Boost 5
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
namitg64472720
Employee

04-10-2017

Bulk Editor has been around with since a long time. It has been a useful tool for making mass edits to node/resource properties.

However, the OOTB Bulk editor implementation is a legacy one, based on classic UI. Also, from a functionality standpoint as well, there are some limitations:

1. Import-Export of data is not available: OOTB Bulk Editor supports exporting the search results in the form of a TSV file. However, there is no way to update the properties and import it back in AEM.

2. Absence of mechanism to add new properties:  There is no way to add new properties in the OOTB Bulk Editor.

3. Legacy Query Language for search: OOTB Bulk Editor supports GQL for searching.

4. Absence of interactive shell: OOTB Bulk Editor doesn’t come with an interactive shell for updating the properties without import-export mechanism.

I have been working on developing a Touch UI Based implementation of the aforesaid concept, aiming to fill the aforesaid gaps. I have able to come up with a bleeding edge version. The new touch ui based implementation comes with following features :

1. Support for different query Language : JCR SQL 2, XPATH & Query Builder Map.

2. Export - Import based data update

3. Interactive shell for updating the properties.

The Tool comes with a tabbed layout. There are 3 tabs:

1. Search Tab : This tab enables the users to enter a search query in a query language of their choice and export the results in the form of an Excel spreadsheet.

2. Import Tab: The users can do bulk updates to the content by updating the spreadsheet downloaded in the previous tab and then uploading it.

3. Update Tab: This tab enables the users to update the content nodes corresponding to a query with actually downloading the content.

I have prepared a video recording showing the teaser of the functionality. Please have a look:

https://my.adobeconnect.com/p0bkrq5f5tbq/

If you have any query or suggestion then kindly comment here.

Replies

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,130 likes

Total Posts

6,156 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,130 likes

Total Posts

6,156 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

05-10-2017

Nice content shared with the community. Making this a featured thread for a week.

srinivasc11017710 ravi_kumar_thiruveedhula TribalLeo kostiantynk kdenolf gkn6 smileysk Few months back you had a question on the bulk editor, this is a good read that I would like to share with you.

~kautuk

Avatar

Avatar
Level 1
cqfan64079567
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
cqfan64079567
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
cqfan64079567
Level 1

05-10-2017

is it ootb in cq 6?

Avatar

Avatar
Validate 25
MVP
Ratna_Kumar
MVP

Likes

158 likes

Total Posts

755 posts

Correct Reply

134 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give Back 50
Give Back 5
View profile

Avatar
Validate 25
MVP
Ratna_Kumar
MVP

Likes

158 likes

Total Posts

755 posts

Correct Reply

134 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give Back 50
Give Back 5
View profile
Ratna_Kumar
MVP

05-10-2017

Thanks for sharing!!

Ratna.

Avatar

Avatar
Boost 5
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
namitg64472720
Employee

05-10-2017

No…it is a custom built feature.

Avatar

Avatar
Validate 1
Level 2
georgeb2620208
Level 2

Like

1 like

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 2
georgeb2620208
Level 2

Like

1 like

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
georgeb2620208
Level 2

05-10-2017

Thanks for posting this.  What property types can be bulk updated with this method?

In the old bulk editor, it was only string values that could be updated via a tsv import.

Avatar

Avatar
Boost 5
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile

Avatar
Boost 5
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
View profile
namitg64472720
Employee

06-10-2017

This one supports editing all types of properties.

Avatar

Avatar
Give Back
Level 1
basavaraj_c
Level 1

Likes

2 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Validate 1
Boost 1
View profile

Avatar
Give Back
Level 1
basavaraj_c
Level 1

Likes

2 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Validate 1
Boost 1
View profile
basavaraj_c
Level 1

04-01-2018

Thanks Namit for sharing this article. Even i'm facing problem in importing the content. Could you please share the flow and implementation for this?

Avatar

Avatar
Validate 25
Level 4
srinivas_chann1
Level 4

Likes

19 likes

Total Posts

222 posts

Correct Reply

6 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Ignite 5
Ignite 3
View profile

Avatar
Validate 25
Level 4
srinivas_chann1
Level 4

Likes

19 likes

Total Posts

222 posts

Correct Reply

6 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Ignite 5
Ignite 3
View profile
srinivas_chann1
Level 4

27-08-2019

Hi,

Can you provide code changes for it.That will be more helpfull??

Avatar

Avatar
Validate 1
Level 2
nitinjl
Level 2

Likes

6 likes

Total Posts

62 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Level 2
nitinjl
Level 2

Likes

6 likes

Total Posts

62 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile
nitinjl
Level 2

04-11-2019

Hey Namit, kautuksahni,

Is this custom implementation available for aem community members. We have a requirement to bulk move date type property from one place to other. And above suggested solutions seems perfect fit to our requirement.