CN103314335B

CN103314335B - The control method of transacter and this transacter and control program

Info

Publication number: CN103314335B
Application number: CN201180065611.9A
Authority: CN
Inventors: 熊本浩; 藤井徹
Original assignee: Omron Corp
Current assignee: Omron Corp
Priority date: 2011-01-31
Filing date: 2011-03-18
Publication date: 2016-04-27
Anticipated expiration: 2031-03-18
Also published as: CN104914818A; CN104914820B; MY189890A; MY193471A; MY171680A; WO2012105063A1; CN104914820A; JP5327239B2; JP2012159942A; CN103314335A; CN104914818B

Abstract

Transacter (11) collects the inspection data from the testing fixture (3335) of manufacturing line, and these inspection data is added in the attribute value table checking DB recording unit (63).Transacter (11) has: check file record portion (60), obtains the inspection file comprising and check data and filename, and record this inspection file and filename from testing fixture (3335); Additional information extracting part (50), extracts the additional information relevant with checking data from the filename that self-check file record portion (60) reads; Data changing unit (51), adds to come the inspection data in the inspection file in self-check file record portion (60) by the additional information of extraction, and as attribute value data; Data write section (53), adds the attribute value data from data changing unit (51) in the attribute value table checking DB recording unit (63).

Description

The control method of transacter and this transacter and control program

Technical field

The present invention relates to and collect from the data of each equipment on manufacturing line, and the data of collection are added the transacter of database and the control method of this transacter and control program.

Background technology

Since the past, people are devoted to collect always and analyze the data from manufacturing the on-the-spot various equipment such as manufacturing installation, measurement mechanism, testing fixture, and are used for by analysis result (as patent documentations 1 ~ 6) such as the control of the said equipment, supervision, improvement or QAN Quality Amelionrate Notices.

With regard to the collection of above-mentioned data, recent equipment is greatly mainly with CSV(CommaSeparatedValue; With comma distinguish value) form (format) data file (hereinafter referred to as " csv file ") form export data.At this, can consider with the data of the form of csv file collection from the said equipment.This is because, csv file have make easily, management easily, versatility advantages of higher.Therefore, can consider with the data of the form of csv file collection from the said equipment.

Above-mentioned making easily specifically refers to, such as, only distinguishes data with comma and namely can be made into csv file, need not distinguish the data type such as numeral, character string and namely can be made into csv file etc.Above-mentioned management easily specifically refers to, such as, can copy the file operations such as deletion to csv file, can be modified by text editor to the data in csv file.In addition, above-mentioned versatility height specifically refers to, such as, because csv file is text formatting, therefore can be used for general table software for calculation etc.

In addition, in order to more effectively to above-mentioned data analysis, can consider by this data DBization (data base system), that is, collect above-mentioned data and add in DB.Above-mentioned DBization such as tool has the following advantages.

(a) search function

By utilizing SQL(StructuredQueryLanguage; Structured Query Language (SQL)), easily can retrieve the data from above-mentioned DB, sort, counting etc.

The combination of (b) data

For different or customization is different and the file of segmentation by date, by adding above-mentioned DB, the data in multiple file can be used as a data entirety.Thus, for long-standing data such as leap date, customization etc., can carry out monitoring, adding up etc. respectively identical machine.

The unitary management of (c) data

By by the data DBization from multiple manufacturing line, can to monitor these data by accessing same DB and to analyze.In addition, the operations such as data backup of can seeking unity of action, are therefore easy to management.

D () is to the remote access of data

There is the DBMS(DatabaseManagementSystem for managing above-mentioned DB; Data base management system (DBMS)) server via communication network and PC(PersonalComputer; PC) be connected, this PC is via ODBC(OpenDatabaseConnectivity; Open database inter connection) access above-mentioned DBMS, thereby, it is possible to carry out telemonitoring and analysis to data.

(prior art document)

Patent documentation 1: Japanese Patent Application Laid " JP 2001-296911 publication "; October 26 calendar year 2001 is open.

Patent documentation 2: Japanese Patent Application Laid " JP 2002-236511 publication "; On August 23rd, 2002 is open.

Patent documentation 3: Japanese Patent Application Laid " JP 2004-164635 publication "; On June 10th, 2004 is open.

Patent documentation 4: Japanese Patent Application Laid " JP 2006-323505 publication "; On November 30th, 2006 is open.

Patent documentation 5: Japanese Patent Application Laid " JP 2007-052571 publication "; On March 1st, 2007 is open.

Patent documentation 6: Japanese Patent Application Laid " Unexamined Patent 09-050949 publication "; On February 18th, 1997 is open.

Summary of the invention

(the problem to be solved in the present invention)

But, by from manufacturing on-the-spot csv file DBization, also there is Railway Project.

Not only comprise normal measured value from the data of each equipment, sometimes also comprise abnormal measured value and measure error.The measured value of these exceptions and the data of measurement error are mostly HI, LO, N/A(NoAccount; Invalid) etc. character string.But csv file can not distinguish the data types such as digit strings, therefore, even if will analyze measured value, also can cause makeing mistakes because comprising nonnumeric data, thus cause analyzing interruption.

In addition, when utilizing above-mentioned DB to carry out data analysis, the order of data needs the sequence consensus specified with the ordering in launching etc. of workpiece (manufacturing object thing).This is because, if data sequence is inconsistent, then when carrying out cycle analysis and comparing the correlativity of the measurement data of each equipment, cannot correct analysis be carried out.

But, in the manufacturing line of reality, there is the situation that the order of data is inconsistent with the order of regulation sometimes.Such as, in order to coordinate the processing time of each equipment, processing slower equipment (as testing fixture) and sometimes parallel processing being carried out to multiple workpiece.Now, the situation that the order of the measurement data of the inconsistent and workpiece of the ordering in launching of the processing sequence of workpiece and workpiece is inconsistent with the ordering in launching of workpiece may be there is.In addition, measure error because producing, or in processing procedure, be short of the workpiece as handling object, equipment can be caused not export measurement data, thus, also likely occur the situation that the order of the measurement data of workpiece is inconsistent with the ordering in launching of workpiece.

In addition, the data that manufacturing line is measured by date, customization, the difference of time etc. and be divided into different csv files, but and be not all split by the unit that will analyze (customization, machine, specified time limit (every year, every month, match with object weekly etc. during)).Therefore, can cause cannot to cross over the date long-term between data analysis and cannot to inconvenience such as data analysis between long-term in units of machine.In order to avoid above-mentioned inconvenience, need to combine data according to the ordering in launching of workpiece.In addition, in filename, often comprise the various information such as customization numbering, machine, voltage as the unit that will analyze (information required for different level).These information are not comprised in above-mentioned file sometimes.Now, if only the data in above-mentioned file are added above-mentioned DB, then can lose the information comprised in above-mentioned filename, thus cause to come data analysis by the above-mentioned unit that will analyze.

The present invention completes just in view of the above problems, its object is to, there is provided a kind of and under the prerequisite of not drop-out or the order unified data from each equipment on manufacturing line well, and can carry out the transacter etc. of data analysis accurately.

(scheme of dealing with problems)

