Facilitating data manipulation in a browser-based user interface of an enterprise business application

• US 7,685,515 B2
• Filed: 09/18/2003
• Issued: 03/23/2010
• Est. Priority Date: 04/04/2003
• Status: Active Grant

• Current Assignee: NetSuite Inc. (Oracle Corporation)
• Original Assignee: NetSuite Inc. (Oracle Corporation)
• Inventors: Goldberg, Evan M., Goldwasser, Baruch, Braud, Luke A.
• Primary Examiner(s): RIES, LAURIE ANNE
• Application Number:
  US10/665,308
• Publication Number:
  US 20040199543A1
• Time in Patent Office: 2,378 Days
• Field of Search: 715/255, 715/234, 715/243, 715/240, 715/246, 715/788, 715/856, 705/1
• US Class Current: 715/255
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/00 Commerce

Abstract

Optimal presentation and editing of business data in a browser-based user interface of an integrated web-based business information system is described, including a browser at a user computer in dynamic communication with a web server allowing database editing and updating without browser page refreshes. For optimizing the data input/editing experience of the user, an array of features in various combinations is provided including: single-click instantiation of cell editing in a table displayed by the browser; single off-click or keyboard commits instantiating cell-wise data transfers; bulk editing allowing group modification of data elements across a plurality of adjacently-displayed or non-adjacently displayed records; client-side, location-based caching of old cell values allowing selective go-back for any edited or bulk-edited cell, in any order desired by the user, prior to a page-refreshing input event; and easy establishment/modification of sub-records associated with any of a displayed list of records using sub-record access icons, rollover menus, and auxiliary browser windows.

Claims

1. In an integrated business system having at least one Enterprise Resource Planning (ERP) database, at least one Customer Relationship Management (CRM) database, and a web server, a method for presenting and editing business data derived from said ERP and CRM databases, comprising:

at a user computer, receiving a web page from said web server and displaying a rendering thereof to a user in a browser window, said web page rendering comprising a plurality of simultaneously displayed portlet windows, each portlet window occupying a relatively small area within said browser window, said portlet windows being selected and arranged according to a user profile for that user, said plurality of portlets comprising;

a first portlet displaying a first list of records each comprising a plurality of data elements derived from said ERP module; and

a second portlet displaying a second list of records each comprising a plurality of data elements derived from said CRM module;

receiving a single-click from the user to establish a selection of a first one of said data elements from one of said first or second portlets;

responsive to said single-click and without requiring intervening user input, placing said first selected data element in an EDIT state and visually highlighting said first selected data element for editing;

receiving editing commands from the user modifying an initial value of said first selected data element, said editing commands ending with a first terminating input comprising one of (i) a first click-off comprising a click within said browser window outside said first selected data element, or (ii) a first keyboard data element commit command;

responsive to said first terminating input, displaying the modified value of said first selected data element and transferring said modified value to the web server, without requiring a page refresh of the browser, for association with said first selected data element in said ERP or CRM database;

wherein if said terminating input comprises said first click-off, and if said first click-off is at a display position corresponding to a second data element different than said first selected data element, performing the steps of;

responsive to said first click-off and without requiring intervening user input, selecting said second data element, placing said second selected data element in the EDIT state, and visually highlighting said second selected data element for editing;

receiving editing commands from the user modifying an initial value of said second selected data element, said editing commands ending with a second terminating input comprising one of (i) a second click-off comprising a click within said browser window and outside said second selected data element, and (ii) a second keyboard data element commit command; and

responsive to said second terminating input, displaying the modified value of said second selected data element and transferring said modified value to the web server, without requiring a pave refresh of the browser, for association with said second selected data element in said ERP or CRM database;

maintaining said initial value of said first selected data element in a memory of said user computer associated with said browser;

maintaining said initial value of said second selected data element in said memory;

receiving a subsequent user selection of one of said first or second selected data elements;

receiving a go-back command from the user; and

responsive to said go-back command, retrieving the initial value corresponding to said subsequently selected first or second data element from said memory, displaying said initial value, and transferring said initial value to the web server, without requiring a page refresh of the browser, for storage in association with said first or second selected data element.

2. The method of claim 1, further comprising, if said first or second terminating input comprises said first or second keyboard data element commit command, respectively, performing the steps of:

responsive to said first or second keyboard data element commit command, respectively, and without requiring any intervening user input;

selecting a third selected data element adjacent to said first or second selected data element, respectively, according to a predetermined inherent direction of said first or second keyboard data element commit command, respectively; and

