CN117592707A - Nuclear power business processing method based on RPA robot - Google Patents
Nuclear power business processing method based on RPA robot Download PDFInfo
- Publication number
- CN117592707A CN117592707A CN202311555084.0A CN202311555084A CN117592707A CN 117592707 A CN117592707 A CN 117592707A CN 202311555084 A CN202311555084 A CN 202311555084A CN 117592707 A CN117592707 A CN 117592707A
- Authority
- CN
- China
- Prior art keywords
- data
- nuclear power
- task
- qdr
- processing method
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 40
- 238000012545 processing Methods 0.000 claims abstract description 23
- 230000005540 biological transmission Effects 0.000 claims abstract description 15
- 238000004422 calculation algorithm Methods 0.000 claims abstract description 14
- 238000012795 verification Methods 0.000 claims abstract description 12
- 238000004140 cleaning Methods 0.000 claims abstract description 11
- 238000009826 distribution Methods 0.000 claims description 51
- 238000007639 printing Methods 0.000 claims description 19
- 230000002159 abnormal effect Effects 0.000 claims description 15
- 238000007726 management method Methods 0.000 claims description 14
- 238000012544 monitoring process Methods 0.000 claims description 14
- 230000007246 mechanism Effects 0.000 claims description 9
- 230000007547 defect Effects 0.000 claims description 6
- 230000005856 abnormality Effects 0.000 claims description 4
- 238000013461 design Methods 0.000 claims description 4
- 230000000694 effects Effects 0.000 claims description 4
- 238000012423 maintenance Methods 0.000 claims description 4
- 238000013500 data storage Methods 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 42
- 230000008569 process Effects 0.000 abstract description 17
- 230000009466 transformation Effects 0.000 abstract description 5
- 230000035515 penetration Effects 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 10
- 238000007689 inspection Methods 0.000 description 8
- 238000004458 analytical method Methods 0.000 description 7
- 238000013515 script Methods 0.000 description 7
- 238000010200 validation analysis Methods 0.000 description 7
- 238000007405 data analysis Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 6
- 230000003203 everyday effect Effects 0.000 description 5
- 238000006243 chemical reaction Methods 0.000 description 4
- 230000014509 gene expression Effects 0.000 description 4
- 230000006872 improvement Effects 0.000 description 4
- 238000013480 data collection Methods 0.000 description 3
- 238000013439 planning Methods 0.000 description 3
- 230000003252 repetitive effect Effects 0.000 description 3
- 239000012141 concentrate Substances 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 230000002354 daily effect Effects 0.000 description 1
- 238000005315 distribution function Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000004801 process automation Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
- 238000013068 supply chain management Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06311—Scheduling, planning or task assignment for a person or group
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0633—Workflow analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Biodiversity & Conservation Biology (AREA)
- Life Sciences & Earth Sciences (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a nuclear power business processing method based on an RPA robot. The method comprises the following steps: s1, acquiring QDR data from a overhaul system, and cleaning and processing the QDR data according to a preset compatibility processing rule. The QDR data includes QDR application forms. S2, verifying the processed QDR data according to a preset verification algorithm to obtain verified QDR data. S3, the verified QDR data are transmitted to the SAP system to generate an NG notification. S4, finishing the cross-system transmission operation of the QDR data. According to the invention, the RPA robot is used as a bridge of an independent information system in a nuclear power office intranet, so that the purposes of data penetration, data one-time input and repeated use are realized, the business process is optimized, the working efficiency is improved, the labor cost is saved, and the digital transformation and automatic upgrading of a nuclear power enterprise are promoted.
Description
Technical Field
The invention relates to the technical field of nuclear power office automation processes, in particular to a nuclear power business processing method based on an RPA robot.
Background
An RPA (Robotic Process Automation robot flow automation) intelligent robot (hereinafter referred to as "RPA") is a flow software robot capable of handling a large number of repetitions and having certain logic rules. As a new generation of digital labor force, the system can simulate the operation mode of a person, break the data barriers among systems and automatically execute a series of business processes. Compared with manual operation, the RPA processing business process is faster, and the working efficiency is greatly improved. RPA technology has the following status quo and trends:
1. the automation range is continuously enlarged: RPA is used as an automation technology, and in addition to common financial and human resource automation, RPA is also applied to the fields of logistics, supply chain management, customer service, and the like. With the continuous development of RPA technology, the automation range of the RPA technology is continuously expanded.
2. Application scene diversification: RPA may be used to automate various types of business processes, including complex processes, cross-system processes, and the like.
3. Low code/no code platform: to reduce the technological threshold, RPA suppliers have introduced low-code or code-free platforms that enable non-technical personnel to create and manage automated processes as well.
4. Human-computer collaboration: RPA is not a technique to replace human work, but rather a way to work cooperatively with human work. In many cases, RPA may handle repetitive tasks, thereby enabling employees to focus on more valuable works, such as innovations and decisions.
Nuclear power enterprises serve as the highly sensitive industrial field, due to the complexity of the service, overall planning is lacking in the early stage in the construction and operation process, a large number of mutually independent information systems are generated in an office intranet, and a data island is formed. From the perspective of nuclear power enterprises, the traditional management lifting means approach to the limit, management efficiency is improved by innovative technology, and integration and comprehensive utilization of production data are important pushing hands for digital transformation of future enterprises.
Disclosure of Invention
The invention aims to solve the technical problem that the nuclear power service processing method based on the RPA robot aims at the defect that the nuclear power has a large number of independent information systems so as to form a plurality of data islands and the data cannot be used repeatedly due to one-time input.
The technical scheme adopted for solving the technical problems is as follows: a nuclear power business processing method based on an RPA robot is applied to an RPA robot end and comprises the following steps:
s1, acquiring QDR data from a overhaul system, and cleaning and processing the QDR data according to a preset compatibility processing rule; the QDR data comprises QDR application forms;
s2, verifying the processed QDR data according to a preset verification algorithm to obtain verified QDR data;
s3, transmitting the verified QDR data to an SAP system to generate an NG notification;
s4, finishing cross-system transmission operation of QDR data;
the QDR data are quality defect report data for recording abnormal conditions of equipment or parts which are not consistent with the initial design in the overhaul activities of the equipment and the parts during the maintenance of the nuclear power plant unit.
Further, in the nuclear power business processing method based on the RPA robot of the present invention, after step S3 and before step S4, the method further includes:
s5, after the NG notification bill is generated, the notification information is sent to the terminal of the corresponding responsible person according to a preset reminding mode.
Further, in the nuclear power business processing method based on the RPA robot, the method further comprises the following steps:
s6, recording a cross-system transmission result of the QDR data in a log file.
Further, in the nuclear power business processing method based on the RPA robot, the method further comprises the following steps:
s10, acquiring corresponding task data from a task system, and monitoring the deadline condition of a task;
s20, judging whether the task exceeds or is about to exceed; if yes, sending out-of-period reminding information to a terminal of a corresponding responsible person according to a preset reminding mode;
s30, judging whether the task is provided with a retry mechanism or not; if yes, when the actual retry number does not exceed the preset retry number threshold, a retry mechanism of the task is started, so that the task can be restarted.
Further, in the nuclear power business processing method based on the RPA robot of the present invention, step S10 further includes:
setting corresponding out-of-date rules for tasks acquired from a task system according to a data storage mode and a data structure of the task system, and monitoring the time limit condition of the tasks according to the out-of-date rules;
wherein the expiration rule comprises an expiration time and/or a retry number threshold.
Further, in the nuclear power business processing method based on the RPA robot, the method further comprises the following steps:
and S40, recording the out-of-date reminding information of the task and the actual retry times, and displaying the out-of-date reminding information and the actual retry times in an Excel table form.
Further, in the nuclear power business processing method based on the RPA robot, the method further comprises the following steps:
s50, monitoring the running state of the task system, and sending out abnormal reminding information when abnormal running conditions occur; the abnormal operation condition comprises downtime of the task system or network abnormality of the task system.
Further, in the nuclear power business processing method based on the RPA robot, the method further comprises the following steps:
s100, acquiring a program effective list from a circulation library of a document management system, and acquiring a latest standard program distribution list from a shared folder of the document management system; wherein the program includes a file document;
s200, comparing the program effective list with the latest standard program distribution list, and judging whether programs in the program effective list are in the latest standard program distribution list or not;
and S300, if yes, distributing the corresponding program to a file satellite library, and recording a distribution result.
Further, in the nuclear power business processing method based on the RPA robot, the method further comprises the following steps:
s400, opening a corresponding program in the file satellite library according to the distribution result, and setting printing parameters according to the printing requirements in the latest standard file distribution list so as to print the program.
Further, in the nuclear power business processing method based on the RPA robot, the method further comprises the following steps:
s500, summarizing all distribution results in a file satellite library, and generating a satellite library distribution list;
and S600, sending the satellite library distribution list to a terminal of a file satellite library service interface person according to a preset reminding mode.
The nuclear power business processing method based on the RPA robot has the following beneficial effects: according to the invention, the RPA robot is used as a bridge of an independent information system in a nuclear power office intranet, so that the purposes of data penetration, data one-time input and repeated use are realized, the business process is optimized, the working efficiency is improved, the labor cost is saved, and the digital transformation and automatic upgrading of a nuclear power enterprise are promoted.
Drawings
The invention will be further described with reference to the accompanying drawings and examples, in which:
fig. 1 is a flowchart of a nuclear power business processing method based on an RPA robot provided in embodiment 1 of the present invention;
fig. 2 is a flowchart of a nuclear power service processing method based on an RPA robot according to some embodiments of the present invention;
FIG. 3 is a flow chart of a nuclear power business processing method based on an RPA robot provided by some embodiments of the invention;
fig. 4 is a flowchart of a nuclear power service processing method based on an RPA robot provided in embodiment 2 of the present invention;
FIG. 5 is a flowchart of a method for processing nuclear power business based on an RPA robot according to some embodiments of the invention;
FIG. 6 is a flow chart of a method for processing nuclear power business based on an RPA robot provided by some embodiments of the invention;
fig. 7 is a flowchart of a nuclear power service processing method based on an RPA robot provided in embodiment 3 of the present invention;
fig. 8 is a flowchart of a nuclear power service processing method based on an RPA robot according to some embodiments of the present invention;
fig. 9 is a flowchart of a nuclear power service processing method based on an RPA robot according to some embodiments of the present invention.
Detailed Description
For a clearer understanding of technical features, objects and effects of the present invention, a detailed description of embodiments of the present invention will be made with reference to the accompanying drawings.
In the following description, for purposes of explanation and not limitation, specific details are set forth such as the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
Example 1
The RPA intelligent robot is used as a non-invasive technology, the original system is not required to be transformed, the development and deployment of an automatic process can be rapidly completed based on an RPA low-code/code-free platform, and meanwhile, the high-efficiency and convenient adjustment can be performed according to the service.
For a cross-system transmission service scene of nuclear power data, before improvement, the cross-system transmission service scene is completely finished by manpower, and personnel with certain expertise and skills are required to be distributed to finish related work. The work responsible person inputs a QDR (i.e. quality defect report) application form in the overhaul system, after the application form passes approval, the work responsible person exports the approved QDR application form, logs in the SAP system, inputs the exported QDR application form into the SAP system one by one, and the data is repeatedly input, so that the work efficiency is low.
In a preferred embodiment, referring to fig. 1, the nuclear power service processing method based on the RPA robot of the present embodiment is applied to the RPA robot end, and includes the following steps:
s1, acquiring QDR data from a overhaul system, and cleaning and processing the QDR data according to a preset compatibility processing rule. The QDR data includes QDR application forms.
It should be noted that, overhaul refers to the planned maintenance of the nuclear power generator set, and the overhaul system records related information of each overhaul, such as the preparation work content of the overhaul, the work content in the implementation of the overhaul, the summary work content after the end of the overhaul, and the like.
That is, this step includes a data collection step and a data cleaning step, specifically, a data collection step: determining a data source (overhaul management system) and a data type (a checked and approved QDR application form) to be transmitted, acquiring the data to be transmitted by writing an RPA (remote procedure A) automation script, and optionally, acquiring the data by a self-defined workflow, a Web form, an API (application program interface) and the like.
And (3) data cleaning: and cleaning and processing the acquired QDR application form data, wherein compatibility processing rules include, but are not limited to, data format conversion, data deduplication, data filling and the like, so that the compatibility of the data among different systems is ensured.
In practical applications, data is often affected by various factors, resulting in errors, repetitions or outliers in the system, so data cleaning is required to be performed for data transmission across the system. The purpose of data cleansing is to ensure data quality in order to obtain accurate and reliable results in tasks such as data analysis, mining, etc.
Format conversion: inconsistent data formats are unified, such as date format, units, case, etc.
And (5) de-duplication: duplicate records in the dataset are detected and removed.
Filling: missing values in the dataset are detected and populated. The purpose of data population is to replace missing data with appropriate values or estimates to preserve the integrity of the data. Common data population methods include filling in missing values with averages, median, etc., or filling in missing values with values that occur most frequently. The amount of data currently involved is relatively small, with default data being supplemented by manual verification.
S2, verifying the processed QDR data according to a preset verification algorithm to obtain verified QDR data.
That is, the data after being cleaned and processed is checked and verified, for example, four operations are performed on the digital data in the QDR application form by using rules and algorithms, and format verification is performed on the date data, so that the accuracy and the integrity of the data are ensured.
Alternatively, the preset verification algorithm includes, but is not limited to:
1. range Validation:
example rules: ensuring that the data is between 1 and 100.
Example of algorithm: if the data is of the numeric type, the sizes are directly compared. If the data is of the date type, it is ensured that the date is within a certain time range.
2. Format verification (Format Validation):
example rules: the format of the mailbox address is verified.
Example of algorithm: regular expressions are used to verify whether the mailbox address conforms to a standard format, for example,' + < a > -zA-Z0-9 > < a >, a between zA-Z0-9.- - [ a-zA-Z ] {2, } $ j.
3. Uniqueness verification (Uniqueness Validation):
example rules: ensuring that the identification card number is unique in the database.
Example of algorithm: and acquiring a data set, and checking whether the same identification card number exists.
4. Logic Validation (Logic Validation):
example rules: the end date cannot be earlier than the start date.
Example of algorithm: it is checked whether the end date is equal to or greater than the start date.
5. Length verification (Length Validation):
example rules: the length of the user name should be between 6 and 20 characters.
Example of algorithm: the length of the character string is calculated to ensure that it is within a specified range.
6. Regular expression verification (Regular Expression Validation):
example rules: the format of the telephone number is verified.
Example of algorithm: the regular expression is used to match a particular phone number format, such as the ∈3} - \d {3} - \d {4} $ b.
S3, the verified QDR data are transmitted to the SAP system to generate an NG notification.
It should be noted that, an Enterprise Resource Planning (ERP) software of the SAP (Systems, applications, and Products in Data Processing) system is developed by a company named SAP SE in germany, and is used for managing various aspects of business of the enterprise, including finance, purchasing, production, inventory, sales, human resources, and the like. SAP systems are intended to integrate various department services within an enterprise to improve the efficiency and synergy of the business process. Better resource management, productivity improvement, decision support enhancement and better user service provision can be achieved through the SAP system.
That is, the QDR robot reads the verified data and then enters it into the NG notification ticket of the target system (SAP system) through an automated flow script.
It should be noted that an automation flow script refers to a script or instruction set required to create an automation robot using RPA programming software. These scripts describe tasks that the robot needs to perform, such as manipulating user interfaces, processing data, performing computations, and interacting with other systems, etc. Illustratively, for example, an NG notification flow is automatically created.
S4, finishing the cross-system transmission operation of the QDR data.
The QDR data is quality defect report data recorded by finding abnormal conditions of equipment or parts which are not consistent with the initial design in overhaul activities of the equipment and the parts during the maintenance of the nuclear power plant unit.
Optionally, referring to fig. 2, after step S3 and before step S4, the method further includes:
s5, after the NG notification bill is generated, the notification information is sent to the terminal of the corresponding responsible person according to a preset reminding mode.
Specifically, the preset reminding mode of the invention comprises but is not limited to mail reminding, short message reminding, nail reminding and the like.
Optionally, referring to fig. 3, the method further comprises:
s6, recording a cross-system transmission result of the QDR data in a log file. Specifically, the cross-system transmission results include, but are not limited to, transmission content, transmission time, whether transmission was successful, and the like.
In this embodiment, the RPA intelligent robot automatically logs in the overhaul system, exports a QDR (quality defect report) data list according to preset conditions, cleans and gathers data, logs in the SAP system one by one application form data, and notifies the work responsible of data logging results by mail.
It should be noted that, the present invention needs to apply for a specific system account for the RPA intelligent robots, write corresponding RPA intelligent robots for different service scenarios and deploy the RPA intelligent robots on an RPA platform, where the RPA platform is built in a nuclear power office intranet, so as to implement interconnection and interworking, and the RPA platform is used for managing and executing a central system of the robots, and generally has functions of managing, monitoring, planning and executing tasks of the robots.
Optionally, a service scenario corresponds to developing an RPA intelligent robot, and the one RPA intelligent robot corresponds to an automation process, and all RPA intelligent robots can share a system account; the system account number is equivalent to an enterprise employee number (digital employee) and is used for accessing each business system in the office intranet.
In addition, writing RPA intelligent robots refers to developing RPA intelligent robots that are scripts or instruction sets created by RPA programming software (not what we generally understand is an entity robot) that can automatically perform a series of tasks or operations, and the automated flow script includes the following:
(1) triggering conditions of the flow: including when to initiate an automated process, such as a particular time, a particular event trigger, etc.
(2) User interface operations: including simulating user clicks on applications or web pages, entering text, selecting menus, etc.
(3) And (3) data processing: processing and converting data, including reading data from files, transferring data between different systems, performing computations, etc.
(4) Conditions and cycles: a conditional statement (e.g., if statement) and a loop (e.g., for loop) are used to implement basic logic control.
(5) Error handling: describing how an error should be handled when it occurs in the flow includes skipping a step, retrying, recording error information, etc.
(6) Integration with other systems: interactions with other systems, databases, such as querying databases, sending emails, etc., are described.
According to the invention, the RPA robot is used as a bridge of an independent information system in a nuclear power office intranet, so that the purposes of data penetration, data one-time input and repeated use are realized, the business process is optimized, the working efficiency is improved, the labor cost is saved, and the digital transformation and automatic upgrading of a nuclear power enterprise are promoted.
In a specific implementation manner, the nuclear power service processing method based on the RPA robot in this embodiment specifically includes the following steps:
1) The RPA intelligent robot automatically logs in the overhaul system every day to access the QDR module.
2) And calling a query function of the system, inputting a query condition, and starting the query.
3) And exporting the query result to excel, and cleaning and processing the data, wherein the operations comprise data format conversion, data deduplication, data filling and the like.
4) And verifying the processed data to ensure that the data type and the data format meet the requirements.
5) And automatically inputting an SAP system, reading the verified data, creating an NG notification ticket, and recording the result.
6) After the input of the input data is completed, the mail informs the work responsible person.
The service scene covers 2 on-line units, 1000 application forms are generated every year, the input time of each application form is about 0.2 hour, and the working hour of the RPA intelligent robot can be saved by 200 hours.
Example 2
Aiming at the nuclear power data statistical analysis business scene, before improvement, task out-of-date reminding needs to manually log in various task systems, a task list about to be out-of-date and the task list which are out-of-date is exported according to specific conditions, and then task out-of-date reminding mails are sent to task responsible persons and task supervision persons. Various business systems are more and different people need to be allocated for processing.
Referring to fig. 4, the nuclear power service processing method based on the RPA robot of the present embodiment further includes:
s10, acquiring corresponding task data from a task system, and optionally, acquiring the corresponding task data from the task system according to query conditions input by a user and monitoring the time limit condition of the task.
Specifically, according to the data storage mode and the data structure of the task system, setting corresponding out-of-date rules for the tasks acquired from the task system, and monitoring the time limit condition of the tasks according to the out-of-date rules. Wherein the expiration rules include, but are not limited to, timeout times, retry number thresholds, and the like. In addition, different reminding modes, such as mail reminding, short message reminding, nail reminding and the like, are designed according to the nature of tasks in the task system.
S20, judging whether the task exceeds or is about to exceed. If yes, sending out-of-period reminding information to the terminal of the corresponding responsible person according to a preset reminding mode.
S30, judging whether a retry mechanism is arranged on the task. If yes, when the actual retry number does not exceed the preset retry number threshold, a retry mechanism of the task is started, so that the task can be restarted.
That is, when the task is out of date, the retry mechanism of the task is started according to the set number of retries and retry time interval.
Optionally, referring to fig. 5, the method further comprises:
and S40, recording the out-of-date reminding information of the task and the actual retry times, and displaying the out-of-date reminding information and the actual retry times in an Excel table form.
It can be understood that the data such as the expiration reminding information and the retry record of the task in the task system are displayed in the Excel report, so that the user can know the task execution condition.
Optionally, referring to fig. 6, the method further comprises:
s50, monitoring the running state of the task system, and sending out abnormal reminding information when abnormal running conditions occur. The abnormal operation condition comprises downtime of the task system or network abnormality of the task system.
It can be understood that when abnormal conditions occur in the task system, such as downtime of a server, network abnormality and the like, abnormal mail reminding is timely carried out, and stable operation of the RPA intelligent robot is ensured.
In this embodiment, the RPA robot automatically logs in to the usual task system, exports task list data, screens out the tasks that are counted out or are about to be out of date, and notifies the corresponding responsible person.
According to the embodiment, the task out-of-date condition and the automatic reminding function in the automatic monitoring task system are realized through the RPA robot, so that the working efficiency is improved, the labor cost is saved, and the digital transformation and the automatic upgrading of a nuclear power enterprise are promoted.
In a specific implementation manner, the nuclear power service processing method based on the RPA robot of the embodiment aims at the data statistics analysis service scene, and includes the following steps:
1) The RPA intelligent robot automatically logs into the task system (4 systems are involved) every day.
2) And calling the query function of the target system, inputting query conditions and exporting data.
3) And (3) summarizing and cleaning the derived data, and supplementing out-of-period reminding rules and reminding modes of various tasks, such as overtime time, retry times and the like, wherein the reminding modes include mail reminding, short message reminding, nail reminding and the like.
4) And reading the summarized data, generating reminding contents according to different reminding modes, and sending the reminding contents to a task responsible person.
The scene covers 2 on-line units and totally relates to 4 sets of systems. The method can timely screen and count out-of-date or about-to-out-of-date tasks, notify responsible persons, and ensure timely examination and approval of the tasks.
Example 3
For the service scenario of replacing manual service execution, before improvement, the nuclear power satellite file distribution service is described as follows,
1) Business personnel access the shared folder and update the standard file distribution list;
2) Business personnel log in a document management system, and export a program effective list in a system circulation library according to effective date;
3) The service personnel compares the program effective list with the standard file distribution list, and judges whether the program of the effective list is in the standard file distribution list one by one, wherein the judging conditions comprise file coding, effective date, version number and the like.
4) And (3) according to the result of the third step, if the program in the effective list is in the standard file distribution list, inquiring the program in the document management system flow library according to the file code, and distributing the program to the corresponding file satellite library through distribution operation.
5) Service personnel find out the newly distributed program according to the file code in the satellite library, print operation is carried out after opening, and print parameters are required to be set on single side and double side, black and white, parts, sizes and the like according to the requirements of each program in a standard distribution list.
6) The service personnel generates a distribution list (if any) of the satellite libraries every day, and notifies the service interface personnel of the satellite libraries.
7) The business personnel log in the system every week to export all effective files, compare with the standard file distribution list in the shared folder, check the conditions of missing transmission, retransmission, file version check, and the like.
Based on this, referring to fig. 7, the nuclear power service processing method based on the RPA robot of the present embodiment further includes:
s100, acquiring a program effective list from a circulation library of the document management system, and acquiring a latest standard program distribution list from a shared folder of the document management system. Wherein the program comprises a file document.
S200, comparing the program effective list with the latest standard program distribution list, and judging whether the program in the program effective list is in the latest standard program distribution list.
And S300, if yes, distributing the corresponding program to a file satellite library, and recording a distribution result.
Optionally, referring to fig. 8, the method further comprises:
s400, opening a corresponding program in the file satellite library according to the distribution result, and setting printing parameters according to the printing requirements in the latest standard file distribution list so as to print the program.
Optionally, referring to fig. 9, the method further includes:
s500, summarizing all distribution results in the file satellite library, and generating a satellite library distribution list.
And S600, sending the satellite library distribution list to a terminal of a file satellite library service interface person according to a preset reminding mode.
It can be understood that the service processing method of the embodiment can realize five functions of data analysis, automatic printing, mail sending, automatic distribution, quality inspection, and the like, and specifically comprises the following steps:
1) Data analysis function:
data collection and cleaning: the RPA robot acquires data from a specified data source (such as a document system and a standard distribution list file), and cleans and converts the data according to file codes, including data format conversion, data deduplication, data filling and data comparison peer-to-peer operation, so that the accuracy and consistency of the data are ensured.
Data processing and analysis: designing RPA flow to execute data analysis task, and relating to statistical calculation, analysis, relevance and the like of file list data. Data manipulation and analysis was performed using Excel.
Report generation and visualization: based on the analysis results, excel was used to generate visual results.
Automated scheduling: the RPA robot is arranged to trigger the execution of the data analysis flow according to a preset time (such as 8:00, 7:00 or 6:00 daily, etc.), so that the data can be updated and analyzed as required.
2) Automatic printing function:
triggering conditions: the RPA robot receives the print request and initiates printing once the trigger condition is met.
Acquiring printing content: when the triggering condition is met, the RPA robot acquires the file code of the distribution program to be printed, and acquires the file content from the document system through the file code.
Printing operation: the RPA reads the print requirements of the files in the standard distribution list, such as single-sided, black-and-white, copies, sizes, etc., and connects to the network printer and configures the parameters.
And (3) monitoring a printing state: and monitoring the state of the printing task to ensure successful completion of printing. If an error occurs, an error handling flow (reprinting) is triggered.
3) Mail sending function:
setting a trigger condition: the RPA robot triggers mail sending under specific conditions, which may be file state change, event (successful flow execution, abnormal flow) and the like in the system.
Acquiring mail information: mail-related information is collected from specified data sources including recipient addresses, topics, text content, attachments, and the like.
Mail construction and sending: the RPA automatically acquires the mail content, uses the html language to compile the mail display style as required, adds the attachment (if any), and sends the mail to the target recipient.
Monitoring and recording: and recording mail sending state, and recording successful or failed results in the log file.
4) Automatic distribution function:
triggering condition definition: the RPA robot monitors the input channel for specific trigger conditions, such as receiving a specific file, receiving a request, etc.
Acquiring distribution content: obtaining the content to be distributed from the input channel may require parsing, converting or extracting the information.
Target identification and distribution: according to preset rules, the RPA robot distributes the content to the appropriate targets, which may be terminals corresponding to different departments, personnel or systems.
And (3) recording distribution results: the results of each distribution operation, including success, failure, or other status, are recorded for subsequent review and optimization.
5) Quality inspection function:
setting a triggering mode: the RPA robot triggers the quality inspection task at a specific time (e.g., illustratively, 9:00 a.c.).
Obtaining a test sample: the RPA robot obtains the data to be inspected from the data source (document system, standard distribution manifest file).
Automatic checking flow: the RPA automatic flow executes the checking task, and relates to automatic checking operations such as data comparison, check and the like.
And (3) generating a test result: based on the inspection results, the RPA robot generates Excel inspection reports, including problem lists, statistics, and the like.
Report save and notification: the RPA robot saves the inspection report to a designated location and mail the relevant personnel or system.
Optionally, the method further comprises an exception handling mechanism: an error processing mechanism is arranged for the five functional modules, so that a flow responsible person can be timely notified when a problem occurs, and appropriate measures are taken.
In this embodiment, necessary security measures such as Excel file encryption, authentication, etc. may be taken in order to ensure that sensitive data and operations are involved.
Alternatively, the critical operations are recorded using a sophisticated log record file to track operation history, troubleshoot problems, and perform performance analysis.
In the embodiment, the nuclear power satellite file distribution assistant RPA intelligent robot realizes five functions of data analysis, automatic distribution, automatic printing, mail sending and quality inspection, and replaces manual work to conduct the work of file data export, arrangement, comparison, analysis, distribution, tabulation, printing, result inspection and the like.
The embodiment can realize automatic processing of repetitive tasks, so that staff can concentrate on more valuable work, and the business process in nuclear power is optimized.
In a specific implementation manner, the nuclear power service processing method based on the RPA robot in this embodiment includes the following steps:
1) The RPA intelligent robot automatically logs in a document management system every day, and a program effective list is exported in a system circulation library according to the effective date;
2) Accessing a shared folder and acquiring a latest standard file distribution list;
3) And comparing the program effective list with the standard file distribution list, judging whether the program of the effective list is in the standard file distribution list one by one, and generating an excel comparison record.
4) And judging whether the programs in the effective list are in a standard file distribution list or not according to the comparison record, if so, inquiring the programs in the document management system flow library according to the file codes, distributing the programs to the corresponding file satellite library through distribution operation, and recording a distribution result by using excel.
5) The RPA intelligent robot reads the distribution result file, acquires the file code, finds a newly distributed program according to the file code in the satellite library, and calls the printing operation after opening.
6) And reading the printing requirement of each program in the standard distribution list of the shared folder, and setting parameters such as single-sided and double-sided, black and white, parts, sizes and the like according to the printing requirement.
7) And reading the distribution record, summarizing the distributed programs to generate a distribution list excel (if any) of the satellite library, and informing service interface persons of the satellite library by mail.
8) And triggering the login system every week to export all effective files, reading a standard file distribution list in the shared folder for comparison, checking the conditions of missed sending, resending, file version checking and the like, generating excel records, and informing a service responsible person of verification and confirmation by mail.
The scene covers 2 on-line units, the satellite file distribution assistant is used for automatically distributing files, human errors in document work are effectively prevented, and in addition, the time consumption of satellite file distribution every day is reduced from 1 person to 0.25 person.
The embodiment can realize automatic processing of repetitive tasks, so that staff can concentrate on more valuable work, and the business process in nuclear power is optimized.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative elements and steps are described above generally in terms of functionality in order to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. The software modules may be disposed in Random Access Memory (RAM), memory, read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
It is to be understood that the above examples only represent preferred embodiments of the present invention, which are described in more detail and are not to be construed as limiting the scope of the invention; it should be noted that, for a person skilled in the art, the above technical features can be freely combined, and several variations and modifications can be made without departing from the scope of the invention; therefore, all changes and modifications that come within the meaning and range of equivalency of the claims are to be embraced within their scope.
Claims (10)
1. The nuclear power business processing method based on the RPA robot is applied to the RPA robot end and is characterized by comprising the following steps:
s1, acquiring QDR data from a overhaul system, and cleaning and processing the QDR data according to a preset compatibility processing rule; the QDR data comprises QDR application forms;
s2, verifying the processed QDR data according to a preset verification algorithm to obtain verified QDR data;
s3, transmitting the verified QDR data to an SAP system to generate an NG notification;
s4, finishing cross-system transmission operation of QDR data;
the QDR data are quality defect report data for recording abnormal conditions of equipment or parts which are not consistent with the initial design in the overhaul activities of the equipment and the parts during the maintenance of the nuclear power plant unit.
2. The RPA robot-based nuclear power business processing method according to claim 1, further comprising, after step S3 and before step S4:
s5, after the NG notification bill is generated, the notification information is sent to the terminal of the corresponding responsible person according to a preset reminding mode.
3. The RPA robot-based nuclear power business processing method of claim 1, further comprising:
s6, recording a cross-system transmission result of the QDR data in a log file.
4. The RPA robot-based nuclear power business processing method of claim 1, further comprising:
s10, acquiring corresponding task data from a task system, and monitoring the deadline condition of a task;
s20, judging whether the task exceeds or is about to exceed; if yes, sending out-of-period reminding information to a terminal of a corresponding responsible person according to a preset reminding mode;
s30, judging whether the task is provided with a retry mechanism or not; if yes, when the actual retry number does not exceed the preset retry number threshold, a retry mechanism of the task is started, so that the task can be restarted.
5. The RPA robot-based nuclear power business processing method of claim 4, wherein step S10 further comprises:
setting corresponding out-of-date rules for tasks acquired from a task system according to a data storage mode and a data structure of the task system, and monitoring the time limit condition of the tasks according to the out-of-date rules;
wherein the expiration rule comprises an expiration time and/or a retry number threshold.
6. The RPA robot-based nuclear power business processing method of claim 4, further comprising:
and S40, recording the out-of-date reminding information of the task and the actual retry times, and displaying the out-of-date reminding information and the actual retry times in an Excel table form.
7. The RPA robot-based nuclear power business processing method of claim 4, further comprising:
s50, monitoring the running state of the task system, and sending out abnormal reminding information when abnormal running conditions occur; the abnormal operation condition comprises downtime of the task system or network abnormality of the task system.
8. The RPA robot-based nuclear power business processing method of claim 1, further comprising:
s100, acquiring a program effective list from a circulation library of a document management system, and acquiring a latest standard program distribution list from a shared folder of the document management system; wherein the program includes a file document;
s200, comparing the program effective list with the latest standard program distribution list, and judging whether programs in the program effective list are in the latest standard program distribution list or not;
and S300, if yes, distributing the corresponding program to a file satellite library, and recording a distribution result.
9. The RPA robot-based nuclear power business processing method of claim 8, further comprising:
s400, opening a corresponding program in the file satellite library according to the distribution result, and setting printing parameters according to the printing requirements in the latest standard file distribution list so as to print the program.
10. The RPA robot-based nuclear power business processing method of claim 1, further comprising:
s500, summarizing all distribution results in a file satellite library, and generating a satellite library distribution list;
and S600, sending the satellite library distribution list to a terminal of a file satellite library service interface person according to a preset reminding mode.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311555084.0A CN117592707A (en) | 2023-11-17 | 2023-11-17 | Nuclear power business processing method based on RPA robot |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311555084.0A CN117592707A (en) | 2023-11-17 | 2023-11-17 | Nuclear power business processing method based on RPA robot |
Publications (1)
Publication Number | Publication Date |
---|---|
CN117592707A true CN117592707A (en) | 2024-02-23 |
Family
ID=89909328
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202311555084.0A Pending CN117592707A (en) | 2023-11-17 | 2023-11-17 | Nuclear power business processing method based on RPA robot |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN117592707A (en) |
-
2023
- 2023-11-17 CN CN202311555084.0A patent/CN117592707A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8694969B2 (en) | Analyzing factory processes in a software factory | |
Strong et al. | Exceptions and exception handling in computerized information processes | |
CN107818431B (en) | Method and system for providing order track data | |
US8601323B2 (en) | Advanced management of runtime errors | |
US20080127089A1 (en) | Method For Managing Software Lifecycle | |
EP1677241A1 (en) | System supported optimization of event resolution | |
JP2006309780A (en) | Method for visually programming instruction set for process | |
US20070078701A1 (en) | Systems and methods for managing internal controls with import interface for external test results | |
US6269457B1 (en) | Technology regression and verification acceptance method | |
CN114462969A (en) | Project progress real-time monitoring method and device, electronic equipment and storage medium | |
US20030101085A1 (en) | Method and system for vendor communication | |
Carstensen et al. | Let's talk about bugs! | |
US7827533B2 (en) | Analytical server, program analysis network system, and program analysis method | |
TW202303474A (en) | Process operation system and process operation method | |
CN116010066A (en) | RPA robot and implementation method | |
US8504412B1 (en) | Audit automation with survey and test plan | |
CN114625640B (en) | Software test project management method and device, storage medium and electronic equipment | |
JP2008515056A (en) | Business process management system and method | |
CN117592707A (en) | Nuclear power business processing method based on RPA robot | |
CN111277425A (en) | Centralized data transmission management device | |
CN110347741B (en) | System for effectively improving output result data quality in big data processing process and control method thereof | |
US20220051109A1 (en) | System of intelligence learning agents leveraging expertise capture for work heuristics management | |
CN113435830A (en) | Mail information summarizing method, system, electronic device and storage medium | |
CN112948204A (en) | Data processing system based on DataRobot technology | |
JP2017102870A (en) | System operation automation device, system operation automation program, and system operation automation method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |