Method and apparatus for validating data entered by a user

• US 5,710,901 A
• Filed: 12/29/1995
• Issued: 01/20/1998
• Est. Priority Date: 12/29/1995
• Status: Expired due to Term

• Current Assignee: CSG Systems Incorporated (CSG Systems International Incorporated)
• Original Assignee: TCI Summitrak Of Texas, Inc.
• Inventors: Mattie, Llad, Stodghill, Scott A.
• Primary Examiner(s): Bayerl, Raymond J.
• Assistant Examiner(s): KATBAB, ABDOLLAH
• Application Number:
  US08/581,778
• Time in Patent Office: 753 Days
• Field of Search: 395/339, 395/185.1, 395/183.22, 395/326-358, 395/939, 395/764, 395/185.01, 371/48
• US Class Current: 715/710
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity

Abstract

A method and apparatus for validating data entered into a data processing system. A plurality of windows is provided, each including at least one widget area into which data is entered by the user. A "doda object" is associated with each widget and contains keys identifying where the data is to be stored in a database, as well as member functions which operate to format the entered data for storage and format information retrieved from the database for display in the widget. During the validation procedure, all of the data associated with each of the widgets in a window are first examined for errors in conjunction with its associated doda object. In addition, a second validation step is performed in which the data associated with certain widgets are compared to those of other widgets in the window, in accordance with an algorithm selected by the user, to detect the presence of errors resulting from data entered inconsistently between widgets. If any errors are detected, an error message is displayed within a validation window. The widget in which the error was detected may then be selected by the user by double-clicking on the error message.

Claims

1. A system for storing and retrieving information to and from a database, comprising:

keyboard means for entering data into the system;

display means, for visually displaying alphanumeric and graphic symbols representing requests for data and the data entered into the system, said display means comprising

at least one window disposed within the display means,

a validation window associated with each window and capable of being displayed on said display means within said window, and

at least one widget disposed within each of said windows, wherein all data entered into the system via said keyboard means is associated with at least one widget;

means for detecting an error condition relating to the data associated with each of said widgets within a window;

means responsive to said means for detecting an error condition for creating an error message string for display in the validation window associated with the window in which said error condition was detected, said means also creating pointer data identifying the widget in which the error condition was detected.

2. A system for storing and retrieving information to and from a database according to claim 1, further comprising re-entry means responsive to said means for creating an error message, said re-entry means re-displaying the widget identified by the pointer data associated with the error message string so as to enable re-entry of the data associated with that widget.

3. A data processing system having the capability of validating data entered into the system, comprising:

display means, comprising

at least one window displaying a plurality of requests for information, and

at least one widget within each window associated with at least one of said displayed requests for information;

means for entering data into the system such that the entered data is associated with at least one of said widgets;

a doda object associated with each of said widgets, the doda object including member functions adapted to ascertain whether data entered in association with the widget is correctly formatted;

means for detecting an error condition in the data objects associated with each of said widgets, based upon the doda object associated with that widget;

means responsive to the detection of an error condition for displaying an error message on a portion of said display means and for pointing to the location of the error condition.

4. A data processing system having the capability of validating data entered into the system according to claim 3, further comprising re-entry means responsive to said means for displaying an error message, said re-entry means re-displaying the location of the error condition so as to enable re-entry of data.

5. A method of validating information entered into a data processing system having visual display means, comprising the steps of:

creating at least one window area on said visual display means;

displaying a plurality of requests for information in said window area;

displaying a plurality of widgets in said window area, each widget associated with at least one of said requests for information;

associating data entered in response to said requests for information with at least one of said widgets;

creating at least one doda object associated with each of said widgets, said doda object including member functions adapted to ascertain whether data associated with the widget is properly formatted;

for each widget, detecting, with the assistance of the doda object for that widget, the presence or absence of an error condition in the data associated with that widget, and in response to the detection of an error condition, creating an error message string and a pointer identifying the widget associated with the data object in which the error condition was detected;

displaying for selection by a system operator, all error message strings on a portion of said window area;

in response to the selection by a system operator of one of the displayed error message strings, re-displaying the widget identified by the pointer associated with the selected error message string so as to enable re-entry of the data associated with that widget.

6. A method of validating information entered into a data processing system having visual display means, comprising the steps of:

creating at least one window area on said visual display means;

displaying a plurality of requests for information in said window area;

displaying a plurality of widgets in said window area, each widget associated with at least one of said requests for information;

as data is entered into the system, associating the entered data with at least one of the widgets;

creating at least one doda object associated with each of said widgets, said doda object including member functions adapted to ascertain whether entered data associated with the widget is properly formatted;

for each widget, detecting, with the assistance of the doda object for that widget, the presence or absence of an error condition within the data associated with that widget by comparing said data with a stored database of available valid data, and in response to the detection of an error condition, creating an error message string and a pointer identifying the widget associated with the data in which the error condition was detected;

for each widget, detecting, with the assistance of the doda object for that widget, the presence or absence of an error condition within the data associated with that widget by comparing said data with the data associated with other widgets in said window area, and in response to the detection of an error condition, creating an error message string and a pointer identifying the widget associated with the data in which the error condition was detected;

displaying for selection by a system operator, all error message strings on a portion of said window area;

in response to the selection by a system operator of one of the displayed error message strings, re-displaying the widget identified by the pointer associated with the selected error message string so as to enable re-entry of the data associated with that widget.