Nuclear power spare part data management method and management robot based on RPA technology

Abstract

The invention provides a nuclear power spare part data management method and management robot based on an RPA technology, and the method comprises the following steps: extracting spare part data, and sorting the spare part data to obtain table data matched with data management; step-by-step duplicate checking is carried out on the table data, pause is controlled after duplicate checking at all levels, duplicate items are confirmed, and a checking table after duplicate checking at all levels is obtained; and encoding the review table, and re-importing the screened data during duplicate checking into the review table to obtain an overwrite table after data management. According to the data management method provided by the invention, the information format can be automatically converted, and it is ensured that the front-end input information conforms to the normalization; the spare part information is subjected to preliminary repeated code identification, so that the manual comparison workload is reduced; and receiving a spare part center list, and reversely arranging the format overwriting system.

Description

Technical Field

[0001] The present invention relates to the field of digital technology, and in particular to a nuclear power spare parts data management method and a management robot based on RPA (Robotic process automation) technology. Background Art

[0002] The existing nuclear power engineering spare parts coding data is relatively large, and the valid fields of each spare part data are long, and the corresponding functional position and parent-child spare parts relationship are also relatively complex. Therefore, there are relatively many fields that need to be manually reviewed. As a result, the spare parts review work is more intensive and requires higher data accuracy. This further leads to a significant increase in the number of personnel required for spare parts information entry and the time required to complete spare parts information entry. Summary of the invention

[0003] In view of the shortcomings of the prior art mentioned above, the purpose of the present invention is to provide a nuclear power spare parts data management method and management robot based on RPA technology, which is used to solve the problem in the prior art that the number of nuclear power engineering spare parts codes is huge, the functional positions and parent-child relationships are relatively complex, which leads to a large number of manual review fields, making the spare parts review work extremely intensive, requiring high data accuracy, and greatly extending the completion time.

[0004] To achieve the above-mentioned purpose and other related purposes, the present invention provides a nuclear power spare parts data management method based on RPA technology, comprising the following steps:

[0005] Extract spare parts data and organize them to obtain data in this table that is compatible with data management;

[0006] Check the data in this table for duplicates at each level, and pause and confirm duplicate items after checking at each level, so as to obtain the review table after checking at each level;

[0007] The review table is encoded, and the screened data during the duplicate check is re-imported into the review table to obtain the overwrite table after data management.

[0008] In one embodiment of the present invention, spare parts data is extracted and sorted to obtain data in this table that is compatible with data management, including:

[0009] The marked file in the spare part data is replaced by the template file, and the old data is cleared, wherein other files in the spare part data except the marked file are updated by manual control;

[0010] Import the replaced spare parts data into the corresponding RPA program according to the export method type, and organize the data in this table.

[0011] In one embodiment of the present invention, the marking file in the spare part data is replaced by the template file, and the old data is cleared, including:

[0012] The template table of spare parts data is redefined, the identification logic of spare parts data is simplified, and the corresponding table of spare parts data is split to obtain the data in this table, and make the data in this table compatible with the RPA program.

[0013] In one embodiment of the present invention, the data in this table is checked for duplicates level by level, and control is exercised to pause and confirm duplicates after checking for duplicates at each level, including: the data in this table is screened for duplicates through a screening program, a historical table, and a corresponding company table in turn, and control is exercised to collect duplicate confirmation information after manual screening for duplicates, wherein the screening for duplicates includes deleting, hiding, and replacing the data in this table.

[0014] In one embodiment of the present invention, the data in this table is screened for duplicates through a screening procedure, including:

[0015] The data in this table are screened for duplicates through a screening program to obtain a first screening result, and first confirmed duplicates are collected after manual confirmation of the first screening result of the screening program, and the first confirmed duplicates are marked.

[0016] In one embodiment of the present invention, the data in this table is filtered for duplicate items through the previous tables, including:

