CN110795671A - Data filling method, computing device and storage medium - Google Patents
Data filling method, computing device and storage medium Download PDFInfo
- Publication number
- CN110795671A CN110795671A CN201911038351.0A CN201911038351A CN110795671A CN 110795671 A CN110795671 A CN 110795671A CN 201911038351 A CN201911038351 A CN 201911038351A CN 110795671 A CN110795671 A CN 110795671A
- Authority
- CN
- China
- Prior art keywords
- page
- action
- filling
- data
- filled
- 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 59
- 230000009471 action Effects 0.000 claims abstract description 157
- 238000004590 computer program Methods 0.000 claims 2
- 238000012163 sequencing technique Methods 0.000 abstract description 5
- 238000004891 communication Methods 0.000 description 14
- 230000008569 process Effects 0.000 description 12
- 238000010586 diagram Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 5
- 238000005429 filling process Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000002093 peripheral effect Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000012508 change request Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 238000004088 simulation Methods 0.000 description 2
- VYZAMTAEIAYCRO-UHFFFAOYSA-N Chromium Chemical compound [Cr] VYZAMTAEIAYCRO-UHFFFAOYSA-N 0.000 description 1
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000007667 floating Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000007723 transport mechanism Effects 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/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/123—Tax preparation or submission
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a data filling method, which is executed in computing equipment, wherein the computing equipment is connected with a server. The server comprises a filled-in system, and the filled-in system comprises a plurality of pages including a login page, a selection page and a filling-in page. The method comprises the following steps that a data filling template and an action set are stored in computing equipment, the data filling template is used for bearing data to be filled, the action set is a set formed by sequencing a plurality of action units and action groups, each action group is composed of a plurality of action units, and each action unit is used for operating a page of a filled system, and the method comprises the following steps: opening a login page in a browser, and entering a selection page based on login information filled by a user; executing the action units in the action set associated with the selection page, thereby entering a filling page; and executing action units associated with the filling page in the action set, so that the data to be filled in the data filling template is filled in the filling page. The invention also discloses corresponding computing equipment and a storage medium.
Description
Technical Field
The present invention relates to the field of information processing technologies, and in particular, to a data filling method, a computing device, and a storage medium.
Background
In the existing webpage information filling field, especially in the tax payment declaration link, financial staff need to manually input tax data into an online tax handling system, the manual operation amount is large, and the tax payment declaration efficiency is low.
Thus, a solution has emerged to make tax declarations by way of simulating web site submission of data. Although the scheme can complete the data submitting action, the data with a specific structure needs to be prepared and assembled in the early stage, and the preparation work is complex. And the submitting address parameters of the online tax handling system are changed frequently, so that the submitting program needs to be adjusted frequently.
Disclosure of Invention
To this end, the present invention provides a data-filling method, a computing device and a storage medium in an effort to solve or at least alleviate at least one of the problems identified above.
According to one aspect of the present invention, there is provided a data filling method, adapted to be executed in a computing device, the computing device being connected to a server, the server including a filled-in system, the filled-in system including a plurality of pages, where the plurality of pages include a login page, a selection page and a filling-in page, the computing device having stored therein a data filling-in template and an action set, the data filling-in template being used for carrying data to be filled in, the action set being an ordered set of a plurality of action units and an action group, where the action group is composed of a plurality of action units, and the action unit is used for operating on a page of the filled-in system, the method including the steps of: opening a login page in a browser, and entering a selection page based on login information filled by a user; executing the action units in the action set associated with the selection page, thereby entering a filling page; and executing action units associated with the filling page in the action set, so that the data to be filled in the data filling template is filled in the filling page.
Optionally, in the data filling method according to the present invention, the action unit includes: the appointed component unit is used for operating components of which the mouse is suspended on the page of the filled system; the clicking unit is used for clicking the appointed component; a reading unit for reading a value in the component; the switching unit is used for switching pages; the refreshing unit is used for refreshing the current page; and the assignment unit is used for assigning the data to be filled to the designated component of the filling page.
Optionally, in the data filling method according to the present invention, the step of executing an action unit associated with the selection page in the action set, thereby entering the filling page, includes: executing an assignment unit in the action set, thereby assigning the data to be filled in the data template to be filled in which is matched with the user name to a specified component of the filling page; the other action units in the action set associated with the fill page are executed to commit.
Optionally, in the data filling method according to the present invention, the step of executing an action unit associated with a filling page in an action set, so as to fill data to be filled in a data filling template into the filling page includes: and the assignment unit in the execution action set assigns the data to be filled and reported to a filling and reporting page designated component on the filling and reporting page, so that the data to be filled and reported in the data filling and reporting template is filled and reported in the filling and reporting page.
Optionally, in the data filling method according to the present invention, there are a plurality of filling pages, and the action group is a sorted set of action units executed on one filling page.
Optionally, in the data filling method according to the present invention, the step of executing the assignment action unit includes: judging whether the cells of the data filling template exist or not, and if so, taking out the values of the cells of the data filling template; and judging whether the components of the filling page exist or not, emptying the values in the components of the filling page if the components of the filling page exist, and putting the values of the cells of the data filling template into the components of the filling page.
Optionally, in the data filling method according to the present invention, the method further includes the steps of: and returning the execution condition of each action unit to the user.
Optionally, in the data filling method according to the present invention, the format of the data filling template is Excel, and/or the filled system is a tax system.
According to yet another aspect of the invention, there is provided a computing device comprising at least one processor; and a memory storing program instructions, wherein the program instructions are configured to be executed by the at least one processor, the program instructions comprising instructions for performing the display method of a bullet box according to the present invention.
According to still another aspect of the present invention, there is provided a readable storage medium storing program instructions which, when read and executed by a client, cause the client to perform the display method of a bullet box of the present invention.
According to the technical scheme, for the system to be filled in, which comprises a login page, a selection page and a filling page, the login page is opened in a browser, the selection page is entered based on login information filled in by a user, an action unit associated with the selection page in the action set is executed by obtaining the action set, so that the filling page is entered, the action unit associated with the filling page in the action set is executed, and therefore data to be filled in a data filling template is filled in the filling page.
The action set is an action group formed by a plurality of action units and a set formed by sequencing the action units, the action units are used for operating the pages of the filled system, and the action group is a set formed by sequencing the action units and executed on the pages of the filled system. The filling task is actively executed according to the action set, automatic simulation manual operation can be realized, the efficiency of filling the webpage information is greatly improved, and meanwhile, the problems of data structure assembly and address parameter change request when data are submitted can be avoided.
In addition, after the action set is executed, the execution condition of each action unit is displayed for the user, the execution condition is accurately fed back to the execution progress of the user, and the platform maintenance complexity is reduced.
Drawings
To the accomplishment of the foregoing and related ends, certain illustrative aspects are described herein in connection with the following description and the annexed drawings, which are indicative of various ways in which the principles disclosed herein may be practiced, and all aspects and equivalents thereof are intended to be within the scope of the claimed subject matter. The above and other objects, features and advantages of the present disclosure will become more apparent from the following detailed description read in conjunction with the accompanying drawings. Throughout this disclosure, like reference numerals generally refer to like parts or elements.
FIG. 1 shows a schematic diagram of an application scenario 100 according to an embodiment of the present invention;
FIG. 2 shows a schematic diagram of a computing device 200, according to one embodiment of the invention;
FIG. 3 shows a flow diagram of a data filling method 300 according to one embodiment of the invention;
fig. 4a-g illustrate operator interface diagrams in a data filling method 300 according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
Fig. 1 shows a schematic illustration of an application scenario 100 according to an embodiment of the present invention. As shown in fig. 1, the filling system includes a computing device 200 and a server 110, and the computing device 200 is communicatively connected to the server 100.
The server includes a filled-in system 112, and the filled-in system 112 includes a plurality of pages including a login page, a selection page, and a filling-in page. The server 110 may be one server or a server cluster composed of a plurality of servers, and the deployment manner of the server 110 is not limited in the present invention.
According to one embodiment of the invention, the mode between the computing device and the Server adopts a C/S architecture, namely a Client-Server mode, namely, the computing device of the Client is connected with the Server through a local area network, receives the request of a user, and makes the request to the Server through the network to operate the database. The server receives the request of the computing equipment, submits the data to the computing equipment, and the computing equipment calculates the data and presents the result to the user. Further, the filled-in system 112 is a tax system, and the computing device of the client accesses the tax system by requesting an address on a browser.
Computing device 200 may be implemented as a personal computer including both desktop and notebook computer configurations. Computing device 200 has installed thereon a client application that supports network file transfer and storage, including native applications or browsers such as those including IE, Chrome, and Firefox, and stores locally various files such as photos, audio, video, documents (e.g., documents in the format of Word, PDF, etc.). The application client may run on an operating system such as Windows, MacOS, etc.
FIG. 2 shows a schematic diagram of a computing device 200, according to one embodiment of the invention. In a basic configuration 202, computing device 200 typically includes system memory 206 and one or more processors 204. A memory bus 208 may be used for communication between the processor 204 and the system memory 206.
Depending on the desired configuration, the processor 204 may be any type of processing, including but not limited to: a microprocessor (μ P), a microcontroller (μ C), a Digital Signal Processor (DSP), or any combination thereof. The processor 204 may include one or more levels of cache, such as a level one cache 210 and a level two cache 212, a processor core 214, and registers 216. Example processor cores 214 may include Arithmetic Logic Units (ALUs), Floating Point Units (FPUs), digital signal processing cores (DSP cores), or any combination thereof. The example memory controller 218 may be used with the processor 204, or in some implementations the memory controller 218 may be an internal part of the processor 204.
Depending on the desired configuration, system memory 206 may be any type of memory, including but not limited to: volatile memory (such as RAM), non-volatile memory (such as ROM, flash memory, etc.), or any combination thereof. System memory 106 may include an operating system 220, one or more applications 222, and program data 224. The application 222 is actually a plurality of program instructions that direct the processor 204 to perform corresponding operations. In some embodiments, application 222 may be arranged to cause processor 204 to operate with program data 224 on an operating system.
Computing device 200 may also include an interface bus 240 that facilitates communication from various interface devices (e.g., output devices 242, peripheral interfaces 244, and communication devices 246) to the basic configuration 202 via the bus/interface controller 230. The example output device 242 includes a graphics processing unit 248 and an audio processing unit 250. They may be configured to facilitate communication with various external devices, such as a display or speakers, via one or more a/V ports 252. Example peripheral interfaces 244 can include a serial interface controller 254 and a parallel interface controller 256, which can be configured to facilitate communications with external devices such as input devices (e.g., keyboard, mouse, pen, voice input device, touch input device) or other peripherals (e.g., printer, scanner, etc.) via one or more I/O ports 258. An example communication device 246 may include a network controller 260, which may be arranged to facilitate communications with one or more other computing devices 262 over a network communication link via one or more communication ports 264.
A network communication link may be one example of a communication medium. Communication media may typically be embodied by computer readable instructions, data structures, program modules, and may include any information delivery media, such as carrier waves or other transport mechanisms, in a modulated data signal. By way of non-limiting example, communication media may include wired media such as a wired network or private-wired network, and various wireless media such as acoustic, Radio Frequency (RF), microwave, Infrared (IR), or other wireless media. The term computer readable media as used herein may include both storage media and communication media.
In the computing device 200 according to the present invention, the application 222 includes a data filling means 228, the data filling means 228 being substantially a plurality of program instructions that can instruct the processor 204 to perform the data filling method 300 to implement data filling.
Fig. 3 shows a flow diagram of a data filling method 300 according to an embodiment of the invention. The method 300 is suitable for execution in a computing device, such as the computing device 200 described above. The computing device is connected to a server that includes a filled-in system that includes a plurality of pages including a login page, a selection page, and a filling-in page. The computing device 200 is installed with a client application supporting network file transmission and storage, and stores a data filling template and an action set, the data filling template is used for bearing data to be filled, the action set is a set formed by sequencing a plurality of action units and action groups, each action group is composed of a plurality of action units, and each action unit is used for operating a page of a filled system. The client application may control the browser to perform an action unit in the action set. Further, the filled system is a tax system.
As shown in fig. 3, the data filling method starts in step S310. In step S310, a login page is opened in the browser, and a selection page is entered based on login information filled in by the user. The browser is one of the client applications, and the client accesses the tax system by requesting an address on the browser.
The mode of opening the browser can be according to a program application of the present invention, the program application is configured to start the corresponding browser and address by clicking the button, and the user can click the open button. The login information is usually a user name and a user password, and different user permissions may be different. The login action is returned to the related personnel, so that the password leakage in the data filling process can be prevented. Meanwhile, the requirement of manually replacing the secret key when the user is switched to be filled is met.
As shown in fig. 4-a, after the program is started, the system will automatically open the designated browser by giving a prompt in the main window after the program is started and clicking "start filling".
As shown in fig. 4-b, opening a given browser and then exposing the login page requires the user to enter a username and password. It should be noted that, in the execution process of the scheme, a password corresponding to the user name does not need to be stored, and only a returned result after the user submits the user name and the password is received, so that the selection page is opened.
In step S320, the action unit associated with the selection page in the action set is executed, thereby entering the filling page. The action set is a set formed by sequencing a plurality of action units and action groups, wherein each action group consists of a plurality of action units, and each action unit is used for operating the page of the filled system.
According to one embodiment of the invention, an action unit comprises: the appointed component unit is used for operating components of which the mouse is suspended on the page of the filled system; the clicking unit is used for clicking the appointed component; a reading unit for reading a value in the component; the switching unit is used for switching pages; the refreshing unit is used for refreshing the current page; and the assignment unit is used for assigning the data to be filled to the designated component of the filling page. It should be noted that although the action unit includes the above form, in the process of executing a specific action set, the component designated by the designated component unit may be changed according to the step of data filling.
For the tax system, the user name is shown in the selection page, and the user name for system login can be obtained by the action of the reading unit. The user name is used for matching the data template to be filled, namely, the data required to be filled by different login users are different. Specifically, the designated component unit in the execution action set operates the mouse to suspend on the component for displaying the user name in the selection page, and then the reading unit is executed to acquire the user name on the selection page. The acquired user name is stored in the global variable, and in the next action, when the appointed user filling template needs to be read, the user name can be taken by reading the global variable, and the data template to be filled is matched through the user name. The data template to be filled in is stored in the computing device, and the specific matching mode is not limited in the invention.
In addition, all action units can be numbered, and the set of a plurality of action units and action groups after being integrally sorted is used for simulating steps required in the filling process corresponding to the artificial tax system. The process executed by the action set is the number of the calling action unit, so that the page of the filled system is operated.
The selection page may also have a component for entering a fill-in page, executing other action units in the action set associated with the selection page, and thereby entering the fill-in page. For example, the designated component unit is executed, the mouse is operated to suspend on the selected page for entering the components of the filled-in page, and then the clicking unit is executed to click on the selected page for entering the components of the filled-in page, so that the filled-in page is entered. If multiple fill pages are included, the component that selects the pages is also used to enter different fill pages.
As shown in fig. 4-c, in the selection page, the mouse is operated by the unit of the designated component in the execution action set to suspend on the component for displaying the user name in the selection page, and then the reading unit is executed to obtain the value in the component, so as to obtain the user name of the current user. The implementation mode is that the serial number of the action unit is called so as to realize the operation on the page of the filled system.
As shown in fig. 4-d, the mouse is hovered in the selection page to "i want to do tax", at which time the system displays a plurality of modules for tax, and clicking one module by the action of the execution clicking unit can enter different filling pages. The implementation mode is that the serial number of the action unit is called so as to realize the operation on the page of the filled system.
As shown in fig. 4-e, if only one filling page is included, the execution specification component unit suspends the mouse to "tax declaration and payment", then executes the action of the click unit to enter a new selection page, and clicks the "filling declaration form button" in the selection page, thereby entering a filling page.
As shown in fig. 4-f, if a plurality of filling pages are included, the execution specification component unit suspends the mouse to "tax declaration and payment", then the action of the click unit is executed to enter a new selection page, the "filling declaration form button" is clicked in the selection page, a new window can be popped up, and one filling page is selected to click "declaration", namely one filling page is entered.
Next, in step S330, the action units associated with the filling page in the action set are executed, so that the data to be filled in the data filling template is filled in the filling page.
According to one embodiment of the invention, the assignment unit in the execution action set assigns the data to be filled in to the filling page specification component on the filling page. The filling page can involve the operation of filling in cells, and the cells exist in the filling page in the form of components and need to be filled in according to the format specification of the filling page and the data needing to be filled in by a user.
The data filing template is a data carrier which needs to be filed by a user, the format is excel, the specific requirement is excel above 2007 edition, and the cell of the excel to be read needs to be ensured to be found. These data-filling templates are corresponding tables that are automatically generated, usually based on the existing business system of the user, and the user who performs data-filling does not need to modify the existing system and modify the data format again. The data filling template is only required to be placed on a specified path, and different user names have different paths. When the appointed user data filling template needs to be read, the user name can be taken by reading the task number in the global variable, and the corresponding path is found according to the user name, so that the data to be filled is obtained.
As shown in fig. 4-g, after a filled-in page is opened, the page has cells to be filled in, and the cells may be input boxes, and the cells exist in the form of components on the filled-in page.
In actual data filling, a system to be filled may fill a plurality of filling pages, and in order to ensure that data on a filled form website is not lost, a sorted set of action units executed on one filling page is generally used as an action group. After the execution of the action group is finished, the action of the clicking unit is executed to click the button with the saving function on the page. In particular, the scheme has no requirement on the filling sequence among different filling pages. Because a plurality of cells in the filled-in page need to be filled in, one assignment unit is executed, namely, one cell is filled in the filled-in page, and the assignment units in the action group have no precedence requirement. Therefore, corresponding template data are read in the system execution process, and the template data do not need to be opened one by one manually and then searched, copied and pasted.
According to one embodiment of the invention, the step of performing the action of the assignment unit comprises: judging whether the cells of the data filling template exist or not, and if so, taking out the values of the cells of the data filling template; and judging whether the components of the filling page exist or not, emptying values in the components of the filling page if the components of the filling page exist, and putting the values of the cells of the data filling template into the components of the filling page.
Specifically, one assignment unit is used for filling in one cell on the filling page, usually more than one cell needs to be filled in on the filling page, the cell can be an input box, and the cell exists in a component form on the filling page. The assignment unit comprises coordinates of components on the filling page and cell coordinates of a corresponding data filling template. The assignment unit judges whether a cell where a cell coordinate designated by excel bearing data to be filled exists or not, and if the cell coordinate exists, the value in the excel cell is taken out. For example, the cell coordinates in excel may be "Sheet 1! A3 ", the value in this excel cell is" 5000 ". Finding out the components at the coordinate positions of the filled page according to the configured components, wherein the page structure in the browser is an xml structure, one component is an xml object, and the process of positioning and establishing according to the component coordinates is similar to the process of analyzing the xml structure. And judging whether the components of the filling page exist or not, if so, clearing the values in the components of the filling page, and putting the values of the cells of the data filling template into the components of the filling page. For example, the value "5000" of the corresponding cell in excel is filled into an input box component which displays that the text is "amount" and needs to be filled on the filling page, and the component is defined based on the xml structure at the coordinate position of the filling page. In particular, the zoom ratio of the browser must be one hundred percent, otherwise the component acquisition is affected.
Particularly, in the execution process of the action unit, a certain identifier of the page needs to be captured to judge the page loading completion degree. At this time, a forced waiting time setting can be set, and the execution is automatically started after waiting for several seconds, so that the problem that the page cannot be operated due to the fact that the page loading is determined to be not finished at this time without capturing the identifier due to too short execution time interval of the action unit is prevented.
And after the action of the assignment unit is executed, executing other action units related to the filling page in the action set so as to submit. For example, the designated component unit is executed, the mouse is operated to suspend on the selected page for submitting the component, and then the clicking unit is executed for submitting the component.
According to another embodiment of the invention, after the action set is executed, the execution of each action unit is presented to the user. It should be noted that sometimes, when the action is abnormal, the filling action may not be terminated, and this value needs to be set to 1(0 does not skip, terminates the subsequent action, 1 skips, and continues to execute the subsequent action). For example, the cell is not fillable, and for the same filled system, different users log in, because of the inconsistency of the authority, some cells may be in a read-only state and do not need to be filled. And setting the exception skipping and continuing to execute the exception generated by the unfilled cells. The exception in the system filling process is processed by pre-configuration, and an intermediate user can not participate, so that the user can master the action execution progress. And the platform maintenance complexity is reduced.
Particularly, after the action unit is executed, the system needs to wait for the result of successful storage returned by the system after the storage is completed, and the forced waiting time after the action is executed can be set, so that the difficulty in detecting the result of waiting for return is avoided.
The following is an example of configuring an assignment unit, task-26 being the number of assignment actions.
task26 { ' action ': click SendKeysFromExcel ', ' findType ': xpath ', ' coord ': ' ' outTime ': ' ' isRetry '; ' retryNum ', ' cellCoord ': ', ' before ForceWait ': ' ' middleForceWait ', ' after ForceWait ': ' ' exceptino ': 0', ' tip ': not made available, sold, 9 tax rate goods and process repair and repair labor ' }
The following are parameter descriptions:
action type (configured according to the types supported in the action library);
findType is a page coordinate searching mode;
coord is the page coordinate;
outTime is the timeout time for waiting when coordinates are positioned (since some filled systems have slow response and need to wait for a period of time, the intelligent waiting time can be set here, and the coordinates are returned to be successfully retrieved immediately after the page is successfully loaded);
isRetry (if the system times out, there is no feedback, we can set retry, and refresh actions, can be used with the following number of retries);
retryNum is the number of retries;
cellCoord is the coordinate of the template cell;
before ForeForcWait, setting the forced waiting time before executing the action;
midleForceWait, in the action execution process, setting the forced waiting time;
afterForceWait, forced waiting time setting after action execution;
exceptinignore whether to ignore exception or not to continue execution;
tip: this is the description information of the action execution, and the action execution is successful, and this information will be returned.
It should be noted that: from the above steps, the declaration page can be reached step by step, but more action units than the above are needed in the actual action set execution process. For example, many pages in the tax system are displayed in a nested page manner by loading a plurality of sub-pages in a frame manner, so that a user can see that the page is a whole page, but coordinates need to be switched to a specific page in a positioning manner, at this time, the frame needs to be switched, and a switching unit is needed to be used for switching the page. These steps are not visible in the filled-in system, and these invisible actions are used for the actions of switching the page structure.
According to the technical scheme, for the system to be filled in, which comprises a login page, a selection page and a filling page, the login page is opened in a browser, the selection page is entered based on login information filled in by a user, an action unit associated with the selection page in the action set is executed by obtaining the action set, so that the filling page is entered, the action unit associated with the filling page in the action set is executed, and therefore data to be filled in a data filling template is filled in the filling page. And the filling task is actively executed according to the action set, so that automatic simulation manual operation can be realized, and the efficiency of filling the webpage information is greatly improved.
Meanwhile, because the manual operation is simulated after the login page is opened, the steps that data are submitted and address parameters need to be bound for the data are not involved, and the problems of data structure assembly and address parameter change request during data submission can be eliminated. The user who carries out data filling does not need to modify the existing system and does not need to modify the data format again. Only the data filling template is required to be placed on the specified path.
At present, the manual processing is carried out to carry out the work of filling a large amount of data for about twenty minutes under the normal condition, if the filling method of the scheme is adopted to carry out equivalent data filling, only two minutes are needed generally, and the filling time is greatly reduced. In conclusion, the scheme provides the experience of quick report filling and greatly saves the operation time.
In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.
Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
Those skilled in the art will appreciate that the modules or units or components of the devices in the examples disclosed herein may be arranged in a device as described in this embodiment or alternatively may be located in one or more devices different from the devices in this example. The modules in the foregoing examples may be combined into one module or may be further divided into multiple sub-modules.
Those skilled in the art will appreciate that the modules in the device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and furthermore they may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.
Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination.
Furthermore, some of the described embodiments are described herein as a method or combination of method elements that can be performed by a processor of a computer system or by other means of performing the described functions. A processor having the necessary instructions for carrying out the method or method elements thus forms a means for carrying out the method or method elements. Further, the elements of the apparatus embodiments described herein are examples of the following apparatus: the apparatus is used to implement the functions performed by the elements for the purpose of carrying out the invention.
As used herein, unless otherwise specified the use of the ordinal adjectives "first", "second", "third", etc., to describe a common object, merely indicate that different instances of like objects are being referred to, and are not intended to imply that the objects so described must be in a given sequence, either temporally, spatially, in ranking, or in any other manner.
While the invention has been described with respect to a limited number of embodiments, those skilled in the art, having benefit of this description, will appreciate that other embodiments can be devised which do not depart from the scope of the invention as described herein. Furthermore, it should be noted that the language used in the specification has been principally selected for readability and instructional purposes, and may not have been selected to delineate or circumscribe the inventive subject matter. Accordingly, many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the appended claims. The present invention has been disclosed in an illustrative rather than a restrictive sense, and the scope of the present invention is defined by the appended claims.
Claims (10)
1. A data filling method, adapted to be executed in a computing device, the computing device being connected to a server, the server including a filled system, the filled system including multiple pages, the multiple pages including a login page, a selection page and a filling page, a data filling template and an action set being stored in the computing device, the data filling template being used for carrying data to be filled, the action set being an ordered set of multiple action units and action groups, an action group being composed of multiple action units, and the action units being used for operating the pages of the filled system, the method comprising:
opening a login page in a browser, and entering a selection page based on login information filled by a user;
executing an action unit in the action set associated with a selection page, thereby entering a filling page; and
and executing action units related to a filling page in the action set, so that the data to be filled in the data filling template is filled in the filling page.
2. The method of claim 1, the action unit comprising:
the designated component unit is used for operating components of which the mouse is suspended on the page of the filled system;
the clicking unit is used for clicking the appointed component;
a reading unit for reading a value in a component;
the switching unit is used for switching pages;
the refreshing unit is used for refreshing a current page;
and the assignment unit is used for assigning the data to be filled to the designated component of the filling page.
3. The method of claim 2, wherein the step of executing an action unit associated with a selection page in the action set to enter a fill page comprises:
executing a designated component unit and a reading unit in the action set, thereby obtaining a user name on the selection page, wherein the user name is used for matching a data template to be filled;
and executing other action units in the action set associated with the selection page so as to enter the filling page.
4. The method of claim 3, wherein the step of executing an action unit associated with a fill-in page in the action set to fill in data to be filled in the data fill-in template into the fill-in page comprises:
executing an assignment unit in the action set, so as to assign the data to be filled in the data template to be filled in, which is matched with the user name, to a specified component of the filling page;
and executing other action units in the action set and associated with the filling page so as to submit.
5. The method of claim 1, wherein the fill-in page is plural, and the action group is a sorted set of action units executed on one fill-in page.
6. The method of claim 4, the step of assigning the action unit execution comprising:
judging whether the cells of the data filling template exist or not, and if so, taking out the values of the cells of the data filling template;
and judging whether the components of the filling page exist or not, if so, emptying the values in the components of the filling page, and putting the values of the cells of the data filling template into the components of the filling page.
7. The method of claim 1, further comprising the steps of: and returning the execution condition of each action unit to the user.
8. The method of claim 1, wherein the data filling template is in the format of Excel, and/or the filled system is a tax system.
9. A computing device, comprising:
at least one processor; and
at least one memory including computer program instructions;
the at least one memory and the computer program instructions are configured to, with the at least one processor, cause the computing device to perform the method of any of claims 1-8.
10. A readable storage medium storing program instructions that, when read and executed by a computing device, cause the computing device to perform the method of any of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911038351.0A CN110795671A (en) | 2019-10-29 | 2019-10-29 | Data filling method, computing device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911038351.0A CN110795671A (en) | 2019-10-29 | 2019-10-29 | Data filling method, computing device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110795671A true CN110795671A (en) | 2020-02-14 |
Family
ID=69442058
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911038351.0A Pending CN110795671A (en) | 2019-10-29 | 2019-10-29 | Data filling method, computing device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110795671A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347336A (en) * | 2020-11-11 | 2021-02-09 | 江苏云坤信息科技有限公司 | System for realizing data collection and distribution based on web page and processing method thereof |
| CN113610595A (en) * | 2021-07-26 | 2021-11-05 | 航天信息系统工程(北京)有限公司 | Method and system for informatization management of price reporting and reviewing |
| CN115438634A (en) * | 2022-08-24 | 2022-12-06 | 内蒙古龙源蒙东新能源有限公司 | Information filling method and device, storage medium and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106681971A (en) * | 2015-11-11 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Form data processing method and device |
| CN108595393A (en) * | 2018-01-11 | 2018-09-28 | 太原理工大学 | A kind of automatic form filling method and device |
| CN108664461A (en) * | 2018-05-03 | 2018-10-16 | 北京神州泰岳软件股份有限公司 | A kind of web form Auto-writing method and device |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
-
2019
- 2019-10-29 CN CN201911038351.0A patent/CN110795671A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106681971A (en) * | 2015-11-11 | 2017-05-17 | 阿里巴巴集团控股有限公司 | Form data processing method and device |
| CN108595393A (en) * | 2018-01-11 | 2018-09-28 | 太原理工大学 | A kind of automatic form filling method and device |
| CN108664461A (en) * | 2018-05-03 | 2018-10-16 | 北京神州泰岳软件股份有限公司 | A kind of web form Auto-writing method and device |
| CN109711960A (en) * | 2018-12-28 | 2019-05-03 | 北京爱康鼎科技有限公司 | It declares dutiable goods method and system |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347336A (en) * | 2020-11-11 | 2021-02-09 | 江苏云坤信息科技有限公司 | System for realizing data collection and distribution based on web page and processing method thereof |
| CN113610595A (en) * | 2021-07-26 | 2021-11-05 | 航天信息系统工程(北京)有限公司 | Method and system for informatization management of price reporting and reviewing |
| CN113610595B (en) * | 2021-07-26 | 2024-05-24 | 航天信息系统工程(北京)有限公司 | Report and examination price informatization management method and system |
| CN115438634A (en) * | 2022-08-24 | 2022-12-06 | 内蒙古龙源蒙东新能源有限公司 | Information filling method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110795671A (en) | Data filling method, computing device and storage medium | |
| WO2015179705A1 (en) | Enhanced compliance verification system | |
| US11792257B2 (en) | Form engine | |
| US20170351972A1 (en) | Program storage medium, method, and system for providing learning model difference | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| CN108320136B (en) | Method and device for setting electronic signature | |
| CN109634579A (en) | Code generating method, device, computer installation and storage medium | |
| CN108228228A (en) | Application software dissemination method and device | |
| CN114092951A (en) | Financial bill processing method, device, system, equipment and medium combining RPA and AI | |
| CN106484699A (en) | The generation method of data base querying field and device | |
| CN112711640A (en) | Method and device for configuring business handling process | |
| CN104346398A (en) | Method and device for automatically filling and submitting data on line | |
| CN115268873A (en) | Low-code file development method based on multi-person cooperation | |
| US11848976B2 (en) | Custom action invocation in a speadsheet integrated with web services | |
| CN117112012A (en) | Application configuration generation method, device, equipment and medium | |
| EP3987410A1 (en) | Systems and methods to facilitate rapid data entry for document review | |
| CN112130827A (en) | Model development method and platform based on cloud modularization technology and intelligent terminal | |
| CN114661745A (en) | Recruitment information publishing method and device based on RPA and AI | |
| CN114860302A (en) | Page configuration method and device, electronic equipment and storage medium | |
| JP2003248747A (en) | Electronic document processing system, electronic document processing program, computer readable recording medium recording program thereof and electronic document processing method | |
| CN109492747A (en) | A kind of the network structure generation method and device of neural network | |
| CN113127791A (en) | Operation page configuration method, system, device and readable storage medium | |
| CN107885755A (en) | The control method and device of application resource information | |
| CN115509907A (en) | Form submission testing method and device, computing equipment and storage medium | |
| CN111581093B (en) | Method, device, equipment and medium for generating test record list |
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: 20200214 |
|
| RJ01 | Rejection of invention patent application after publication |