CN109343493A - Control system based on soldering paste detection device - Google Patents

Control system based on soldering paste detection device Download PDF

Info

Publication number
CN109343493A
CN109343493A CN201811329431.7A CN201811329431A CN109343493A CN 109343493 A CN109343493 A CN 109343493A CN 201811329431 A CN201811329431 A CN 201811329431A CN 109343493 A CN109343493 A CN 109343493A
Authority
CN
China
Prior art keywords
soldering paste
data
information
detection device
control system
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201811329431.7A
Other languages
Chinese (zh)
Inventor
冯奕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Flextronics Technology Suzhou Co Ltd
Original Assignee
Flextronics Technology Suzhou Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Flextronics Technology Suzhou Co Ltd filed Critical Flextronics Technology Suzhou Co Ltd
Priority to CN201811329431.7A priority Critical patent/CN109343493A/en
Publication of CN109343493A publication Critical patent/CN109343493A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B19/00Programme-control systems
    • G05B19/02Programme-control systems electric
    • G05B19/418Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
    • G05B19/4183Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by data acquisition, e.g. workpiece identification
    • GPHYSICS
    • G05CONTROLLING; REGULATING
    • G05BCONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
    • G05B2219/00Program-control systems
    • G05B2219/30Nc systems
    • G05B2219/31From computer integrated manufacturing till monitoring
    • G05B2219/31457Factory remote control, monitoring through internet
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/02Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]

