JP2003256456A - Data input method and device, and program for inputting data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a method for efficiently inputting data to a database. <P>SOLUTION: A data input device includes an input part 2, a database recording part 4 for recording an order receiving database, a display part 3 for displaying an input screen having a plurality of input fields arranged in a designated order, a repeated input head item information recording part 5 for recording information for specifying the input field, and a data input processing part 6 for recording information for specifying a first input field, displaying a cursor in the input field specified according to the recorded information, displaying the data input by a user in the input field where the cursor is displayed, recording the information for specifying the input field selected by the user, moving the cursor to the next input field when the input field where the cursor is now displayed is not the last input field, and storing a data set displayed in a plurality of input fields when the input field where the cursor is now displayed is the last input field. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for inputting data into a database containing a plurality of items, and further includes a device using such a method and a plurality of items having a predetermined order. A program for entering data into a database.

[0002]

2. Description of the Related Art A conventional data input method for inputting data to a database will be described with reference to FIG. FIG. 6 is a diagram showing an example of a conventional data input screen for inputting order data to the order database. In the data input screen shown in FIG. 6, "order number", "order date", "order base CD (code)", "customer CD", "person in charge CD", "delivery destination CD", "delivery method""CD","ordercategory","sales type category", "shipment category", "book edge category", "sales record category", "shipment instruction category", "customer order number", "part number", " Item CD ",
"Standard", "Supplier CD", "Shipping Location CD", "Manufacturing Base CD", "Delivery Date", "Scheduled Shipping Date", "Quantity",
"Number of cases", "Order quantity", "Unit price unit", "Order price", "Tentative unit price category", "Order amount", "Complete delivery category",
The 1st to 34th input fields for sequentially inputting the "packaging form CD", the "stock allocation number", the "summary", and the "production instruction number" are displayed.

In the initial state, the cursor is displayed in the first input field for inputting the "order number", and the user (person in charge of ordering) looks at the order sheet and receives the "order number". Enter. Next, when the user presses the "Enter" key, the cursor is displayed in the second input field for inputting the "order date", and the user inputs the "order date" while looking at the order form. . Hereinafter, in the same manner, “order base CD” to “number of manufacturing instructions” are input to the third to 34th input fields. After that, when the user presses the "Enter" key, the data input in the first to 34th input fields is stored in the database. Then, the cursor is displayed in the first input field in preparation for the next data input.

In such a conventional data input method, there is no inconvenience when the "order number" to the "manufacturing instruction number" are all different for each order form. However, for example, a plurality of order details may be described in one order form received from one customer, and items of each order detail may be different. In this case, one order detail can be considered as one order data. Considering this, the "order number" to "customer order number" in the plurality of order data have the same value, and the "part number of the other party" to "the number of manufacturing instructions" have different values. However, even in such a case, in the conventional data input method, the “order number” to “number of manufacturing instructions” have to be input for all order forms, and the efficiency of data input work is extremely high. It was bad.

Similarly, there may be cases where one customer receives an order form in which a plurality of order details for the same item having different delivery dates are described. In this case, "order number"-"manufacturing base CD" in the data related to these order forms
Have the same value, and "delivery date" to "number of manufacturing instructions" have different values. Also in this case, in the conventional data input method, "order number" to "number of manufacturing instructions" have to be input for all order forms, and the efficiency of data input work is very poor.

[0006] As described above, in order to input data with some duplicated values, a plurality of programs having different user interfaces (for example, when a plurality of purchase orders for a plurality of items arrive from one customer). Program for multiple orders for the same item with different delivery dates
It has also been practiced that a user prepares a program or the like for the case where it arrives from one customer, and the user uses the program properly according to the contents of the order form. As described above, the use of a plurality of programs can improve the efficiency of data input work, but it requires man-hours and costs for developing a plurality of programs. Further, when the order forms with various contents arrive from various customers, the user has to switch the program according to the contents of these order forms.

[0007]

SUMMARY OF THE INVENTION In view of the above points, an object of the present invention is to provide a data input method capable of efficiently inputting data to a database. Further, the present invention is a data input device capable of efficiently inputting data to a database, and
The purpose is to provide a program for inputting data.

[0008]

