Automatic equipment list importing method and device, equipment, medium and product

Abstract

The invention discloses an equipment list automatic importing method and device, equipment, a medium and a product, and relates to the technical field of automatic processing. Acquiring an equipment list; analyzing the equipment list to obtain a text library; the text library comprises at least four text sets; the text set is arranged according to the row sequence of the equipment list; and automatically importing the text content in the text library into information software based on the association relationship between the text content and the configuration item. By adopting the technical scheme, the equipment list table is segmented and automatically imported, so that the problem that manual operation is needed for batch importing at present is solved, the structure information of the equipment can be automatically identified and automatically imported to a specified position, and the working efficiency is improved.

Description

Technical Field

[0001] This invention relates to the field of automated processing technology, and in particular to a method, apparatus, equipment, medium and product for automatically importing equipment lists. Background Technology

[0002] In the electrical equipment manufacturing industry, the pricing and production BOM (Bill of Materials) for complete sets of equipment are generally project-based. A single project typically involves BOMs for hundreds to thousands of cabinets. Furthermore, due to inconsistencies in software used by different departments and companies, or variations in client bidding requirements, the format of each project's BOM varies. This necessitates that pricing and technical personnel in the complete set of equipment industry convert these disparate BOMs into a unified format and import them into their respective systems for cost accounting or manufacturing. Copper busbars, as critical conductive connectors, directly impact assembly quality and R&D cycle time with their design accuracy and efficiency. The installation and connection of copper busbars require engineers to precisely position the openings, ensuring the number of openings meets structural stability requirements.

[0003] Currently, various software programs support the requirement of batch BOM uploads, but they all specify the upload template style. This requires staff to manually adjust the existing BOMs to the software's specified format before they can be imported in batches. This results in a heavy workload for technical staff, who need to manually use Excel to make repeated adjustments. Furthermore, existing BOM component recognition cannot separate multiple cabinets, causing multiple consecutive BOMs to be read as one, affecting work accuracy and thus work efficiency. Summary of the Invention

[0004] This invention provides a method, apparatus, device, medium, and product for automatically importing equipment lists. By adopting this technical solution, the problem of manual operation required for batch import is solved. By segmenting the equipment list table and automating the import, the structural information of the equipment can be automatically identified and automatically imported into the specified location, thereby improving work efficiency.

[0005] According to one aspect of the present invention, an automatic import method for an equipment list is provided, comprising:

[0006] Obtain the equipment list;

[0007] The device list is parsed to obtain a text library; the text library contains at least four text sets; the text sets are arranged in the row order of the device list;

[0008] Based on the association between text content and configuration items, the text content in the text library is automatically imported into the information software.

[0009] According to another aspect of the present invention, an automatic equipment list import device is provided, characterized in that it comprises:

[0010] The acquisition module is used to obtain the device list;

[0011] A parsing module is used to parse the device list to obtain a text library; the text library contains at least four text sets; the text sets are arranged in the row order of the device list;

[0012] The import module is used to automatically import text content from the text library into the information software based on the association between text content and configuration items.

[0013] According to another aspect of the present invention, an electronic device is provided, the electronic device comprising:

[0014] At least one processor; and

[0015] A memory communicatively connected to the at least one processor; wherein,

[0016] The memory stores a computer program that can be executed by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform the device list automatic import method according to any embodiment of the present invention.

[0017] According to another aspect of the present invention, a computer-readable storage medium is provided, the computer-readable storage medium storing computer instructions for causing a processor to execute and implement the device list automatic import method according to any embodiment of the present invention.

[0018] According to another aspect of the present invention, a computer program product is provided, the computer program product comprising a computer program that, when executed by a processor, implements the device inventory automatic import method according to any embodiment of the present invention.

[0019] The technical solution of this invention solves the problem of manual operation required for batch import by segmenting and automatically importing the equipment list table. It can automatically identify the structural information of the equipment and automatically import it to the specified location, thereby improving work efficiency.

[0020] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of the present invention, nor is it intended to limit the scope of the invention. Other features of the invention will become readily apparent from the following description. Attached Figure Description