In order to solve the problem, transacter of the present invention collects the data from each equipment on manufacturing line, and the data of collection are added database, the feature of this transacter is: have: acquiring unit, obtains the measurement data from described equipment; Add unit, when comprising character string in the measurement data that described acquiring unit obtains, this character string being converted to and can carry out processing as numerical string and be different from the value of measured value, and described measurement data is added described database.

At this, can carry out processing as numerical string and the value being different from measured value is such as, null value, 0, negative value etc.

In addition, in order to solve the problem, the control method of transacter of the present invention is the control method for transacter, this transacter collects the data from each equipment on manufacturing line, and the data of collection are added database, the feature of the control method of this transacter is: comprise: obtaining step, obtains the measurement data from described equipment; Add step, when comprising character string in the measurement data obtained through described obtaining step, this character string being converted to and can carry out processing as numerical string and be different from the value of measured value, and described measurement data is added described database.

According to said structure and method, when comprising character string in described measurement data, first convert this character string to null value, more described measurement data is added described database.As a result, in the database, comprise measured value or null value in described measurement data, and do not comprise character string, therefore, it is possible to easily analyze above-mentioned measurement data.

In order to solve the problem, transacter of the present invention collects the data from each equipment on manufacturing line, and the data of collection are added database, the feature of this transacter is: have: production line information recording part, record production line information, the corresponding relation between the rule comprising the order of the workpiece of described equipment and this device processes in described production line information; Acquiring unit, obtains the data of each workpiece of described equipment; Arrangement units, according to the production line information from described production line information recording part, according to the order of regulation, arranges the data of each workpiece that described acquiring unit obtains; Add unit, the data of each workpiece arranged by described arrangement units add described database.

In order to solve the problem, the control method of transacter of the present invention is the control method for transacter, this transacter collects the data from each equipment on manufacturing line, and the data of collection are added database, the feature of the control method of this transacter is: comprise: obtaining step, obtains the data of each workpiece of described equipment; Alignment step, production line information is read from recording unit, and according to the production line information read, according to the order of regulation, arrange the data of each workpiece obtained through described obtaining step, wherein, the corresponding relation between the rule comprising the order of the workpiece of described equipment and this device processes in described production line information; Add step, the data of each workpiece arranged through described alignment step are added described database.

At this, the order of described regulation is such as: workpiece drops into order, official hour order, the batch order of regulation, the machine order etc. of regulation of manufacturing line.The rule of described order is such as: multiple channel, measurement error, upset and number, measurement moment etc.

According to said structure and method, according to the production line information from production line information recording part, according to the order of regulation, arrange the data of each workpiece obtained from described equipment, and these data are added database.So the data comprised in described database arrange, therefore, it is possible to utilize described database to carry out data analysis accurately according to the order of regulation.

In order to solve the problem, transacter of the present invention collects the data from each equipment on manufacturing line, and the data of collection are added database, the feature of this transacter is: have: acquiring unit, obtains the file and the filename that comprise described data from described equipment; Extracting unit, from the filename that described acquiring unit obtains, extracts the additional information relevant with described data; Add unit, the additional information that described extracting unit extracts is added in the described data in the file of described acquiring unit acquisition, and these data are added described database.

In order to solve the problem, the control method of transacter of the present invention is the control method for transacter, this transacter collects the data from each equipment on manufacturing line, and the data of collection are added database, the feature of the control method of this transacter is: comprise: obtaining step, obtains the file and the filename that comprise described data from described equipment; Extraction step, from the filename obtained through described obtaining step, extracts the additional information relevant with described data; Add step, the additional information extracted is added in the described data in the file obtained through described obtaining step, and these data are added described database through described extraction step.

According to said structure and method, from equipment, obtain file and filename, and from the filename obtained, extract the additional information relevant with the data in described file.Then, the additional information of extraction is added in the data in described file, and these data are added database.Thus, not only comprise the data in described file in database, also add the additional information comprised in described filename, therefore, it is possible under the prerequisite of not losing additional information by the data integration from equipment in database.

Each step in described transacter can be performed by computing machine in the mode of control program.In addition, by being stored in the recording medium of embodied on computer readable by described control program, described control program can be performed on arbitrary computing machine.

(effect of invention)

As mentioned above, when comprising character string in measurement data, transacter of the present invention first converts this character string to null value, more described measurement data is added database, therefore, it is possible to play easily to the effect that above-mentioned measurement data is analyzed.

Transacter of the present invention is according to the production line information from production line information recording part, according to the order of regulation, arrange the data of each workpiece obtained from equipment, and these data are added database, therefore, it is possible to play the effect utilizing this database to carry out data analysis accurately.

Transacter of the present invention obtains file and filename from equipment, and from this filename, extract the additional information relevant with the data in described file, then, the additional information of extraction is added in the data in described file, and these data are added database, therefore, it is possible to play the data integration from equipment under the prerequisite of not losing additional information to the effect in database.

Accompanying drawing explanation

Fig. 1 is the schematic configuration block diagram of the transacter in the production system of an embodiment of the present invention.

Fig. 2 is the schematic configuration block diagram of above-mentioned production system.

Fig. 3 is the processing flow chart in above-mentioned transacter from record check file to renewal checks DB.

Fig. 4 is the schematic diagram of the example representing the extraction condition be recorded in the extraction condition recording unit of above-mentioned transacter with the formation of structured document.

Fig. 5 is the schematic diagram of the example representing the filename of above-mentioned inspection file with tabular form.

Fig. 6 is the process flow diagram that the additional information extracting part of above-mentioned transacter carries out the extraction process of additional information.

Fig. 7 is the schematic diagram of the example representing corresponding relation between entry name and character string in the form of a table.

Fig. 8 is the schematic diagram representing the example that operator shows in the form of a table.

Fig. 9 is that the testing fixture represented in above-mentioned production system walks abreast the block diagram of example of inspection 3 workpiece.

Figure 10 is the workpiece numbering that 3 inspection portions represented in the form of a table in above-mentioned testing fixture check and the schematic diagram checking the moment.

Figure 11 be the above-mentioned workpiece represented in the form of a table after arrangement numbering, check CH and check the schematic diagram in moment.

Figure 12, after being checked by above-mentioned testing fixture, overturns before and after inspecting stand, then by the block diagram of another testing fixture to the example that workpiece checks.

Figure 13 is the workpiece numbering representing that another testing fixture above-mentioned checks in the form of a table and the schematic diagram checking the moment.

Figure 14 is the schematic diagram of the example representing the production line information recorded in the production line information recording part of above-mentioned transacter with the form of structured document.

Figure 15 is the process flow diagram that the data combining of above-mentioned transacter carries out that data combine process.

Figure 16 is the schematic diagram of the example of the content representing the inspection file that above-mentioned transacter obtains in the form of a table.

Figure 17 is the schematic diagram of the example of the content representing attribute value table and the NG table recorded in the inspection DB recording unit of above-mentioned transacter in the form of a table respectively.

Figure 18 represents to produce without the numbering of the workpiece after arrangement during workpiece, the schematic diagram checking channel and inspection moment in the form of a table.

Figure 19 represents that the workpiece after arrangement when there is workpiece turning is numbered and checks the schematic diagram in moment in the form of a table.

Embodiment

