CN110503378A - A kind of BOM standardized method, system and electronic equipment and storage medium - Google Patents
A kind of BOM standardized method, system and electronic equipment and storage medium Download PDFInfo
- Publication number
- CN110503378A CN110503378A CN201910797386.6A CN201910797386A CN110503378A CN 110503378 A CN110503378 A CN 110503378A CN 201910797386 A CN201910797386 A CN 201910797386A CN 110503378 A CN110503378 A CN 110503378A
- Authority
- CN
- China
- Prior art keywords
- bom
- column
- original
- standard
- matching
- 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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Machine Translation (AREA)
Abstract
This application discloses a kind of BOM standardized method, system and a kind of electronic equipment and computer readable storage mediums, this method comprises: obtaining original BOM；Auto-matching is carried out to the column heading in the column heading and standard BOM in original BOM using default corresponding relationship, obtains matching result；Based on the matching result by the contents extraction arranged in the original BOM into the corresponding column of the standard BOM.From the above, it can be seen that, the application is after getting the original BOM of separate sources, original BOM and standard BOM will be matched automatically using the default corresponding relationship of column heading, so as to be arranged in original BOM according to matching result, the interior content saved is corresponding to be extracted into standard BOM, realize the standardization of BOM, human resources and time cost have been effectively saved, working efficiency is significantly improved.
Description
Technical field
This application involves handling of goods and materials technical fields, more specifically to a kind of BOM standardized method, system and one
Kind electronic equipment and a kind of computer readable storage medium.
Background technique
BOM (full name in English: bill of material；Chinese name: bill of materials), it is for recording a product institute
Need the table of all electronic components and spare part.Since the inside template of each electronics R & D Enterprises is different, separate sources
BOM format differs greatly, if wanting, the demand that client is got from different BOM to help client to find required material, is needed
Manually to tell which information belongs to parameter, which information belongs to model etc. from the original BOM of client, and manual copy is extremely
In standardized BOM, cause to waste certain manpower and material resources.
Therefore, how to solve the above problems is that those skilled in the art need to pay close attention to.
Summary of the invention
The application's is designed to provide a kind of BOM standardized method, system and a kind of electronic equipment and a kind of computer
Readable storage medium storing program for executing has been effectively saved human resources and time cost, significantly improves working efficiency.
To achieve the above object, this application provides a kind of BOM standardized methods, comprising:
Obtain original BOM；
Auto-matching is carried out to the column heading in the column heading and standard BOM in original BOM using default corresponding relationship, is obtained
To matching result；
Based on the matching result by the contents extraction arranged in the original BOM into the corresponding column of the standard BOM.
Optionally, described that the column heading in the column heading and standard BOM in original BOM is carried out using default corresponding relationship
Before Auto-matching, further includes:
Whether matching operation is carried out to the original column in the original BOM using identification information judgment, and according to judgement
As a result determine whether to start it is described using default corresponding relationship to the column heading in the column heading and standard BOM in original BOM into
The step of row Auto-matching.
Optionally, described that the column heading in the column heading and standard BOM in original BOM is carried out using default corresponding relationship
Auto-matching obtains matching result, comprising:
According in the standard BOM when the corresponding title feature dictionary in forefront is to all column headings in the original BOM
Carry out Auto-matching；
If successful match, by the original column in the original BOM labeled as described when the corresponding candidate column in forefront.
Optionally, the contents extraction that will be arranged in the original BOM based on the matching result is into the standard BOM
In corresponding column, comprising:
It is directly that the candidate contents extraction arranged is corresponding into the standard BOM if the candidate is classified as one
In column；
If the candidate is classified as multiple, target column is determined from the candidate column, and by the content of the target column
It extracts into the standard BOM in corresponding column.
It is optionally, described to determine target column from the candidate column, comprising:
According to the column content progress in the standard BOM when the corresponding content characteristic dictionary in forefront to each candidate column
Matching；
The effective information density of each candidate column is determined using the matching result；
The corresponding candidate column of maximum value in all effective information density are determined as the target column.
Optionally, further includes:
Receive BOM more new command；
It is modified based on the BOM more new command to the standard BOM.
Optionally, further includes:
Determine the parameter column that multiple types parameter is saved in the standard BOM；
According to the column heading of the standard BOM by a plurality of types of parameter extractions in parameter column to the standard BOM
In the corresponding column of each parameter type.
To achieve the above object, this application provides a kind of BOM standardized systems, comprising:
Module is obtained, for obtaining original BOM；
Matching module, for using default corresponding relationship to the column heading in the column heading and standard BOM in original BOM into
Row Auto-matching, obtains matching result；
Extraction module, for based on the matching result by the contents extraction arranged in the original BOM to the standard BOM
In corresponding column.
Optionally, further includes:
Receiving module, for receiving BOM more new command；
Modified module, for being modified based on the BOM more new command to the standard BOM.
To achieve the above object, this application provides a kind of electronic equipment, comprising:
Memory, for storing computer program；
Processor realizes the step of aforementioned disclosed any BOM standardized method when for executing the computer program
Suddenly.
To achieve the above object, this application provides a kind of computer readable storage medium, the computer-readable storages
Computer program is stored on medium, the computer program realizes aforementioned disclosed any BOM mark when being executed by processor
The step of quasi-ization method.
By above scheme it is found that a kind of BOM standardized method provided by the present application, comprising: obtain original BOM；It utilizes
Default corresponding relationship carries out Auto-matching to the column heading in the column heading and standard BOM in original BOM, obtains matching result；
Based on the matching result by the contents extraction arranged in the original BOM into the corresponding column of the standard BOM.From the foregoing, it will be observed that
The application will utilize the default corresponding relationship of column heading automatically to original BOM and mark after getting the original BOM of separate sources
Quasi- BOM is matched, and so as to be arranged in original BOM according to matching result, the interior content saved is corresponding to be extracted to standard BOM
In, it realizes the standardization of BOM, has been effectively saved human resources and time cost, significantly improve working efficiency.
Disclosed herein as well is a kind of BOM standardized system and a kind of electronic equipment and a kind of computer-readable storage mediums
Matter is equally able to achieve above-mentioned technical effect.
It should be understood that the above general description and the following detailed description are merely exemplary, this can not be limited
Application.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of application for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 is a kind of flow chart of BOM standardized method disclosed in the embodiment of the present application；
Fig. 2 is the flow chart of another kind BOM standardized method disclosed in the embodiment of the present application；
Fig. 3 is the flow chart of another BOM standardized method disclosed in the embodiment of the present application；
Fig. 4 is a kind of flow chart of specific BOM standardized method disclosed in the embodiment of the present application；
Fig. 5 is a kind of structure chart of BOM standardized system disclosed in the embodiment of the present application；
Fig. 6 is the structure chart of a kind of electronic equipment disclosed in the embodiment of the present application；
Fig. 7 is the structure chart of another kind electronic equipment disclosed in the embodiment of the present application.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of embodiments of the present application, instead of all the embodiments.It is based on
Embodiment in the application, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall in the protection scope of this application.
In traditional technology, since the inside template of each electronics R & D Enterprises is different, the BOM format difference of separate sources is very
Greatly, if wanting, the demand that client is got from different BOM to help client to find required material, needs manually from client's
Tell which information belongs to parameter, which information belongs to model etc. in original BOM, and manual copy is into standardized BOM,
Cause to waste certain manpower and material resources.
Therefore, the embodiment of the present application discloses a kind of BOM standardized method, be effectively saved human resources and time at
This, significantly improves working efficiency.
Shown in Figure 1, a kind of BOM standardized method disclosed in the embodiment of the present application includes:
S11: original BOM is obtained；
In the specific implementation process, it is necessary first to obtain the original BOM of the client of separate sources.Specifically, it can use
The wireless communication modes such as network, bluetooth receive original BOM, or can import original BOM by preset interface or data line.This hair
It is bright to be not specifically limited in this embodiment.
It should be noted that the embodiment of the present application specifically can be applied to a variety of intelligent terminals or server-side, wherein intelligence
Terminal can include but is not limited to: smart phone, tablet computer, PC, PDA, wearable device and wear display equipment etc.；Service
End can include but is not limited to: single network server, multiple network servers composition server group or based on cloud computing by
The cloud that a large number of computers or network servers is constituted.
S12: automatic is carried out to the column heading in the column heading and standard BOM in original BOM using default corresponding relationship
Match, obtains matching result；
In the present embodiment, the column heading and standard in the default original BOM of corresponding relationship Auto-matching of column heading will be utilized
Column heading in BOM.It in a specific embodiment, can be corresponding for the column heading setting of each column of standard BOM in advance
Title feature dictionary, therefore can use the corresponding title feature dictionary of each column and all column headings in original BOM are carried out
Matching, to identify in original BOM and when the matched column in forefront.
It is understood that when being in advance that column heading sets corresponding title feature dictionary in standard BOM in the present embodiment,
It can be by obtaining the history BOM of a large amount of separate sources, and it is screened out from it title corresponding with the column heading in standard BOM,
And then feature extraction is carried out to a large amount of column heading, obtain the highest phrase of the wherein frequency of occurrences or character, and by various titles
Possibility deposit in the title feature dictionary constructed in advance.For example, for the installation position of the electronic component saved in BOM
It sets, corresponding column heading can have a variety of representations such as position number, point, installation position, welding position in different BOM, this
A variety of may save to the column heading of standard BOM can be in " installation site " corresponding title feature dictionary by embodiment.
S13: based on the matching result by the contents extraction arranged in the original BOM to the corresponding column of the standard BOM
In.
In this step, matched carrying out Auto-matching to the column heading in the column heading and standard BOM in original BOM
It as a result, will be corresponding to standard BOM by the contents extraction arranged in the original BOM of successful match based on matching result obtained above after
Column in.
On the basis of the above embodiments, preferably, the present embodiment can further include: receive
BOM more new command；It is modified based on BOM more new command to standard BOM.Specifically, display device or display screen can be passed through
There is provided interactive operation interface for user, so as to user mouse click or touch by way of in the drop-down list of standard BOM
The column heading of original BOM is chosen, so as to copy to the content of original BOM permutation in standard BOM；In addition, user may be used also
Individually to edit each of original BOM cell by the interactive operation interface, the modification to standard BOM is realized.
In addition, in specific implementation, it is contemplated that the multiple parameters of electronic component may be stored in together by some original BOM
The case where one column, the present embodiment it is above-mentioned by the contents extraction arranged in original BOM to the corresponding column of standard BOM after, will also be from
Multiple parameters are extracted in the parameter column of standard BOM, are stored in the corresponding column of the parameter.It specifically can be based on column content
The extraction of feature progress parameter.Wherein, parameter is classified as the column that the present embodiment is pre-set in standard BOM, the column and original BOM
The column of middle storage multiple types parameter are corresponding.
By above scheme it is found that a kind of BOM standardized method provided by the present application, comprising: obtain original BOM；It utilizes
Default corresponding relationship carries out Auto-matching to the column heading in the column heading and standard BOM in original BOM, obtains matching result；
Based on the matching result by the contents extraction arranged in the original BOM into the corresponding column of the standard BOM.From the foregoing, it will be observed that
The application will utilize the default corresponding relationship of column heading automatically to original BOM and mark after getting the original BOM of separate sources
Quasi- BOM is matched, and so as to be arranged in original BOM according to matching result, the interior content saved is corresponding to be extracted to standard BOM
In, it realizes the standardization of BOM, has been effectively saved human resources and time cost, significantly improve working efficiency.
The embodiment of the present application discloses another BOM standardized method, and relative to a upper embodiment, the present embodiment is to technology
Scheme has made further instruction and optimization.It is shown in Figure 2, specific:
S21: original BOM is obtained；
S22: whether matching operation has been carried out to the original column in the original BOM using identification information judgment；
S23: if it is not, then using default corresponding relationship to the column heading in the column heading and standard BOM in original BOM into
Row Auto-matching, obtains matching result；
S24: based on the matching result by the contents extraction arranged in the original BOM to the corresponding column of the standard BOM
In.
It is understood that utilizing default corresponding relationship to the column in the column heading and standard BOM in original BOM each
After title carries out Auto-matching, if successful match, respective column in current matching successfully original BOM can be marked
Note, thus before matching next time, by identifying whether the column in original BOM include above-mentioned identification information, it can be learnt that the column
Whether successful match characterizes non-successful match, then needs to continue matching operation, then if not including identification information
Starting step S23 carries out Auto-matching to the column heading in the column heading and standard BOM in original BOM using default corresponding relationship
Process；If characterizing successful match comprising identification information, without matching again to the column, repetition can be avoided
Matching, further saves the working time.
Further, if after whole matching process, there are still the column for not including identification information in original BOM, i.e.,
The column and the non-successful match of either rank in standard BOM, then it represents that the corresponding column heading of the column fails by title feature dictionary institute
Record, therefore the column heading of the column can be prompted to staff by modes such as the pages or voice, so as to staff couple
The column heading is added in title feature dictionary after being analyzed, and realizes the real-time update of title feature dictionary, subsequent to improve
Matching precision.
The embodiment of the present application discloses another BOM standardized method, and relative to a upper embodiment, the present embodiment is to technology
Scheme has made further instruction and optimization.It is shown in Figure 3, specific:
S31: original BOM is obtained；
S32: automatic is carried out to the column heading in the column heading and standard BOM in original BOM using default corresponding relationship
Match；
S33: if successful match, by the original column in the original BOM labeled as described when the corresponding candidate column in forefront；
S34: directly that the candidate contents extraction arranged is right into the standard BOM if the candidate is classified as one
In the column answered；
S35: if the candidate is classified as multiple, determining target column from the candidate column, and by the target column
Contents extraction is into the standard BOM in corresponding column.
In the present embodiment, using default corresponding relationship to the column heading in the column heading and standard BOM in original BOM into
After row Auto-matching, if successful match, by the original column of successful match in original BOM labeled as candidate column.It is understood that
It is, it, can be directly by the contents extraction of the candidate Lie Nei into Current standards BOM in corresponding column if candidate is classified as one；
If candidate is classified as multiple, the column headings for characterizing multiple candidate column may need in the title feature dictionary pattern matching success of the column
Multiple candidate column are further identified, therefrom determine with the target column when forefront best match, so as to by target column
Contents extraction into Current standards BOM in corresponding column.
Specifically, the above-mentioned process that target column is determined from candidate column may include: according to current in the standard BOM
Corresponding content characteristic dictionary is arranged to match the column content of each candidate column；It is determined using the matching result each
The effective information density of the candidate column；The corresponding candidate column of maximum value in all effective information density are determined as institute
State target column.
It is understood that in the corresponding feature-modeling of content that the present embodiment can also be stored up previously according to each column memory
Hold characteristics dictionary, to further match to the content of column memory storage after column heading successful match, to ensure to match knot
The accuracy of fruit improves the standardized precision of BOM.According to when the corresponding content characteristic dictionary in forefront is to the column of each candidate column
It after content is matched, determines and obtains the effective information density of each candidate column, and by effective information density in all candidate column
Maximum candidate column are determined as target column.Wherein, effective information density refers specifically in the content of column memory storage, with content characteristic word
The information of allusion quotation successful match accounts for the ratio of total information.
Fig. 4 is a kind of flow chart of specific BOM standardized method provided by the embodiments of the present application, as shown in figure 4, this reality
Example is applied specifically according to the header identification permutation of column, with the target column in matching criteria BOM.Since the first row of original BOM
Match, first determines whether the column have been marked as some column of standard BOM；If the column are not labeled as some column of standard BOM,
Then according to the title of the title feature dictionary pattern matching of the target column column, and the column are arranged labeled as candidate after successful match, mark
Continue to judge whether there is next column after note, if it exists next column, then continues according under the title feature dictionary pattern matching of target column
The title of one column；If the column have been marked as some column of standard BOM or above-mentioned matching result is failure, directly judge whether
There are next columns, if there is next column, then carry out above-mentioned matching operation to next column；If there is no next column, then judge
It is arranged with the presence or absence of mark candidate, and determines the number of mark candidate column；If the candidate of label is classified as zero, terminate work at present
Process；If the candidate of label is classified as one, which is gone forward side by side ranks contents extraction labeled as target column；If the candidate column of label
To be multiple, then multiple candidate column are identified based on the content characteristic of target column, obtains the corresponding effective letter of each candidate column
Density is ceased, the highest column of effective information density are labeled as target column.
A kind of BOM standardized system provided by the embodiments of the present application is introduced below, a kind of BOM mark described below
Quasi-ization system can be cross-referenced with a kind of above-described BOM standardized method.
Shown in Figure 5, a kind of BOM standardized system provided by the embodiments of the present application includes:
Module 101 is obtained, for obtaining original BOM；
Matching module 102, for utilizing default corresponding relationship to the column mark in the column heading and standard BOM in original BOM
Topic carries out Auto-matching, obtains matching result；
Extraction module 103, for based on the matching result by the contents extraction arranged in the original BOM to the standard
In the corresponding column of BOM.
On the basis of the above embodiments, BOM standardization provided by the embodiments of the present application as a preferred implementation manner,
System can further include:
Receiving module, for receiving BOM more new command；
Modified module, for being modified based on the BOM more new command to the standard BOM.
On the basis of the above embodiments, BOM standardization provided by the embodiments of the present application as a preferred implementation manner,
System can further include:
Judgment module, for whether having carried out matching behaviour to the original column in the original BOM using identification information judgment
Make, and determines whether that starting described utilize presets corresponding relationship to the column heading and standard BOM in original BOM according to judging result
In column heading carry out Auto-matching the step of.
On the basis of the above embodiments, BOM standardization provided by the embodiments of the present application as a preferred implementation manner,
Matching module in system may include:
Automatic matching unit, for according in the standard BOM when the corresponding title feature dictionary in forefront is to described original
All column headings in BOM carry out Auto-matching；
Candidates unit, if the column heading in the original BOM succeeds with the title feature dictionary pattern matching,
By the original column in the original BOM labeled as described when the corresponding candidate column in forefront.
On the basis of the above embodiments, BOM standardization provided by the embodiments of the present application as a preferred implementation manner,
Extraction module in system may include:
Direct extraction unit, if being classified as one for the candidate, directly by the contents extraction of the candidate column to institute
It states in standard BOM in corresponding column；
Target determination unit determines target column from the candidate column, and will if being classified as the candidate multiple
The contents extraction of the target column is into the standard BOM in corresponding column.
On the basis of the above embodiments, BOM standardization provided by the embodiments of the present application as a preferred implementation manner,
Target determination unit in system may include:
Content matching subelement, for according in the standard BOM when the corresponding content characteristic dictionary in forefront is to each institute
The column content for stating candidate column is matched；
Density determines subelement, for determining the effective information density of each candidate column using the matching result；
Target determines subelement, for being determined as the corresponding candidate column of the maximum value in all effective information density
The target column.
On the basis of the above embodiments, BOM standardization provided by the embodiments of the present application as a preferred implementation manner,
System can further include:
Parameter column determining module, for determining the parameter column for saving multiple types parameter in the standard BOM；
Parameter extraction module, for according to the column heading of the standard BOM by a plurality of types of parameters in parameter column
It extracts into the corresponding column of each parameter type of standard BOM.
It can refer to particular content disclosed in previous embodiment about above-mentioned module and the more specifical course of work of unit, this
Embodiment no longer repeats this.
Present invention also provides a kind of electronic equipment, shown in Figure 6, a kind of electronic equipment provided by the embodiments of the present application
Include:
Memory 100, for storing computer program；
The standardization of BOM provided by above-described embodiment may be implemented in processor 200 when for executing the computer program
The step of method.
Specifically, memory 100 includes non-volatile memory medium, built-in storage.Non-volatile memory medium storage
There are operating system and computer-readable instruction, which is that the operating system and computer in non-volatile memory medium can
The operation of reading instruction provides environment.Processor 200 can be a central processing unit (Central in some embodiments
Processing Unit, CPU), controller, microcontroller, microprocessor or other data processing chips, mentioned for electronic equipment
For calculating and control ability, when executing the computer program saved in the memory 100, aforementioned any implementation may be implemented
The step of BOM standardized method provided by example.
On the basis of the above embodiments, preferably, shown in Figure 7, the electronic equipment further include:
Input interface 300 is connected with processor 200, for obtaining computer program, parameter and the instruction of external importing,
It saves through the control of processor 200 into memory 100.The input interface 300 can be connected with input unit, and it is manual to receive user
The parameter or instruction of input.The input unit can be the touch layer covered on display screen, be also possible to be arranged in terminal enclosure
Key, trace ball or Trackpad, be also possible to keyboard, Trackpad or mouse etc..
Display unit 400 is connected with processor 200, for video-stream processor 200 processing data and for show can
Depending on the user interface changed.The display unit 400 can for light-emitting diode display, liquid crystal display, touch-control liquid crystal display and
OLED (Organic Light-Emitting Diode, Organic Light Emitting Diode) touches device etc..
The network port 500 is connected with processor 200, for being communicatively coupled with external each terminal device.The communication link
The communication technology used by connecing can be cable communicating technology or wireless communication technique, and such as mobile high definition chained technology (MHL) leads to
It is blue with universal serial bus (USB), high-definition media interface (HDMI), adopting wireless fidelity technology (WiFi), Bluetooth Communication Technology, low-power consumption
The tooth communication technology, communication technology based on IEEE802.11s etc..
Fig. 7 illustrates only the electronic equipment with component 100-500, it will be appreciated by persons skilled in the art that Fig. 7 shows
Structure out does not constitute the restriction to electronic equipment, may include than illustrating less perhaps more components or combining certain
A little components or different component layouts.
Present invention also provides a kind of computer readable storage medium, the storage medium may include: USB flash disk, mobile hard disk,
Read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic
The various media that can store program code such as dish or CD.Computer program, the calculating are stored on the storage medium
Machine program realizes the step of BOM standardized method provided by aforementioned any embodiment when being executed by processor.
From the foregoing, it will be observed that the application after getting the original BOM of separate sources, will utilize the default corresponding relationship of column heading
Automatically original BOM and standard BOM are matched, so as to which the interior content saved will be arranged in original BOM according to matching result
It is corresponding to extract into standard BOM, it realizes the standardization of BOM, has been effectively saved human resources and time cost, significantly improve
Working efficiency.
Each embodiment is described in a progressive manner in specification, the highlights of each of the examples are with other realities
The difference of example is applied, the same or similar parts in each embodiment may refer to each other.For system disclosed in embodiment
Speech, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is referring to method part illustration
.It should be pointed out that for those skilled in the art, under the premise of not departing from the application principle, also
Can to the application, some improvement and modification can also be carried out, these improvement and modification also fall into the protection scope of the claim of this application
It is interior.
It should also be noted that, in the present specification, relational terms such as first and second and the like be used merely to by
One entity or operation are distinguished with another entity or operation, without necessarily requiring or implying these entities or operation
Between there are any actual relationship or orders.Moreover, the terms "include", "comprise" or its any other variant meaning
Covering non-exclusive inclusion, so that the process, method, article or equipment for including a series of elements not only includes that
A little elements, but also including other elements that are not explicitly listed, or further include for this process, method, article or
The intrinsic element of equipment.In the absence of more restrictions, the element limited by sentence "including a ...", is not arranged
Except there is also other identical elements in the process, method, article or apparatus that includes the element.
Claims (10)
1. a kind of BOM standardized method characterized by comprising
Obtain original BOM；
Auto-matching is carried out to the column heading in the column heading and standard BOM in original BOM using default corresponding relationship, is obtained
With result；
Based on the matching result by the contents extraction arranged in the original BOM into the corresponding column of the standard BOM.
2. BOM standardized method according to claim 1, which is characterized in that described to utilize default corresponding relationship to original
Column heading in column heading and standard BOM in BOM carries out before Auto-matching, further includes:
Whether matching operation is carried out to the original column in the original BOM using identification information judgment, and according to judging result
Determine whether to start it is described using default corresponding relationship to the column heading in the column heading and standard BOM in original BOM carry out from
The step of dynamic matching.
3. BOM standardized method according to claim 1, which is characterized in that described to utilize default corresponding relationship to original
Column heading in column heading and standard BOM in BOM carries out Auto-matching, obtains matching result, comprising:
According in the standard BOM when the corresponding title feature dictionary in forefront in the original BOM all column headings carry out
Auto-matching；
If successful match, by the original column in the original BOM labeled as described when the corresponding candidate column in forefront.
4. BOM standardized method according to claim 3, which is characterized in that it is described will be described based on the matching result
The contents extraction arranged in original BOM is into the standard BOM in corresponding column, comprising:
If the candidate is classified as one, the contents extraction for directly arranging the candidate is into the standard BOM in corresponding column；
If the candidate is classified as multiple, target column is determined from the candidate column, and by the contents extraction of the target column
Into corresponding column in the standard BOM.
5. BOM standardized method according to claim 4, which is characterized in that described to determine mesh from the candidate column
Mark column, comprising:
According to the column content progress in the standard BOM when the corresponding content characteristic dictionary in forefront to each candidate column
Match；
The effective information density of each candidate column is determined using the matching result；
The corresponding candidate column of maximum value in all effective information density are determined as the target column.
6. BOM standardized method according to any one of claims 1 to 5, which is characterized in that further include:
Receive BOM more new command；
It is modified based on the BOM more new command to the standard BOM.
7. BOM standardized method according to claim 6, which is characterized in that further include:
Determine the parameter column that multiple types parameter is saved in the standard BOM；
A plurality of types of parameter extractions in parameter column to the standard BOM are respectively joined according to the column heading of the standard BOM
In the corresponding column of several classes of types.
8. a kind of BOM standardized system characterized by comprising
Module is obtained, for obtaining original BOM；
Matching module, for being carried out certainly using default corresponding relationship to the column heading in the column heading and standard BOM in original BOM
Dynamic matching, obtains matching result；
Extraction module, for based on the matching result that the contents extraction arranged in the original BOM is corresponding to the standard BOM
Column in.
9. a kind of electronic equipment characterized by comprising
Memory, for storing computer program；
Processor realizes the BOM standardized method as described in any one of claim 1 to 7 when for executing the computer program
The step of.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program, realizing the BOM standardized method as described in any one of claim 1 to 7 when the computer program is executed by processor
Step.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910797386.6A CN110503378A (en) | 2019-08-27 | 2019-08-27 | A kind of BOM standardized method, system and electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910797386.6A CN110503378A (en) | 2019-08-27 | 2019-08-27 | A kind of BOM standardized method, system and electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110503378A true CN110503378A (en) | 2019-11-26 |
Family
ID=68590070
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910797386.6A Pending CN110503378A (en) | 2019-08-27 | 2019-08-27 | A kind of BOM standardized method, system and electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110503378A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143278A (en) * | 2019-12-04 | 2020-05-12 | 深圳市铭华航电工艺技术有限公司 | Electronic assembly-based bill of material processing method, device, equipment and readable medium |
| CN113627892A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107038555A (en) * | 2017-04-10 | 2017-08-11 | 广州智造家网络科技有限公司 | A kind of BOM tables introduction method and device |
| CN110019829A (en) * | 2017-09-19 | 2019-07-16 | 小草数语（北京）科技有限公司 | Data attribute determines method, apparatus |
| CN110033206A (en) * | 2018-01-11 | 2019-07-19 | 国科赛思(北京)科技有限公司 | Bill of materials automatic Check method and device |
-
2019
- 2019-08-27 CN CN201910797386.6A patent/CN110503378A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107038555A (en) * | 2017-04-10 | 2017-08-11 | 广州智造家网络科技有限公司 | A kind of BOM tables introduction method and device |
| CN110019829A (en) * | 2017-09-19 | 2019-07-16 | 小草数语（北京）科技有限公司 | Data attribute determines method, apparatus |
| CN110033206A (en) * | 2018-01-11 | 2019-07-19 | 国科赛思(北京)科技有限公司 | Bill of materials automatic Check method and device |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143278A (en) * | 2019-12-04 | 2020-05-12 | 深圳市铭华航电工艺技术有限公司 | Electronic assembly-based bill of material processing method, device, equipment and readable medium |
| CN113627892A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
| CN113627892B (en) * | 2021-08-16 | 2023-09-01 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109948134B (en) | Report automatic generation method, system, electronic equipment and storage medium | |
| CN109819284A (en) | A kind of short video recommendation method, device, computer equipment and storage medium | |
| CN110515951A (en) | A kind of BOM standardized method, system and electronic equipment and storage medium | |
| CN108614859A (en) | Intelligent search method, server and storage medium | |
| CN110263007A (en) | A kind of file naming method, system and electronic equipment and storage medium | |
| US20110191381A1 (en) | Interactive System for Extracting Data from a Website | |
| CN111061770A (en) | BOM model matching device and method, electronic equipment and storage medium | |
| CN101796573B (en) | Display apparatus, character sequence display method, and multiple character sequence sorting method | |
| WO2022033426A1 (en) | Document processing method, document processing apparatus, and electronic device | |
| CN103455475A (en) | Typesetting method, equipment and system | |
| CN109885828A (en) | Word error correction method, device, computer equipment and medium based on language model | |
| CN108399072A (en) | Five application page update method and device | |
| CN111858905B (en) | Model training method, information identification device, electronic equipment and storage medium | |
| CN105528935A (en) | Writing sequence guidance method and device | |
| CN102193960B (en) | Content sharing system | |
| US20150039987A1 (en) | Systems and methods for data entry | |
| CN101008940B (en) | Method and device for automatic processing font missing | |
| CN110503378A (en) | A kind of BOM standardized method, system and electronic equipment and storage medium | |
| CN113127621A (en) | Dialogue module pushing method, device, equipment and storage medium | |
| CN106294480A (en) | A kind of file layout change-over method, device and examination question import system | |
| CN111611366A (en) | Intention recognition optimization processing method, device, equipment and storage medium | |
| CN106970758A (en) | Electronic document operation processing method, device and electronic equipment | |
| CN113360685A (en) | Method, device, equipment and medium for processing note content | |
| CN104346052A (en) | Method and device for Chinese characters input | |
| US9418055B2 (en) | Method for copying multiple content between applications |
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: 20191126 |
|
| RJ01 | Rejection of invention patent application after publication |