JP3396817B2 - Quality information file management method and apparatus - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention is a management method for assembling product quality information in a quality control system in an assembly and inspection line of a production factory, and in particular, can process quality information efficiently and in a short time. The present invention relates to a quality information file management method.

[0002]

2. Description of the Related Art For example, when quality information at the time of completion of a vehicle and during assembly is key-input by an input device installed beside a line near a work, an operator can input each quality information in a short time without error. It is important to be able to enter a key, and various methods and apparatuses for inputting quality information have been proposed.

FIG. 6 is a view for explaining an example of a conventional method and apparatus in which an operator sequentially inputs the vehicle quality information by key input, and FIG. 6 (a) schematically shows the flow of the procedure. 6
6 (b) shows the screen of the display device, and FIG. 6 (c) schematically shows a general device using this conventional method.
(D) shows the format of the input information.

In this method and apparatus, first, an operator inputs an input device DS for inputting quality information by a terminal device PC at a preparatory step 101 to start the work, and an identification number assigned to each vehicle. And a setting step 102 for displaying the name corresponding to this header in the area B of the identification number on the display device CRT, while reading it with the bar code reader BR and setting it as the header ID which is the code of the identification number. ing.

Next, the operator reads the inspection result table and refers to the area M of the message for displaying a message prompting a key input on the display device CRT, while using the code QC of each quality information of one assembly vehicle as its element. Each time the key is sequentially input from the input device DS, the character string QCH of the quality information is displayed in the area E of the entry each time the key is input, and the entry step 103, and this code QC is used by the server SV for vehicle-specific information Update 1 stage 104 for displaying this character string QCH aligned in the input area IW while filing in the unit IU.

Finally, it comprises a reporting step 105 for transmitting the information unit IU to a central processing unit (not shown) of the production control system SYSA via the LAN, and takes necessary additional measures together with the inspection result of the assembled vehicle. It reports to the quality control system, collects all input files, arranges quality information on the day, and displays the result in the area T of the statistical table.

The input device DS is a data selector,
Although not shown individually, a keyboard in which a large number of keys corresponding to respective elements of the quality information are arranged and a function key group for instructing each control and processing the quality information are provided. Although not shown, the function key group includes a completion key for transferring quality information to the quality control system SYS via the terminal device PC and a clear key for erasing a numerical value once keyed. Incidentally, C is a coupling device for connecting this terminal device PC or the like to a LAN, and together with other terminal device PC and a transfer device or the like not shown, a server SV is connected via this LAN to form a quality control system SYS. And is connected to a production management system SYSA (not shown).

[0008]

However, when the above-mentioned conventional input method and device are used to key in the vehicle quality information to the input device while performing the inspection work, there are the following problems. It was (1) The evaluation contents, which are the results of the comprehensive judgment, are collected in correspondence with the identification numbers assigned to each vehicle, and the file of the comprehensive judgment that is separately created and the individual quality information are all collected together with the identification numbers. Since the input file and the input file are separately provided in the memory of the server, the above-mentioned identification number is duplicated in the stored contents, and the file area in the server is wasted. . (2) Further, since the application program on the terminal device using these files becomes complicated correspondingly, an extra burden is imposed on the overhead associated with the development and operation of the software. (3) Further, since these files are used by a large number of terminal devices, competing management in the server becomes complicated, and thus the access from the terminal devices is made to wait an additional amount. In view of the above-mentioned problems, it is an object of the present invention to provide a quality information input method and apparatus capable of efficiently inputting quality information in a product quality control system in a short time.

[0009]

A file management method for quality information according to claim 1 of the present invention, which has solved the above-mentioned problems, is to inspect the quality of parts constituting a product produced in a production factory and to produce a plurality of products. a file management method of quality information for managing the quality information and the overall evaluation in a single file for resets the identification information inputting step, the count variable for inputting identification information identifying the product, at least Ca
The addition of attributes having a count variable in the identification information 1
An adding step ; a quality information inputting step of inputting quality information for each part of the product;
A second adding step of counting up the count variable and adding the count variable to the quality information, a total evaluation inputting step of inputting the total evaluation of the product, and quality information with the count variable added to the file. The quality information file process of sequentially arranging and storing, and the file,
An identification information file step of storing the identification information and the comprehensive evaluation in which the attribute is continuously added to the array of the quality information added with the count variable stored in the quality information file step, and all the steps are performed by the plurality of products. Repeatedly, the quality information array with the count variable added is
It is characterized in that the information is stored by being separated by the identification information added with the attribute and the comprehensive evaluation. Further, the quality information file management device according to claim 2 of the present invention which has solved the above-mentioned problems, inspects the quality of parts constituting the products produced in the production factory, and performs quality information and comprehensive evaluation for a plurality of products. a file management apparatus of the quality information managed by a single file, an identification information input means for inputting identification information identifying the product, and resets the count variable, less the
Also adds an attribute having a count variable to the identification information
First addition means , quality information input means for inputting quality information for each part of the product, and each time the quality information is input,
The count variable is counted up and this count variable
Second addition means for adding a number to the quality information, total evaluation input means for inputting the overall evaluation of the product, and a quality information file for sequentially storing the quality information with the count variable added in the file. Means, and identification information file means for storing the identification information and the comprehensive evaluation in which the attribute is continuously added to the quality information array in which the count variable stored in the quality information file means is added to the file. The operation of all the means is repeatedly performed on the plurality of products, and the array of quality information to which the count variable is added is divided and stored by the identification information and the comprehensive evaluation to which the attribute is added. To do.

[0010]

The individual quality information is collected for each product, separated by the product identification number and the comprehensive judgment contents, and stored in one file. Further, an attribute for access is given to each quality information, the product identification number, and the comprehensive determination content, and they are collectively managed in this input file by the application program of the terminal device.

[0011]

Embodiments of the present invention will now be described with reference to the drawings in a vehicle manufacturing plant. FIG. 1 is a diagram for explaining an embodiment of the method and apparatus of the present invention, in which the same parts as in the conventional example are omitted. FIG. 1 (a) schematically shows the operation flow in the terminal device, and FIG.
Shows schematically the memory configuration in the terminal device and the server, and FIG. 1 (c) shows the configuration of individual quality information.

The main part of the method and device of this embodiment is to first provide a two-step entry 103a in which the terminal device receives the information of the vehicle identification number and each element of the quality information entered by the key. A configuration two-stage 104a for evaluating and filing each file is provided next, and is configured as shown in FIG.
In the conventional example shown in (a), the first step 103 is the second step 103a, and the first step 104 is the second step 10
4a, respectively.

In FIG. 1B, the terminal device PC has a plurality of entry register groups ER provided with a plurality of registers for temporarily holding key-input information, and a plurality of display units for displaying a change in state in each process. Flags F1, F2, F3
A status register SR having F4 is provided in the main memory, and these register groups ER and SR are all initialized at the preparation stage described above.

The server SV arranges files KF, J corresponding to respective codes KC, JC, SC, HC of items, events, responsible areas, repairs and indications.
The file memory is provided with F, SF, HF, and an input file IF for collectively arranging quality information for each vehicle and transferring it to the quality control system SYS. The repair and indication file HC may be provided in the terminal device PC.

The flag F1 is the code KC of the new item.
The flag F2 sets the code JC of the new event when the terminal device PC accepts it, and accepts the code KC of the item when the flag F2 is on, so that the new quality information is sent to the terminal device PC. By indicating that the PC has accepted, and accepting the event code JC when the flag F1 is on, a series of quality information is transmitted to the terminal device PC.
Has been accepted without excess or deficiency.

The flag F3 indicates that the above-mentioned header ID has been input, and is transferred to the attribute bit ZB1 described later to be processed. The flag F4 indicates that the above-mentioned quality information QC has been input, and is transferred to the attribute bit ZB2 described later to be processed.

In FIG. 1 (c), the code QC of the individual quality information is the code K of the item which is an element designating the part.
C and event code JC that is an element indicating the result of the inspection
And the responsible area code SC that is an element that indicates the department to be repaired, and the indicated code HC that is an element that indicates the department to be inspected and that is an element that indicates the status of the repair. It shows which part has what kind of symptom, which department carried out repair, and which inspection department input this quality information.

FIG. 2 is an explanatory diagram for storing the quality information in the server, and FIG. 2A shows the entry register group and the input file. With reference to FIG. 2A, the two stages of entry and the two stages of organization in FIG. 1 will be described in detail. The entry register group ER is a header ID which is a code corresponding to the identification number read above.
And a first register ER1 for temporarily holding the attribute information described later, and a second register ER2 for temporarily holding the code QC of the quality information and the attribute information described later.
It consists of and.