[0021] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0022] Figure 1 This is a flowchart of an automatic equipment list import method provided by an embodiment of the present invention;

[0023] Figure 2 This is a flowchart of an automatic equipment list import method provided by an embodiment of the present invention;

[0024] Figure 3 This is a flowchart of a method for determining an information header set and a detail header set according to an embodiment of the present invention;

[0025] Figure 4 This is a schematic diagram of an automatic equipment list import device provided according to an embodiment of the present invention;

[0026] Figure 5 This is a schematic diagram of the structure of an electronic device that implements the automatic import method of the device list in this embodiment of the invention. Detailed Implementation

[0027] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0028] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0029] Furthermore, it should be noted that the information collected in the technical solution of this invention is information and data authorized by the user or fully authorized by all parties, and the collection, storage, use, processing, transmission, provision, disclosure and application of related data all comply with the relevant laws, regulations and standards of relevant countries and regions, necessary confidentiality measures have been taken, and public order and good morals are not violated. Corresponding operation entry points are provided for users to choose to authorize or refuse.

[0030] Figure 1 This is a flowchart illustrating an automatic equipment list import method according to an embodiment of the present invention. This embodiment is applicable to the automated identification and import of equipment list tables, particularly suitable for the automatic identification and import of BOM components. The method can be executed by the automatic equipment list import device provided in this embodiment, which can be implemented in hardware and / or software and can be configured in a server. Figure 1 As shown, the method includes:

[0031] S110. Obtain the equipment list.

[0032] The equipment list is a bill of materials in Excel format. Each equipment list can contain at least one cabinet. Each cabinet is a BOM to be imported. A BOM contains equipment information and a detailed equipment list. The equipment information can be the cabinet body number, model specifications, cabinet number, and other cabinet information. The detailed equipment information can be the component name, model specifications, manufacturer, and other equipment component information in the cabinet.

[0033] Specifically, the system obtains an Excel-formatted list of equipment cabinets imported by staff through the interactive interface of the information software. This list includes at least one Bill of Materials (BOM) to be imported.

[0034] S120. Parse the equipment list to obtain a text library; the text library contains at least four text sets; the text sets are arranged in the row order of the equipment list.

[0035] The text set in the text library is a collection of text content stored in Excel format, row by row. The text set is used to represent the configuration information of the cabinet, including cabinet information and detailed information. Cabinet information can be the cabinet title row and cabinet information row corresponding to the cabinet; detailed information can be the detailed title row and detailed information row corresponding to the detailed information.

[0036] Specifically, semantic parsing is performed on the device list in Excel format to obtain the text content set corresponding to each row, which serves as a text set. This text set is then arranged according to the row order of the device list in Excel format to obtain a text library. Optionally, the device list is parsed to obtain a text library, including:

[0037] The equipment list is parsed to obtain the row order;

[0038] Natural language processing is performed on the device list based on the row order to obtain the text set corresponding to each row;

[0039] The text set is sorted according to line order to obtain the text library.

[0040] The row order follows the row and column order of the equipment list in Excel format, starting from the first row and continuing to the last row of the equipment list.

[0041] Specifically, the device list in Excel format is parsed to obtain the row order of the device list. Natural language processing is then performed on the device list based on the row order to obtain the text content set corresponding to each row. The text set is then sorted based on the row order to obtain the text library corresponding to the device list in Excel format.

[0042] Understandably, by parsing the equipment list in Excel format and sorting the identified text set according to row order, the accuracy of text content recognition is ensured, further improving the accuracy of subsequent cabinet segmentation.

[0043] S130. Based on the association between text content and configuration items, automatically import text content from the text library into the information software.

[0044] Among them, the configuration items are the project names displayed on the interactive interface of the information software, which may include the cabinet number, cabinet model, cabinet number, and cabinet name in the cabinet information; the component name, component manufacturer, component brand, component model, and model specifications in the detailed information; and the information software is the cabinet information collection software.

[0045] Specifically, based on the relationship between text content and configuration items, the text content in the text library is automatically imported into the information software for cabinet information configuration.

