Browse Prior Art Database

Batch Editing Of Objects In A Grid Disclosure Number: IPCOM000241046D
Publication Date: 2015-Mar-23
Document File: 5 page(s) / 162K

Publishing Venue

The Prior Art Database


Disclosed is a method that enables users to simultaneously edit data values in multiple rows of a data grid.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 50% of the total text.

Page 01 of 5

Batch Editing Of Objects In A Grid

Generally, to edit multiple rows of data in a grid, users often need to do so one row at a time. A data grid may always be in edit mode, or it may initially be in read-only mode (e.g., to protect information from accidental changes that can have undesired business impact). As in the example depicted in Figure 1, to edit the values in the grid in read-only mode, the user selects the check box for each row needing edits and then clicks an Edit button. The grid becomes editable and contains only the selected subset of rows. The user can make changes to individual data cells in the grid, and then submit the changes, as in Figure 2.

Figure 1: Read-only grid - user selects rows to edit and clicks the Edit Attribute button

Figure 2: Editable grid containing the selected subset of rows; users can change the values of individual rows and submit the changes

The method disclosed herein enables users to quickly make a large number of updates for multiple items (rows) that need to have similar values for an attribute (that is, a


Page 02 of 5

column in the data grid). The user can make a single change in one or more columns to update multiple rows, instead of making the change to each row one at a time. In specific instances, the changes can be submitted and processed as a single batch command, which requires fewer resources (e.g., processing time) than does submitting several commands. Users still have the option to edit data in individual cells, per current processes.

The data grid may always be in edit mode, or it may initially be in read-only mode. If the data grid is always in edit mode, then the user selects the rows to be edited (e.g., via check boxes). If the data grid is initially in read-only mode, then the user selects the rows to be edited and switches to edit mode (e.g., by clicking an Edit button). In edit mode, the grid contains only the subset of rows that the user selected for editing.

Once in edit mode, the user can toggle between editing individual rows in the grid (e.g., via a Single Edit toggle button) and editing one or more columns or multiple rows at a time (e.g., via a Batch Edit toggle button). If the user toggles to Batch Edit mode, the following occur as illustrated in Figure 3:

A new editable row is added to the top of the grid. The row contains appropriate input controls (e.g., text boxes and drop-down list) that are initially blank (i.e. blank text boxes, and "Select" default in drop-downs).

The remaining data rows in the grid are displayed underneath the new editable row, but are not individually editable

Figure 3: Toggle to Batch Edit and new editable row appears at the top of the grid

To edit data in a text box:

1. The user clicks in a text box in the new editable row (e.g., the Region Class column)

2. The entire column is highlighted (e.g., different background color)

3. The user types in a value (e.g., 1)

4. The value in that column changes to the typed value for all the...