CN112712421A - Method, equipment and storage medium for automatically downloading running bill - Google Patents
Method, equipment and storage medium for automatically downloading running bill Download PDFInfo
- Publication number
- CN112712421A CN112712421A CN202011596190.XA CN202011596190A CN112712421A CN 112712421 A CN112712421 A CN 112712421A CN 202011596190 A CN202011596190 A CN 202011596190A CN 112712421 A CN112712421 A CN 112712421A
- Authority
- CN
- China
- Prior art keywords
- bank
- downloading
- account
- program
- online
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 57
- 238000003860 storage Methods 0.000 title claims description 17
- 238000004801 process automation Methods 0.000 claims abstract description 19
- 238000004088 simulation Methods 0.000 claims description 11
- 239000000126 substance Substances 0.000 claims 1
- 230000003252 repetitive effect Effects 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 13
- 230000008569 process Effects 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 230000009286 beneficial effect Effects 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008030 elimination Effects 0.000 description 1
- 238000003379 elimination reaction Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- 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/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/13—File access structures, e.g. distributed indices
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Technology Law (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The application discloses a method, equipment and medium for automatically downloading a running bill, wherein the method comprises the following steps: the system determines the bank name according to the user instruction; loading a downloading program corresponding to the bank name from a plurality of downloading programs based on the bank name, wherein the plurality of downloading programs are operated by a robot process automation tool; logging in an online bank interface according to an account number and a password of a bank account by a downloading program, wherein the account number and the password of the bank account are prestored in a Windows voucher of the system; inquiring the online banking interface to obtain an account summary sheet and a transaction document; and downloading the account summary sheet and the transaction document to a corresponding folder of the system. The automatic bank online bank login and running bill downloading function is realized through the downloading program operated by the robot process automation tool, so that the repetitive labor of workers is greatly reduced, and the problem of high error rate caused by the repetitive labor of users is avoided.
Description
Technical Field
The application relates to the technical field of computers, in particular to a method, equipment and a storage medium for automatically downloading a running bill.
Background
With the gradual development and improvement of the national asset supervision system, the state resource committee proposes that the state resource enterprises need to report all the capital flow bills, and because the informatization level of each large state resource enterprise is low, many cooperative banks and many bank accounts exist, all the bank accounts are difficult to be brought into a capital management system. For bank accounts other than the funds management system, manual downloads of the funds movement bills for those accounts are required.
Because the number of the capital running bills is large, errors frequently occur in the actual operation process by manual work, and account missing are easy to occur, a method for automatically downloading the running bills becomes a problem to be solved urgently.
Disclosure of Invention
In order to solve the above problems, that is, there are many bank accounts and many cooperating banks outside the fund management system, and the manual downloading of the fund flow bill is time-consuming and labor-consuming, and has low efficiency and is very easy to make mistakes, the present application provides a method, a device and a storage medium for automatically downloading the flow bill, which includes:
in a first aspect, a method for automatic downloading of a running bill is provided, which includes: the system determines the bank name according to the user instruction; loading a downloading program corresponding to the bank name from a plurality of downloading programs based on the bank name, wherein the plurality of downloading programs are operated by a robot process automation tool, and the plurality of downloading programs and the robot process automation tool are pre-stored in the system; logging in an online bank interface according to an account number and a password of a bank account through the downloading program, wherein the account number and the password of the bank account are prestored in a Windows voucher of the system; based on the downloading program, inquiring in the online banking interface to obtain an account summary sheet and a transaction document; and downloading the account summary sheet and the transaction document to a corresponding folder of the system based on the downloading program.
In one example, the downloading program is configured to: opening an online bank login interface corresponding to the bank name according to a preset configuration file, wherein the address of the online bank login interface is recorded in the configuration file; acquiring an account number and a password of the bank account from a Windows certificate of the system according to the configuration file, wherein an opening path of the Windows certificate is recorded in the configuration file; and downloading the account summary sheet and the transaction document into the folder according to the configuration file, wherein the position of the folder is recorded in the configuration file.
In one example, the downloading program is further configured to: clicking and/or double-clicking operation is carried out at a preset position through simulating a mouse, so that the online bank login interface is clicked and opened, a login key is clicked, and a download key is clicked according to the configuration file; and performing typing operation at a preset position through a simulation keyboard so as to input the address of the online bank login interface and input the account number and the password of the bank account according to the configuration file.
In one example, the method specifically includes the following steps that a user logs in to an online banking interface according to an account number and a password of a bank account through the downloading program: detecting whether an electronic key exists in the current operating environment, if so, opening an online bank login interface based on the downloading program, and extracting an account number and a password of the bank account prestored in the Windows certificate; and automatically inputting the account number and the password of the bank account to the corresponding position of the online bank login interface through a simulation keyboard so as to log in the online bank interface.
In one example, the method specifically includes the steps of logging in to an online banking interface based on the account number and the password of the downloading program and the bank account: detecting whether an electronic key exists in the current operating environment; if the electronic key exists, opening an online bank login interface based on the downloading program, and extracting account numbers and passwords of a plurality of bank accounts pre-stored in the Windows certificate; and polling and inputting the accounts and the passwords of the plurality of bank accounts to corresponding positions of the online bank login interface through a simulation keyboard, and trying to login to the online bank interface until login is successful.
In one example, based on the downloading program, logging in to an online banking interface according to an account number and a password of a bank account, the method specifically includes: detecting whether a plurality of electronic keys exist in the current operating environment; if a plurality of electronic keys exist, detecting whether a logged account exists in the current operating environment; if the logged account exists, detecting whether the logged account completes downloading or not; if the downloading is finished, quitting the logged account, marking the account number and the password of the bank account corresponding to the logged account, and obtaining the marked account number and password of the bank account; opening the online bank login interface based on the downloading program, and extracting account numbers and passwords of a plurality of bank accounts pre-stored in the Windows voucher; removing the marked account numbers and passwords of the bank accounts from the account numbers and passwords of the plurality of bank accounts to obtain the processed account numbers and passwords of the bank accounts; and polling and inputting the processed account number and the password of the bank account to the corresponding position of the online bank login interface through a simulation keyboard, and trying to login to the online bank interface until login is successful.
In one example, after downloading the account summary and the transaction document into the corresponding folder based on the downloading program, the method further comprises: loading a filling program, wherein the filling program runs through the robot process automation tool, and the filling program and the robot process automation tool are pre-stored in the system; summarizing the account summary sheet and the transaction document in the folder through the filling program, and automatically generating a table in an Excel form; logging in an enterprise database according to an account and a password of the enterprise database through the filling program, wherein the account and the password of the enterprise database are prestored in a Windows voucher of the system; and uploading the table to the enterprise database through the filling program.
In one example, after the internet bank login interface is opened based on the downloading program, the method further comprises: detecting whether the online bank login interface has an electronic key-driven update prompt; and if the electronic key drives the update prompt, automatically clicking an update option based on the downloading program, and automatically downloading the updated driving program.
In another aspect, an apparatus for automatic downloading of a running bill is provided, including: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform a method as in any one of the above examples.
In another aspect, a non-volatile computer storage medium for automatic downloading of a running bill is provided, the medium storing computer-executable instructions, wherein the computer-executable instructions are configured to: a method as in any preceding example.
The method, the equipment and the storage medium for automatically downloading the running bill can bring the following beneficial effects: the automatic bank online bank login and running bill downloading function is realized through the downloading program operated by the robot process automation tool, so that the repetitive labor of workers is greatly reduced, and the problem of high error rate caused by the repetitive labor of users is avoided. Meanwhile, the running bills corresponding to the plurality of bank accounts can be completely downloaded, repeated downloading of the running bills corresponding to the same account is avoided on the basis of no omission, and the method is more suitable for state enterprises. In addition, in order to respond to the reporting requirement of the state resource committee, the method and the system design a filling and reporting program for summarizing the running bills and automatically uploading the running bills to an enterprise database, reduce the working pressure of financial staff, ensure the data safety of the running bills, and avoid the situations of account missing, account missing and account change caused by manpower summarization.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
fig. 1 is a schematic flowchart of an automatic downloading method for a running bill provided in an embodiment of the present application;
fig. 2 is a schematic diagram of an online banking login interface provided in an embodiment of the present application;
fig. 3 is a schematic diagram of an account summary table of an online banking interface provided in an embodiment of the present application;
fig. 4 is a schematic diagram of an online banking interface transaction query provided in an embodiment of the present application;
fig. 5 is a schematic diagram of an online banking download interface provided in an embodiment of the present application;
fig. 6 is a schematic diagram of an automatic downloading device for a running bill provided in an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
In the embodiment of the application, the method for automatically downloading the running bill is stored in a corresponding system, a user can log in the system through the system, the system can be a hardware device with corresponding functions, such as a smart phone, a tablet computer and a personal computer, the system can be pre-installed in the system, and the system can also be logged in through modes, such as an APP (application), a WEB (WEB site) and the like, so that the running bill can be automatically downloaded. As shown in fig. 1, a method for automatically downloading a running bill provided in an embodiment of the present application includes:
s101, the system determines the bank name according to the user instruction.
Specifically, before the running bill is automatically downloaded, the user needs to select from a plurality of bank names according to the requirement, and the system may determine, according to the selection instruction of the user, a corresponding bank name to which the instruction is to be executed, where the running bill includes, but is not limited to: account summary, transaction document.
S102, loading a downloading program corresponding to the bank name from a plurality of downloading programs based on the bank name, wherein the plurality of downloading programs run through a robot process automation tool, and the plurality of downloading programs and the robot process automation tool are pre-stored in the system.
Particularly, a national enterprise generally has multiple cooperative banks, and because the internet banking interfaces of different banks are often different, multiple downloading programs are designed, and the multiple downloading programs correspond to the multiple banks one to one. And selecting a downloading program corresponding to the bank name from a plurality of downloading programs prestored in the system based on the bank name determined by the system, and loading the program.
The plurality of downloading programs run through a robot Process Automation tool, and the robot Process Automation tool can perform operations such as copying, pasting, clicking, inputting and the like through simulation manual work, so that a user is assisted to complete work and tasks with high repeatability in various terminals. In the embodiment of the present application, any type of robot process automation tool may be selected, and a uicat is used as an example in the present application for explanation, where the uicat is a robot process automation tool, and the uicat is developed by a uicat Studio development tool and may be used as a carrier for downloading programs or other types of robot process automation programs in the embodiment of the present application.
In one embodiment, after the downloading program is developed, a corresponding configuration file needs to be set, and in the embodiment of the application, the address of the online banking login interface, the opening path of the Windows certificate and the position of the folder corresponding to the downloading target need to be recorded in the configuration file. Meanwhile, the configuration file needs to be adapted to the Windows certificate, so that the downloading program can read the content in the Windows certificate according to the configuration file. The Windows voucher records the website of the bank corresponding to the online bank login interface, and the account number and the password of the bank account.
After loading the downloading program, the downloading program can simulate a mouse to open any type of browser by clicking and/or double clicking at a specific position. After entering the browser interface, the downloading program can acquire the website of the internet bank from the Windows certificate according to the configuration file. The downloading program can paste the website of the online bank to the website input box of the browser in a copying and pasting mode, and can also key the website of the online bank into the website input box of the browser through a simulation keyboard to enter an online bank login interface.
Further, after the downloading program enters the online banking login interface, the account number and the password of the bank account are obtained from the Windows voucher according to the configuration program. The downloading program can paste the account number and the password of the bank account to the corresponding position of the online bank login interface in a copying and pasting mode, and can also key in the account number and the password of the bank account at the corresponding position of the online bank login interface through a simulation keyboard to enter the online bank interface.
Furthermore, after the downloading program enters the internet banking interface, the account summary table and the transaction data can be found by clicking layer by layer in a mode of simulating clicking and/or double clicking of a mouse at a specific position, the downloading target position is selected as the position of the corresponding folder in a mode of simulating clicking and/or double clicking of the mouse at the specific position according to the position of the corresponding folder recorded in the configuration file, and a downloading key is clicked, so that the account summary table and the transaction data are downloaded into the corresponding folder.
It should be noted that the internet banking interfaces of different banks are designed differently, and developers can design different downloading programs according to different internet banking, and the different downloading programs simulate click and/or double click of a mouse and simulate different time and positions of keyboard typing.
S103, logging in an online banking interface according to an account number and a password of a bank account through the downloading program, wherein the account number and the password of the bank account are prestored in a Windows voucher of the system.
Specifically, since the internet banking login generally requires an electronic key, before the login, the system may detect whether the electronic key exists in the current operating environment, and if the electronic key does not exist, the system stops operating the downloading program and reminds the user. If the electronic key exists, as shown in fig. 2, the system opens the internet bank login interface based on a downloading program, extracts the account number and the password of the bank account pre-stored in the Windows certificate, and inputs the greeting password of the bank account to the corresponding position of the internet bank login interface in a keyboard simulating manner so as to log in the internet bank interface.
And S104, inquiring the online banking interface to obtain an account summary sheet and a transaction document based on the downloading program.
As shown in fig. 3 and 4, after entering the internet banking interface, the system may click layer by layer to find the account total list and the transaction document (shown as a transaction query in fig. 4) by simulating a mouse click and/or double click at a specific position according to a downloading program.
And S105, downloading the account summary sheet and the transaction document to a corresponding folder of the system based on the downloading program.
As shown in fig. 5, after the account summary and the transaction document are obtained through query, the system may select a download target location as the location of the corresponding folder by simulating a mouse click and/or double click at a specific location according to the download program and the location of the corresponding folder recorded in the configuration file, and click a download button, thereby implementing automatic download of the account summary and the transaction data into the corresponding folder.
In one embodiment, the Windows voucher may record accounts and passwords of a plurality of bank accounts, if only one electronic key is inserted into the operating environment, when the system detects the existence of the electronic key, the online bank login interface may be opened based on a downloading program, the accounts and passwords of the plurality of bank accounts pre-stored in the Windows voucher are extracted, the accounts and passwords of the plurality of bank accounts are input to corresponding positions of the online bank login interface in a polling manner in a keyboard simulating manner, and the login to the online bank interface is attempted until the login is successful. Because the number of the cooperative banks and the bank accounts of the state resource enterprise is very large, the account numbers and the passwords of a plurality of bank accounts are often stored in the Windows voucher.
In one embodiment, the Windows voucher may record accounts and passwords of a plurality of bank accounts, and if a plurality of electronic keys are inserted into an operating environment, when the system detects that the electronic keys exist, the online bank login interface may be opened based on a downloading program, the accounts and passwords of the bank accounts pre-stored in the Windows voucher are extracted, the accounts and passwords of the bank accounts are input to corresponding positions of the online bank login interface in a polling manner in a keyboard simulating manner, and the login to the online bank interface is attempted until the login is successful. After the account summary and the transaction document of the current account are downloaded, the system quits the current account and marks the current account, wherein the mark is used for displaying that the account is downloaded completely. The system eliminates the marked account numbers and passwords of the bank accounts from the account numbers and the passwords of the plurality of bank accounts, and repeats the processes of the account numbers and the passwords of the bank accounts after the elimination until all the running bills of the bank accounts corresponding to the plurality of electronic keys are downloaded. According to the scheme recorded by the embodiment, the system can realize all downloading of a plurality of running bills on the basis that the user inserts a plurality of electronic keys simultaneously, so that the user is prevented from inserting the electronic keys one by one and downloading the electronic keys one by one, the working efficiency is improved, and meanwhile, repeated downloading of the running bills corresponding to one bank account is also prevented through rejection processing.
In one embodiment, the Windows voucher may record account numbers and passwords of a plurality of bank accounts, and when a plurality of electronic keys are inserted into the operating environment at this time, when the system detects that an electronic key exists, it may detect whether a logged-in account exists in the current operating environment, and if a logged-in account exists, it may detect whether the account has completed downloading, and if the downloading is completed, it exits the current account, and marks the current account, where the marks are used to show that the account has completed downloading. The system eliminates the marked account numbers and passwords of the bank accounts from the account numbers and the passwords of the plurality of bank accounts, polls and inputs the eliminated bank accounts and passwords to corresponding positions of the online bank login interface in a keyboard simulating mode, and tries to log in the online bank interface until login is successful. And after the successful login and the successful downloading of the accounts are completed, repeating the process until all the running bills of the bank accounts corresponding to the plurality of electronic keys are downloaded. According to the scheme recorded by the embodiment, the user inserts the plurality of electronic keys again in the process of using the system, the system can continuously download all the corresponding running bills according to the plurality of newly inserted electronic keys, the working efficiency is improved, and meanwhile, the repeated downloading of the running bills corresponding to one bank account is avoided through removing processing.
In one embodiment, after the account summary and the transaction documents are downloaded to the corresponding folders, the system can load a filling program, summarize the account summary and the transaction documents in the folders through the filling program, and automatically generate a table in an Excel form. And then, the system logs in the enterprise database according to the account and the password of the enterprise database through the filling program, and uploads the table to the enterprise database.
The filling program runs through a robot process automation tool, and the development and running mode of the filling program is consistent with that of the downloading program, and is not described again here. The configuration file corresponding to the filling program records the access path of the Windows voucher, the opening path of the Excel table and the position of the folder. The Windows voucher records the account number and the password of the enterprise database.
In one embodiment, after the system opens the online bank login interface based on the downloading program, whether an electronic key-driven update prompt exists in the online bank login interface can be detected, if the electronic key-driven update prompt exists, a mouse click and/or double click update option is simulated based on the downloading program, and the updated driver is automatically downloaded. And if the online bank login interface does not have the electronic key drive updating prompt, shielding the step operation of the downloading program.
In one embodiment, as shown in fig. 6, an embodiment of the present application provides an apparatus for automatically downloading a running bill, including: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of the above embodiments.
In one embodiment, the present application provides a non-volatile computer storage medium for automatic downloading of a running bill, and the non-volatile computer storage medium stores computer executable instructions configured to: a method as in any preceding embodiment.
The embodiments in the present application are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the device and media embodiments, the description is relatively simple as it is substantially similar to the method embodiments, and reference may be made to some descriptions of the method embodiments for relevant points.
The device and the medium provided by the embodiment of the application correspond to the method one to one, so the device and the medium also have the similar beneficial technical effects as the corresponding method, and the beneficial technical effects of the method are explained in detail above, so the beneficial technical effects of the device and the medium are not repeated herein.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for automatically downloading a running bill is characterized by comprising the following steps:
the system determines the bank name according to the user instruction;
loading a downloading program corresponding to the bank name from a plurality of downloading programs based on the bank name, wherein the plurality of downloading programs are operated by a robot process automation tool, and the plurality of downloading programs and the robot process automation tool are pre-stored in the system;
logging in an online bank interface according to an account number and a password of a bank account through the downloading program, wherein the account number and the password of the bank account are prestored in a Windows voucher of the system;
based on the downloading program, inquiring in the online banking interface to obtain an account summary sheet and a transaction document;
and downloading the account summary sheet and the transaction document to a corresponding folder of the system based on the downloading program.
2. The method for automatically downloading the running bill according to claim 1, wherein the downloading program is used for:
opening an online bank login interface corresponding to the bank name according to a preset configuration file, wherein the address of the online bank login interface is recorded in the configuration file;
acquiring an account number and a password of the bank account from a Windows certificate of the system according to the configuration file, wherein an opening path of the Windows certificate is recorded in the configuration file;
and downloading the account summary sheet and the transaction document into the folder according to the configuration file, wherein the position of the folder is recorded in the configuration file.
3. The method for automatically downloading the running bill according to claim 2, wherein the downloading program is further configured to:
clicking and/or double-clicking operation is carried out at a preset position through simulating a mouse, so that the online bank login interface is clicked and opened, a login key is clicked, and a download key is clicked according to the configuration file;
and performing typing operation at a preset position through a simulation keyboard so as to input the address of the online bank login interface and input the account number and the password of the bank account according to the configuration file.
4. The method for automatically downloading the running bill according to claim 1, wherein the method logs in to an online banking interface according to an account number and a password of a bank account through the downloading program, and specifically comprises the following steps:
detecting whether an electronic key exists in a current operating environment
If the electronic key exists, opening an online bank login interface based on the downloading program, and extracting an account number and a password of the bank account prestored in the Windows certificate;
and automatically inputting the account number and the password of the bank account to the corresponding position of the online bank login interface through a simulation keyboard so as to log in the online bank interface.
5. The method for automatically downloading the running bill according to claim 1, wherein the online banking interface is logged in based on the account number and the password of the downloading program and the bank account, and the method specifically comprises:
detecting whether an electronic key exists in the current operating environment;
if the electronic key exists, opening an online bank login interface based on the downloading program, and extracting account numbers and passwords of a plurality of bank accounts pre-stored in the Windows certificate;
and polling and inputting the accounts and the passwords of the plurality of bank accounts to corresponding positions of the online bank login interface through a simulation keyboard, and trying to login to the online bank interface until login is successful.
6. The method for automatically downloading the running bill according to claim 1, wherein based on the downloading program, the method logs in to an online banking interface according to an account number and a password of a bank account, and specifically comprises:
detecting whether a plurality of electronic keys exist in the current operating environment;
if a plurality of electronic keys exist, detecting whether a logged account exists in the current operating environment;
if the logged account exists, detecting whether the logged account completes downloading or not;
if the downloading is finished, quitting the logged account, marking the account number and the password of the bank account corresponding to the logged account, and obtaining the marked account number and password of the bank account;
opening the online bank login interface based on the downloading program, and extracting account numbers and passwords of a plurality of bank accounts pre-stored in the Windows voucher;
removing the marked account numbers and passwords of the bank accounts from the account numbers and passwords of the plurality of bank accounts to obtain the processed account numbers and passwords of the bank accounts;
and polling and inputting the processed account number and the password of the bank account to the corresponding position of the online bank login interface through a simulation keyboard, and trying to login to the online bank interface until login is successful.
7. The method for automatically downloading the running bill according to claim 1, wherein after the account summary and the transaction bill are downloaded into the corresponding folder based on the downloading program, the method further comprises:
loading a filling program, wherein the filling program runs through the robot process automation tool, and the filling program and the robot process automation tool are pre-stored in the system;
summarizing the account summary sheet and the transaction document in the folder through the filling program, and automatically generating a table in an Excel form;
logging in an enterprise database according to an account and a password of the enterprise database through the filling program, wherein the account and the password of the enterprise database are prestored in a Windows voucher of the system;
and uploading the table to the enterprise database through the filling program.
8. The method for automatically downloading the running bill according to any one of claims 4 to 6, wherein after the internet bank login interface is opened based on the downloading program, the method further comprises:
detecting whether the online bank login interface has an electronic key-driven update prompt;
and if the electronic key drives the update prompt, automatically clicking an update option based on the downloading program, and automatically downloading the updated driving program.
9. An apparatus for automatic downloading of a running bill, comprising:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-8.
10. A non-transitory computer storage medium for automatic downloading of a running bill, the medium storing computer-executable instructions configured to: the method of any one of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011596190.XA CN112712421B (en) | 2020-12-29 | 2020-12-29 | Method, equipment and storage medium for automatically downloading running bill |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011596190.XA CN112712421B (en) | 2020-12-29 | 2020-12-29 | Method, equipment and storage medium for automatically downloading running bill |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112712421A true CN112712421A (en) | 2021-04-27 |
| CN112712421B CN112712421B (en) | 2023-03-28 |
Family
ID=75546452
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011596190.XA Active CN112712421B (en) | 2020-12-29 | 2020-12-29 | Method, equipment and storage medium for automatically downloading running bill |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112712421B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113592441A (en) * | 2021-07-22 | 2021-11-02 | 深圳海智创科技有限公司 | RPA-based online bank intelligent management method, system and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101158905A (en) * | 2007-10-30 | 2008-04-09 | 上海华为技术有限公司 | Software downloading method and telecommunication apparatus |
| CN104933547A (en) * | 2015-05-27 | 2015-09-23 | 浪潮软件集团有限公司 | Data input method, device and system |
| CN109977389A (en) * | 2019-04-10 | 2019-07-05 | 鼎信信息科技有限责任公司 | List input method, device, computer equipment and storage medium |
| CN111144886A (en) * | 2019-12-17 | 2020-05-12 | 远光软件股份有限公司 | Automatic bank account-arriving record processing method, system, equipment and storage medium |
| CN111191097A (en) * | 2019-12-20 | 2020-05-22 | 天阳宏业科技股份有限公司 | Method, device and system for automatically acquiring webpage information by web crawler |
| CN111723138A (en) * | 2020-06-10 | 2020-09-29 | 山东浪潮新世纪科技有限公司 | System and method for automatically acquiring data in simulated manual mode |
| CN111798296A (en) * | 2020-06-15 | 2020-10-20 | 远光软件股份有限公司 | Automatic account checking method, automatic account checking device and computer readable storage medium |
-
2020
- 2020-12-29 CN CN202011596190.XA patent/CN112712421B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101158905A (en) * | 2007-10-30 | 2008-04-09 | 上海华为技术有限公司 | Software downloading method and telecommunication apparatus |
| CN104933547A (en) * | 2015-05-27 | 2015-09-23 | 浪潮软件集团有限公司 | Data input method, device and system |
| CN109977389A (en) * | 2019-04-10 | 2019-07-05 | 鼎信信息科技有限责任公司 | List input method, device, computer equipment and storage medium |
| CN111144886A (en) * | 2019-12-17 | 2020-05-12 | 远光软件股份有限公司 | Automatic bank account-arriving record processing method, system, equipment and storage medium |
| CN111191097A (en) * | 2019-12-20 | 2020-05-22 | 天阳宏业科技股份有限公司 | Method, device and system for automatically acquiring webpage information by web crawler |
| CN111723138A (en) * | 2020-06-10 | 2020-09-29 | 山东浪潮新世纪科技有限公司 | System and method for automatically acquiring data in simulated manual mode |
| CN111798296A (en) * | 2020-06-15 | 2020-10-20 | 远光软件股份有限公司 | Automatic account checking method, automatic account checking device and computer readable storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113592441A (en) * | 2021-07-22 | 2021-11-02 | 深圳海智创科技有限公司 | RPA-based online bank intelligent management method, system and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112712421B (en) | 2023-03-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI582616B (en) | Formatting data by example | |
| US9396279B1 (en) | Collaborative virtual markup | |
| CN106610774B (en) | Webpage table editing method and device | |
| CN104657274B (en) | software interface test method and device | |
| CN107451112B (en) | Form tool data checking method, device, terminal equipment and storage medium | |
| CN102707958A (en) | Open-platform-based interface generation checking method and equipment | |
| CN114610286A (en) | Development document generation method and device, computer equipment and storage medium | |
| CN112712421B (en) | Method, equipment and storage medium for automatically downloading running bill | |
| CN108874379B (en) | Page processing method and device | |
| JP4477531B2 (en) | Data import method and data import apparatus | |
| CN114385722A (en) | Interface attribute consistency checking method and device, electronic equipment and storage medium | |
| CN112379871A (en) | Data processing method and device | |
| CN111552648A (en) | Automatic verification method and system for application | |
| CN114493551B (en) | Contract generation method and device, electronic equipment and storage medium | |
| JP4215255B2 (en) | Degradation confirmation inspection method, degradation confirmation inspection system, and program therefor | |
| CN110673828A (en) | Product configuration method | |
| CN107092671B (en) | Method and equipment for managing meta information | |
| CN117897710A (en) | Artificial intelligence method for solving industrial data conversion problem | |
| CN113485689A (en) | Buried point processing method and device | |
| CN115437621A (en) | Process editing method and device based on robot process automation | |
| CN112364048A (en) | Data processing method and device, electronic equipment and computer storage medium | |
| Oehlmann et al. | Learning plan transformations from self-questions: A memory-based approach | |
| CN113781016B (en) | Method, system, equipment and storage medium for updating account information | |
| CN117608536B (en) | Gap data online template customization and supplementary recording system and method thereof | |
| CN111522737B (en) | Automatic test verification method and device for front-end interface and storage medium |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230309 Address after: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |