CN113836843A - PCB component information comparison method and device, terminal and storage medium - Google Patents
PCB component information comparison method and device, terminal and storage medium Download PDFInfo
- Publication number
- CN113836843A CN113836843A CN202111136836.0A CN202111136836A CN113836843A CN 113836843 A CN113836843 A CN 113836843A CN 202111136836 A CN202111136836 A CN 202111136836A CN 113836843 A CN113836843 A CN 113836843A
- Authority
- CN
- China
- Prior art keywords
- file
- pcb
- coordinate file
- coordinate
- data
- 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
- 238000000034 method Methods 0.000 title claims abstract description 38
- 238000003860 storage Methods 0.000 title claims abstract description 15
- 230000004048 modification Effects 0.000 claims abstract description 129
- 238000012986 modification Methods 0.000 claims abstract description 129
- 230000006870 function Effects 0.000 claims description 27
- 238000012216 screening Methods 0.000 claims description 11
- 238000012545 processing Methods 0.000 claims description 4
- 230000008859 change Effects 0.000 abstract description 9
- 238000004519 manufacturing process Methods 0.000 abstract description 8
- 238000010586 diagram Methods 0.000 description 20
- 230000003247 decreasing effect Effects 0.000 description 6
- 238000004590 computer program Methods 0.000 description 4
- 239000000463 material Substances 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/30—Circuit design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/162—Delete operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2115/00—Details relating to the type of the circuit
- G06F2115/12—Printed circuit boards [PCB] or multi-chip modules [MCM]
Abstract
The invention discloses a PCB component information comparison method, a device, a terminal and a storage medium, wherein the method comprises the following steps: acquiring a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification; establishing a coordinate file comparison table according to the first coordinate file and the second coordinate file; and determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table. The invention can determine the deleted and/or added components in the PCB file after board modification relative to the PCB file before board modification, so as to timely obtain the change conditions of the components before and after the board modification of the PCB, and avoid errors in BOM manufacturing.
Description
Technical Field
The invention relates to the technical field of information comparison, in particular to a method, a device, a terminal and a storage medium for information comparison of PCB components.
Background
At present, when a single-panel PCB (printed circuit board) is designed, some non-registered components are added or deleted by a designer, and the components do not enter a schematic diagram, because in the design stage of the schematic diagram, because the components are manually added or deleted when the PCB is designed and changed, the designer cannot know which components need to be added or deleted on which network by pressing the components, so that the designer has no way to embody the added or subtracted components into the schematic diagram, and the BOM (material list) is derived from the schematic diagram, so that the components are not added or deleted in the BOM, and errors occur in BOM manufacturing.
Thus, there is a need for improvements and enhancements in the art.
Disclosure of Invention
The technical problem to be solved by the present invention is to provide a method, an apparatus, a terminal and a storage medium for comparing PCB component information, aiming at solving the problem in the prior art that a designer cannot know which components are increased or decreased, and the increased or decreased components cannot be embodied in a schematic diagram, so that a BOM manufacturing error occurs.
In order to solve the technical problems, the technical scheme adopted by the invention is as follows:
in a first aspect, the present invention provides a method for comparing PCB component information, wherein the method includes:
acquiring a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification;
establishing a coordinate file comparison table according to the first coordinate file and the second coordinate file;
and determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table.
In one implementation manner, the obtaining a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification includes:
acquiring the PCB file before board modification, and deriving the first coordinate file from the PCB file before board modification;
and acquiring the PCB file after board modification, and deriving the second coordinate file from the PCB file after board modification.
In one implementation, the building a coordinate file comparison table according to the first coordinate file and the second coordinate file includes:
sequentially calling and matching data in the first coordinate file and the second coordinate file, and filling the called and matched data into a blank table to obtain a first table;
and sequentially calling and matching the data in the second coordinate file and the data in the first coordinate file, and filling the called and matched data into the first table to obtain the coordinate file comparison table.
In one implementation manner, the sequentially performing calling and matching operations on the data in the first coordinate file and the data in the second coordinate file, and filling the data obtained by calling and matching into a blank table to obtain a first table includes:
calling a second row of data in the first coordinate file according to a preset first function, and filling the called second row of data in the first coordinate file into a first row of the blank table;
searching a plurality of lines of matched data in the first coordinate file according to a preset second function, and sequentially filling the plurality of lines of matched data in the first coordinate file into the blank table;
and searching a plurality of matched lines of data in the second coordinate file by adopting the second function according to the second lines of data in the first coordinate file, and sequentially filling the plurality of matched lines of data in the second coordinate file into the blank table to obtain the first table.
In one implementation manner, the sequentially performing calling and matching operations on the data in the second coordinate file and the data in the first coordinate file, and filling the data obtained by calling and matching into the first table to obtain the coordinate file comparison table includes:
calling a second line of data in the second coordinate file according to the first function, and filling the called second line of data in the second coordinate file into the first table;
searching a plurality of lines of matched data in the second coordinate file according to a preset second function, and sequentially filling the plurality of lines of matched data in the second coordinate file into the first table;
and searching a plurality of matched rows of data in the first coordinate file by adopting the second function according to the second rows of data in the second coordinate file, and sequentially filling the plurality of rows of data matched in the first coordinate file into the first table to obtain the coordinate file comparison table.
In one implementation manner, the determining, according to the coordinate file comparison table, a component deleted and/or added from the PCB file after board modification relative to the PCB file before board modification includes:
acquiring data of a first table part in the coordinate file comparison table;
and screening the data of the first table part according to a preset third function, and determining the deleted components of the PCB file after board modification relative to the PCB file before board modification.
In one implementation manner, the determining, according to the coordinate file comparison table, a component deleted and/or added from the PCB file after board modification relative to the PCB file before board modification includes:
acquiring data except for a first table part in the coordinate file comparison table;
and screening the data except the first table part in the coordinate file comparison table according to a preset third function, and determining the components added in the PCB file after board modification relative to the PCB file before board modification.
In a second aspect, an embodiment of the present invention provides a PCB component information comparison apparatus, where the apparatus includes:
the system comprises a coordinate file acquisition module, a first processing module and a second processing module, wherein the coordinate file acquisition module is used for acquiring a PCB file before board modification and a PCB file after board modification, acquiring a first coordinate file according to the PCB file before board modification and acquiring a second coordinate file according to the PCB file after board modification;
the coordinate file comparison table building module is used for building a coordinate file comparison table according to the first coordinate file and the second coordinate file;
and the component comparison module is used for determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table.
In a third aspect, an embodiment of the present invention further provides a terminal, where the terminal includes a memory, a processor, and a PCB component information comparison program or a data decryption processing program that is stored in the memory and is executable on the processor, and when the processor executes the PCB component information comparison program or the data decryption processing program, the steps of the PCB component information comparison method according to any one of the foregoing schemes are implemented.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, where a PCB component information comparison program or a data decryption processing program is stored in the computer-readable storage medium, and when the PCB component information comparison program or the data decryption processing program is executed by a processor, the steps of the PCB component information comparison method in any one of the foregoing schemes are implemented.
Has the advantages that: compared with the prior art, the invention provides a PCB component information comparison method, which comprises the following steps: acquiring a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification; establishing a coordinate file comparison table according to the first coordinate file and the second coordinate file; and determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table. According to the invention, the coordinate file comparison table is established, and the deleted and/or added components in the PCB file after board modification relative to the PCB file before board modification can be determined according to the coordinate file comparison table after board modification, so that the change conditions of the components before and after PCB modification can be timely known, and errors can be avoided during BOM manufacturing.
Drawings
Fig. 1 is a flowchart of a specific implementation of a PCB component information comparison method according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of a first coordinate file in the PCB component information comparison method according to the embodiment of the present invention.
Fig. 3 is a schematic diagram of a second coordinate file in the PCB component information comparison method according to the embodiment of the present invention.
Fig. 4 is a schematic diagram illustrating a coordinate file comparison table in the PCB component information comparison method according to the embodiment of the present invention is set in a screening form.
Fig. 5 is a schematic diagram of components determined to be deleted in the PCB component information comparison method according to the embodiment of the present invention.
Fig. 6 is a schematic diagram of determining an added component in the PCB component information comparison method according to the embodiment of the present invention.
Fig. 7 is a schematic block diagram of a PCB component information comparing device according to an embodiment of the present invention.
Fig. 8 is a schematic block diagram of an internal structure of a terminal according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and effects of the present invention clearer and clearer, the present invention is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
It will be understood by those skilled in the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the prior art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
Research shows that some unregistered components are added or deleted by a designer when a single-panel PCB (printed circuit board) is designed currently, and the components do not enter a schematic diagram, because in the design stage of the schematic diagram, because the components are manually increased or decreased when the PCB is designed and changed, the designer cannot know which components need to be added or deleted on which network after pressing the components, so that the designer has no way to embody the increased or decreased components in the schematic diagram, and the BOM (material list) is derived from the schematic diagram, so that the components are not added or deleted in the BOM, and errors occur in BOM manufacturing. And the coordinate file exported by the PCB file has the advantages that the number of components is increased or decreased, the sequence is different, and the common comparison method cannot meet the requirements.
In order to solve the existing problem, the embodiment provides a method for comparing information of a PCB component, and in specific implementation, the embodiment first obtains a PCB file before board modification and a PCB file after board modification, obtains a first coordinate file according to the PCB file before board modification, and obtains a second coordinate file according to the PCB file after board modification; establishing a coordinate file comparison table according to the first coordinate file and the second coordinate file; and determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table. According to the invention, the coordinate file comparison table is established, and the deleted and/or added components in the PCB file after board modification relative to the PCB file before board modification can be determined according to the coordinate file comparison table after board modification, so that the change conditions of the components before and after PCB modification can be timely known, and errors can be avoided during BOM manufacturing.
Exemplary method
The PCB component information comparison method can be applied to a terminal, and the terminal can be an intelligent terminal product such as a mobile phone and a computer. As shown in fig. 1, the PCB component information comparison method in this embodiment includes the following steps:
step S100, obtaining a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification.
In this embodiment, since the designer needs to timely learn the components added and subtracted in the PCB before and after board modification so that no error occurs in the manufacture of the BOM (bill of materials), for this purpose, in this embodiment, the PCB file before board modification and the PCB file after board modification are first obtained, the first coordinate file is obtained according to the PCB file before board modification, and the second coordinate file is obtained according to the PCB file after board modification. In specific implementation, after the PCB file before board modification is obtained, the first coordinate file is derived from the PCB file before board modification, and the first coordinate file is stored as "book 1. xls" as shown in fig. 2. After the modified PCB file is obtained, the second coordinate file is derived from the modified PCB file, and the second coordinate file is stored as "book 2. xls" as shown in fig. 3. The first coordinate file and the second coordinate file in this embodiment respectively reflect components on the PCB before and after board change.
After the first coordinate file and the second coordinate file are obtained, in this embodiment, step S200 is executed to construct a coordinate file comparison table according to the first coordinate file and the second coordinate file.
Since the first coordinate file and the second coordinate file respectively reflect the components on the PCB before and after board changing, the embodiment may generate the coordinate file comparison table based on the first coordinate file and the second coordinate file, so that the difference between the components on the PCB before and after board changing may be determined based on the coordinate file comparison table, and whether there are increased or decreased components. Specifically, in this embodiment, first, a call and a matching operation are sequentially performed on data in the first coordinate file and the second coordinate file, and the data obtained by the call and the matching are filled in a blank table to obtain a first table. After the first table is obtained, the present embodiment continues to sequentially perform the calling and matching operations on the data in the second coordinate file and the data in the first coordinate file, and fills the data obtained by the calling and matching into the first table to obtain the coordinate file comparison table. That is, the coordinate file comparison table in the present embodiment is created based on the blank table and then created based on the first table.
In specific application, when the first table is created, according to a preset first function, the second line of data in the first coordinate file (i.e., BOOK1) is called, and the called second line of data in the first coordinate file (i.e., BOOK1) is filled into the first line of the blank table. Then, according to a preset second function, a plurality of lines of matched data are searched in the first coordinate file (i.e., BOOK1), and the plurality of lines of matched data from the first coordinate file (i.e., BOOK1) are sequentially filled into the blank table, that is, the data searched for matching in the BOOK1 are filled in the 2 nd, 3 rd, 4 th. Then, the second function is adopted to find out a plurality of matched columns of data in the second coordinate file (i.e. BOOK2) according to the second columns of data in the first coordinate file (i.e. BOOK1), and the blank table is sequentially filled with the plurality of columns of data matched in the second coordinate file (i.e. BOOK2), so that the first table is obtained. That is, in the created first table, several columns of data matched from the second coordinate file (i.e., BOOK2) are filled in the N +1 th and N +2.
After the first table is created, the present embodiment continues to call the second line of data in the second coordinate file (i.e., BOOK2) according to the first function, and fills the called second line of data in the second coordinate file (i.e., BOOK2) into the first table. Therefore, the second column of data in the second coordinate file (i.e., BOOK2) obtained by the call is filled in the (N + M + 1) th column. Then, according to a preset second function, a plurality of lines of matched data are searched in the second coordinate file (i.e., the BOOK2), and the plurality of lines of matched data in the second coordinate file (i.e., the BOOK2) are sequentially filled in the first table. That is, several lines of data matched from the second coordinate file (i.e., BOOK2) are sequentially filled in the N + M +2, N + M +3, and N + M +4. Finally, in this embodiment, according to the second column of data (i.e., the data of the N + M +1 column) in the second coordinate file (i.e., the BOOK2), the second function is adopted to find out the matched several columns of data in the first coordinate file (i.e., the BOOK1), and the first table is sequentially filled with the several columns of data matched from the first coordinate file (i.e., the BOOK1), so as to obtain the coordinate file comparison table. That is, several columns of data finally matched from the first coordinate file (i.e., BOOK1) in the coordinate file comparison table are created and filled from the N + M + H.
In this embodiment, the first function is used to call data of a certain cell in a certain table; the function of the second function: the data of the corresponding column is matched out in the subsequent column of some basic data.
After the coordinate file comparison table is constructed, in this embodiment, step S300 is executed to determine, according to the coordinate file comparison table, components deleted and/or added from the PCB file after board modification relative to the PCB file before board modification.
In specific implementation, the embodiment first obtains data of a first table part in the coordinate file comparison table; and then screening the data of the first table part according to a preset third function, and determining the deleted components of the PCB file after board modification relative to the PCB file before board modification. In a specific application, this embodiment compares data in columns with the same meaning in the first table part in the coordinate file comparison table to determine a difference grid, and in order to highlight the effect of the difference grid, this embodiment may set these comparison result tables in a "conditional format", for example, a grid with a "different" result is set to be gray, and set the 1 st row of the coordinate file comparison table in a data screening form, as shown in fig. 4, as a grid of M1 is selected for screening, and as a grid of "# N/a", the second coordinate file (i.e., BOOK2) is screened to have bit numbers of J63 and R257, and the second coordinate file is derived based on the PCB file after PCB board modification, so when PCB is modified, these 2 bit numbers are deleted, as shown in fig. 5, and thus, it is determined that the component of the PCB file after board modification is located at J63 with respect to the component deleted in the PCB file before board modification, And R257.
In another implementation manner, the embodiment may further obtain data in the coordinate file comparison table except for the first table portion; and then screening the data except the first table part in the coordinate file comparison table according to a preset third function, and determining the components added in the PCB file after board modification relative to the PCB file before board modification. Similarly, in this embodiment, comparing the data in the columns with the same meaning, selecting the grid AE1 for screening, selecting "# N/a", and screening out that the bit numbers that the first coordinate file (i.e. BOOK1) does not have are C551, J64, J90, and R266, so that it is determined that the added components in the PCB file after board modification are C551, J64, J90, and R266 relative to the PCB file before board modification, as shown in fig. 6.
It should be noted that the components compared in this embodiment belong to unregistered components, even if the registered components are deleted or added, the difference can be directly derived from the schematic diagram to change the BOM, the unregistered components need a designer to change the BOM, and the designer does not know whether the deleted or added components appear, so that the deleted and/or added components in the PCB file after board change relative to the PCB file before board change need to be determined by the PCB component information comparison method of this embodiment, so that the designer can learn in time, and errors in making the BOM are avoided.
Exemplary devices
Based on the foregoing embodiment, this embodiment further provides a PCB component information comparison device, as shown in fig. 7, the device includes: the system comprises a coordinate file acquisition module 10, a coordinate file comparison table construction module 20 and a component comparison module 30. Specifically, the coordinate file obtaining module 10 is configured to obtain a PCB file before board modification and a PCB file after board modification, obtain a first coordinate file according to the PCB file before board modification, and obtain a second coordinate file according to the PCB file after board modification. The coordinate file comparison table constructing module 20 is configured to construct a coordinate file comparison table according to the first coordinate file and the second coordinate file. And the component comparison module 30 is configured to determine, according to the coordinate file comparison table, components deleted and/or added from the PCB file after board modification relative to the PCB file before board modification.
Based on the above embodiment, the present invention further provides a terminal, which can be disposed on the wardrobe device, and a schematic block diagram of the terminal can be as shown in fig. 8. The terminal comprises a processor, a memory, a network interface, a display screen, a temperature sensor and the like which are connected through a system bus. Wherein the processor of the terminal is configured to provide computing and control capabilities. The memory of the terminal comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the terminal is used for connecting and communicating with an external terminal through a network. The computer program is executed by a processor to realize a PCB component information comparison program. The display screen of the terminal can be a liquid crystal display screen or an electronic ink display screen or an interactive screen, and the temperature sensor of the terminal is arranged in the terminal in advance and used for detecting the operating temperature of internal equipment.
It will be understood by those skilled in the art that the block diagram of fig. 8 is a block diagram of only a portion of the structure associated with the inventive arrangements and is not intended to limit the terminals to which the inventive arrangements may be applied, as the particular terminals may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a terminal is provided, where the terminal includes a memory, a processor, and a PCB component information comparison program stored in the memory and executable on the processor, and when the processor executes the PCB component information comparison program, the following operation instructions are implemented:
acquiring a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification;
establishing a coordinate file comparison table according to the first coordinate file and the second coordinate file;
and determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, databases, or other media used in embodiments provided herein may include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
In summary, the invention discloses a method, a device, a terminal and a storage medium for comparing information of PCB components, wherein the method comprises the following steps: acquiring a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification; establishing a coordinate file comparison table according to the first coordinate file and the second coordinate file; and determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table. The invention can determine the deleted and/or added components in the PCB file after board modification relative to the PCB file before board modification, so as to timely obtain the change conditions of the components before and after the board modification of the PCB, and avoid errors in BOM manufacturing.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A PCB component information comparison method is characterized by comprising the following steps:
acquiring a PCB file before board modification and a PCB file after board modification, obtaining a first coordinate file according to the PCB file before board modification, and obtaining a second coordinate file according to the PCB file after board modification;
establishing a coordinate file comparison table according to the first coordinate file and the second coordinate file;
and determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table.
2. The PCB component information comparison method of claim 1, wherein the obtaining of the PCB file before board modification and the PCB file after board modification, the obtaining of the first coordinate file according to the PCB file before board modification, and the obtaining of the second coordinate file according to the PCB file after board modification comprise:
acquiring the PCB file before board modification, and deriving the first coordinate file from the PCB file before board modification;
and acquiring the PCB file after board modification, and deriving the second coordinate file from the PCB file after board modification.
3. A PCB component information comparison method according to claim 1, wherein the constructing a coordinate file comparison table according to the first coordinate file and the second coordinate file comprises:
sequentially calling and matching data in the first coordinate file and the second coordinate file, and filling the called and matched data into a blank table to obtain a first table;
and sequentially calling and matching the data in the second coordinate file and the data in the first coordinate file, and filling the called and matched data into the first table to obtain the coordinate file comparison table.
4. A PCB component information comparison method according to claim 3, wherein the sequentially performing calling and matching operations on the data in the first coordinate file and the second coordinate file, and filling the data obtained by calling and matching into a blank table to obtain a first table comprises:
calling a second row of data in the first coordinate file according to a preset first function, and filling the called second row of data in the first coordinate file into a first row of the blank table;
searching a plurality of lines of matched data in the first coordinate file according to a preset second function, and sequentially filling the plurality of lines of matched data in the first coordinate file into the blank table;
and searching a plurality of matched lines of data in the second coordinate file by adopting the second function according to the second lines of data in the first coordinate file, and sequentially filling the plurality of matched lines of data in the second coordinate file into the blank table to obtain the first table.
5. The PCB component information comparison method of claim 4, wherein the sequentially performing calling and matching operations on the data in the second coordinate file and the data in the first coordinate file, and filling the called and matched data into the first table to obtain the coordinate file comparison table comprises:
calling a second line of data in the second coordinate file according to the first function, and filling the called second line of data in the second coordinate file into the first table;
searching a plurality of lines of matched data in the second coordinate file according to a preset second function, and sequentially filling the plurality of lines of matched data in the second coordinate file into the first table;
and searching a plurality of matched rows of data in the first coordinate file by adopting the second function according to the second rows of data in the second coordinate file, and sequentially filling the plurality of rows of data matched in the first coordinate file into the first table to obtain the coordinate file comparison table.
6. The PCB component information comparison method of claim 1, wherein the determining of the components deleted and/or added from the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table comprises:
acquiring data of a first table part in the coordinate file comparison table;
and screening the data of the first table part according to a preset third function, and determining the deleted components of the PCB file after board modification relative to the PCB file before board modification.
7. The PCB component information comparison method of claim 1, wherein the determining of the components deleted and/or added from the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table comprises:
acquiring data except for a first table part in the coordinate file comparison table;
and screening the data except the first table part in the coordinate file comparison table according to a preset third function, and determining the components added in the PCB file after board modification relative to the PCB file before board modification.
8. The utility model provides a PCB components and parts information contrast device which characterized in that, the device includes:
the system comprises a coordinate file acquisition module, a first processing module and a second processing module, wherein the coordinate file acquisition module is used for acquiring a PCB file before board modification and a PCB file after board modification, acquiring a first coordinate file according to the PCB file before board modification and acquiring a second coordinate file according to the PCB file after board modification;
the coordinate file comparison table building module is used for building a coordinate file comparison table according to the first coordinate file and the second coordinate file;
and the component comparison module is used for determining components deleted and/or added in the PCB file after board modification relative to the PCB file before board modification according to the coordinate file comparison table.
9. A terminal, characterized in that the terminal comprises a memory, a processor and a PCB component information comparison program or a data decryption processing program stored in the memory and operable on the processor, and when the processor executes the PCB component information comparison program or the data decryption processing program, the steps of the PCB component information comparison method according to any one of claims 1 to 7 are implemented.
10. A computer-readable storage medium, wherein a PCB component information comparison program or a data decryption processing program is stored on the computer-readable storage medium, and when the PCB component information comparison program or the data decryption processing program is executed by a processor, the steps of the PCB component information comparison method according to any one of claims 1 to 7 are implemented.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111136836.0A CN113836843A (en) | 2021-09-27 | 2021-09-27 | PCB component information comparison method and device, terminal and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111136836.0A CN113836843A (en) | 2021-09-27 | 2021-09-27 | PCB component information comparison method and device, terminal and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113836843A true CN113836843A (en) | 2021-12-24 |
Family
ID=78970888
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111136836.0A Pending CN113836843A (en) | 2021-09-27 | 2021-09-27 | PCB component information comparison method and device, terminal and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113836843A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102043762A (en) * | 2009-10-15 | 2011-05-04 | 北大方正集团有限公司 | Method and device for comparing layouts |
| CN102186310A (en) * | 2011-05-05 | 2011-09-14 | 深圳创维数字技术股份有限公司 | Locating method and device |
| CN107025362A (en) * | 2017-04-28 | 2017-08-08 | 无锡市同步电子科技有限公司 | A kind of method for verifying schematic diagram and PCB creation data uniformity |
| CN107315140A (en) * | 2017-06-21 | 2017-11-03 | 广州视源电子科技股份有限公司 | A kind of method, device, equipment and the storage medium of AOI detections |
| CN109963451A (en) * | 2017-12-14 | 2019-07-02 | 中国科学院长春光学精密机械与物理研究所 | A kind of localization method of printed circuit board component |
| CN111209717A (en) * | 2020-01-07 | 2020-05-29 | 深圳市一博科技股份有限公司 | Method for respectively outputting coordinates of surface-bottom layer devices |
| CN111507057A (en) * | 2020-04-22 | 2020-08-07 | 深圳市亚派光电器件有限公司 | Method and device for outputting PADS drawing and computer readable storage medium |
-
2021
- 2021-09-27 CN CN202111136836.0A patent/CN113836843A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102043762A (en) * | 2009-10-15 | 2011-05-04 | 北大方正集团有限公司 | Method and device for comparing layouts |
| CN102186310A (en) * | 2011-05-05 | 2011-09-14 | 深圳创维数字技术股份有限公司 | Locating method and device |
| CN107025362A (en) * | 2017-04-28 | 2017-08-08 | 无锡市同步电子科技有限公司 | A kind of method for verifying schematic diagram and PCB creation data uniformity |
| CN107315140A (en) * | 2017-06-21 | 2017-11-03 | 广州视源电子科技股份有限公司 | A kind of method, device, equipment and the storage medium of AOI detections |
| CN109963451A (en) * | 2017-12-14 | 2019-07-02 | 中国科学院长春光学精密机械与物理研究所 | A kind of localization method of printed circuit board component |
| CN111209717A (en) * | 2020-01-07 | 2020-05-29 | 深圳市一博科技股份有限公司 | Method for respectively outputting coordinates of surface-bottom layer devices |
| CN111507057A (en) * | 2020-04-22 | 2020-08-07 | 深圳市亚派光电器件有限公司 | Method and device for outputting PADS drawing and computer readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 硬件WIKI: "如何对比BOM差异-Spreadsheet Compare", pages 1 - 8, Retrieved from the Internet <URL:https://zhuanlan.zhihu.com/p/186152529> * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104409066A (en) | Method for acquiring gray-scale compensation value of pixel | |
| CN109657137A (en) | Public sentiment news category model building method, device, computer equipment and storage medium | |
| CN111191079A (en) | Document content acquisition method, device, equipment and storage medium | |
| US20220039001A1 (en) | Network search method and apparatus, device and storage medium | |
| CN113836843A (en) | PCB component information comparison method and device, terminal and storage medium | |
| CN106920576A (en) | A kind of method and system of inspection Nand Flash mass | |
| CN114138634B (en) | Test case selection method and device, computer equipment and storage medium | |
| US20080109778A1 (en) | Setting method of line pitch/line width layout for logic circuit | |
| CN115314339A (en) | CAN channel calibration amount duplicate checking method, duplicate checking device, processor and vehicle | |
| CN115687338A (en) | Method and device for adding identification information to projects in batch and terminal | |
| CN112992036A (en) | Display panel driving method and device and display equipment | |
| CN114333669B (en) | Sample capacity determining method, device, display equipment and storage medium | |
| US20140163917A1 (en) | Multi-sensing-elements calibration system, multi-sensing-elements calibration method and recording medium | |
| CN116935769B (en) | Detection method and system for bad characteristics of OLED display module | |
| CN113242102B (en) | Radio frequency test method and device, equipment and readable storage medium | |
| CN109918290B (en) | Automatic screening method and device for target equipment, computer equipment and storage medium | |
| CN109544661A (en) | Area drawing drawing method, device, computer equipment and storage medium | |
| CN109410815A (en) | The generation method and computer readable storage medium of display panel and its gray scale voltage | |
| CN111367816B (en) | Mobile test method and device, computer equipment and storage medium | |
| CN111625140B (en) | Touch test method and touch device | |
| CN116052798B (en) | Electronic recipe management method, system and storage medium for production execution system | |
| CN114492265B (en) | Method, equipment and storage medium for determining chip testable design | |
| CN110781071B (en) | Method and device for testing application program upgrade version and computer equipment | |
| CN113838397A (en) | Display performance testing method and device, testing equipment and storage medium | |
| US10950164B2 (en) | Method and device for determining compensation grayscale value of display panel, and display device |
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 |