Mass Operations

Mass Operations

From LongJump Support Wiki

Mass Operations
Jump to: navigation, search

Mass Operations allow you to quickly edit, delete or change ownership of a series of records (defined by a View), in a "batch" or "bulk" process.

Contents

About Mass Operations

The Mass Update and Mass Ownership Change features act like a "search-and-replace" function to make it easier to change information within the database.

The Mass Delete function is useful to purge the database of unwanted content.

Offline Processing for Batches of 2500 Records or More

When a Mass Operation request is made that contains more than 2500 records, the operation will be handled offline, as system resources allow. This means that the request will be scheduled and added to a processing queue. When the request is complete, an email message will be sent to the requestor.

To follow the progress of the Mass Operation:

  1. Click Settings > Monitor > Mass Operations Status. This page is updated after processing every 100 records
    Statistics are displayed, indicating the number of records processed and any error messages (indicating records that could not be processed)
  2. Wait for notification by email that the Mass Operation is complete.


Working with Mass Operations

File:Lock-tiny.gif

Users that have the Access Mass Data Operations permission can manage Mass Operations 

Mass Update Data

Settings > Data Management > Mass Update Data

The Mass Update Data feature lets you quickly update field-specific information for multiple records.

Learn more: Mass Operations

Examples

  • Set the [Do Not Mass Email] field to 1 (True) for a group of contact records
  • Change the Due Date for a group of task records
  • Update a Department name for a group of account records
Considerations
  • In order to apply a mass update, first create a View that includes all the records to be updated
  • Because a Mass Update action overwrites field data, this action cannot be revoked
  • The Recycle Bin option is not available for Mass Update actions

To apply a Mass Update:

  1. Create a custom View that filters for the records you want
  2. Click Settings > Data Management > Mass Update Data
  3. Enter the following information:
    • Select an Object from the list
    • Select the View that contains the records you want to update
  4. Choose a Field and specify the new Value
  5. Optionally, click the [Preview Records] button to confirm that these are the records you want to affect.
  6. Click the [Execute] button to apply the update to all the records in the view.
    A confirmation dialog appears.
  7. Click the [OK] button to confirm the action.

See Mass Operation Status to monitor progress of the update.

See Offline Processing for Batches of 2500 Records or More for details on handling large batch operations.

Mass Ownership Change

Settings > Data Management > Mass Ownership Change

The Mass Ownership Change feature lets you quickly change the Ownership designated in multiple records. In order to apply a mass ownership change, you must first create a View that includes all the records that you want to change.

Learn more: Mass Operations

File:Lock-tiny.gif

To update Ownership information::

  1. Create a custom View that filters for the records you want
  2. Click Settings > Data Management > Mass Ownership Change
  3. In the Change Ownership page, enter your information in the required fields:
    • Select an Object from the list
    • Select a View that contains the records you want to reassign
    • Select the name of the new record owner
  4. Optionally, click the [Preview Records] button to confirm that these are the records you want to affect.
  5. Click the [Execute] button to apply the change to all the records in the view.
    A confirmation dialog appears.
  6. Click the [OK] button to confirm the action.
    When the Mass Operation completes, you see a success message with the number of records transferred.

To view the changes that have been made, click the object that you selected as the Resource and, if necessary, open one or more records.

See Offline Processing for Batches of 2500 Records or More for details on handling large batch operations.

Mass Delete Data

Settings > Data Management > Mass Delete Data

The Mass Delete Data feature provides the ability to quickly delete multiple records based on specific criteria, as defined in a View.

Learn more: Mass Operations

Perform a Mass Delete

To do a Mass Delete:

  1. Create a View that selects the desired records
  2. Click Settings > Data Management > Mass Delete Data.
  3. In the Mass Delete Data page, enter the following information in the required fields:
    • Select an Object from the list
    • Select the View that contains the records to delete
  4. Optionally, click the [Preview] button to view the list of records to be deleted.
  5. Click the [Execute] button to delete all the records in the selected view
    A confirmation dialog appears
  6. Click [OK] to confirm the action.

When the Mass Delete is complete, a success message is displayed, indicating the number of records deleted.

Undo a Mass Delete

To undo a Mass Delete, see Recycle Bin.

See Offline Processing for Batches of 2500 Records or More for details on handling large batch operations.

Delete an Audit Log

After a mass delete action is executed on Audit Log records, a single entry is recorded in the Audit Log, which includes these elements:

  • Filter criteria of the View used to select the records to delete; Contains these fields: Filter by Record Ownership, Date Filter, Column (Field) Filter and Subquery filter
  • Object Name
  • Number of records deleted
Personal tools