System and method for real-time validation of structured data files

• US 7,913,159 B2
• Filed: 03/28/2003
• Issued: 03/22/2011
• Est. Priority Date: 03/28/2003
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Narendran, Arungundram, Bath, Kamaljit S., Levenkov, Alexei, Shur, Andrey, Sikchi, Prakash, Larcheveque, Jean-Marie H., Selim, Nora S., Catorcini, Alessandro, Ardeleanu, Adriana
• Primary Examiner(s): Pitaro; Ryan F
• Application Number:
  US10/402,640
• Publication Number:
  US 20040189708A1
• Time in Patent Office: 2,916 Days
• Field of Search: 715/505, 715/507, 715224-226
• US Class Current: 715/224
• CPC Class Codes: G06F 21/566 Dynamic detection, i.e. detection performed at run-time, e.g. emulation, suspicious activities
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 40/221 Parsing markup language streams streaming G06F40/149
• CPC Class Codes: G06F 40/226 Validation

Abstract

A system and method validating entry of data into a structured data file in real-time is described. The system and method also described a real-time validation tool that enables a developer to create custom validation rules. These custom validation rules can include preset validation rules, which the real-time validation tool enables a developer to create in an easy-to-use way.

Claims

1. A method comprising:

receiving, at a computing device, first data entered into a first data-entry field mapped to a first node of a hierarchical data file written in XML, the first data intended for storage in the first node of the hierarchical data file; and

validating, locally on the computing device and using one or more validation rules based at least in part on a schema containing logic governing the hierarchical data file, wherein at least one validation rule is configured to be a script-based rule, the first data received in real time and prior to permitting entry of second data into a second data-entry field mapped to a second node of the hierarchical data file, the second data intended for storage in the second node of the hierarchical data file, the one or more validation rules governing a node group of the hierarchical data file of which the first node is a part of, and validating being based on third data stored in at least a third node of the node group, the third data having been entered into a third data-entry field mapped to at least the third node.

2. A method of claim 1, further comprising providing an alert if the first data received is not valid.

3. A method of claim 1, further comprising providing an alert if the first data received is not valid, wherein the alert includes information related to the invalid first data.

4. A method of claim 1, further comprising providing an alert if the first data received is not valid, wherein the alert marks the first data-entry field.

5. A method of claim 1, wherein the first data is received from a user entering the first data into an electronic form.

6. A method of claim 1, wherein the first data is received from a user entering the first data into the first data-entry field and further comprising alerting the user if the first data received is invalid.

7. A method of claim 1, wherein the first data is received from a user entering the first data into the first data-entry field and further comprising alerting the user with information related to the first data if the first data is invalid.

8. A method of claim 1, wherein the first data is received from a user entering the first data into the first data-entry field and further comprising alerting the user by marking the first data-entry field containing the first data if the first data is invalid.

9. A method of claim 1, wherein the first data is received from a user entering the first data into the first data-entry field and further comprising alerting the user by marking the first data-entry field containing the first data by outlining the first data-entry field with a red, dashed-lined box if the first data is invalid.

10. A method of claim 1, wherein the first data is received from a user entering the first data into the first data-entry field and further comprising alerting the user by marking the first data-entry field containing the first data with a solid red underline beneath the first data in the first data-entry field.

11. A method of claim 1, wherein the first data is received from a user entering the first data into an electronic form through the first data-entry field and further comprising preventing the user from editing the second data-entry field in the electronic form if the first data received is invalid.

12. A method of claim 1, wherein the first data is received from a user entering the first data into an electronic form through the first data-entry field and further comprising enabling the user to enter second data into the second data-entry field in the electronic form if the first data received is valid.

13. A method of claim 1, wherein the first data is received from a user entering the first data into an electronic form written in XHTML.

14. A method of claim 1, further comprising:

displaying an electronic form with the first data-entry field mapped to the first node; and

enabling a user to input the first data into the first data-entry field.

15. A computer-readable storage medium comprising computer-executable instructions that perform the method of claim 1 when executed by a computer.

16. A method comprising:

displaying with a computing device an electronic form with first and second data-entry fields associated with first and second nodes in a hierarchical data file written in XML;

enabling a user to input data into the first data-entry field through the computing device, the data being storable in the first node;

receiving data input into the first data-entry field;

validating the data, locally on the computing device, with a validation rule, in real time, and prior to enabling the user to input second data into the second data-entry field, to determine if the data is valid or invalid, wherein the validation rule is based on a part of a schema containing logic that governs the hierarchical data file, wherein the logic sets forth bounds of what data nodes the file can contain or the structure the nodes should have, and wherein the validation rule governs a node group of the hierarchical data file which includes the first node, and wherein validating is based on third data stored in a third node belonging to the node group, the third data having been entered into a third data-entry field mapped to the third node; and

enabling the user to input the second data into the second data-entry field if the data input into the first data-entry field is valid, the second data being storable in the second node, or alerting the user if the data input into the first data-entry field is invalid.

