CN104915416A - Method for rapidly exporting bill of materials containing devices with specific attributes - Google Patents
Method for rapidly exporting bill of materials containing devices with specific attributes Download PDFInfo
- Publication number
- CN104915416A CN104915416A CN201510307939.7A CN201510307939A CN104915416A CN 104915416 A CN104915416 A CN 104915416A CN 201510307939 A CN201510307939 A CN 201510307939A CN 104915416 A CN104915416 A CN 104915416A
- Authority
- CN
- China
- Prior art keywords
- bom
- components
- storehouse
- parts
- information
- 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
- 239000000463 material Substances 0.000 title claims abstract description 30
- 238000000034 method Methods 0.000 title claims abstract description 14
- 238000004806 packaging method and process Methods 0.000 claims abstract description 5
- 238000005538 encapsulation Methods 0.000 claims description 5
- 238000012546 transfer Methods 0.000 claims description 3
- 238000013461 design Methods 0.000 abstract description 9
- 238000010586 diagram Methods 0.000 abstract description 6
- 238000012423 maintenance Methods 0.000 abstract description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000010454 slate Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Factory Administration (AREA)
Abstract
The invention relates to the technical field of circuit schematic diagram design, in particular to a method capable of rapidly exporting a bill of materials containing devices with specific attributes. The method of the invention comprises the following steps: setting specific attributes of components; setting a format of a BOM table; loading a component database, a PCB packaging library and a schematic diagram symbol library which contain component information according to design requirements; and rapidly exporting the complete BOM. The invention improves the systematicness of the whole management of the component library, obviously improves the maintenance efficiency of the schematic diagram symbol library and the PCB packaging library, and also improves the management efficiency and the management quality; but also improves the efficiency and saves the time for exporting the BOM containing the devices with specific attributes.
Description
Technical field
The present invention relates to schematic diagram design technical field, particularly a kind of method that can derive fast containing particular community device Bill of Material (BOM).
Background technology
Bill of Material (BOM) (Bill of Material, BOM), adopt area of computer aided enterprise production management, first computing machine will be enable to read product slate manufactured by enterprise and all materials that will relate to, for the ease of computer recognizing, the product structure of expressing by diagram must be changed into certain data layout, this file describing product structure is in data format exactly Bill of Material (BOM), is namely BOM.
Along with the development that electron trade is advanced by leaps and bounds, board design difficulty strengthens, and components and parts kind is various especially, and the method for traditional artificial integration BOM has no longer been applicable to complicated Electronic Design.
Summary of the invention
In order to solve the problem of prior art, the invention provides a kind of method that can derive fast containing particular community device Bill of Material (BOM), it better can solve problems such as deriving the complete or error that tank farm stock is inaccurate and manual retrieval brings of BOM information.
The technical solution adopted in the present invention is as follows:
The method containing particular community device Bill of Material (BOM) can be derived fast, comprise the following steps:
A, components and parts particular community is set;
B, BOM sheet format is set;
C, connection components and parts database, components and parts database is according to information in components and parts in tables of data, encapsulate in storehouse at PCB respectively and transfer corresponding packaging information, in schematic symbol storehouse, call corresponding symbolic information, in material code system, call relevant producer, producer's item number and inventory information;
D, the information in described components and parts database is loaded in described BOM table and derives.
In steps A, the described components and parts particular community that arranges specifically sets the association attributes needing the BOM derived in the attribute of schematic symbol.
In step B, the gauge outfit order of the BOM form that needs are arranged is: sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
A steps A 1 is also comprised: independently PCB is encapsulated storehouse, schematic symbol storehouse and material code system and read in each storehouse by a component management system and call relevant information and be integrated into a complete components and parts database before steps A.
The beneficial effect that technical scheme provided by the invention is brought is:
Directly available complete BOM information can be derived according to method of the present invention, deviser is undertaken producing by this BOM, material is standby produces, improve the promptness of BOM, high efficiency, save time, raise the efficiency.
In addition, invention also improves the systematicness of Component library holistic management, the maintenance efficiency that schematic symbol storehouse and PCB encapsulate storehouse is improved significantly, and also improves the efficiency of management and management quality.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, below the accompanying drawing used required in describing embodiment is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is internal library johning knot composition of the present invention.
Fig. 2 is schematic symbol storehouse of the present invention.
Fig. 3 is that PCB of the present invention encapsulates storehouse.
Fig. 4 is BOM sheet format schematic diagram of the present invention.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly, below in conjunction with accompanying drawing, embodiment of the present invention is described further in detail.
Embodiment one
The method containing particular community device Bill of Material (BOM) can be derived fast, comprise the following steps:
A, components and parts particular community is set; The association attributes needing the BOM derived is set in the attribute of schematic symbol.
B, BOM sheet format is set; The gauge outfit order of the BOM form that needs are arranged is: sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
C, connection components and parts database, components and parts database is according to information in components and parts in tables of data, encapsulate in storehouse at PCB respectively and transfer corresponding packaging information, in schematic symbol storehouse, call corresponding symbolic information, in material code system, call relevant producer, producer's item number and inventory information.
D, the information in described components and parts database is loaded in described BOM table and derives.
In steps A, described components and parts particular community is set specifically in step B,
As shown in Figure 1, components and parts are given corresponding schematic symbol by setting principle Symbol Database, use symbol of the same race, avoid design iterations, raise the efficiency for similar components and parts, better resource sharing.
As shown in Figure 2, components and parts are given corresponding schematic symbol by setting principle Symbol Database, use symbol of the same race, avoid design iterations, raise the efficiency for similar components and parts, better resource sharing.
As shown in Figure 3, PCB is set and encapsulates storehouse, set up encapsulation according to often kind of components and parts, use same package for different devices, avoid design iterations, raise the efficiency, better resource sharing;
PCB is set and encapsulates storehouse, set up pad according to often kind of components and parts, use identical pad for different devices, avoid design iterations, raise the efficiency, better resource sharing;
Setting data list item also comprises:
The path in corresponding schematic symbol storehouse, databook path and title are set.
As shown in Figure 4, BOM tables of data comprises sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
Embodiment two:
The difference of the present embodiment and embodiment one is: also comprise a steps A 1 before steps A: independently PCB is encapsulated storehouse, schematic symbol storehouse and material code system and read in each storehouse by a component management system and call relevant information and be integrated into a complete components and parts database.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (4)
1. can derive the method containing particular community device Bill of Material (BOM) fast, comprise the following steps:
A, components and parts particular community is set;
B, BOM sheet format is set;
C, connection components and parts database, components and parts database is according to information in components and parts in tables of data, encapsulate in storehouse at PCB respectively and transfer corresponding packaging information, in schematic symbol storehouse, call corresponding symbolic information, in material code system, call relevant producer, producer's item number and inventory information;
D, the information in described components and parts database is loaded in described BOM table and derives.
2. a kind of method that can derive fast containing particular community device Bill of Material (BOM) according to claim 1, it is characterized in that, in described steps A, the described components and parts particular community that arranges specifically sets the association attributes needing the BOM derived in the attribute of schematic symbol.
3. a kind of method that can derive fast containing particular community device Bill of Material (BOM) according to claim 1, it is characterized in that, in described step B, the gauge outfit order of the BOM form that needs are arranged is: sequence number, quantity, material code, name of material, value value, encapsulation, producer, producer's item number.
4. a kind of method that can derive fast containing particular community device Bill of Material (BOM) according to claim 1, it is characterized in that, before described steps A, also comprise a steps A 1: independently PCB is encapsulated storehouse, schematic symbol storehouse and material code system and read in each storehouse by a component management system and call relevant information and be integrated into a complete components and parts database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510307939.7A CN104915416A (en) | 2015-06-08 | 2015-06-08 | Method for rapidly exporting bill of materials containing devices with specific attributes |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510307939.7A CN104915416A (en) | 2015-06-08 | 2015-06-08 | Method for rapidly exporting bill of materials containing devices with specific attributes |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104915416A true CN104915416A (en) | 2015-09-16 |
Family
ID=54084479
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510307939.7A Pending CN104915416A (en) | 2015-06-08 | 2015-06-08 | Method for rapidly exporting bill of materials containing devices with specific attributes |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104915416A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106408148A (en) * | 2016-04-26 | 2017-02-15 | 浪潮电子信息产业股份有限公司 | Subsystem and realization method of automatically leading out production specification based on SAP system |
| CN107944685A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of method that packing list is automatically generated based on PLM system and SAP system |
| CN108228917A (en) * | 2016-12-09 | 2018-06-29 | 展讯通信（上海）有限公司 | Circuit diagram check device and method |
| CN109165227A (en) * | 2018-07-25 | 2019-01-08 | 上海望友信息科技有限公司 | Update/application method, system, medium and the terminal in EDA pad encapsulation library |
| CN109886623A (en) * | 2019-01-30 | 2019-06-14 | 美林数据技术股份有限公司 | The group packet processing method and device of product data |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106563A (en) * | 2013-02-05 | 2013-05-15 | 深圳杰科电器制造有限公司 | Method and device for generating dedicated bill of material for producing printed circuit board |
-
2015
- 2015-06-08 CN CN201510307939.7A patent/CN104915416A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106563A (en) * | 2013-02-05 | 2013-05-15 | 深圳杰科电器制造有限公司 | Method and device for generating dedicated bill of material for producing printed circuit board |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106408148A (en) * | 2016-04-26 | 2017-02-15 | 浪潮电子信息产业股份有限公司 | Subsystem and realization method of automatically leading out production specification based on SAP system |
| CN108228917A (en) * | 2016-12-09 | 2018-06-29 | 展讯通信（上海）有限公司 | Circuit diagram check device and method |
| CN108228917B (en) * | 2016-12-09 | 2021-08-03 | 展讯通信（上海）有限公司 | Circuit schematic diagram inspection device and method |
| CN107944685A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of method that packing list is automatically generated based on PLM system and SAP system |
| CN109165227A (en) * | 2018-07-25 | 2019-01-08 | 上海望友信息科技有限公司 | Update/application method, system, medium and the terminal in EDA pad encapsulation library |
| CN109165227B (en) * | 2018-07-25 | 2022-02-11 | 上海望友信息科技有限公司 | Method, system, medium and terminal for updating/applying EDA (electronic design automation) pad packaging library |
| CN109886623A (en) * | 2019-01-30 | 2019-06-14 | 美林数据技术股份有限公司 | The group packet processing method and device of product data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104915416A (en) | Method for rapidly exporting bill of materials containing devices with specific attributes | |
| CN103677789B (en) | Table data based on GRID components shows method and system | |
| CN102789491B (en) | A kind of configurable data subscription and delivery system and method thereof | |
| CN103729493B (en) | The layout method of printed circuit board (PCB) | |
| CN105045980A (en) | Method for configuring component library in PCB | |
| CN105404507A (en) | Process template construction method and system | |
| CN103810346A (en) | Method for checking part height restrictions through ALLEGRO software | |
| CN103793565B (en) | Method for rapidly generating netlist | |
| CN104572032A (en) | Report creation method and electronic equipment | |
| CN103106563A (en) | Method and device for generating dedicated bill of material for producing printed circuit board | |
| CN102298739A (en) | Method for changing bill of materials (BOM) and apparatus thereof | |
| CN105205038A (en) | Complete material list table generation method and device | |
| CN102063355B (en) | Automatic test server and system of disk array | |
| CN109992567A (en) | One kind is based on the matched PCB package file search method of figure | |
| CN103164573B (en) | PDM managing and designing system | |
| CN105278961A (en) | Method and system for generating database table structure document | |
| CN112085302A (en) | Cigarette quality tracing system, method, storage medium and electronic terminal | |
| CN100498808C (en) | Printing circuit board element height outputting method and device thereof | |
| CN102855305B (en) | Data upgrading method and device | |
| CN103853895A (en) | Method and device for designing PCB (Printed Circuit Board) | |
| CN105573774A (en) | Application parameter managing and configuring method | |
| CN102306163A (en) | Dynamic integration technology based on B2B (business to business) platform | |
| CN113705143B (en) | Automatic simulation system and automatic simulation method | |
| CN102375889A (en) | Method for constructing webpage through webpage construction database | |
| CN102243663A (en) | Dynamic labeling method based on electronic drawing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150916 |