JP2003140984A - Method and device for data conversion, and method and device for production information management - Google Patents

Abstract

PROBLEM TO BE SOLVED: To perform the management of production data for production equipment by converting any type of production data outputted from the production equipment in a production line to a common data type. SOLUTION: This data conversion device 30 converts the production data (CSV data) outputted from various types of production equipment 2 to 6 into standard data of XML type, and transmitting and receiving the data of XML type to and from a server 19 by using an HTTP.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data conversion method and apparatus for converting, for example, arbitrary format data output from a plurality of manufacturing devices into a common data format, and a product manufactured by using these methods and apparatus. The present invention relates to a manufacturing information management method and apparatus for managing manufacturing data of a production system.

[0002]

2. Description of the Related Art A plurality of manufacturing equipments are provided on a product manufacturing line. These manufacturing devices are, for example, a printing machine, a visual inspection machine, a chip mounter, a reflow device, a terminal device (abbreviated as a visual inspection device) for inputting a visual inspection result via a PC in a printed circuit board production line.

Each of these manufacturing equipment has manufacturing data. For example, in the case of a chip mounter, it is manufacturing data such as data on a chip component mounted on a substrate and error contents (for example, suction error) when an error occurs.

Further, in the production line, the equipment manufactured by different companies is mixed for each manufacturing equipment.

[0005]

However, each data output from each manufacturing device manufactured by each company is communicated in a dedicated data format unique to the manufacturing device and by a dedicated data protocol. There is.

Therefore, even if the manufacturing data of each manufacturing device is stored in the database and the manufacturing information is managed, it is difficult to perform data communication between the manufacturing devices of each company using a common interface. .

The manufacturing equipment has a Web server function,
HTML (Hyper Text Mar) is a language developed for the purpose of displaying necessary data on the screen for easy viewing.
kupLanguage) format, which is transmitted by the HTTP protocol. However, the HTML format is insufficient for handling data output from manufacturing equipment such as the above-mentioned printing machine, appearance inspection machine, chip mounter, reflow device, and visual inspection device.

[0008] Therefore, an object of the present invention is to provide a data conversion method and an apparatus therefor capable of converting the manufacturing data in a unique (arbitrary) format outputted from each manufacturing equipment into a common data format.

Further, the present invention is a manufacturing information management method capable of managing the manufacturing data of each manufacturing device by converting the manufacturing data of the unique (arbitrary) format output from each manufacturing device of the manufacturing line into a common data format. And its device.

[0010]

SUMMARY OF THE INVENTION The present invention comprises the steps of receiving data of arbitrary format output from various devices and converting these data into standard XML format data.
And a step of transmitting and receiving the converted XML format data according to the HTTP protocol.

According to the present invention, a step of receiving data of an arbitrary format output from various devices and calculating format conversion data for converting this data into standard XML format data, and the determined format. A step of converting arbitrary format data into XML format data by using the conversion data, and HT converting the converted XML format data.
And a step of transmitting and receiving by a TP protocol.

According to the data conversion method of the present invention, the correspondence between the identification data of various devices and the format conversion data is registered in advance, and the format conversion data is calculated from the identification data included in the unique format data. It is characterized by

According to the present invention, conversion means for receiving data of arbitrary format output from various devices and converting the data into standard XML format data, and the converted XML.
A data conversion device, comprising: a transmission / reception means for transmitting / receiving L format data by HTTP protocol.

According to the present invention, format indexing means for receiving data of arbitrary format output from various devices and indexing format conversion data for converting this data into standard XML format data, and this indexing means. And a data transmitting / receiving unit for transmitting / receiving the converted XML format data to / from the XML format by using the HTTP protocol. Data conversion device.

According to the present invention, in the above-mentioned data conversion apparatus of the present invention, the format indexing means pre-registers the correspondence between the identification data of various devices and the format conversion data, and the identification data included in the data of the arbitrary format is registered. The feature is that the data for format conversion is determined.

The present invention provides a manufacturing information management method for storing manufacturing data of a plurality of manufacturing devices in a manufacturing system in which a work is supplied to a plurality of manufacturing devices to manufacture a product, and managing the manufacturing data. The manufacturing information management method is characterized by receiving manufacturing data in an arbitrary format to be output, converting the manufacturing data into standard XML format data, and transmitting / receiving the XML format data by the HTTP protocol.