In the entry step 2103a, in FIG. 1 (a), first, the header ID is input from the bar code reader BR, and the first attribute bit ZB1 for access is added to add the attribute. The identification input means 2 which forms the header Fn and is set in the above-mentioned entry register ER1 and the respective codes KC and JC of the item and the event are individually keyed, and the previous quality set in the above-mentioned entry register ER2 is set. The information is filed, and the code SC of the responsible area is automatically generated and input by these codes KC and JC, and the second attribute bit ZB2 for access is added to form the code Qm of the attributed quality information. , The items to be set in the entry register ER2, and the event input means 3 and 4 are provided in this order. Note that n,
m indicates the m-th quality information of the n-th vehicle.

Subsequently, instead of being automatically generated, the code SC of the responsible area is individually keyed if necessary, and the items are set and entered in the same manner as the above items and the event input means 3 and 4. , And the code KC, JC of the event, the responsible area input means 5 for registering the code SC of this responsible area, and both repair and indication codes H
Key in C individually as needed to enter these codes H
Repairing to set C to the initial value of the next quality information input and indication input means 6 are provided in this order, and this entry 2 step 1
03a.

Accordingly, the entry 2 step 103a is performed in the header I set in the above-mentioned entry register ER1.
The identification number corresponding to D is displayed in the area B of the above-mentioned identification number, and the names corresponding to the respective codes KC, JC, SC and HC set in the above-mentioned entry register ER2 are set in the item of the server SV. , Event, and responsibility area files KF, JF, SF, and HF are read, and their names are displayed in the above-mentioned entry area E and input area IW.

In the rearrangement 2 step 104a, the correction means 7 similar to the conventional example and the comprehensive evaluation of the vehicle are added, and the above-mentioned attribute-added header Fn and attribute-added quality information code Qm are added.
And the completion input means 8 for filing in the above-mentioned input file IF are provided in this order. These codes Fn and Qm are collected for each vehicle, and the header F with the attribute is formed.
It is divided by n and stored.

That is, first, the code Qm of the attribute-added quality information is sequentially arranged in the input file IF in the order in which it is formed, and then the attribute-added header ID is added to the quality information group. A quality information group and an identification number are combined at the end as a delimiter, and the combination is repeatedly stored an arbitrary number of times to form the input file IF. Group of attributes with header Fn
Allows you to distinguish it from the later groups.
Note that Fn-1 is a header ID with an attribute added to the previous group.

The attribute bits ZB1 and ZB2 are flag bits FB1 and FB2 having both of the above-mentioned respective flags F3 and F4, and a common count bit indicating the order of inputting the respective quality information codes. C
And B respectively.

FIG. 2B is an explanatory diagram for accessing the above-mentioned responsible district file. The responsible district file SF has a predetermined address A in which the codes SC of the responsible districts, which are input following these item and event codes KC and JC, are associated in order with the codes of all the items.
The data is arranged in D2 and stored with a predetermined data length M.

That is, in FIG. 2 (b), the responsible district file SF is defined by the following formula (Equation 1).
The offset from the address A2 is a number n1 indicating the order of item codes, and a number n2 indicating the order of event codes,
The maximum value n2 _{ma x} address AD2 by calculating from the number n2 is accessed, the stored responsible district code SC
Is read and is registered in the entry register ER.

[0027]

## EQU1 ## AD2 = A2 + (n1n2 _max + n2) M

Here, the code KC of the item is from the 0th,
The code JC of the event is arranged from the first, and S01
Is the code KC of the 0th item and the code J of the 1st event
Corresponding to C, S11 indicates a memory area corresponding to the code of the first item and the code of the first event. It should be noted that the order of arrangement is not limited to this embodiment. The ALU is an arithmetic operation means.

FIG. 3 and FIG. 4 are the two steps 1 in FIG.
3A and 3B are partially detailed flow charts. FIG. 3A shows the identification input means 2, FIG. 3B shows the item input means 3, and FIG.
4C shows the event inputting means 4, FIG. 4A shows the responsible area inputting means 5, and FIG. 4B shows the repairing and pointing inputting means 6, respectively, and the connectors b1 to b5 are respectively shown. Determination processing 21, 31, 41, 51, 61,
At 63, when each start condition is not satisfied, the subsequent flow is branched to execute the next means. still,
(Return) is after finishing the processing by each means,
It is a return destination that branches the flow when bypassing on the way.