[0017] The first confirmed duplicate items are screened for duplicates through the previous table to obtain a second screening result, the second confirmed duplicate items after manual confirmation of the second screening result are collected, and the duplicate item cross codes corresponding to the previous table are imported into the corresponding spare parts of the corresponding second confirmed duplicate items and hidden.

[0018] In one embodiment of the present invention, the data in this table is filtered for duplicates through the corresponding company table, including:

[0019] The second confirmed duplicate items after hiding are screened for duplicates through the company table to obtain the third screening results, the third confirmed duplicate items after manual confirmation of the third screening results are collected, and the duplicate spare part codes corresponding to the third confirmed duplicate items are imported into the corresponding spare parts in the company table and hidden.

[0020] In one embodiment of the present invention, a review table after various levels of duplication checking is obtained, including:

[0021] Collect the processing completion signal of the duplicate items confirmed at the previous level, and control the duplication check at the next level according to the processing completion signal until the duplication check at each level is completed and the review table is obtained.

[0022] In one embodiment of the present invention, the review table is encoded, and the screened data during the duplicate check is re-imported into the review table to obtain an overwrite table after data management, including:

[0023] Get the corresponding company table, history table, and screening data when the screening program is used to screen duplicate items, and write the corresponding company table, history table, and screening data corresponding to the screening program into the review table in turn, and obtain the import table and difference table after encoding each data in the review table, wherein when the screened data is written into the review table, it is based on the data in this table before the screening program screens out duplicate items.

[0024] The present invention also provides a nuclear power spare parts data management robot based on RPA technology, including:

[0025] A data sorting unit, which extracts and sorts spare parts data to obtain data in this table that is compatible with data management;

[0026] The data duplication checking unit checks the data of the table for duplication at each level, and controls the suspension and confirmation of duplicate items after each level of duplication checking, thereby obtaining a review table after duplication checking at each level; and

[0027] Write a retrieval unit, write the retrieval unit to encode the review table, and re-import the screened data during the duplicate check into the review table to obtain the overwrite table after data management.

[0028] Beneficial effects of the present invention: The present invention proposes a nuclear power spare parts data management method and management robot based on RPA technology. The management method and management robot realize the main functions by redefining template tables, simplifying recognition logic, pioneering and innovating, combining Excel macro operations, inserting manual review and confirmation stages, etc. It also realizes automatic conversion of information formats to ensure that the front-end input information complies with the norms. It realizes preliminary duplicate code recognition of spare parts information to reduce the workload of manual comparison; and receives the spare parts center list and reversely sorts the format to overwrite the system. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 The figure is a flow chart of the data management method of the present invention.

[0030] Figure 2 Shown is a schematic diagram of file replacement processing in a preferred embodiment of the present invention.

[0031] Figure 3 Shown is a schematic diagram of the file format when data is organized in a preferred embodiment of the present invention.

[0032] Figure 4 Shown is a schematic diagram of a data duplication checking procedure in a preferred embodiment of the present invention.

[0033] Figure 5 and Figure 6 Shown is a table diagram of a preferred embodiment of the present invention before and after the screening procedure for duplicate items.

[0034] Figure 7 and Figure 8 Shown is a table diagram before and after duplicate items are filtered out in a preferred embodiment of the present invention.

[0035] Figures 9 to 11 Shown is a table chart of a company before and after duplicate item screening in a preferred embodiment of the present invention.

[0036] Fig.12 Shown is a schematic diagram of a program for writing an import list in a preferred embodiment of the present invention.

[0037] Figures 13 to 15 Shown is a table diagram of the process of writing an import table in a preferred embodiment of the present invention.

[0038] Fig.16 This is an architectural diagram of the data management robot of the present invention. DETAILED DESCRIPTION

[0039] The following describes the embodiments of the present invention by specific examples, and those skilled in the art can easily understand other advantages and effects of the present invention from the contents disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and the details in this specification can also be modified or changed in various ways based on different viewpoints and applications without departing from the spirit of the present invention. It should be noted that the following embodiments and features in the embodiments can be combined with each other without conflict.

