Batch Update of preside objects

Description

The existing data manager is fine for maintaining single rows of data, however we currently require functionality to be able to update multiple rows at a time.

Our exact requirement is:

We have a preside object e.g. farm and that has a many-to-many column to an object called animal. If we have a list of farms, it would be nice to be able to do a text search as per the existing data manager search, to select the ones you want to update, and then pick the field you want to set, ie, animal, and then chose the animals you want to apply to the farm. This would then append the selected animals to the farms selected.

@dom - as you mentioned the other day, maybe it would be good to set which fields can be bulk updated as an object property?

We do have a pretty urgent requirement for this, we can either build it ourselves or possibly sponsor the development, but it would be good to understand feasibility/timescales.

Activity

Show:
Steve Dowle
February 15, 2016, 11:29 AM

I've attached an example of how it could work.

In our particular case, we have imported a number of news, drugs, journals, guidelines and trial data which has traditionally been classified against a specialty, we have now introduced a set of diseases, and we need to go and reclassify 30k+ of items against diseases. We can identify using the data manager search most of the items e.g. all arthritis journals, but we then need to be able to select them all and set their disease to be arthritis. Some of these items may have more that one disease against them, so we would need this to append to their current value.

In our particular case the object has a many-to-many relationship with disease. If it has already been classified to that disease, then it should just ignore it.

It would be really useful to be able to see a log of changes made by the bulk updater, and ideally be able to export this information into excel () so that we can see what items still need classifying.

Dominic Watson
March 2, 2016, 4:40 PM

The latest version of this is in the release-10.5.0 branch. However, it looks like CommandBox have done something to break box install so waiting on some feedback and a fix from then before the build can run to make this downloadable as a zip file / through the update manager.

Sneak peaks:

Dominic Watson
March 2, 2016, 5:37 PM

Update: build has completed after working through CommandBox problems with Luis (to do with putting cloudflare in front of coldbox domain).

10.5.0.00748 is the latest build with this work included.

Dominic Watson
March 2, 2016, 6:58 PM

Current implementation is this for picking out which fields to make bulk editable:

  • NOT id,dateupdated,datemodified

  • NOT the label field

  • NOT any field with unique index

  • NOT any 'one-to-many' field (these are just helper fields - and not saved against the record)

  • NOT a field that has batcheditable=false attribute

So all object properties, other than ones above, will be batch editable by default.

Assignee

Manikandan M

Reporter

Steve Dowle

Labels

None

Accepted

Yes

Fix versions

Priority

Medium
Configure