Coral UI based Bulk Editor

Avatar

Avatar
Give Back
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct reply

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

Avatar
Give Back
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
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,200 likes

Total Posts

6,394 posts

Correct reply

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

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 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

159 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

159 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
Give Back
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct reply

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

Avatar
Give Back
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
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
Give Back
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct reply

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

Avatar
Give Back
Employee
namitg64472720
Employee

Likes

5 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
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

21 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

21 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.