[0040] It should be noted that the illustrations provided in the following embodiments are only schematic illustrations of the basic concept of the present invention, and thus the drawings only show components related to the present invention rather than being drawn according to the number, shape and size of components in actual implementation. In actual implementation, the type, quantity and proportion of each component may be changed arbitrarily, and the component layout may also be more complicated.

[0041] In the following description, numerous details are discussed to provide a more thorough explanation of the embodiments of the present invention. However, it is obvious to those skilled in the art that the embodiments of the present invention can be implemented without these specific details. In other embodiments, well-known structures and devices are shown in the form of block diagrams rather than in detail to avoid making the embodiments of the present invention difficult to understand.

[0042] See also Figure 1 The nuclear power spare parts data management method based on RPA technology provided by the present invention comprises the following steps:

[0043] Extract spare parts data and organize them to obtain data in this table that is compatible with data management;

[0044] Check the data in this table for duplicates at each level, and pause and confirm duplicate items after checking at each level, so as to obtain the review table after checking at each level;

[0045] The review table is encoded, and the screened data during the duplicate check is re-imported into the review table to obtain the overwrite table after data management.

[0046] It is not difficult to find from the above content that when processing nuclear power spare parts data, the spare parts data needs to be encoded. Before encoding the spare parts data, obtain the spare parts data that needs to be encoded. Then, organize the spare parts data to convert the spare parts data into a format that is suitable for data management, and convert the spare parts data into a file table form corresponding to data management, so as to obtain the processed data of this table. Then, delete, hide and replace the data in this table step by step to obtain a screened review table that meets the conditions of duplicate checking at all levels. Then send the review table to the spare parts center for encoding, and after the encoding is completed, re-import the screened data corresponding to the duplicate checking at all levels into the review table, complete the reverse sorting format overwriting system, and obtain the overwriting table corresponding to the original data of this table.

[0047] Among them, the spare parts data is extracted and sorted to obtain the data in this table that is compatible with data management, including:

[0048] The marked file in the spare part data is replaced by the template file, and the old data is cleared, wherein other files in the spare part data except the marked file are updated by manual control;

[0049] Import the replaced spare parts data into the corresponding RPA program according to the export method type, and organize the data in this table.

[0050] In one embodiment of the present invention, when sorting the filing data, the spare parts data that need to be encoded are first extracted from the spare parts system. In addition, after obtaining the spare parts data, it is also necessary to adjust the spare parts data to a file type corresponding to the RPA program through a template file, and clear the useless data in the old spare parts data, so as to achieve data cleaning of the spare parts data while performing template conversion. Specifically, before replacing the template file, it is necessary to select the marking file in the marked spare parts data to directly replace the template file. Moreover, other files in the spare parts data (except the export list after review) except the marking file need to be manually updated before each use. Then, after the spare parts data is replaced by the template data, it is imported into the RPA program according to the preset export method and run to sort out the data in this table.

[0051] See also Figure 2 In a preferred embodiment, blue-labeled files or marked files such as "Coding Review Import Table", "Table 2: Column Extraction, Data Replacement", "Table 3: Duplicate Item Screening in This Table", "Table 4: Duplicate Item Screening in Previous Tables", "Table 5-1: Duplicate Item Screening in Hongyanhe", "Table 5-2: Duplicate Item Screening in Huizhou", "Table 5-3: Duplicate Item Screening in Fangchenggang", "Table 5-4: Duplicate Item Screening in Ningde", "Table 5-5: Duplicate Item Screening in Yangjiang", "Table 7: System Import File" are replaced by template files to clear old data. Other files (except the list exported after review) need to be manually updated before each use.

[0052] See also Figure 3 In a preferred embodiment, there are two export modes, corresponding to "My Tasks" and "Comprehensive Query". The current RPA programs are "Column Extraction_Data Replacement (My Tasks)" and "Column Extraction_Data Replacement (Comprehensive Query)". You can select the corresponding program to enter and run according to the different export modes ("My Tasks" and "Comprehensive Query"). After waiting for the process to be completed, return to the main interface.