17. A method of claim 16, further comprising:

enabling the user to input the second data into the second data-entry field if the data is invalid.

18. A method of claim 16, wherein alerting the user includes marking the first data-entry field.

19. A method of claim 16, wherein alerting the user includes presenting a dialog box informing the user that the data input is invalid.

20. A method of claim 16, further comprising:

requiring the user to correct the data input into the first data-entry field if the data is invalid.

21. A method of claim 16, wherein the electronic form has a fourth data-entry field.

22. A method of claim 21, wherein alerting the user includes marking the first data-entry field and the fourth data-entry field.

23. A method of claim 16, wherein the validation rule is written in script.

24. A method of claim 16, wherein the validation rule written in a declarative syntax.

25. A computer-readable storage medium comprising computer-executable instructions that perform the method of claim 16 when executed by the computing device.

26. One or more computer-readable storage media comprising computer-executable instructions that are executable to implement a user interface, the user interface comprising:

an electronic form containing a first data-entry field mapped to a first node of a hierarchical data file and a second data-entry field mapped to a second node of the hierarchical data file;

an interface to enable a user to input first data into the first data-entry field and prohibit, in response to a real-time validation indicating that the first data is invalid, the user to input second data into the second data-entry field, wherein the real-time validation is performed in real-time locally on a computing device comprising one or more processors, and wherein the real-time validation is performed using one or more validation rules based at least in part on a schema containing logic governing the hierarchical data file, wherein the real-time validation is configured to perform validation based on script-based validation rules and wherein the real-time validation is performed based at least in part on third data having been entered into a third data-entry field mapped to at least a third node of the hierarchical data file, and wherein the first data is intended for storage in the first node; and

an alert area near the first data-entry field indicating that the data input is invalid based on the real-time validation indicating that the first data is invalid.

27. The one or more computer-readable storage media of claim 26, wherein the alert area includes graphics surrounding the first data-entry field.

28. The one or more computer-readable storage media of claim 26, wherein the alert area surrounds the first data-entry field and includes graphics containing a red, dashed-lined box.

29. The one or more computer-readable storage media of claim 26, wherein the alert area includes graphics highlighting the first data.

30. The one or more computer-readable storage media of claim 26, wherein the alert area surrounds the first data-entry field and includes the graphics containing a squiggly line beneath the invalid first data.

31. The one or more computer-readable storage media of claim 26, wherein the alert area includes text containing information about the invalid first data.

32. The one or more computer-readable storage media of claim 26, wherein the alert area includes text containing information about the first data-entry field.

33. The one or more computer-readable storage media of claim 26, wherein the alert area includes a pop-up window.

34. A system comprising:

a user-input device;

a computer having a display;

a user interface executable on the computer and configured to;

display in the display an electronic form containing a first data-entry field mapped to a first node of a hierarchical data file written in XML; and

receive first data input into the first data-entry field via the user input device; and

a real-time validation tool application executable on the computer and configured to;

validate without communicating with a remote computing device remote from the computer having the display, in real-time and prior to second data being input into a second data-entry field mapped to a second node of the hierarchical data file, the first data input into the data-entry field against one or more validation rules, wherein the one or more validation rules are based at least in part on a schema containing logic governing the hierarchical data file, wherein at least one validation rule is configured to be a script-based rule and wherein the one or more validation rules govern a node group of the hierarchical data file of which the first node is a part of, and wherein the real-time validation tool application is configured to validate the first data based at least in part on third data having been input into a third data-entry field mapped to a third node of the hierarchical data file; and

indicate whether the first data is valid or invalid to the user interface, wherein the user interface is further configured to;

prohibit the user from inputting the second data into the second data-entry field if the real-time validation tool indicates that the first data is invalid; and

enable the user to input the second data into the second data-entry field if the real-time validation tool indicates that the first data is valid.

35. An apparatus comprising:

means for displaying an electronic form with data-entry fields associated with nodes of a hierarchical data file written in XML;

means for enabling a user to input first data into a first data-entry field of the data-entry fields;

means for validating the first data with a validation rule, in real time and prior to enabling the user to input second data into a second data-entry field of the data-entry fields, to determine if the data is valid or invalid, wherein validating is performed locally on a computing device comprising one or more processors without communicating with a remote computing device, and wherein the validation rule is based on a part of a schema containing logic that governs the hierarchical data file, wherein the logic sets forth the bounds of what data nodes the file can contain or the structure the nodes should have, and governs a group of all or part of the nodes, and wherein one node of the group is associated with the first data-entry field and is intended to store the first data input into the first data-entry field, and wherein validating is based at least in part on third data having been input into a third data-entry field of the data-entry fields, wherein the third data-entry field is associated with another node of the group storing the third data; and

means for enabling the user to input the second data into the second data-entry field if the first data input into the first data-entry field is valid, or alerting the user if the first data input into the first data-entry field is invalid.