[0046] This invention provides an embodiment that obtains an equipment list; parses the equipment list to obtain a text library; the text library contains at least four text sets; the text sets are arranged in row order according to the equipment list; and based on the association between text content and configuration items, the text content in the text library is automatically imported into information software. This technical solution, by segmenting the equipment list table and automating the import, solves the problem of manual operation required for batch import, automatically identifies the structural information of the equipment, and automatically imports it to the specified location, thus improving work efficiency.

[0047] Figure 2This is a flowchart of an automatic equipment list import method according to an embodiment of the present invention. Based on the above embodiments, this embodiment supplements the specific import method of text content from a text library. It should be noted that for parts not detailed in this embodiment, please refer to the relevant descriptions in other embodiments. For example... Figure 2 As shown, the method includes:

[0048] S210. Obtain the equipment list.

[0049] S220. Parse the equipment list to obtain a text library; the text library contains at least four text sets; the text sets are arranged in the row order of the equipment list.

[0050] S230. Based on the segmentation rules, the text set in the text library is segmented to obtain the information title set and the detail title set.

[0051] Among them, the segmentation rule is the weighted benchmark rule, which is used to segment the title lines in the text set; the title lines can include the container information title lines and the container detail title lines; both the information title set and the detail title set are title lines in the BOM; the information title set is the container information title line; the detail title set is the container detail title line.

[0052] Specifically, the text sets in the text library are weighted according to the weighting benchmark rules, and the text sets are segmented based on the weighting thresholds to obtain the information title set and detail title set corresponding to the title row.

[0053] Optional, such as Figure 3 The method for determining an information title set and a detail title set is shown. The segmentation rules include information weight benchmarks and detail weight benchmarks. Accordingly, the text set in the text library is segmented based on the segmentation rules to obtain the information title set and the detail title set, including:

[0054] S231. Based on the semantic dictionary, perform association calculations on the text content in the text set to determine the first and second keywords corresponding to the text set.

[0055] The semantic dictionary is the keyword dictionary corresponding to the title row; the first keyword is a keyword related to the cabinet information, used to represent the cabinet name, which can be set to "cabinet number" and / or "model"; the second keyword is a keyword related to the cabinet details, used to represent the component name in the cabinet, which can be set to "component".

[0056] Specifically, based on the keywords corresponding to the information title row and detail title row in the semantic dictionary, the first keyword and / or second keyword corresponding to the text content in each text set are calculated and associated with the text content in the text set.

[0057] In an optional embodiment of the present invention, the association calculation can be a similarity calculation, which calculates the similarity between keywords in the semantic dictionary and text content, matches keywords with similarity higher than the similarity threshold with the keyword, and stores them as keywords in the text set.

[0058] Understandably, by setting up a semantic dictionary, keywords corresponding to the information title lines and detail labels in each text set can be further extracted in order to accurately segment the title lines in the text set based on the keywords.

[0059] S232. Based on the information weight benchmark and the first keyword, determine the information title set from the text library.

[0060] Among them, the information weight benchmark is the benchmark value of the information weight and detail weight corresponding to the first keyword.

[0061] Specifically, based on the baseline values ​​of the information weight and detail weight corresponding to the first keyword, and the first keyword of each text set in the text library, the weight value of each text set is determined. Based on the weight value, the information title set is determined from each text set in the text library, and the information title set is the cabinet information title row in the equipment list.

[0062] Optionally, based on information weighting benchmarks and the first keyword, a set of information titles is determined from the text library, including:

[0063] Information weights are calculated based on the information weight benchmark and the first keyword to obtain the information weight values ​​corresponding to the text set.

[0064] The first comparison result is obtained by comparing the information weight value and the information threshold.

[0065] The information weight value that is higher than the information threshold in the first comparison result is taken as the first weight value;

[0066] The text set corresponding to the first weight value is used as the information title set.

[0067] Among them, the information weight value is the weight of the box / cabinet title corresponding to each text set; the information threshold is the threshold of the box / cabinet information title row; the first comparison result is the comparison result of the information weight value of each text set with the information threshold, which can be that the information weight value is higher than the information threshold or the information weight value is lower than the information threshold.