[0053] Furthermore, the marking file in the spare part data is replaced by the template file, and the old data is cleared, including:

[0054] The template table of spare parts data is redefined, the identification logic of spare parts data is simplified, and the corresponding table of spare parts data is split to obtain the data in this table, and make the data in this table compatible with the RPA program.

[0055] In a preferred embodiment of the present invention, in order to replace the marked file in the spare parts data with the template data, the spare parts data will be redefined for the template table first, that is, the spare parts data will be redefined and adjusted in the form of the template file. And the identification of the spare parts data is correspondingly simplified according to the identification logic of the template file. At the same time, the spare parts data will be split to more clearly determine the corresponding information in the spare parts data. And the above-mentioned processed data is processed by the adapted RPA program to further obtain the data in this table.

[0056] Specifically, the data in this table is checked for duplicates level by level, and the suspension and confirmation of duplicates are controlled after each level of checking, including: the data in this table is screened for duplicates through a screening program, a historical table, and a corresponding company table in turn, and the collection of duplicate confirmation information after manual screening of duplicates is controlled, wherein the screening of duplicates includes deleting, hiding, and replacing the data in this table.

[0057] In one embodiment of the present invention, after obtaining the data in this table, in order to reduce the situations that can be deleted, hidden and replaced, the data in this table is checked for duplicates step by step. Specifically, the data in this table is sequentially subjected to the duplicate screening of the screening program, the duplicate screening of the previous table and the duplicate screening of the company. After obtaining the screened data, the screened data is manually confirmed for duplicates, and the duplicate verification and continued duplicate screening process are manually completed to obtain duplicate confirmation information. Moreover, when screening for duplicates, according to the results of the screening of the data in this table, that is, the situations that need to be deleted, the situations that need to replace the data with other spare data, and the situations that need to hide certain spare parts data, the corresponding deletion, replacement and hiding of the data in the above situations are controlled. It should be noted that the previous table is the spare parts data that has been screened in the previous duplicate screening process.

[0058] See also Figure 4 In a preferred embodiment, when checking for duplicate data, it is necessary to use a data duplicate checking program to enter, that is, to enter by selecting the program "data duplicate checking" and start running.

[0059] Furthermore, the data in this table are screened for duplicates through a screening procedure, including:

[0060] The data in this table are screened for duplicates through a screening program to obtain a first screening result, and first confirmed duplicates are collected after manual confirmation of the first screening result of the screening program, and the first confirmed duplicates are marked.

[0061] In one embodiment of the present invention, when performing the duplicate item screening of the screening program, it is the first duplicate item screening of the data in the table. After obtaining the corresponding first screening result, the duplicate items are manually confirmed again, and the first confirmed duplicate items screened out are marked by marking. Specifically, the screening program is the duplicate item selection function provided by Excel, and the first confirmed duplicate items can be marked by marking color.

[0062] See also Figure 5 and Figure 6 In a preferred embodiment, Figure 5 For the table before filtering in the Excel filter program, Figure 6 This is the table after the excel filter program has filtered the items. That is, after the excel filter software has finished filtering the duplicate items, a message box will pop up and the program will pause. You need to manually confirm the duplicate items. Then mark the duplicate items and "create a group" to keep only one. Select "completed" in the message box and confirm, and the program will be further controlled to continue running.

[0063] Furthermore, the data in this table is filtered for duplicates through the previous tables, including:

[0064] The first confirmed duplicate items are screened for duplicates through the previous table to obtain a second screening result, the second confirmed duplicate items after manual confirmation of the second screening result are collected, and the duplicate item cross codes corresponding to the previous table are imported into the corresponding spare parts of the corresponding second confirmed duplicate items and hidden.

