Automatic data reading and inputting method and system based on RPA technology

An automatic data reading technology, applied in special data processing applications, semi-structured data retrieval, semi-structured data mapping/conversion, etc., can solve problems such as difficult to distinguish process segments, high configuration difficulty, and complex configuration pages. Achieve the effects of increasing speed, reducing difficulty and workload, and improving work efficiency

Pending Publication Date: 2021-07-27
广州省事熊智能科技有限公司
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the process of configuring the above business process by RPA technicians, the comparison between a large number of process fragments makes it difficult for RPA technicians to distinguish, and the configuration page is too complicated, making configuration difficult
Moreover, for data processing robot programs, too many segments need to run a corresponding number of robot program segments to execute at the same time, making the speed of reading and entering data too slow

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic data reading and inputting method and system based on RPA technology
  • Automatic data reading and inputting method and system based on RPA technology
  • Automatic data reading and inputting method and system based on RPA technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0068] Such as figure 1 As shown, a method for automatically reading and entering data based on RPA technology. The method is to write an RPA robot program based on RPA technology to establish a data processing robot, and use the data processing robot to perform the following steps:

[0069] S1, locate the Excel file, determine the position of the Excel table to be processed; specifically include:

[0070] S11. Automatically open the folder storing Excel, and locate the Excel file through file name search;

[0071] S12. Identify whether the Excel file is consistent with the file name of the Excel table to be processed;

[0072] If the file names are consistent, the Excel file is the Excel table to be processed; otherwise, the search is continued until the searched Excel file is consistent with the file name of the Excel table to be processed.

[0073] S2. Automatically open the Excel table, and determine the position of the currently read row in the Excel table according to ...

Embodiment 2

[0095] Such as image 3 As shown, this embodiment proposes a system for automatically reading and entering data based on RPA technology, including:

[0096] Data processing robot builds module 1, is used for setting up data processing robot based on RPA technology, and utilizes the data processing process in the execution system of described data processing robot;

[0097] The Excel table position determination module 2 is used to locate the Excel file and determine the position of the Excel table to be processed;

[0098] The row position determination module 3 is used to automatically open the Excel sheet, and determine the position of the row currently read in the Excel sheet according to the data entry progress;

[0099] The row vector data set acquisition module 4 is used to read the Excel data in the row by a single whole row reading method to obtain a row vector data set;

[0100] The row vector data positioning and cleaning module 5 is used to locate the row vector d...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to an automatic data reading and inputting method and system based on an RPA technology. The method employs a data processing robot to execute the following steps: positioning an Excel file, and determining the position of a to-be-processed Excel table; automatically opening the Excel table, and determining the position of the currently read row in the Excel table according to the data entry progress; reading Excel data in the row by adopting a single whole row reading method to obtain a row vector data set; positioning row vector data in the row vector data set, and performing data cleaning processing on the row vector data; inputting the cleaned row vector data into a browser Form table line by line. The data processing robot is established based on the RPA technology. According to the method, in the process of inputting the data from the Excel table to the browser Form table, the data is read and input in a mode of reading one line of data at a time and inputting one line of data at a time, so that the reading and input speed is effectively improved, and the working efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of robotic process automation, in particular to a method and system for automatically reading and entering data based on RPA technology. Background technique [0002] Robotic Process Automation (RPA, Robotic Process Automation) technology is a business process automation technology based on software robots and artificial intelligence. By imitating manual operation of computers, it provides an automated operation mode that does not require human participation. [0003] In the existing application scenarios of RPA technology, many of the data recorded in the Excel table need to be filled into the forms of the computer browsers of various management systems, such as the reporting of medical data, the entry of employee information, the filling of financial invoice information, etc. Business needs. This requires employees to read the Excel data and manually fill in the form in the browser, which is not o...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06K9/00G06F16/84G06F40/18
CPCG06F16/84G06F40/18G06V30/412
Inventor 杨勇蒋勉蒋经华吴世枫
Owner 广州省事熊智能科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap