CN110597862A - Data entry method, equipment and system based on information system - Google Patents
Data entry method, equipment and system based on information system Download PDFInfo
- Publication number
- CN110597862A CN110597862A CN201910890668.0A CN201910890668A CN110597862A CN 110597862 A CN110597862 A CN 110597862A CN 201910890668 A CN201910890668 A CN 201910890668A CN 110597862 A CN110597862 A CN 110597862A
- Authority
- CN
- China
- Prior art keywords
- information
- data entry
- excel file
- module
- data
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The invention provides a data entry method based on an information system, data entry equipment based on the information system, a system, computer equipment and a computer readable storage medium, and relates to the technical field of data processing. The method comprises the following steps: acquiring query information input through an information system; forming an EXCEL file according to the query information; performing supplementary recording operation on the EXCEL file; and carrying out data verification on the EXCEL file after the additional recording operation so as to finish data entry. The invention solves the technical problems of low data entry efficiency and easy error of front-line practitioners, brings great convenience to the work of business personnel, can meet the requirement of reporting timeliness, and ensures the efficiency and quality of data entry.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a processing technology of information system data, and specifically relates to a data entry method based on an information system, data entry equipment based on the information system, computer equipment and a computer readable storage medium.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
At present, with the increasingly complex supervision environment of the financial industry, in order to meet the requirements of business compliance, each financial institution successively develops a collection and delivery system for client information, transaction information and account information. This information is in the hundreds of millions, as each customer may have multiple bank accounts, and each bank account may have tens or even hundreds of transactions during the delivery period.
In the prior art, bank workers carry out data correction and filling on a webpage according to a reporting interface of a supervision mechanism. Under the traditional webpage input mode, after a bank practitioner inquires out a customer to be filled in a delivery system, a single record is selected and clicked to enter a detail page, and filling is carried out item by item. Particularly, under the condition of lacking account information and transaction information, the operation of 'adding newly' is required for multiple times, and due to the fact that the account and transaction attributes are multiple, each new adding involves multiple input fields and the page display is complex, multiple page jumps and complex operations are limited to processing and inputting one by one, the difficulty of data inputting is increased, the efficiency and the quality of data inputting are difficult to guarantee, and the requirement of reporting timeliness is difficult to meet.
Therefore, how to provide a new solution, which can solve the above technical defects, is a technical problem to be solved in the art.
Disclosure of Invention
In view of the above, the present invention provides an information system-based data entry method, an information system-based data entry device, an information system, a computer device, and a computer-readable storage medium, in which query information is first obtained, a customer list, account information, and transaction information are queried according to the query information to form an EXCEL file, and data is checked after an EXCEL file entry operation to complete data entry, so that technical problems of low data entry efficiency and easy error of front-line workers are solved, great convenience is provided for the workers, the requirement of reporting timeliness can be met, and the efficiency and quality of data entry are ensured.
In order to achieve the above object, the present invention provides a data entry method based on an information system, the method comprising:
acquiring query information input through an information system;
forming an EXCEL file according to the query information;
performing supplementary recording operation on the EXCEL file;
and carrying out data verification on the EXCEL file after the additional recording operation so as to finish data entry.
In a preferred embodiment of the present invention, the additional recording operation includes adding and/or deleting and/or modifying at least one of the customer information, the account information, and the transaction information.
In a preferred embodiment of the present invention, forming the EXCEL file according to the query information includes:
inquiring a client list to be filled according to the inquiry information;
querying account information and transaction information associated with the customer;
and exporting the customer list, the account information and the transaction information to form an EXCEL file.
In a preferred embodiment of the present invention, the data verification of the EXCEL file after the completion of the entry operation to complete the data entry includes:
verifying the accuracy and the integrity of the EXCEL file after the additional recording operation to obtain a verification result;
and performing data entry according to the verification result.
In a preferred embodiment of the present invention, the data entry according to the verification result comprises:
when the verification result shows that the EXCEL file passes verification, saving the EXCEL file;
and loading the EXCEL file.
In a preferred embodiment of the present invention, the data entry according to the verification result comprises:
and when the verification result shows that the EXCEL file fails to be verified, generating an exception report, wherein the exception report is used for displaying prompt information.
One of the objects of the present invention is to provide a data entry device based on an information system, comprising:
the query information acquisition module is used for acquiring query information;
the file forming module is used for forming an EXCEL file according to the query information;
the file additional recording module is used for performing additional recording operation on the EXCEL file;
and the data checking module is used for carrying out data checking on the EXCEL file after the additional entry operation so as to finish data entry.
In a preferred embodiment of the present invention, the document forming module includes:
the client list query module is used for querying a client list to be filled according to the query information;
the related information inquiry module is used for inquiring account information and transaction information related to the client;
and the data export module is used for exporting the customer list, the account information and the transaction information to form an EXCEL file.
In a preferred embodiment of the present invention, the data verification module includes:
the verification result determining module is used for verifying the accuracy and the integrity of the EXCEL file after the additional recording operation to obtain a verification result;
and the data entry module is used for carrying out data entry according to the verification result.
In a preferred embodiment of the invention, the data entry module comprises:
the file storage module is used for storing the EXCEL file when the verification result shows that the EXCEL file passes the verification;
and the file loading module is used for loading the EXCEL file.
In a preferred embodiment of the invention, the data entry module comprises:
and the exception report generating module is used for generating an exception report when the verification result shows that the EXCEL file fails to be verified, wherein the exception report is used for displaying prompt information.
One of the objects of the present invention is to provide an information system comprising an information system based data entry device.
One of the objects of the present invention is to provide a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing a method for data entry based on an information system when executing the computer program.
One of the objects of the present invention is to provide a computer-readable storage medium storing a program for executing a data entry method based on an information system.
The invention has the advantages that the invention provides the data entry method based on the information system, the data entry equipment based on the information system, the computer equipment and the computer readable storage medium, firstly, the query information is obtained, the customer list, the account information and the transaction information are queried according to the query information to form the EXCEL file, and the data entry is completed by carrying out data verification after the entry supplementing operation of the EXCEL file, so that the technical problems of low data entry efficiency and easy error of front-line practitioners are solved, the great convenience is brought to the work of business personnel, the requirement of reporting timeliness can be met, and the efficiency and the quality of data entry are ensured.
In order to make the aforementioned and other objects, features and advantages of the invention comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic structural diagram of a data entry device based on an information system according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a file forming module in the data entry device based on the information system according to the embodiment of the present invention;
fig. 3 is a schematic structural diagram of a data verification module in an information system-based data entry device according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a first implementation manner of a data loading module in an information system-based data entry device according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a second implementation manner of a data loading module in an information system-based data entry device according to an embodiment of the present invention;
fig. 6 is a flowchart of a data entry method based on an information system according to an embodiment of the present invention;
fig. 7 is a flowchart of step S102 in fig. 6;
fig. 8 is a flowchart of step S104 in fig. 6;
FIG. 9 is a flowchart of a first embodiment of step S302 in FIG. 8;
fig. 10 is a flowchart of a second embodiment of step S302 in fig. 8;
fig. 11 is a schematic flow chart of data entry according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention.
As will be appreciated by one skilled in the art, embodiments of the present invention may be embodied as a system, apparatus, method or computer program product. Accordingly, the present disclosure may be embodied in the form of: entirely hardware, entirely software (including firmware, resident software, micro-code, etc.), or a combination of hardware and software.
In the prior art, with the increasing complexity of banking supervision environments, in order to meet the requirements of business compliance, financial institutions have developed acquisition and delivery systems for client information, transaction information and account information in succession. The number of the information is hundreds of millions, the traditional online input mode is limited to processing and inputting one by one, a large amount of manpower is consumed, the efficiency is low, and the requirement on the timeliness of the report is difficult to meet.
Based on the information system, the invention provides the information system which comprises an information system body and data entry equipment based on the information system. In the present invention, the information system body refers to all the components of the information system in the prior art. The following description focuses on an information system provided by the present invention comprising a data entry device based on an information system. The invention provides a rapid processing scheme for batch data entry based on the export and import functions of EXCEL.
Fig. 1 is a schematic structural diagram of a data entry device based on an information system according to an embodiment of the present invention, please refer to fig. 1, where the device includes:
the query information obtaining module 100 is configured to obtain query information.
In one embodiment of the invention, the practitioner may enter the query conditions through an information system.
And the file forming module 200 is configured to form an EXCEL file according to the query information.
Fig. 2 is a schematic structural diagram of a file forming module 200 according to an embodiment of the present invention, please refer to fig. 2, where the file forming module 200 includes:
a client list query module 210, configured to query a client list to be filled according to the query information;
an associated information query module 220 for querying account information and transaction information associated with the customer;
and the data export module 230 is used for exporting the customer list, the account information and the transaction information to form an EXCEL file.
That is, in an embodiment of the present invention, after the practitioner inputs the query information, the practitioner queries the customer list to be filled, checks the customer records to be filled, and exports the customer records to the EXCEL file together with the account information and the transaction information existing in the system queried in association, and if not, exports all the customer records by default.
Referring to fig. 1, the data entry device further includes:
and the file additional recording module 300 is configured to perform additional recording operation on the EXCEL file.
In one embodiment of the invention, the additional recording operation comprises adding operation and/or deleting operation and/or modifying operation on at least one of the customer information, the account information and the transaction information.
And the data checking module 400 is configured to perform data checking on the EXCEL file after the entry supplementing operation to complete data entry.
Fig. 3 is a schematic structural diagram of a data checking module 400 according to an embodiment of the present invention, please refer to fig. 3, in which the data checking module 400 includes:
the verification result determining module 410 is configured to verify the accuracy and integrity of the EXCEL file after the additional entry operation to obtain a verification result;
and the data entry module 420 is configured to perform data entry according to the verification result.
In one embodiment of the invention, the EXCEL file with completed entry is imported into the system for subsequent approval process.
Fig. 4 is a schematic structural diagram of a first implementation manner of the data entry module 420 in the embodiment of the present invention, please refer to fig. 4, in the first implementation manner of the present invention, the data entry module 420 includes:
the file saving module 421, configured to save the EXCEL file when the verification result shows that the EXCEL file passes the verification;
and the file loading module 422 is configured to load the EXCEL file.
Fig. 5 is a schematic structural diagram of a second implementation manner of the data entry module 420 in the embodiment of the present invention, please refer to fig. 5, in the second implementation manner of the present invention, the data entry module 420 further includes:
an exception report generating module 423, configured to generate an exception report when the check result shows that the EXCEL file fails to be checked, where the exception report is used to display a prompt message.
That is, in the invention, the equipment checks the accuracy and integrity of the data, and the data passing the check is recorded; and automatically generating an exception report for the data which cannot pass the verification, modifying the data according to the prompt information, and then performing import operation.
The invention provides a data entry system and equipment based on an information system, which are characterized in that query information is firstly obtained, a client list, account information and transaction information are queried according to the query information to form an EXCEL file, and the data entry is completed by carrying out data verification after the entry supplementing operation of the EXCEL file, so that the technical problems of low data entry efficiency and high possibility of errors of front-line workers are solved, great convenience is brought to the work of business workers, the requirement of reporting timeliness can be met, and the efficiency and the quality of data entry are guaranteed.
Furthermore, although in the above detailed description several unit modules of the system are mentioned, this division is not mandatory only. Indeed, the features and functions of two or more of the units described above may be embodied in one unit, according to embodiments of the invention. Also, the features and functions of one unit described above may be further divided into embodiments by a plurality of units. The terms "module" and "unit" used above may be software and/or hardware that realizes a predetermined function. While the modules described in the following embodiments are preferably implemented in software, implementations in hardware, or a combination of software and hardware are also possible and contemplated.
Having described the system, apparatus and method for information system based data entry of exemplary embodiments of the present invention, a method of exemplary embodiments of the present invention is described with reference to the accompanying drawings. The implementation of the method can be referred to the above overall implementation, and repeated details are not repeated.
In the prior art, each customer may have a plurality of bank accounts, and each bank account may have tens of transactions or even hundreds of transactions in the delivery period, and a bank customer manager corrects and fills data on a webpage according to a delivery interface of a regulatory mechanism, so that multiple page jumps and complicated operations are involved, and the efficiency and quality of data entry are difficult to ensure. The invention perfectly integrates the EXCEL and the banking reporting system by means of the strong data processing capacity of the office software EXCEL, thereby enhancing the quality guarantee and efficiency of data entry.
Based on the above, the invention provides a data entry method based on an information system, which makes full use of the powerful data processing capacity of EXCEL to perform data entry, and then performs authorization approval after the data entry.
Specifically, fig. 6 is a schematic flow chart of a data entry method based on an information system according to an embodiment of the present invention, please refer to fig. 6, where the method includes:
s101: query information input through an information system is acquired.
In one embodiment of the invention, the practitioner may enter the query conditions through an information system.
S102: and forming an EXCEL file according to the query information.
Fig. 7 is a schematic flowchart of step S102, please refer to fig. 7, which includes:
s201: inquiring a client list to be filled according to the inquiry information;
s202: querying account information and transaction information associated with the customer;
s203: and exporting the customer list, the account information and the transaction information to form an EXCEL file.
That is, in an embodiment of the present invention, after the practitioner inputs the query information, the practitioner queries the customer list to be filled, checks the customer records to be filled, and exports the customer records to the EXCEL file together with the account information and the transaction information existing in the system queried in association, and if not, exports all the customer records by default.
Referring to fig. 6, the data entry method further includes:
s103: and performing supplementary recording operation on the EXCEL file.
In one embodiment of the invention, the additional recording operation comprises adding operation and/or deleting operation and/or modifying operation on at least one of the customer information, the account information and the transaction information.
S104: and carrying out data verification on the EXCEL file after the additional recording operation so as to finish data entry.
Fig. 8 is a flowchart illustrating step S104 according to an embodiment of the present invention, referring to fig. 8, the step includes:
s301: verifying the accuracy and the integrity of the EXCEL file after the additional recording operation to obtain a verification result;
s302: and performing data entry according to the verification result.
In one embodiment of the invention, the EXCEL file with completed entry is imported into the system for subsequent approval process.
Fig. 9 is a flowchart illustrating a first implementation manner of step S302 according to an embodiment of the present invention, referring to fig. 9, in the first implementation manner of the present invention, the step includes:
s401: when the verification result shows that the EXCEL file passes verification, saving the EXCEL file;
s402: and loading the EXCEL file.
Fig. 10 is a flowchart illustrating a second implementation manner of step S302 according to an embodiment of the present invention, referring to fig. 10, in the second implementation manner of the present invention, the step further includes:
s501: when the verification result shows that the EXCEL file fails to be verified, generating an exception report;
s502: the exception report displays a prompt message.
That is, in the invention, the equipment checks the accuracy and integrity of the data, and the data passing the check is recorded; and automatically generating an exception report for the data which cannot pass the verification, modifying the data according to the prompt information, and then performing import operation.
The data entry method based on the information system, provided by the invention, comprises the steps of firstly obtaining query information, querying a client list, account information and transaction information according to the query information to form an EXCEL file, and verifying data after the EXCEL file is subjected to additional entry operation to complete data entry, so that the technical problems of low data entry efficiency and high possibility of errors of front-line workers are solved, great convenience is brought to the work of business workers, the requirement of reporting timeliness can be met, and the efficiency and the quality of data entry are guaranteed.
The invention also provides computer equipment which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor executes the computer program to realize the data entry method based on the information system.
The invention also provides a computer readable storage medium storing a program for executing the data entry method based on the information system.
It should be noted that while the operations of the method of the present invention are depicted in the drawings in a particular order, this does not require or imply that the operations must be performed in this particular order, or that all of the illustrated operations must be performed, to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step execution, and/or one step broken down into multiple step executions. Having described exemplary embodiments of the present invention, a system of exemplary embodiments of the present invention will now be described with reference to the accompanying drawings. The implementation of the system can be referred to the above overall implementation, and repeated details are not repeated.
The technical solution of the present invention will be described in detail with reference to specific examples.
In the financial field, in order to meet the requirements of business compliance, various organizations have successively developed collecting and reporting systems for customer information, transaction information, and account information. In the prior art, bank workers carry out data correction and filling on a webpage according to a reporting interface of a supervision mechanism. Under the traditional webpage input mode, after a bank practitioner inquires out a customer to be filled in a delivery system, a single record is selected and clicked to enter a detail page, and filling is carried out item by item. Particularly, under the condition of lacking account information and transaction information, the operation of 'adding newly' is required for multiple times, and due to the fact that the account and transaction attributes are multiple, each new adding involves multiple input fields and the page display is complex, multiple page jumps and complex operations are limited to processing and inputting one by one, the difficulty of data inputting is increased, the efficiency and the quality of data inputting are difficult to guarantee, and the requirement of reporting timeliness is difficult to meet.
Fig. 11 is a schematic flow chart of data entry in an embodiment provided by the present invention, please refer to fig. 11, where the flow of data entry in the embodiment includes:
s1: and (5) information query.
And inputting a retrieval condition to inquire out a client list to be filled.
S2: and (4) information is exported.
Checking customer records to be filled, and exporting the customer records to an EXCEL file together with the existing account information and transaction information in the system inquired in a correlation mode; if not, all client records are exported by default.
S3: and (5) information entry.
In EXCEL, operations such as addition, deletion, and modification of customer information, account information, and transaction information are performed.
S4: and (4) importing information.
And importing the EXCEL file subjected to the additional recording into a reporting system for subsequent approval process.
S5: data verification
The reporting system checks the accuracy and integrity of the data, and the data passing the check is recorded into the reporting system; and for the data which cannot pass the verification, automatically generating an exception report by the system, modifying the data according to the prompt information, and then carrying out import operation.
Through full branch investigation and demonstration, the invention can practically solve the technical problems of low data entry efficiency and easy error of first-line service personnel in the aspect of supervising the entry of the report data.
In summary, the present invention provides an information system-based data entry method, an information system-based data entry device, an information system, a computer device, and a computer-readable storage medium, in which a practitioner first obtains query information, queries a customer list, account information, and transaction information according to the query information to form an EXCEL file, and performs data verification after performing entry supplementing operation on the EXCEL file to complete data entry, so as to solve the technical problems of low data entry efficiency and easy error of a front-line practitioner, thereby providing great convenience to the work of a service worker, satisfying the requirement of reporting timeliness, and ensuring the efficiency and quality of data entry.
Improvements to a technology can clearly be distinguished between hardware improvements (e.g. improvements to the circuit structure of diodes, transistors, switches, etc.) and software improvements (improvements to the process flow). However, as technology advances, many of today's process flow improvements have been seen as direct improvements in hardware circuit architecture. Designers almost always obtain the corresponding hardware circuit structure by programming an improved method flow into the hardware circuit.
Thus, it cannot be said that an improvement in the process flow cannot be realized by hardware physical modules. For example, a Programmable Logic Device (PLD), such as a Field Programmable Gate Array (FPGA), is an integrated circuit whose Logic functions are determined by programming the Device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Furthermore, nowadays, instead of manually making an integrated Circuit chip, such Programming is often implemented by "logic compiler" software, which is similar to a software compiler used in program development and writing, but the original code before compiling is also written by a specific Programming Language, which is called Hardware Description Language (HDL), and HDL is not only one but many, such as abel (advanced Boolean Expression Language), ahdl (alternate Language Description Language), traffic, pl (core unified Programming Language), HDCal, JHDL (Java Hardware Description Language), langue, Lola, HDL, laspam, hardsradware (Hardware Description Language), vhjhd (Hardware Description Language), and vhigh-Language, which are currently used in most popular applications.
It will also be apparent to those skilled in the art that hardware circuitry that implements the logical method flows can be readily obtained by merely slightly programming the method flows into an integrated circuit using the hardware description languages described above.
The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer-readable medium storing computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, and an embedded microcontroller, examples of which include, but are not limited to, the following microcontrollers: ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic for the memory.
Those skilled in the art will also appreciate that, in addition to implementing the controller as pure computer readable program code, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may thus be considered a hardware component, and the means included therein for performing the various functions may also be considered as a structure within the hardware component. Or even means for performing the functions may be regarded as being both a software module for performing the method and a structure within a hardware component.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functionality of the units may be implemented in one or more software and/or hardware when implementing the present application.
From the above description of the embodiments, it is clear to those skilled in the art that the present application can be implemented by software plus necessary general hardware platform. Based on such understanding, the technical solutions of the present application may be essentially or partially implemented in the form of software products, which may be stored in a storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and include instructions for causing a computer system (which may be a personal computer, a server, or a network system, etc.) to execute the methods described in the embodiments or some parts of the embodiments of the present application.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The application is operational with numerous general purpose or special purpose computing system environments or configurations. For example: personal computers, server computers, hand-held or portable systems, tablet-type systems, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics systems, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or systems, and the like.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing systems that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage systems.
While the present application has been described with examples, those skilled in the art will appreciate that there are numerous variations and permutations of the present application without departing from the spirit of the application, and it is intended that the appended claims encompass such variations and modifications as fall within the true spirit of the application.
Claims (15)
1. A data entry method based on an information system, the method comprising:
acquiring query information input through an information system;
forming an EXCEL file according to the query information;
performing supplementary recording operation on the EXCEL file;
and carrying out data verification on the EXCEL file after the additional recording operation so as to finish data entry.
2. The method of claim 1, wherein forming an EXCEL file from the query information comprises:
inquiring a client list to be filled according to the inquiry information;
querying account information and transaction information associated with the customer;
and exporting the customer list, the account information and the transaction information to form an EXCEL file.
3. The method of claim 2, wherein the subsidy operation comprises an add operation and/or a delete operation and/or a modify operation on at least one of the customer information, account information, and transaction information.
4. The method of claim 3, wherein data checking the EXCEL file after the completion of the data entry comprises:
verifying the accuracy and the integrity of the EXCEL file after the additional recording operation to obtain a verification result;
and performing data entry according to the verification result.
5. The method of claim 4, wherein entering data according to the verification result comprises:
when the verification result shows that the EXCEL file passes verification, saving the EXCEL file;
and loading the EXCEL file.
6. The method of claim 4, wherein entering data according to the verification result comprises:
and when the verification result shows that the EXCEL file fails to be verified, generating an exception report, wherein the exception report is used for displaying prompt information.
7. An information system based data entry device, the device comprising:
the query information acquisition module is used for acquiring query information;
the file forming module is used for forming an EXCEL file according to the query information;
the file additional recording module is used for performing additional recording operation on the EXCEL file;
and the data checking module is used for carrying out data checking on the EXCEL file after the additional entry operation so as to finish data entry.
8. The apparatus of claim 7, wherein the document formation module comprises:
the client list query module is used for querying a client list to be filled according to the query information;
the related information inquiry module is used for inquiring account information and transaction information related to the client;
and the data export module is used for exporting the customer list, the account information and the transaction information to form an EXCEL file.
9. The apparatus of claim 8, wherein the subsidy operation comprises an add operation and/or a delete operation and/or a modify operation on at least one of the customer information, account information, and transaction information.
10. The apparatus of claim 9, wherein the data verification module comprises:
the verification result determining module is used for verifying the accuracy and the integrity of the EXCEL file after the additional recording operation to obtain a verification result;
and the data entry module is used for carrying out data entry according to the verification result.
11. The apparatus of claim 10, wherein the data entry module comprises:
the file storage module is used for storing the EXCEL file when the verification result shows that the EXCEL file passes the verification;
and the file loading module is used for loading the EXCEL file.
12. The apparatus of claim 10, wherein the data entry module comprises:
and the exception report generating module is used for generating an exception report when the verification result shows that the EXCEL file fails to be verified, wherein the exception report is used for displaying prompt information.
13. An information system, characterized in that the information system comprises an information system based data entry device according to any of claims 7 to 12.
14. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the information system based data entry method according to any of claims 1 to 6 when executing the computer program.
15. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a data entry method based on an information system, which executes the method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910890668.0A CN110597862A (en) | 2019-09-20 | 2019-09-20 | Data entry method, equipment and system based on information system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910890668.0A CN110597862A (en) | 2019-09-20 | 2019-09-20 | Data entry method, equipment and system based on information system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110597862A true CN110597862A (en) | 2019-12-20 |
Family
ID=68861734
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910890668.0A Pending CN110597862A (en) | 2019-09-20 | 2019-09-20 | Data entry method, equipment and system based on information system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110597862A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112348563B (en) * | 2020-09-27 | 2024-04-26 | 北京淇瑀信息科技有限公司 | Computer-aided resource release management method and platform for preventing forgetting to enter |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101610291A (en) * | 2009-08-06 | 2009-12-23 | 杭州高达软件系统有限公司 | Data uploading method, method for down loading and system based on third party's platform |
| CN102456051A (en) * | 2010-10-27 | 2012-05-16 | 北京大学 | Methods and devices for importing/exporting database data |
| CN102760267A (en) * | 2012-06-12 | 2012-10-31 | 东莞市尚睿电子商务有限公司 | ERP (enterprise resource planning) electronic commerce system and using method thereof |
| US20130080298A1 (en) * | 2011-09-23 | 2013-03-28 | Deborah A. Latulipe | System and method for processing a financial account |
| CN106294400A (en) * | 2015-05-21 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The introduction method of batch data and system |
| CN107222589A (en) * | 2017-07-24 | 2017-09-29 | 南京国电南自维美德自动化有限公司 | A kind of embedded equipment I P address batch modification method and system of identical IP |
| CN108495181A (en) * | 2018-03-28 | 2018-09-04 | 深圳创维－Rgb电子有限公司 | The quick editor's method, apparatus and computer readable storage medium of program |
| CN108921698A (en) * | 2018-07-03 | 2018-11-30 | 中国银行股份有限公司 | Branch's amended record method and system based on global integration core banking system |
-
2019
- 2019-09-20 CN CN201910890668.0A patent/CN110597862A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101610291A (en) * | 2009-08-06 | 2009-12-23 | 杭州高达软件系统有限公司 | Data uploading method, method for down loading and system based on third party's platform |
| CN102456051A (en) * | 2010-10-27 | 2012-05-16 | 北京大学 | Methods and devices for importing/exporting database data |
| US20130080298A1 (en) * | 2011-09-23 | 2013-03-28 | Deborah A. Latulipe | System and method for processing a financial account |
| CN102760267A (en) * | 2012-06-12 | 2012-10-31 | 东莞市尚睿电子商务有限公司 | ERP (enterprise resource planning) electronic commerce system and using method thereof |
| CN106294400A (en) * | 2015-05-21 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The introduction method of batch data and system |
| CN107222589A (en) * | 2017-07-24 | 2017-09-29 | 南京国电南自维美德自动化有限公司 | A kind of embedded equipment I P address batch modification method and system of identical IP |
| CN108495181A (en) * | 2018-03-28 | 2018-09-04 | 深圳创维－Rgb电子有限公司 | The quick editor's method, apparatus and computer readable storage medium of program |
| CN108921698A (en) * | 2018-07-03 | 2018-11-30 | 中国银行股份有限公司 | Branch's amended record method and system based on global integration core banking system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112348563B (en) * | 2020-09-27 | 2024-04-26 | 北京淇瑀信息科技有限公司 | Computer-aided resource release management method and platform for preventing forgetting to enter |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9524230B2 (en) | Testing coordinator | |
| US9898280B2 (en) | Automatic code review and code reviewer recommendation | |
| US8156137B2 (en) | Data processing systems and methods | |
| CN103577168A (en) | Test case creation system and method | |
| US20100229052A1 (en) | Resolving asynchronous validation errors | |
| CN111858371A (en) | Software testing method, system, storage medium and computer equipment | |
| CN109284225A (en) | A kind of quality determining method and electronic equipment of multi-person synergy exploitation programming code | |
| US8839251B2 (en) | Automating sequential cross-application data transfer operations | |
| CN110336814A (en) | A kind of analytic method, equipment and the system of SWIFT message | |
| CN113326247A (en) | Cloud data migration method and device and electronic equipment | |
| EP2199905A1 (en) | Lifecycle management and consistency checking of object models using application platform tools | |
| CN109472680A (en) | A kind of accounting processing method and system | |
| CN110618873A (en) | Data locking method, equipment and system based on information system | |
| CN109885290B (en) | Application program service description information generation and release method, device and storage medium | |
| CN110597862A (en) | Data entry method, equipment and system based on information system | |
| CN114253516A (en) | UI (user interface) development method and device for data filling system and storage medium | |
| US11567961B2 (en) | Using flat data input for simultaneous application of multiple separate calculations rule sets to obtain multiple output results | |
| CN111914002B (en) | Machine room resource information processing method and device and electronic equipment | |
| CN115080433A (en) | Testing method and device based on flow playback | |
| CN112330502A (en) | Contract auditing method and device, electronic equipment and storage medium | |
| CN109697141B (en) | Method and device for visual testing | |
| CN112596781A (en) | Service execution and service configuration method and device | |
| CN106528718B (en) | Method and apparatus for processing data from third party | |
| CN113342681A (en) | Regression testing method and device | |
| CN114490580A (en) | Configurable data migration method and apparatus executed by automation script |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191220 |