placing said third selected data element in the EDIT state and visually highlighting said third selected data element for editing;

receiving editing commands from the user modifying a value of said third selected data element, said editing commands ending with a third terminating input comprising one of (i) a third click-off comprising a click within said browser window and outside said third selected data element, and (ii) a third keyboard data element commit command; and

responsive to said third terminating input, displaying the modified value of said third selected data element and transferring said modified value to the web server, without requiring a page refresh of the browser, for storage in association with said third selected data element.

3. The method of claim 2, wherein said first, second, and third keyboard data element commit commands are selected from the group consisting of:

a TAB command having a predetermined inherent direction of RIGHT;

a SHIFT-TAB command having a predetermined inherent direction of LEFT;

an UP ARROW command having a predetermined inherent direction of UP;

a DOWN ARROW command having a predetermined inherent direction of DOWN; and

an ENTER command having a predetermined direction of DOWN.

4. The method of claim 1, wherein said user computer comprises a mouse, and wherein said clicks are mouse clicks.

5. The method of claim 1, wherein said user computer comprises a touch-screen display, and wherein said clicks are touch-screen taps.

6. The method of claim 1, further comprising performing client-side validation of said modified value of said first selected data element prior to said transferring said modified value to the web server.

7. The method of claim 1, wherein said browser comprises Microsoft Internet Explorer Version 5.5 or later.

8. In an integrated business system having a web server and at least one database, a method for presenting and editing business data derived from the database, comprising:

at a user computer, receiving a web page from said web server and displaying a rendering thereof to a user in a browser window, said web page rendering including a listing of a plurality of records derived from the database, each record comprising a plurality of cells;

receiving a single-click from the user to establish a selection of a first cell in said listing;

responsive to said single-click and without requiring intervening user input, placing said first cell in an EDIT state and visually highlighting said first cell for editing;

receiving editing commands from the user modifying an initial value of said first cell, said editing commands ending with a first terminating input comprising one of (i) a first click-off comprising a click within said browser window outside said first cell, or (ii) a first cell-committing keyboard input;

responsive to said first terminating input, displaying the modified value of said first cell and transferring said modified value to the web server, without requiring a page refresh of the browser, for association with said first cell in the database;

wherein if said terminating input comprises said first click-off, and if said first click-off is at a display position corresponding to a second cell in said listing different than said first cell, performing the steps of;

responsive to said first click-off and without requiring intervening user input, selecting said second cell, placing said second cell in the EDIT state, and visually highlighting said second cell for editing;

receiving editing commands from the user modifying an initial value of said second cell, said editing commands ending with a second terminating input comprising one of (i) a second click-off comprising a click within said browser window and outside said second cell, and (ii) a second cell-committing keyboard input; and

responsive to said second terminating input, displaying the modified value of said second cell and transferring said modified value to the web server, without requiring a page refresh of the browser, for association with said second cell in said database;

maintaining said initial value of said first cell in a memory of said user computer associated with said browser;

maintaining said initial value of said second cell in said memory;

receiving a subsequent user selection of one of said first or second cells;

receiving a go-back command from the user; and

responsive to said go-back command, retrieving the initial value corresponding to said subsequently selected first or second cell from said memory, displaying said initial value, and transferring said initial value to the web server, without requiring a page refresh of the browser, for storage in association with said subsequently selected first or second cell.

9. The method of claim 8, further comprising, if said first or second terminating input comprises said first or second cell-committing keyboard input, respectively, performing the steps of:

responsive to said first or second cell-committing keyboard input, respectively, and without requiring any intervening user input;

selecting a third selected cell adjacent to said first or second cell, respectively, according to a predetermined inherent direction of said first or second cell-committing keyboard input, respectively; and

placing said third cell in the EDIT state and visually highlighting said third cell for editing;

receiving editing commands from the user modifying a value of said third cell, said editing commands ending with a third terminating input comprising one of (i) a third click-off comprising a click within said browser window and outside said third cell, and (ii) a third cell-committing keyboard input; and

responsive to said third terminating input, displaying the modified value of said third selected data element and transferring said modified value to the web server, without requiring a page refresh of the browser, for storage in association with said third cell.

10. The method of claim 9, wherein said first, second, and third cell-committing keyboard inputs are selected from the group consisting of:

a TAB command having a predetermined inherent direction of RIGHT;

a SHIFT-TAB command having a predetermined inherent direction of LEFT;

an UP ARROW command having a predetermined inherent direction of UP;

a DOWN ARROW command having a predetermined inherent direction of DOWN; and

an ENTER command having a predetermined direction of DOWN.

11. The method of claim 8, wherein said user computer comprises a mouse, and wherein said clicks are mouse clicks.

12. The method of claim 8, wherein said user computer comprises a touch-screen display, and wherein said clicks are touch-screen taps.

13. The method of claim 8, further comprising performing client-side validation of said modified value of said first cell prior to said transferring said modified value to the web server.

14. The method of claim 8, wherein said browser comprises Microsoft Internet Explorer Version 5.5 or later.

15. In an integrated business system having at least one Enterprise Resource Planning (ERP) database, at least one Customer Relationship Management (CRM) database, and a web server, a method for presenting and editing business data derived from said ERP and CRM databases, comprising:

at a user computer, receiving a web page from said web server and displaying a rendering thereof to a user in a browser window, said web page rendering comprising a plurality of simultaneously displayed portlet windows, each portlet window occupying a relatively small area within said browser window, said portlet windows being selected and arranged according to a user profile for that user, said plurality of portlets comprising;

a first portlet displaying a first list of records each comprising a plurality of data elements derived from said ERP module; and

a second portlet displaying a second list of records each comprising a plurality of data elements derived from said CRM module;

receiving a single-click from the user to establish a selection of a first one of said data elements from one of said first or second portlets;

responsive to said single-click and without requiring intervening user input, placing said first selected data element in an EDIT state and visually highlighting said first selected data element for editing;

receiving editing commands from the user modifying an initial value of said first selected data element, said editing commands ending with a first terminating input comprising one of (i) a first click-off comprising a click within said browser window outside said first selected data element, or (ii) a first keyboard data element commit command;

responsive to said first terminating input, displaying the modified value of said first selected data element and transferring said modified value to the web server, without requiring a page refresh of the browser, for association with said first selected data element in said ERP or CRM database;

wherein if said terminating input comprises said first click-off, and if said first click-off is at a display position corresponding to a second data element different than said first selected data element, performing the steps of;

responsive to said first click-off and without requiring intervening user input, selecting said second data element, placing said second selected data element in the EDIT state, and visually highlighting said second selected data element for editing;

receiving editing commands from the user modifying an initial value of said second selected data element, said editing commands ending with a second terminating input comprising one of (i) a second click-off comprising a click within said browser window and outside said second selected data element, and (ii) a second keyboard data element commit command; and

responsive to said second terminating input, displaying the modified value of said second selected data element and transferring said modified value to the web server, without requiring a page refresh of the browser, for association with said second selected data element in said ERP or CRM database;

maintaining said initial value of said first selected data element in a memory of said user computer associated with said browser;

maintaining said initial value of said second selected data element in said memory;

subsequent to said second terminating input, receiving a plurality of user inputs in said browser unrelated to said first or second selected data elements;

receiving a subsequent user selection of one of said first or second selected data elements;

receiving a go-back command from the user;

if said plurality of unrelated user inputs resulted in a page refresh prior to said go-back command, keeping said subsequently selected first or second data element at its modified value; and

if said plurality of unrelated user inputs did not result in a page refresh prior to said go-back command, retrieving said initial value of said subsequently selected first or second data element from said memory, displaying said initial value, and transferring said initial value to the web server, without requiring a page refresh of the browser, for storage in association with said first or second selected data element.

16. The method of claim 15, further comprising, if said first or second terminating input comprises said first or second keyboard data element commit command, respectively, performing the steps of:

responsive to said first or second keyboard data element commit command, respectively, and without requiring any intervening user input;

selecting a third selected data element adjacent to said first or second selected data element, respectively, according to a predetermined inherent direction of said first or second keyboard data element commit command, respectively; and

placing said third selected data element in the EDIT state and visually highlighting said third selected data element for editing;

receiving editing commands from the user modifying a value of said third selected data element, said editing commands ending with a third terminating input comprising one of (i) a third click-off comprising a click within said browser window and outside said third selected data element, and (ii) a third keyboard data element commit command; and

responsive to said third terminating input, displaying the modified value of said third selected data element and transferring said modified value to the web server, without requiring a page refresh of the browser, for storage in association with said third selected data element.

17. The method of claim 16, wherein said first, second, and third keyboard data element commit commands are selected from the group consisting of:

a TAB command having a predetermined inherent direction of RIGHT;

a SHIFT-TAB command having a predetermined inherent direction of LEFT;

an UP ARROW command having a predetermined inherent direction of UP;

a DOWN ARROW command having a predetermined inherent direction of DOWN; and

