CN116150199A

CN116150199A - Data checking method and system based on RPA robot

Info

Publication number: CN116150199A
Application number: CN202211426876.3A
Authority: CN
Inventors: 王树发; 尹峰
Original assignee: Guangdong Tobacco Guangzhou Co ltd
Current assignee: Guangdong Tobacco Guangzhou Co ltd
Priority date: 2022-11-15
Filing date: 2022-11-15
Publication date: 2023-05-23

Abstract

The invention provides a data checking method and a system based on an RPA robot, which relate to the technical field of intelligent data checking, wherein the method comprises the steps of initializing the RPA robot, and determining the query range of data by the RPA robot according to preset query conditions; the RPA robot opens each piece of data in the query range in turn according to the query range, and checks all the data according to preset check conditions to obtain a data check result; the RPA robot reorders the data which accords with the checking condition according to the data checking result, records the data which does not accord with the checking condition, and acquires the checked checking result; the RPA robot fills the checked checking result into a preset checking form; the invention can improve the accuracy of data checking, obviously improve the working efficiency and ensure the data quality; in addition, the transactional work of repeated and tedious data statistics, sequencing and filling of the data checking staff can be effectively reduced, and the enterprise management level is improved.

Description

Data checking method and system based on RPA robot

Technical Field

The invention relates to the technical field of intelligent data verification, in particular to a data verification method and system based on an RPA robot.

Background

In the era background of digital transformation, enterprises need to efficiently screen effective data from data which are huge and are mixed in artificial intelligence technology, and create value by utilizing the data; the purchasing is a natural big data center of an enterprise, and is a favorable entry point for the digitalized transformation of the enterprise; in the background of the day-to-day and month-to-month age, RPA (Robotics Process Automation) technology is fully called "robot process automation", and is mainly a software solution for executing repeatable tasks based on certain rules by simulating and enhancing the interaction process of people and a computer; simply, the operation of a person on a computer is simulated by software, and the process of the flow task is automatically executed according to a specified principle; the RPA software completes computer operation according to a set flow, replaces or assists people to complete the repeated labor with definite rules, is a digital labor force, can effectively help tobacco enterprise workers to release from a large number of simple and complex transactional works, inputs precious time and effort into more valuable works such as personnel management, service masses, tissue study and the like, and effectively improves the working efficiency;

in recent years, RPA obtains good effect in the direction of fusing with OCR technology, which is more convenient for the recognition and reading of images, while the RPA robot in the next step can be used in combination with more technologies, such as computer vision, intelligent voice, voice synthesis, natural language understanding, unstructured document understanding, and diversified development;

an important work of staff is that at the end of a month, the staff needs to be responsible for tracking, checking and making a report of the monthly fee payment condition of the staff at the supporting part (generally, the month is collected in the same month), and in the past, a manual checking, manual statistics and paper-filled report reporting mode is adopted, so that the payment result needs to be inquired from an agricultural cloud payment platform, and whether payment and checking are carried out one by one is checked; especially for branches with more people, the statistics workload is large, time and effort are consumed, and regular report completion before a time point is often required to be carried out by adding a team and a spot; under the traditional manual work mode, the working time of personnel is limited, when the workload of an enterprise is large, the normal working time of financial staff is difficult to meet the requirements of the enterprise, the processing efficiency can be greatly reduced, and the manual statistics and checking mode influence the accuracy of data and the analysis effect on the payment condition of the cost; in addition, a large amount of data requires high-intensity work by staff, which is not beneficial to further improving the work management level; the RPA robot is a program based on machine processing, can work continuously and efficiently, can make up for the defects of low tolerance of manual operation and poor peak processing capacity, and is suitable for 7x24 hours business of enterprises.

The prior art discloses a data intelligent checking method, a device, equipment and a storage medium, which comprises the following steps: executing a preset event operation script, and downloading a first data file and a second data file to be checked; reading the first data file and the second data file row by row, and analyzing the data in the first data file and the second data file into the same data check file according to a preset file format, wherein the data check file comprises a table, and the table comprises a service field and a corresponding value; according to the preset service field, the value of the preset service field is called from the data checking file to be checked, and the checking result is written into the data checking file; the method in the prior art is mainly used for checking and processing a certain limited number of data, and still needs manual auxiliary processing for a large number of data in work, which is time-consuming and labor-consuming, not only is the data accuracy low, but also the working efficiency is low.

