CN111859876A - Automatic form entering method and system - Google Patents
Automatic form entering method and system Download PDFInfo
- Publication number
- CN111859876A CN111859876A CN201910320980.6A CN201910320980A CN111859876A CN 111859876 A CN111859876 A CN 111859876A CN 201910320980 A CN201910320980 A CN 201910320980A CN 111859876 A CN111859876 A CN 111859876A
- Authority
- CN
- China
- Prior art keywords
- attribute
- data
- unit
- attribute value
- entry
- 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
Images
Abstract
The invention relates to a form automatic entry method and a system, and the method can avoid a target symbol; through the analysis of the table, all attribute values of the attribute names possibly corresponding to the preset system rules are collected in the data source, the input positions of the attribute values are determined, meanwhile, the attribute values corresponding to the attributes are searched in the data source, and all the attribute values are listed; if only one attribute value is listed or a certain attribute value can be determined, the attribute value is entered, and automatic entry of the form is completed; if a certain item of the plurality of attribute values cannot be determined, all possible attribute values are listed and the user selects and enters the item. The invention automatically collects information in the data source and effectively improves the working efficiency.
Description
Technical Field
The invention relates to the technical field of information processing, in particular to a method and a system for automatically inputting a form.
Background
Many of the people's work is to enter data, and the data is often repetitive, so that it takes a lot of time for people to repeat the low-level work. In an increasingly mobile environment, data entry is often inconvenient, the damage to people from computers is very serious, memory is reduced, negative effects on health caused by manual computer entry are very large compared with manual form filling, and meanwhile manual entry is slow and easy to fatigue. In the prior art, some data entry methods are proposed, and target symbols need to be added manually, so that the invention designs a method and a system for automatically entering data on a PC (personal computer) end, a mobile end, a webpage and the like without depending on the target symbols.
Disclosure of Invention
The invention aims to solve the technical problem of providing a method and a system for automatically inputting a form aiming at the defect that the prior art needs to manually input target symbols.
Scheme set 1: the present scheme set provides a method and system for real-time, automatic data entry of forms,
the technical scheme for solving the technical problems is as follows:
a real-time form automatic entry method comprises the following steps:
step 1: opening a form document to be entered, searching for empty cells in the form document, determining the corresponding relation between the attribute name and the empty cells, and determining the entry position of data to be entered;
step 2: analyzing the attribute name, and determining a uniform attribute identifier corresponding to the attribute name;
and step 3: collecting data in a data source, acquiring all possible attribute values corresponding to the attribute identification under a preset system rule, and listing all the attribute values;
and 4, step 4: if only one attribute value is listed or it can be determined that a certain attribute value meets the system rule of the attribute identifier, the attribute value is entered at the entry position of the data to be entered, and automatic entry of the form is completed; if one item of the plurality of items of attribute values cannot be determined, listing all possible attribute values, prompting the user to select, and entering according to the method after the user selects.
The invention has the beneficial effects that: the automatic form entry method is different from the methods that image data are identified by an artificial intelligence technology, the identified images are converted into texts to be entered into a database and the like, and the automatic form entry method can be suitable for various different working environments such as a PC (personal computer) end, a mobile end, a webpage and the like, does not need to memorize a large amount of data, avoids repeated low-level work, saves working time, has high entry speed and high accuracy, greatly reduces the error rate of manual entry, improves the working efficiency, greatly reduces the negative influence of computer entry on human health, is suitable for general popularization, and does not need to manually enter target symbols.
According to another aspect of the present invention, an automatic form entry system is provided, which includes a collecting unit, a searching unit, a processing unit, an attribute name and empty cell correspondence determining unit, and an entry unit;
the searching unit is used for searching the attribute name in the document to be input and transmitting the attribute name to the processing unit;
the acquisition unit is used for acquiring all possible attribute values corresponding to the attribute identification in a given data source;
the attribute name and empty cell corresponding relation determining unit is used for determining the corresponding relation between the attribute identifier and the empty cell according to the position relation between the attribute name and the empty cell in the collected document;
The processing unit is used for analyzing the attribute name, determining an attribute identifier, transferring the attribute identifier to the acquisition unit, acquiring all attribute values by the acquisition unit, and listing all the attribute values;
the entry unit is used for entering an attribute value, and if the attribute value listed by the processing unit has only one item or the information of a certain attribute value can be determined to accord with the system rule of the attribute name, the attribute value is entered at the empty cell position corresponding to the attribute name; and the attribute value is further used for entering the attribute value according to the selection of the user if the condition that all the possible attribute values are listed as one of the plurality of attribute values cannot be determined.
The system rule can be used for eliminating the wrong attribute value, or can determine the attribute value by using a priority value sorting method, and the system rule can be a set default value, a certain priority value, a maximum value of the composite score, and the like.
In the present invention, the attribute name refers to a name appearing in the form, such as a birth date and a birth date, which have multiple writing methods according to the preference of the form writer, the attribute identifier is a unified identifier, such as a specification of "birth date", and the attribute value refers to corresponding specific information, such as 4/8/2000. The system may establish a correspondence between the attribute name and the attribute identification.
The invention has the beneficial effects that: the automatic form entry system can automatically obtain data from various data sources without people, avoids using eyes to use a brain, is suitable for various different working environments such as a PC (personal computer) end, a mobile end, a webpage and the like, does not need to memorize a large amount of data, avoids repeated low-level work, saves working time, improves working efficiency, greatly reduces the negative influence of computer entry on human health, is suitable for general popularization, and can be used for not adding target symbols into documents.
Scheme set 2: scheme 1 relies on collecting data and has a wide selection range, which is likely not necessarily the correct attribute value, and storing the selected attribute value for the next entry will improve accuracy.
Further on the basis of scheme 1: the step 4 is followed by the following steps:
and 5: storing the corresponding relation between the data attribute identifier selected in the step 4 and the selected attribute value into a storage unit, wherein the storage unit also serves as a data source;
according to another aspect of the present disclosure, an automatic form entry system is provided, which includes a storage unit for storing a corresponding relationship between a selected data attribute identifier and an attribute value, based on the system of the scheme 1;
Therefore, the system can use correct options next time, the accuracy is improved, and the storage unit can be a solid or a virtual storage unit, such as a file, a database and a storage space.
Preferably, when the data source is selected, the data source in the storage unit is taken as a preference, which is beneficial to improving the accuracy.
Preferably, the data source in the storage unit is provided with a priority value, and as the number of determinations in step 4 increases, the priority value increases, which is a factor that affects the sorting priority at the time of entry.
Alternatively, the correspondence between the entered data attribute identification and the selected attribute value may be manually entered in the storage unit. This makes up for the shortfall in the electronic data source information.
Scheme set 3: on the basis of any one of the above schemes, the entry system contains preprocessing information, and the step 4 further includes preprocessing the attribute identifier and the attribute value respectively according to a preset preprocessing rule.
For example, the preset preprocessing rule may include a conditional filtering rule, an ordering rule, a format rule, and the like.
According to another aspect of the present invention, there is provided an automatic form entry system, further comprising, based on any one of the above schemes: the device also comprises a pretreatment unit;
The preprocessing unit is used for respectively preprocessing the attribute identification and the attribute value according to a preset preprocessing rule.
For example, the preset preprocessing rule may include a conditional filtering rule, an ordering rule, a format rule, and the like.
The source of these rules may be the system itself or may be designed for a document.
The beneficial effects of the further scheme are as follows: the attribute identification and the attribute value are respectively preprocessed through the preprocessing unit, so that the attribute identification and the attribute value can be conveniently and quickly searched, and data information meeting the requirements of users can be conveniently and accurately input.
Scheme set 4: scheme 1 relies on the data collection, contains data information in many tables, and this scheme is further on scheme 1's basis: the step 3 further comprises the following steps:
step 31: and acquiring data in a data source with a table, and determining the corresponding relation between the attribute identification and the attribute value according to the data type and the position relation and the corresponding relation of the data information in the acquired document.
According to another aspect of the present disclosure, on the basis of the system in scheme 1, the collection unit further includes an attribute name and attribute value corresponding relationship determination unit, where the attribute name and attribute value corresponding relationship determination unit is configured to determine a corresponding relationship between the attribute identifier and the attribute value according to a position relationship and a corresponding relationship of the attribute name and the attribute value in the collected document.
The beneficial effects of the above further scheme are as follows: in the data type and data information acquisition process, the corresponding relation determining unit determines the corresponding relation between the attribute identification and the attribute value, so that the corresponding attribute identification and the attribute value are conveniently distributed, and a database with one-to-one corresponding relation between the attribute identification and the attribute value is conveniently established subsequently.
Scheme set 5: the information which needs to be input frequently is also personal information, selected information is stored in the scheme set 2, the information sometimes needs to be kept secret, and data in the storage unit is encrypted according to preset rules on the basis of the scheme set 2, wherein the encryption and decryption methods comprise a symmetric encryption and decryption method and/or an asymmetric encryption and decryption method.
According to another aspect of the present disclosure, there is provided an automatic form entry system, further comprising: the encryption and decryption unit is used for encrypting and decrypting the attribute values.
The beneficial effects of the further scheme are as follows: the encryption and decryption unit is used for carrying out encryption and decryption processing on the attribute value with the confidentiality requirement, so that the data security can be improved, and important data information can be prevented from being stolen.
The additional limitations in the preferred embodiments of the present invention, other than the dependency relationships indicated in the drawings, are independent of each other and can be freely combined, and in order to reduce the space, the combination is not always enumerated. The scheme adopts relatively concise description, and a plurality of functions can be added on the basis of the scheme. Some methods and apparatuses in the above schemes may also be modified, for example, the storage unit may be composed of multiple units, data is stored in various places in a distributed manner, or data is divided for convenience and security. Some of the above sequences can be exchanged without affecting the functions, and further steps and devices can be inserted into the above steps and devices, such as steps of relaying, compressing, relaying, converting, duplicate checking, verifying, manually confirming and processing. The data and information in the above scheme may also be converted, for example, the data is dispersed, symbolized, encrypted, scrambled in sequence, added with redundancy, etc., as long as the final one-to-one correspondence relationship of the information can be established. The method and the system can be applied to independent software, can also be integrated in an operating system, word processing software, browsing software, office software and communication software as a module, and can also be a plug-in.
Drawings
FIG. 1 is a schematic flow chart of a method for automatically entering a form according to the present invention;
FIG. 2 is a schematic structural diagram of an automatic form entry system according to the present invention;
FIG. 3 is a schematic structural diagram of another automatic form entry system of the present invention.
In the drawings, the components represented by the respective reference numerals are listed below:
10. the device comprises a collecting unit, 20, a searching unit, 30, a processing unit, 40, an entry unit, 50, a collecting unit, 101, an attribute name and attribute value corresponding relation determining unit, 301, a preprocessing unit, 501 and an encryption and decryption unit.
Detailed Description
It should be noted that other arrangements of the present technology will become readily apparent to those skilled in the art from the following detailed description, wherein various arrangements (or alternatives) of the present technology are shown and described by way of illustration. The present technology is capable of other different arrangements (or alternatives) and its several details are capable of modification in various respects, all without departing from the scope of the present technology. The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive. For the purpose of facilitating an understanding of the invention, we have used a very concise description and do not imply that we are not involved in the complicated fashion. Many features of the invention may be freely combined, some irrelevant features may be added to an embodiment at the same time, and some obvious alternatives are included for the purpose of reducing the number of embodiments. For example, features X and Y are written in one embodiment, but clearly not both, each of which yields advantages and is not dependent on the presence of the other, so that a particular one of the features may be removed or modified. The embodiments we have chosen are very simple to understand.
The principles and features of this invention are described below in conjunction with the following drawings, which are set forth by way of illustration only and are not intended to limit the scope of the invention.
The present invention will be explained below.
Data sources herein include, but are not limited to: local files, databases, files and databases networked with the local computer, and various data on web pages. The form file of the data to be entered is not limited to forms of documents such as Word, Excel and the like, and also comprises file contents, an input box of an application software system and an input box of a webpage. For convenience, in the present invention, the contents of a web page, a page, and the like, which need to be filled in are also referred to as a form document to be entered.
In implementation, the storage unit may be a physical storage unit or a virtual storage unit, such as a file, a database, and a storage space.
Example set 1: the present set of embodiments provide a method and system for automatic data entry without a target symbol.
An automatic form entry method, as shown in fig. 1, includes the following steps:
step 1: opening a form document to be entered, searching for empty cells in the form document, determining the corresponding relation between the attribute name and the empty cells, and determining the entry position of data to be entered;
The general table can be determined according to the corresponding relationship between the upper and lower parts and the corresponding relationship between the left and right parts, for example, the right part of the table with the attribute name is an empty cell, and the lower non-empty cell is the left and right corresponding relationship, and the empty cell on the right side of the attribute name is the input position of the attribute value, if the lower cell is empty, the upper and lower corresponding relationship can be determined.
Some documents have a left-right and up-down mixed correspondence, which can also be determined separately according to the above-described method.
In addition, the web page table can determine the corresponding relation according to the html code.
Step 2: analyzing the attribute name, and determining a uniform attribute identifier corresponding to the attribute name;
for example, if a birthday needs to be filled in the document, the attribute names of the birthday, the birth date, etc. are all uniformly associated with the birth date according to the setting of the system, and the birthday is associated with the uniform birth date.
And step 3: collecting data in a data source, acquiring all possible attribute values corresponding to the attribute identification under a preset system rule, and listing all the attribute values;
the information of various birth dates is obtained and listed by inquiring in a database and a table.
And 4, step 4: if only one attribute value is listed, the corresponding empty cell can be directly input, or it can be determined that a certain attribute value meets the system rule of the attribute identifier, such as a default value, a priority value and a context dependency relationship, the attribute value can be input at the input position (the empty cell) of the data to be input, and automatic table input is completed; if one item of the plurality of items of attribute values cannot be determined, listing all possible attribute values, prompting the user to select, and entering according to the method after the user selects.
Preferably, the name information may be displayed at the same time of listing the information and displaying other related information, such as birthday and ID number, for the convenience of user selection.
The blank space (empty cell) is a broad sense, and may be an empty cell, or a place of the web page where data needs to be entered, and some web pages have prompt information at the entered position, and are also called blank spaces (empty cells).
Taking a document as an example, some information in the document is frequently entered, and after receiving the document a, the writer starts an entry system (the system may be a stand-alone program, a plug-in, a browser, a word processing system component, etc.), selecting a document in an entry system, reading the document according to a file format by the entry system, searching the document by a searching unit, searching for an empty cell needing to be filled, through the corresponding relation between the empty cell and the attribute name 'birthday', the birth date corresponding to the birthday, searching the birthday attribute value corresponding to the attribute identification in the data source, displaying all the attribute values, i.e., all birthdays, when the birthday is unique, or has a default value, a priority value, a value is selected according to the rule, and then, inputting information such as birthdays and the like corresponding to the empty cells by the unit, and if a plurality of items exist and cannot be determined, listing all values for the user to select. Preferably, other related information corresponding to the attribute value may be listed at the same time, so as to facilitate the user to select, for example, if the birthday corresponds to the information such as the display name, etc., to list them.
According to the above embodiment, an automatic form entry system may be developed, as shown in fig. 2, including an acquisition unit 10, a search unit 20, a processing unit 30, an attribute name and empty cell correspondence determination unit 60, and an entry unit 40;
the searching unit is used for searching the attribute name in the document to be input and transmitting the attribute name to the processing unit;
the acquisition unit is used for acquiring all possible attribute values corresponding to the attribute identification in a given data source;
the attribute name and empty cell (space) corresponding relation determining unit is used for determining the corresponding relation between the attribute identifier and the empty cell according to the position relation between the attribute name and the empty cell in the collected document, and only has the corresponding relation;
the processing unit is used for analyzing the attribute name, determining an attribute identifier, transferring the attribute identifier to the acquisition unit, acquiring all attribute values by the acquisition unit, and listing all the attribute values;
the entry unit is used for entering an attribute value, and if the attribute value listed by the processing unit has only one item or the information of a certain attribute value can be determined to accord with the system rule of the attribute name, the attribute value is entered at the empty cell position corresponding to the attribute name; and the attribute value is further used for entering the attribute value according to the selection of the user if the condition that all the possible attribute values are listed as one of the plurality of attribute values cannot be determined.
Example set 2: scheme 1 relies on collecting data and has a wide selection range, which is likely not necessarily the correct attribute value, and storing the selected attribute value for the next entry will improve accuracy.
Further on the basis of scheme 1: the step 4 is followed by the following steps:
and 5: storing the corresponding relation between the data attribute identification and the attribute value selected in the step 4 into a storage unit, wherein the storage unit also serves as a data source; in the storage unit, there are attribute identifications and corresponding attribute values.
The storage unit may be a physical storage unit, or may be virtual, and may exist in the form of a file, a storage space, a database, a table, or the like.
Preferably, when selecting the data source, the data source in the storage unit is arranged in front of the data source as a preference,
preferably, the data source in the memory unit is provided with a priority value that is incremented in response to a selected number of increments, such as by count accumulation.
Optionally, there is an interface, which can manually input the corresponding relationship between the entered data attribute identifier and the selected attribute value in the storage unit, and enter the information that cannot be found in the data source, for example, the information such as the personal identification number and name can be entered.
According to another aspect of this embodiment, an automatic form entry system is provided, which includes a storage unit 50 on the basis of the system of the foregoing embodiment 1, for storing the corresponding relationship between the selected data attribute identifier and the attribute value, and the storage structure may be single-dimensional or multi-dimensional;
example set 3: on the basis of any one of the above schemes, the system includes preprocessing information, and the step 4 further includes preprocessing the attribute identifier and the attribute value according to a preset preprocessing rule.
For example, the preset preprocessing rule may include a conditional filtering rule, an ordering rule, a format rule, and the like. The attribute identification and the attribute value are respectively preprocessed through the preprocessing unit, so that the attribute identification and the attribute value corresponding to the attribute name can be searched more conveniently and rapidly, and data information meeting the user requirements can be input more conveniently and more accurately.
Due to the diversification of the data information, other information can be set for the file, for example, special identifiers such as format identifiers (rules and marks), screening identifiers, class name identifiers, source identifiers and version identifiers are added. The same data information may have multiple formats, for example, the data information representing the birthday has different formats such as 2018, 7, 23, 2018-7-23, 20180723, and may be set in the system, or the document to be entered, and in some cases, the data to be entered needs to satisfy a specific condition, and then a screening flag may be set in the system, and the attribute flag and the attribute value are primarily screened through the screening flag, for example, the patent works applied in the last 5 years need to be entered, so the screening flag may be set when naming the target symbol, and the screening flag may include information such as condition information and sequencing information, so as to allow the filling requirement made by the file producer, or the will of the file filler, and allow the information entry to satisfy the specific requirement and specification.
And data source identification and version identification can be added according to needs, so that the method is suitable for different working environments and has higher universality.
According to another aspect of the present invention, there is provided an automatic form entry system, further comprising, based on any one of the above schemes: further comprising a pre-processing unit 301;
the preprocessing unit is used for respectively preprocessing the attribute identification and the attribute value according to a preset preprocessing rule.
For example, the preset preprocessing rule may include a conditional filtering rule, an ordering rule, a format rule, and the like.
Example set 4: further on the basis of the foregoing embodiments: and for a data source with a word table and an Excel table, determining the corresponding relation between the attribute identifier and the attribute value according to the data attribute (attribute identifier) and the position relation and the corresponding relation of the data information in the collected document. The collected document can be a file, a webpage, a database, a memory space and storage equipment, so that when data information contained in the file, the webpage, the database, the memory space, the storage equipment and the like is automatically read, the relationship between the attribute identification and the attribute value can be judged according to the position relationship and the corresponding relationship between the data type and the data information in the collected document; the corresponding relation between the data type and the data information in the collected document is often the up-down adjacent relation or the left-right adjacent relation, if the left-right adjacent relation is assumed, the judgment can be carried out according to the characteristics of the data type, whether the left-right adjacent data information conforms to the characteristics of the data type is judged, and after the left-right adjacent data information conforms to the characteristics of the data type, the corresponding relation between the data type and the data information can be determined to be the left-right adjacent relation, so that the corresponding relation between the attribute identification and the attribute value is determined, otherwise, the left-right adjacent relation is; the corresponding relation between the attribute identification and the attribute value can be determined by judging each row in the collected document, judging that the corresponding relation between the data type and the data information in the collected document is a vertically adjacent relation when the rows are all of the data types and have no data information, and judging that the corresponding relation between the data type and the data information in the collected document is a horizontally adjacent relation when every other row is the data information or the data type.
And manual judgment can be carried out, or judgment can be carried out according to the format of data, such as detection of telephone numbers, identification numbers, dates, nationalities and the like, and prompt can be given or collection of part of information can be abandoned once the non-compliance is detected.
According to the method of the foregoing embodiment, an automatic form entry system may be implemented, where the collection unit further includes an attribute name and attribute value correspondence determination unit 101, and the attribute name and attribute value correspondence determination unit is configured to determine a correspondence between the attribute identifier and the attribute value according to a position relationship and a correspondence between the data type and the data information in the collection document.
Example set 5: the information which needs to be entered frequently is also personal information, the embodiment set 2 stores selected information which sometimes needs to be kept secret, on the basis of the embodiment set 2, data in the storage unit is encrypted according to preset rules, and the system encrypts and decrypts the information in the storage unit so as to prevent important information from being leaked. During encryption, only important information with confidentiality requirement can be encrypted, the attribute identification can not be encrypted, if the information is not completely encrypted, the information whether to be encrypted is required to be added, and simultaneously information dependent on decryption related data is added, and the information is stored in a certain part (such as a storage unit and a processing unit) of the system or a certain file and a table. For a form of symmetric encryption, this is simple and is not exemplified here.
There are several preferred embodiments as follows:
1) for the mixed encryption of symmetric encryption and asymmetric encryption, a random number generator is used for generating random numbers as keys to encrypt information when the information is recorded, then the keys are encrypted by public keys of Windows systems of a plurality of authorized users, and if a plurality of persons have authority to record the information, the public keys of the plurality of persons are used for encrypting the information. Each encrypted key is stored as a piece of information in one data item, while other information required for decryption is also stored as a data item in the storage unit. In the Windows system, a system user logs in and can actually decrypt the private key of the system user, so that different users can be conveniently given the authority of decrypting, acquiring and inputting data, confidential information is prevented from falling into hands of other people, and the user does not need to perform excessive operation. After the authorized user logs in, the information can be decrypted. If the user is not authorized, the symmetric key cannot be decrypted, and thus the confidential data cannot be obtained. The method has the advantages that when the authorized user decrypts, the private key does not seem to be needed to be decrypted, transparent encryption and decryption can be achieved, namely, the user does not need to perform encryption and decryption operations, a password does not need to be input, convenience is brought to the user, and data security can be guaranteed.
2) For convenience, a hash value may be generated using a user password, and a portion of the hash value may be used as a key to encrypt the related data. At the same time, it needs to add encryption related information, such as whether to encrypt, the working mode of encryption, the filling mode, etc.
3) Preferably, each data item (attribute value) to be encrypted is encrypted with a different key, but in order to memorize, store or manage fewer keys while ensuring security, the key is generated using a one-way function f (k, x), where k is a master key (or password) and x is a value that uniquely identifies (locates) the data item, e.g., the master key of one-dimensional data, or unique attributes, attributes for each dimension of multidimensional data, and in the case of multiple tables, table names. Thus, the user or system only needs to remember the key or password, and the disclosure of one password does not affect other data items. This one-way function may use the Hash function a = Hash (k | x) or a mathematical puzzle, such as a = ga (mod p), and the discrete logarithm problem refers to the known g, p, a = k |, where p is a very large prime number, g is the primitive root of p, and |, represents the combined data. A is a key to an attribute value.
4) When the key is generated by adopting the method of the 3) and the main key is encrypted by the user public key by adopting the method of the 2), the main key k can be automatically decrypted when the user logs in, and the memory of the user is not needed.
Through the encryption embodiment, a small number of keys can be memorized, stored or managed, the security of the data information can be ensured, the leakage of the key of the data information or the attribute value of one dimension does not influence the security of the data information or the attribute value of other dimensions, and the security and the stability are high.
According to the above method, a system with encrypted and decrypted data can be realized, which further comprises an encryption and decryption unit 501 for encrypting and decrypting the attribute value.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (10)
1. An automatic form entry method is characterized by comprising the following steps:
step 1: opening a form document to be entered, searching for empty cells in the form document, determining the corresponding relation between the attribute name and the empty cells, and determining the entry position of data to be entered;
Step 2: analyzing the attribute name, and determining a uniform attribute identifier corresponding to the attribute name;
and step 3: collecting data in a data source, acquiring all possible attribute values corresponding to the attribute identification under a preset system rule, and listing all the attribute values;
and 4, step 4: if only one attribute value is listed or it can be determined that a certain attribute value meets the system rule of the attribute identifier, the attribute value is entered at the entry position of the data to be entered, and automatic entry of the form is completed; if one item of the plurality of items of attribute values cannot be determined, listing all possible attribute values, prompting the user to select, and entering according to the method after the user selects.
2. A form automatic entry method according to claim 1, further comprising, after said step 4, the steps of:
and 5: and (4) storing the corresponding relation between the data attribute identification in the step (4) and the selected attribute value into a storage unit, wherein the storage unit also serves as a data source.
3. The form automatic entry method according to claim 1, wherein the system includes preprocessing information, and said step 4 further includes preprocessing said attribute identification and said attribute value, respectively, according to a preset preprocessing rule.
4. A form automatic entry method according to claim 1, wherein said step 3 further comprises, step 31: and acquiring data in a data source with a table, and determining the corresponding relation between the attribute identification and the attribute value according to the data type and the position relation and the corresponding relation of the data information in the acquired document.
5. The form automatic entry method according to claim 2, characterized in that the preset rules encrypt the data in the storage unit, and the encryption and decryption method comprises a symmetric encryption and decryption method and/or an asymmetric encryption and decryption method.
6. An automatic form entry system is characterized by comprising a collection unit, a search unit, a processing unit, an attribute name and empty cell corresponding relation determination unit and an entry unit;
the searching unit is used for searching the attribute name in the document to be input and transmitting the attribute name to the processing unit;
the acquisition unit is used for acquiring all possible attribute values corresponding to the attribute identification in a given data source;
the attribute name and empty cell corresponding relation determining unit is used for determining the corresponding relation between the attribute identifier and the empty cell according to the position relation between the attribute name and the empty cell in the collected document;
The processing unit is used for analyzing the attribute name, determining an attribute identifier, transferring the attribute identifier to the acquisition unit, acquiring all attribute values by the acquisition unit, and listing all the attribute values;
the entry unit is used for entering an attribute value, and if the attribute value listed by the processing unit has only one item or the information of a certain attribute value can be determined to accord with the system rule of the attribute name, the attribute value is entered at the empty cell position corresponding to the attribute name; and the attribute value is further used for entering the attribute value according to the selection of the user if the condition that all the possible attribute values are listed as one of the plurality of attribute values cannot be determined.
7. The form automatic entry system of claim 6, comprising a storage unit for storing selected data attribute identification and attribute value correspondence.
8. The form automatic entry system of claim 6, wherein the processing unit further comprises a preprocessing unit;
the preprocessing unit is used for respectively preprocessing the attribute identification and the attribute value according to a preset preprocessing rule.
9. The form automatic entry system of claim 6, wherein the collection unit further comprises an attribute name and attribute value correspondence determination unit, the correspondence determination unit being configured to determine a correspondence between the attribute identifier and the attribute value according to a positional relationship and a correspondence of the attribute name and the attribute value in the collection document.
10. The form automatic entry system of claim 7 further comprising an encryption and decryption unit for encrypting and decrypting the attribute values.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910320980.6A CN111859876A (en) | 2019-04-21 | 2019-04-21 | Automatic form entering method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910320980.6A CN111859876A (en) | 2019-04-21 | 2019-04-21 | Automatic form entering method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111859876A true CN111859876A (en) | 2020-10-30 |
Family
ID=72951946
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910320980.6A Pending CN111859876A (en) | 2019-04-21 | 2019-04-21 | Automatic form entering method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111859876A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116151202A (en) * | 2023-02-21 | 2023-05-23 | 中国人民解放军海军工程大学 | Form filling method, device, electronic equipment and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6523025B1 (en) * | 1998-03-10 | 2003-02-18 | Fujitsu Limited | Document processing system and recording medium |
| JP2003150546A (en) * | 2001-11-14 | 2003-05-23 | Nec Corp | Data input device and input method to data input form |
| US6574631B1 (en) * | 2000-08-09 | 2003-06-03 | Oracle International Corporation | Methods and systems for runtime optimization and customization of database applications and application entities |
| JP2005165826A (en) * | 2003-12-04 | 2005-06-23 | Nippon Telegr & Teleph Corp <Ntt> | Data input support method, system, program, and terminal |
| CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
| CN106095961A (en) * | 2016-06-16 | 2016-11-09 | 网易（杭州）网络有限公司 | Table display processing method and device |
| CN109376219A (en) * | 2018-10-31 | 2019-02-22 | 北京锐安科技有限公司 | Matching process, device, electronic equipment and the storage medium of text attributes field |
| CN109542899A (en) * | 2018-10-31 | 2019-03-29 | 桂林金发明科技开发有限公司 | A kind of data method for automatically inputting and system based on target symbol |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
-
2019
- 2019-04-21 CN CN201910320980.6A patent/CN111859876A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6523025B1 (en) * | 1998-03-10 | 2003-02-18 | Fujitsu Limited | Document processing system and recording medium |
| US6574631B1 (en) * | 2000-08-09 | 2003-06-03 | Oracle International Corporation | Methods and systems for runtime optimization and customization of database applications and application entities |
| JP2003150546A (en) * | 2001-11-14 | 2003-05-23 | Nec Corp | Data input device and input method to data input form |
| JP2005165826A (en) * | 2003-12-04 | 2005-06-23 | Nippon Telegr & Teleph Corp <Ntt> | Data input support method, system, program, and terminal |
| CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
| CN106095961A (en) * | 2016-06-16 | 2016-11-09 | 网易（杭州）网络有限公司 | Table display processing method and device |
| CN109558440A (en) * | 2018-10-18 | 2019-04-02 | 平安科技（深圳）有限公司 | Batch data processing method, device, computer equipment and storage medium |
| CN109376219A (en) * | 2018-10-31 | 2019-02-22 | 北京锐安科技有限公司 | Matching process, device, electronic equipment and the storage medium of text attributes field |
| CN109542899A (en) * | 2018-10-31 | 2019-03-29 | 桂林金发明科技开发有限公司 | A kind of data method for automatically inputting and system based on target symbol |
Non-Patent Citations (1)
| Title |
|---|
| 李杰;宁帆;赵国安;: "一种批量信息检索方法及实现", 计算机系统应用, no. 05 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116151202A (en) * | 2023-02-21 | 2023-05-23 | 中国人民解放军海军工程大学 | Form filling method, device, electronic equipment and storage medium |
| CN116151202B (en) * | 2023-02-21 | 2024-04-02 | 中国人民解放军海军工程大学 | Form filling method, device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP4999751B2 (en) | Data sharing techniques | |
| CN108009440B (en) | Data storage method, query method, device, storage medium and computer equipment | |
| US7865742B2 (en) | Method, apparatus, and program product for enabling access to flexibly redacted content | |
| US7861096B2 (en) | Method, apparatus, and program product for revealing redacted information | |
| US7333987B2 (en) | Controlled-access database system and method | |
| US20080046757A1 (en) | Method, Apparatus, and Program Product for Flexible Redaction of Content | |
| WO2019152892A1 (en) | Technologies for private key recovery in distributed ledger systems | |
| US20020038421A1 (en) | Encrypted file system, encrypted file retrieval method, and computer-readable medium | |
| US20060005017A1 (en) | Method and apparatus for recognition and real time encryption of sensitive terms in documents | |
| US8332655B2 (en) | Method for order invariant correlated encrypting of data and SQL queries for maintaining data privacy and securely resolving customer defects | |
| US7930560B2 (en) | Personal information management system, personal information management program, and personal information protecting method | |
| EP1763796A2 (en) | Encrypted table indexes and searching encrypted tables | |
| US20020099733A1 (en) | Method and apparatus for attaching electronic signature to document having structure | |
| CN1979511B (en) | File data safety management system and method | |
| CN103607420A (en) | Safe electronic medical system for cloud storage | |
| CN104992124A (en) | Document safety access method for cloud storage environment | |
| US20040243627A1 (en) | Chat stream information capturing and indexing system | |
| CN110598193B (en) | Audit offline document management system | |
| CN109542899A (en) | A kind of data method for automatically inputting and system based on target symbol | |
| US8280061B2 (en) | Methods and systems for storing and retrieving encrypted data | |
| CN111859876A (en) | Automatic form entering method and system | |
| CN108650268A (en) | It is a kind of realize multistage access can search for encryption method and system | |
| CN201130381Y (en) | Electric signature tool with cryptogram management function | |
| CN102073805A (en) | Computer system and content management method | |
| CN111563118B (en) | Automatic data input method and system for obtaining data in real time |
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 |