CN103377050A - SMT (surface mounted technology) machine program coordinate transformation method - Google Patents
SMT (surface mounted technology) machine program coordinate transformation method Download PDFInfo
- Publication number
- CN103377050A CN103377050A CN2013102700348A CN201310270034A CN103377050A CN 103377050 A CN103377050 A CN 103377050A CN 2013102700348 A CN2013102700348 A CN 2013102700348A CN 201310270034 A CN201310270034 A CN 201310270034A CN 103377050 A CN103377050 A CN 103377050A
- Authority
- CN
- China
- Prior art keywords
- data
- program
- item
- chip mounter
- detailed
- 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
Landscapes
- Stored Programmes (AREA)
Abstract
The invention discloses an SMT (surface mounted technology) machine program coordinate transformation method. The SMT machine program coordinate transformation method includes that detailed original data of an SMT machine program are acquired, physical significance of each data item is determined, the original data form a data table according to distribution of rows and columns, the rows or the columns of the data table correspond to each physical parameter of the same type of devices, and the columns or the rows correspond to the same parameter values of different types of devices; the corresponding data items are read from the determined detailed original data according to a target data format and subjected to coordinate transformation to obtain target program detail data which form a data table according to the distribution of the rows and the columns, the rows or the columns of the data table correspond to each physical parameter of the same device, and the columns or the rows of the data table correspond to the same parameter values of different devices. By the method, program coordinate details with different formats and specifications are automatically converted to the program coordinate details according with requirements of certain rules, preparation time of SMT machine program coordinates is shortened, and efficiency, accuracy and compatibility of program composition are improved.
Description
Technical field
The present invention relates to a kind of Bill of Material (BOM) coordinate transformation method, especially relate to a kind of PCB(Printed of being applied to Circuit Board, printed-wiring board (PWB)) SMT(Surface Mounted Technology in the manufacture process, surface mounting technology) the program coordinate transformation method of chip mounter.
Background technology
The detailed establishment of the material of SMT chip mounter often needs to meet certain code requirement, and the PCB material detailed data form of each design department's output all can there are differences usually, the PCB material detailed data that simultaneously some production domesticization are introduced projects exists different from the code requirement of each enterprises, cause the chip mounter operating personnel in the detailed set-up procedure of processing of chip mounter material, to be wasted time and energy, efficient is lower, and make mistakes easily, become a problem being badly in need of solution in the chip mounter material detailed data compilation process.
The surface-mounted device detail that those skilled in the art provide all can comprise usually: the kind of the position that project sequence number, device mount, the coding of material, material, the model of material and the data such as quantity of material.And in actual concrete model and the parameter that need to be accurate to each device when carrying out the program composition of chip mounter material detailed data.Chip mounter programmer set-up procedure that the material detailed data that provides is processed original method of usage comparison all always namely adopted the method for shearing or copying one by one item, model specification to be pasted on the corresponding position in the past.Make all detailed items, model meet the program composition of carrying out again next step behind the call format of establishment chip mounter program.
In addition, the design and development company that has at present the more SMT of being engaged in system optimization software, the special software of its exploitation can directly go out to meet the material detailed data program of chip mounter read operation standard by the documentation of related pattern, but these special software great majority are only for the wider design software of some level of application, compatibility is not strong, adopts simultaneously the expense of special software generally higher.
In existing mode, there is following technical matters in the chip mounter material detailed data that the chip mounter operating personnel are right when carrying out conversion process:
1, for the shirtsleeve operation process, need to manually carry out repetitive operation, do not give full play to personnel's effect;
2, the layout of PCB becomes increasingly complex, and working out a program often needs thousands of coordinate items are operated on the position that pastes the corresponding format requirement, and personnel are easy to fatigue;
3, operating personnel very easily go wrong in this simple uninteresting operating process.
Summary of the invention
In view of this, the object of the present invention is to provide a kind of chip mounter program coordinate transformation method, solved that prior art exists only for the wider design software of some level of application, compatibility is not strong, if and adopt special software, expense is general higher technological deficiency again, it is detailed to be automatically converted to the program coordinate that meets certain rule request by the program coordinate detail with different-format and standard, thereby shortened the setup time of chip mounter program coordinate, improved the efficient, accuracy and the compatibility that program.
In order to realize the foregoing invention purpose, the present invention specifically provides a kind of technic relization scheme of chip mounter program coordinate transformation method, and a kind of chip mounter program coordinate transformation method may further comprise the steps:
(A) obtain the detailed raw data of chip mounter program, determine the physical significance of each data item in the detailed raw data of chip mounter program, the detailed raw data of described chip mounter program distributes according to row and column, and formation tables of data, tables of data is comprised of cell, the row or column of tables of data is corresponding to the different physical of same type device, and the column or row of tables of data are corresponding to the identical parameter value of dissimilar devices;
(B) from the detailed raw data of the chip mounter program of confirming, read corresponding data item according to the target data form, described data item is carried out coordinate conversion, obtain the target program detailed data, described target program detailed data distributes according to row and column, and formation tables of data, tables of data is comprised of cell, and the row or column of tables of data is corresponding to the different physical of same device, and the column or row of tables of data are corresponding to the identical parameter value of different components.
Preferably, read corresponding data item according to the target data form from the detailed raw data of the chip mounter program of confirming among the described step B, described data item is carried out coordinate conversion, the process that obtains the target program detailed data further may further comprise the steps:
(B1) carry out the definition of each variable in the program;
(B2) each variable in the program is carried out initialization operation;
(B3) carry out the gauge outfit replicate run;
(B4) calculate the columns that the target program detailed data relates to according to the physical significance type of each data item in the tables of data of the detailed raw data of chip mounter program, a kind of physical data type in the detailed raw data of the corresponding chip mounter program of each column data;
(B5) enter master routine, according to columns data are carried out a datacycle line by line and launch operation, every data line is corresponding to the assignment of same device;
(B6) read in first row data corresponding to item, the separator in the detailed raw data item of chip mounter program is launched, will contain again by column recursive copying expansion of data corresponding in the item of this separator, until the separator detection is complete;
(B7) the recursive copying expanding data that each item is corresponding writes in the array by row line by line;
(B8) repeated execution of steps (B6) until the data of all row write array, writes the data in all arrays the cell of the tables of data of target program detailed data to step (B7) again.
Preferably, the tables of data of described target program detailed data is divided into the corresponding item of each device of first row by row, and all the other each row represent respectively corresponding material code, title, specifications and models and the quantity information of including but not limited to of corresponding item device at interior wherein one or more parameter values.
Preferably, the separator in the described step (B6) comprises common separator ", " number, and described common separator ", " number is separated the discontinuous item of the same class device that relates in the detailed raw data of described chip mounter program.
Preferably, the separator in the described step (B6) also comprises continuous separator "～" number, and described continuous separator "～" number is separated the continuous item of the same class device that relates in the detailed raw data of described chip mounter program.
Preferably, in described step (B6), if run into common separator ", " number is arranged in the cell, the item of common separator ", " number then will be arranged separately, write respectively array; If run into continuous separator "～" number is arranged in the cell, then with item that "～" symbol arranged in the cell separately, item is write respectively array successively according to serial number; If there is not symbol in the cell, then directly this item is write array.
Preferably, run into when continuous separator "～" number is arranged in the cell described, if item comprises two when alphabetical, the serial number value of described item is got the 3rd bit value and is calculated.
Preferably, in described step (B3), with the gauge outfit data Replica of cell A1:F2 to cell K1:P2.
Preferably, in described step (B4), begin to calculate columns from cell C5.
Preferably, chip mounter program coordinate transformation method adopts excel macro to work out.
A kind of chip mounter program coordinate transformation method that provides by implementing the invention described above has following technique effect:
1, the present invention can automatically convert chip mounter material raw data to and meet that chip mounter reads, the target material detailed data of processing requirements, need not manually to carry out repetitive operation, given full play to personnel's effect, operating personnel have been freed from the heavy simple duplication of labour;
2, the present invention can be automatically converted to the program coordinate detailed data that meets certain rule request with the program coordinate detail that different-format and different specification require according to different call formats, thereby shortened the setup time of chip mounter program coordinate, data handling procedure all realizes robotization, and be difficult for makeing mistakes, significantly improved efficient and the accuracy of detailed data conversion.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, the below will do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art, apparently, accompanying drawing in the following describes only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the program flow diagram of a kind of embodiment of chip mounter program coordinate transformation method of the present invention.
Fig. 2 is the program flow diagram of detailed data expansion process in a kind of embodiment of chip mounter program coordinate transformation method of the present invention.
Fig. 3 is the program flow diagram of separator testing process in a kind of embodiment of chip mounter program coordinate transformation method of the present invention.
Embodiment
For quote and know for the purpose of, with the technical term that hereinafter uses, write a Chinese character in simplified form or abridge and be described below:
PCB:Printed Circuit Board, the abbreviation of printed-wiring board (PWB);
SMT:Surface Mounted Technology, the abbreviation of surface mounting technology;
BOM:Bill of Material, the abbreviation of Bill of Material (BOM), it is the product structure data file that computing machine can be identified, also be ERP(Enterprise Resource Planning, the abbreviation of Enterprise Resources Plan) master document, BOM makes the system identification product structure, also is contact and the tie of linking up the every business of enterprise.
For the purpose, technical scheme and the advantage that make the embodiment of the invention clearer, below in conjunction with the accompanying drawing in the embodiment of the invention, technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is a part of embodiment of the present invention, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that obtains under the creative work prerequisite.
To shown in the accompanying drawing 3, provided the specific embodiment of a kind of chip mounter program of the present invention coordinate transformation method such as accompanying drawing 1, the invention will be further described below in conjunction with the drawings and specific embodiments.
The embodiment of a kind of chip mounter program coordinate transformation method as shown in Figure 1 may further comprise the steps:
(A) obtain the detailed raw data of chip mounter program, determine the physical significance of each data item in the detailed raw data of chip mounter program, the detailed raw data of chip mounter program distributes according to row and column, and formation tables of data, tables of data is comprised of cell, the row or column of tables of data is corresponding to the different physical of same type device, and the column or row of tables of data are corresponding to the identical parameter value of dissimilar devices;
(B) from the detailed raw data of the chip mounter program of confirming, read corresponding data item according to the target data form, described data item is carried out coordinate conversion, obtain the target program detailed data, the target program detailed data distributes according to row and column, and formation tables of data, tables of data is comprised of cell, and the row or column of tables of data is corresponding to the different physical of same device, and the column or row of tables of data are corresponding to the identical parameter value of different components.
Need to prove that here the meaning of row and column representative can be exchanged in the detailed raw data of chip mounter program and the target program detailed data.That is to say that in following table 1, the row in the detailed raw data of chip mounter program and the target program detailed data represents the different physical of same type device, and the identical parameter value of the dissimilar devices of row representative.Equally, embodiment also can adopt the identical parameter value of the dissimilar devices of row representative in the detailed raw data of chip mounter program and the target program detailed data, and row represent the various ways such as different physical of same type device, as required arbitrarily conversion.So the scope that the present invention asks for protection includes but not limited to mode cited in the embodiment.
As mentioned above, it is detailed that the program coordinate detail that the technical scheme that the specific embodiment of the invention is described requires different-format and different specification by programming is automatically converted to the program coordinate that meets certain rule request, reach the setup time that shortens chip mounter program coordinate, the efficient that raising programs and the dual purpose of accuracy.
As a kind of typical embodiment of the present invention, chip mounter program coordinate transformation method adopts excel macro to work out.Excel macro is actually one section VB(Visual Basic that is embedded among the Excel) program.This embedding program (grand) can produce automatically with the writing function that Excel carries, and also can be write by the user in the VB program interface that embeds, and realizes the automatic operation of various Excel tables.Grand is an instruction set, is used for telling that Excel comes the action of completing user appointment.The grand computer program that is similar to, but it is to run on fully among the Excel, can finish uninteresting, repetitive operation frequently with grand.The speed of grand execution is more faster than user do-it-yourself.Excel is the spreadsheet in the Office of the Microsoft office process software.The technical scheme that the specific embodiment of the invention is described is by one section program coordinate conversion program of establishment, and in the embedding excel macro, and can improve according to the format characteristic of software corresponding macroprogram, the program coordinate detail of different-format and different specification requirement is automatically converted to the program coordinate detail that meets certain rule request, thereby shortened the setup time of chip mounter program coordinate, significantly improved the efficient and the accuracy that program.
Read corresponding data item according to the target data form from the detailed raw data of the chip mounter program of confirming among the above-mentioned steps B, data item is carried out coordinate conversion, the process that obtains the target program detailed data further may further comprise the steps:
(B1) carry out the definition of each variable in the program;
(B2) each variable in the program is carried out initialization operation;
(B3) carry out the gauge outfit replicate run;
(B4) calculate the columns that the target program detailed data relates to according to the physical significance type of each data item in the tables of data of the detailed raw data of chip mounter program, a kind of physical data type in the detailed raw data of the corresponding chip mounter program of each column data;
(B5) enter master routine, according to columns data are carried out a datacycle line by line and launch operation, every data line is corresponding to the assignment of same device;
(B6) read in first row data corresponding to item, the separator in the detailed raw data item of chip mounter program is launched, will contain again by column recursive copying expansion of data corresponding in the item of this separator, until the separator detection is complete;
(B7) the recursive copying expanding data that each item is corresponding writes in the array by row line by line;
(B8) repeated execution of steps (B6) until the data of all row write array, writes the data in all arrays the cell of the tables of data of target program detailed data to step (B7) again.
Wherein, the detailed data expansion process program flow diagram in the chip mounter program coordinate transformation method as shown in Figure 2.
The tables of data of target program detailed data is divided into the corresponding item of each device of first row by row, and all the other each row represent respectively corresponding material code, title, specifications and models and the quantity information of including but not limited to of corresponding item device at interior wherein one or more parameter values.
Separator in the above-mentioned steps (B6) comprises common separator ", " number, and common separator ", " number is separated the discontinuous item of the same class device that relates in the detailed raw data of chip mounter program.Separator in the above-mentioned steps (B6) also comprises continuous separator "～" number, and separator "～" number is separated the continuous item of the same class device that relates in the detailed raw data of chip mounter program continuously.As shown in Figure 3, in step (B6), if run into common separator ", " number is arranged in the cell, the item of common separator ", " number then will be arranged separately, write respectively array.If run into continuous separator "～" number is arranged in the cell, then with item that "～" symbol arranged in the cell separately, item is write respectively array successively according to serial number.If there is not symbol in the cell, then directly this item is write array.
When continuous separator "～" number was arranged in running into cell, if item comprises two when alphabetical, the serial number value of item was got the 3rd bit value and is calculated.Reason is, item in the chip mounter program detailed data generally has its particular meaning, represent electric capacity such as C, L represents inductance, part of devices needs to adopt two letter representations sometimes, the electric capacity of using in the chip mounter program detailed data, inductance quantity great majority are for a plurality of, so the expression modes such as C1, C2, CC1, CC7 are arranged.
As a kind of typical embodiment of the present invention, as shown in table 2 below, in step (B3), with the gauge outfit data Replica of cell A1:F2 to cell K1:P2.In step (B4), begin to calculate columns from cell C5.In concrete operating process; the start address that gauge outfit copies and destination address; and the initial calculation cell of columns can adjust flexibly according to concrete needs and requirement, and the content that the present invention asks for protection includes but not limited to the concrete Numerical examples enumerated in the embodiment.
Below by the detailed operating process of enumerating an instantiation explanation chip mounter program coordinate transformation method of the present invention.
The detailed raw data of a concrete chip mounter program is as shown in table 1 below:
Table 1
Piece number: the position at the detailed place of representation program.
Code name: the numbering of representation element device.
Material class number: to the only authentication code of material recognition.
Model specification: a series of indexs of reflection components and parts performance, character, quality.
As shown in table 2 below, the detailed raw data of the program of confirming is read corresponding data item according to the target data form.
Table 2
Move program coordinate conversion program prepared in advance, obtain the target program detailed data.Of particular note, the example of lifting here is a very simple application, and actual production process program detailed data is very huge.Can demonstrate fully the huge superiority that adopts the described technical scheme of chip mounter program coordinate transformation method embodiment of the present invention to bring by this example.
The target program detailed data that obtains after the chip mounter program coordinate transformation method processing of the present invention that adopts for the detailed raw data of chip mounter program as shown in table 3 below.
Table 3
| Code name | Material class number | Title | Model specification | Quantity |
| U1 | W600000059 | The SMD integrated regulator | MC7805ABD2TG | 1 |
| U3 | W67205044233G | The SMD driver | MIC4426YM | 1 |
| C1 | W57141256221 | The SMD capacitor | 12063C225KAT2A | 1 |
| C2 | W57141256221 | The SMD capacitor | 12063C225KAT2A | 1 |
| C3 | W57141506470G | The SMD monolithic capacitor | 12105C475KAT2A | 1 |
| C13 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C14 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C15 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C16 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C17 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C18 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C19 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C20 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C21 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C22 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
| C23 | W57141257100 | The SMD monolithic capacitor | CT41G-1210-2X1-25V-106KN | 1 |
Below by one section concrete coordinate conversion source program example, illustrate how from the detailed raw data of the program of confirming, to read corresponding data item according to the target data form, be converted to the process of target program detailed data.
Sub?SMT()
Dim?x，y，i，n，m，sum，L，P，S，Q，sum2?As?Integer
Dim?Rng?As?Range
Dim?Strfind?As?String
Dim?Rng2?As?Range
Dim?Arry?As?Variant
Dim Arry2 As Variant//variable-definition
i=0
n=0
L=0
P=1
S=1
X=0//variable initialize
Range(" K1:P2 ") .Value=Range(" A1:F2 ") .Value//expression copies to the A1:F2 gauge outfit among the K1:P2; As above shown in the table 2; the content of A1:F2 is a kind of set form of embodiment design document; this is a kind of set form of each enterprises BOM file, and embodiment describes with this form, and the content that the present invention asks for protection includes but not limited to this embodiment.
ActiveSheet.Range(" C5 ") .Select//expression begins to calculate columns from cell C5; As above shown in the table 2; this also is a kind of set form of each enterprises BOM file; its data that need to launch are from the fifth line of form, and embodiment describes with this form, and the content that the present invention asks for protection includes but not limited to this embodiment.
Selection.End(xlDown) .Select//chosen when last substantial cells of row
Set Rng2=Selection.Offset(0 ,-1) // value of Rng2 is set
Y=Mid(Rng2.Address(0,0), 2) // carry out assignment for y
" implication of said procedure is for calculating columns
" following is master routine, represents that every row once circulate
Forx=0?To?(y-3)
" with the item in the cell separately, write respectively array
Strfind=Trim(Rng2.Offset(-x, 0) .Value) // carry out assignment for Strfind
Arry=Split (Strfind, ", ") // expression will have in the cell ", " item of symbol separately writes respectively array; As above shown in the table 1, the item in the design document represents it is C1, and C2 just need to be launched into two row at the data message of programming, and the retrieval symbol of expansion process is exactly ", " number.
Sum2=UBound(Arry) // carry out assignment for sum2
The For i=0 To sum2//content that does not have symbol in the array is copied;
" to array contain～content of symbol copies;
If?Len（Arry（i)）>4?Then
Arry2=Split(Arry(i), "～") // represent to write respectively array with there being the item of "～" symbol to separate in the cell;
If " position comprises two letters, and then M need get the 3rd;
Sum=0//this section source code represents to contain in the item two letters, and then M gets the 3rd character, and such as CC4, the M value is " 3 " just; This be because, the item symbol in the designing BOM file generally has its particular meaning, represents electric capacity such as C, L represents inductance, some device needs sometimes with two letter representations, and the capacitor and inductor quantity of using among BOM great majority are for a plurality of, so C1 is arranged, C2, CC1, the expression mode of CC7.
" according to M be listed as to condition be respectively L, N, O, P row assignment
" for choosing when prostatitis (the prostatitis of working as here is exactly the M row) colleague's different lines assignment
In the above-mentioned source program:
A, Range (" K1:P2 ") .Value=Range (" A1:F2 ") .Value represents the A1:F2 gauge outfit is copied among the K1:P2;
B, ActiveSheet.Range (" C5 ") .Select represents to begin to calculate columns from cell C5;
C, Arry=Split (Strfind, ", ") expression will have in the cell ", " item of symbol separately writes respectively array;
D, this circulation of For i=0 To sum2 are with copying of not meeting in the array;
E, Arry2=Split(Arry(i), "～") represent to write respectively array with there being the item of "～" symbol to separate in the cell;
F, (If UCase(Mid(Arry2(0), 2,1))=" A " AndUCase(Mid(Arry2(0), 2,1))＜=" Z " Then; M=Mid (Arry2(1), 3,4) – Mid(Arry2(0), 3,4); Else:m=Mid(Arry2(1), 2,4)-Mid(Arry2(0), 2,4); End If; Sum=0) this section source code represents to contain in the item two letters, and then M gets the 3rd character, and such as CC4, the M value is " 3 " just;
G, this circulation of For P=1To4 are to meet copying of "～" in the array.
Can find out from above code, mainly be that the requirement of the detailed primitive data item of program according to programming launched data in the process of carrying out chip mounter program coordinate conversion, this is a kind of duplication of labour in actual production, exist this duplication of labour will produce waste, comprise the waste of time and human resources.Therefore, the conversion method of utilizing the specific embodiment of the invention to provide can realize the data-switching of other types, thereby significantly shorten the construction cycle of chip mounter program making process, and the speed of the detailed coordinate conversion of raising program, and reduce the probability that makes a mistake in the coordinate conversion process.In actual application, the detailed coordinate format of the PCB material of each design department's output may there are differences, because the physical meaning of detailed each the data item representative of coordinate of material is can be predetermined, therefore as long as from the detailed raw data of the program of confirming, read corresponding data item operation program coordinate conversion program prepared in advance according to the target data form, just obtain the target program detailed data.
Each embodiment adopts the mode of going forward one by one to describe in this instructions, and what each embodiment stressed is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.
The above only is preferred embodiment of the present invention, is not the present invention is done any pro forma restriction.Although the present invention discloses as above with preferred embodiment, yet is not to limit the present invention.Any those of ordinary skill in the art, in the situation that does not break away from Spirit Essence of the present invention and technical scheme, all can utilize method and the technology contents of above-mentioned announcement that technical solution of the present invention is made many possible changes and modification, or be revised as the equivalent embodiment of equivalent variations.Therefore, every content that does not break away from technical solution of the present invention, any simple modification of above embodiment being done according to technical spirit of the present invention, be equal to replacements, equivalence changes and modify, all still belong in the scope that technical solution of the present invention protects.
Claims (10)
1. a chip mounter program coordinate transformation method is characterized in that, may further comprise the steps:
(A) obtain the detailed raw data of chip mounter program, determine the physical significance of each data item in the detailed raw data of chip mounter program, the detailed raw data of described chip mounter program distributes according to row and column, and formation tables of data, tables of data is comprised of cell, the row or column of tables of data is corresponding to the different physical of same type device, and the column or row of tables of data are corresponding to the identical parameter value of dissimilar devices;
(B) from the detailed raw data of the chip mounter program of confirming, read corresponding data item according to the target data form, described data item is carried out coordinate conversion, obtain the target program detailed data, described target program detailed data distributes according to row and column, and formation tables of data, tables of data is comprised of cell, and the row or column of tables of data is corresponding to the different physical of same device, and the column or row of tables of data are corresponding to the identical parameter value of different components.
2. a kind of chip mounter program coordinate transformation method according to claim 1, it is characterized in that, from the detailed raw data of the chip mounter program of confirming, read corresponding data item according to the target data form among the described step B, described data item is carried out coordinate conversion, and the process that obtains the target program detailed data further may further comprise the steps:
(B1) carry out the definition of each variable in the program;
(B2) each variable in the program is carried out initialization operation;
(B3) carry out the gauge outfit replicate run;
(B4) calculate the columns that the target program detailed data relates to according to the physical significance type of each data item in the tables of data of the detailed raw data of chip mounter program, a kind of physical data type in the detailed raw data of the corresponding chip mounter program of each column data;
(B5) enter master routine, according to columns data are carried out a datacycle line by line and launch operation, every data line is corresponding to the assignment of same device;
(B6) read in first row data corresponding to item, the separator in the detailed raw data item of chip mounter program is launched, will contain again by column recursive copying expansion of data corresponding in the item of this separator, until the separator detection is complete;
(B7) the recursive copying expanding data that each item is corresponding writes in the array by row line by line;
(B8) repeated execution of steps (B6) until the data of all row write array, writes the data in all arrays the cell of the tables of data of target program detailed data to step (B7) again.
3. a kind of chip mounter program coordinate transformation method according to claim 2, it is characterized in that: the tables of data of described target program detailed data is divided into the corresponding item of each device of first row by row, and all the other each row represent respectively corresponding material code, title, specifications and models and the quantity information of including but not limited to of corresponding item device at interior wherein one or more parameter values.
4. according to claim 2 or 3 described a kind of chip mounter program coordinate transformation methods, it is characterized in that: the separator in the described step (B6) comprise common separator "; " number, described common separator ", " number is separated the discontinuous item of the same class device that relates in the detailed raw data of described chip mounter program.
5. a kind of chip mounter program coordinate transformation method according to claim 4, it is characterized in that: the separator in the described step (B6) also comprises continuous separator "～" number, and described continuous separator "～" number is separated the continuous item of the same class device that relates in the detailed raw data of described chip mounter program.
6. a kind of chip mounter program coordinate transformation method according to claim 5 is characterized in that: in described step (B6), if run into have in the cell common separator "; " number, the item of common separator ", " number then will be arranged separately, write respectively array; If run into continuous separator "～" number is arranged in the cell, then with item that "～" symbol arranged in the cell separately, item is write respectively array successively according to serial number; If there is not symbol in the cell, then directly this item is write array.
7. according to claim 5 or 6 described a kind of chip mounter program coordinate transformation methods, it is characterized in that: run into when continuous separator "～" number is arranged in the cell described, if item comprises two when alphabetical, the serial number value of described item is got the 3rd bit value and is calculated.
8. according to claim 2, the described a kind of chip mounter program coordinate transformation method of arbitrary claim in 3,4,6, it is characterized in that: in described step (B3), with the gauge outfit data Replica of cell A1:F2 to cell K1:P2.
9. a kind of chip mounter program coordinate transformation method according to claim 8 is characterized in that: in described step (B4), begin to calculate columns from cell C5.
10. according to claim 2, the described a kind of chip mounter program coordinate transformation method of arbitrary claim in 3,4,6,9, it is characterized in that: chip mounter program coordinate transformation method adopts excel macro to work out.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310270034.8A CN103377050B (en) | 2013-06-28 | 2013-06-28 | A kind of chip mounter program coordinate transformation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310270034.8A CN103377050B (en) | 2013-06-28 | 2013-06-28 | A kind of chip mounter program coordinate transformation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103377050A true CN103377050A (en) | 2013-10-30 |
| CN103377050B CN103377050B (en) | 2016-05-25 |
Family
ID=49462214
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310270034.8A Expired - Fee Related CN103377050B (en) | 2013-06-28 | 2013-06-28 | A kind of chip mounter program coordinate transformation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103377050B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109885286A (en) * | 2019-01-27 | 2019-06-14 | 东莞新技电子有限公司 | A kind of outer Programming method of the program line of Panasonic's plug-in machine |
| CN110235108A (en) * | 2018-08-02 | 2019-09-13 | 深圳欣锐科技股份有限公司 | A kind of patch program check method, terminal device and computer readable storage medium |
| CN112329375A (en) * | 2020-10-22 | 2021-02-05 | 上海望友信息科技有限公司 | Design method and device of mounting program ECN, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1960624A (en) * | 2006-08-23 | 2007-05-09 | 上海广联电子有限公司 | Programmable control method for pasting chips for machine of pasting chips |
| CN101684999A (en) * | 2008-09-25 | 2010-03-31 | 比亚迪股份有限公司 | Conversion method of data format |
| US8156509B2 (en) * | 2007-06-05 | 2012-04-10 | International Business Machines Corporation | Exchanging data using data transformation |
-
2013
- 2013-06-28 CN CN201310270034.8A patent/CN103377050B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1960624A (en) * | 2006-08-23 | 2007-05-09 | 上海广联电子有限公司 | Programmable control method for pasting chips for machine of pasting chips |
| US8156509B2 (en) * | 2007-06-05 | 2012-04-10 | International Business Machines Corporation | Exchanging data using data transformation |
| CN101684999A (en) * | 2008-09-25 | 2010-03-31 | 比亚迪股份有限公司 | Conversion method of data format |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110235108A (en) * | 2018-08-02 | 2019-09-13 | 深圳欣锐科技股份有限公司 | A kind of patch program check method, terminal device and computer readable storage medium |
| CN109885286A (en) * | 2019-01-27 | 2019-06-14 | 东莞新技电子有限公司 | A kind of outer Programming method of the program line of Panasonic's plug-in machine |
| CN112329375A (en) * | 2020-10-22 | 2021-02-05 | 上海望友信息科技有限公司 | Design method and device of mounting program ECN, electronic equipment and storage medium |
| CN112329375B (en) * | 2020-10-22 | 2023-09-01 | 上海望友信息科技有限公司 | Design method and device for mounting program ECN, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103377050B (en) | 2016-05-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100474318C (en) | Automatic generation system for designing BOM | |
| CN102682166A (en) | SMT (Surface Mounted Technology) equipment rapid processing system and method | |
| CN102087594B (en) | Management method and device for extension point and plugins | |
| CN102087597A (en) | J2EE and component set-based visualized development platform | |
| CN105447246A (en) | Method and system for generating electrical principle diagram through one key | |
| US20110040531A1 (en) | Method and System for Identification of Grouping Characteristics | |
| CN102707669B (en) | Method for constructing CAM (computer-aided manufacturing) system for punching for automobile girders | |
| CN103605845A (en) | Machine tool fixture library management system based on assembling knowledge description | |
| CN104985939A (en) | Laser marking machine control method and laser marking machine | |
| CN103377050A (en) | SMT (surface mounted technology) machine program coordinate transformation method | |
| CN102521427B (en) | ProE-based simple hole table array automatic modeling method | |
| CN101908215B (en) | Spatial data fusing method | |
| CN101908081B (en) | Circuit auxiliary design method and system | |
| CN109543327B (en) | Method and device for placing parts in PCB design | |
| US9323880B2 (en) | Apparatus and method for file translation | |
| CN110502735B (en) | Method and system for quickly manufacturing universal process file of electronic equipment | |
| CN105335141A (en) | Image processing method and apparatus | |
| CN106775779A (en) | A kind of automatic method for assigning via net attributes in Allegro softwares | |
| CN101131709B (en) | Distributed circuit layout character face processing method and system thereof | |
| CN102779036B (en) | For the Software tool of automatic technology | |
| CN110989999A (en) | Code generation method and device, electronic equipment and medium | |
| CN109117431B (en) | System and method for merging source data from a source application to target data of a target application | |
| US7562317B2 (en) | Multitasking circuit layout diagram silkscreen text handling method and system | |
| CN106557312B (en) | Program development support device and program development support software | |
| CN101414313A (en) | Line layout system and method |
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: 20160525 Termination date: 20200628 |