With reference to Fig. 1 ~ Figure 19, an embodiment of the invention are described.In the present embodiment, the present invention is applicable to the production system with production line, this production line for the manufacture of and assembling parts.But the present invention is not limited to above-mentioned production system, go for the general management to the operation that processed object processes.The operation that processed object processes is referred to, such as, inspection operation, the treatment process of obsolete objects (such as, plant wastes, plant chimney stalk, waste gas, rubbish etc.), the inspection operation, equipment inspection operation, cycling and reutilization operation etc. of obsolete objects of the production process of industrial product, ore deposit industrial product, agricultural product or raw material.

Fig. 2 represents the schematic configuration of the production system of present embodiment.In production system 1, transacter 11 collects the various inspection data from the multiple testing fixtures being arranged at production scene 10, and be made the database (hereinafter referred to as " check DB ") of these inspection data, and via communication network 13, the inspection DB that is made is utilized by PC14.Communication network 13 and PC14 all adopt known technology, thus omit related description.

In the present embodiment, the parts manufacturing line (operation production line in early stage) 20 being provided with manufacture component in production scene 10 and the machining production line (assembly line) 21 that the parts manufactured are assembled.Be provided with 2 production lines 2223 in parts manufacturing line 20, each production line 2223 manufactures identical parts 24.

And on machining production line 21, relative to production line 30, be provided with parts generator 31, processing unit (plant) 3234 and testing fixture 3335.The parts 24 manufactured through parts manufacturing line 20 are supplied to production line 30 by parts generator 31, and parts 24 assembling is worked on the substrate of workpiece 36 by processing unit (plant) 32 again, then the inspection after being processed by testing fixture 33.Then, processing unit (plant) 34 in the workpiece 36 after checking and position that parts 24 are irrelevant process, then the inspection after being processed by testing fixture 35.Then, processing and check processing is repeated, until complete goods.In the present embodiment, processing unit (plant) 3234 and testing fixture 3335 are different devices, but also can be integrated the device of type.

Testing fixture 3335 checks workpiece 36 with regard to various inspection item, and makes inspection file, in this inspection file, comprises the inspection data of the expression check result by inspection item classification.Check that file can be made in units of every 1 workpiece 36, also can make in units of multiple workpiece 36, also can make in units of the workpiece 36 of regulation number, can also make in units of the stipulated time.

In general, most of testing fixture 3335 checks except file except making with the distinctive form of manufacturer, can also check file with CSV formatted output.At this, in the present embodiment, testing fixture 3335 provides the inspection file (csv file) of CSV form to transacter 11.In addition, testing fixture 3335 checks while file providing, and also by file system, provides the various information relevant with above-mentioned inspection file, as filename, time interocclusal record (timestamp) etc.Testing fixture 3335 provides inspection file to transacter 11, can have been combined, also can pass through USB(UniversalSerialBus by wire communication, radio communication or wire communication with radio communication; USB (universal serial bus)) recording medium such as storer come.

Fig. 1 represents the schematic configuration of transacter 11.As shown in Figure 1, transacter 11 has control part 40, recording unit 41 and network I/F(interface) portion 42.

The action of each structure in control part 40 Comprehensive Control transacter 11, such as can by comprising CPU(CentralProcessingUnit; Central processing unit) and the computing machine of storer form.The action control of each structure can come by making computing machine executive control program.For the detailed content of control part 40, will be described hereinafter.

Recording unit 41, for recorded information, is made up of the pen recorder such as hard disk, flash memory.For the detailed content of recording unit 41, will be described hereinafter.

Network I/F portion 42 is the interface between control part 40 and communication network 13.Be specially, network I/F portion 42 is connected with the communication network 13 shown in Fig. 2.Network I/F portion 42 not only converts the data from control part 40 to be suitable for communication network 13 form, and sends to communication network 13, also the data from communication network 13 is converted to the form being suitable for control part 40 and processing, and sends to control part 40.

Below, control part 40 and recording unit 41 are described in detail.As shown in Figure 1, control part 40 has additional information extracting part (extracting unit) 50, data changing unit (adding unit) 51, data combining (adding unit, arrangement units) 52, data write section (adding unit) 53 and data providing unit 54.Recording unit 41 has the file record portion (acquiring unit) 60 that checks, extraction conditions recording unit 61, production line information recording part 62 and checks DB recording unit 63.In addition, each testing fixture 3335 has additional information extracting part 50, data changing unit 51 respectively and checks file record portion 60.

Check that file record portion 60 is respectively for testing fixture 3335, records the inspection file from testing fixture 3335.Check file record portion 60 also record in catalogue filename, time the various information relevant to above-mentioned inspection file such as interocclusal record.As mentioned above, check that file is the file of CSV form.

Extraction condition recording unit 61 is for each inspection file record portion 60, and the pre-recorded extraction condition had for extracting additional information, described additional information is the information of the inspection data needing to be added to certain workpiece 36.Production line information recording part 62 is pre-recorded production line information, and described production line information is the information relevant to manufacturing line, is the information again needed for array data.Check that DB recording unit 63 records and check DB.Check that DB comprises the attribute value table of stored attribute values and stores NG(NoGood; Make mistakes) NG of data table etc.These tables can individualism, also may be incorporated in together.

Additional information extracting part 50 is according to the extraction condition of record in extraction condition recording unit 61, extract said additional information, described additional information refers to be attached to the information checked in data, and described inspection data are included in should from checking the inspection file that file record portion 60 reads.The additional information of extraction is sent to data changing unit 51 by additional information extracting part 50.

Be specially, first additional information extracting part 50 reads various information relevant to above-mentioned inspection file from the catalogue checking file record portion 60, as filename, time interocclusal record etc.Then, additional information extracting part 50, according to the extraction condition of record in extraction condition recording unit 61, extracts said additional information from the information read.For the detailed content extracting said additional information, will be described hereinafter.

In addition, sometimes in filename, parameter is attached with, as " [customization numbering] .csv [machine] [voltage] [channel] " etc.This parameter is also contained in said additional information.In addition, by preserving the enactment document of the parameter of each machine, the parameter corresponding with machine can be extracted.

Data changing unit 51 is for changing from checking the data comprised the inspection file that file record portion 60 reads.Data after change are sent to data combining 52 by data changing unit 51.

Be specially, if the inspection data come in the inspection file in self-check file record portion 60 are character string, then data changing unit 51 thinks that these inspection data are NG data, above-mentioned character string is changed to null value (null).If check, file is CSV form, then above-mentioned character string is changed to null value character string (length is the character string of 0).Data changing unit 51 also makes NG file, in this NG file, on the arrangement position identical with these inspection data of above-mentioned inspection file, comprises above-mentioned NG data character string.

Data changing unit 51, in the inspection data of above-mentioned inspection file, adds the additional information relevant to above-mentioned inspection file from additional information extracting part 50, as attribute value data.Then, the inspection file after process and the NG file corresponding with this inspection file are sent to data combining 52 by data changing unit 51.

The various data received from multiple data changing unit 51, in units of workpiece 36, combine by data combining 52.The combining data of data combining 52 send to data write section 53.

Be specially, data combining 52 is according to the production line information of record in production line information recording part 62, arrange the attribute value data (checking data and additional information) of each workpiece 36 and combine, described attribute value data is included in the multiple inspection files received from multiple data changing unit 51.Equally, data combining 52, according to above-mentioned production line information, arranges the NG data of each workpiece 36 and combines, and described NG data are included in the NG file from multiple data changing unit 51.