[0068] Specifically, based on the baseline values ​​of the information weight and detailed weight of the first keyword in the information weight benchmark, the information weight is calculated by comparing it with the first keyword in each text set to obtain the information weight value corresponding to the text set. The information weight value is then compared with an information threshold to obtain the first comparison result. The information weight value higher than the information threshold in the first comparison result is taken as the first weight value, and the text set corresponding to the first weight value is taken as the information title set. For example, each first keyword has a corresponding information weight benchmark. For example, the keyword "cabinet number" only indicates the name of the cabinet, so its corresponding information weight benchmark has a cabinet weight benchmark of 1000 and a detailed weight benchmark of 0; "model specification" may represent the component model or the cabinet model, so its corresponding information weight benchmark has a cabinet weight benchmark of 100 and a detailed weight benchmark of 100. If a text set has "cabinet number" as its first keyword, and its weight is calculated according to the cabinet weight benchmark and the detail weight benchmark in the information weight benchmark, then the information weight value of this text set is 1000; if another text set has "model specification" as its first keyword, and its weight is calculated according to the cabinet weight benchmark and the detail weight benchmark in the information weight benchmark, then the information weight value of this text set is 400; if no first keyword exists in the text set, then its information weight value is 0.

[0069] In an optional embodiment of the present invention, if there are at least two first keywords, a corresponding information weight benchmark can be configured according to the type of the first keyword. This allows for prioritizing the determination of the first keyword type during weight value calculation, finding the corresponding target information weight benchmark based on the first keyword type, and calculating the weight value of the first keyword based on the target information weight benchmark. If there are at least two first keywords in the text set, the information weight values ​​corresponding to each first keyword are summed. It should be noted that the information weight benchmark can be pre-configured based on the experience of those skilled in the art, and the embodiments of the present invention do not specifically limit the specific configuration benchmark.

[0070] Understandably, by matching the type of the first keyword with the corresponding information weight benchmark, the accurate calculation of the information weight value of the first keyword is ensured, thereby improving the accurate segmentation of the header row in the BOM list. This allows for the accurate segmentation of multiple consecutive BOMs in the equipment list, automatic identification of the BOM structure and information, and automatic import of the information in the BOM into the specified location.

[0071] S233. Based on the detail weight benchmark and the second keyword, determine the detail title set from the text library.

[0072] Among them, the detailed weight benchmark is the information weight of the second keyword and the benchmark value of the detailed weight; the detailed title set indicates that the text set is the cabinet detailed title line in the equipment list.

[0073] Specifically, based on the information weight and detail weight benchmark values ​​in the detail weight benchmark associated with the second keyword, and the second keyword of each text set in the text library, the detail weight value of each text set is determined. Based on the detail weight value, the detail title set is determined from each text set in the text library. Then, the detail title set is the cabinet detail title row in the equipment list.

[0074] Optionally, based on the detail weight benchmark and the second keyword, a set of detail titles is determined from the text library, including:

[0075] Detailed weights are calculated based on the detailed weight benchmark and the second keyword to obtain the detailed weight values ​​corresponding to the text set.

[0076] The second comparison result is obtained by comparing the detailed weight values ​​and the detailed thresholds;

[0077] The detail weight values ​​that are higher than the detail threshold in the second comparison result are used as the second weight values;

[0078] Use the text set corresponding to the second weight value as the detailed title set.

[0079] Among them, the detailed weight value is the weight of the detailed title of each box and cabinet corresponding to each text set; the detailed threshold is the threshold of the detailed title row; the first comparison result is the comparison result of the detailed weight value of each text set with the detailed threshold, which can be either the detailed weight value is higher than the detailed threshold or the detailed weight value is lower than the detailed threshold.

[0080] Specifically, based on the information weight of the second keyword in the detailed weight benchmark and the benchmark value of the detailed weight, the detailed weight is calculated using the second keyword to obtain the detailed weight value corresponding to the text set. This detailed weight value is then compared with the detailed threshold to obtain a second comparison result. The detailed weight value higher than the detailed threshold in the second comparison result is taken as the second weight value, and the text set corresponding to the second weight value is taken as the detailed title set. For example, each keyword has a corresponding detailed weight benchmark. For instance, the keyword "component" only indicates the name of the cabinet / box detail; therefore, its cabinet / box weight benchmark is 0, and its detailed weight benchmark is 1000. If a text set has "component" as its second keyword, its detailed weight value is calculated according to the cabinet / box weight benchmark and the detailed weight benchmark, resulting in a detailed weight value of 1000. If another text set does not have the second keyword, its corresponding detailed weight value is 0.