In FIG. 3A, first, the determination process 21
The starting condition is that the header ID has been read by the bar code reader BR. At this time,
First, the flag bit F3 is set, F4 is reset, the count bit CB is reset, the above-mentioned attribute bit ZB1 is formed, and the above-mentioned entry register ER is formed.
The first attribute processing 22 for holding the header ID at a predetermined position of 1 is executed, and then this header ID is held at a predetermined position of the above-mentioned first entry register ER1 by the numeral 1 processing 23 , and this header ID is held. The identification information corresponding to the above is displayed in the area B of the above-mentioned identification number, and each processing in this identification input means 2 is completed.

In FIG. 3B, first, determination processing 3
The starting condition of Nos. 1 and 32 is that the code KC of the item is independently keyed in. At this time, first, from the above-mentioned second entry register ER2, the previously set quality information, if any, has been set. File registration 1 processing 33 for registering the file with the input file IF, and then the flag bit F
Reset 3 and set F4 to count bit C
B is incremented by +1 to execute the second attribute processing 34 for forming the above-mentioned attribute bit ZB2 and holding it at the predetermined position of the entry register ER2, and finally resetting the above-mentioned flags F1 and F2. The flag process 35 is executed, and when different, these processes 33, 34, 35 are executed.
Is bypassing.

Next, the code KC of this new item is held in the entry register ER2 in the numeral 2 processing 36, and the code HC of the previous repair and indication is similarly set as the initial value in the quality information of this time. While holding, the names corresponding to the respective codes are read from the files of the respective elements, these names are displayed in the area E of the above-mentioned entry, the flag F1 is set in the flag setting processing 37, and the item input means 3 is used. Each processing of has been completed. It is also possible to set an initial value for the repairing and indicating code HC in advance by a separate means and to set this initial value every time in this process 36.

In FIG. 3C, first, determination processing 4
The start condition of Nos. 1 and 42 is that the flag F1 has been set when the code JC of the event is keyed in, and at this time, the code JC is displayed while being held by the numerical numeral 3 processing 43 described later. However, the flag F2 is set.

Numerical value 3 processing 43, 46, 52, 62, 64
Takes in the codes JC, SC, and HC of each element individually or in combination, and the second entry
While holding in the register ER2, the names corresponding to these codes are fetched from the file of each element and displayed in the area E of the above-mentioned entry.

Next, the item code KC and the event code J
As shown in FIG. 2 (b), the responsible area file SF is searched by C and the responsible area code SC is fetched as described above, and the code S is entered in the numeral 3 processing 46.
The C is displayed while being held, and the respective processes in the event input means 4 are completed.

In FIG. 4A, first, the judgment processing 51
The condition for starting is that the code SC of the responsible area is keyed in. At this time, the code SC is displayed while being held in the numeral 3 process 52, and then the flag F1, is determined in the judgment process 53.
This code SC is shown in Fig. 2 (b) only when F2 has been set.
As described above, the responsible area registration process 54 for registering in the responsible area file SF is executed, and each processing in the responsible area input means 5 is completed.

In FIG. 4B, first, the judgment processing 61
The starting condition is that the repair or indication code HC has been keyed in. At this time, these codes HC are displayed while being retained in the numeral 3 processing 62 and 64, and the repair and indication input means 6 Each processing has been completed.

FIG. 5 is a flow chart showing in detail the completion input means 8 in the second stage of the arrangement of FIG. 1, in which the correction means 7 described in FIG. 1 is connected to the connector b6, and the reporting step 105 described in FIG. And the processing is continued by the connector E2.

In FIG. 5, first, the starting condition of the judgment processing 81 is that one of a plurality of completion keys for inputting the comprehensive evaluation of the vehicle is pressed, and in this case, first, The file registration 1 process 33 and the flag process 34 described above are sequentially executed.

Next, the evaluation code (not shown), which is the above-mentioned comprehensive evaluation, is assigned to the first register ER in FIG.
The attribute ID ZB1 is set together with the header ID held in this register to form the attributed header Fn, which is the final quality information of the attributed vehicle for this vehicle. The file registration 2 process 82 for storing in the address following the code Qm is executed, and each process in the completion input means 8 is completed. At this time, if there is no need to input the quality information of this vehicle, the attributed header Fn is stored at the address following the attributed header Fn-1 of the previous vehicle.

Therefore, the attributed header Fn stored in the input file IF indicates the value of the total number of all the quality information of one vehicle assigned this identification number in the inspection result table. The attribute bit ZB1 is stored in the attribute bit ZB1 and is referred to by the flag bit F3 only in the reporting step 105 and in searching the input file IF as needed. Since the address of the header Fn can be accessed, it is possible to quickly and accurately read all the quality information of this one vehicle stored in the address before that by tracing back the total number value described above. It has become.

