JP2963954B2 - Data collection device - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a data collection device, and more particularly to a data collection device suitable for application to a data collection system using a handy terminal (portable computer terminal).

[Prior art] In recent years, computerization of factories and offices has been rapidly progressing, so that various types of data collection systems corresponding to each business have been developed, so that even if abbreviated as FA, OA, they can communicate with each other. ing.

[Problems to be solved by the invention]

By the way, for example, in a data collection system using a handy terminal for collecting data of factory process management, the program has conventionally been incorporated in a handy terminal developed separately for each process. For this reason, for example, since the handy terminal in which the program for the process A is installed fails, it is difficult to use the handy terminal in which the program for the process B is installed as a substitute. In some cases, it is necessary to ask the appropriate software engineer to reassemble the entire program, and the arrangement of the program is rather complicated.

[Means for solving the problem]

Therefore, according to the present invention, a table creating means for determining conditions at the time of data collection as a table is arranged in the host computer (parent computer), and input conditions corresponding to the work category selected by the user are read from the table. The above object is achieved by arranging data collection means for performing data collection in accordance with the conditions in the handy terminal.

[Action]

In this way, the data collection means can simply incorporate the table for the process to be substituted or the newly set table into the handy terminal to be used in the substitute or the handy terminal to be used in the new process, and Alternatively, data of a new process can be collected.

〔Example〕

Hereinafter, the present invention will be described in detail based on illustrated embodiments. In FIG. 2, reference numeral 1 denotes a handy terminal, and 2 denotes a central processing unit for executing the processing described below in accordance with programs stored in a read only memory 4 and a random access memory 5. In the following description and drawings, the central processing unit is abbreviated as "CPU", the read only memory is abbreviated as "ROM", and the random access memory is abbreviated as "RAM". In the following description, when an abbreviation is given in parentheses after the name, that abbreviation will be used thereafter.

Reference numeral 7 denotes a liquid crystal display (LCD) for displaying data supplied from the CPU 2. Reference numeral 8 denotes a transparent touch panel, which is arranged on the LCD. 10 is an input / output port (I / O)
With keyboard (KB) 11, barcode reader 13 and others
Connect to CPU2. Reference numeral 14 denotes a barcode book, which contains various barcodes (not shown) used for data input.

21 is a host computer (parent computer), 22 is its central processing unit (CPU), and read-only memory (ROM) 23
And a program stored in a random access memory (RAM) 25 to execute processing described later.

26 is a flexible disk drive (FDD) for reading and writing a flexible disk (not shown). 28
Denotes a cathode ray tube display (CRT), which displays data supplied from the CPU 22. A printing device (PRT) 29 prints out data supplied from the CPU 22. 31 is the keyboard (KB)
Is provided for data input. 32 is an input / output port (I / O)
Then, the PRT 29 and the KB 31 are connected to the CPU 22.

41 is a RAM card which has a built-in random access memory chip backed up by a lithium battery or the like. The
The RAM card 41 can be bonded to the host computer 21 or the handy terminal 1, and data is read and written by the CPU 2 or the CPU 22.

FIGS. 3 to 5 show examples of tables. In this embodiment, a table is created for each department. FIG. 3 shows a table for collecting data in the outsourcing management department, FIG. 4 shows an assembly department, and FIG. 5 shows a table for collecting data in the shipping department.

In each of these tables, each condition at the time of data collection is determined for each work unit in the department. For example, in the case of the subcontract management department shown in FIG. 3, the conditions for ordering work to the subcontractor, order record in the acceptance inspection work for the product delivered from the subcontractor, and data collection work such as the inspection result record are respectively defined. ing.

In this embodiment, for each data collection operation in each of these operations, the presence or absence of exception processing, the total number of items to be input, the number of data digits for each item, the content of exception processing, and the name of the item are determined. These conditions can be called up by work codes 0011, 0012,... Attached to the data collection work. The significance of these conditions will be clarified in a description of an operation example described later.

FIG. 6 shows a layout of a transaction file formed in the RAM 5 for storing data collected by the handy terminal 1 according to these conditions. This transaction file is also formed for each department in accordance with the tables shown in FIG. 3 to FIG.
It is common that the work code is written in the first 4 bytes of the record 128 bytes, and the data of each item collected in the fifth byte and thereafter is stored.

Thus, an operation example of this embodiment will be described. First, the table creation operation shown in FIG. 1 is performed. Here, it is assumed that the host computer 21 has already been started and is in a state of waiting for a task selection (step S1) (hereinafter abbreviated as "S1"; the same applies to step S2 and thereafter). In this state, the operator selects the "table creation program" (S2). In response, the host computer 21 sets the "table creation program"
Is started (S3). According to the guidance displayed on the CRT 28, for example, each condition of the table shown in FIG. 3 is input (S4). CP
U22 creates a table shown in FIG. 3 and the like according to the input data (S5). Next, the CPU 22 stores the created table in R
Download to AM card 41 (S6). And step
Return to S1 (S7).