In addition, data combining 52, according to the production line information of record in production line information recording part 62, rearranges the attribute value data of the workpiece 36 from data changing unit 51 and NG data.Then, data combining 52 will combine and attribute value data after rearranging and NG data send to data write section 53.For the content rearranging attribute value data, will be described hereinafter.

The attribute value data that receives from data combining 52 and the write of NG data are checked attribute value table in the inspection DB of DB recording unit 63 and NG table by data write section 53 respectively.Now, data write section 53 gives serial number to above-mentioned attribute value data, and this attribute value data is added attribute value table.In addition, the serial number that data write section 53 will be given for the above-mentioned attribute value table corresponding with above-mentioned NG data, is given to this NG data, and these NG data is added NG table.

Data providing unit 54, for according to external request, reads various data, and is supplied to outside from the inspection DB checking DB recording unit 63.Be specially, if Data extracting section 54 is via communication network 13 and network I/F portion 42, receive the request from PC14, then according to this request, from the inspection DB checking record DB recording unit 63, reading attributes Value Data and NG data.Then, the attribute value data of reading and NG data, via network I/F portion 42 and communication network 13, are supplied to this PC14 by data providing unit 54.For the object lesson utilizing attribute value data and NG data analysis, will be described hereinafter.

According to said structure, additional information extracting part 50 extracts the additional information relevant to checking file, this additional information is added the inspection data checked in file by data changing unit 51, and then this additional information is added in the attribute value table of the inspection DB checking DB recording unit 63.Therefore, not only comprising the inspection data checked in file in this attribute value table, also comprising the additional information relevant to checking file, thus, can under the prerequisite of not losing additional information, the data integration of the device of self-check in the future 3335 is in above-mentioned attribute value table.

If comprise character string in inspection data, then data changing unit 51 converts this character string to null value, and the inspection data after conversion add in the attribute value table of the inspection DB checking DB recording unit 63 by data write section 53.As a result, comprise the check the value as above-mentioned inspection data or null value in above-mentioned attribute value table, and do not comprise character string, therefore, it is possible to easily to above-mentioned inspection data analysis.

In addition, by data changing unit 51 and data write section 53, the null value after conversion is added in above-mentioned attribute value table, and corresponding with above-mentioned coal addition position, and above-mentioned character string is added in the NG table of the inspection DB checking DB recording unit 63.Thereby, it is possible to prevent the loss of character string informations such as slipping up as checked, inspection is abnormal.By referring to the character string corresponding with above-mentioned null value, such as, can judge that above-mentioned null value is which type of checks abnormal or checks error.

Data combining 52 according to the production line information from production line information recording part 62, by the inspection data of each workpiece 36 obtained from testing fixture 3335, by the order arrangement of regulation.Inspection data after arrangement add in above-mentioned attribute value table by data write section 53.So the data comprised in above-mentioned attribute value table, according to the order arrangement of regulation, thus can realize utilizing above-mentioned attribute value table to carry out data analysis accurately.

Below, be described with reference to the process action of Fig. 3 to the transacter 11 with said structure.Fig. 3 represents in transacter 11, to upgrading the treatment scheme checked DB from record check file.

As shown in Figure 3, when recording new inspection file in inspection file record portion 60 (S10), additional information extracting part 50, according to the extraction condition of record in extraction condition recording unit 61, extracts the additional information (S11) relevant to above-mentioned inspection file newly.Then, if the inspection data coming to comprise in the above-mentioned inspection file newly in self-check file record portion 60 are character string (S12), then this character string is changed to null value by data changing unit 51, and be made NG file, make arrangement position identical with these inspection data in this NG file comprises this character string (S13).

Then, data combining 52 is before this for the inspection file obtained from certain data changing unit 51 and additional information, this additional information is appended in the inspection data of each workpiece 36 comprised in this inspection file, and using add after inspection data as attribute value data.And for the inspection file obtained from other data changing units 51 and additional information, also repeat identical operation (S14).

Then, data combining 52 is according to the production line information in production line information recording part 62, to rearrange and in conjunction with the attribute value data of the workpiece 36 comprised in multiple inspection file, and, according to above-mentioned production line information, rearrange and combine the NG data (S15) of each workpiece 36 comprised in the NG file from data changing unit 51.

Then, each attribute value data after data write section 53 gives combination gives serial number, and this attribute value data is added in the attribute value table of the inspection DB checking DB recording unit 63, and, by the serial number given for the above-mentioned attribute value table corresponding with above-mentioned NG data, be given to this NG data, and these NG data added in the NG table of above-mentioned inspection DB (S16).Afterwards, return step S10, repeat above-mentioned action.

Below, with reference to Fig. 4 ~ Fig. 8, additional information is extracted to additional information extracting part 50 and is described in detail.In general, check that data manage with document form, be made inspection file by the different machines of the product in different customization (order), manufacture process, different (in shifts) on duty.Now, the additional information that customization name, machine name, in shifts name etc. is relevant to manufacturing line is included in filename as a part for filename.

But these additional informations are not sometimes included in data mode and check in file.Now, if only check DB by checking that the data comprised in file add, then can cause losing said additional information.For this reason, in the present embodiment, additional information adds in the inspection data of each workpiece 36 by data combining 52, thus this additional information is added in inspection DB.

In addition, in the process performing certain customization, another customization is inserted sometimes.Now, will the execution of certain customization above-mentioned be interrupted, then after being ready to perform another customization above-mentioned, perform another customization above-mentioned; And after this execution terminates, then after being ready to perform certain customization above-mentioned, recover the execution of certain customization above-mentioned.

At this moment, by the inspection file after the inspection file of the inspection file be made respectively before certain customization interruption above-mentioned, another customization above-mentioned and certain customization recovery above-mentioned.Therefore, the inspection file before being necessary to identify above-mentioned interruption and after above-mentioned recovery be above-mentioned certain customize the file of divided execution.Therefore, the son numbering of customization can be comprised in filename.

But, if only the inspection data of the inspection file before above-mentioned interruption and after above-mentioned recovery combined, distinguish very difficult the level checking data.Therefore, check that DB carries out in the process analyzed in utilization, even if check that the statistic of data is before above-mentioned interruption and different after above-mentioned recovery, be also difficult to determine that its reason is that the segmentation of customization performs.For this reason, in the present embodiment, the son of the customization comprised in above-mentioned filename numbering is added the inspection data of each workpiece 36 as said additional information.Thereby, it is possible to easily distinguish the level checking data.

Check in the filename of file such as there be the information that comprises: customization name (customization numbering), machine name, (1 class, 2 classes, 3 classes etc.) on duty, operator name, early stage operation production line numbering, customization numbering etc.In above-mentioned filename, the part or all of of above-mentioned information combines with separator (separator).Testing fixture is different, and the information comprised in above-mentioned filename is also different.In addition, each information often represents with the numbering that can identify.

From above-mentioned various information, for each testing fixture determines the additional information for analyzing, and setting is for extracting the extraction condition of the additional information of decision, and this extraction condition is previously recorded in extraction condition recording unit 61.Fig. 4 represents an example of above-mentioned extraction condition.As shown in the figure, above-mentioned extraction condition is with XML(ExtensibleMarkupLanguage; Extend markup language) structured document such as file describes.

As shown in Figure 4, above-mentioned extraction condition can be set respectively for testing fixture 3335.In the example in the figures, with regard to testing fixture 33(inspection machine 1) with regard to, the operation production line 20 in early stage as the additional information checking data should be added to is comprised in extraction condition, but with regard to testing fixture 35(inspection machine 2) with regard to, in extraction condition, do not comprise the operation production line 20 in early stage as said additional information.

Below the reason that early stage, operation production line was numbered as said additional information is described.On the parts manufacturing line 20 of the production system 1 shown in Fig. 2,2 production lines 2223 all manufacture the parts 24 of same kind.But, the parts 24 manufactured on different production line 2223 respectively can because of differences such as mould, extruding, shaping environment, and the difference produced in some characteristics, and just because of this difference, may cause production line 2223 one of them manufactured by parts 24 mostly be substandard products.

Therefore, when the parts manufactured mostly are substandard products, need to judge that the parts used are which the production line manufactures in production line 2223.As can be seen here, being numbered of the production line 2223 in parts manufacturing line 20 needs to be attached to the additional information in the inspection data collected by assembly line 21.In addition, if the parts 24 that manufacture of parts manufacturing line 20 without, or change new parts 24 in the fabrication process into, then the characteristic of parts 24 also may produce difference, is now preferably made new inspection file.

The characteristic of the goods that assembly line 21 manufactures also can change with the adjustment result of the operator of assembly line 21.Therefore, the information of operator also should belong to said additional information.

Fig. 5 illustrates the example of the filename checking file with tabular form.Inspection file shown in (a) of Fig. 5 is testing fixture 33(inspection machine 1) the inspection file of making, the inspection file shown in (b) of Fig. 5 is testing fixture 35(inspection machine 2) the inspection file of making.In the example in the figures, according to the order of making, describe the filename of multiple inspection files of testing fixture 3335 respectively.

As shown in Figure 5, at testing fixture 33(inspection machine 1) in the filename of inspection file of making, be arranged in sequence be connected with separator " _ " customization numbering, machine name, on duty, operator name, early stage operation production line numbering and the son numbering of customization numbering.In addition, at testing fixture 35(inspection machine 2) in the filename of inspection file of making, compared with the above-mentioned filename relating to inspection machine 1, eliminate operation production line numbering in early stage.

In the example of fig. 5, in the process performing customization " M1121397 ", owing to inserting another customization " M1121398 ", the inspection file of customization " M1121397 " is divided into 2, addition of son numbering respectively in its filename.In addition, person on duty has changed 1 class into by 2 classes, and operator has also changed " SUZUKI " into by " TANAKA ".

Fig. 6 represents that additional information extracting part 50 carries out the flow process that additional information extracts process (S11).As shown in the figure, first, from extraction condition recording unit 61, read the extraction condition (S20) shown in Fig. 4.

Then, according to above-mentioned extraction condition, from the filename checking the inspection file recorded file record portion 60, extract additional information (S21).Be specially, character " _ " segmentation of filename contained by " separator " label in above-mentioned extraction condition of above-mentioned inspection file.Such as, filename " M1121397_A001_2_TANAKA_S1_1.txt " is divided into character string " M1121397 ", " A001 ", " 2 ", " TANAKA ", " S1 ", " 1 ".Extension name (txt) contained in filename is not the information relevant to checking data, thus can ignore.

Then, according to above-mentioned extraction condition, by the additional information corresponding with entry name (S22) extracted.Be specially, the character string of segmentation is corresponding with the entry name that " entry name order " label in above-mentioned extraction condition comprises.(a) of Fig. 7 represents the formation entry name of corresponding relation and the example of character string in the form of a table.In the example in the figures, character string " M1121397 " is numbered corresponding with customization, character string " A001 " is corresponding with machine name, character string " 2 " is corresponding with on duty, character string " TANAKA " is corresponding with operator name, character string " S1 " is corresponding with operation production line name in early stage, and character string " 1 " is numbered corresponding with customization.

Then, according to above-mentioned extraction condition, part or all of additional information is converted to code (S23).Be specially, with reference to " operator " label in above-mentioned extraction condition, aforesaid operations person's name converted to operator ID(and identify) code.(b) of Fig. 7 represents the example of the above-mentioned entry name after changing and character string in the form of a table.In the example in the figures, operator name " TANAKA " is converted into ID code " 0002 ".

Thereby, it is possible to the quantity of information of reduction additional information, thus the size of reduced inspection DB.In addition, compared with character string, computing machine more easily processes code, therefore, it is possible to perform the retrieval process to checking DB rapidly.In addition, except operator name, also preferred by early stage operation production line name, implementor name, other character strings such as machine name convert cognizance code to.

In addition, the information relevant with operator of also can sening as an envoy to separately and above-mentioned ID code form operator's table of corresponding relation.Fig. 8 represents the example that aforesaid operations person shows in the form of a table.By utilizing aforesaid operations person to show, DB can be checked according to the above-mentioned information retrieval relevant with operator, the ID code of result for retrieval can also be converted to the information relevant with operator and exporting.The employee DB of the company that also can work by referring to this operator obtains the information relevant with operator.

Then, will the additional information after conversion be comprised and send to data changing unit (S24) corresponding to the information of the entry name of this additional information.That is, the information shown in (b) of Fig. 7 is sent to data changing unit 51.By sending entry name, the entry name of this additional information can be added above-mentioned attribute value table.Thus, the user of PC14 easily can grasp the project of additional additional information by above-mentioned entry name.Then, terminate the extraction process of additional information, return original flow process.

Below, with reference to Fig. 9 ~ Figure 15, the arrangement of data is carried out to data combining 52 and rearrangement is described in detail.First, the importance of the rearrangement carrying out data is described.

When utilizing inspection DB to carry out data analysis, check that the order of the data in DB needs consistent with the ordering in launching of workpiece 36.This is because, if the order of above-mentioned data is inconsistent with the ordering in launching of workpiece 36, then when carrying out cycle analysis or comparing the result of each equipment, just can not carry out correct analysis.

On the other hand, on the manufacturing line of reality, in order to match with the processing time of each operation, process slower equipment (such as testing fixture) the multiple workpiece 36 of parallel processing sometimes.Now, the order, inconsistent sometimes with the checks sequence of workpiece 36 of workpiece 36 is dropped into production line 30.Therefore, need the order of the inspection data rearranging workpiece 36, match to make the ordering in launching of itself and workpiece 36.

Such as, if: the process velocity of processing unit (plant) is 1 second/1, and the inspection speed of testing fixture is 3 seconds/1, then in order to make the processing time of manufacturing procedure and check that the processing time of operation matches, need or 3 testing fixtures are set in inspection operation, or 3 inspection portions are set in 1 testing fixture.

Fig. 9 represents that testing fixture 33 walks abreast the example of inspection 3 workpiece 36.As shown in the figure, in testing fixture 33, from downstream side to upstream side, be provided with 1CH(channel respectively) inspection portion 330 of ~ 3CH.In addition, production line 30 is also provided with arm 37 and inspecting stand 38.

Arm 37 is placed on inspecting stand 38 for the workpiece 36 processed by processing unit (plant) 32.3 workpiece 36 are placed on inspecting stand 38 by arm 37.The inspection portion 330 of 1CH, 2CH and 3CH checks the workpiece 36 in right side on inspecting stand 38 in 3 workpiece 36, central authorities and left side respectively.

The workpiece numbering that the inspection portion 330 of 1CH ~ 3CH that (a) ~ (c) of Figure 10 represents in the testing fixture 33 shown in Fig. 9 respectively in the form of a table checks and check the moment.In the example in the figures, the time that each inspection portion 330 is required on checking is 3 ± 1 seconds.

Figure 11 represents numbering, the inspection CH of the workpiece 36 shown in (a) ~ (c) of the Figure 10 after arrangement in the form of a table and checks the moment.Wherein, (a) of Figure 11 is the table by checking after moment arrangement.(a) of this figure does not press number order (ordering in launching) arrangement of workpiece 36.

On the other hand, the table shown in (b) of Figure 11 arranges in the following manner, that is, for Figure 10 (a) ~ (c) shown in workpiece numbering and check the moment, according to checking that the order of CH selects the time the earliest respectively one by one, and repeat this operation.(b) of this figure arranges according to the number order of workpiece 36.

In addition, sometimes workpiece 36 is changed on fixture or this fixture is rotated, and the order of workpiece 36 can change.Figure 12 represents after being checked by testing fixture 33, and overturn (180 degree of rotations) before and after inspecting stand 38, then, testing fixture 35 checks the example of workpiece 36.Figure 13 represents the workpiece numbering that the testing fixture 35 shown in Figure 12 checks in the form of a table and checks the moment.In the example in the figures, the time that testing fixture 35 is required on checking is 1 ± 0.5 second.Figure 13 does not press the number order arrangement of workpiece 36.Now, need consider above-mentioned upset and rearrange.

For this reason, in the present embodiment, production line information required when the inspection data of the workpiece 36 such as the arrangement of each equipment on production line 30, channel content are rearranged according to the ordering in launching of workpiece 36 that production line information recording part 62 is pre-recorded.Figure 14 represents an example of above-mentioned production line information.As shown in the figure, above-mentioned production line information can describe with the form of the structured documents such as XML file.

Figure 15 represents that data combining 52 carries out the flow process that data combine process.As shown in the figure, first, from production line information recording part 62, read the production line information (S40) shown in Figure 14, and judge whether there is channel tag (S41) in the production line information read.

If there is no channel tag, then according to checking that the order in moment arranges the data (S42) of workpiece 36.On the other hand, if there is channel tag, then according to the data (S43) of the content arrangement workpiece 36 of this channel tag.Such as, in production line information as shown in figure 14, the content of the arrangement label of the channel tag of inspection machine 1 label is " 1CH, 2CH, 3CH ".Therefore, carry out selecting and arranging according to the order of the data ((c) of Figure 10) of the data ((a) of Figure 10) of the inspection file of 1CH, the data ((b) of Figure 10) of the inspection file of 2CH, the inspection file of 3CH, by repeating this operation, the data ((b) of Figure 11) arranged by the ordering in launching of workpiece can be obtained.

Then, judge whether there is upset label (S44) in above-mentioned production line information, if there is this upset label, then according to above-mentioned upset label, the data of arrangement are rearranged (S45).Then, end data combines process, returns original flow process.Such as, in the production line information shown in Figure 14, the workpiece number in the upset label of inspection machine 2 label is 3.Therefore, for the data (Figure 13) of the inspection file of inspection machine 2, by the turn in sequence (reverse) of the data by 3 workpiece, and repeat this operation, can according to workpiece ordering in launching array data.

Below, with reference to Figure 16 and Figure 17, data conversion data be recorded in when checking in DB recording unit 63 is described.Figure 16 represents an example of the content checking file in the form of a table, and this inspection file testing fixture 35 is as shown in Figure 12 made, and is obtained by transacter 11.(a) (b) of Figure 17 represents the example of the content of attribute value table and the NG table checking record in DB recording unit 63 respectively in the form of a table.In Figure 16 and Figure 17, the project of each row is respectively workpiece numbering (work ID), checks sequence, measure the item 1 ~ 6, check result, measurement moment and channel number from left to right.

Attribute value table is used for stored attribute values.As shown in (a) of Figure 17, the data be stored in attribute value table are numeric data.Therefore, by utilizing the attribute value table checking record in DB recording unit 63, PC14 can carry out data analysis.Such as, read the data of above-mentioned attribute value table every 1 hour, by calculating mean value, the discrete value of each channel, can the passing of research property value, or calculate the code number comprising null value, thus calculate yield rate, thereby, it is possible to the state of investigation inspection machine.In attribute value table, the number category (integer, natural number, single precision, double precision etc.) of projects is identical with the number category of the respective item in the inspection file shown in Figure 16.

On the other hand, NG table checks error for storing and checks abnormal character string.As shown in (b) of Figure 17, in the data that NG table stores, only work ID is numeric data, and other are string data.

In the present embodiment, check if check in file to comprise character strings such as slipping up, inspection is abnormal, then this character string is converted to null value, then be stored in attribute value table.Such as, in the inspection file shown in Figure 16, the 3rd row the 3rd arranges, the 17th row the 6th arranges the ~ the 17 row the 8th and arranges and comprise character string in the 18th row the 4th row.Correspondingly, in the attribute value table shown in (a) of Figure 17, this character string is converted into null value.

But, when storing null value in attribute value table, although can understand owing to checking error, check that certain reason such as abnormal causes measuring, can not understand and cause immeasurable concrete reason, thus, causing losing important analytical information.

For this reason, in the present embodiment, not only this character string is added the respective item in NG table, also added work ID.Such as, in the NG table shown in (b) of Figure 17, added: the 1st row store the record of work ID=3 and the 3rd row storing character string " LO ".In addition, also added: the 1st row store the record of work ID=17 and the 6th row the ~ the 8 row storing character string " N/A ", and the 1st row store the record of work ID=18 and the 4th row storing character string " HI ".

Thus, by utilizing NG to show, PC14 just can analyze inspection error, inspection exception etc.Such as, utilize above-mentioned NG to show, in during computational rules, represent the character string number checking error, can check-up through statistical means error.And represent statistics by table and coordinate diagram, the tendency (increase, minimizing etc.) checking error can be confirmed thus, thus confirm the state of equipment.In the present embodiment, owing to being made above-mentioned NG table, above-mentioned statistics and above-mentioned confirmation can thus have been realized.

In addition, read the value of each measure the item of above-mentioned attribute value table by different customizations, and represent with column diagram, thereby, it is possible to determine the abnormal place produced from the shape of this column diagram.In the present embodiment, in above-mentioned attribute value table, store the additional informations such as customized information, therefore, it is possible to add up in units of said additional information.

Recording unit 41 also has permissible range recording unit, and this permissible range recording unit checks the permissible range (upper and lower bound) of data for storing.And then if check that the inspection data of the inspection file in file record portion 60 are in outside above-mentioned permissible range, then data changing unit 51 also can will represent that abnormal character string adds NG file.Now, corresponding with the position that above-mentioned inspection data add above-mentioned attribute value table, the character string of above-mentioned expression exception is added NG table.Thus, by referring to NG table, just to inspection error and abnormal analysis can be checked.In addition, even if check that data are in outside permissible range, also above-mentioned attribute value table can be added into, therefore, it is possible to prevent information dropout.

Below, with reference to Figure 18, process is inserted to data during data defect and is described in detail.For testing fixture 3335, when there is no workpiece (hereinafter referred to as " during without workpiece "), likely do not make data.Now, the periodicity of the attribute value data of adding up according to attribute value table has deviation, is difficult to carry out data analysis.

When not existing without workpiece, as shown in (a) of Figure 11, according to the order array data checking moment (measuring the moment).On the other hand, the generation after Figure 18 represents arrangement is in the form of a table without workpiece numbering, inspection channel during workpiece and check the moment.Now, the information defined without workpiece > label by the < inspection machine 1>< shown in Figure 14, can be recognized and not export data.Therefore, at synchronization, the position that there are not data in 1CH ~ 3CH is the position produced without workpiece.

Situation shown in Figure 18 is, at inspection moment " 9:00:09 ", the data of 2CH do not exist, and therefore, can recognize that workpiece 8 produces the situation without workpiece.But, check how many moment can produce some errors, now, can with reference to the information set by the < supervision time >< error > label shown in Figure 14, by judge check moment ± error scope in 1CH ~ 3CH whether all there are data, judge whether the situation producing countless certificate.

Thus, when there is not (entirely not existing) in the data measured at synchronization, be judged as because causing not making data without workpiece, in the example of above-mentioned workpiece 36(at Figure 18, for workpiece 412) inspection data between, insert the data indicated without workpiece, then the order of the data of each workpiece 36 by regulation is arranged.Thereby, it is possible to prevent the periodicity generation deviation of attribute value data.

As shown in Figure 9, with regard to testing fixture 33(inspection machine 1) with regard to, when checking beginning, 330 pairs, the inspection portion workpiece 3 of 3CH checks, and the inspection portion 330 of 1CH2CH does not exist workpiece.Therefore, as shown in figure 18, checking the inspection moment " 9:00:00 " when starting, there are the data of 3CH, but there are not the data of 1CH2CH.Now, at inspection moment " 9:00:00 ", the data indicated without workpiece can be inserted, as the data of 1CH2CH.

Then, upper once check time, 330 pairs, the inspection portion workpiece 6 of 3CH checks, 330 pairs, the inspection portion workpiece 2 of 2CH checks, and the inspection portion 330 of 1CH does not exist workpiece.Therefore, as shown in figure 18, upper once check time the inspection moment " 9:00:03 ", there are the data of 2CH3CH, but there are not the data of 1CH.Now, at inspection moment " 9:00:03 ", the data indicated without workpiece can be inserted, as the data of 1CH.

Below, with reference to Figure 19, the amendment process in moment is described in detail.In the process of carrying out the production line shown in Figure 12, if workpiece occur in sequence change, then the ordering in launching of the order and workpiece of measuring the moment all will be upset.Now, if rearrange data according to the ordering in launching of workpiece, then the order measuring the moment will be upset.Therefore, the measured value (measured value of the inspection machine 2 of Figure 12) after the measured value (measured value of the inspection machine 1 of Figure 12) before the change of workpiece order and workpiece order change cannot form corresponding relation.Therefore, need amendment to measure the moment, arrange all in order to make the ordering in launching of workpiece and to measure the order in moment.

In fact, when the < inspection machine 2>< shown in Figure 14 overturns > label for " having ", in order to make data arrange by the ordering in launching of workpiece, as long as with the value (3) set by the < inspection machine 2>< upset > label shown in Figure 14 for unit overturns.

Figure 19 represents the workpiece numbering that the inspection machine 2 after arrangement checks in the form of a table and checks the moment.(a) of Figure 19 is actual data.If these data rearranged in units of 3, then as shown in (b) of Figure 19, the ordering in launching arrangement of workpiece will be pressed.Then, in order to the ordering in launching of the order with workpiece that make the inspection moment is consistent, change in units of 3 and check the moment.As a result, as shown in (c) of Figure 19, the measurement moment of these data presses the ordering in launching arrangement of workpiece.

With regard to inspection machine 1, if the ordering in launching of data according to workpiece is arranged, then as shown in (b) of Figure 11.As shown in Figure 9, with regard to inspection machine 1, in 3 workpiece that inspecting stand 38 is placed, one is checked by the inspection portion 330 of 3CH, and another is checked by the inspection portion 330 of 2CH, and remaining 1 is checked by the inspection portion 330 of 1CH, then terminates the inspection of inspection machine 1.

Therefore, if make on inspecting stand 38 place 3 workpiece the inspection moment unanimously, in particularly preferably last with the inspection machine 1 inspection moment, namely the inspection moment of 1CH is consistent.(c) of Figure 11, for the data shown in Figure 11 (b), makes the inspection moment of continuous print 1CH ~ 3CH consistent with the inspection moment of 1CH, and repeats aforesaid operations and obtain.Thus, the data of (c) of Figure 11 are the data arranged by the ordering in launching of workpiece in the measurement moment.

As mentioned above, data combining 52 is after arranging the inspection data of each workpiece 36 according to the order of regulation, rearranged by the order of morning to evening according to the measurement moment of each workpiece 36, thus, in attribute value table, the measurement moment also can arrange in order, thus can easily according to measuring the moment to data analysis.

According to above-mentioned process, the attribute value table shown in (a) of Figure 17 is recorded in and checks in DB recording unit 63.In this attribute value table, data arrange according to the ordering in launching of workpiece, and the data recorded are that the position of exceptional value stores null value, and the measurement moment arranges according to the ordering in launching of workpiece.The data of workpiece numbering 23 are the data without workpiece, and except workpiece numbering, measure except moment and channel number, sundry item all saves as null value.By the way measurement data is modified, data analysis can be realized more accurately.

The present invention is not limited to above-mentioned embodiment, can carry out various change in the scope shown in claim.That is, by being combined in the technical scheme suitably changed in the scope shown in claim, the embodiment obtained is also included in the technical scope of the present invention.

Such as, in the present embodiment, the inspection data of collecting from testing fixture 3335 are illustrated, but the present invention goes for collecting the data from various equipment set on manufacturing line, as collect from measurement mechanism measurement data, collect setting data etc. from processing unit (plant) 3234.

Finally, each functional block of transacter 11, particularly control part 40, can be made up of hardware logic, also can be as described below, uses CPU, realized by software.

That is, transacter 11 has: the CPU(centralprocessingunit performing the order of the control program for realizing each function: central processing unit); Store the ROM(readonlymemory of said procedure: ROM (read-only memory)); Launch the RAM(randomaccessmemory of said procedure: random access memory); Store the memory storages (recording medium) such as the storer of said procedure and various data.In addition, recording medium is provided to transacter 11, this recording medium can be read by computing machine and record the program code (executable program, intermediate code program, source program) of the control program of transacter 11, described control program is the software for realizing the above function, by being read by the computing machine (or CPU, MPU) of described transacter 11 and performed the program code recorded in recording medium, also object of the present invention can be realized.

About aforementioned recording medium, such as, it can be the band such as tape, cartridge tape class; Also can be the dish class comprising the CDs such as disk and CD-ROM, MO, MD, DVD, CD-R such as floppy disk (registered trademark), hard disk; Also can be the card classes such as IC-card (comprising storage card), light-card; Or the semiconductor memory class etc. such as mask-type ROM, EPROM, EEPROM, flash rom.

In addition, transacter 11 also can connect communication network, and said procedure code also can provide by means of communication network.About above-mentioned communication network, not special restriction, such as, internet (internet), Intranet (intranet), extranet (extranet), LAN, ISDN, VAN, CATV communication network, VPN (virtual private network) (virtualprivatenetwork), phone loop line network, mobile communications network, satellite communication network etc. can be utilized.In addition, about the transmission medium in order to form communication network, not special restriction, such as, the wire communication such as IEEE1394, USB, line of electric force, cable television loop line, telephone wire, ADSL loop line can be utilized, also can utilize the such as infrared ray such as IrDA or telepilot, Bluetooth(registered trademark), the radio communication such as 802.11 radio communications, HDR, mobile telephone network, satellite loop line, received terrestrial digital broadcasting network (terrestrialdigitalnet).In addition, even achieved the computer data signal being placed in carrier wave of said procedure code by electric transmission, also the present invention can be realized.

As mentioned above, in order to solve the problem, transacter of the present invention collects the data from each equipment on manufacturing line, and the data of collection are added database, the feature of this transacter is: have: acquiring unit, obtains the measurement data from described equipment; Add unit, when comprising character string in the measurement data that described acquiring unit obtains, this character string being converted to and can carry out processing as numerical string and be different from the value of measured value, and described measurement data is added described database.

In transacter of the present invention, as preferably, described character string also adding on corresponding position, the position of described database to the value after conversion, adds in string table by described additional unit.

Now, adding on corresponding position, the position of described database to the null value after conversion, described character string is added in string table.Measure error thereby, it is possible to prevent loss, measure the character string informations such as abnormal.Further, by referring to the character string corresponding with described null value, such as, can judge that the measurement of described null value why sample is abnormal or measure error.

In transacter of the present invention, also can have permissible range recording unit further, the permissible range of measurement data described in this permissible range recording unit record; When the measurement data that described acquiring unit obtains is not included in the permissible range in described permissible range recording unit, described additional unit and then adding on corresponding position, the position of described database to described measurement data, will represent that abnormal character string adds in string table.Now, by referring to string table, to measurement error and abnormal analysis can be measured.Further, even if measurement data is in outside permissible range, also described database can be added into, therefore, it is possible to prevent information dropout.

But some equipment does not generate data when there is not objective workpiece.Now, the periodicity of data can produce deviation, causes being difficult to carry out data analysis.

For this reason, in transacter of the present invention, as preferably, in the data of described each workpiece, comprise the measurement moment of these data; Corresponding relation between during also comprising the measurement of described equipment and this equipment in described production line information, wherein, for described equipment carries out measuring the time needed during described measurement; Described arrangement units is according to the production line information from described production line information recording part, if during the difference in the measurement moment of the data between adjacent described workpiece is greater than the measurement corresponding with described equipment, between data then between described workpiece, insertion shows the non-existent data of objective workpiece, and then arranges the data of described each workpiece according to the order of regulation.

If during the difference in described measurement moment is greater than described measurement, then can think that objective workpiece does not exist.At this, between the data between described workpiece, insert and show that objective workpiece is non-existent without workpiece data, can prevent the periodicity of data from producing deviation.

In addition, described without preferably comprising the workpiece identification information identifying workpiece in workpiece data, and preferentially comprise and measure the moment, this measurement moment is the moment between the measurement moment in the data between one of measurement moment in the data between described adjacent workpieces or described adjacent workpieces.Described can be null value without other values in workpiece data.

In transacter of the present invention, in the data of described each workpiece, comprise the measurement moment of these data; Described arrangement units, after the order according to regulation is arranged the data of described each workpiece, also can change the measurement moment of described each workpiece, makes the measurement moment of described each workpiece according to the order arrangement of regulation.Like this, the measurement moment also arranges in order, thus easily can carry out data analysis according to the measurement moment.The order relating to the regulation in described measurement moment is such as that workpiece drops into the order etc. of manufacturing line.

In transacter of the present invention, as preferably, in described filename, comprise the multiple described additional information combined with separator; This transacter also has: extraction condition recording unit, records the extraction condition for extracting described additional information; Described extraction condition comprises the information of described separator and the corresponding relation between the order of described additional information and entry name; Described extracting unit, according to the extraction condition from described extraction condition recording unit, extracts described additional information from described filename, and makes described entry name corresponding with the additional information of extraction; The entry name forming corresponding relation with described additional information is also added described database by described additional unit.Now, the user of described database easily can grasp the project of the additional information added by described entry name.

(utilizing possibility in industry)

Transacter of the present invention can not drop-out ground or order well integration from the data of each equipment on manufacturing line, therefore, be not only applicable to the Data Collection from the inspection data of testing fixture and data analysis, the Data Collection from the arbitrary equipment such as measurement mechanism, processing unit (plant) and data analysis can also be applicable to.

[description of reference numerals]

1 production system

10 production scenes

11 transacters

13 communication networks

14PC

20 early stage operation production line parts manufacturing line

21 machining production line assembly lines

2223 production lines

24 parts

30 production lines

31 parts generators

3234 processing unit (plant)s

3335 testing fixtures

36 workpiece

37 arms

38 inspecting stands

40 control parts

41 recording units

42 network I/F portions

50 additional information extracting part (extracting unit)

51 data changing units (adding unit)

52 data combining (adding unit, arrangement units)

53 data write sections (adding unit)

54 data providing unit

60 check file record portion (acquiring unit)

61 extraction condition recording units

62 production line information recording parts

63 check DB recording unit

330 inspection portions

Claims

1. a transacter, collects the data from each equipment on manufacturing line, and the data of collection are added database, and the feature of this transacter is:

Have:

Acquiring unit, obtains the measurement data from described equipment;

Add unit, when comprising nonnumeric character string in the measurement data that described acquiring unit obtains, this character string being altered to and can carrying out processing as numerical string and be different from the value of measured value, and described measurement data is added described database.

2. transacter according to claim 1, is characterized in that:

Described additional unit also to change after value add on corresponding position, the position of described database, described character string is added in string table.

3. transacter according to claim 1 and 2, is characterized in that:

There is permissible range recording unit further, the permissible range of measurement data described in this permissible range recording unit record;

When the measurement data that described acquiring unit obtains is not included in the permissible range in described permissible range recording unit, described additional unit and then adding on corresponding position, the position of described database to described measurement data, will represent that abnormal character string adds in string table.

4. a control method for transacter, this transacter collects the data from each equipment on manufacturing line, and the data of collection are added database, and the feature of the control method of this transacter is:

Comprise:

Obtaining step, obtains the measurement data from described equipment;

Add step, when comprising nonnumeric character string in the measurement data obtained through described obtaining step, this character string being altered to and can carrying out processing as numerical string and be different from the value of measured value, and described measurement data is added described database.