The present invention is not limited to the above-mentioned embodiment, and for example, an attribute for access may be added only to the header, and each of the above items, events, and responsible areas may be added. Each of the files may be divided by itself, and may be partially transferred to a terminal device for local use if necessary. Further, it goes without saying that various modifications can be made within the scope not departing from the gist of the present invention, such as the fact that it may be carried out in a general production factory other than vehicle manufacturing.

[0043]

As described above, the present invention has the following effects. (1) A comprehensive judgment file in which the evaluation contents, which are the results of comprehensive judgment, are collected in association with the identification numbers assigned to each product, and an input file in which all the individual quality information together with this identification number are collected. Since the files are collectively provided on the memory of the server, it is possible to eliminate the waste of the file area in the memory. (2) Further, since the application program on the terminal device for managing these files becomes simpler by that amount, it is possible to reduce the extra burden of overhead involved in software development and operation. (3) Further, since file management in the server accessed by a large number of terminal devices becomes simple, the access from the terminal devices can be accelerated accordingly. As a result of the above (1) to (3), the quality information is efficiently and
You will be able to enter keys in a short time.

[Brief description of drawings]

FIG. 1 is a diagram illustrating a method and apparatus of the present invention.

FIG. 2 is a diagram illustrating an input file and a responsible area file used in the present invention.

FIG. 3 is a flow chart for explaining identification input, item input, and event input means in FIG.

FIG. 4 is a flowchart for explaining responsible area input, repair and indication input means in FIG.

5 is a flowchart illustrating a completion input unit in FIG.

FIG. 6 is a diagram illustrating a conventional method and apparatus.

[Explanation of symbols]

2 ... Identification input means 3 ...
・ Item input means 4 ・ ・ ・ Event input means 5 ・ ・ ・
・ Responsible area input means 6 ・ ・ ・ Repair and indication input means 8 ・ ・ ・ ・
・ Completion input means PC ・ ・ ・ ・ ・ ・ Terminal device ER ・ ・ ・
・ Entry register SF ・ ・ ・ ・ ・ ・ Responsibility area file IF ・ ・ ・
・ Input file QC ・ ・ ・ ・ Code of quality information QCH ・ ・
・ Quality information character string 103a ・ 2 steps of entry 104a ・
・ Two stages of organization

─────────────────────────────────────────────────── ─── Continuation of the front page (58) Fields surveyed (Int.Cl. ⁷ , DB name) G05B 19/418 B23Q 37/00-41/08 G06F 17/60

Claims (2)

(57) [Claims] 1. A file management method of quality information for inspecting the quality of parts constituting a product produced in a production factory, and managing quality information and comprehensive evaluation of a plurality of products in a single file. Input the identification information to identify the product, reset the count variable and reset the count variable to at least
A first adding step of adding an attribute to the identification information, a quality information inputting step of inputting quality information for each part of the product, and counting up the count variable each time the quality information is input, A second adding step of adding a count variable to the quality information, a comprehensive evaluation inputting step of inputting a comprehensive evaluation of the product, and quality information of sequentially arranging and storing the quality information to which the count variable is added in the file. File process, and stored in the file in the quality information file process
The sequence of quality information with a count variable added
It includes an identification information file step of storing the identification information and the overall evaluation obtained by adding attributes, and repeats the entire process for the plurality of products, before
A file management method for quality information, characterized in that an array of quality information added with a count variable is stored delimited by identification information added with the attribute and comprehensive evaluation. 2. A quality information file management device for inspecting the quality of parts constituting a product produced in a production factory, and managing quality information and comprehensive evaluation of a plurality of products in a single file, identification information input means for inputting identification information identifying the product, and resets the count variable, at least count variable
First adding means for adding an attribute to the identification information, quality information input means for inputting quality information for each part of the product, and counting up the count variable each time the quality information is input, Second addition means for adding a count variable to the quality information, comprehensive evaluation input means for inputting a comprehensive evaluation of the product, and quality information for sequentially arranging and storing the quality information with the count variable in the file. A file means and the file stored in the quality information file means
The sequence of quality information with a count variable added
An identification information file means for storing identification information with an attribute added and an overall evaluation, and the operation of all the means is repeated for the plurality of products, and the array of quality information with the count variable added is
A file management device for quality information, which is stored by being separated by identification information added with the attribute and comprehensive evaluation.