an ENTER command having a predetermined direction of DOWN.

18. The method of claim 15, wherein said user computer comprises a mouse, and wherein said clicks are mouse clicks.

19. The method of claim 15, wherein said user computer comprises a touch-screen display, and wherein said clicks are touch-screen taps.

20. The method of claim 15, further comprising performing client-side validation of said modified value of said first selected data element prior to said transferring said modified value to the web server.

21. The method of claim 15, wherein said browser comprises Microsoft Internet Explorer Version 5.5 or later.

22. In an integrated business system having a web server and at least one database, a method for presenting and editing business data derived from the database, comprising:

at a user computer, receiving a web page from said web server and displaying a rendering thereof to a user in a browser window, said web page rendering including a listing of a plurality of records derived from the database, each record comprising a plurality of cells;

receiving a single-click from the user to establish a selection of a first cell in said listing;

responsive to said single-click and without requiring intervening user input, placing said first cell in an EDIT state and visually highlighting said first cell for editing;

receiving editing commands from the user modifying an initial value of said first cell, said editing commands ending with a first terminating input comprising one of (i) a first click-off comprising a click within said browser window outside said first cell, or (ii) a first cell-committing keyboard input;

responsive to said first terminating input, displaying the modified value of said first cell and transferring said modified value to the web server, without requiring a page refresh of the browser, for association with said first cell in the database;

wherein if said terminating input comprises said first click-off, and if said first click-off is at a display position corresponding to a second cell in said listing different than said first cell, performing the steps of;

responsive to said first click-off and without requiring intervening user input, selecting said second cell, placing said second cell in the EDIT state, and visually highlighting said second cell for editing;

receiving editing commands from the user modifying an initial value of said second cell, said editing commands ending with a second terminating input comprising one of (i) a second click-off comprising a click within said browser window and outside said second cell, and (ii) a second cell-committing keyboard input; and

responsive to said second terminating input, displaying the modified value of said second cell and transferring said modified value to the web server, without requiring a page refresh of the browser, for association with said second cell in said database;

maintaining said initial value of said first cell in a memory of said user computer associated with said browser;

maintaining said initial value of said second cell in said memory;

subsequent to said second terminating input, receiving a plurality of user inputs in said browser unrelated to said first or second selected cells;

receiving a subsequent user selection of one of said first or second cells;

receiving a go-back command from the user;

if said plurality of unrelated user inputs resulted in a page refresh prior to said go-back command, keeping said subsequently selected first or second cell at its modified value; and

if said plurality of unrelated user inputs did not result in a page refresh prior to said go-back command, retrieving said initial value of said subsequently selected first or second cell from said memory, displaying said initial value, and transferring said initial value to the web server, without requiring a page refresh of the browser, for storage in association with said subsequently selected first or second cell.

23. The method of claim 22, further comprising, if said first or second terminating input comprises said first or second cell-committing keyboard input, respectively, performing the steps of:

responsive to said first or second cell-committing keyboard input, respectively, and without requiring any intervening user input;

selecting a third selected cell adjacent to said first or second cell, respectively, according to a predetermined inherent direction of said first or second cell-committing keyboard input, respectively; and

placing said third cell in the EDIT state and visually highlighting said third cell for editing;

receiving editing commands from the user modifying a value of said third cell, said editing commands ending with a third terminating input comprising one of (i) a third click-off comprising a click within said browser window and outside said third cell, and (ii) a third cell-committing keyboard input; and

responsive to said third terminating input, displaying the modified value of said third selected data element and transferring said modified value to the web server, without requiring a page refresh of the browser, for storage in association with said third cell.

24. The method of claim 23, wherein said first, second, and third cell-committing keyboard inputs are selected from the group consisting of:

a TAB command having a predetermined inherent direction of RIGHT;

a SHIFT-TAB command having a predetermined inherent direction of LEFT;

an UP ARROW command having a predetermined inherent direction of UP;

a DOWN ARROW command having a predetermined inherent direction of DOWN; and

an ENTER command having a predetermined direction of DOWN.

25. The method of claim 22, wherein said user computer comprises a mouse, and wherein said clicks are mouse clicks.

26. The method of claim 22, wherein said user computer comprises a touch-screen display, and wherein said clicks are touch-screen taps.

27. The method of claim 22, further comprising performing client-side validation of said modified value of said first cell prior to said transferring said modified value to the web server.

28. The method of claim 22, wherein said browser comprises Microsoft Internet Explorer Version 5.5 or later.