Landscapes

  • Engineering & Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Manufacturing & Machinery (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Automation & Control Theory (AREA)
  • General Factory Administration (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a kind of control systems based on soldering paste detection device, obtain examining report in each soldering paste detection device, and the data in all examining reports are transferred, summarized, are counted, obtain the First Pass Yield of corresponding product type in a certain period of time, defect type quantity, the information such as the statistics of scolding tin volume, and generate corresponding table and statistical graph, full-automatic data statistics is intervened without personnel, not only can be to avoid artificial statistics high-volume data, prevent statistics from malfunctioning, and data statistics is quick, accurately, improving production efficiency.

Description

Control system based on soldering paste detection device
Technical field
The present invention relates to electronic control system fields, more particularly to a kind of control system based on soldering paste detection device.
Background technique
Whole data monitoring, the quality monitoring including component rank and pin foot rank is not specific to count for SPI test According in the machine report for being all dispersed in every SPI machine.This status bring adverse consequences is also obvious:
A. not whole First Pass Yield data;
B. without FPY (First Pass Yield) data monitoring of every line, artificial statistics needs to consume the plenty of time;
C. it does not sort specific to the First Pass Yield of each product category, can not manually handle a fairly large number of product category;
E. the specific defect type of each model and defective locations can not be tracked
D. each component defect type and quantity in corresponding product classification can not specifically be checked.
Summary of the invention
The invention mainly solves the technical problem of providing a kind of control systems based on soldering paste detection device, have reliable The advantages that performance is high, work efficiency is high, statistics is comprehensively accurate, at the same the application of electronic control system and it is universal on have extensively Market prospects.
In order to solve the above technical problems, one technical scheme adopted by the invention is that:
A kind of control system based on soldering paste detection device is provided comprising:
User query module: for user input query condition and feedback query result;
Soldering paste detection module: for acquiring and arranging single soldering paste detection device and generate examining report;
FTP information transmission modular: for the examining report in each soldering paste detection module to be transferred in a file server And it is saved;
APP message processing module: for the examining report in file server to be analyzed and extracted, and using the frame for dividing table Structure will test information and be counted and be recorded;For receiving querying condition and extracting corresponding query information and by wanting in the classification table Seek survival into query result.
In a preferred embodiment of the present invention, in APP message processing module, extract each factory, weekly, every production All primary data information (pdi)s and statistics in the examining report of line are aggregated into an initial data statistical form, count in initial data Factory, all numbers and producing line information are indicated in the file name of table.
In a preferred embodiment of the present invention, in APP message processing module, the inspection in initial data statistical form is extracted Measurement information, and statistics is aggregated into a detection and divides table.
In a preferred embodiment of the present invention, the detection breath includes: record number, construction number, job number, production Line number, device numbering, product number, date year number, week on date number, date day number, file name, testing result letter Breath, date information, product program name, sequence number, subitem table name, resource table, resource number, remarks, insertion record date, whether Processing, processing time.
In a preferred embodiment of the present invention, holding time of the initial data statistical form in file server is 1 year.
In a preferred embodiment of the present invention, it in APP message processing module, obtains each in initial data statistical form The quantity and percent of pass that product produces daily, and a production statistics table is generated daily according to this two groups of data statistics.
In a preferred embodiment of the present invention, it in APP message processing module, obtains each in initial data statistical form The element title that product includes, the segment and defects count of the volume size of product, and according to these data statistics per born At a scale of construction statistical form.
In a preferred embodiment of the present invention, it in APP message processing module, individually obtains each product and produces daily Defects count and daily generate a defect statistics table.
In a preferred embodiment of the present invention, it is csv's that the soldering paste detection module generates format upon completion of the assays Examining report.
In a preferred embodiment of the present invention, APP message processing module obtains what user inputted in user query module Query information, and according to query information transfer initial data statistical form, detection divide table, production statistics table, scale of construction statistical form, defect Related data and feedback in one or more of statistical form;
APP message processing module transfers the data in production statistics table, scale of construction statistical form and defect statistics table according to query information, The First Pass Yield curve for generating and feeding back every producing line, ten low ProductNames lead to specific before generating and feeding back First Pass Yield The histogram for crossing rate data generates and feeds back first three low product defects type pie chart of First Pass Yield;
APP message processing module transfers the data in production statistics table, scale of construction statistical form and defect statistics table according to query information, It generates and feeds back and occur that deviation, tin are few, the location map of the component of the more three kinds of defect types of tin, and marked on distribution map The quantity of defect component;
APP message processing module transfers the data in production statistics table, scale of construction statistical form and defect statistics table according to query information, Generate and feed back the histogram of different scolding tin volumes and scolding tin total amount.
The beneficial effects of the present invention are: obtaining examining report in each soldering paste detection device, and in all examining reports Data transferred, summarized, counted, obtain the First Pass Yield of corresponding product type in a certain period of time, defect class Type quantity, the information such as statistics of scolding tin volume, and corresponding table and statistical graph are generated, full-automatic data statistics is not necessarily to Personnel intervene, and not only can prevent statistics from malfunctioning, and data statistics is quick, accurately, mentions to avoid artificial statistics high-volume data Rise production efficiency.
Detailed description of the invention
To describe the technical solutions in the embodiments of the present invention more clearly, make required in being described below to embodiment Attached drawing is briefly described, it should be apparent that, drawings in the following description are only some embodiments of the invention, for For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other Attached drawing, in which:
Fig. 1 is the structural schematic diagram of control system one preferred embodiment of the invention based on soldering paste detection device.
Specific embodiment
The technical scheme in the embodiments of the invention will be clearly and completely described below, it is clear that described implementation Example is only a part of the embodiments of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, this field is common Technical staff's all other embodiment obtained without making creative work belongs to the model that the present invention protects It encloses.
Referring to Fig. 1, the embodiment of the present invention includes:
A kind of control system based on soldering paste detection device in two sub-sections, board part of data acquisition and data statistics part number It is write according to collecting part by C#, the data needed in data statistics, back-end data point is extracted in brave cream detection device standard report Analysing module architectures is SQL Server+ASP.Net, and after collected data are saved in database, daily 12 points to data It is pre-processed.After the page has request of data, preprocessed data is counted, to show real-time statistics result.
The control system based on soldering paste detection device includes:
User query module: for user input query condition and feedback query result;
Soldering paste detection module: for acquiring and arranging single soldering paste detection device and generate examining report;
FTP information transmission modular: for the examining report in each soldering paste detection module to be transferred in a file server And it is saved;
APP message processing module: for the examining report in file server to be analyzed and extracted, and using the frame for dividing table Structure will test information and be counted and be recorded;For receiving querying condition and extracting corresponding query information and by wanting in the classification table Seek survival into query result.
In APP message processing module, each factory, all original weekly, in the examining report of every producing line is extracted Data information and count be aggregated into an initial data statistical form, in the file name of initial data statistical form indicate factory, All numbers and producing line information.
In APP message processing module, the detection information in initial data statistical form is extracted, and count and be aggregated into an inspection Survey divides table.Detection breath include: record number, construction number, job number, producing line number, device numbering, product number, Date year number, week on date number, date day number, file name, testing result information, date information, product program name, sequence Whether row number subitem table name, resource table, resource number, remarks, insertion record date, handles, handles the time.
Holding time of the initial data statistical form in file server is 1 year.
In APP message processing module, the quantity and pass through that each product produces daily in initial data statistical form are obtained Rate, and a production statistics table fctSATSummaryYieldDay is generated daily according to this two groups of data statistics, it is every for saving The quantity and percent of pass data that a product produces daily, comparison original data record item number greatly reduce.
In APP message processing module, the element title that each product includes in initial data statistical form is obtained, product The segment and defects count of volume size, and a scale of construction statistical form is generated daily according to these data statistics FctSATSummaryVolumeDay, the element title in each product type, the segment and defects count of volume size, Data volume is at 500,000,000 or so.
In APP message processing module, individually obtains the defects count that each product produces daily and generate one daily Defect statistics table fctSATSummaryDefectDay.
To magnanimity initial data, section carries out that three above table is calculated during idle time.
APP message processing module obtains the query information that user inputs in user query module, and according to query information tune Initial data statistical form, detection is taken to divide in one or more of table, production statistics table, scale of construction statistical form, defect statistics table Related data is simultaneously fed back.
Every time according to the end user query requirement in browser, including the different periods, different plant areas is different Producing line carries out specific aim inquiry, and there is no need to inquire magnanimity initial data, main three calculated results for needing to inquire last point Table obtains query result required for user, greatly improves efficiency by combining the data operation in storing process.
APP message processing module is transferred in production statistics table, scale of construction statistical form and defect statistics table according to query information Data generate and feed back the First Pass Yield curve of every producing line, generate and feed back before First Pass Yield ten low ProductNames with Especially by the histogram of rate data, generates and feed back first three low product defects type pie chart of First Pass Yield.
APP message processing module is transferred in production statistics table, scale of construction statistical form and defect statistics table according to query information Data, generate and feed back and occur that deviation, tin are few, the location map of the component of the more three kinds of defect types of tin, and in distribution map Subscript goes out the quantity of defect component.
APP message processing module is transferred in production statistics table, scale of construction statistical form and defect statistics table according to query information Data generate and feed back the histogram of different scolding tin volumes and scolding tin total amount.
Content in each described examining report includes: plank information, jigsaw information and pad information.
The plank information includes: the total First Pass Yield of all models of all products;All productions of every line of each factory The First Pass Yield of product;Lower ten names of product of the last week First Pass Yield and pass through rate score;First Pass Yield first three Low product specific defect type pie chart.
The jigsaw information includes: to show which element on product which daughter board there is a problem, and show Failure type and quantity are shown.
The pad information includes the volume distribution map of each pad scolding tin of statistical product.
After initial data saves, 12 points or so of daily morning, background data base can run a script, daily the number of flood tide According to carrying out summarizing calculating, such as First Pass Yield of some product type on the day of, defect type quantity, the system of scolding tin volume Meter etc., and the statistical result after calculating is stored in a new table.
After the step, user obtains instant data and only needs background access these processed tables of data i.e. Can, without being calculated since initial data.What is greatly speeded up checks the speed of calculated result.The data for needing to count are from upper Hundred million quantity is reduced to million ranks.
This system can count the First Pass Yield of each product, the ratio of defects of each original part, defect class on each product Type and we can count on the tin amount of each pad of product, this can not be counted in the past.Meanwhile which is produced The quantity that tin on which pad of product occurs more than tin is more, this clearly can pass through graphical display in systems.
It is counted by this, that corresponding component of this product, which pad can be clearly found out in picture It is relatively more that offset number occurs in tin.There are these information, so that it may corresponding adjustment be made to production in time, acquired by these Data, the statistical work for originally needing several days that could complete can count completion within 20s now.And it can be any Select regular hour span.
Beneficial effect the present invention is based on the control system of soldering paste detection device is:
A. greatly reduce data statistics time and difficulty, reduce manpower waste;
B. prevent statistics from malfunctioning;
C. full-automatic data statistics is not necessarily to manual intervention;
D. data can track the rank of each pin of device
It e. can be than manually seeing more data statistics.
The above description is only an embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair Equivalent structure or equivalent flow shift made by bright description is applied directly or indirectly in other relevant technology necks Domain is included within the scope of the present invention.

Claims (10)

1. a kind of control system based on soldering paste detection device characterized by comprising
User query module: for user input query condition and feedback query result;
Soldering paste detection module: for acquiring and arranging single soldering paste detection device and generate examining report;
FTP information transmission modular: for the examining report in each soldering paste detection module to be transferred in a file server And it is saved;
APP message processing module: for the examining report in file server to be analyzed and extracted, and using the frame for dividing table Structure will test information and be counted and be recorded;For receiving querying condition and extracting corresponding query information and by wanting in the classification table Seek survival into query result.
2. the control system according to claim 1 based on soldering paste detection device, which is characterized in that in APP information processing In module, extracts each factory, all primary data information (pdi)s weekly, in the examining report of every producing line and count and be aggregated into one A initial data statistical form indicates factory, all numbers and producing line information in the file name of initial data statistical form.
3. the control system according to claim 2 based on soldering paste detection device, which is characterized in that in APP information processing In module, the detection information in initial data statistical form is extracted, and statistics is aggregated into a detection and divides table.
4. the control system according to claim 3 based on soldering paste detection device, which is characterized in that the detection breath packet Include: record number, job number, producing line number, device numbering, product number, date year number, is compiled in week on date construction number Number, date day number, file name, testing result information, date information, product program name, sequence number, subitem table name, resource Whether table resource number, remarks, insertion record date, handles, handles the time.
5. the control system according to claim 2 based on soldering paste detection device, which is characterized in that the initial data system Counting holding time of the table in file server is 1 year.
6. the control system according to claim 2 based on soldering paste detection device, which is characterized in that in APP information processing In module, the quantity and percent of pass that each product produces daily in initial data statistical form are obtained, and according to this two groups of data systems Meter generates a production statistics table daily.
7. the control system according to claim 6 based on soldering paste detection device, which is characterized in that in APP information processing In module, each product element title for including in initial data statistical form is obtained, the segment of the volume size of product and lack Quantity is fallen into, and generates a scale of construction statistical form daily according to these data statistics.
8. the control system according to claim 7 based on soldering paste detection device, which is characterized in that in APP information processing In module, individually obtains the defects count that each product produces daily and generate a defect statistics table daily.
9. the control system according to claim 1 based on soldering paste detection device, which is characterized in that the soldering paste detects mould Block generates the examining report that format is csv upon completion of the assays.
10. the control system according to claim 8 based on soldering paste detection device, which is characterized in that APP information processing mould Block obtains the query information that user inputs in user query module, and transfers initial data statistical form, detection according to query information Divide the related data and feedback in one or more of table, production statistics table, scale of construction statistical form, defect statistics table;
APP message processing module transfers the data in production statistics table, scale of construction statistical form and defect statistics table according to query information, The First Pass Yield curve for generating and feeding back every producing line, ten low ProductNames lead to specific before generating and feeding back First Pass Yield The histogram for crossing rate data generates and feeds back first three low product defects type pie chart of First Pass Yield;
APP message processing module transfers the data in production statistics table, scale of construction statistical form and defect statistics table according to query information, It generates and feeds back and occur that deviation, tin are few, the location map of the component of the more three kinds of defect types of tin, and marked on distribution map The quantity of defect component;
APP message processing module transfers the data in production statistics table, scale of construction statistical form and defect statistics table according to query information, Generate and feed back the histogram of different scolding tin volumes and scolding tin total amount.
CN201811329431.7A 2018-11-09 2018-11-09 Control system based on soldering paste detection device Pending CN109343493A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811329431.7A CN109343493A (en) 2018-11-09 2018-11-09 Control system based on soldering paste detection device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811329431.7A CN109343493A (en) 2018-11-09 2018-11-09 Control system based on soldering paste detection device

Publications (1)

Publication Number Publication Date
CN109343493A true CN109343493A (en) 2019-02-15

Family

ID=65314308

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811329431.7A Pending CN109343493A (en) 2018-11-09 2018-11-09 Control system based on soldering paste detection device

Country Status (1)

Country Link
CN (1) CN109343493A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114750510A (en) * 2022-04-29 2022-07-15 道恩周氏(青岛)复合包装材料有限公司 Defect marking and automatic removing method, system, equipment and medium

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1908829A (en) * 2005-08-04 2007-02-07 日东电子科技(深圳)有限公司 Reflow soldering programming automatic management system and method
CN102221561A (en) * 2010-04-15 2011-10-19 西门子公司 System and method for detecting printing state of soldering paste
CN104684270A (en) * 2013-11-27 2015-06-03 三星泰科威株式会社 System for monitoring and estimating disorder of SMT device and method of operating same
CN105786831A (en) * 2014-12-22 2016-07-20 富泰华工业(深圳)有限公司 Data analysis system and method
CN106815718A (en) * 2017-01-11 2017-06-09 广州炬森自动化设备有限公司 A kind of pcb board defect statistics method and system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1908829A (en) * 2005-08-04 2007-02-07 日东电子科技(深圳)有限公司 Reflow soldering programming automatic management system and method
CN102221561A (en) * 2010-04-15 2011-10-19 西门子公司 System and method for detecting printing state of soldering paste
CN104684270A (en) * 2013-11-27 2015-06-03 三星泰科威株式会社 System for monitoring and estimating disorder of SMT device and method of operating same
CN105786831A (en) * 2014-12-22 2016-07-20 富泰华工业(深圳)有限公司 Data analysis system and method
CN106815718A (en) * 2017-01-11 2017-06-09 广州炬森自动化设备有限公司 A kind of pcb board defect statistics method and system

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114750510A (en) * 2022-04-29 2022-07-15 道恩周氏(青岛)复合包装材料有限公司 Defect marking and automatic removing method, system, equipment and medium
CN114750510B (en) * 2022-04-29 2024-02-02 道恩周氏(青岛)复合包装材料有限公司 Defect marking and automatic eliminating method, system, equipment and medium

Similar Documents

Publication Publication Date Title
CN110991486B (en) Method and device for controlling labeling quality of multi-person collaborative image
CN111209258A (en) Tax end system log real-time analysis method, equipment, medium and system
CN106709065A (en) Standardization processing method and standardized processing device for address information
CN112883692B (en) Automatic generation method of PPT data report
CN110851667A (en) Integrated analysis method and tool for multi-source large data
CN108897821B (en) Method and device for automatically generating data conclusion
CN116433052A (en) Intelligent bidding information acquisition data analysis and evaluation system
CN108197301A (en) A kind of method for being used to quantify different stock trader APP market refresh rates
CN112699128A (en) Report generation method and device, readable storage medium and electronic equipment
CN101976394A (en) Data acquiring and counting system and method
CN113255307A (en) Intelligent reporting method and system for power system
CN109343493A (en) Control system based on soldering paste detection device
CN110569237A (en) System and method for realizing real-time data cleaning processing
CN117078152A (en) Image recognition-based quotient zero precision signing method and system for tobacco industry
CN111966726A (en) System and method for generating self-adaptive data analysis report based on different types of clients
CN111899214A (en) Pathological section scanning analysis device and pathological section scanning method
CN116303741A (en) Data display method, device and storage medium
CN110287243A (en) Distributed data acquires and display systems and method in real time
CN115952236A (en) Power failure data analysis processing method and device based on real-time flow calculation
CN110175196A (en) A kind of bill of materials problem statistical method and device
JP2001184273A (en) Questionnaire system, and method of automating questionnaire work
CN107248375A (en) Identifier benefit value method and system for quarter machine
CN113220726A (en) Data quality detection method and system
CN112801520A (en) Intelligent management system based on enterprise management big data
CN113780716A (en) Business machine account generation system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20190215