CN101684999B - Conversion method of data format - Google Patents
Conversion method of data format Download PDFInfo
- Publication number
- CN101684999B CN101684999B CN2008101614128A CN200810161412A CN101684999B CN 101684999 B CN101684999 B CN 101684999B CN 2008101614128 A CN2008101614128 A CN 2008101614128A CN 200810161412 A CN200810161412 A CN 200810161412A CN 101684999 B CN101684999 B CN 101684999B
- Authority
- CN
- China
- Prior art keywords
- data
- chip
- chip data
- target
- data item
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 23
- 230000008569 process Effects 0.000 claims abstract description 15
- 230000003287 optical effect Effects 0.000 claims description 7
- 238000004519 manufacturing process Methods 0.000 abstract description 5
- 238000005516 engineering process Methods 0.000 description 4
- 239000000047 product Substances 0.000 description 4
- 238000001514 detection method Methods 0.000 description 3
- 208000034423 Delivery Diseases 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000012372 quality testing Methods 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000012467 final product Substances 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000011159 matrix material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 238000011179 visual inspection Methods 0.000 description 1
Images
Landscapes
- Image Processing (AREA)
- Character Input (AREA)
Abstract
The invention discloses a conversion method of a data format, comprising the following steps: firstly, acquiring raw chip data from a chip mounter and determining physical significances of various data items of the raw chip data; secondly, replacing separating characters among the data items of the raw chip data by preset separating characters to obtain middle chip data; and finally, reading corresponding data items from the middle chip data according to a target data format, distinguishing different data items through the separating characters in the process of reading the data items and constructing target chip data according to the read data items. By applying the invention, quick conversion from the raw chip data to the target chip data can be realized in the process of manufacturing an AIO program.
Description
Technical field
The present invention relates to the automated optical detection technique, particularly a kind of conversion method of data format.
Background technology
Chip mounter is based on surface mounting technology (SMT, Surface Mount Technology), is used for realizing pasting at a high speed, accurately the equipment of discharge road board component.In intense market competition, electronic product manufacturer must guarantee the quality of product, and in order to guarantee the quality of product, and it is just particularly important in manufacture course of products, the semifinished or finished goods of each production link to be carried out quality testing.
Along with the printed circuit board line pattern that uses among the SMT becomes more meticulous, the microminiaturization of SMD element and SMT assembly High Density Packaging, the development trend of assembling fast; Adopt the mode of visual inspection or artificial optical detection to carry out the needs that quality testing can not adapt to practical application; Therefore; Automated optical detects (AOI, Automatic Optical Inspector) technology and just is being used for the testing circuit board component more and more widely, to improve the paster quality of SMT.
The ultimate principle of AOI is: with optical instrument (for example: video camera) obtain the measured object image; And this image digitazation obtained corresponding chip data; Standard chip data with storage in advance compares, analyzes, checks and judgement etc. then, is equivalent to artificial visual is detected robotization, intellectuality.In fact said standard chip data is exactly in processes such as comparison, analysis, check and judgement, in order to the chip data as standard.
The data item that chip data generally includes has:
The thing item number, the numbering of expression surface mount elements;
Surface mount elements X coordinate with respect to origin position on its place platelet is represented in the X position;
Surface mount elements Y coordinate with respect to origin position on its place platelet is represented in the Y position;
The anglec of rotation, expression surface mount elements actual paster angle is with respect to the anglec of rotation as the surface mount elements of target;
And other data relevant with paster, or the like.
The AOI program is to run on the AOI equipment, carries out the software program of detection task with control AOI equipment.When making the AOI program, need obtain chip data.In practical application, can obtain chip data from number of ways, from chip mounter, obtain chip data and be a kind of in the said number of ways.
Yet the chip data of from different chip mounters, deriving possibly have different data structures and different data layouts.For example: distinguish with separator between each data item, still, in the different pieces of information structure; The representation of separator maybe be different, and this will cause identical method for reading data possibly obtain different results for different data structures, therefore; When reading chip data, need at first judge the type of chip mounter; And adopting corresponding method for reading data to read, it is low that this causes making the AOI program efficiency, also higher to producer's requirement.Therefore, how will be the data that meet the unified goal form from the data-switching of different pieces of information structure, be to realize quick Fabrication AOI program, and promote the key of producing the line quality.
Summary of the invention
In view of this, fundamental purpose of the present invention is to provide a kind of conversion method of data format, in the process of making the AOI program, to realize the quick conversion of original chip data to the target chip data.
For achieving the above object, the invention provides a kind of conversion method of data format, when this method was applied to make automated optical and detects the AOI program and from chip mounter, obtain original chip data, this method comprised:
Obtain original chip data from chip mounter, confirm the physical significance of each data item in the said original chip data;
When said original chip data leaves in the file that suffix is .txt, use preset separator to substitute the separator between the data item in the said original chip data, chip data in the middle of obtaining; When said original chip data leaves in the file that suffix is .xls; Before the separator in using the alternative said original chip data of preset separator between the data item, further comprise: delete gauge outfit, row information and gibberish item that said suffix is the file of .xls; Wherein, said preset separator be a string in original chip data occurrence probability be low to moderate the character string of predetermined threshold value;
According to target data form reading corresponding data item from middle chip data; According to the data item structure target chip data that reads; Said target chip data is the target chip data of the AOI program making of participation AOI equipment, in the process of reading of data item, distinguishes different data item with said preset separator.
Visible by technique scheme; Conversion method of data format provided by the invention; Through using preset separator to substitute the separator between the data item in the original chip data, chip data in the middle of obtaining makes and all adopts identical separator to separate between each data item in the chip data in the middle of resulting; Then according to target data form reading corresponding data item from middle chip data, and in the process of reading of data item, distinguish different data item with said preset separator.So; Because the data item in the original chip data has been treated to the data item of separating with preset separator; At this moment; Can be as required reading corresponding data item apace, thereby accelerate the speed of structure target chip data, in the process of making the AOI program, realize of the quick conversion of original chip data to the target chip data.
Description of drawings
Fig. 1 is the schematic flow sheet of conversion method of data format of the present invention;
Fig. 2 is the AOI program structure instance that the present invention is directed to multiple chip mounter structure.
Embodiment
For making the object of the invention, technical scheme and advantage clearer, below with reference to the accompanying drawing embodiment that develops simultaneously, the present invention is done further explain.
Fig. 1 is the schematic flow sheet of conversion method of data format of the present invention.Referring to Fig. 1, this method comprises:
Step 101: obtain original chip data from chip mounter, confirm the physical significance of each data item in the said original chip data;
Step 102: use preset separator to substitute the separator between the data item in the said original chip data, chip data in the middle of obtaining;
Step 103:,, in the process of reading of data item, distinguish different data item with said preset separator according to the data item structure target chip data that reads according to target data form reading corresponding data item from middle chip data.
So far, finish data transfer device of the present invention.
Concrete when realizing method shown in Figure 1, to accessed original chip data deposit the form difference, need take different modes to handle, for example:
If the accessed original chip data of step 101 leaves in the file that suffix is .txt, the separator in the alternative original chip data of the separator that then in step 102, directly uses the present invention to preset between each data item gets final product.For the useless capable information in the .txt file, gibberish item etc., all can not add processing, because in the process that subsequent reads is fetched data, will ignore capable information and gibberish item.
If the accessed original chip data of step 101 leaves in the file that suffix is .xls; Then need at first deletion gibberish information wherein; Keep necessary information, the execution in step 102 said separators of presetting with the present invention substitute the operation of the separator between each data item in the original chip data again.Chip mounter with Siemens Company is an example; The gibberish information of from said chip mounter, obtaining can comprise the gauge outfit of .xls; And row such as Level, Omit, Exclusive, CAD Shape, and the useful data item comprises row such as Ref-Designator, Component.
As previously mentioned; Because in the different data structures; The representation of separator maybe be different; This causes identical method for reading data possibly obtain different results for different data structures, so the present invention taked the original chip data of participating in the AOI program making is carried out pre-service, separates the mode of each data item with unified preset separator, thereby can improve the speed and the reliability of whole Data Format Transform process greatly.When separator is set, can select a string in chip data occurrence probability be low to moderate the character string of predetermined threshold value, obscure to avoid chip data and separator.For example: the probability that these three symbols of * @* occur in the chip mounter data simultaneously is quite little, almost nil, therefore, and the present invention presets * @* as the present invention separator.
Method according to target data form reading corresponding data item from middle chip data in the above-mentioned steps 103 can be: according to each parameter corresponding physical meaning in the target data form, from middle chip data, read the data item with same physical meaning.When constructing the target chip data according to the data item that reads, can change accordingly the said data item that reads according to preset transformational relation, and with the data item of the data item after the conversion as correspondence in the target chip data.
Through one section source program instance, explain and how the data item that reads to be changed accordingly below according to preset transformational relation:
For?line_n2＝0To(line_n-1)
Select?Case?Offset_aoi(line_n2，3)
Case0
aoi_x＝-1000*(Placer_y+Offset_aoi(line_n2，2))
aoi_y＝1000*(Placer_x+Offset_aoi(line_n2，1))
Orign_angle2＝(Orign_angle+360)Mod360
Case180
aoi_x＝-1000*(Offset_aoi(line_n2，2)-Placer_y)
aoi_y＝1000*(Offset_aoi(line_n2，1)-Placer_x)
Orign_angle2＝(Orign_angle+180)Mod360
Case?Else
MsgBox″The?offset?file?has?wrong?rotate?angle，please?check?it!″
Close#1，#4
Exit?Sub
End?Select
If?LCase(Text1.Text)＝″y″Then
Print#4，″d″，aoi_x，CDbl(Text2.Text)*1000-aoi_y，
Offset_aoi(line_n2，0)&″:″&Ref，″n0000″，Orign_angle2，
Component，″n-″&i，Offset_aoi(line_n2，0)&″:″&Ref，Component
Else
Print#4，″d″，aoi_x，aoi_y，Offset_aoi(line_n2，0)&″:″&Ref，
″n0000″，Orign_angle2，Component，″n-″&i，Offset_aoi(line_n2，0)
&″:″&Ref，Component
End?If
i＝i+1
Next?line_n2
In the above-mentioned source program, the total number of platelet in the line_n indication circuit plate.
Offset_aoi () is a matrix of storage in advance, and in this example, the line number of Offset_aoi () is line_n, and value is 0～line_n-1, and columns is 4, and value is 0～3.Wherein, The title of current platelet is shown in the 0th tabulation; The 1st tabulation shows that current platelet is with respect to the X coordinate as that piece platelet of target; The 2nd tabulation is shown current platelet with respect to the Y coordinate as that piece platelet of target, and the 3rd tabulation shows that current platelet is with respect to the anglec of rotation as that piece platelet of target.
Aoi_x representes the X coordinate of surface mount elements in the target chip data; Aoi_y representes the Y coordinate of surface mount elements in the target chip data.
Placer_y representes the Y coordinate of surface mount elements in the original chip data; Placer_x representes the X coordinate of surface mount elements in the original chip data.
Orign_angle2 representes the angle of surface mount elements in the target chip data; Orign_angle representes the angle of surface mount elements in the original chip data.
Above-mentioned source code is used to accomplish chip data on the physical significance to the function of AOI routine data conversion, just from the function of original chip data to the conversion of target chip data.The semanteme of above-mentioned source code is specially:
Begin from being numbered 0 platelet, successively every platelet operated as follows:
Judge current platelet with respect to the anglec of rotation, and carry out of the conversion of original chip data according to preset transformational relation to the target chip data according to the said anglec of rotation as that piece platelet of target;
If the anglec of rotation is 0 °, then the Y coordinate of surface mount elements in the original chip data and current platelet multiply by-1000 values that obtain with respect to the Y coordinate sum as that piece platelet of target, as the X coordinate of surface mount elements in the target chip data; The X coordinate of surface mount elements in the original chip data and current platelet multiply by 1000 values that obtain with respect to the X coordinate sum as that piece platelet of target, as the Y coordinate of surface mount elements in the target chip data; The value that the angle of surface mount elements in the original chip data and 360 sums are obtained 360 deliverys is as the angle of surface mount elements in the target chip data;
If the anglec of rotation is 180 °, then current platelet multiply by-1000 values that obtain with respect to the difference as the Y coordinate of surface mount elements in the Y coordinate of that piece platelet of target and the original chip data, as the X coordinate of surface mount elements in the target chip data; Current platelet multiply by 1000 values that obtain with respect to the difference as the X coordinate of surface mount elements in the X coordinate of that piece platelet of target and the original chip data, as the Y coordinate of surface mount elements in the target chip data; The value that the angle of surface mount elements in the original chip data and 180 sums are obtained 360 deliverys is as the angle of surface mount elements in the target chip data;
If the anglec of rotation is other values, then point out mistake.
Can find out from above code; Mainly be that the data item in the original chip data is redistributed according to the requirement of making the AOI program in the process of making the AOI program; This is a kind of duplication of labour in actual production; Exist this duplication of labour will produce waste, comprise time and waste of manpower resource.Therefore; Utilize conversion method of data format provided by the present invention can realize the making of other and type AOI program thereof; Thereby significantly shorten the construction cycle of making the AOI program software, and improve the speed of Data Format Transform, and reduce the probability that makes a mistake in the Data Format Transform process.
In practical application, possibly there is the chip mounter of number of different types, the AOI program need be obtained original chip data from the chip mounter of said number of different types.Because the physical meaning of each data item representative is can be predetermined in the various chip mounters; Therefore, can construct one section corresponding program according to conversion method of data format of the present invention or construct a corresponding software module to the chip mounter of each type in order to accomplish the conversion of data layout.So,, can call corresponding software module and change, can obtain the target chip data as long as confirm original chip data type according to the chip mounter type, as shown in Figure 2.
Visible by the foregoing description; Conversion method of data format provided by the invention; Through using preset separator to substitute the separator between the data item in the original chip data, chip data in the middle of obtaining makes and all adopts identical separator to separate between each data item in the chip data in the middle of resulting; Then according to target data form reading corresponding data item from middle chip data, and in the process of reading of data item, distinguish different data item with said preset separator.So; Because the data item in the original chip data has been treated to the data item of separating with preset separator; At this moment; Can be as required reading corresponding data item apace, thereby accelerate the speed of structure target chip data, in the process of making the AOI program, realize of the quick conversion of original chip data to the target chip data.
The above is merely preferred embodiment of the present invention, is not to be used to limit protection scope of the present invention.All any modifications of within spirit of the present invention and principle, being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (4)
1. when conversion method of data format, this method are applied to make automated optical and detect the AOI program and from chip mounter, obtain original chip data, it is characterized in that, comprising:
Obtain original chip data from chip mounter, confirm the physical significance of each data item in the said original chip data;
When said original chip data leaves in the file that suffix is .txt, use preset separator to substitute the separator between the data item in the said original chip data, chip data in the middle of obtaining; When said original chip data leaves in the file that suffix is .xls; Before the separator in using the alternative said original chip data of preset separator between the data item, further comprise: delete gauge outfit, row information and gibberish item that said suffix is the file of .xls; Wherein, said preset separator be a string in original chip data occurrence probability be low to moderate the character string of predetermined threshold value;
According to target data form reading corresponding data item from middle chip data; In the process of reading of data item, distinguish different data item with said preset separator; According to the data item structure target chip data that reads, said target chip data is the target chip data of the AOI program making of participation AOI equipment.
2. method according to claim 1 is characterized in that, saidly comprises according to target data form reading corresponding data item from middle chip data:
According to each parameter corresponding physical meaning in the target data form, from middle chip data, read data item with same physical meaning.
3. method according to claim 1 is characterized in that, the data item structure target chip data that said basis reads comprises:
Transformational relation according to preset is changed the said data item that reads accordingly, with the data item of the data item after the conversion as correspondence in the target chip data.
4. method according to claim 1 is characterized in that:
Said preset separator is: * *.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008101614128A CN101684999B (en) | 2008-09-25 | 2008-09-25 | Conversion method of data format |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008101614128A CN101684999B (en) | 2008-09-25 | 2008-09-25 | Conversion method of data format |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101684999A CN101684999A (en) | 2010-03-31 |
| CN101684999B true CN101684999B (en) | 2012-06-27 |
Family
ID=42048278
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2008101614128A Expired - Fee Related CN101684999B (en) | 2008-09-25 | 2008-09-25 | Conversion method of data format |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101684999B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102314410B (en) * | 2010-07-02 | 2013-07-31 | 英业达股份有限公司 | Data creation method and data creation system applied to Flash interface |
| CN102073937A (en) * | 2010-12-30 | 2011-05-25 | 中国民航信息网络股份有限公司 | Transit management system and method for hub airport |
| CN103377050B (en) * | 2013-06-28 | 2016-05-25 | 株洲南车时代电气股份有限公司 | A kind of chip mounter program coordinate transformation method |
| CN108959438A (en) * | 2018-06-12 | 2018-12-07 | 北京杰控科技有限公司 | A kind of collecting method and system, a kind of server |
| DE102018125216B3 (en) * | 2018-10-11 | 2020-02-06 | Neotech AMT GmbH | Process for preparing the automated manufacture of an electronic component, process for the automated manufacture and / or automated post-processing of an electronic component, computing device, computer program and electronically readable data carrier |
-
2008
- 2008-09-25 CN CN2008101614128A patent/CN101684999B/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN101684999A (en) | 2010-03-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107025362B (en) | Method for checking consistency of schematic diagram and PCB production data | |
| CN108012426B (en) | A Quality Traceability Method of Multilayer PCB | |
| CN107944517B (en) | A product whole process quality traceability method | |
| CN101684999B (en) | Conversion method of data format | |
| CN100541502C (en) | A kind of PCB analogue system and its implementation with error detection function | |
| CN109946319A (en) | Printed circuit board checking device, determine screen process press defect type method and computer can interpretation recording medium | |
| CN107992917B (en) | A Quality Traceability Method of Multilayer PCB | |
| CN102271464B (en) | Method for tracing quality of circuit board | |
| KR100749050B1 (en) | Method of generating mount data for device mounting of a printed circuit board | |
| AU2001228211A1 (en) | Method and system for detecting defects on a printed circuit board | |
| CN110222381B (en) | Method, system, medium and terminal for generating dynamic installation guide file for PCB assembly | |
| CN117473940B (en) | Electronic design drawing management method and device, electronic equipment and storage medium | |
| CN102246605B (en) | Circuit module | |
| CN103517575A (en) | Method for transplant grafting of printed circuit board | |
| WO1999030545A1 (en) | A pcb testing circuit for an automatic inserting apparatus and a testing method therefor | |
| Gore et al. | A novel methodology for health assessment in printed circuit boards | |
| CN110245582A (en) | A method for identifying single-class components in bitmaps based on deep learning | |
| US20100269080A1 (en) | Computer-aided design system and method for simulating pcb specifications | |
| CN111443096B (en) | Method, system, electronic device and storage medium for detecting defect of printed circuit board | |
| CN113807479A (en) | PCB tracing method, PCB tracing identification method and PCB | |
| CN109426674A (en) | A kind of printed circuit board detecting method and system | |
| CN110969111A (en) | Automatic identification and classification method for mechanical part digital drawing | |
| CN104411091A (en) | Circuit board sign method based on bad mark two-dimensional codes | |
| CN101398864A (en) | Circuit board making and emulating system and method | |
| KR101408848B1 (en) | Information tracing method of pcb test processing with multi-step mapping |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120627 Termination date: 20170925 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |