Bulk Update
Bulk update enables you to make changes to multiple records simultaneously. When you update a field via bulk update by entering a value, changing a value or clearing the field, the change will apply to all the selected records. You can perform a bulk update on one or more records, and on one or more fields of those records.
Bulk update is accessed by clicking Assist > Bulk Update and is available on these dashboards:
- Asset entities
- Asset importances
- Asset type entities
- Asset type task resources
- Meters
- Monitoring point trigger expressions
- Regular asset components
- Regular asset task resources
- Regular asset task spares
- Regular asset tasks
- Regular asset type components
- Regular asset type conditions
- Regular asset type task spares
- Regular asset type tasks
- Resources
- Sites
- Site resources
- Stock items
- Supplier resources
- Trade financial rates
- Users
- User options
- Work order importances
- Work order task resource
- Work orders
- Work requests
Bulk update is also available on certain recursive dashboards. Please note, in a few cases you have to select the record in the grid in order for the Bulk Update option to display in the Assist panel in the sidebar.
To access a recursive dashboard, right-click the applicable node in the asset tree or asset type tree, click Browse, then select the entity to browse to.
The recursive dashboards that these apply to are as follows:
Asset type tree recursive dashboards
- Components (regular asset type components and placeholder asset type components)
- All tasks, including regular tasks
- Asset type task resources
- Task spares
Asset tree recursive dashboards
- Assets (regular assets, placeholder assets and in-place assets)
- Components (regular asset components and placeholder asset components)
- Work orders (selected asset and selected asset & children)
- All tasks
- Task conditions (regular asset type task conditions and regular asset task conditions)
- Task resources
- Task spares
Refer to Recursive Dashboard for more information.
Bulk update implementation
This functionality will adhere to the rules and validations for the entity and a bulk update will fail because of these rules. When attempting to update a field which is read-only when a work order is in a Closed base status, then the update will fail. Similarly, a required field cannot be cleared on a record using the bulk update functionality.
For user defined fields to be selectable when performing a bulk update, Enable Bulk Update needs to be set to true on the specific user defined field. Refer to the User Defined Fields Screen for more information.
When performing a bulk update, a notification message will display upon saving to indicate the number of successful updates and the number of failed updates.
Clicking More Info on the message will display additional notifications at the base of the dashboard, which when clicked, will select the applicable record on the grid. This enables the user to locate the exact record for which the update passed or failed, in cases where the update was applied to a batch of records.
Bulk update as background task
A bulk update can be performed as a background task. The progress of the background task can be monitored. Refer to Background Tasks for more information.
Permissions
The appropriate permissions are required per entity to perform a bulk update on an entity. Recursive dashboards use the same permissions that apply to the normal dashboards, special permissions may not be required to perform bulk updates on recursive dashboards.