[0065] In one embodiment of the present invention, when the data in this table is screened by the previous table, it is a secondary screening of the data in this table. That is, after the duplicate item screening is completed through the screening program and the first confirmed duplicate item is obtained, the first confirmed duplicate item is screened by the previous table. And after the screening, the second screening result is obtained, and the second confirmed duplicate item is determined by manually checking the second screening result. Then the duplicate item cross code of the previous table is copied to the spare part corresponding to the second confirmed duplicate item to complete the hiding.

[0066] See also Figure 7 and Figure 8 In a preferred embodiment, Figure 7 This is the table before all previous table filtering. Figure 8 This is the table after the previous table is screened. That is, after the previous table duplicates are screened, a message box pops up, the control program is paused, and the duplicates are manually confirmed. By comparing the spare parts information in the second confirmed duplicates with the previous table, the duplicate cross code of the previous table is copied to the spare parts corresponding to the second confirmed duplicates and "hidden". Select "Completed" in the message box and confirm, and the program is further controlled to continue running.

[0067] Specifically, the data in this table is filtered for duplicates through the corresponding company table, including:

[0068] The second confirmed duplicate items after hiding are screened for duplicates through the company table to obtain the third screening results, the third confirmed duplicate items after manual confirmation of the third screening results are collected, and the duplicate spare part codes corresponding to the third confirmed duplicate items are imported into the corresponding spare parts in the company table and hidden.

[0069] In one embodiment of the present invention, the corresponding company tables are different depending on the company. Therefore, in the process of screening duplicate items in the company table, the screening of the company table completes at least one screening of duplicate items. That is, after screening the previous tables and hiding the corresponding spare parts information of the previous tables, the duplicate items are screened one by one through each company table to obtain a third screening result. After obtaining the third screening result, it is also necessary to manually check and confirm the third confirmed duplicate items. Then, the duplicate spare part code corresponding to the third confirmed duplicate item is imported into the spare part corresponding to the company table, and the corresponding spare part information is hidden.

[0070] See also Fig. 9 and Fig.10 In a preferred embodiment, Fig. 9This is the table before filtering by the company table. Fig.10 This is the table after the company table is filtered. That is, after the duplicate items are filtered through the company table, a message box pops up, the program pauses, and the duplicate items are manually confirmed. By comparing the third confirmed duplicate items with, for example, the company table of Company A, the duplicate item spare part code of the table of the third confirmed duplicate items is copied to the spare part corresponding to the company table of Company A, and the spare parts in the table of the third confirmed duplicate items are "hidden". Select "Completed" in the message box and confirm, and the program is further controlled to continue running.

[0071] See also Fig.11 In a preferred embodiment, after screening duplicate items of other companies in turn, a review form is finally obtained, which is then sent to the spare parts center for coding and then returned.

[0072] Specifically, the review form after all levels of duplication checking is obtained, including:

[0073] Collect the processing completion signal of the duplicate items confirmed at the previous level, and control the duplication check at the next level according to the processing completion signal until the duplication check at each level is completed and the review table is obtained.

[0074] In one embodiment of the present invention, during the duplication checking process at each level, when the relevant processing process of the last confirmed duplicate item is completed, a corresponding processing completion signal can be collected. And according to the processing completion signal, the next level of duplication checking can be controlled, and after all the duplication checking procedures are completed, the final review table is obtained and sent to the spare parts center for coding.

[0075] Furthermore, the review table is encoded, and the screened data during the duplicate check is re-imported into the review table to obtain the overwrite table after data management, including:

[0076] Get the corresponding company table, history table, and screening data when the screening program is used to screen duplicate items, and write the corresponding company table, history table, and screening data corresponding to the screening program into the review table in turn, and obtain the import table and difference table after encoding each data in the review table, wherein when the screened data is written into the review table, it is based on the data in this table before the screening program screens out duplicate items.