Disclosure of Invention

The invention provides a data checking method and a system based on an RPA robot, which can remarkably improve the working efficiency and ensure the data quality in order to overcome the defects of low accuracy and low efficiency in the data checking in the prior art.

In order to solve the technical problems, the technical scheme of the invention is as follows:

a data checking method based on an RPA robot comprises the following steps:

s1: initializing an RPA robot;

s2: the RPA robot determines the query range of the data according to the preset query condition;

s3: the RPA robot opens each piece of data in the query range in turn according to the query range, and checks all the data according to preset check conditions to obtain a data check result;

s4: the RPA robot reorders the data which accords with the checking condition according to the data checking result, records the data which does not accord with the checking condition, and acquires the checked checking result;

s5: and the RPA robot fills the checked checking result into a preset checking form.

Preferably, in the step S1, the specific process of initializing the RPA robot is:

setting operation parameters of the RPA robot, wherein the operation parameters comprise a branch name and a fee payment time, and the RPA robot with the set operation parameters logs in a preset cloud payment platform according to a preset account number and a preset password to finish initialization of the RPA robot;

preferably, the RPA robot with the set operation parameters logs in a preset cloud payment platform according to a preset account number and a preset password, and the process is realized by utilizing an OCR technology.

Preferably, the data is in particular payment result bill data.

Preferably, the payment result bill data is a PDF format file.

Preferably, in the step S2, the specific method for determining the query range of the data according to the preset query condition is as follows:

the preset query conditions are operation parameters of the RPA robot, the set branch name is used as a query target, and the set fee payment time is used as a query start-stop time period;

and taking the query target and the query start-stop time period as the query range of the data.

Preferably, in step S3, the RPA robot opens each piece of data in the query range in turn according to the query range, and the process is implemented by using a web page data batch chain obtaining method.

Preferably, after the step S5, the method further includes uploading the check form filled with the data check result to the cloud payment platform by the RPA robot.

Preferably, after the step S5, the RPA robot further invokes a preset Excel template, fills the data verification result into the Excel template, and prints out the data verification result to obtain a data verification total report.

The invention also provides a data checking system based on the RPA robot, which applies the data checking method based on the RPA robot and comprises the following steps:

an initializing unit: for initializing the RPA robot;

query range determination unit: the method comprises the steps that the RPA robot is used for determining the query range of data according to preset query conditions;

a data collation unit: the RPA robot is used for opening each piece of data in the query range in sequence according to the query range, and checking all the data according to preset checking conditions to obtain a data checking result;

a data checking unit: the RPA robot is used for reordering the data which meet the checking conditions according to the data checking result, recording the data which do not meet the checking conditions and obtaining the checked checking result;

and a verification result filling unit: and the RPA robot is used for filling the checked check result into a preset check form.

Compared with the prior art, the technical scheme of the invention has the beneficial effects that:

the invention provides a data checking method and a system based on an RPA robot, wherein the method comprises the steps of initializing the RPA robot firstly, and then determining the query range of data according to preset query conditions by the RPA robot; the RPA robot opens each piece of data in the query range in turn according to the query range, and checks all the data according to preset check conditions to obtain a data check result; then the RPA robot reorders the data which accords with the checking condition according to the data checking result, records the data which does not accord with the checking condition, and acquires the checked checking result; finally, the RPA robot fills the checked checking result into a preset checking form;

the invention can greatly reduce the time for manually carrying out operations such as data inquiry, classification statistics, data processing, result obtaining and the like, improve the accuracy of data checking, remarkably improve the working efficiency and ensure the data quality; the application of the method can effectively reduce a great deal of repeated and complicated transactional work of data statistics, sequencing and filling of data checking staff, and improves the enterprise management level.

Drawings

Fig. 1 is a flowchart of a data checking method based on an RPA robot according to embodiment 1.

Fig. 2 is a graph of the data collation results provided in embodiment 2.

Fig. 3 is a diagram showing a non-reconciled status personnel statistics reminder provided in example 2.

Fig. 4 is a specific list of outstanding personnel provided in example 2.

Fig. 5 is a diagram of the reordering result provided in embodiment 2.

Fig. 6 is a diagram of a data collation total report in Excel format provided in example 2.

Fig. 7 is a diagram of a data collation system based on RPA robot according to embodiment 3.

Detailed Description

The drawings are for illustrative purposes only and are not to be construed as limiting the present patent;

for the purpose of better illustrating the embodiments, certain elements of the drawings may be omitted, enlarged or reduced and do not represent the actual product dimensions;

it will be appreciated by those skilled in the art that certain well-known structures in the drawings and descriptions thereof may be omitted.

The technical scheme of the invention is further described below with reference to the accompanying drawings and examples.

Example 1

As shown in fig. 1, the present embodiment provides a data checking method based on an RPA robot, including the following steps:

s1: initializing an RPA robot;

In the specific implementation process, firstly initializing an RPA robot, and then determining the query range of data by the RPA robot according to preset query conditions; the RPA robot opens each piece of data in the query range in turn according to the query range, and checks all the data according to preset check conditions to obtain a data check result; then the RPA robot reorders the data which accords with the checking condition according to the data checking result, records the data which does not accord with the checking condition, and acquires the checked checking result; finally, the RPA robot fills the checked checking result into a preset checking form;

Example 2

The embodiment provides a data checking method based on an RPA robot, which comprises the following steps:

s1: the method for initializing the RPA robot comprises the following steps:

setting operation parameters of the RPA robot, wherein the operation parameters comprise a branch name and a fee payment time, and the RPA robot with the set operation parameters automatically logs in a preset cloud payment platform by utilizing an OCR technology according to a preset account number and a password to finish the initialization of the RPA robot;

s2: the RPA robot determines the query range of the data according to the preset query condition, and the specific method comprises the following steps:

taking the query target and the query start-stop time period as a query range of data;

s3: the RPA robot uses a webpage data batch chain acquisition method according to the query range, sequentially opens each piece of data in the query range, and checks all the data according to preset check conditions to obtain a data check result;

s5: the RPA robot fills the checked checking result into a preset checking form;

the RPA robot uploads the check form filled with the data check result to the cloud payment platform;

the RPA robot calls a preset Excel template, fills the data checking result into the Excel template and prints out the data checking result to obtain a data checking total report;

the data are specifically bill data of payment results;

the bill data of the payment result is a PDF format file;

in the specific implementation process, firstly, initializing an RPA robot, setting operation parameters of the RPA robot, wherein the operation parameters comprise a branch name and a fee payment time, in the embodiment, setting the branch name as an 'information center party branch', setting the fee payment time as '202208', and indicating that the time required to be checked is 2022, namely 8 months; the RPA robot with the set operation parameters automatically recognizes and fills in the identification code by utilizing the OCR technology according to the preset account number and password, and automatically logs in a preset cloud payment platform to finish the initialization of the RPA robot;

then the RPA robot determines the query range of the data according to the preset query condition, and stores the determined data query range into a two-dimensional array;

the RPA robot opens each piece of data in the query range in turn according to the query range, checks all the data according to a preset check condition, and automatically opens a PDF format file to search whether the content of the PDF format file meets the preset check condition, and in the embodiment, the check condition is whether checking is finished; after all the data queries are completed, a preliminary checking result is obtained, and as shown in fig. 2, the checking result is shown in fig. 2: all people 4 in 2022 and 8 are in a manual checked-out state, which indicates that the RPA robot can correctly check data;

the RPA robot reorders the data which accords with the checking condition according to the data checking result, records the data which does not accord with the checking condition, and acquires the checked checking result;

if the RPA robot has the state of not being checked out, the RPA robot records the data quantity, and a popup window is displayed, as shown in FIG. 3, when the RPA robot checks the data with the state of not being checked out, the RPA robot automatically pops up the window to prompt, and the number of people not checked out is 2;

then the RPA robot automatically creates a text document record and stores a list of people who are not checked out, as shown in FIG. 4, and as can be seen from FIG. 4, the RPA robot can automatically generate a text document and display 2 people list information which is not checked out;

for the data in the "checked-out" state, the RPA robot automatically reorders all the data in the "checked-out" state in ascending order, as shown in fig. 5, and obtains the checked-out result, as can be seen from fig. 5, the RPA robot can automatically renumber all the data in the "checked-out" state and reorder in ascending order;

the RPA robot fills the checked checking result into a preset checking form and uploads the checking result to the cloud payment platform;

finally, the RPA robot calls a preset Excel template, fills the checked data checking result into the Excel template and prints out the data checking result to obtain a data checking total report, as shown in fig. 6, as can be seen from fig. 6, the RPA robot can automatically fill the checked data checking result into the Excel template and automatically send a printing request to a printer to print out the data checking total report;