The present invention is a manufacturing information management method for managing manufacturing data of a plurality of manufacturing devices in a production system for manufacturing a product by distributing a work to a plurality of manufacturing devices, and manufacturing data of an arbitrary format output from the manufacturing devices. And a step of calculating format conversion data for converting the manufacturing data into standard XML format manufacturing data, and converting the manufacturing data into XML format manufacturing data using the calculated format conversion data. The step of converting,
And a step of transmitting and receiving the converted XML-format manufacturing data according to the HTTP protocol.

According to the manufacturing information management method of the present invention, the correspondence between the identification data of the manufacturing equipment and the format conversion data is registered in advance, and the conversion data is converted from the identification data included in the manufacturing data of any format. Is characterized in that.

The present invention is a manufacturing information management apparatus for managing manufacturing data of a plurality of manufacturing devices in a manufacturing system for arranging a plurality of manufacturing devices to manufacture products, and manufacturing data of any format output from various manufacturing devices. Received
The manufacturing information management apparatus is provided with a data conversion means for converting the manufacturing data into standard XML format data and a transmitting / receiving means for transmitting / receiving the XML format data by the HTTP protocol.

According to the present invention, in a manufacturing information management apparatus for managing the manufacturing data of a plurality of manufacturing equipment in a manufacturing system for arranging a plurality of manufacturing equipment to manufacture a product, the manufacturing data of an arbitrary format output from the manufacturing equipment is stored. A format indexing means for receiving the format data and converting the format data into standard XML format format data and indexing the format data using the index format conversion data. Data conversion means for converting the data and the converted manufacturing data in the XML format in the HTT
The manufacturing information management apparatus is provided with a transmitting / receiving means for transmitting and receiving according to the P protocol.

According to the present invention, in the above manufacturing information management apparatus of the present invention, the format indexing means is identification data storage means in which the correspondence between the identification data of the manufacturing equipment and the format conversion data is registered in advance, and the data of any format. And an indexing means for reading out the format conversion data corresponding to the identification data from the identification data storage means.

[0022]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is an overall configuration diagram of a manufacturing information management device used in a printed circuit board manufacturing line. The printed circuit board manufacturing line 1 is provided with, for example, a printing machine 2, a visual inspection machine 3, a chip mounter 4, a variant mounter 5, and a reflow device 6 as a plurality of manufacturing equipment.

These manufacturing equipments 2 to 6 are provided in a mixture of those manufactured by different companies.
Each of the manufacturing data output from 6 to 6 has a dedicated data format unique to the manufacturing equipment. For example, these manufacturing devices 2 to 6 have a unique CSV (Comma Se
parated values) TCP / IP data on LAN 13
(Transmission Control Protocol / Internet Protoc
ol) has the function of transmitting in the socket method. Each of the manufacturing equipments 2 to 6 has a function of transmitting manufacturing data in a plurality of data formats, and the function of transmitting CSV data among them is selected in advance.

Each of these manufacturing equipments 2 to 6 has an IP address.
(Internet Protocol Address) An address is determined. Therefore, each manufacturing data output from each manufacturing device 2 to 6 includes an IP address for identifying its own manufacturing device.

Next to these manufacturing devices 2 to 6, a visual inspection step 7, a correction step 8, a post step 9 and the like are provided.
Of these, in the visual inspection step 7, a defect phenomenon input personal computer (hereinafter referred to as PC) 10 is provided. The correction process 8 is provided with a defect cause input PC 11. PC for serial number input in back process 9
12 are provided.

The manufacturing devices 2 to 6, the defect phenomenon input PC 10, the defect cause input PC 11, and the serial number input PC 12 are connected to each other via a manufacturing local area network (hereinafter referred to as LAN) 13, Moreover, it is connected to the backbone LAN 15 via the router 14.

The trunk LAN 15 is connected to a management room LAN 17 via a router 16.

The management room 18 includes a server 19 and a management PC.
20, a master maintenance PC 21, a bar code printing PC 22, and a bar code printer 23 are provided, and these are connected to each other via a LAN 17. In addition,
The server 19 is provided with a manufacturing information database 24.

A data converter (also referred to as a relay device) 30 shown in FIG. 2 is connected to each of the manufacturing equipments 2 to 6 in the manufacturing line 1. These data conversion devices 30 may be connected to the outside of the respective manufacturing equipments 2 to 6, or may be incorporated in the respective manufacturing equipments 2 to 6.