[0077] In one embodiment of the present invention, after the review form obtained after the duplicate check is sent to the spare parts center for encoding, the screened data of the company table corresponding to each company is first written into the encoded review form in sequence to obtain the first import table. Then the screened data corresponding to the previous table is written into the first import table to obtain the second import table. Finally, the screened data corresponding to the screening program is written into the second import table, thereby obtaining the import table and difference table corresponding to the data in this table, and the encoded data after screening and encoding will be marked. Moreover, when importing the screened data into the review table, it is necessary to check whether the imported data corresponds to the data in this table. That is, when the filtered data is written into the review table, it is based on the data in this table before the screening program filters the duplicates.

[0078] See also Fig.12 A preferred embodiment is a "write import list" program for writing the company table, the history table, and the screening data corresponding to the screening program into the review table.

[0079] See also Fig.13 , Fig.14 and Fig.15 In a preferred embodiment, Fig.13 To filter out the table of data writing process, Fig.14 For the table of the imported table, Fig.15 This is the difference table obtained after the final review with the back label data. Specifically, by copying the reviewed company table, history table, and the screening data corresponding to the screening program into the review table in sequence, then select the "Write Import List" program to enter and control the operation. The screened data is written in sequence, and the writing progress is judged by observing the number of data displayed below the table, and then the import table and difference table are obtained respectively.

[0080] like Fig.16 As shown, the present invention also provides a nuclear power spare parts data management robot based on RPA technology, including:

[0081] A data sorting unit, which extracts and sorts spare parts data to obtain data in this table that is compatible with data management;

[0082] The data duplication checking unit checks the data of the table for duplication at each level, and controls the suspension and confirmation of duplicate items after each level of duplication checking, thereby obtaining a review table after duplication checking at each level; and

[0083] Write a retrieval unit, write the retrieval unit to encode the review table, and re-import the screened data during the duplicate check into the review table to obtain the overwrite table after data management.

[0084] It is not difficult to understand from the above content that when the spare parts data management robot of the present invention performs data management, the extracted spare parts data is sorted into data compatible with the RPA program through the data sorting unit, so as to realize the redefinition of template forms, simplification of recognition logic, splitting of data tables, etc. of spare parts data, and then obtain the data in this table. Then, the data duplication checking unit is used to check the data in this table step by step, and the review table after the corresponding deletion, replacement and hiding processing is obtained. The review table is then sent to the spare parts center for coding through the writing and retrieval unit. And after coding, the screened data after duplication checking at each level is written into the review table to obtain the corresponding import table and difference table.

[0085] In summary, the present invention organizes the extracted spare parts data to redefine the template table, simplify the recognition logic, and combines the duplicate checking process of the duplicate checking program software, inserts the manual review and confirmation stage, and then sends the obtained review table to the spare parts center for coding. It realizes automatic conversion of information format to ensure that the front-end input information complies with the norms; performs preliminary duplicate code identification on the spare parts information to reduce the workload of manual comparison; receives the spare parts center list and reversely organizes the format to overwrite the system. Moreover, in order to adapt the RPA program, it realizes redefinition of template tables, simplification of recognition logic, and splitting of data tables. By combining the Excel table mouse macro operation, the limitations of software functions are broken through and process automation is promoted. Through the designed duplicate spare parts marking method, the input order of different tables is reasonably planned. By splitting the duplicate checking process into multiple sub-processes, and pausing and continuing the process by inserting an information box in the middle. Therefore, the present invention effectively overcomes the various shortcomings in the prior art and has a high industrial utilization value.

[0086] The above embodiments are merely illustrative of the principles and effects of the present invention, and are not intended to limit the present invention. Anyone familiar with the art may modify or alter the above embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or alterations made by a person of ordinary skill in the art without departing from the spirit and technical concept disclosed by the present invention shall still be covered by the claims of the present invention.

Claims

1. A nuclear power spare parts data management method based on RPA technology, characterized in that: The steps include: Extract spare parts data and organize them to obtain data in this table that is compatible with data management; The data in the table are checked for duplicates at each level, and the duplicate items are paused and confirmed after each level of checking for duplicates, so as to obtain a review table after checking for duplicates at each level; The review table is encoded, and the screened data during the duplicate check is re-imported into the review table to obtain an overwrite table after data management.