The operations of steps S1 to S7 are carried out for each table in addition to those shown in FIGS. The RAM card 41 whose table has been downloaded in these operations is mounted on the handy terminal 1 of each section (S8).

Next, a management file for uploading data collected by the handy terminal 1 of each section is formed in the host computer 21. The layout of this file is arbitrarily determined according to the type of business and business to which the present invention is applied (not shown). Here, in order to collectively grasp the movement of the product flowing in each section, the data collection items of each section as shown in FIGS. 3 to 5 are aggregated to be the data items of the management file.

This operation is performed according to the procedure shown in FIG. First, it is assumed that the host computer 21 is initially in a "waiting for job selection" state as in the operation of FIG. 1 (S21). The operator selects "File creation program" from the displayed menu.
Is selected (S22). As a result, the CPU 22 activates the “file creation program” (S23).

Therefore, the data collection items aggregated as described above are input (S24). Other items necessary for management may be added to these items. Then, the CPU 22 creates a management file based on these input items (S25). Next, key items are input (S26). The key item determines which record of the management file stores the collected data. For example, if the first item instruction number in FIG. 3 is used as a key item, the instruction number of record number n in the management file is “1153”.
23451 ", and when the instruction number in the record 1 of the collected data matches this, the data of each item in the record 1 is transferred to each item of the record n in the management file.

When the key item input (S26) is completed, the CPU 22 creates a key item file based on the input data (S27). For key items, necessary data is input (S28). The CPU 22 writes this in the corresponding item of the management file (S29). For example, if the instruction number is set as a key item as described above, the instruction number of each job set at that time (flowing to the process), for example, “115323451” or the like is input as key item data. And when this process is done
The CPU 22 returns to the task selection waiting (S30).

The details of the data collection work will be described with reference to FIGS. It is assumed that the same application program, that is, a program for performing data collection with reference to the tables shown in FIGS. 3 to 5, has been downloaded to the handy terminal 1 of each section. It is assumed that it has been activated and is in the state of “waiting for business selection” (S41), and the screen is displayed as in D31.

In this state, "1, data input" is selected (S42, D
2). As a result, the CPU 2 of the handy terminal 1 displays a message "What is the work name?" On the screen to allow the operator to input what the work name is, and waits for the input of the work code (D2, S43). The indications of "canceled" and "return to previous screen" displayed at the bottom of the screen D2 are for correcting erroneous input or returning the CPU 2 to the state one step before. If they come into contact, the CPU 2 executes the processing.
(The same applies to the following screens.) In response to the message "What is the work name?", The operator selects the bar code (work code) of the corresponding work name from the bar code book 14 and displays it in the bar code. Scanning is performed by the code reader 13 (S44). The CPU 2 loads the data of the table corresponding to the work code from the RAM card 41 into the RAM 5. Then, first, the presence or absence of exception processing is checked. For example, if “acceptance inspection (work code 0012)” is selected here, the CPU 2 sets the exception code presence / absence item of this work code 0012 to “1 = Yes”
Is displayed, the message "Work name acceptance inspection" and "What is the quantity?" Are displayed on the LCD 7 (D3, D45).

There are various types of exception handling. In this embodiment, “repeated” and “keyboard input only” are the exception processing.
"Repeatable" means that the same number of data is generated by one input operation when receiving and inspecting the same unit or multiple circuit boards. It is necessary to handle the same unit individually for process management. Is used when there is, and “K” is added to the content of the exception of the item. “Keyboard input only” means that barcode input is not accepted, and “N” is used as a symbol. At this time, the CPU 2 temporarily stores the input quantity in the buffer.

Next, the CPU 2 refers to the first item of the table, and displays a message such as “work name order record”, “item number of one digit 9”, and “instruction number?” On the LCD 7 (D4, S45). When a quantity is input, the quantity is also displayed. Then, the operator uses the barcode book 14 and the barcode reader 13 to input a corresponding instruction number (S46). The CPU 2 compares the number of digits of the input data with the number of digits indicated in the table, and if there is an error, sounds a buzzer and prompts for re-input.

If it is correct, this is displayed on the LCD 7 and the number of the item order is incremented, and the message "What is the subcontractor code?" Is issued with reference to the next item in the table, here, item 2 (D5).

The CPU 2 repeats this process until the number of items shown in the table is reached (S45, S46, D4, D5). In the case of the order record, "total number of items = 2", and the data input for this operation is completed only with the "instruction number" and the "outsourcing party code".

