CN101684999A - Conversion method of data format - Google Patents
Conversion method of data format Download PDFInfo
- Publication number
- CN101684999A CN101684999A CN200810161412A CN200810161412A CN101684999A CN 101684999 A CN101684999 A CN 101684999A CN 200810161412 A CN200810161412 A CN 200810161412A CN 200810161412 A CN200810161412 A CN 200810161412A CN 101684999 A CN101684999 A CN 101684999A
- Authority
- CN
- China
- Prior art keywords
- data
- chip
- chip data
- data item
- target
- 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.)
- Granted
Links
Images
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 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 described 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 actual applications, can obtain chip data, from chip mounter, obtain chip data and be a kind of in the described number of ways from number of ways.
Yet the chip data of deriving from different chip mounters may have different data structures and different data layouts.For example: distinguish with separator between each data item, but, in the different pieces of information structure, the representation of separator may be different, and this will cause identical method for reading data may 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 converted to the data that meet the unified goal form from the data 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, to realize the quick conversion of original chip data to the target chip data in the process of making the AOI program.
For achieving the above object, the invention provides a kind of conversion method of data format, this method comprises:
Obtain original chip data from chip mounter, determine the physical significance of each data item in the described original chip data;
Use default separator to substitute the separator between the data item in the described original chip data, chip data in the middle of obtaining;
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 described default separator according to the data item structure target chip data that reads.
As seen from the above technical solution, conversion method of data format provided by the invention, by using default separator to substitute the separator between the data item in the original chip data, chip data in the middle of obtaining, make and all adopt 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 described default separator.So, because the data item in the original chip data has been treated to the data item of separating with default 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 example that the present invention is directed to multiple chip mounter structure.
Embodiment
For making purpose of the present invention, technical scheme and advantage clearer, below with reference to the accompanying drawing embodiment that develops simultaneously, the present invention is described in further detail.
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, determine the physical significance of each data item in the described original chip data;
Step 102: use default separator to substitute the separator between the data item in the described 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 described default 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.
When specific implementation method shown in Figure 1, at 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, then the separator between each data item gets final product in the alternative original chip data of the separator that directly uses the present invention to preset in step 102.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 to delete gibberish information wherein, keep necessary information, the execution in step 102 described 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 obtaining from described chip mounter can comprise the gauge outfit of .xls, and Level, Omit, row such as 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 may be different, this causes identical method for reading data may obtain different results for different data structures, therefore the present invention has taked the original chip data that participates in the AOI program making is carried out pre-service, separates the mode of each data item with unified default 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, read the data item with same physical meaning from middle chip data.When constructing the target chip data according to the data item that reads, can change accordingly the described data item that reads according to default transformational relation, and with the data item of the data item after the conversion as correspondence in the target chip data.
Below by one section source program example, illustrate how the data item that reads to be changed accordingly according to default transformational relation:
For?line_n2＝0To(line_n-1)
Select?Case?Offset_aoi(line_n2，3)
Case?0
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)Mod?360
Case?180
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)Mod?360
Case?Else
MsgBox″The?offset?file?has?wrong?rotate?angle，please?check?it！″
Close?#1，#4
Exit?Sub
End?Select
If?LCase(Text?1.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 represents the X coordinate of surface mount elements in the target chip data; Aoi_y represents the Y coordinate of surface mount elements in the target chip data.
Placer_y represents the Y coordinate of surface mount elements in the original chip data; Placer_x represents the X coordinate of surface mount elements in the original chip data.
Orign_angle2 represents the angle of surface mount elements in the target chip data; Orign_angle represents the angle of surface mount elements in the original chip data.
Above-mentioned source code is used to finish 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:
From being numbered 0 platelet, successively every platelet is carried out following operation:
Judge current platelet with respect to the anglec of rotation, and carry out of the conversion of original chip data according to default transformational relation to the target chip data according to the described 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 be 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 be 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 be 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 be 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.
From above code as can be seen, 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 actual applications, may have the chip mounter of number of different types, the AOI program need be obtained original chip data from the chip mounter of described 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 or construct a corresponding software module according to conversion method of data format of the present invention at the chip mounter of each type in order to finish the conversion of data layout.So,, can call corresponding software module and change, can obtain the target chip data, as shown in Figure 2 as long as determine original chip data type according to the chip mounter type.
As seen from the above-described embodiment, conversion method of data format provided by the invention, by using default separator to substitute the separator between the data item in the original chip data, chip data in the middle of obtaining, make and all adopt 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 described default separator.So, because the data item in the original chip data has been treated to the data item of separating with default 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 preferred embodiment of the present invention only, is not to be used to limit protection scope of the present invention.All any modifications of being done within the spirit and principles in the present invention, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (7)
1, a kind of conversion method of data format is characterized in that, comprising:
Obtain original chip data from chip mounter, determine the physical significance of each data item in the described original chip data;
Use default separator to substitute the separator between the data item in the described original chip data, chip data in the middle of obtaining;
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, according to the data item structure target chip data that reads with described default separator.
2, method according to claim 1 is characterized in that, describedly 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 described basis reads comprises:
According to default transformational relation the described data item that reads is changed accordingly, with the data item of the data item after the conversion as correspondence in the target chip data.
4, according to each described method of claim 1 to 3, it is characterized in that:
Described default separator be a string in chip data occurrence probability be low to moderate the character string of predetermined threshold value.
5, method according to claim 4 is characterized in that:
Described default separator is: * @*.
6, according to each described method of claim 1 to 3, it is characterized in that:
Described original chip data leaves in the file that suffix is .txt.
According to each described method of claim 1 to 3, it is characterized in that 7, described original chip data leaves in the file that suffix is .xls,
Before the separator in using the alternative described original chip data of default separator between the data item, further comprise: delete gauge outfit, row information and gibberish item that described suffix is the file of .xls.
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 true CN101684999A (en) | 2010-03-31 |
| CN101684999B 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) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102073937A (en) * | 2010-12-30 | 2011-05-25 | 中国民航信息网络股份有限公司 | Transit management system and method for hub airport |
| CN102314410A (en) * | 2010-07-02 | 2012-01-11 | 英业达股份有限公司 | Data establishing method and data establishing system using same |
| CN103377050A (en) * | 2013-06-28 | 2013-10-30 | 株洲南车时代电气股份有限公司 | SMT (surface mounted technology) machine program coordinate transformation method |
| CN108959438A (en) * | 2018-06-12 | 2018-12-07 | 北京杰控科技有限公司 | A kind of collecting method and system, a kind of server |
| CN112868014A (en) * | 2018-10-11 | 2021-05-28 | 新技术Amt股份有限公司 | Preparation method for the automatic production of electronic components, preparation method for the automatic production and/or automatic post-processing of electronic components, computing device, computer program and electronically readable data carrier |
-
2008
- 2008-09-25 CN CN2008101614128A patent/CN101684999B/en not_active Expired - Fee Related
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102314410A (en) * | 2010-07-02 | 2012-01-11 | 英业达股份有限公司 | Data establishing method and data establishing system using same |
| CN102073937A (en) * | 2010-12-30 | 2011-05-25 | 中国民航信息网络股份有限公司 | Transit management system and method for hub airport |
| CN103377050A (en) * | 2013-06-28 | 2013-10-30 | 株洲南车时代电气股份有限公司 | SMT (surface mounted technology) machine program coordinate transformation method |
| 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 |
| CN112868014A (en) * | 2018-10-11 | 2021-05-28 | 新技术Amt股份有限公司 | Preparation method for the automatic production of electronic components, preparation method for the automatic production and/or automatic post-processing of electronic components, computing device, computer program and electronically readable data carrier |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101684999B (en) | 2012-06-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110992317B (en) | PCB defect detection method based on semantic segmentation | |
| CN107025362B (en) | Method for checking consistency of schematic diagram and PCB production data | |
| CN107944517B (en) | Product whole-process quality tracing method | |
| US20150066180A1 (en) | Quick processing system and method for smt equipment | |
| CN101684999B (en) | Conversion method of data format | |
| CN109946319A (en) | Printed circuit board checking device, determine screen process press defect type method and computer can interpretation recording medium | |
| CN110222381B (en) | Method, system, medium and terminal for generating dynamic installation guide file for PCB assembly | |
| KR100749050B1 (en) | Mount data generation method for chip mounting of printed circuit board | |
| CN108596829A (en) | A kind of PCB bare boards picture method for registering and device | |
| CN104902691A (en) | Printed circuit board information system and realization method for the same | |
| CN102246605B (en) | Circuit module | |
| CN116152244A (en) | SMT defect detection method and system | |
| CN100407878C (en) | Method and apparatus for examining uniformity | |
| WO1999030545A1 (en) | A pcb testing circuit for an automatic inserting apparatus and a testing method therefor | |
| US20100269080A1 (en) | Computer-aided design system and method for simulating pcb specifications | |
| CN101398864B (en) | Circuit board making and emulating system and method | |
| 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 | |
| CN113260161B (en) | Traceable circuit board manufacturing method | |
| CN101770527A (en) | Method for modifying data of circuit components | |
| CN1979500A (en) | Part arrangement automatical checking system and method | |
| CN111443096B (en) | Method, system, electronic device and storage medium for detecting defect of printed circuit board | |
| CN110245412B (en) | Automatic design method and system for PCB thimble template, storage medium and terminal | |
| CN113191006A (en) | Digital VR monitoring method and device for electronic SMT factory |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120627 Termination date: 20170925 |