[0081] Understandably, by setting a second keyword and its corresponding detailed weight benchmark, the accurate calculation of the detailed weight value of the second keyword is ensured, and the structure and information of a single BOM can be identified so that the information in the BOM can be automatically and accurately imported into the specified location.

[0082] S240. Based on the row order, information title set, and detail title set, the text library is filtered to obtain at least one information text set corresponding to a container.

[0083] Among them, the container indicates a BOM; the information text set is the information text corresponding to the container, including the container information text set and the container detail text set.

[0084] Specifically, the text library is filtered according to the row order, information title set, and detailed title set to determine at least one cabinet from the text library, and the corresponding information text set is determined from at least one cabinet based on the information title set and detailed title set.

[0085] Optionally, the text library is filtered based on row order, information title set, and detail title set to obtain at least one information text set corresponding to a container, including:

[0086] Based on the row order, the text library is traversed downwards, and the text set between two adjacent information title sets is taken as the target cabinet's cabinet text set;

[0087] For each container text set, based on the line order, the text set corresponding to the line above the line corresponding to the detailed title set in the container text set is taken as the container information set;

[0088] The next line up to the last line of the detailed title set in the container text set shall be taken as the container detail set;

[0089] Use the container information set and at least one container detail set as the information text set of the target container.

[0090] Among them, the information title set corresponds to a cabinet; the text set between two adjacent information title sets is the information list corresponding to a cabinet; the cabinet information set is the cabinet name information; the cabinet details set is the equipment details information of the equipment in the cabinet; and the information text set is the cabinet name information and equipment details information of the cabinet.

[0091] Specifically, the text library is traversed downwards based on row order, and the text set between two adjacent information title sets is taken as a cabinet text set; until all cabinet text sets corresponding to all cabinets are found, the middle part between two consecutive information title lines is the complete BOM part of the first cabinet. Then, for each cabinet text set, according to row order, the text set corresponding to the previous row of the detailed title set in the cabinet text set is taken as the cabinet information set, and at least one text set from the next row of the detailed title set in the cabinet text set up to the last row is taken as the cabinet detail set. The cabinet information set and at least one cabinet detail set are taken as the information text set of the target cabinet.

[0092] Understandably, the text set in the text library is segmented according to the cabinet title line and the information title line based on the segmentation rules. The cabinet title line can accurately identify whether there are multiple BOM cabinets in the equipment list, and the information title line can distinguish between cabinet information and detailed information to ensure the accuracy of subsequent information import.

[0093] S250. Based on the association between text content and configuration items, automatically import the text content of at least one information text set into the information software.

[0094] Specifically, based on the association between text content and configuration items, the text content of at least one cabinet's corresponding information text set is automatically imported into the information software.

[0095] Optionally, after automatically importing the text content from at least one information text set into the information software based on the association between text content and configuration items, the process includes:

[0096] If the information text set contains at least one piece of information that has not been imported, a warning will be issued through the interactive interface.

[0097] In response to feedback from the interactive interface, the unimported information is used as a sample to optimize the association relationship.

[0098] Among them, the unimported information refers to the text content that still exists in the information text set after the import based on the association between text content and configuration items; the warning prompt can be a pop-up prompt to indicate to relevant staff that the equipment list import is not completed; the feedback operation is manual review to determine whether the unimported information is useless information or the association between text content and configuration items has not been established.

[0099] Specifically, after the information is automatically imported by the software, if there is at least one piece of information in the text set that has not been imported, a warning pop-up will be displayed through the interactive interface, showing the text content of the missing information. Relevant staff will then take action based on this pop-up. If the missing information is useless, it can be ignored and subsequent actions can proceed. If no association is established between the text content and the configuration item, or if they cannot be matched, the missing information will be manually imported, and the missing information and its corresponding configuration item will be used as samples to self-learn and optimize the existing association.

