Apparatus and method to automate data entry into an application program

• US 5,047,960 A
• Filed: 01/04/1989
• Issued: 09/10/1991
• Est. Priority Date: 01/04/1989
• Status: Expired due to Fees

• Current Assignee: Scott K. Sloan
• Original Assignee: Scott K. Sloan
• Inventors: Sloan, Scott K.
• Primary Examiner(s): Herndon, Heather R.
• Application Number:
  US07/293,311
• Time in Patent Office: 979 Days
• Field of Search: 364/518, 364/521, 364/200 MS File, 364/900 MS File, 364/523, 340/723, 340/724
• US Class Current: 715/202
• CPC Class Codes: G06F 3/023 Arrangements for converting discrete items of information into a coded form, e.g. arrangements for interpreting keyboard generated codes as alphanumeric codes, operand codes or instruction codes
• CPC Class Codes: G06F 3/033 Pointing devices displaced or positioned by the user , e.g. mice, trackballs, pens or joysticks; Accessories therefor digitisers characterised by the transducing means G06F3/041
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

An apparatus and method for transferring desired data from an existing data source in a computer system to an application program. The existing data source is first converted into visibly formatted data output which is at a location separate from the computer system. The desired data is then selected from the visible format. The desired data is able to be transferred into the application program merely in response to the selection from the visibly formatted data without using of a keyboard.

Claims

1. In a computer system, apparatus for automatically inputting desired data into an application program by extracting the desired data from a data source in the computer system and printing it out from the computer system in a visible format comprising:

means for storing said data source as an index list of predefined strings in a memory area of said computer system;

means for converting said data source into said visible format as a visible listing of items with each item in said listing of items corresponding to a predefined string in said index list wherein said visible listing of items is separate from said computer system;

means for selecting one of said items in said visible listing, and identifying a corresponding predefined string in said index list; and

means for inputting the corresponding string into a specified application program.

2. In a computer data processing system, an apparatus for automatically inputting desired data into an application program by extracting the desired data from a data source in the computer data processing system and printing it out from the computer data processing system in a visible format comprising:

means for storing said data source as an index list of predefined strings in a memory area internal of said data processing computer system;

means for converting said data source into said visible format as a printed list of items with each item in said printed list of items corresponding to a predefined string in said index list wherein said printed list of items is separate from computer data processing system;

means for selecting one of said items in said printed list; and

means for inputting a corresponding predefined string into a specified application program for data processing.

3. Apparatus as set forth in claim 2, wherein

said specified application program is an application program being capable of generating and/or operating a multiplicity of records, each said record having a multiplicity of distinct fields for storing related data;

said index list including a plurality of predefined multifield strings having data values for a plurality of fields; and

whereby a selection of an item in said printed list causes said apparatus to input data from said corresponding string into the application program for update.

4. Apparatus as set forth in claim 3, further including list extraction means for reading the data in said distinct fields of said multiplicity of records in the application program, said list extraction means producing a concordance representing distinct data values stored in at least one of said plurality of fields in said data base.

5. The apparatus as set forth in claim 4, wherein said strings in said index list include said concordance of data values.

6. The apparatus of claim 2, wherein said list of items comprise user friendly descriptive terms which characterize the data in said predefined strings in said index list.

7. The apparatus of claim 2, wherein said printed list comprises a formatted list of said items, each said item having a specified (p,r,c) coordinate, said selecting means is generally an (x,y) device for generating a signal for said apparatus to interpret said (p,r,c) coordinate of said selected item, and said imputing means including means for identifying the corresponding string in said index list based on said (p,r,c) coordinate and means for storing and transferring said corresponding string to the application program.

8. The apparatus of claim 7, wherein said printed list comprises a printed list of items on at least one piece of paper, said paper having at least one first reference information signifying a predetermined (x,y) coordinate on said paper, and a second reference information distinguishing each piece of said paper.

9. The apparatus of claim 8, wherein said (x,y) device is an electronic mouse adapted to be moved from said first reference point to the location of a selected item in said printed list, said mouse capable of generating an electronic signal signifying the x and y distance traveled from said first reference point to the selected item.

10. The apparatus of claim 7, wherein said (x,y) device comprises at least one tablet having a stylus, said data tablet adapted to generate an said (x,y) signal specifying the item selected by said stylus.

11. Apparatus as set forth in claim 2, wherein

said printed list of items include designations for keystrokes, application program macros, code numbers and text;

said predefined strings include a plurality of fields for storing data, which, when input to a specified application program, automatically input the keyboard commands to the computer system to automatically update said specified application program; and

said keystroke and application program macros can be selected in a location separate from the computer data processing system.

12. In a computer data processing system, a method for automatically imputing desired data into an application program by extracting the desired data from a data source in the computer data processing system and printing it out from the computer data processing system in a visible format, comprising the steps of:

storing said data source as an index list of predefined strings in a memory area internal said computer data processing system;

