CN112008766A - RPA robot-based data recall automation method - Google Patents
RPA robot-based data recall automation method Download PDFInfo
- Publication number
- CN112008766A CN112008766A CN202010912831.1A CN202010912831A CN112008766A CN 112008766 A CN112008766 A CN 112008766A CN 202010912831 A CN202010912831 A CN 202010912831A CN 112008766 A CN112008766 A CN 112008766A
- Authority
- CN
- China
- Prior art keywords
- robot
- recall
- data
- electric meter
- bureau
- 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
Images
Classifications
-
- B—PERFORMING OPERATIONS; TRANSPORTING
- B25—HAND TOOLS; PORTABLE POWER-DRIVEN TOOLS; MANIPULATORS
- B25J—MANIPULATORS; CHAMBERS PROVIDED WITH MANIPULATION DEVICES
- B25J19/00—Accessories fitted to manipulators, e.g. for monitoring, for viewing; Safety devices combined with or specially adapted for use in connection with manipulators
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/40—Data acquisition and logging
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computer Hardware Design (AREA)
- Mechanical Engineering (AREA)
- Databases & Information Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Robotics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Manipulator (AREA)
Abstract
The invention discloses a data recall automation method based on an RPA robot, which comprises the steps of S1 daily timing starting, S2 electric meter bureau number acquisition, S3 data recall, S4 recall result feedback and the like. The application of the invention avoids the repeated operation of manually starting the robot every day, can effectively help the recruitment staff to reduce pressure and burden, and improves the enterprise management level.
Description
Technical Field
The invention discloses a data recall automation method based on an RPA robot.
Background
The big data of current electric power are developed rapidly, and power consumption acquisition terminal and user data acquisition application are all multiplied increase, and data acquisition's timeliness requires to have brought great challenge for a ray of data acquisition personnel. Therefore, an automatic method is urgently needed, which can realize automatic recall of abnormal data, relieve the working pressure of front-line personnel and ensure the timeliness of data acquisition.
Object of the Invention
The invention aims to provide an RPA robot-based data recall automation method, which can be used by a user to quickly recall data and meet the timeliness of data acquisition and application.
In order to achieve the purpose, the technical scheme of the invention is as follows:
a data recall automation method based on an RPA robot is characterized in that: the method comprises the following steps:
s1: the daily timing starts: automatically starting a recall robot through a lightweight enterprise-level job scheduling framework Quartz;
s2: collecting the number of the electric meter bureau: the robot automatically logs in the electricity consumption acquisition information system through a pre-designed behavior model, accurately positions and identifies foreground page text information of the electricity consumption acquisition information system by applying an Element Click technology, and acquires the number of an electric meter office to be recalled;
s3: data recall: executing data recruitment operation in a power consumption acquisition information system according to the number of an electric meter bureau acquired by S2 through a pre-designed behavior model, and finishing data recruitment behavior confirmation by means of an OCR technology;
s4: and (3) recalling result feedback: the robot feeds back the data recall condition to the spreadsheet.
In S1, automatically starting a recall robot through a lightweight enterprise-level job scheduling framework Quartz; in S2, acquiring the number of the electric meter bureau needing to be recalled by applying an Element Click technology; in S3, the robot calls the OCR service to complete the confirmation of the system verification code, and finally completes the data recall operation.
The working principle of the invention is as follows:
through a lightweight enterprise-level operation scheduling framework Quartz, the robot is started at 8 and 10 points every day, the robot automatically logs in an electricity utilization acquisition information system after being started, an abnormal data query function interface is opened, and the electricity bureau number needing to be subjected to data recalling is exported. And aiming at the electric meter bureau data needing to be recruited, taking at most 200 pieces of data in each batch as a limit, executing data recruitment operation in the electricity utilization acquisition information system, and recognizing the data recruitment verification code of the electricity utilization acquisition information system by utilizing an OCR technology to complete the confirmation of the recruitment operation. And after each batch of data is processed, feeding back the result of data recruitment to the electronic form of the specified path.
The invention has the beneficial effects that: after the method is applied, the repeated operation of manually starting the robot every day can be avoided. By the method, the automatic recall of the low-voltage user failure data and the large-user failure data can be realized, and the timeliness and the efficiency of data acquisition are improved. The application of the method can effectively help the recruitment staff to reduce pressure and burden, and improve the enterprise management level.
Drawings
FIG. 1 is a schematic flow diagram of the process of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present invention is not limited thereby.
A data recall automation method based on an RPA robot is characterized in that: the method comprises the following steps:
s1: the daily timing starts: automatically starting a recall robot through a lightweight enterprise-level job scheduling framework Quartz;
s2: collecting the number of the electric meter bureau: the robot automatically logs in the electricity consumption acquisition information system through a pre-designed behavior model, accurately positions and identifies foreground page text information of the electricity consumption acquisition information system by applying an Element Click technology, and acquires the number of an electric meter office to be recalled;
s3: data recall: executing data recruitment operation in a power consumption acquisition information system according to the number of an electric meter bureau acquired by S2 through a pre-designed behavior model, and finishing data recruitment behavior confirmation by means of an OCR technology;
s4: and (3) recalling result feedback: the robot feeds back the data recall condition to the spreadsheet.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the technical principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (2)
1. A data recall automation method based on an RPA robot is characterized in that: the method comprises the following steps:
s1: the daily timing starts: automatically starting a recall robot through a lightweight enterprise-level job scheduling framework Quartz;
s2: collecting the number of the electric meter bureau: the robot automatically logs in the electricity consumption acquisition information system through a pre-designed behavior model, accurately positions and identifies foreground page text information of the electricity consumption acquisition information system by applying an Element Click technology, and acquires the number of an electric meter office to be recalled;
s3: data recall: executing data recruitment operation in a power consumption acquisition information system according to the number of an electric meter bureau acquired by S2 through a pre-designed behavior model, and finishing data recruitment behavior confirmation by means of an OCR technology;
s4: and (3) recalling result feedback: the robot feeds back the data recall condition to the spreadsheet.
2. The RPA robot-based data recall automation method according to claim 1, characterized in that: in S1, automatically starting a recall robot through a lightweight enterprise-level job scheduling framework Quartz; in S2, acquiring the number of the electric meter bureau needing to be recalled by applying an Element Click technology; in S3, the robot calls the OCR service to complete the confirmation of the system verification code, and finally completes the data recall operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010912831.1A CN112008766A (en) | 2020-09-03 | 2020-09-03 | RPA robot-based data recall automation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010912831.1A CN112008766A (en) | 2020-09-03 | 2020-09-03 | RPA robot-based data recall automation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112008766A true CN112008766A (en) | 2020-12-01 |
Family
ID=73515656
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010912831.1A Pending CN112008766A (en) | 2020-09-03 | 2020-09-03 | RPA robot-based data recall automation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112008766A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112749171A (en) * | 2021-02-08 | 2021-05-04 | 国网山东省电力公司德州供电公司 | Cross-system non-invasive data acquisition technology |
| CN113642831A (en) * | 2021-06-24 | 2021-11-12 | 国网上海市电力公司 | Data rapid acquisition method, medium and equipment based on process automation processing |
| CN115048282A (en) * | 2022-08-15 | 2022-09-13 | 北京弘玑信息技术有限公司 | Extraction method of repeated operation, electronic device and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104360208A (en) * | 2014-12-05 | 2015-02-18 | 国家电网公司 | Acquisition failure analyzing and processing method of electricity utilization information acquisition operating and maintaining system |
| RU2665033C1 (en) * | 2017-10-25 | 2018-08-27 | федеральное государственное бюджетное образовательное учреждение высшего образования "Национальный исследовательский университет "МЭИ" (ФГБОУ ВО "НИУ "МЭИ") | Automatic frequency load shedding in the power supply power distribution network control method |
| CN109741118A (en) * | 2018-06-26 | 2019-05-10 | 平安科技（深圳）有限公司 | Invoice issuing method, apparatus, equipment and computer readable storage medium |
| CN110161300A (en) * | 2019-06-19 | 2019-08-23 | 广东电网有限责任公司 | A kind of monitoring method and monitoring device of low-voltage power supply |
| CN110489407A (en) * | 2019-07-29 | 2019-11-22 | 南方电网数字电网研究院有限公司 | Data filling mining method, apparatus, computer equipment and storage medium |
| CN111209271A (en) * | 2019-12-25 | 2020-05-29 | 深圳供电局有限公司 | Electric power data complementary acquisition method and device, computer equipment and storage medium |
-
2020
- 2020-09-03 CN CN202010912831.1A patent/CN112008766A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104360208A (en) * | 2014-12-05 | 2015-02-18 | 国家电网公司 | Acquisition failure analyzing and processing method of electricity utilization information acquisition operating and maintaining system |
| RU2665033C1 (en) * | 2017-10-25 | 2018-08-27 | федеральное государственное бюджетное образовательное учреждение высшего образования "Национальный исследовательский университет "МЭИ" (ФГБОУ ВО "НИУ "МЭИ") | Automatic frequency load shedding in the power supply power distribution network control method |
| CN109741118A (en) * | 2018-06-26 | 2019-05-10 | 平安科技（深圳）有限公司 | Invoice issuing method, apparatus, equipment and computer readable storage medium |
| CN110161300A (en) * | 2019-06-19 | 2019-08-23 | 广东电网有限责任公司 | A kind of monitoring method and monitoring device of low-voltage power supply |
| CN110489407A (en) * | 2019-07-29 | 2019-11-22 | 南方电网数字电网研究院有限公司 | Data filling mining method, apparatus, computer equipment and storage medium |
| CN111209271A (en) * | 2019-12-25 | 2020-05-29 | 深圳供电局有限公司 | Electric power data complementary acquisition method and device, computer equipment and storage medium |
Non-Patent Citations (3)
| Title |
|---|
| 丁振凡: "《Spring3.X编程技术与应用》", 31 August 2013, 北京邮电大学出版社 * |
| 李婉婷等: "对电能量计量系统中异常数据的处理与探讨", 《电气传动自动化》 * |
| 陈信元: "《会计学》", 31 March 2018, 上海财经大学出版社 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112749171A (en) * | 2021-02-08 | 2021-05-04 | 国网山东省电力公司德州供电公司 | Cross-system non-invasive data acquisition technology |
| CN113642831A (en) * | 2021-06-24 | 2021-11-12 | 国网上海市电力公司 | Data rapid acquisition method, medium and equipment based on process automation processing |
| CN115048282A (en) * | 2022-08-15 | 2022-09-13 | 北京弘玑信息技术有限公司 | Extraction method of repeated operation, electronic device and storage medium |
| CN115048282B (en) * | 2022-08-15 | 2022-10-25 | 北京弘玑信息技术有限公司 | Extraction method of repeated operation, electronic device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112008766A (en) | RPA robot-based data recall automation method | |
| CN104809548A (en) | Client appeal work order automatically issuing method | |
| CN112886922B (en) | Calculation method, device and storage medium for loss electric quantity of photovoltaic power station | |
| CN111950846A (en) | Intelligent factory shift scheduling system | |
| CN116149282A (en) | Processing control method and system for steel smelting based on flow control | |
| CN103746337A (en) | Relay protection device constant value modifying and checking system | |
| CN106790246A (en) | The automatic method and system for declaring social security | |
| CN109857507A (en) | A kind of method that automation remote executes Windows program | |
| WO2019080807A1 (en) | Method and system for managing energy supply device, and terminal device | |
| CN105356614A (en) | Universal debugging method applied to distribution network automation | |
| CN208444183U (en) | Fitter's bench error protection control system | |
| CN113887964B (en) | Production line simulation system based on man-machine method | |
| CN109324928A (en) | A kind of method of automatically backup data file | |
| CN113554418B (en) | Automatic price linkage method for agreement inventory purchase material contract | |
| CN115175023A (en) | Photovoltaic inverter-based method, system and device for reading meter of internet of things | |
| CN108319642A (en) | Processing method, processing unit and the terminal of outage information | |
| CN114020763A (en) | Kafka-based real-time power generation data acquisition and transmission and data monitoring method | |
| CN107104508B (en) | Power cut-off and power transmission time automatic calculation system integrating interactive communication function | |
| CN205142534U (en) | Portable worker singly handles mobile terminal | |
| CN110705230A (en) | Electronic ledger generation method and system based on overhaul operation behavior perception | |
| CN113032651A (en) | Dispatching operation data automatic acquisition and submission management system | |
| CN210490930U (en) | Central centralized control system of Internet of things | |
| CN208834380U (en) | A kind of invoice chooses terminal automatically | |
| CN116011795B (en) | Distributed power supply group regulation group control management system based on data analysis | |
| CN106205102A (en) | A kind of meter register method of power line carrier communication |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201201 |
|
| RJ01 | Rejection of invention patent application after publication |