The data conversion device 30 receives the manufacturing data (CSV data) in a unique (arbitrary) format output from various manufacturing equipments 2 to 6, and converts the manufacturing data into a standard XML (eXtensible Markup Language) format. It is converted to data and this XML format data is converted into HTTP (Hype
r Text Transfer Protocol) for example LAN
Server 1 from 13 through backbone LAN 15 and LAN 17
9 has a function of transmitting and receiving. In addition, XML is
It is a data description language that can convey the meaning of data as a WWW (World Wide Web) term.

Specifically, in the data conversion device 30, the format determination unit 32, the data conversion unit 33, and the transmission / reception unit 34 are operated by the command issued from the main control unit 31.

The format determining section 32 receives the manufacturing data (CSV data) output from each of the manufacturing equipments 2 to 6 and determines the format of these manufacturing data. The format determining section 32 includes an identification data memory 35 and a style sheet designating section 36. have.

As shown in FIG. 3, the identification data memory 35 has a plurality of format conversions for converting the IP address and the manufacturing data (CSV data) output from each manufacturing device 2-6 into XML format data. Data (hereinafter referred to as a style sheet) is stored correspondingly.

These style sheets are stored in the server 1
Stored in the database 24 of each manufacturing equipment 2
The data conversion device 30 causes the server 19
Identification data memory 3 read from the database 24 of
It is supposed to be stored in 5.

The style sheet designating section 36 has a function of reading the IP address included in the manufacturing data (CSV data) received from each of the manufacturing equipments 2 to 6 and finding the style sheet corresponding to this IP address from the identification data memory 35. Have.

The data conversion unit 33 uses the style sheet determined by the style sheet designation unit 36 to manufacture the original (arbitrary) format manufacturing data (CSV data) received from each of the manufacturing apparatuses 2 to 6 in the XML format. It has the function of converting to data.

The transmitter / receiver 34 receives the manufacturing data (CSV data) output from the manufacturing equipments 2 to 6 in the CSV format.
It has a data receiving port and has a function of transmitting and receiving the XML format manufacturing data converted by the data converting unit 33 by the HTTP protocol.

Next, the operation of the apparatus configured as described above will be described with reference to FIGS. 4 and 5. FIG. 4 is an operation flow chart from the manufacturing equipments 2 to 6 until the manufacturing data is stored in the database 24 of the server 19, and FIG. 5 is an operation flow chart in the data conversion device 30.

Each of the manufacturing equipments 2 to 6 sends the manufacturing data (CSV data) to each data conversion device 30 as LA.
The data is sent to N13 by TCP / IP in the socket method. Each of these manufacturing data includes its own manufacturing equipment 2
IP addresses for identifying ~ 6 are included.

In the case of the chip mounter 4, these manufacturing data are, for example, data relating to chip components mounted on the substrate and error contents (for example, suction error) when an error occurs.

The transmission / reception section 34 of each data converter 30 connected to each manufacturing equipment 2 to 6 outputs the manufacturing data (CSV data) in a unique format output from each manufacturing equipment 2 to 6 as a CS.
Received through the V data reception port.

Next, in step # 1, the style sheet designating section 36 reads the IP address contained in the manufacturing data (CSV data) from the manufacturing equipments 2 to 6 received through the CSV data receiving port, and reads this IP address. The style sheet corresponding to the identification data memory 35
Figure out from.

Next, the data conversion section 33 determines in step # 2.
In, the manufacturing data (CSV data) received from each of the manufacturing devices 2 to 6 is converted into the manufacturing data in the XML format by using the style sheet determined by the style sheet designating unit 36.

Next, in step # 3, the transmission / reception unit 34 transmits the XML-format manufacturing data converted by the data conversion unit 33 to the server 19 of the management room 18 by the HTTP protocol.

The manufacturing data in XML format is transmitted from the LAN 13 to the management room 18 side through the backbone LAN 15 and LAN 17.

The server 19 of the control room 18 is used for each manufacturing device 2
The manufacturing data in the XML format transmitted from the above-mentioned 6 to 6 are received, and these manufacturing data are stored in the database 24.
Therefore, in this database 24, each manufacturing equipment 2-6
Manufacturing data is stored in a common XML format.

As described above, in the above-mentioned one embodiment,
Manufacturing data (CSV output from various manufacturing equipment 2-6)
(Data) is converted into standard XML format data, and the data conversion device 30 for transmitting / receiving this XML format data to / from the server 19 by HTTP is provided. , The appearance inspection machine 3, the chip mounter 4, the odd-shaped mounter 5, the reflow device 6, and the like, the manufacturing data (CSV data) output from the respective manufacturing devices 2 to 6 are converted into a common standard XML format and stored in the database 24. Can be memorized. As a result, even if each manufacturing data of each company is output from each manufacturing device 2 to 6 in its own (arbitrary) format, each manufacturing data of these manufacturing devices 2 to 6 is stored in the database 24 in the standard XML format. Can be stored and managed.

In the management of the manufacturing data, the manufacturing data of each of the manufacturing devices 2 to 6 stored in the database 24 in the XML format is read out and statistical processing is performed. The process can be managed. Further, the progress of manufacturing the product and the quality data of the product can be displayed in the control room 18 in real time, and the error occurrence in each of the manufacturing devices 2 to 6 can be displayed in real time. In the error occurrence, for example, the defective rate of the printed circuit board, the error rate of each of the manufacturing devices 2 to 6, and the error occurrence rate can be displayed in real time.

