CN112765165A - Data entry method and device, equipment and computer readable storage medium - Google Patents
Data entry method and device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN112765165A CN112765165A CN202011643172.2A CN202011643172A CN112765165A CN 112765165 A CN112765165 A CN 112765165A CN 202011643172 A CN202011643172 A CN 202011643172A CN 112765165 A CN112765165 A CN 112765165A
- Authority
- CN
- China
- Prior art keywords
- input
- data
- entered
- entry
- page
- 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
- 238000000034 method Methods 0.000 title claims abstract description 63
- 238000013479 data entry Methods 0.000 title claims abstract description 62
- 238000012545 processing Methods 0.000 claims abstract description 49
- 238000005538 encapsulation Methods 0.000 claims abstract description 24
- 230000006870 function Effects 0.000 claims description 29
- 238000000605 extraction Methods 0.000 claims description 25
- 238000005516 engineering process Methods 0.000 claims description 18
- 238000004806 packaging method and process Methods 0.000 claims description 18
- 238000012015 optical character recognition Methods 0.000 claims description 8
- 238000004801 process automation Methods 0.000 claims description 6
- 238000012163 sequencing technique Methods 0.000 claims description 6
- 238000004891 communication Methods 0.000 description 11
- 230000008569 process Effects 0.000 description 10
- 238000011161 development Methods 0.000 description 4
- 230000002093 peripheral effect Effects 0.000 description 4
- 238000013473 artificial intelligence Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 239000000284 extract Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000011159 matrix material Substances 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
Abstract
The invention relates to the technical field of data processing, and discloses a data entry method, a data entry device, data entry equipment and a computer readable storage medium. According to the method, the input field and the input format of the extracted and stored area to be input in the page to be input are obtained, format encapsulation processing is carried out on the data to be input according to the input field and the input format, encapsulated data are obtained, and then if an input instruction is received, the encapsulated data are input into the area to be input corresponding to the page to be input; when the page to be entered needs to be recorded with the data to be entered, the entered field and the entered format of the extracted and stored area to be entered can be directly acquired, so that the entered field and the entered format of the area to be entered in the page to be entered do not need to be acquired independently at each time when the same page to be entered is not recorded with different data to be entered, the entered efficiency of the data is improved to the greatest extent, and the redundancy of the codes and the workload of related workers are reduced.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data entry method, a data entry device, data entry equipment, and a computer-readable storage medium.
Background
The Robot Process Automation (RPA) technology is a novel artificial intelligence virtual Process Automation robot, and through development of several years, RPA has been widely applied to various fields requiring Process Automation.
Although the RPA technology is applied to the shelving of product elements, at present, for the shelving of the product elements, a worker needs to firstly acquire the entry fields and the entry formats corresponding to the areas to be entered in the page, and configure the data to be entered according to the acquired areas to be entered in the plurality of entry fields and the entry formats, so that the data to be entered are entered into the areas to be entered in the corresponding entry fields and the entry formats, and the shelving of the product elements is realized.
Therefore, how to improve the data entry efficiency is an urgent problem to be solved.
Disclosure of Invention
The invention mainly aims to provide a data entry method, a data entry device, data entry equipment and a computer readable storage medium, and aims to improve the data entry efficiency.
In order to achieve the above object, the present invention provides a data entry method, including the steps of:
acquiring an input field and an input format of an extracted and stored area to be input in a page to be input;
according to the input field and the input format, format packaging processing is carried out on data to be input to obtain packaged data;
and if an entry instruction is received, entering the packaging data into a to-be-entered area corresponding to the to-be-entered page.
Optionally, the step of performing format encapsulation processing on the data to be entered according to the entry field and the entry format to obtain encapsulated data includes:
determining data to be entered meeting the entry field according to the entry field;
according to the input format, carrying out format processing on the data to be input which meets the input field; and packaging the data to be input after format processing to obtain packaged data.
Optionally, if an entry instruction is received, the step of entering the package data into the to-be-entered area corresponding to the to-be-entered page includes:
if an input instruction is received, acquiring a page identifier to be input carried in the input instruction;
determining a page to be input according to the page to be input identifier;
displaying the page to be input, and inputting the packaging data into the area to be input corresponding to the page to be input.
Optionally, before the step of obtaining the entry field and the entry format of the extracted and stored area to be entered in the page to be entered, the data entry method further includes:
acquiring a page to be input;
extracting the input fields and input formats of a plurality of areas to be input in the page to be input;
and storing the extracted entry fields and entry formats corresponding to the areas to be entered into a file.
Optionally, after the step of performing format encapsulation processing on the data to be entered according to the entry field and the entry format to obtain encapsulated data, the data entry method further includes:
acquiring a logic association relation between the data to be input;
according to the logic association relation among the data to be input, sorting the data to be input to obtain a sorting result;
if an entry instruction is received, the step of entering the encapsulation data into the area to be entered corresponding to the page to be entered comprises the following steps:
and if an input instruction is received, inputting the packaging data into a to-be-input area corresponding to the to-be-input page according to the sequencing result.
Optionally, before the step of performing format encapsulation processing on the data to be entered according to the entry field and the entry format to obtain encapsulated data, the data entry method further includes:
downloading a product element table through a robot process automation technology, and uploading the product element table to an element extraction function interface;
and extracting the data to be recorded from the product element table by using an optical character recognition technology through the element extraction function interface.
Optionally, the step of downloading the product element list by a robot process automation technology and uploading the product element list to the element extraction function interface includes:
reading a product element email through an email reading function of a preset UiPadh application, and downloading an unread product element email attachment to a specified file path, wherein the product element email attachment comprises a product element table;
and uploading the product element table to an element extraction function interface through the uploading control function of the preset UiPadh application.
In addition, to achieve the above object, the present invention further provides a data entry device, including:
the acquisition module is used for acquiring the input field and the input format of the extracted and stored area to be input in the page to be input;
the processing module is used for carrying out format packaging processing on the data to be input according to the input field and the input format to obtain packaged data;
and the entry module is used for entering the packaging data into the area to be entered corresponding to the page to be entered if an entry instruction is received.
Further, to achieve the above object, the present invention also provides an apparatus comprising: a memory, a processor and a data entry program stored on the memory and running on the processor, which when executed by the processor implements the steps of a data entry method as above.
Furthermore, to achieve the above object, the present invention also provides a computer readable storage medium having stored thereon a data entry program, which when executed by a processor, implements the steps of the data entry method as above.
According to the technical scheme provided by the invention, the input field and the input format of the extracted and stored area to be input in the page to be input are obtained, format encapsulation processing is carried out on the data to be input according to the input field and the input format, encapsulated data is obtained, and then the encapsulated data is input into the area to be input corresponding to the page to be input if an input instruction is received; the problem of data entry inefficiency among the correlation technique is solved.
The technical scheme provided by the invention extracts and stores the input field and the input format of the area to be input in the page to be input in advance, so that when the page to be input needs to input the data to be input, the extracted and stored input field and input format of the area to be input are directly obtained, and the input field and input format of the area to be input in the page to be input are not required to be separately obtained each time when the same page to be input and different data to be input are input, thereby improving the input efficiency of the data to a great extent, and reducing the redundancy of the codes and the workload of related workers.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the structures shown in the drawings without creative efforts.
FIG. 1 is a schematic diagram of an apparatus architecture of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a first embodiment of the data entry method of the present invention;
FIG. 3 is a schematic flow chart of a data entry method according to a second embodiment of the present invention;
FIG. 4 is a schematic flow chart of a data entry method according to a third embodiment of the present invention;
FIG. 5 is a block diagram of a first embodiment of the data entry device of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is a schematic device structure diagram of a hardware operating environment according to an embodiment of the present invention.
The apparatus comprises: at least one processor 101, a memory 102, and a data entry program stored on the memory and executable on the processor, the data entry program configured to implement the steps of the data entry method of any of the following embodiments.
In some embodiments, the apparatus may further include: a communication interface 103 and at least one peripheral device. The processor 101, memory 102 and communication interface 103 may be connected by a bus or signal lines. Various peripheral devices may be connected to communication interface 103 via a bus, signal line, or circuit board. Specifically, the peripheral device includes: at least one of radio frequency circuitry 104, display screen 105, and power supply 106.
The communication interface 103 can be used to connect at least one peripheral device related to I/O (Input/Output) to the processor 101 and the memory 102. In some embodiments, the processor 101, memory 102, and communication interface 103 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 101, the memory 102 and the communication interface 103 may be implemented on a single chip or circuit board, which is not limited in this embodiment.
The Radio Frequency circuit 104 is used for receiving and transmitting RF (Radio Frequency) signals, also called electromagnetic signals. The radio frequency circuitry 104 communicates with communication networks and other communication devices via electromagnetic signals. The rf circuit 104 converts an electrical signal into an electromagnetic signal for transmission, or converts a received electromagnetic signal into an electrical signal. Optionally, the radio frequency circuit 104 comprises: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a subscriber identity module card, and so forth. The radio frequency circuitry 104 may communicate with other terminals via at least one wireless communication protocol. The wireless communication protocols include, but are not limited to: metropolitan area networks, various generation mobile communication networks (2G, 3G, 4G, and 5G), Wireless local area networks, and/or WiFi (Wireless Fidelity) networks. In some embodiments, the rf circuit 104 may further include NFC (Near Field Communication) related circuits, which are not limited in this application.
The display screen 105 is used to display a UI (User Interface). The UI may include graphics, text, icons, video, and any combination thereof. When the display screen 105 is a touch display screen, the display screen 105 also has the ability to capture touch signals on or over the surface of the display screen 105. The touch signal may be input to the processor 101 as a control signal for processing. At this point, the display screen 105 may also be used to provide virtual buttons and/or a virtual keyboard, also referred to as soft buttons and/or a soft keyboard. In some embodiments, the display screen 105 may be one, the front panel of the device; in other embodiments, the display screens 105 may be at least two, respectively disposed on different surfaces of the device or in a folded design; in some embodiments, the display 105 may be a flexible display, disposed on a curved surface or on a folded surface of the device. Even further, the display screen 105 may be arranged in a non-rectangular irregular pattern, i.e. a shaped screen. The Display screen 105 may be made of LCD (liquid crystal Display), OLED (Organic Light-Emitting Diode), and the like.
The power supply 106 is used to power the various components in the device. The power source 106 may be alternating current, direct current, disposable batteries, or rechargeable batteries. When the power source 106 includes a rechargeable battery, the rechargeable battery may support wired or wireless charging. The rechargeable battery may also be used to support fast charge technology.
Those skilled in the art will appreciate that the configuration shown in fig. 1 does not constitute a limitation of the device and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
Based on the above hardware structure, embodiments of the present invention are proposed.
Referring to fig. 2, fig. 2 is a schematic flow chart of a data entry method according to a first embodiment of the present invention, where the data entry method includes the following steps:
step S10: and acquiring the input field and the input format of the extracted and stored area to be input in the page to be input.
It should be clear that the application scenario of this embodiment may occur in the process of automatically putting product elements on shelf, where the product elements refer to data to be entered that needs to be entered into a page to be entered, that is, the automatically putting product elements on shelf refers to entering the data to be entered into a region to be entered of the page to be entered, so as to implement putting or updating data of the page to be entered on shelf.
The page to be entered in the embodiment refers to a page to be entered with data, wherein one page to be entered may be provided, or a plurality of pages to be entered may be provided; in practical application, the method can be flexibly adjusted according to specific application scenes.
The area to be entered in the embodiment refers to an area in the page to be entered, where data entry is required; for example, the area to be entered is an area where time data needs to be entered, the area to be entered is an area where digital data needs to be entered, and the area to be entered is an area where text data needs to be entered.
The input fields in the embodiment refer to different input fields for different areas to be input; for example, the input field corresponds to a time control, the input field corresponds to an age control, the input field corresponds to a region drop-down box control, and the like.
The input format in the embodiment refers to that different input formats are respectively provided for different input fields; for example, the time control and the age control have different entry formats, the region drop-down box and the academic drop-down box have different entry formats, and the textarea textbox and the ordinary textbox have different entry formats.
It can be understood that, in this embodiment, acquiring the entry field and the entry format of the extracted and stored area to be entered in the page to be entered means that the entry field and the entry format of the area to be entered in the page to be entered are extracted and stored in advance, and are directly acquired; therefore, in this embodiment, before the step S10 acquires the entry field and the entry format of the extracted and stored area to be entered in the page to be entered, the data entry method may further include the following steps:
firstly, acquiring a page to be input;
then, extracting the input fields and the input formats of a plurality of areas to be input in the page to be input;
and then, storing the extracted entry fields and entry formats corresponding to the areas to be entered into a file.
That is, in this embodiment, obtain the page to be entered in advance, and extract and save the type-in field and the type-in format of a plurality of regions to be entered in the page to be entered, when the page to be entered needs to be carried out the type-in of the data to be entered, directly obtain the type-in field and the type-in format of a plurality of regions to be entered that have been extracted and saved, when the different data to be entered of the same page to be entered is not needed again, all need go to obtain the type-in field and the type-in format of the region to be entered in the page to be entered separately at every turn, the type-in efficiency of the data has been promoted to a great extent.
For better understanding, please refer to table one here, which is an example of each extracted and stored area to be entered in the page to be entered, and the entry field and the entry format corresponding to each area to be entered:
watch 1
| Area to be recorded | Entry field | Entry format |
| Area to be entered 1 | Entry field A | Entry Format a |
| Area to be entered 2 | Entry field B | Entry format b |
| Area to be entered 3 | Entry field C | Entry format c |
| …… | …… | …… |
In some examples, when the front-end page to be entered is designed, the entry field and the entry format of the area to be entered in the designed page to be entered are extracted and stored, so that the entry field and the entry format of the area to be entered in the page to be entered are extracted and stored at the first time, and then when the product elements need to be put on shelf, the entry field and the entry format of the area to be entered which are extracted and stored in the page to be entered can be directly acquired.
In some examples, the entry field and the entry format of the area to be entered in the page to be entered may be extracted for storage when the product element needs to be shelved, where shelving referred to herein generally means that the page to be entered has the product element to be shelved for the first time, and certainly may also be that the product element needs to be shelved again for the second time, the third time, and so on; in practical application, the method can be flexibly adjusted according to specific application scenes.
It should be clear that, in this embodiment, the extraction of the entry field and the entry format of the area to be entered in the page to be entered may be implemented by a function of a control for extracting the page to be entered of the UiPath, where the UiPath is one of popular software in the RPA technology, and may also be implemented by a function of a control for extracting the page to be entered of software such as Automation and company, blue prism, or a function of a control for extracting the page to be entered by self-definition; in practical application, the method can be flexibly adjusted according to specific application scenes.
Step S20: and according to the input field and the input format, carrying out format packaging processing on the data to be input to obtain packaged data.
It can be understood that, in this embodiment, after the entry field and the entry format of the extracted and stored area to be entered in the page to be entered are obtained through step S10, format encapsulation processing may be performed on the data to be entered according to the obtained entry field and entry format, so as to obtain encapsulated data.
In this embodiment, the step S20, according to the entry field and the entry format, performing format encapsulation processing on the data to be entered, and obtaining encapsulated data may include the following steps:
firstly, determining data to be entered meeting the entry field according to the entry field;
then, according to the input format, carrying out format processing on the data to be input which meets the input field;
and then, packaging the data to be input after format processing to obtain packaged data.
That is, in this embodiment, the data to be entered meeting the entry field is first determined according to the entry field, then format processing is performed on the data to be entered meeting the entry field according to the entry format, and then the data to be entered after format processing is encapsulated to obtain encapsulated data, so that it is only necessary to subsequently obtain the encapsulated data and enter the encapsulated data into the area to be entered corresponding to the page to be entered.
Specifically, in this embodiment, the element extraction system performs format encapsulation processing on the data to be entered according to the obtained entry field and entry format by querying the product element interface, so as to obtain encapsulated data; therefore, the process of the UiPadh does not need to be changed, the customized development work of the UiPadh is greatly reduced, when a page to be input needs to be newly added or deleted or change a region to be input, only the corresponding extraction rule needs to be newly added or deleted or changed when the element is extracted, and then format encapsulation processing is carried out on data to be input according to newly added or deleted or changed input fields and input formats of the region to be input of the page to be input, so that the method is more flexible and efficient, the whole process is simple and convenient, and the expansibility and the practicability are higher.
For better understanding, please refer to table two, which is an example of format encapsulation processing on data to be entered according to an entry field and an entry format in table one, and obtaining encapsulated data:
watch two
Step S30: and if the input instruction is received, inputting the packaged data into the area to be input corresponding to the page to be input.
It can be understood that, in this embodiment, after the format encapsulation processing is performed on the data to be entered according to the entry field and the entry format in step S20 to obtain the encapsulated data, if an entry instruction is received, the encapsulated data is entered into the area to be entered corresponding to the page to be entered.
In this embodiment, if the step S30 receives the entry instruction, the step S may include the following steps of entering the package data into the to-be-entered area corresponding to the to-be-entered page:
firstly, if an input instruction is received, acquiring a page identifier to be input carried in the input instruction;
then, determining a page to be input according to the page identifier to be input;
and then displaying the page to be input, and inputting the packaging data into the area to be input corresponding to the page to be input.
That is, in this embodiment, when an entry instruction is received, first, the page identifier to be entered is obtained from the received entry instruction, then, the page to be entered is determined according to the page identifier to be entered, and then, the page to be entered is displayed, and the package data is entered into the area to be entered corresponding to the page to be entered, so that automatic shelving of product elements is realized in the true sense. The input instruction received in this embodiment may be issued in any manner, for example, by voice, or by touch, and specifically, the touch may include key clicking, sliding, and the like.
Specifically, in the embodiment, when an entry instruction is received, the RPA is started, and the UiPath is in butt joint with the element extraction system through the product element query interface, so that the queried encapsulation data is entered into the area to be entered corresponding to the page to be entered, and the automatic shelving of the product elements is realized; the data to be entered can be entered by determining the identification number of the area to be entered and the data to be entered corresponding to the identification number of the area to be entered, so that the accuracy of data entry is ensured, and the occurrence of data entry errors is avoided.
For better understanding, please refer to table three, which is an example of entering the package data obtained in table two into the area to be entered corresponding to the page to be entered:
watch III
In the embodiment, the input field and the input format of the to-be-input area of the to-be-input page are extracted and stored in advance on one side of the RPA, so that the extracted and stored input field and input format of the to-be-input area in the to-be-input page can be directly acquired when the to-be-input page is put on shelf every time, the input field and the input format of the to-be-input area in the to-be-input page are not required to be acquired separately every time, the input efficiency of data is improved, and the redundancy of codes and the workload of related workers are greatly reduced. In addition, in the embodiment, format encapsulation processing is performed on the to-be-entered data on one side of the element extraction system according to the entry field and the entry format to obtain encapsulated data, the process of the UiPath is not required to be changed, the customized development work of the UiPath is greatly reduced, the whole process is simple and convenient, and the expansibility and the practicability are higher.
Based on the first embodiment, a second embodiment of the data entry method of the present invention is presented.
Referring to fig. 3, in this embodiment, after the step S20 performs format encapsulation processing on the data to be entered according to the entry field and the entry format, and obtains encapsulated data, the data entry method may further include the following steps:
step S21: acquiring a logic association relation between data to be input;
step S22: according to the logic association relation among the data to be input, sorting the data to be input to obtain a sorting result;
correspondingly, if the step S30 receives the entry instruction, the method includes the steps of entering the package data into the to-be-entered area corresponding to the to-be-entered page, including:
and if the input instruction is received, inputting the packaging data into the area to be input corresponding to the page to be input according to the sequencing result.
It should be clear that there may be a logical association relationship between different data to be entered, for example, data to be entered needs to be entered first, another data to be entered needs to be entered later, or two data to be entered need to be entered simultaneously; therefore, in this embodiment, in step S20, format encapsulation processing is performed on the data to be entered according to the entry field and the entry format, after encapsulated data is obtained, a logical association relationship between the data to be entered may be obtained first, and according to the logical association relationship between the data to be entered, the data to be entered is sorted to obtain a sorting result, and then according to the sorting result, the encapsulated data is entered into the area to be entered corresponding to the page to be entered; therefore, the data to be input can be accurately input into the area to be input corresponding to the page to be input, and the error phenomenon of data to be input caused by directly inputting the logical association relationship of the data to be input neglected due to the logical association relationship of the data to be input is avoided.
For a better understanding, a specific example is described herein; for example, if the data 1 to be entered is a drop-down box, a certain value is selected, the data 2 to be entered can be entered with a certain value, and at this time, the data 1 to be entered and the data 2 to be entered have a logical association relationship; therefore, when the data 1 to be entered and the data 2 to be entered are entered into corresponding areas to be entered, the logical association relationship between the data 1 to be entered and the data 2 to be entered needs to be known first, and the data to be entered is sequenced to obtain a sequencing result, that is, the data 1 to be entered is entered before and the data 2 to be entered is entered afterwards, so that the accurate entry of the data 1 to be entered and the data 2 to be entered can be ensured; the logical association relationship between the data 1 to be entered and the data 2 to be entered can be preset in the rule engine corresponding to the element extraction system, so that the speed of obtaining the logical association relationship between the data to be entered can be improved, and the data entry efficiency is further improved.
In the embodiment, format encapsulation processing is performed on the data to be input according to the input field and the input format, then the logical association relationship between the data to be input is obtained, the data to be input is sequenced according to the logical association relationship between the data to be input to obtain the sequencing result, and then the encapsulated data is input into the area to be input corresponding to the page to be input according to the sequencing result, so that the input accuracy of the data is improved to the greatest extent.
Based on the above embodiments, a third embodiment of the data entry method of the present invention is provided.
Referring to fig. 4, in this embodiment, before the step S20 performs format encapsulation processing on the data to be entered according to the entry field and the entry format to obtain encapsulated data, the data entry method may further include the following steps:
step S11: downloading a product element table through the RPA, and uploading the product element table to an element extraction function interface;
step S12: and extracting the data to be recorded from the product element table by using an optical character recognition technology through an element extraction functional interface.
In this embodiment, the step S11 downloads the product element table through the RPA, and uploads the product element table to the element extraction function interface, including:
firstly, reading a product element mail through a mail reading function of a preset UiPadh application, and downloading an unread product element mail attachment to a specified file path, wherein the product element mail attachment comprises a product element table;
and then, uploading the product element table to an element extraction function interface through an uploading control function of a preset UiPadh application.
Specifically, in the present embodiment, the downloading of the product element table may be reading a product element email through an email reading function of the UiPath, and automatically downloading an unread product element email attachment to a predefined file path, where the product element email attachment includes the product element table; and uploading the extracted product element table to an element extraction function interface through the webapi control function of the UiPath, and extracting data to be recorded from the product element table by the element extraction function interface by using an optical character recognition technology, wherein the element extraction function interface is an http interface provided by java application.
Specifically, the data to be entered in the present embodiment may be extracted by an element extraction system through an Optical Character Recognition (OCR) technology, where the OCR technology refers to a process in which an electronic device (such as a scanner or a digital camera) inspects characters printed on paper, determines the shape thereof by detecting dark and light patterns, and then translates the shape into computer text by a Character Recognition method; the method is a technology for converting characters in a paper document into an image file with a black-white dot matrix in an optical mode aiming at print characters, and converting the characters in the image into a text format through recognition software for further editing and processing by word processing software.
In the embodiment, the product element table is downloaded through the RPA, the product element table is uploaded to the element extraction function interface, the to-be-recorded data is extracted from the product element table through the element extraction function interface by using the optical character recognition technology, so that the to-be-recorded data is extracted, the whole process is simple and convenient, and the extracted to-be-recorded data is higher in efficiency and accuracy.
In addition, referring to fig. 5, an embodiment of the present invention further provides a data entry device based on the data entry method, where the data entry device includes:
the acquiring module 500 is used for acquiring the input field and the input format of the extracted and stored area to be input in the page to be input;
the processing module 501 is configured to perform format encapsulation processing on the data to be entered according to the entry field and the entry format to obtain encapsulated data;
the entry module 502 is configured to, if an entry instruction is received, enter the package data into the area to be entered corresponding to the page to be entered.
In the embodiment, the data entry device can directly acquire the entry field and the entry format of the extracted and stored area to be entered in the page to be entered by pre-extracting and storing the entry field and the entry format of the area to be entered of the page to be entered on one side of the RPA, when the product elements are on shelf in the page to be entered at each time, the entry field and the entry format of the area to be entered in the page to be entered which are extracted and stored in the page to be entered are not required to be acquired separately at each time, the entry efficiency of data is improved, and the redundancy of codes and the workload of related workers are greatly reduced. In addition, in the embodiment, format encapsulation processing is performed on the to-be-entered data on one side of the element extraction system according to the entry field and the entry format to obtain encapsulated data, the process of the UiPath is not required to be changed, the customized development work of the UiPath is greatly reduced, the whole process is simple and convenient, and the expansibility and the practicability are higher.
It should be noted that, in this embodiment, the data entry apparatus further optionally includes other corresponding modules, so as to implement the steps of the data entry method.
The data entry device of the present invention adopts all the technical solutions of all the embodiments described above, so that at least all the beneficial effects brought by the technical solutions of the embodiments described above are achieved, and details are not repeated herein.
In addition, an embodiment of the present invention further provides a computer-readable storage medium, where a data entry program is stored on the computer-readable storage medium, and when being executed by a processor, the data entry program implements the steps of the data entry method.
The computer-readable storage media include volatile or nonvolatile, removable or non-removable media implemented in any method or technology for storage of information such as computer-readable instructions, data structures, computer program modules or other data. Computer-readable storage media include, but are not limited to, RAM (Random Access Memory), ROM (Read-Only Memory), EEPROM (Electrically erasable Programmable Read-Only Memory), flash Memory or other Memory technology, CD-ROM (Compact disk Read-Only Memory), Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage, or any other medium which can be used to store the desired information and which can be accessed by a computer.
It will be apparent to one skilled in the art that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the physical components may be implemented as software executed by a processor, such as a central processing unit, digital signal processor, or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A data entry method, characterized in that it comprises the steps of:
acquiring an input field and an input format of an extracted and stored area to be input in a page to be input;
according to the input field and the input format, format packaging processing is carried out on data to be input to obtain packaged data;
and if an entry instruction is received, entering the packaging data into a to-be-entered area corresponding to the to-be-entered page.
2. The data entry method according to claim 1, wherein the step of performing format encapsulation processing on the data to be entered according to the entry field and the entry format to obtain encapsulated data comprises:
determining data to be entered meeting the entry field according to the entry field;
according to the input format, carrying out format processing on the data to be input which meets the input field;
and packaging the data to be input after format processing to obtain packaged data.
3. The data entry method according to claim 1, wherein the step of entering the packaged data into the to-be-entered area corresponding to the to-be-entered page if an entry instruction is received comprises:
if an input instruction is received, acquiring a page identifier to be input carried in the input instruction;
determining a page to be input according to the page to be input identifier;
displaying the page to be input, and inputting the packaging data into the area to be input corresponding to the page to be input.
4. A data entry method according to any one of claims 1 to 3, wherein, before the step of obtaining the entry field and the entry format of the extracted and saved area to be entered in the page to be entered, the data entry method further comprises:
acquiring a page to be input;
extracting the input fields and input formats of a plurality of areas to be input in the page to be input;
and storing the extracted entry fields and entry formats corresponding to the areas to be entered into a file.
5. A data entry method according to any one of claims 1 to 3, wherein, after said step of performing format encapsulation processing on the data to be entered according to said entry field and entry format to obtain encapsulated data, said data entry method further comprises:
acquiring a logic association relation between the data to be input;
according to the logic association relation among the data to be input, sorting the data to be input to obtain a sorting result;
if an entry instruction is received, the step of entering the encapsulation data into the area to be entered corresponding to the page to be entered comprises the following steps:
and if an input instruction is received, inputting the packaging data into a to-be-input area corresponding to the to-be-input page according to the sequencing result.
6. A data entry method as claimed in any one of claims 1 to 3, wherein, prior to the step of performing format encapsulation processing on the data to be entered according to the entry field and the entry format to obtain encapsulated data, the data entry method further comprises:
downloading a product element table through a robot process automation technology, and uploading the product element table to an element extraction function interface;
and extracting the data to be recorded from the product element table by using an optical character recognition technology through the element extraction function interface.
7. A data entry method as claimed in claim 6 wherein said step of downloading a product element list by robotic process automation techniques and uploading said product element list to an element extraction function interface comprises:
reading a product element email through an email reading function of a preset UiPadh application, and downloading an unread product element email to a specified file path, wherein the attachment of the product element email comprises a product element table;
and uploading the product element table to an element extraction function interface through the uploading control function of the preset UiPadh application.
8. A data entry device, said data entry device comprising:
the acquisition module is used for acquiring the input field and the input format of the extracted and stored area to be input in the page to be input;
the processing module is used for carrying out format packaging processing on the data to be input according to the input field and the input format to obtain packaged data;
and the entry module is used for entering the packaging data into the area to be entered corresponding to the page to be entered if an entry instruction is received.
9. An apparatus, characterized in that the apparatus comprises: memory, a processor and a data entry program stored on the memory and running on the processor, which when executed by the processor implements the steps of the data entry method of any one of claims 1-7.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a data entry program which, when executed by a processor, implements the steps of the data entry method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011643172.2A CN112765165A (en) | 2020-12-30 | 2020-12-30 | Data entry method and device, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011643172.2A CN112765165A (en) | 2020-12-30 | 2020-12-30 | Data entry method and device, equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112765165A true CN112765165A (en) | 2021-05-07 |
Family
ID=75698722
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011643172.2A Pending CN112765165A (en) | 2020-12-30 | 2020-12-30 | Data entry method and device, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112765165A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113610603A (en) * | 2021-08-09 | 2021-11-05 | 京东科技控股股份有限公司 | Page information processing method and device, electronic equipment and storage medium |
| CN113793122A (en) * | 2021-09-16 | 2021-12-14 | 广东电网有限责任公司东莞供电局 | Method, device and storage medium for automatically inputting fixed value list based on RPA |
| CN114637448A (en) * | 2022-03-04 | 2022-06-17 | 上海弘玑信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
-
2020
- 2020-12-30 CN CN202011643172.2A patent/CN112765165A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113610603A (en) * | 2021-08-09 | 2021-11-05 | 京东科技控股股份有限公司 | Page information processing method and device, electronic equipment and storage medium |
| CN113610603B (en) * | 2021-08-09 | 2024-04-16 | 京东科技控股股份有限公司 | Page information processing method and device, electronic equipment and storage medium |
| CN113793122A (en) * | 2021-09-16 | 2021-12-14 | 广东电网有限责任公司东莞供电局 | Method, device and storage medium for automatically inputting fixed value list based on RPA |
| CN114637448A (en) * | 2022-03-04 | 2022-06-17 | 上海弘玑信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112765165A (en) | Data entry method and device, equipment and computer readable storage medium | |
| CN106778440B (en) | Two-dimensional code identification method and device | |
| CN106775637B (en) | Page display method and device for application program | |
| CN110113196B (en) | Protocol configuration method, device, equipment and medium | |
| EP3493130A1 (en) | Image processing method, image processing device, computer device, and computer readable storage medium | |
| CN104917896A (en) | Data pushing method and terminal equipment | |
| CN105677325A (en) | Mobile terminal and image processing method | |
| CN105609121A (en) | Method and device for controlling multimedia playing progress | |
| CN107958365B (en) | Material information changing method and device, storage medium and electronic equipment | |
| US20190102925A1 (en) | System, method, and electronic device for information duplication and machine-readable storage medium | |
| CN111277991A (en) | Operator name display method and device, mobile terminal and storage medium | |
| CN110750368A (en) | Copying and pasting method and terminal | |
| US11182071B2 (en) | Apparatus and method for providing function associated with keyboard layout | |
| CN105335434B (en) | Log management method and device and electronic equipment | |
| CN105653514A (en) | Text editing method and terminal | |
| CN111026457B (en) | Hardware configuration method and device, storage medium and terminal equipment | |
| CN104778864A (en) | Touch reading system with extensible content based on intelligent device and implementation method thereof | |
| CN110717486B (en) | Text detection method and device, electronic equipment and storage medium | |
| CN106548110A (en) | Image processing method and device | |
| CN110222286A (en) | Information acquisition method, device, terminal and computer readable storage medium | |
| CN112749248A (en) | Text element content extraction method and device, equipment and computer storage medium | |
| CN104331721A (en) | Rapid book locating device and locating method thereof | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components | |
| CN113065083A (en) | Page processing method and device, electronic equipment and storage medium | |
| CN105590075A (en) | Method for rapidly getting access to SD card and intelligent terminal |
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 |