[0100] Understandably, by manually reviewing the information that has not been imported, the system can learn and optimize the relationships, thereby improving the accuracy and efficiency of the automated import of equipment lists.

[0101] This invention employs segmentation rules to segment text sets in a text library, resulting in information title sets and detail title sets. Based on the information title sets, it achieves accurate segmentation of multiple cabinet BOMs within a single equipment list, preventing the misreading of multiple consecutive BOMs as a single entity and thus ensuring the accuracy of subsequent automatic import of cabinet information. Furthermore, based on the detail title sets, it segments cabinet and detail information, enabling automatic identification of the BOM's structure and information. This further ensures that information in the BOM is automatically imported to the designated location, improving work efficiency and enhancing the efficiency of BOM flow between various enterprise systems.

[0102] Figure 4 This is a schematic diagram of an automatic equipment list import device according to an embodiment of the present invention. This embodiment is applicable to the automated identification and import of equipment list tables, particularly suitable for the automatic identification and import of BOM components. The automatic equipment list import device can be implemented in hardware and / or software and can be configured in a server. The automatic equipment list import device 300 includes an acquisition module 310, a parsing module 320, and an import module 330.

[0103] Module 310 is used to obtain the device list;

[0104] The parsing module 320 is used to parse the device list to obtain a text library; the text library contains at least four text sets; the text sets are arranged in the row order of the device list;

[0105] Import module 330 is used to automatically import text content from the text library into the information software based on the association between text content and configuration items.

[0106] This invention provides an embodiment that obtains an equipment list; parses the equipment list to obtain a text library; the text library contains at least four text sets; the text sets are arranged according to the row order of the equipment list; and based on the association between text content and configuration items, the text content in the text library is automatically imported into information software. This technical solution, by segmenting the equipment list table and automating the import, solves the problem of manual operation required for batch import, automatically identifies the structural information of the equipment, and automatically imports it to the designated location, thus improving work efficiency.

[0107] Optionally, the parsing module 320 is also used to parse the device list to obtain the row order;

[0108] Natural language processing is performed on the device list based on the row order to obtain the text set corresponding to each row;

[0109] The text set is sorted according to line order to obtain the text library.

[0110] Optionally, the import module 330 includes a segmentation unit, a filtering unit, and an import unit;

[0111] The segmentation unit is used to segment the text set in the text library based on segmentation rules to obtain the information title set and the detail title set;

[0112] The filtering unit is used to filter the text library based on row order, information title set, and detail title set to obtain at least one information text set corresponding to a container.

[0113] The import unit is used to automatically import text content from at least one information text set into the information software based on the association between text content and configuration items.

[0114] Optionally, the segmentation rules include information weight benchmarks and detailed weight benchmarks; correspondingly, the segmentation unit is also used to perform association calculations on the text content in the text set based on the semantic dictionary, and to determine the first key and the second key corresponding to the text set;

[0115] Based on information weighting benchmarks and primary keywords, a set of information titles is determined from the text library;

[0116] Based on the detail weight benchmark and the second keyword, the detail title set is determined from the text library.

[0117] Optionally, the segmentation unit is also used to calculate the information weight based on the information weight benchmark and the first keyword to obtain the information weight value corresponding to the text set;

[0118] The first comparison result is obtained by comparing the information weight value and the information threshold.

[0119] The information weight value that is higher than the information threshold in the first comparison result is taken as the first weight value;

[0120] The text set corresponding to the first weight value is used as the information title set.

[0121] Optionally, the segmentation unit is also used to calculate the detailed weight based on the detailed weight benchmark and the second keyword to obtain the detailed weight value corresponding to the text set;

[0122] The second comparison result is obtained by comparing the detailed weight values ​​and the detailed thresholds;

[0123] The detail weight values ​​that are higher than the detail threshold in the second comparison result are used as the second weight values;

[0124] Use the text set corresponding to the second weight value as the detailed title set.

[0125] Optionally, the filtering unit is also used to traverse the text library downwards based on row order, and take the text set between two adjacent information title sets as the target container text set;

[0126] For each container text set, based on the line order, the text set corresponding to the line above the line corresponding to the detailed title set in the container text set is taken as the container information set;

[0127] The next line up to the last line of the detailed title set in the container text set is taken as the container detail set;

[0128] Use the container information set and at least one container detail set as the information text set of the target container.

[0129] Optionally, the automatic import device 300 for the equipment list also includes an optimization module, which provides an early warning through the interactive interface if at least one piece of information in the information text set is not imported.

[0130] In response to feedback from the interactive interface, the unimported information is used as a sample to optimize the association relationship.

[0131] The automatic equipment list import device provided in this embodiment of the invention can execute the automatic equipment list import method provided in any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the method.

[0132] According to embodiments of the present invention, the present invention also provides an electronic device, a readable storage medium, and a computer program product.

[0133] Figure 5 A schematic diagram of an electronic device 10 that can be used to implement embodiments of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the invention described and / or claimed herein.

[0134] like Figure 5As shown, the electronic device 10 includes at least one processor 11 and a memory, such as a read-only memory (ROM) 12 or a random access memory (RAM) 13, communicatively connected to the at least one processor 11. The memory stores computer programs executable by the at least one processor. The processor 11 can perform various appropriate actions and processes based on the computer program stored in the ROM 12 or loaded from storage unit 18 into the RAM 13. The RAM 13 can also store various programs and data required for the operation of the electronic device 10. The processor 11, ROM 12, and RAM 13 are interconnected via a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0135] Multiple components in electronic device 10 are connected to I / O interface 15, including: input unit 16, such as keyboard, mouse, etc.; output unit 17, such as various types of displays, speakers, etc.; storage unit 18, such as disk, optical disk, etc.; and communication unit 19, such as network card, modem, wireless transceiver, etc. Communication unit 19 allows electronic device 10 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0136] Processor 11 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. Processor 11 performs the various methods and processes described above, such as the device inventory automatic import method.

[0137] In some embodiments, the device inventory automatic import method may be implemented as a computer program tangibly contained in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on electronic device 10 via ROM 12 and / or communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the device inventory automatic import method described above may be performed. Alternatively, in other embodiments, processor 11 may be configured to perform the device inventory automatic import method by any other suitable means (e.g., by means of firmware).

[0138] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations may include: implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0139] Computer programs used to implement the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when executed by the processor, the computer programs cause the functions / operations specified in the flowcharts and / or block diagrams to be performed. The computer programs may be executed entirely on a machine, partially on a machine, or as a standalone software package, partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0140] In the context of this invention, a computer-readable storage medium can be a tangible medium that may contain or store a computer program for use by or in conjunction with an instruction execution system, apparatus, or device. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination thereof. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.

[0141] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0142] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as data servers), or computing systems that include middleware components (e.g., application servers), or computing systems that include frontend components (e.g., user computers with graphical user interfaces or web browsers through which users can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., communication networks). Examples of communication networks include local area networks (LANs), wide area networks (WANs), blockchain networks, and the Internet.

[0143] A computing system can include clients and servers. Clients and servers are generally geographically separated and typically interact via communication networks. The client-server relationship is created by computer programs running on the respective computers and having a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a host product within the cloud computing service system. This addresses the shortcomings of traditional physical hosts and dedicated virtual services, such as high management difficulty and weak business scalability.

[0144] It should be understood that the various forms of processes shown above can be used, with steps reordered, added, or deleted. For example, the steps described in this invention can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution of this invention can be achieved, and this is not limited herein.

[0145] The specific embodiments described above do not constitute a limitation on the scope of protection of this invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this invention.

Claims

1. A method for automatically importing a device inventory, characterized by, The application relates to a method for automatically importing information software based on a device list, comprising the following steps: acquiring a device list; analyzing the device list to obtain a text library; the text library comprises at least four text sets; the text sets are arranged according to the line order of the device list; automatically importing the text content of the text library into information software based on the association relationship between the text content and configuration items.

2. The method of claim 1, wherein, The step of analyzing the device list to obtain a text library comprises the following steps: analyzing the device list to obtain a line order; performing natural semantic recognition on the device list based on the line order to obtain a text set corresponding to each line; sorting the text sets based on the line order to obtain a text library.

3. The method of claim 1, wherein, The step of automatically importing the text content of the text library into information software based on the association relationship between the text content and configuration items comprises the following steps: segmenting the text sets in the text library based on segmentation rules to obtain an information title set and a detailed title set; screening the text library based on the line order, the information title set and the detailed title set to obtain an information text set corresponding to at least one cabinet; automatically importing the text content in at least one information text set into information software based on the association relationship between the text content and configuration items.

4. The method of claim 3, wherein, The segmentation rules comprise an information weight benchmark and a detailed weight benchmark; correspondingly, the step of segmenting the text sets in the text library based on the segmentation rules to obtain an information title set and a detailed title set comprises the following steps: performing association calculation on the text content of the text sets based on a semantic dictionary to determine a first keyword and a second keyword corresponding to the text sets; determining an information title set from the text library based on the information weight benchmark and the first keyword; determining a detailed title set from the text library based on the detailed weight benchmark and the second keyword.

5. The method of claim 4, wherein, The step of determining an information title set from the text library based on the information weight benchmark and the first keyword comprises the following steps: performing information weight calculation based on the information weight benchmark and the first keyword to obtain an information weight value corresponding to the text set; comparing the information weight value with an information threshold value to obtain a first comparison result; taking the information weight value higher than the information threshold value in the first comparison result as a first weight value; taking the text set corresponding to the first weight value as the information title set.

6. The method of claim 4, wherein, The step of determining a detailed title set from the text library based on the detailed weight benchmark and the second keyword comprises the following steps: performing detailed weight calculation based on the detailed weight benchmark and the second keyword to obtain a detailed weight value corresponding to the text set; comparing the detailed weight value with a detailed threshold value to obtain a second comparison result; taking the detailed weight value higher than the detailed threshold value in the second comparison result as a second weight value; taking the text set corresponding to the second weight value as the detailed title set.

7. The method of claim 3, wherein, The step of screening the text library based on the line order, the information title set and the detailed title set to obtain an information text set corresponding to at least one cabinet comprises the following steps: traversing the text library downwards based on the line order, and taking the text set between two adjacent information title sets as the cabinet text set of a target cabinet; For each cabinet text set, based on the row order, the text set corresponding to the previous row of the corresponding row of the detailed title set in the cabinet text set is taken as a cabinet information set; At least one text set corresponding to the next row until the last row of the corresponding row of the detailed title set in the cabinet text set is taken as a cabinet detail set; The cabinet information set and the at least one cabinet detail set are taken as an information text set of the target cabinet.

8. The method of claim 3, wherein, After automatically importing the text content in at least one of the information text sets into the information software based on the association relationship between the text content and the configuration item, the method comprises: If there is at least one unimported information in the information text set, a warning prompt is performed through an interactive interface; In response to a feedback operation of the interactive interface, the unimported information is taken as a sample to optimize the association relationship.

9. An apparatus for automatically importing a device list, characterized by comprising: The method comprises: An acquisition module is configured to acquire a device list; An analysis module is configured to analyze the device list to obtain a text library; The text library comprises at least four text sets; and the text sets are arranged according to the row order of the device list; An import module is configured to automatically import the text content in the text library into an information software based on an association relationship between the text content and a configuration item.

10. An electronic device, comprising: The electronic device comprises: At least one processor; and A memory connected in communication with the at least one processor; wherein The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to execute the device list automatic import method in any one of claims 1-8.

11. A computer readable storage medium, characterized in that, The computer readable storage medium stores computer instructions for enabling the processor to execute the device list automatic import method in any one of claims 1-8 when executed by the processor.

12. A computer program product, characterised in that, The computer program product comprises a computer program, and the computer program is executed by the processor to implement the device list automatic import method according to any one of claims 1-8. The computer program product comprises a computer program, and the computer program is executed by the processor to implement the device list automatic import method according to any one of claims 1-8.

Images