After completing the entry of the number of items specified in the table, CPU2
Displays the last input data and issues a message "What is the correction?" To confirm whether the input data has been corrected (D6). If correction is necessary, touch the fingertip to "Yes". In this case, the CPU 2 displays a necessary message such as “What is the item name to be corrected?” On the LCD 7 and performs a correction process (not shown).

If the fingertip touches "No correction" (S48), CPU2
Writes the data of one record stored in the buffer into the transaction file in the RAM 5 (S49). The record number 0 in FIG. 6 indicates the contents of the transaction file for the above example, the first four digits are “work code”, the next nine digits are “instruction number”, and the next five digits are “subcontractor code”. is there.
After that, carriage return (CR) and line feed (LF) codes indicating the end of data are added.

Then, if you want to input the data of the acceptance inspection work, enter the corresponding barcode in the barcode book 14 into the barcode reader 13
Scan with. The CPU 2 is in a state of waiting for the next barcode input in step S50, and this barcode input is performed in step S44.
, And proceeds to the data input process of step S45 and subsequent steps.

In the table of the acceptance inspection, as described above, "existence of presence / absence of processing = 1 (available)" is set, and K is added to the exception content of the tenth item. In this case, at the time of data input (S45, S46) according to the tenth item, the CPU 2 creates a record of the number corresponding to the tenth item with a serial number based on the input data. Records 1 to 5 in FIG. 6 are examples of records created in this way.

If the “end” barcode is read in step S50, the CPU 2 performs necessary processing such as closing the file and returns to the task selection waiting (S41).

The data (transaction file) collected in this way is transferred to the host computer according to the procedure shown in FIG.
Uploaded to 21. Where each CPU2, CPU2
2 is in a state of waiting for a task selection (S61, S71).
First, a fingertip touches “2. Data transmission” on the LCD 7 of the handy terminal 1 (S62). The CPU 2 is now in a "data transmission standby" state (S63).

For the host computer 21, the "data receiving mode" is selected in KB31 (S72). This causes the host computer 21 to enter the “data receiving state” (S73). Next, a finger is brought into contact with any key of the LCD 7 of the handy terminal 1 to instruct "start transmission" (S64). In response, the CPU 2 transmits a transaction file to the CPU 22 (S65).

The CPU 22 receives this transaction file (S
74). Then, what is the search key item for each record is read from the search key file, and each record of the transaction file is transcribed to a record of the management file having a key item having the same content as that of the key item (S75). . When these transcriptions are completed, the CPU 22 checks whether there is no data error or the like in the data reception, and transmits the result (check code) to the CPU 2 (S76).

CPU2 displays this check code on LCD7 (S6
6). Here, the fingertip contacts one of the keys (S67).
If the result is normal, CPU2 returns to "Wait for business selection" (S6
8) If abnormal, the state of the abnormality and points to be checked (such as cable connection) are displayed (S69). After checking and correcting this, data transmission is performed again.

(Modified example)

The writing of the table to the RAM card 41 may be performed through the route of the host computer 21 → handy terminal 1 → RAM card 41. The table may be stored in the RAM 5 of the handy terminal 1.

Alternatively, the transaction file may be stored in the RAM card 41, and the transaction file may be attached to the host computer 21 and uploaded.

Further, the tables may not be separated for each section, but may be combined into one table as appropriate.

〔The invention's effect〕

As described above, according to the present invention, it is possible to quickly respond to a process change, a failure of a handy terminal, and the like, and to smoothly execute data collection.

[Brief description of the drawings]

FIG. 1 shows an embodiment of the present invention, FIG. 1 is a flowchart of table creation, FIG. 2 is a block diagram showing a hardware configuration, FIGS. 3 to 5 are diagrams showing tables for each department, FIG. FIG. 7 is a diagram showing a file layout of a transaction file, FIG. 7 is a flowchart showing a procedure for creating a management file and the like, FIG. 8 is a flowchart showing a procedure for data collection, and FIG. 9 is an LCD screen at the time of data collection. FIG. 10 is a flowchart showing a procedure for uploading data. 1… Handy terminal, 2,22… CPU, 4,23… ROM, 5,25… RAM, 13… Barcode reader, 14… Barcode book, 21… Host computer, 41… RAM card.

Continuation of the front page (56) References JP-A-2-67898 (JP, A) JP-A-2-214792 (JP, A) JP-A-62-12942 (JP, A) JP-A-3-72295 (JP) , A)

Claims (1)

(57) [Claims] 1. A parent computer having a table creating means for defining conditions at the time of data collection as a table for each work type, and an electronic computer terminal having data collecting means and capable of exchanging data with the parent computer. Wherein the table creation means defines a condition at the time of data collection as a table, the data collection means reads input conditions corresponding to a work category selected by a user from the table, and executes data collection according to the condition. Data collection device.