CN109325730A - A method of it supports that BOM is directly imported production system - Google Patents
A method of it supports that BOM is directly imported production system Download PDFInfo
- Publication number
- CN109325730A CN109325730A CN201810989469.0A CN201810989469A CN109325730A CN 109325730 A CN109325730 A CN 109325730A CN 201810989469 A CN201810989469 A CN 201810989469A CN 109325730 A CN109325730 A CN 109325730A
- Authority
- CN
- China
- Prior art keywords
- bom
- production system
- initial
- information
- final
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- 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—Systems or methods specially adapted for 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
Abstract
The invention discloses a kind of methods for supporting that BOM is directly imported production system, comprising: step S100: being configured PCB design software, and typing material key message exports initial BOM into schematic diagram；Step S200: the material information in initial BOM is carried out automatically to merge statistics, classification and sequence, generates final BOM, the material information includes type of device, material code, encapsulation and value；Step S300: final BOM is introduced directly into production system.The present invention realizes automatic classification, merging and sequence using shell script, can effectively improve the efficiency for exporting final BOM；It reduces the information many and diverse to material to be compared, only by useful data input, the probability of human error can be reduced；Operation to PCB schematic diagram is, it can be achieved that the recycling of circuit modular or blocking, reduces human cost.
Description
Technical field
The present invention relates to PCB materials and production system technical field, specifically, be it is a kind of support directly BOM is imported
The method of production system.
Background technique
Bill of materials (BOM, bill of material) refers to parts list and its structure needed for product, is to constitute
The inventory of all subassemblies of father's assembly parts, part and raw material, and zero every kind required for one assembly parts of manufacture
The inventory of the quantity of part.Production system refers to the information system of the running of support unit's routine work under normal circumstances.It includes
Creation data, creation data processing system and production network.In general, electronic product can all use printed circuit board (PCB), engineering
Teacher will use PCB design software and directly export initial BOM (Excel or extended formatting) after the completion of PCB schematic diagram.It is general every
A company has the row needed inside specific requirement, such as BOM comprising which key message, BOM to the format or content of BOM
Version etc..And the directly derived initial BOM of software, the requirement for meeting final BOM is tended not to, engineer needs to compile BOM
Volume, arrange, then the BOM is entered into subsequent production system and assembled, weld.This link is critically important, and engineer can be non-
Often with caution, it goes through, check information (including device type, material code, encapsulation, value, the precision of the every kind of material in the inside BOM
It is required that, temperature coefficient, brand etc.), default material information is added, and typesetting is carried out to BOM, makes the format character of BOM
Close production system.When facing hundreds and thousands of kinds of materials, inspection artificial in this way, arrangement are not only wasted time, but also in personnel
Error is very easy in the case where tired out.If BOM malfunctions, subsequent production system can be caused to stagnate, not only influence the friendship of product
Phase, or even will affect the quality of product.In currently available technology, by BOM typing production system, be all by the way of artificial,
Every kind of material Manual arranging typing.It since data are very huge, requires a great deal of time and energy, and is very easy to lose
Leakage and error, considerably increase the quality risk of product.Therefore need a kind of BOM that can quickly, accurately import production system whole
Reason scheme.
Summary of the invention
It is existing for solving the purpose of the present invention is to provide a kind of method for supporting that BOM is directly imported production system
Initial BOM can not be introduced directly into production system in technology, need to carry out human-edited to initial BOM, process is cumbersome time-consuming to ask
Topic.
The present invention is solved the above problems by following technical proposals:
A method of it supports that BOM is directly imported production system, comprising:
Step S100: being configured PCB design software, and for typing material key message into schematic diagram, export is initial
BOM；
Step S200: the material information in initial BOM is carried out automatically to merge statistics, classification and sequence, is generated final
BOM, the material information include type of device, material code, encapsulation and value；
Step S300: final BOM is introduced directly into production system.
Batch operation is carried out using PCB design software such as Cadence, PADS, Altium Designer, Protel etc., is deleted
Except useless material information, key message is entered into schematic diagram, initial BOM derived from schematic diagram.Again to using VB language
Shell script realization classified automatically to initial BOM, merged, being sorted, production system can be introduced directly by being organized into, service
In the normative BOM of research and development, production.Using script, the efficiency of output BOM can be effectively improved；Reduce the information many and diverse to material
It is compared, only by useful data input, the probability of human error can be reduced；Operation to PCB schematic diagram is, it can be achieved that circuit
The recycling of modularization or blocking reduces human cost.The present invention is classifying to initial BOM, is merging and collated
Cheng Zhong beats debugging breakpoints and uses the mode of variable storage data instead by addition, modification logical code in shell script, and
Data are handled in the buffer, efficiency can be made to be increased dramatically.
Further, the step S200 is specifically included:
Step S210: opening initial BOM, reads the material information in initial BOM, and is put into the storage of script execution equipment
In device；
Step S220: position of the spare material in final BOM in initial BOM is set；
Step S230: the identical item of material information is merged, and statistical magnitude and position number；
Step S240: classifying according to the initial of material code, and material code is carried out according to the rule of setting
Sequence；
Step S250: the sequence sequenced is write into Excel table.
PCB design software is specifically arranged, edits the attribute of single material, deletes useless material description in batches
Information.The material informations such as batch input " device type ", " material code ", " encapsulation ", " value ".Export contains the material information
Initial BOM (Excel format).The shell script for running VB language, classified to the material information in initial BOM, merged,
Sequence etc., is organized into the BOM format for meeting production system.The operation includes: the initial of the opening PCB design Software Create
BOM；The material information in the BOM is read, memory is put into；Selected " row of the value with NC device, and place it in EXCEL table
Lattice end；" device type ", " material code ", " encapsulation ", the identical material of " value " information are merged, and count position
Number and quantity；Classified according to file leader's alphabetical sequence of " material code "；According to the row of selected " material code " according to setting
Sequence arrangement；The size carry out sequence arrangement of the value of row basis " encapsulation " in selected " material code "；The sequence that will be sequenced
EXCEL table is write into, final BOM is formed.
Further, further include step S260: adding title, sequence number and Table Header information that final BOM needs.
Further, the step S100 is specifically included:
Step S110: in PCB design software, editing the attribute of single material, deletes useless material description letter in batches
Breath；
Step S120: batch input material information；
Step S130: original BOM is exported, includes the material information in the step S120 in the original BOM.
The deletion garbage and addition critical component information of batch, reduce data volume, and it is equal not need every kind of material
Manual arranging input, improves work efficiency, reduces the probability of error and omission.
Further, the step S300 includes:
Step S310: operation production system imports the final BOM put in order；
Step S320: if occurring not being inconsistent information normally in operational process, there is the prompt that reports an error in human window.
It can return to modify initial BOM or to initial BOM classification, merging and sequence according to the error message of prompt
Rule, until final BOM can correctly import production system.
Compared with prior art, the present invention have the following advantages that and the utility model has the advantages that
(1) present invention uses shell script to realize automatic classification, merge and sort, and can effectively improve the final BOM's of output
Efficiency；It reduces the information many and diverse to material to be compared, only by useful data input, the probability of human error can be reduced；It is right
The operation of PCB schematic diagram is, it can be achieved that the recycling of circuit modular or blocking, reduces human cost.
(2) present invention classified to initial BOM, merge and sequencer procedure in, by adding, modifying logical code,
Debugging breakpoints are beaten, and use the mode of variable storage data instead, and handle data in the buffer, it is then another and document is written, it writes
After the completion of entering, finally unifies to save document data, efficiency can be made to be increased dramatically.
Specific embodiment
The present invention is described in further detail below with reference to embodiment, embodiments of the present invention are not limited thereto.
Embodiment 1:
A method of it supports that BOM is directly imported production system, comprising:
Step S100: being configured PCB design software, and for typing material key message into schematic diagram, export is initial
BOM:
Step S110: in PCB design software, editing the attribute of single material, deletes useless material description letter in batches
Breath；
Step S120: batch input material information；
Step S130: original BOM is exported, includes the material information in the step S120 in the original BOM.
Step S200: the material information in initial BOM is carried out automatically to merge statistics, classification and sequence, is generated final
BOM, the material information include type of device, material code, encapsulation and value:
Step S210: opening initial BOM, reads the material information in initial BOM, and is put into the storage of script execution equipment
In device；
Step S220: position of the spare material in final BOM in initial BOM is set；
Step S230: the identical item of material information is merged, and statistical magnitude and position number；
Step S240: classifying according to the initial of material code, and material code is carried out according to the rule of setting
Sequence；
Step S250: the sequence sequenced is write into Excel table；
Step S260: title, sequence number and Table Header information that final BOM needs are added.
Step S300: final BOM is introduced directly into production system:
Step S310: operation production system imports the final BOM put in order；
Step S320: if occurring not being inconsistent information normally in operational process, there is the prompt that reports an error in human window.
Batch operation is carried out using PCB design software such as Cadence, PADS, Altium Designer, Protel etc., is deleted
Except useless material information, key message is entered into schematic diagram, initial BOM derived from schematic diagram.The deletion of batch is useless
Information and addition critical component information, reduce data volume, and do not need the equal Manual arranging input of every kind of material, improve work
Efficiency reduces the probability of error and omission.PCB design software is specifically arranged, the attribute of single material is edited, batch
Amount deletes useless material description information.The material informations such as batch input " device type ", " material code ", " encapsulation ", " value ".
Export contains the initial BOM (Excel format) of the material information.The shell script for running VB language, to the object in initial BOM
Material information is classified, is merged, is sorted, and the BOM format for meeting production system is organized into.The operation includes: described in opening
The initial BOM of PCB design Software Create；The material information in the BOM is read, memory is put into；It is selected that " value is with NC device
Row, and place it in Microsoft Excel end；" device type ", " material code ", " encapsulation ", " value " information is identical
Material merges, and counts position number and quantity；Classified according to file leader's alphabetical sequence of " material code "；According to selected
The row of " material code " is arranged according to the sequence of setting；The size progress sequence of row basis " encapsulation " in selected " material code "
Arrangement；The sequence sequenced is write into EXCEL table, forms final BOM.Production system is opened, final BOM is imported into production system
System can return to modify initial BOM or the rule to initial BOM classification, merging and sequence according to the error message of prompt,
Until final BOM can correctly import production system.
Using script, the efficiency of output BOM can be effectively improved；It reduces the information many and diverse to material to be compared, will only have
Data input can reduce the probability of human error；Operation to PCB schematic diagram is, it can be achieved that circuit modular or blocking
Recycling, reduce human cost.The present invention classify to initial BOM, merge and sequencer procedure in, by script
It added in program, modify logical code, beaten debugging breakpoints and use the mode of variable storage data instead, and handle number in the buffer
According to efficiency being made to be increased dramatically.
Although reference be made herein to invention has been described for explanatory embodiment of the invention, and above-described embodiment is only this hair
Bright preferable embodiment, embodiment of the present invention are not limited by the above embodiments, it should be appreciated that those skilled in the art
Member can be designed that a lot of other modification and implementations, these modifications and implementations will fall in principle disclosed in the present application
Within scope and spirit.
Claims (5)
1. a kind of method for supporting that BOM is directly imported production system characterized by comprising
Step S100: being configured PCB design software, and typing material key message exports initial BOM into schematic diagram；
Step S200: carrying out the material information in initial BOM automatically to merge statistics, classification and sequence, generate final BOM,
The material information includes type of device, material code, encapsulation and value；
Step S300: final BOM is introduced directly into production system.
2. a kind of method for supporting that BOM is directly imported production system according to claim 1, which is characterized in that described
Step S200 is specifically included:
Step S210: opening initial BOM, reads the material information in initial BOM, and is put into the memory of script execution equipment
In；
Step S220: position of the spare material in final BOM in initial BOM is set；
Step S230: the identical item of material information is merged, and statistical magnitude and position number；
Step S240: classifying according to the initial of material code, and material code is ranked up according to the rule of setting；
Step S250: the sequence sequenced is write into Excel table.
3. a kind of method for supporting that BOM is directly imported production system according to claim 2, which is characterized in that also wrap
It includes step S260: adding title, sequence number and Table Header information that final BOM needs.
4. a kind of method for supporting that BOM is directly imported production system according to claim 3, which is characterized in that described
Step S100 is specifically included:
Step S110: in PCB design software, the attribute of single material is edited, deletes useless material description information in batches；
Step S120: batch input material information；
Step S130: original BOM is exported, includes the material information in the step S120 in the original BOM.
5. a kind of method for supporting that BOM is directly imported production system according to claim 1, which is characterized in that described
Step S300 includes:
Step S310: operation production system imports the final BOM put in order；
Step S320: if occurring not being inconsistent information normally in operational process, there is the prompt that reports an error in human window.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810989469.0A CN109325730A (en) | 2018-08-28 | 2018-08-28 | A method of it supports that BOM is directly imported production system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810989469.0A CN109325730A (en) | 2018-08-28 | 2018-08-28 | A method of it supports that BOM is directly imported production system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109325730A true CN109325730A (en) | 2019-02-12 |
Family
ID=65264027
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810989469.0A Pending CN109325730A (en) | 2018-08-28 | 2018-08-28 | A method of it supports that BOM is directly imported production system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109325730A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110377620A (en) * | 2019-07-16 | 2019-10-25 | 四川康佳智能终端科技有限公司 | A kind of material searching method, computer and storage medium based on BOM tool |
| CN110471653A (en) * | 2019-08-16 | 2019-11-19 | 四川长虹电器股份有限公司 | BOM automatic arranging method based on C# |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN111967217A (en) * | 2020-08-14 | 2020-11-20 | 上海弘快科技有限公司 | Design system capable of realizing electrical interconnection of schematic diagrams |
| CN112465418A (en) * | 2020-10-29 | 2021-03-09 | 苏州浪潮智能科技有限公司 | Material loading method and device based on product life cycle management |
| CN112559443A (en) * | 2019-09-10 | 2021-03-26 | 南通深南电路有限公司 | Storage method of lamination data, lamination method of circuit board and related device |
| CN112801621A (en) * | 2021-01-30 | 2021-05-14 | 深圳捷创电子科技有限公司 | BOM bill of material sorting and approving method, system and computer readable storage medium |
Citations (6)
| 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 |
| CN103678648A (en) * | 2013-12-23 | 2014-03-26 | 泰富重工制造有限公司 | Classifying and gathering system and method of BOM tables |
| US20150128102A1 (en) * | 2013-11-06 | 2015-05-07 | Texas Instruments Incorporated | Circuit design synthesis tool with export to a computer-aided design format |
| CN104778540A (en) * | 2015-03-27 | 2015-07-15 | 中材装备集团有限公司 | BOM (bill of material) management method and management system for building material equipment manufacturing |
| CN105761045A (en) * | 2016-02-29 | 2016-07-13 | 万高(杭州)科技有限公司 | Printed circuit board BOM sorting method and system |
| CN107633353A (en) * | 2017-09-08 | 2018-01-26 | 南京国电南自电网自动化有限公司 | Material BOM tables based on EXCEL Table V BA close rule inspection method |
-
2018
- 2018-08-28 CN CN201810989469.0A patent/CN109325730A/en active Pending
Patent Citations (6)
| 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 |
| US20150128102A1 (en) * | 2013-11-06 | 2015-05-07 | Texas Instruments Incorporated | Circuit design synthesis tool with export to a computer-aided design format |
| CN103678648A (en) * | 2013-12-23 | 2014-03-26 | 泰富重工制造有限公司 | Classifying and gathering system and method of BOM tables |
| CN104778540A (en) * | 2015-03-27 | 2015-07-15 | 中材装备集团有限公司 | BOM (bill of material) management method and management system for building material equipment manufacturing |
| CN105761045A (en) * | 2016-02-29 | 2016-07-13 | 万高(杭州)科技有限公司 | Printed circuit board BOM sorting method and system |
| CN107633353A (en) * | 2017-09-08 | 2018-01-26 | 南京国电南自电网自动化有限公司 | Material BOM tables based on EXCEL Table V BA close rule inspection method |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110377620A (en) * | 2019-07-16 | 2019-10-25 | 四川康佳智能终端科技有限公司 | A kind of material searching method, computer and storage medium based on BOM tool |
| CN110471653A (en) * | 2019-08-16 | 2019-11-19 | 四川长虹电器股份有限公司 | BOM automatic arranging method based on C# |
| CN110515951A (en) * | 2019-08-27 | 2019-11-29 | 云汉芯城（上海）互联网科技股份有限公司 | A kind of BOM standardized method, system and electronic equipment and storage medium |
| CN110515951B (en) * | 2019-08-27 | 2020-05-08 | 云汉芯城（上海）互联网科技股份有限公司 | BOM standardization method and system, electronic device and storage medium |
| CN112559443A (en) * | 2019-09-10 | 2021-03-26 | 南通深南电路有限公司 | Storage method of lamination data, lamination method of circuit board and related device |
| CN112559443B (en) * | 2019-09-10 | 2021-12-14 | 南通深南电路有限公司 | Storage method of lamination data, lamination method of circuit board and related device |
| CN111967217A (en) * | 2020-08-14 | 2020-11-20 | 上海弘快科技有限公司 | Design system capable of realizing electrical interconnection of schematic diagrams |
| CN112465418A (en) * | 2020-10-29 | 2021-03-09 | 苏州浪潮智能科技有限公司 | Material loading method and device based on product life cycle management |
| CN112465418B (en) * | 2020-10-29 | 2022-06-03 | 苏州浪潮智能科技有限公司 | Material loading method and device based on product life cycle management |
| CN112801621A (en) * | 2021-01-30 | 2021-05-14 | 深圳捷创电子科技有限公司 | BOM bill of material sorting and approving method, system and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109325730A (en) | A method of it supports that BOM is directly imported production system | |
| Sorenson et al. | The Metaview system for many specification environments | |
| US8671084B2 (en) | Updating a data warehouse schema based on changes in an observation model | |
| CN106055618B (en) | Data processing method based on web crawler and structured storage | |
| CN105373469A (en) | Interface based software automation test method | |
| CN107844424A (en) | Model-based testing system and method | |
| CN105354239A (en) | Configuration data processing model based processing center data stream processing method | |
| CN103077192B (en) | A kind of data processing method and system thereof | |
| CN109086985B (en) | Professional test information management system for spacecraft assembly | |
| CN110489297A (en) | A kind of FPGA debugging signal setting method based on graphical interfaces | |
| CN111881579B (en) | Complex dynamic data model management method | |
| US20110078218A1 (en) | Event history storage device, event history tracking device, event history storage method, event history storage program, and data structure | |
| CN111401028A (en) | Automatic comparison method and device for RPS software version of nuclear power station | |
| JP5690472B2 (en) | Data extraction system | |
| Gephart et al. | Qualitative Data Analysis: Three Microcomputer-Supported Approaches. | |
| CN109614143A (en) | The development approach of failure flow chart is automatically generated in IETM browser | |
| CN108846198A (en) | A method of it being automatically deleted invalid via hole in Cadence software | |
| CN109032580A (en) | A kind of production method that general data is reported to a higher authorities for approval and analyzes software | |
| CN112508520A (en) | Method, system, device and storage medium for rapidly checking bill of material | |
| CN108628606B (en) | Method and system for generating WEB network management application program of embedded equipment | |
| CN102541855A (en) | Information data processing system and method | |
| US8839097B2 (en) | System and method for information encapsulation for providing multiple deliverable formats from one information source | |
| KR100656559B1 (en) | Program Automatic Generating Tools | |
| Ra et al. | Framework of a conceptual simulation model design tool | |
| CN116627390B (en) | ICD file substitution method and device in aviation software development |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190212 |
|
| RJ01 | Rejection of invention patent application after publication |