In order to solve the above problems, a data input method according to the present invention is a method for repeatedly inputting a plurality of data sets into a database including a plurality of items. Step (a) of displaying a plurality of input fields arranged in a predetermined order for inputting a data set relating to the item, and recording information specifying the first input field of the plurality of input fields Step (b), and step (c) of displaying the cursor in the input field specified by the recorded information in the plurality of input fields, and inputting the data input by the user with the cursor being displayed. Step (d) of displaying in the field, and step (e) of recording the input information when the user inputs information specifying any of the plurality of input fields
Then, when the input field in which the cursor is currently displayed is not the last input field, the step (f) of moving the cursor to the next input field of the input field and the input field in which the cursor is currently displayed are If it is the last input field, the data set displayed in multiple input fields is stored in the database and specified by the recorded information in the multiple input fields to input the next data set. And (g) moving the cursor to the input field.

Further, the data input device according to the present invention is a device for repeatedly inputting a plurality of data sets into a database including a plurality of items. Input means for inputting data, display means for displaying an input screen, second recording means for recording information identifying one input field of the plurality of input fields, and data set for a plurality of items A plurality of input fields arranged in a predetermined order in order to input, and information for identifying the first input field of the plurality of input fields is recorded in the second recording means, The cursor is displayed in the input field specified by the information recorded in the recording means, the data input by the user from the input means is displayed in the input field in which the cursor is displayed, and the user makes a plurality of inputs. When the information for specifying any of the input fields is input, the input information is recorded in the second recording means, and when the input field where the cursor is currently displayed is not the last input field, the input field is input. And a control means for storing the data sets displayed in the plurality of input fields in the database when the input field in which the cursor is currently displayed is the last input field. .

Further, the program for inputting data according to the present invention is a program for repeatedly inputting a plurality of data sets to a database including a plurality of items, and inputs a data set relating to a plurality of items. In order to achieve this, a procedure (a) for displaying a plurality of input fields arranged in a predetermined order, a procedure (b) for recording information identifying the first input field of the plurality of input fields, and a plurality of (C) of displaying the cursor in the input field specified by the recorded information in the input field of (1) and displaying the data input by the user in the input field in which the cursor is displayed (d) When the user inputs information that specifies one of the plurality of input fields, the step (e) of recording the input information, and the input field in which the cursor is currently displayed is the last input field. If there is not, the procedure (f) of moving the cursor to the next input field of the relevant input field, and if the input field in which the cursor is currently displayed is the last input field, it is displayed in multiple input fields. The procedure (g) of storing the data set in the database and moving the cursor to the input field specified by the recorded information in the plurality of input fields in order to input the next data set. To run.

According to the present invention, it is possible to efficiently input data to the database.

[0012]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a diagram showing a data input device according to an embodiment of the present invention. As shown in FIG. 1, the data input device 1 includes an input unit 2, a display unit 3,
The database recording unit 4, the repeated input head item information recording unit 5, and the data input processing unit 6 are provided. Input section 2
Is a keyboard, mouse, etc. for the user to input data and the like. The display unit 3 displays C for displaying characters, images, etc.
RT, LCD, etc.

The database recording unit 4 records a database including a plurality of items having a predetermined order. In the present embodiment, the database recording unit 4 uses the “order number”, “order date”, “order base CD (code)”, “customer CD”, “person in charge CD”, “delivery destination CD”, “delivery CD”. Delivery method CD "," Order classification "," Sales form classification "," Shipping classification "," Book edge classification "," Sales recording classification "," Shipping instruction classification "," Customer order number "," Part number " , "Item CD",
"Standard", "Supplier CD", "Shipping Location CD", "Manufacturing Base CD", "Delivery Date", "Scheduled Shipping Date", "Quantity",
"Number of cases", "Order quantity", "Unit price unit", "Order price", "Tentative unit price category", "Order amount", "Complete delivery category",
It is assumed that an ordering database including 34 items of "packaging form CD", "number of stock allocations", "summary", and "number of manufacturing instructions" is recorded.

The repetitive input top item information recording unit 5 provides information for identifying the top item of the items for repeatedly inputting a value among a plurality of items contained in the order reception database recorded in the database recording unit 5. Record. The data input processing unit 6 causes the display unit 3 to display a plurality of input fields for inputting values of a plurality of items included in the database recorded in the database recording unit 5 in a predetermined order, and the user inputs The data including the value input to the unit 2 is stored in the database recorded in the database recording unit 5.

The database recording unit 4 and the repeated input head item information recording unit 5 shown in FIG. 1 are a hard disk, a flexible disk, an MO, an MT, and an RA.
M, CD-ROM, DVD-ROM, etc. are applicable. Further, the data input processing unit 6 can be composed of a CPU and software (program). This program is a hard disk, flexible disk, MO, M
It can be recorded on a recording medium such as T, RAM, CD-ROM, or DVD-ROM.

Next, the operation of the data input device according to this embodiment will be described with reference to FIGS. FIG. 2 is a flowchart showing a data input process of the data input device. Here, it is assumed that a plurality of order details are described in one order form received from one customer, and the items of each order detail are different, and the user (order person in charge etc.) The data shall be entered based on

First, the data input processing section 6 displays an initial screen on the display section 3 (step S11). FIG. 3 is a diagram showing an example of an initial screen displayed on the display unit 3. In the initial screen shown in FIG. 3, "Order number", "Order date", "Order base CD (code)", "Customer CD",
"Person in charge CD", "delivery destination CD", "delivery method CD",
"Order category", "Sales type category", "Shipping category", "Book edge category", "Sales record category", "Shipping instruction category", "Customer order number", "Partner part number", "Item CD","standard",
"Supplier CD", "Shipping place CD", "Manufacturing base C"
"D", "delivery date", "scheduled shipping date", "quantity", "number of cases", "order quantity", "unit price unit", "order unit price", "temporary unit price category", "order amount", " Full delivery category ”,“ Package C ”
First to thirty-fourth input fields for sequentially inputting "D", "number of stocks allocated", "summary", and "number of manufacturing instructions" are displayed together with item names.

Next, the data input processing unit 6 repeatedly records the information specifying the first item "order number" of the order database in the order input head item information recording unit 5 as an initial value (step S6). S12). Next, the data input processing unit 6 moves (displays) the cursor to the input field for inputting the first item to be repeatedly input (step S13). In the initial stage, the repeated input top item information recording unit 5 records the information for specifying the “order number”, and the data input processing unit 6 makes the first input for inputting the value of the “order number”. Display the cursor in the column.
At this time, as shown in FIG. 3, it is the item name of the first item to be repeatedly input, and the area around the character “Order number” displayed on the left side of the figure in the first input field is the background. It may be displayed in a color different from the color.

Next, the user inputs the value of the "order number" from the input section 2 based on the first order details (step S14). The data input processing unit 6 displays the input value in the first input field. The user presses the “Enter” key after finishing inputting the value.

Here, the user can change the head item to be repeatedly input by inputting information for specifying the head item to be repeatedly input. In the present embodiment, a plurality of order details are described in one order form received from one customer, and the items of each order detail are different. Therefore, the values of “item CD” to “number of production instructions” Is repeatedly input, the user inputs information specifying the "item CD" by clicking the item name of the "item CD" with the mouse. The data input processing unit 6 checks whether or not the information specifying the top item to be repeatedly input is input by the user, and if the information to specify the top item to be repeatedly input is input, the process is performed. S1
If not, the process proceeds to step S17 (step S15). It should be noted that the user only needs to input the information specifying the "item CD" only once, and from the second time onward, the input of the information specifying the first item to be repeatedly input can be skipped.

If it is determined in step S15 that the information specifying the first item to be repeatedly input is input,
The data input processing unit 6 repeats the information for identifying the head item to be repeatedly input by the repeated input head item information recording unit 5
To record (step S16). In the present embodiment, the data input processing unit 6 determines in step S16 that
Information for identifying the “item CD” input by the user is repeatedly recorded in the input head item information recording unit 5. Then, the data input processing unit 6 returns the process to step S14.

