CN106202022A - A kind of solder joint data processing method and system - Google Patents
A kind of solder joint data processing method and system Download PDFInfo
- Publication number
- CN106202022A CN106202022A CN201610571056.1A CN201610571056A CN106202022A CN 106202022 A CN106202022 A CN 106202022A CN 201610571056 A CN201610571056 A CN 201610571056A CN 106202022 A CN106202022 A CN 106202022A
- Authority
- CN
- China
- Prior art keywords
- solder joint
- data
- joint data
- excel
- module
- 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
- 229910000679 solder Inorganic materials 0.000 title claims abstract description 306
- 238000003672 processing method Methods 0.000 title claims abstract description 16
- 238000000034 method Methods 0.000 claims abstract description 48
- 238000003466 welding Methods 0.000 claims abstract description 42
- 238000006243 chemical reaction Methods 0.000 claims abstract description 32
- 238000012800 visualization Methods 0.000 claims abstract description 31
- 238000012545 processing Methods 0.000 claims description 27
- 230000008676 import Effects 0.000 claims description 25
- 238000011112 process operation Methods 0.000 claims description 13
- 238000012360 testing method Methods 0.000 claims description 8
- 238000004883 computer application Methods 0.000 abstract description 2
- 239000002131 composite material Substances 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Manufacturing & Machinery (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of solder joint data processing method and system, method includes: for the newly-built EXCEL masterplate of solder joint data, EXCEL masterplate is the solder joint tables of data of conformance with standard form；Judging the software type that the source data of solder joint data is currently located, then complete solder joint data in cooperation EXCEL masterplate CATIA module, EXCEL module or ROBCAD module in visualization interface automatically processes operation；Data conversion requirements according to solder joint data calls the digital-to-analogue data conversion module in visualization interface and carries out digital-to-analogue data conversion.The present invention has filled up the blank of solder joint data processing software exploitation, the beneficially standardized management of solder joint data；Function covers butt welding point data in being typically designed and emulating and carries out the requirement processed, and more comprehensively, and it is strong to have provided the user good visualization interface, versatility and interactivity, easy to use.The composite can be widely applied to welding data process and computer application field.
Description
Technical field
The present invention relates to welding data process and computer application field, especially a kind of solder joint data processing method and be
System.
Background technology
In the process industry of various products, spot welding is a kind of highly important technique, particularly at automobile manufacturing field.
About more than 4000 solder joint of each car, on vehicle body, the welding of 90% is all a weld through, therefore the whether accurate of spot welding data directly affects
Quality to product.And in the same project of spot-welding technology, the embodiment of the different technologies personnel's butt welding point data shared out the work and helped one another
The substantive requirements of form are different but must often link up with others skilled in the art with regard to solder joint data, and same technical staff is in difference
In the case of also tend to need solder joint data to embody in different forms.This results in solder joint data needs continually with various
Form is mutually changed between various softwares and transmits.
The software that the most special butt welding point data carry out changing and processing more lacks.Although currently existing some butt welding
Point data carries out the macroprogram processed, but these program versatilities and interactivity are poor, and the requirement to user's professional ability is higher, and
Its function singleness, it is difficult to meet the data handling requirements of spot-welding technology.
Summary of the invention
For solving above-mentioned technical problem, it is an object of the invention to: provide a kind of versatility and interactivity is strong, comprehensively, make
By convenient and the solder joint data processing method of high treating effect.
Another object of the present invention is to: a kind of property is provided and interactivity is good, easy, comprehensive and the weldering of high treating effect
Point data processing system.
The technical solution used in the present invention is:
A kind of solder joint data processing method, comprises the following steps:
For the newly-built EXCEL masterplate of solder joint data, described EXCEL masterplate is the solder joint tables of data of conformance with standard form；
Judge the software type that the source data of solder joint data is currently located, then coordinate EXCEL masterplate in visualization interface
Complete solder joint data in CATIA module, EXCEL module or ROBCAD module automatically processes operation；
The digital-to-analogue data conversion module that data conversion requirements according to solder joint data calls in visualization interface carries out digital-to-analogue data
Conversion.
Further, the described software type being currently located according to solder joint data and EXCEL masterplate, in visualization interface
CATIA module, EXCEL module or ROBCAD module complete the step for of automatically processing operation of solder joint data, comprising:
Judge the software type that the source data of solder joint data is currently located；
Forward the corresponding module in visualization interface to according to the result judged and carry out automatically processing of solder joint data: if solder joint data
The software that is currently located of source data be CATIA software, then with CATIA module EXCEL masterplate complete solder joint data from
Dynamic process operates；If the software that the source data of solder joint data is currently located is EXCEL software, then completed solder joint by EXCEL module
Data automatically process operation；If the software that the source data of solder joint data is currently located is ROBCAD software, then by ROBCAD mould
Block coordinates what EXCEL masterplate completed solder joint data to automatically process operation.
Further, described with CATIA module EXCEL masterplate complete solder joint data automatically process operation this step
Suddenly, comprising:
In CATIA, under Part file, all visible points, as the centre of sphere, generate corresponding solder balls；
In identification CATIA, all visible solder balls spheres under Part file, obtain centre of sphere point；
All visible point coordinates in CATIA current window is exported in the form of EXCEL masterplate；
The txt file derived after solder balls in CATIA and bodywork are carried out interference checking carries out welding parameter process,
Obtain the plate numbering that each solder balls is connected.
Further, described completed the step for of automatically processing operation of solder joint data by EXCEL module, comprising:
The generation point in CATIA can be imported to according to the solder joint data genaration in EXCEL masterplate；
The solder joint data genaration extracted in EXCEL masterplate can import to the .pt formatted file in ROBCAD；
Welding gun digital-to-analogue according to the solder joint data in EXCEL masterplate and CATIA generates plugs in rifle figure；
For EXCEL masterplate has distributed the solder joint data genaration solder balls 3D Flowchart of station and robot；
Rename for the solder joint data in EXCEL masterplate, and filter out the solder joint of symmetry, make the numbering of symmetrical solder joint identical and
The most adjacent；
The solder joint data genaration extracted in EXCEL masterplate can import to the .csv formatted file in PD；
Solder joint data in EXCEL masterplate are carried out solder joint iterative testing；
The solder joint data that solder joint data in EXCEL masterplate carry out different editions compare.
Further, described with ROBCAD module EXCEL masterplate complete solder joint data automatically process operation this step
Suddenly, comprising:
The solder joint data derived by ROBCAD import in EXCEL masterplate after txt file replicates again；
The solder joint data derived by ROBCAD are directly generated by txt file after txt file replicates again and can import in ROBCAD
.pt formatted file；
The solder joint data derived by ROBCAD combine the welding gun digital-to-analogue of CATIA after txt file preserves and directly generate plug in rifle figure.
Further, the conversion of described digital-to-analogue data includes but not limited to: be converted into by cgr or the CATPart file of CATIA
The .co formatted file of ROBCAD；Cgr or the CATPart file of CATIA is converted into the .cojt formatted file of PD；By ROBCAD
.co formatted file be converted to the .cojt formatted file of PD.
What the present invention was taked another solution is that
A kind of solder joint data handling system, including:
Standard form builds module, and for for the newly-built EXCEL masterplate of solder joint data, described EXCEL masterplate is conformance with standard
The solder joint tables of data of form；
Automatic business processing module, for judging the software type that the source data of solder joint data is currently located, then coordinates EXCEL mould
What version completed solder joint data in CATIA module, EXCEL module or ROBCAD module in visualization interface automatically processes behaviour
Make；
Modular converter, for calling the digital-to-analogue data conversion module in visualization interface according to the data conversion requirements of solder joint data
Carry out digital-to-analogue data conversion.
Further, described modular converter includes:
Judging unit, for judging the software type that the source data of solder joint data is currently located；
Automatically process unit, for according to judge result forward to the corresponding module in visualization interface carry out solder joint data from
Dynamic process: if the software that the source data of solder joint data is currently located is CATIA software, then EXCEL masterplate with CATIA module
Complete solder joint data automatically processes operation；If the software that the source data of solder joint data is currently located is EXCEL software, then by
What EXCEL module completed solder joint data automatically processes operation；If the software that the source data of solder joint data is currently located is ROBCAD
Software, then with ROBCAD module EXCEL masterplate complete solder joint data automatically process operation.
Further, described in automatically process unit being completed when automatically processing operation of solder joint data by EXCEL module, will hold
The following operation of row:
In CATIA, under Part file, all visible points, as the centre of sphere, generate corresponding solder balls；
In identification CATIA, all visible solder balls spheres under Part file, obtain centre of sphere point；
All visible point coordinates in CATIA current window is exported in the form of EXCEL masterplate；
The txt file derived after solder balls in CATIA and bodywork are carried out interference checking carries out welding parameter process,
Obtain the plate numbering that each solder balls is connected.
Further, described in automatically process unit being completed when automatically processing operation of solder joint data by EXCEL module, will hold
The following operation of row:
The generation point in CATIA can be imported to according to the solder joint data genaration in EXCEL masterplate；
The solder joint data genaration extracted in EXCEL masterplate can import to the .pt formatted file in ROBCAD；
Welding gun digital-to-analogue according to the solder joint data in EXCEL masterplate and CATIA generates plugs in rifle figure；
For EXCEL masterplate has distributed the solder joint data genaration solder balls 3D Flowchart of station and robot；
Rename for the solder joint data in EXCEL masterplate, and filter out the solder joint of symmetry, make the numbering of symmetrical solder joint identical and
The most adjacent；
The solder joint data genaration extracted in EXCEL masterplate can import to the .csv formatted file in PD；
Solder joint data in EXCEL masterplate are carried out solder joint iterative testing；
The solder joint data that solder joint data in EXCEL masterplate carry out different editions compare.
The beneficial effects of the method for the present invention is: include template establishment, judge software type after automatically carry out solder joint data
Process and the step of digital-to-analogue data conversion, filled up the blank of current solder joint data processing software exploitation, for solder joint data
Automatically process and data transmission provides a whole set of solution, the beneficially standardized management of solder joint data；Visualization interface
Inside it is provided with CATIA module, EXCEL module or ROBCAD module software for completing automatic business processing operation and carries out digital-to-analogue
The digital-to-analogue data conversion module of data conversion, what function covered that butt welding point data in being typically designed and emulating carry out processing wants
Asking, more comprehensively, and it is strong to have provided the user good visualization interface, versatility and interactivity, easy to use, does not has user
There is special professional skill requirement.
The system of the present invention provides the benefit that: include that standard form builds module, automatic business processing module and conversion
Module, has filled up the blank of current solder joint data processing software exploitation, automatically processing and data transmission offer for solder joint data
A whole set of solution, the beneficially standardized management of solder joint data；It is provided with in visualization interface for completing at automatization
CATIA module, EXCEL module or the ROBCAD module software of managing operation and the digital-to-analogue data carrying out digital-to-analogue data conversion conversion
Module, function covers butt welding point data in being typically designed and emulating and carries out the requirement processed, and provides the user more comprehensively
Good visualization interface, versatility and interactivity are strong, easy to use, do not have a special professional skill requirement to user.
Accompanying drawing explanation
Fig. 1 is the overall flow figure of the present invention a kind of solder joint data processing method；
Fig. 2 is the visualization interface schematic diagram of the present invention；
Fig. 3 is the drop-down menu schematic diagram of CATIA module of the present invention；
Fig. 4 is the drop-down menu schematic diagram of EXCEL module of the present invention；
Fig. 5 is the drop-down menu schematic diagram of ROBCAD module of the present invention；
Fig. 6 is the drop-down menu schematic diagram of digital-to-analogue data conversion module of the present invention.
Detailed description of the invention
With reference to Fig. 1, a kind of solder joint data processing method, comprise the following steps:
For the newly-built EXCEL masterplate of solder joint data, described EXCEL masterplate is the solder joint tables of data of conformance with standard form；
Judge the software type that the source data of solder joint data is currently located, then coordinate EXCEL masterplate in visualization interface
Complete solder joint data in CATIA module, EXCEL module or ROBCAD module automatically processes operation；
The digital-to-analogue data conversion module that data conversion requirements according to solder joint data calls in visualization interface carries out digital-to-analogue data
Conversion.
It is further used as preferred embodiment, the described software type being currently located according to solder joint data and EXCEL mould
Version, complete solder joint data in CATIA module, EXCEL module or the ROBCAD module in visualization interface automatically processes behaviour
The step for of work, comprising:
Judge the software type that the source data of solder joint data is currently located；
Forward the corresponding module in visualization interface to according to the result judged and carry out automatically processing of solder joint data: if solder joint data
The software that is currently located of source data be CATIA software, then with CATIA module EXCEL masterplate complete solder joint data from
Dynamic process operates；If the software that the source data of solder joint data is currently located is EXCEL software, then completed solder joint by EXCEL module
Data automatically process operation；If the software that the source data of solder joint data is currently located is ROBCAD software, then by ROBCAD mould
Block coordinates what EXCEL masterplate completed solder joint data to automatically process operation.
Be further used as preferred embodiment, described with CATIA module EXCEL masterplate complete solder joint data from
The step for of dynamic process operation, comprising:
In CATIA, under Part file, all visible points, as the centre of sphere, generate corresponding solder balls；
In identification CATIA, all visible solder balls spheres under Part file, obtain centre of sphere point；
All visible point coordinates in CATIA current window is exported in the form of EXCEL masterplate；
The txt file derived after solder balls in CATIA and bodywork are carried out interference checking carries out welding parameter process,
Obtain the plate numbering that each solder balls is connected.
Be further used as preferred embodiment, described by EXCEL module complete solder joint data automatically process operation this
One step, comprising:
The generation point in CATIA can be imported to according to the solder joint data genaration in EXCEL masterplate；
The solder joint data genaration extracted in EXCEL masterplate can import to the .pt formatted file in ROBCAD；
Welding gun digital-to-analogue according to the solder joint data in EXCEL masterplate and CATIA generates plugs in rifle figure；
For EXCEL masterplate has distributed the solder joint data genaration solder balls 3D Flowchart of station and robot；
Rename for the solder joint data in EXCEL masterplate, and filter out the solder joint of symmetry, make the numbering of symmetrical solder joint identical and
The most adjacent；
The solder joint data genaration extracted in EXCEL masterplate can import to the .csv formatted file in PD；
Solder joint data in EXCEL masterplate are carried out solder joint iterative testing；
The solder joint data that solder joint data in EXCEL masterplate carry out different editions compare.
Be further used as preferred embodiment, described with ROBCAD module EXCEL masterplate complete solder joint data
The step for of automatically processing operation, comprising:
The solder joint data derived by ROBCAD import in EXCEL masterplate after txt file replicates again；
The solder joint data derived by ROBCAD are directly generated by txt file after txt file replicates again and can import in ROBCAD
.pt formatted file；
The solder joint data derived by ROBCAD combine the welding gun digital-to-analogue of CATIA after txt file preserves and directly generate plug in rifle figure.
Being further used as preferred embodiment, the conversion of described digital-to-analogue data includes but not limited to: by the cgr of CATIA or
CATPart file is converted into the .co formatted file of ROBCAD；Cgr or CATPart file by CATIA is converted into the .cojt of PD
Formatted file；The .co formatted file of ROBCAD is converted to the .cojt formatted file of PD.
With reference to Fig. 1, a kind of solder joint data handling system, including:
Standard form builds module, and for for the newly-built EXCEL masterplate of solder joint data, described EXCEL masterplate is conformance with standard
The solder joint tables of data of form；
Automatic business processing module, for judging the software type that the source data of solder joint data is currently located, then coordinates EXCEL mould
What version completed solder joint data in CATIA module, EXCEL module or ROBCAD module in visualization interface automatically processes behaviour
Make；
Modular converter, for calling the digital-to-analogue data conversion module in visualization interface according to the data conversion requirements of solder joint data
Carry out digital-to-analogue data conversion.
Being further used as preferred embodiment, described modular converter includes:
Judging unit, for judging the software type that the source data of solder joint data is currently located；
Automatically process unit, for according to judge result forward to the corresponding module in visualization interface carry out solder joint data from
Dynamic process: if the software that the source data of solder joint data is currently located is CATIA software, then EXCEL masterplate with CATIA module
Complete solder joint data automatically processes operation；If the software that the source data of solder joint data is currently located is EXCEL software, then by
What EXCEL module completed solder joint data automatically processes operation；If the software that the source data of solder joint data is currently located is ROBCAD
Software, then with ROBCAD module EXCEL masterplate complete solder joint data automatically process operation.
Be further used as preferred embodiment, described in automatically process unit and completed solder joint data by EXCEL module
When automatically processing operation, by following for execution operation:
In CATIA, under Part file, all visible points, as the centre of sphere, generate corresponding solder balls；
In identification CATIA, all visible solder balls spheres under Part file, obtain centre of sphere point；
All visible point coordinates in CATIA current window is exported in the form of EXCEL masterplate；
The txt file derived after solder balls in CATIA and bodywork are carried out interference checking carries out welding parameter process,
Obtain the plate numbering that each solder balls is connected.
Be further used as preferred embodiment, described in automatically process unit and completed solder joint data by EXCEL module
When automatically processing operation, by following for execution operation:
The generation point in CATIA can be imported to according to the solder joint data genaration in EXCEL masterplate；
The solder joint data genaration extracted in EXCEL masterplate can import to the .pt formatted file in ROBCAD；
Welding gun digital-to-analogue according to the solder joint data in EXCEL masterplate and CATIA generates plugs in rifle figure；
For EXCEL masterplate has distributed the solder joint data genaration solder balls 3D Flowchart of station and robot；
Rename for the solder joint data in EXCEL masterplate, and filter out the solder joint of symmetry, make the numbering of symmetrical solder joint identical and
The most adjacent；
The solder joint data genaration extracted in EXCEL masterplate can import to the .csv formatted file in PD；
Solder joint data in EXCEL masterplate are carried out solder joint iterative testing；
The solder joint data that solder joint data in EXCEL masterplate carry out different editions compare.
Below in conjunction with Figure of description and specific embodiment the present invention it is further explained and illustrates.
Embodiment one
Reference Fig. 1-Fig. 6, the first embodiment of the present invention:
Lack for prior art solder joint data processing software, versatility and interactivity poor in-convenience in use and function singleness
Deficiency, the present invention proposes a kind of solder joint data processing method and system, utilize design or simulation software etc. DLL or
Input-output file, completes solder joint data and completes the automatic place of data in the softwares such as CATIA, EXCEL and ROBCAD (or PD)
Reason, provides a whole set of scheme for the transmission between these softwares of the solder joint data.
The solder joint data processing method of the present invention mainly comprises the steps that
First, a standard masterplate is set up for the solder joint data form of expression in EXCEL.As in figure 2 it is shown, visualization interface bag
Containing menucommand " newly-built EXCEL masterplate ", for the solder joint tables of data of a newly-built conformance with standard form.
Then, it is currently located in which kind of software by source data, is divided in three modules and carries out automatic data processing: CATIA
Module, EXCEL module and ROBCAD module.These three module comprises following function respectively:
(1) CATIA module.
As it is shown on figure 3, CATIA module includes following functions:
1. a generation ball: using visible points all under Part file in CATIA as the centre of sphere, generate corresponding solder balls.
When point generates ball, first confirm that the solder joint data of solder balls to be generated, then a newly-built Part literary composition in CATIA
Part, copies under Part file by all of point, and finally by unnecessary point deletion or hiding, " point is raw to click on CATIA drop-down menu
Balling-up " after can pop-up dialogue box, user can input in this dialog box solder balls radius (wherein, hide point be left in the basket, no
Solder balls can be generated).
The present invention adds the geometric figure collection (figure of entitled " balls_ solder balls number " in the tree of Part file
In be not drawn into), its solder balls generated is all under this one-level, and the name of solder balls is corresponding with the name of solder joint, the most also
Unanimously.
2. ball extraction point: all visible spheres under Part file in identification CATIA, obtains centre of sphere point (hiding ball
Face is left in the basket).The present invention adds the geometric figure collection of entitled " points_ generates some number " in the tree of Part file
(being not drawn in figure), the centre of sphere point of Software Create is all under this one-level, and the name of centre of sphere point is corresponding with the name of sphere, suitable
Sequence is the most consistent.
3. point coordinates imports EXCEL: all visible point coordinates in CATIA current window is exported to Microsoft Excel
In (hide point be left in the basket).Wherein, EXCEL table contains in solder joint title and solder joint coordinate information, solder joint title and CATIA
Solder joint data corresponding, order the most consistent.
4.txt to welding parameter: the solder balls in CATIA and bodywork are carried out interference checking, then to leading
The txt file gone out processes, and obtains the plate numbering that each solder balls connects.
In CATIA, solder balls and workpiece are carried out collision detection (i.e. interference checking), and testing result is exported to
Txt file.Then, " txt to welding parameter " order of CATIA drop-down menu is clicked on, in pop-up dialogue box before selection
The txt file derived, ultimately generates the EXCLE table of the sheet material information corresponding containing solder joint numbering and solder joint numbering.
(2) EXCEL module.
As shown in Figure 4, EXCEL module includes following functions:
1. point coordinates imports CATIA: the solder joint data genaration in Microsoft Excel can import to the generation point in CATIA.
After user clicks on " point coordinates imports CATIA ", meeting the most newly-built Part file in CATIA, and in tree
The geometric figure collection (being not drawn in figure) of one entitled " spots_ solder joint number " can be increased, the solder joint of importing all this one-level it
Under, and the name of solder joint is corresponding with the name in EXCEL table, order is the most consistent.
2.Excel to pt: the solder joint data genaration extracted in EXCEL can import to the .pt file in ROBCAD.
Click on " excel to pt " order of EXCEL drop-down menu, the dialog box ejected selects solder joint tables of data；
After having selected solder joint tables of data, program operation can eject derivation pt file prompting frame, click determine after select .pt file
Store path, now Automatic Program is pt file designation, name form be " the spot_ day month _ Hour Minute Second ".
3.Excel to plugs in rifle figure: adjusting after welding gun gets attitude ready with simulation software, solder joint data contain coordinate
And angle information, attitude got ready by welding gun needs to allow the technical staff of design fixture understand, in order to avoid the fixture designed is done with welding gun
Relate to.Effect of this order is to combine the solder joint data in the CATIA digital-to-analogue of welding gun and EXCEL, is created that product in CATIA
File, comprises that welding gun is all possible gets attitude ready, i.e. plugs in rifle figure.
Click on " excel to plugs in rifle figure " order of EXCEL drop-down menu, then select successively in the dialog box ejected
Corresponding program is run after tables of data and welding gun cgr digital-to-analogue.This process can in CATIA a newly-built Product file, it contains
There are welding torch position and attitude.
4. generate solder balls 3DFlowchart: for being already allocated to the solder joint data of station and robot, be directed into
While CATIA generates solder balls, the tree format of solder joint is made to meet 3D Flowchart by different station and different machines people
The requirement of (i.e. three-dimensional flow diagram).
5. solder joint renaming (being used for screening symmetrical solder joint): the solder joint name form arranged in the window by user is
Solder joint data rename, and filter out the solder joint of symmetry, make the numbering of symmetrical solder joint identical and order is the most adjacent (is comparing two
When whether solder joint is symmetrical solder joint, if the two solder joint X, Y, the absolute value of Z coordinate all differ in 2mm, and the symbol of Y coordinate
On the contrary, then it is assumed that the two solder joint is symmetrical).
6.Excel to csv: the solder joint data genaration extracted in EXCEL can import to PD(software) in .csv lattice
Formula file；
7. solder joint iterative testing compares with different editions solder joint data: for solder joint data inspection, compare with verification.
(3) ROBCAD module.
As it is shown in figure 5, ROBCAD module includes following functions:
1.txt to excel: first derive solder joint data with the Location information order of ROBCAD, entirely select duplication
In txt file, and preserve txt file, then with " txt to excel " order, the solder joint data in txt file are imported to
In standard EXCEL masterplate, finally give a Microsoft Excel.
2.txt to pt: first derive solder joint data with the Location information order of ROBCAD, entirely select duplication
In txt file, and preserve txt file, directly generated the .pt file that can import in ROBCAD the most again by txt.Program is transported
Prompting frame can be ejected during this order of row, click determine after need to select the store path of pt file (program can be automatically for pt file
Name, name form be " the spot_ day month _ Hour Minute Second).
3. txt to plugs in rifle figure: derive solder joint data, Quan Xuan with the Location information order of ROBCAD
Copy in txt file, and preserve txt file, then in conjunction with welding gun digital-to-analogue, directly generate plug in rifle figure.Click on ROBCAD drop-down
" txt to plugs in rifle figure " order of menu, after then selecting txt file and cgr welding gun digital-to-analogue successively in the dialog box ejected
Run corresponding program.This process can in CATIA a newly-built Product file, containing welding torch position and attitude.
Additionally, software further comprises digital-to-analogue data conversion module as shown in Figure 6, can be by cgr or CATPart of CATIA
File be converted into ROBCAD use .co file or PD in use .cojt formatted file, it is possible to .co file is converted into
.cojt formatted file.
Compared with prior art, the present invention proposes a kind of brand-new solder joint data processing software, has filled up current butt welding
Point data processes the blank of software development.The present invention is that the process of solder joint data provides a whole set of solution, is conducive to weldering
The standardized management of point data, the function of this software almost covers what butt welding point data in being typically designed and emulating carried out processing
Requirement, and the expansibility of this software is strong, it is easy to safeguard；This software has also provided the user good visualization interface, general
Property and interactivity strong, easy to use, user is not had special professional skill requirement.
It is above the preferably enforcement of the present invention is illustrated, but the invention is not limited to described enforcement
Example, those of ordinary skill in the art also can make all equivalent variations on the premise of spirit of the present invention or replace
Changing, deformation or the replacement of these equivalents are all contained in the application claim limited range.
Claims (10)
1. a solder joint data processing method, it is characterised in that: comprise the following steps:
For the newly-built EXCEL masterplate of solder joint data, described EXCEL masterplate is the solder joint tables of data of conformance with standard form；
Judge the software type that the source data of solder joint data is currently located, then coordinate EXCEL masterplate in visualization interface
Complete solder joint data in CATIA module, EXCEL module or ROBCAD module automatically processes operation；
The digital-to-analogue data conversion module that data conversion requirements according to solder joint data calls in visualization interface carries out digital-to-analogue data
Conversion.
A kind of solder joint data processing method the most according to claim 1, it is characterised in that: described current according to solder joint data
The software type at place and EXCEL masterplate, complete in CATIA module, EXCEL module or the ROBCAD module in visualization interface
Become the step for of automatically processing operation of solder joint data, comprising:
Judge the software type that the source data of solder joint data is currently located；
Forward the corresponding module in visualization interface to according to the result judged and carry out automatically processing of solder joint data: if solder joint data
The software that is currently located of source data be CATIA software, then with CATIA module EXCEL masterplate complete solder joint data from
Dynamic process operates；If the software that the source data of solder joint data is currently located is EXCEL software, then completed solder joint by EXCEL module
Data automatically process operation；If the software that the source data of solder joint data is currently located is ROBCAD software, then by ROBCAD mould
Block coordinates what EXCEL masterplate completed solder joint data to automatically process operation.
A kind of solder joint data processing method the most according to claim 2, it is characterised in that: described with CATIA module
EXCEL masterplate completes the step for of automatically processing operation of solder joint data, comprising:
In CATIA, under Part file, all visible points, as the centre of sphere, generate corresponding solder balls；
In identification CATIA, all visible solder balls spheres under Part file, obtain centre of sphere point；
All visible point coordinates in CATIA current window is exported in the form of EXCEL masterplate；
The txt file derived after solder balls in CATIA and bodywork are carried out interference checking carries out welding parameter process,
Obtain the plate numbering that each solder balls is connected.
A kind of solder joint data processing method the most according to claim 3, it is characterised in that: described completed by EXCEL module
The step for of automatically processing operation of solder joint data, comprising:
The generation point in CATIA can be imported to according to the solder joint data genaration in EXCEL masterplate；
The solder joint data genaration extracted in EXCEL masterplate can import to the .pt formatted file in ROBCAD；
Welding gun digital-to-analogue according to the solder joint data in EXCEL masterplate and CATIA generates plugs in rifle figure；
For EXCEL masterplate has distributed the solder joint data genaration solder balls 3D Flowchart of station and robot；
Rename for the solder joint data in EXCEL masterplate, and filter out the solder joint of symmetry, make the numbering of symmetrical solder joint identical and
The most adjacent；
The solder joint data genaration extracted in EXCEL masterplate can import to the .csv formatted file in PD；
Solder joint data in EXCEL masterplate are carried out solder joint iterative testing；
The solder joint data that solder joint data in EXCEL masterplate carry out different editions compare.
A kind of solder joint data processing method the most according to claim 3, it is characterised in that: described with ROBCAD module
EXCEL masterplate completes the step for of automatically processing operation of solder joint data, comprising:
The solder joint data derived by ROBCAD import in EXCEL masterplate after txt file replicates again；
The solder joint data derived by ROBCAD are directly generated by txt file after txt file replicates again and can import in ROBCAD
.pt formatted file；
The solder joint data derived by ROBCAD combine the welding gun digital-to-analogue of CATIA after txt file preserves and directly generate plug in rifle figure.
6. according to a kind of solder joint data processing method described in any one of claim 1-5, it is characterised in that: described digital-to-analogue data
Conversion includes but not limited to: cgr or the CATPart file of CATIA is converted into the .co formatted file of ROBCAD；By CATIA's
Cgr or CATPart file is converted into the .cojt formatted file of PD；.co formatted file by ROBCAD is converted to the .cojt of PD
Formatted file.
7. a solder joint data handling system, it is characterised in that: including:
Standard form builds module, and for for the newly-built EXCEL masterplate of solder joint data, described EXCEL masterplate is conformance with standard
The solder joint tables of data of form；
Automatic business processing module, for judging the software type that the source data of solder joint data is currently located, then coordinates EXCEL mould
What version completed solder joint data in CATIA module, EXCEL module or ROBCAD module in visualization interface automatically processes behaviour
Make；
Modular converter, for calling the digital-to-analogue data conversion module in visualization interface according to the data conversion requirements of solder joint data
Carry out digital-to-analogue data conversion.
A kind of solder joint data handling system the most according to claim 7, it is characterised in that: described modular converter includes:
Judging unit, for judging the software type that the source data of solder joint data is currently located；
Automatically process unit, for according to judge result forward to the corresponding module in visualization interface carry out solder joint data from
Dynamic process: if the software that the source data of solder joint data is currently located is CATIA software, then EXCEL masterplate with CATIA module
Complete solder joint data automatically processes operation；If the software that the source data of solder joint data is currently located is EXCEL software, then by
What EXCEL module completed solder joint data automatically processes operation；If the software that the source data of solder joint data is currently located is ROBCAD
Software, then with ROBCAD module EXCEL masterplate complete solder joint data automatically process operation.
A kind of solder joint data handling system the most according to claim 8, it is characterised in that automatically process described in: unit by
EXCEL module completes when automatically processing operation of solder joint data, by following for execution operation:
In CATIA, under Part file, all visible points, as the centre of sphere, generate corresponding solder balls；
In identification CATIA, all visible solder balls spheres under Part file, obtain centre of sphere point；
All visible point coordinates in CATIA current window is exported in the form of EXCEL masterplate；
The txt file derived after solder balls in CATIA and bodywork are carried out interference checking carries out welding parameter process,
Obtain the plate numbering that each solder balls is connected.
A kind of solder joint data handling system the most according to claim 9, it is characterised in that automatically process unit described in: and exist
When automatically processing operation of solder joint data is completed, by following for execution operation by EXCEL module:
The generation point in CATIA can be imported to according to the solder joint data genaration in EXCEL masterplate；
The solder joint data genaration extracted in EXCEL masterplate can import to the .pt formatted file in ROBCAD；
Welding gun digital-to-analogue according to the solder joint data in EXCEL masterplate and CATIA generates plugs in rifle figure；
For EXCEL masterplate has distributed the solder joint data genaration solder balls 3D Flowchart of station and robot；
Rename for the solder joint data in EXCEL masterplate, and filter out the solder joint of symmetry, make the numbering of symmetrical solder joint identical and
The most adjacent；
The solder joint data genaration extracted in EXCEL masterplate can import to the .csv formatted file in PD；
Solder joint data in EXCEL masterplate are carried out solder joint iterative testing；
The solder joint data that solder joint data in EXCEL masterplate carry out different editions compare.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610571056.1A CN106202022B (en) | 2016-07-18 | 2016-07-18 | A kind of solder joint data processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610571056.1A CN106202022B (en) | 2016-07-18 | 2016-07-18 | A kind of solder joint data processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106202022A true CN106202022A (en) | 2016-12-07 |
| CN106202022B CN106202022B (en) | 2019-03-05 |
Family
ID=57494569
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610571056.1A Active CN106202022B (en) | 2016-07-18 | 2016-07-18 | A kind of solder joint data processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106202022B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108763843A (en) * | 2018-07-27 | 2018-11-06 | 江铃汽车股份有限公司 | The spot welding connection method for automatic modeling and system of automobile body-in-white |
| CN109664299A (en) * | 2018-12-27 | 2019-04-23 | 广州明珞汽车装备有限公司 | A kind of quick deriving method, system and the device of robot coordinate |
| CN110308667A (en) * | 2019-05-16 | 2019-10-08 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of automatic setting interference checking |
| CN110334061A (en) * | 2019-05-22 | 2019-10-15 | 广州明珞汽车装备有限公司 | Method, system, device and the storage medium of batch modification device data model |
| CN110489767A (en) * | 2018-05-14 | 2019-11-22 | 一汽-大众汽车有限公司 | A kind of spot-welded space inspection method and device |
| CN110968558A (en) * | 2019-11-07 | 2020-04-07 | 广州明珞汽车装备有限公司 | Renaming method, system and storage medium for prototype, example and folder |
| CN111191321A (en) * | 2019-11-14 | 2020-05-22 | 广州明珞汽车装备有限公司 | Control method and system for renaming welding spots and storage medium |
| CN112395782A (en) * | 2019-07-31 | 2021-02-23 | 比亚迪股份有限公司 | CAE-based method and device for calculating coordinates of welding points in batch |
| CN111413918B (en) * | 2020-03-05 | 2021-05-28 | 明珞汽车装备（上海）有限公司 | Method, system and storage medium for processing creation data of OPC communication label |
| CN113360961A (en) * | 2021-05-11 | 2021-09-07 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly acquiring welding spot information |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4337493B2 (en) * | 2003-10-03 | 2009-09-30 | トヨタ車体株式会社 | Welding point management numbering system, program, recording medium |
| CN101777055A (en) * | 2009-12-31 | 2010-07-14 | 广东九联科技股份有限公司 | PCB (Printed circuit board) plate welding method |
| CN102375897A (en) * | 2010-08-13 | 2012-03-14 | 上海世科嘉车辆技术研发有限公司 | System for generating dendrogram of welding and assembly structure of vehicle body |
| US20130282182A1 (en) * | 2012-04-23 | 2013-10-24 | Chrysler Group Llc | Method and system for scheduling weld events |
| CN105550267A (en) * | 2015-12-09 | 2016-05-04 | 四川广正科技有限公司 | Method and system utilizing Excel format data to process welding performance data |
-
2016
- 2016-07-18 CN CN201610571056.1A patent/CN106202022B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4337493B2 (en) * | 2003-10-03 | 2009-09-30 | トヨタ車体株式会社 | Welding point management numbering system, program, recording medium |
| CN101777055A (en) * | 2009-12-31 | 2010-07-14 | 广东九联科技股份有限公司 | PCB (Printed circuit board) plate welding method |
| CN102375897A (en) * | 2010-08-13 | 2012-03-14 | 上海世科嘉车辆技术研发有限公司 | System for generating dendrogram of welding and assembly structure of vehicle body |
| US20130282182A1 (en) * | 2012-04-23 | 2013-10-24 | Chrysler Group Llc | Method and system for scheduling weld events |
| CN105550267A (en) * | 2015-12-09 | 2016-05-04 | 四川广正科技有限公司 | Method and system utilizing Excel format data to process welding performance data |
Non-Patent Citations (2)
| Title |
|---|
| WU921019: "Robcad基础培训", 《百度文库》 * |
| 张云杰，乔建军: "《CATIA V5-6 R2013中文版基础教程》", 1 June 2014 * |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489767A (en) * | 2018-05-14 | 2019-11-22 | 一汽-大众汽车有限公司 | A kind of spot-welded space inspection method and device |
| CN108763843B (en) * | 2018-07-27 | 2022-02-01 | 江铃汽车股份有限公司 | Automatic modeling method and system for spot welding connection of automobile body in white |
| CN108763843A (en) * | 2018-07-27 | 2018-11-06 | 江铃汽车股份有限公司 | The spot welding connection method for automatic modeling and system of automobile body-in-white |
| CN109664299A (en) * | 2018-12-27 | 2019-04-23 | 广州明珞汽车装备有限公司 | A kind of quick deriving method, system and the device of robot coordinate |
| CN110308667A (en) * | 2019-05-16 | 2019-10-08 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of automatic setting interference checking |
| CN110334061A (en) * | 2019-05-22 | 2019-10-15 | 广州明珞汽车装备有限公司 | Method, system, device and the storage medium of batch modification device data model |
| CN112395782A (en) * | 2019-07-31 | 2021-02-23 | 比亚迪股份有限公司 | CAE-based method and device for calculating coordinates of welding points in batch |
| CN110968558A (en) * | 2019-11-07 | 2020-04-07 | 广州明珞汽车装备有限公司 | Renaming method, system and storage medium for prototype, example and folder |
| CN110968558B (en) * | 2019-11-07 | 2023-04-07 | 广州明珞汽车装备有限公司 | Method, system and storage medium for renaming prototype, example and folder |
| CN111191321A (en) * | 2019-11-14 | 2020-05-22 | 广州明珞汽车装备有限公司 | Control method and system for renaming welding spots and storage medium |
| CN111191321B (en) * | 2019-11-14 | 2023-10-17 | 广州明珞汽车装备有限公司 | Control method, system and storage medium for renaming welding spots |
| CN111413918B (en) * | 2020-03-05 | 2021-05-28 | 明珞汽车装备（上海）有限公司 | Method, system and storage medium for processing creation data of OPC communication label |
| CN113360961A (en) * | 2021-05-11 | 2021-09-07 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly acquiring welding spot information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106202022B (en) | 2019-03-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106202022A (en) | A kind of solder joint data processing method and system | |
| Dewar et al. | Assembly planning in a virtual environment | |
| CN104599024A (en) | Generation system of welding process guide system for structural part | |
| CN105653443B (en) | One kind meets that DO-178C standard testings trace mesh calibration method | |
| CN109202339B (en) | Method for intelligently managing welding construction site | |
| CN105205223A (en) | Finite element modeling method for establishing defective material model | |
| CN110059121B (en) | Method, system, device and storage medium for rapidly exporting bill of materials | |
| CN105138499A (en) | Data processing method and apparatus and terminal | |
| US20230041354A1 (en) | Learning management systems with shared weld training results | |
| CN114186984A (en) | Two-dimensional and three-dimensional integrated collaborative design system for architectural design enterprise | |
| CN109102245B (en) | Processing method, system and device for approval process | |
| CN107729474B (en) | Data quality detection method, system, equipment and storage medium of CAD model | |
| CN107464083A (en) | A kind of generation method of BOM, device and equipment | |
| Raza et al. | PDCA integrated simulations enable effective deployment of collaborative robots: Case of a manufacturing SME | |
| CN109657376B (en) | Full-vehicle automatic modeling method for CAE simulation | |
| KR101874459B1 (en) | Apparatus and method for generating user interface for pre-verifying dfm | |
| US20050096768A1 (en) | System and method for formulating and redacting bending procedures used in manufacturing | |
| CN104239212B (en) | Query method and device of test case and establishment method and device of test case | |
| CN116305375A (en) | Method, system, device and storage medium for rapidly checking three-dimensional mode interference position | |
| CN109657321B (en) | Electronic assembly rapid process design system for printed board assembly and use method | |
| CN106980505A (en) | A kind of domestic middleware migration remodeling method of information system and device | |
| TWI627597B (en) | Expert analysis system in risk management and method for operation of the same | |
| US20040267508A1 (en) | Computer numerical control code-simulating system and method | |
| CN111191416B (en) | Control method and system for welding spot information conversion | |
| CN110334906A (en) | Business data processing method, device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address |
Address after: Room 101 and 201, building C3, No. 11, Kaiyuan Avenue, Huangpu District, Guangzhou City, Guangdong Province Patentee after: Guangzhou mingluo Equipment Co., Ltd Address before: 510530 Unit A and Second Floor of Building C3, No.11 Kaiyuan Avenue, Guangzhou High-tech Industrial Development Zone, Guangzhou, Guangdong Province Patentee before: Guangzhou MINO Automotive Equipment Co.,Ltd. |
|
| CP03 | Change of name, title or address |