converting said data source into said visible format as a printed list of items with each item in said printed list of items corresponding to a predefined string in said index list wherein said printed list of items is separate from said computer data processing system;

selecting one of said items in said printed list, and identifying a corresponding string in said index list; and

inputting the corresponding string into a specified application program for data processing.

13. The method of claim 12, wherein said step of converting said data source into said visible format as a printed list of items further includes the step of:

providing the system with printout format parameters to identify locations of corresponding strings of said items printed on said printed list in said index list.

14. The method of claim 13, wherein said printout format parameters include the number of rows, the number of columns, the font size and the number of pages printed on the printed list.

15. The method of claim 12, wherein said predefined strings each contain at least one data field for storing the data to be transferred to the application program when said item corresponding to said data string is selected.

16. The method of claim 15, wherein said index list storing step further includes the step of:

providing the system with filed format parameters to control the access of said data field containing the data in a predefined string corresponding to a selected item for imputing to the application program.

17. In a computer system, an apparatus for automatically transferring desired data from a data source into an application program, the data source having been generated by an application program such as Dbase, Lotus or word processor in the computer system, said apparatus comprising:

means for converting said data source into visible formatted data at a location separate from said computer system, said visible formatted data having location parameters to identify locations of said visible formatted data;

means for selecting data from said visible formatted data at said location separate from said computer system; and

means for extracting said data in response to selections of said data selecting means.

19. The apparatus of claim 17, further comprising:

means for storing said data resource at a memory area internal of said computer system;

means for detecting said location parameters on said visible formatted data; and

means for identifying location relationship between each data item in said visible formatted data and a corresponding data item in said memory area.

20. The apparatus of claim 19, further comprising:

means for buffering said data item before said data item is transferred from said memory area into said application program.

21. The apparatus of claim 19, further comprising:

means for buffering said program macros after said program macros are selected by said program macros selecting means.

22. The apparatus of claim 19, wherein said means for detecting said location parameters including an electronic mouse and/or a stylus.

23. The apparatus of claim 22, wherein said means for detecting said location parameters including at least one tablet.

24. The apparatus of claim 19, wherein said visible formatted data are printed on a plurality of pieces of papers, said plurality of pieces of papers including position information to identify paper order and position of each data item on said plurality of pieces of paper.

25. The apparatus of claim 19, wherein each data item of said data source in said memory area associates with position information stored in said memory area.

26. The apparatus of claim 19, wherein each data item of said data source in said memory area associates with command information, which is stored in said memory area, to invoke subroutines when said data item is entered into said application in response to a selection of one of said program macros.

27. The apparatus of claim 26, wherein said command information is keystroke.

18. In a computer system, an apparatus for automatically transferring desired data from a data source into an application program, the data source having been generated by an application program such as Dbase, Lotus or work processor in the computer system, said apparatus comprising:

means for generating program macros at a location separate from said computer system, said program macros defining data processing operations of said application program;

means for selecting said program macros at said location separate from said computer system; and

means for activating said data processing operations of said application program in response to selections of said program macros selecting means.

28. The apparatus of claim 18, further comprising:

means for converting said data source into a visible formatted data at said location separate from said computer system, said visible formatted data having location parameters to identify locations of said visible formatted data;

means for selecting data from said visible formatted data at said location separate from said computer system; and

means for extracting said data in response to selections of said data selecting means and selections of said program macros selecting means.

29. The apparatus of claim 18, wherein said program macros keystrokes.

30. The apparatus of claim 18, wherein said program macros are designed as readable instruction.

31. In a computer system, a method for automatically transferring desired data from a data source into an application program, the data source have been generated by an application program such as Dbase, Lotus or word processor in the computer system, comprising:

converting said data source into a visible formatted data at a location separate from said computer system, said visible formatted data having location parameters to identify locations of said visible formatted data;

selecting data from said visible formatted data at said location separate from said computer system; and

extracting the selected data.

32. In a computer system, a method for automatically transferring desired data from a data source into an application program, the data source have been generated by an application program such as Dbase, Lotus or word processor in the computer system, said method comprising:

converting said data source into a visible formatted data at a location separate from said computer system, said visible formatted data having location parameters to identify locations of said visible formatted data;

generating program macros at said location separate from said computer system, said program macros defining data processing operations of said application program;

selecting data from said visible formatted data at said location separate from said computer system; and

selecting said program macros at said location separate from said computer system; and

activating said data processing operations of said application programs in response to the selected data and the selected program macros.

34. The method of claim 32 or 33, comprising the steps of:

storing said data source at a memory area internal of said computer system;

detecting said location parameters on said visible formatted data; and

identifying location relationship between each data item in said visible formatted data and a corresponding data item in said memory area internal of the computer system.

35. The method of claim 34, further comprising the step of:

buffering said data item before said data item is transferred from said memory area into said application program.

33. The method of claim 33, further comprising the step of:

buffering said program macros after said program macros are selected.