the method in the embodiment can ensure that the log-in, query, download, copy, sort, statistics and completion of report form filling and storage and printing work of manual processing are reduced from original 1 hour to 5 minutes, the data accuracy rate can reach 100 percent, and the working efficiency is obviously improved;

Example 3

As shown in fig. 7, the present embodiment provides a data collation system based on an RPA robot, and the data collation method based on an RPA robot in

application embodiment

1 or 2, comprising:

the initialization unit 301: for initializing the RPA robot;

query range determination unit 302: the method comprises the steps that the RPA robot is used for determining the query range of data according to preset query conditions;

the data collation unit 303: the RPA robot is used for opening each piece of data in the query range in sequence according to the query range, and checking all the data according to preset checking conditions to obtain a data checking result;

the data checking unit 304: the RPA robot is used for reordering the data which meet the checking conditions according to the data checking result, recording the data which do not meet the checking conditions and obtaining the checked checking result;

the collation result reporting unit 305: and the RPA robot is used for filling the checked check result into a preset check form.

In a specific implementation process, the initialization unit 301 initializes the RPA robot first, and then the query range determining unit 302 causes the RPA robot to determine a query range of data according to a preset query condition; then the RPA robot opens each piece of data in the query range in turn according to the query range in the data checking unit 303, and checks all the pieces of data according to preset check conditions to obtain a data check result; then the data checking unit 304 makes the RPA robot reorder the data conforming to the checking condition according to the data checking result, and records the data not conforming to the checking condition, and acquires the checked checking result; finally, the check result filling unit 305 causes the RPA robot to fill the checked check result into a preset check form;

the invention can greatly reduce the time for manually carrying out operations such as data inquiry, classification statistics, data processing, result obtaining and the like, improve the accuracy of data checking, remarkably improve the working efficiency and ensure the data quality; the application of the method can effectively reduce a great deal of repeated and complicated transactional work of data statistics, sequencing and filling of data checking workers, and improves the enterprise management level.

The same or similar reference numerals correspond to the same or similar components;

the terms describing the positional relationship in the drawings are merely illustrative, and are not to be construed as limiting the present patent;

it is to be understood that the above examples of the present invention are provided by way of illustration only and not by way of limitation of the embodiments of the present invention. Other variations or modifications of the above teachings will be apparent to those of ordinary skill in the art. It is not necessary here nor is it exhaustive of all embodiments. Any modification, equivalent replacement, improvement, etc. which come within the spirit and principles of the invention are desired to be protected by the following claims.

Claims

1. The data checking method based on the RPA robot is characterized by comprising the following steps of:

s1: initializing an RPA robot;

2. The RPA robot-based data verification method according to claim 1, wherein in the step S1, the specific process of initializing the RPA robot is as follows:

setting operation parameters of the RPA robot, wherein the operation parameters comprise a branch name and a fee payment time, and the RPA robot with the set operation parameters logs in a preset cloud payment platform according to a preset account number and a preset password to finish initialization of the RPA robot.

3. The data checking method based on the RPA robot according to claim 2, wherein the RPA robot with the set operation parameters logs in a preset cloud payment platform according to a preset account number and a preset password, and the process is implemented by using an OCR technology.

4. The RPA robot-based data verification method according to claim 1, wherein the data is in particular payment result bill data.

5. The RPA robot-based data verification method of claim 4, wherein the payment result bill data is a PDF format file.

6. The RPA robot-based data verification method according to claim 1, wherein in the step S2, the specific method for determining the query range of the data according to the preset query condition is as follows:

7. The RPA robot-based data verification method according to claim 1, wherein in the step S3, the RPA robot opens each piece of data in the query range in sequence according to the query range, and the process is implemented using a web page data batch chaining method.

8. The RPA robot-based data verification method according to claim 1, wherein after the step S5, the RPA robot uploads the verification form filled with the data verification result to the cloud payment platform.

9. The RPA robot-based data verification method according to claim 1, further comprising the step of the RPA robot calling a preset Excel template, filling the data verification result into the Excel template and printing out the data verification result to obtain a data verification total report after the step S5.

10. An RPA robot-based data collation system applying the RPA robot-based data collation method according to any one of claims 1 to 9, characterized by comprising:

an initializing unit: for initializing the RPA robot;