Further, by analyzing the manufacturing data of each of the manufacturing devices 2 to 6 stored in the database 24 and performing the statistical processing, the product quality transition analysis (passage rate, defect rate, 1-pass pass rate) and Defect analysis (Pareto, numerical value, histogram, simple OLAP: online analysis,
It is possible to improve the quality of the product by clarifying the improvement points by executing the (processor).

Further, the CS (customer satisfaction) can be improved by searching the history of each manufacturing data of each manufacturing equipment 2 to 6 stored in the database 24.

The style sheet is stored in the database 24 of the server 19, and the data conversion device 30 causes the database 24 of the server 19 to be turned on each time the manufacturing equipments 2 to 6 are turned on.
Since it is read from and stored in the identification data memory 35,
Maintenance can be performed on the management room 18 side.

The present invention is not limited to the above-mentioned one embodiment, and various modifications can be made without departing from the scope of the invention at the implementation stage.

Further, the above embodiments include inventions at various stages, and various inventions can be extracted by appropriately combining a plurality of disclosed constituent elements. For example, even if some constituent elements are deleted from all the constituent elements shown in the embodiment, the problem described in the section of the problem to be solved by the invention can be solved, and it is described in the section of the effect of the invention. When the effect of being obtained is obtained, a configuration in which this constituent element is deleted can be extracted as an invention.

For example, in the above-described one embodiment, the case where each of the manufacturing equipments 2 to 6 transmits the manufacturing data in the CSV format by the TPC socket method has been described, but the manufacturing equipment is not limited to this, and is manufactured by serial communication such as RS232C. A method of communicating data is also applicable.

Further, it is not limited to the printed circuit board manufacturing line 1, but is applicable to all kinds of data of a unique format (arbitrary format) output from each manufacturing equipment provided in the manufacturing line of various products into common format data. Applicable. Examples include an assembly inspection line for information equipment, an assembly inspection line for medical equipment, an assembly inspection line for measurement equipment, an assembly inspection line for home appliances, and an assembly inspection line for video equipment.

[0057]

As described above in detail, according to the present invention, it is possible to provide a data conversion method and apparatus capable of converting the manufacturing data in a unique (arbitrary) format output from each manufacturing device into a common data format.

Further, according to the present invention, the manufacturing information capable of managing the manufacturing data of each manufacturing equipment by converting the manufacturing data of the unique (arbitrary) format outputted from each manufacturing equipment of the manufacturing line into a common data format. A management method and its device can be provided.

[Brief description of drawings]

FIG. 1 is an overall configuration diagram showing an embodiment in which a manufacturing information management device according to the present invention is used in a printed circuit board manufacturing line.

FIG. 2 is a configuration diagram of a data conversion device in an embodiment of a manufacturing information management device according to the present invention.

FIG. 3 is a schematic diagram of an identification data memory in one embodiment of the manufacturing information management device according to the present invention.

FIG. 4 is an operation flow chart from each manufacturing device to the storage of manufacturing data in the database of the server in the embodiment of the manufacturing information management apparatus according to the present invention.

FIG. 5 is an operation flow chart in the data conversion device in the embodiment of the manufacturing information management device according to the present invention.

[Explanation of symbols]

1: Production line 2: Printing machine 3: Visual inspection machine 4: Chip mounter 5: Atypical mounter 6: Reflow device 7: Visual inspection process 8: Correction process 9: Post process 10: PC for inputting defect phenomenon 11: PC for defect cause input 12: Serial number input PC 13, 15, 17: LAN 14, 16: Router 18: Management room 19: Server 20: Management PC 21: PC for master maintenance 22: Bar code printing PC 23: Bar code printer 30: Data converter (relay device) 31: Main control unit 32: Format determination unit 33: Data conversion unit 34: Transmitter / receiver 35: Identification data memory 36: Stylesheet designation section

Claims (10)

[Claims] 1. A step of receiving arbitrary format data output from various devices and converting these data into standard XML format data, and a step of transmitting / receiving the converted XML format data by HTTP protocol. And a data conversion method comprising: 2. A step of receiving data of an arbitrary format output from various devices and determining format conversion data for converting this data into standard XML format data, and the determined format conversion data. A data conversion method comprising: a step of converting the data into XML format data by using data; and a step of transmitting and receiving the converted XML format data according to an HTTP protocol. 3. The correspondence between the identification data of the various devices and the format conversion data is registered in advance, and the format conversion data is calculated from the identification data included in the arbitrary format data. Item 2. The data conversion method according to item 2. 4. A conversion unit for receiving data of an arbitrary format output from various devices and converting the data into standard XML format data, and transmitting / receiving the converted XML format data by HTTP protocol. A data conversion device comprising: a transmission / reception means. 5. A format indexing means for receiving data in an arbitrary format output from various devices, and indexing format conversion data for converting this data into standard XML format data, and the indexing means. Data comprising: data conversion means for converting the data into XML format data using format conversion data; and transmission / reception means for transmitting / receiving the converted XML format data by HTTP protocol. Converter. 6. The format indexing means pre-registers the correspondence between the identification data of the various devices and the format conversion data, and extracts the format conversion data from the identification data included in the arbitrary format data. The data conversion apparatus according to claim 5, wherein the data conversion is performed. 7. A manufacturing information management method for managing manufacturing data of a plurality of manufacturing equipment in a manufacturing system for manufacturing a product by flowing a work to a plurality of manufacturing equipment, wherein a manufacturing process of an arbitrary format output from the various manufacturing equipment. A manufacturing information management method comprising receiving data, converting the manufacturing data into standard XML format data, and transmitting / receiving the XML format data by HTTP protocol. 8. A manufacturing information management method for managing manufacturing data of a plurality of manufacturing devices in a manufacturing system for manufacturing a product by supplying a work to a plurality of manufacturing devices, wherein the manufacturing data of any format is output from the manufacturing device. And converting the manufacturing data into standard XML manufacturing data based on the manufacturing data, and converting the manufacturing data into standard XML format manufacturing data; and using the calculated format conversion data. Is converted into XML-format manufacturing data, and the converted XML-format manufacturing data is converted into HTTP.
And a step of transmitting and receiving according to a protocol. 9. A manufacturing information management apparatus for managing manufacturing data of a plurality of manufacturing devices in a manufacturing system for manufacturing a product by arranging a plurality of manufacturing devices, wherein the manufacturing data of any format output from the various manufacturing devices. Data conversion means for receiving the manufacturing data and converting the manufacturing data into standard XML format data, and a transmitting / receiving means for transmitting / receiving the XML format data to / from the manufacturing information database according to the HTTP protocol. Manufacturing information management device. 10. A manufacturing information management apparatus for managing manufacturing data of a plurality of manufacturing devices in a manufacturing system for manufacturing a product by arranging a plurality of manufacturing devices, wherein manufacturing data of an arbitrary format output from the manufacturing devices is A format indexing means for receiving the format data and converting the format data into standard XML format format data and indexing the format data using the index format conversion data. Data conversion means for converting into manufacturing data, and the converted manufacturing data in the XML format is HTTP.
A manufacturing information management apparatus, comprising: a transmitting / receiving unit that transmits / receives data to / from the manufacturing information database according to a protocol.