2. According to claim 1, the method for managing nuclear power spare parts data based on RPA technology is characterized in that: Extract spare parts data and organize them to obtain data in this table that is compatible with data management, including: The marking file in the spare part data is replaced by the template file, and the old data is cleared, wherein other files in the spare part data except the marking file are updated by manual control; The replaced spare parts data is imported into the corresponding RPA program according to the export mode type, and the data in this table is sorted out.

3. The method for managing nuclear power spare parts data based on RPA technology according to claim 2 is characterized in that: The marking file in the spare parts data is replaced by the template file, and the old data is cleared, including: The template table of the spare parts data is redefined, the identification logic of the spare parts data is simplified, and the corresponding table of the spare parts data is split to obtain the data in the present table, and make the data in the present table compatible with the RPA program.

4. The method for managing nuclear power spare parts data based on RPA technology according to claim 1 is characterized in that: The data in this table are checked for duplicates level by level, and control is given to pausing and confirming duplicates after checking for duplicates at each level, including: screening the data in this table for duplicates through a screening program, a historical table, and a corresponding company table in turn, and controlling the collection of duplicate confirmation information after manual screening of the duplicates, wherein the screening for duplicates includes deleting, hiding, and replacing the data in this table.

5. The method for managing nuclear power spare parts data based on RPA technology according to claim 4 is characterized in that: The data in this table are screened for duplicates through a screening procedure, including: The data in the table are screened for duplicates through a screening program to obtain a first screening result, first confirmed duplicates are collected after manual confirmation of the first screening result of the screening program, and the first confirmed duplicates are marked.

6. The method for managing nuclear power spare parts data based on RPA technology according to claim 5 is characterized in that: The data in this table are screened for duplicates through previous tables, including: The first confirmed duplicate items are screened for duplicates through the previous table to obtain a second screening result, the second confirmed duplicate items after manual confirmation of the second screening result are collected, and the duplicate item cross codes corresponding to the previous table are imported into the corresponding spare parts of the corresponding second confirmed duplicate items and hidden.

7. The method for managing nuclear power spare parts data based on RPA technology according to claim 6 is characterized in that: The data in this table is filtered for duplicates through the corresponding company table, including: The second confirmed duplicate items after being hidden are screened for duplicates through the company table to obtain a third screening result, and the third confirmed duplicate items after manual confirmation of the third screening result are collected, and the duplicate spare part codes corresponding to the third confirmed duplicate items are imported into the spare parts corresponding to the company table and hidden.

8. The method for managing nuclear power spare parts data based on RPA technology according to claim 1 is characterized in that: Get the review form after going through various levels of duplication checking, including: The processing completion signal of the confirmed duplicate items of the previous level is collected, and the duplication check of the next level is controlled to continue according to the processing completion signal until the duplication check of each level is completed to obtain the review table.

9. The method for managing nuclear power spare parts data based on RPA technology according to claim 4 is characterized in that: The review table is encoded, and the screened data during the duplicate check is re-imported into the review table to obtain an overwrite table after data management, including: Obtain the corresponding company table, history table, and the screening data when the screening program performs duplicate screening, and write the corresponding company table, history table, and the screening data corresponding to the screening program into the review table in turn, to obtain an import table and a difference table after encoding each data in the review table, wherein when the screened data is written into the review table, it is based on the data in the current table before the screening program screens out duplicates.

10. The nuclear power spare parts data management robot based on RPA technology is characterized by: include: A data sorting unit, which extracts and sorts spare parts data to obtain data in this table that is compatible with data management; A data duplication checking unit, wherein the data duplication checking unit checks the data of the table for duplication at each level, and controls the suspension and confirmation of duplicate items after each level of duplication checking, so as to obtain a review table after duplication checking at each level; as well as A writing and retrieving unit is used to encode the review table and re-import the screened data during the duplicate checking into the review table to obtain an overwrite table after data management.

Images