On the other hand, when it is determined in step S15 that the information for specifying the first item to be repeatedly input has not been input, the data input processing unit 6 instructs the end of data input (here, " It is checked whether or not the (F12) key is pressed. If the data input processing unit 6 determines that the "F12" key is not pressed, the data input processing unit 6 moves the process to step S18, and then "F12".
If it is determined that the key has been pressed, the process ends (step S17).

When it is determined in step S17 that the "F12" key has not been pressed, the data input processing unit 6
Check if the input field in which the cursor is currently displayed is the last input field. Then, the data input processing unit 6
If it is determined that the input field in which the cursor is currently displayed is not the last input field, the process proceeds to step S19,
If it is determined that the input field in which the cursor is currently displayed is the last input field, the process proceeds to step S20 (step S18). When it is determined in step S18 that the input field in which the cursor is currently displayed is not the last input field, the data input processing unit 6 moves the cursor to the input field of the next item (step S19). For example, when the input field in which the cursor is currently displayed is the first input field for inputting the value of “order number”, the data input processing unit 6 inputs the value of “order date”. Move the cursor to the second input field. Then, the data input processing unit 6 returns the process to step S14. By repeating steps S14 to S19 in this way,
Values from "order number" to "number of production instructions" can be entered.

On the other hand, when it is determined in step S18 that the input field in which the cursor is currently displayed is the last input field, the data input processing unit 6 is displayed in the first to 34th input fields. Data including 34 values is stored in the order receiving database recorded in the database recording unit 4 (step S20). As a result, data for one order detail can be stored in the order receipt database. After that, the data input processing unit 6 returns the process to step S13, but in step S13, the cursor is moved to the 16th input field for inputting the value of "item CD". At this time, as shown in FIG. 4, it is the item name of the first item to be repeatedly input, and the periphery of the characters of "item CD" displayed on the left side of the 16th input field is different from the background color. It may be displayed in color. Also, "Order number" ~
In the first to fifteenth input fields for inputting the value of the "part number of the other party", the value input last time is stored as it is.

As described above, according to the data input device according to the present embodiment, data is received based on one order form which is an order form received from one customer and in which a plurality of order details are described. When inputting, if you enter the value of "order number"-"part number" based on the first order details, the value of "order number"-"part number" for the second and subsequent order details Since it suffices to input the values of "item CD" to "number of manufacturing instructions" without inputting, it is possible to improve the work efficiency of data input to the order database.

In the present embodiment, the data is input based on one order form that is delivered from one customer and has a plurality of order details.
The values of "item CD" to "number of production instructions" are to be repeatedly input, but it is an order form received from one customer and a plurality of order details with different delivery dates for the same item are described. In the case of inputting data based on a general order sheet, the values of "delivery date" to "number of manufacturing instructions" are repeatedly input. In this case, in step S15, the user inputs information specifying the "delivery date", and the data input processing unit 6 repeatedly inputs the information specifying the "delivery date" input by the user in step S16. The information is recorded in the information recording unit 5. After that, the process returns to step S14, but in step S14, the cursor is moved to the 21st input field for inputting the value of "delivery date". In this case, as shown in FIG. 5, it is the item name of the first item to be repeatedly input, and the periphery of the character “delivery date” displayed in the upper part of the figure in the 21st input field is different from the background color. It may be displayed in color.

Further, the user may be able to press the data storage confirmation key (“F11” key in this embodiment) at any step other than step S20. In this case, the data input processing unit 6 uses the first to the 34th
Check whether or not values are entered in all of the input fields. Then, the data input processing unit 6 stores the data in the order entry database if the values are input in all the first to 34th input fields, and then returns the process to step S13. On the other hand, when the value is not input to any of the first to 34th input fields, the data input processing unit 6 displays a warning message on the display unit 3, and the input field where the value is not input is displayed. It is also possible to move the cursor.

[0028]

As described above, according to the present invention, the present invention can efficiently input data to the database.

[Brief description of drawings]

FIG. 1 is a diagram showing an outline of a data input device according to an embodiment of the present invention.

FIG. 2 is a flowchart showing a data input process of the data input device according to the embodiment of the present invention.

3 is a diagram showing an example of a data input screen displayed on a display unit 3 of FIG.

4 is a diagram showing an example of a data input screen displayed on the display unit 3 of FIG.

5 is a diagram showing an example of a data input screen displayed on the display unit 3 of FIG.

FIG. 6 is a diagram showing an example of a conventional data input screen.

[Explanation of symbols]

1 Data input device 2 Input section 3 Display 4 Database recording section 5 Repeated input top item information recording section 6 Data input processing section

Continued front page    (72) Inventor Motoyuki Suzuki             1-13-3 Higashisakura, Higashi-ku, Nagoya City Stock Association             Company Obic Nagoya Branch (72) Inventor Masanori Matsubara             1-13-3 Higashisakura, Higashi-ku, Nagoya City Stock Association             Company Obic Nagoya Branch F term (reference) 5B075 ND24                 5E501 AA01 AC23 BA05 CB02 CB09                       DA15 EB06 FA02 FA43

Claims (9)

[Claims] 1. A method for repeatedly inputting a plurality of data sets to a database including a plurality of items, wherein a plurality of data sets arranged in a predetermined order for inputting data sets relating to the plurality of items. A step (a) of displaying an input field, a step (b) of recording information for specifying a first input field of the plurality of input fields, and a step of recording information of the plurality of input fields. Step (c) of displaying the cursor in the input field specified by the information
And (d) displaying the data input by the user in the input field in which the cursor is displayed, and when the user inputs the information for specifying any one of the plurality of input fields The step (e) of recording the information, and the step (f) of moving the cursor to the next input field of the input field if the input field in which the cursor is currently displayed is not the last input field, When the input field in which the cursor is displayed is the last input field, the data sets displayed in the plurality of input fields are stored in the database, and the plurality of data sets are input to input the next data set. A step (g) of moving a cursor to an input field specified by the recorded information in the input field; 2. The data displayed from the first input field to the input field immediately preceding the input field specified by the recorded information is retained for input of the next data set. The data input method according to claim 1, wherein: 3. The plurality of input fields are displayed with their respective item names, and the item name associated with the input field specified by the recorded information in the plurality of input fields is different from other item names. The data input method according to claim 1 or 2, wherein the data is displayed with a brightness that can be identified. 4. An apparatus for repeatedly inputting a plurality of data sets to a database including a plurality of items, the first recording means recording the database, and an input means for a user to input data. A display means for displaying an input screen, a second recording means for recording information for identifying one of the plurality of input fields, and a data set for the plurality of items, Display multiple input fields arranged in a predetermined order,
Information for identifying the first input field of the plurality of input fields is recorded in the second recording device, and the cursor is moved to the input field specified by the information recorded in the second recording device. Display the data input by the user from the input means in the input field in which the cursor is displayed,
When the user inputs information that specifies any one of the plurality of input fields, the input information is recorded in the second recording unit, and the input field in which the cursor is currently displayed is the last input. If it is not a column, move the cursor to the next input column of the relevant input column, and if the input column where the cursor is currently displayed is the last input column, the data sets displayed in the plurality of input columns are A data input device comprising: control means for storing in a database. 5. An input field 1 specified from the first input field by the information recorded in the second recording means.
The data displayed up to the previous input field is retained for input of the next data set.
The data input device described. 6. An item associated with an input field specified by the information recorded in the second recording means, among the plurality of input fields being displayed with their respective item names. 6. The data input device according to claim 4, wherein the name is displayed with a brightness that can be distinguished from other item names. 7. A program for repeatedly inputting a plurality of data sets to a database including a plurality of items, wherein a plurality of data sets arranged in a predetermined order are used to input the data sets relating to the plurality of items. A step (a) of displaying an input field, a step (b) of recording information identifying the first input field of the plurality of input fields, and a step of recording information of the plurality of input fields. The step (c) of displaying the cursor in the input field specified by the information, the step (d) of displaying the data input by the user in the input field in which the cursor is displayed, and the step of the user If you enter information that specifies any of the above, the procedure (e) for recording the entered information and the entry field in which the cursor is currently displayed is not the last entry field Next input A step (f) of moving the cursor to a field, and storing the data sets displayed in the plurality of input fields in the database when the input field in which the cursor is currently displayed is the last input field, A program for causing the CPU to execute the step (g) of moving the cursor to the input field specified by the recorded information in the plurality of input fields to input the next data set. 8. The data displayed from the first input field to the input field immediately preceding the input field specified by the recorded information is retained for input of the next data set. The program according to claim 7, characterized in that: 9. The plurality of input fields are displayed with their respective item names, and the item name associated with the input field specified by the recorded information in the plurality of input fields is the other item name. 9. The program according to claim 7, wherein the program is displayed with a brightness that can be identified as.