CN106802898B - Data entry method and device - Google Patents
Data entry method and device Download PDFInfo
- Publication number
- CN106802898B CN106802898B CN201510845009.7A CN201510845009A CN106802898B CN 106802898 B CN106802898 B CN 106802898B CN 201510845009 A CN201510845009 A CN 201510845009A CN 106802898 B CN106802898 B CN 106802898B
- Authority
- CN
- China
- Prior art keywords
- field
- standard
- data
- format
- system 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.)
- Expired - Fee Related
Links
- 238000013479 data entry Methods 0.000 title claims abstract description 50
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000012545 processing Methods 0.000 claims abstract description 25
- 238000013524 data verification Methods 0.000 claims abstract description 22
- 238000012795 verification Methods 0.000 claims abstract description 22
- 238000001514 detection method Methods 0.000 claims 1
- 238000010586 diagram Methods 0.000 description 8
- 230000003993 interaction Effects 0.000 description 2
- 238000013523 data management Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000013522 software testing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Abstract
The invention provides a data entry method and a data entry device, wherein the data entry method comprises the following steps: acquiring system data, and analyzing and acquiring each field of the system data; verifying each field of the system data according to a currently stored data verification standard to obtain a verification result, wherein the data verification standard comprises a standard format of each standard field; and according to the checking result, inputting and processing the system data. By the data entry method and the data entry device, automatic entry and verification of data can be realized, and the efficiency and the accuracy of data entry are improved.
Description
Technical Field
The invention relates to the field of software testing, in particular to a data entry method and device.
Background
At present, the data management work mainly adopts a manual management method. Generally comprising the steps of: acquiring system data of the system, such as basic information of a client, from other systems; the system data is entered manually, and the data is manually checked and verified during the entry process.
However, in the data entry process, because a large amount of data is often involved, the manual entry needs a lot of time, and the accuracy of the manual inspection and verification is more dependent on the knowledge and experience of the administrator. Therefore, the existing data entry scheme is long in time consumption and prone to error, and the efficiency and accuracy of data entry are affected.
Disclosure of Invention
The invention provides a data entry method and a data entry device, which are used for solving the problems of long time consumption and low accuracy rate of the existing data entry scheme.
A first aspect of the present invention provides a data entry method, including:
acquiring system data, and analyzing and acquiring each field of the system data;
verifying each field of the system data according to a currently stored data verification standard to obtain a verification result, wherein the data verification standard comprises a standard format of each standard field;
and according to the checking result, inputting and processing the system data.
Another aspect of the present invention provides a data entry device comprising:
the acquisition module is used for acquiring system data and analyzing and acquiring each field of the system data;
the verification module is used for verifying each field of the system data according to a currently stored data verification standard to obtain a verification result, wherein the data verification standard comprises a standard format of each standard field;
and the processing module is used for inputting and processing the system data according to the verification result.
According to the data entry method and the data entry device, the fields of the system data are automatically checked according to the standard format of the pre-configured standard fields, and the data entry scheme is carried out according to the check result, so that the data are automatically entered and checked, and the efficiency and the accuracy of the data entry are improved.
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 introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic flow chart of a data entry method according to an embodiment of the present invention;
fig. 2 is a schematic flow chart of another data entry method according to a first embodiment of the present invention;
fig. 3 is a schematic flow chart of another data entry method according to an embodiment of the present invention;
fig. 4 is a schematic flow chart of another data entry method according to an embodiment of the present invention;
fig. 5 is a schematic flow chart of another data entry method according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a data entry device according to a second embodiment of the present invention;
FIG. 7 is a schematic structural diagram of another data entry device according to a second embodiment of the present invention;
fig. 8 is a schematic structural diagram of another data entry device according to a second embodiment of the present invention;
fig. 9 is a schematic structural diagram of another data entry device according to a second embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, 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 some, but not all, embodiments of the present invention. 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.
Fig. 1 is a schematic flow chart of a data entry method according to an embodiment of the present invention, as shown in fig. 1, the method includes:
101. acquiring system data, and analyzing and acquiring each field of the system data;
102. verifying each field of the system data according to a currently stored data verification standard to obtain a verification result, wherein the data verification standard comprises a standard format of each standard field;
103. and according to the checking result, inputting and processing the system data.
In practical application, data interaction between systems can be realized through the intermediate component. Optionally, when system data needs to be entered, the system data under a certain system may be acquired through the intermediate component.
The standard field in the data check standard may be some preset fields, for example, in practical applications, a field in which an error is usually prone to occur, or a field whose content is relatively fixed and definite. For example, for a field for characterizing a mobile phone number of a user, a standard format of the field may be configured as an 11-digit number, and accordingly, when a certain field for characterizing a mobile phone number in system data is detected to be not in compliance with the standard format, it is indicated that there is a high possibility of an error in the field.
Specifically, the data verification standard may be pre-established, and accordingly, as shown in fig. 2, fig. 2 is a schematic flow chart of another data entry method provided in the first embodiment of the present invention, and on the basis of the implementation shown in fig. 1, the method further includes:
201. receiving a configuration instruction of a user, wherein the configuration instruction comprises a first field and a first format;
202. and taking the first field as one of standard fields, taking the first format as the standard format of the first field, and storing the first format into the data check standard.
By the embodiment, the standard format of each standard field can be established in advance, so that the system data can be automatically verified according to the standard format of each standard field in the subsequent data entry process.
Specifically, there are various ways to verify system data according to a data verification standard, for example, as shown in fig. 3, fig. 3 is a schematic flow chart of another data entry method provided by an embodiment of the present invention, and based on any of the foregoing embodiments, 102 may specifically include:
301. for each field of the system data, detecting whether a first standard field matched with the field exists in the data check standard;
302. if the first standard field exists, taking the standard format of the first standard field as the standard format of the field, and detecting whether the format of the field in the system data is matched with the standard format of the field;
303. if the matching is successful, the verification is successful, otherwise, the verification fails.
Specifically, after each field of the system data is obtained through analysis, for each field, a standard field matched with the field is determined from the data verification standard, where matching may mean that the content represented by the field is the same, for example, both fields are used for representing the mobile phone number of the user. Further, the standard format of the standard field is used as the standard format of the field, whether the format of the field in the system data is matched with the standard format of the field is detected, if so, the format of the field is in accordance with the requirement, the verification is successful, otherwise, the field verification is failed. The format matching may be that the format of the field is the same, for example, the same is 11 bits, or the content of the field is the same, and the specific case may be determined according to the content represented by the field, which is not limited herein.
Further, after checking a field of the system data, corresponding processing may be performed according to a checking result, specifically, fig. 4 is a flowchart of another data entry method provided in an embodiment of the present invention, and on the basis of the implementation manner shown in fig. 3, 103 may specifically include:
401. inputting fields which are successfully verified in all fields of the system data;
402. and aiming at the fields which fail to be checked in all the fields of the system data, entering and adding reminding marks for the fields.
Specifically, after a field of the system data is verified, if the field is verified successfully, the field can be entered, and if the field is verified unsuccessfully, the field is marked by using a reminding mark during the entry so as to inform a user that the field may have an error, so that the user can further confirm the field.
Optionally, the manner of the reminder mark may be various, for example, the field is marked with a prominent color, and this embodiment is not limited thereto.
In practical applications, there may be no standard field matching with a field of system data in the data verification standard, that is, there is a low probability of error occurring in such a field, and accordingly, as shown in fig. 5, fig. 5 is a schematic flow chart of another data entry method provided by an embodiment of the present invention, and on the basis of the implementation manner shown in fig. 3 or fig. 4, after 301, the method further includes:
501. and if the first standard field does not exist, entering the field.
Specifically, data fields which are usually not wrong can be normally recorded, so that the data recording time is saved, and the data recording efficiency is improved.
According to the data entry method provided by the embodiment, each field of the system data is automatically checked according to the standard format of each preset standard field, and the data entry scheme is performed according to the check result, so that the automatic entry and check of the data are realized, and the efficiency and the accuracy of the data entry are improved.
Fig. 6 is a schematic structural diagram of a data entry device according to a second embodiment of the present invention, and as shown in fig. 6, the device includes:
the acquisition module 61 is configured to acquire system data and analyze and acquire each field of the system data;
the checking module 62 is configured to check each field of the system data according to a currently stored data checking standard, so as to obtain a checking result, where the data checking standard includes a standard format of each standard field;
and the processing module 63 is configured to perform entry processing on the system data according to the verification result.
In practical application, data interaction between systems can be realized through the intermediate component. Optionally, when system data needs to be entered, the obtaining module 61 may obtain the system data under a certain system through the intermediate component.
The standard field in the data check standard may be some preset fields, for example, in practical applications, a field in which an error is usually prone to occur, or a field whose content is relatively fixed and definite.
Specifically, the data verification standard may be pre-established, and accordingly, as shown in fig. 7, fig. 7 is a schematic structural diagram of another data entry device provided in the second embodiment of the present invention, and on the basis of the implementation manner shown in fig. 6, the device further includes:
a receiving module 71, configured to receive a configuration instruction of a user, where the configuration instruction includes a first field and a first format;
a storage module 72, configured to use the first field as one of the standard fields, use the first format as the standard format of the first field, and store the first format in the data check standard.
By the embodiment, the standard format of each standard field can be established in advance, so that the system data can be automatically verified according to the standard format of each standard field in the subsequent data entry process.
Specifically, there are various ways for the checking module 62 to check the system data according to the data checking standard, for example, as shown in fig. 8, fig. 8 is a schematic structural diagram of another data entry device provided by the second embodiment of the present invention, and on the basis of any one of the foregoing embodiments, the checking module 62 may specifically include:
a detecting unit 621, configured to detect, for each field of the system data, whether a first standard field matching the field exists in the data check standard;
a matching unit 622, configured to, if the first standard field exists, take the standard format of the first standard field as the standard format of the field, and detect whether the format of the field in the system data matches the standard format of the field;
and a determination unit 623, configured to, if the matching is performed, successfully check, and otherwise, fail to check.
Specifically, after the obtaining module 61 analyzes each field of the obtained system data, the detecting unit 621 determines, for each field, a standard field matched with the field from the data verification standard, where matching may mean that the content represented by the field is the same. Further, the detecting unit 621 uses the standard format of the standard field as the standard format of the field, the matching unit 622 detects whether the format of the field in the system data matches the standard format of the field, if so, the determining unit 623 determines that the format of the field meets the requirement, and the verification is successful, otherwise, the determining unit 623 determines that the field verification fails.
Further, after the checking module 62 checks the field of the system data, the processing module 63 may perform corresponding processing according to a checking result, specifically, fig. 9 is a schematic structural diagram of another data entry device provided in the second embodiment of the present invention, and on the basis of the implementation shown in fig. 8, the processing module 63 may specifically include:
the first processing unit 631 is configured to enter, for a successfully verified field of the fields of the system data, the field;
and the second processing unit 632 is configured to enter and add a reminder to a field that fails to be checked in each field of the system data.
Specifically, after the verification module 62 verifies a field of the system data, if the field is verified successfully, the first processing unit 631 enters the field, and if the field is verified unsuccessfully, the second processing unit 632 marks the field with a reminder while entering the field, so as to notify the user that the field may have an error, so that the user can further confirm the field.
Optionally, the manner of the reminder mark may be various, for example, the field is marked with a prominent color, and this embodiment is not limited thereto.
In practical applications, there may be no standard field matching with a field of the system data in the data verification standard, that is, there is a low probability that such a field is wrong, and accordingly, the second embodiment of the present invention further provides another data entry apparatus, and on the basis of the embodiment shown in fig. 8 or fig. 9, the processing module 63 is further configured to enter the field if the detecting unit 621 detects that the first standard field is not present.
Specifically, data fields which are usually not wrong can be normally recorded, so that the data recording time is saved, and the data recording efficiency is improved.
According to the data entry device provided by the embodiment, each field of the system data is automatically checked according to the standard format of each preset standard field, and the data entry scheme is performed according to the check result, so that the automatic entry and check of the data are realized, and the efficiency and the accuracy of the data entry are improved.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working process of the apparatus described above may refer to the corresponding process in the foregoing method embodiment, and is not described herein again. In addition, it should be noted that each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
Those of ordinary skill in the art will understand that: all or a portion of the steps of implementing the above-described method embodiments may be performed by hardware associated with program instructions. The program may be stored in a computer-readable storage medium. When executed, the program performs steps comprising the method embodiments described above; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (4)
1. A data entry method, comprising:
acquiring system data through an intermediate component, and analyzing and acquiring each field of the system data;
verifying each field of the system data according to a currently stored data verification standard to obtain a verification result, wherein the data verification standard comprises a standard format of each standard field;
according to the checking result, inputting the system data;
the verifying each field of the system data according to the currently stored data verification standard to obtain a verification result includes:
for each field of the system data, detecting whether a first standard field matched with the field exists in the data check standard;
if the first standard field exists, taking the standard format of the first standard field as the standard format of the field, and detecting whether the format of the field in the system data is matched with the standard format of the field;
if the matching is carried out, the verification is successful, otherwise, the verification fails;
the entering processing of the system data according to the checking result comprises:
inputting fields which are successfully verified in all fields of the system data;
inputting and adding a reminding mark for the fields which fail to be checked in each field of the system data;
the method further comprises the following steps:
receiving a configuration instruction of a user, wherein the configuration instruction comprises a first field and a first format;
and taking the first field as one of standard fields, taking the first format as the standard format of the first field, and storing the first format into the data check standard.
2. The method of claim 1, wherein after detecting whether a first standard field matching the field exists in the data check standard for each field of the system data, further comprising:
and if the first standard field does not exist, entering the field.
3. A data entry device, comprising:
the acquisition module is used for acquiring system data through the intermediate component and analyzing and acquiring each field of the system data;
the verification module is used for verifying each field of the system data according to a currently stored data verification standard to obtain a verification result, wherein the data verification standard comprises a standard format of each standard field;
the processing module is used for inputting and processing the system data according to the checking result;
the verification module comprises:
the detection unit is used for detecting whether a first standard field matched with the field exists in the data check standard or not aiming at each field of the system data;
a matching unit, configured to, if the first standard field exists, take the standard format of the first standard field as the standard format of the field, and detect whether the format of the field in the system data matches the standard format of the field;
the judging unit is used for successfully verifying if the matching is carried out, otherwise, the verifying fails;
the processing module comprises:
the first processing unit is used for inputting fields which are successfully verified in the fields of the system data;
the second processing unit is used for inputting and adding a reminding mark for the fields which fail to be checked in the fields of the system data;
the device further comprises:
the device comprises a receiving module, a sending module and a processing module, wherein the receiving module is used for receiving a configuration instruction of a user, and the configuration instruction comprises a first field and a first format;
and the storage module is used for taking the first field as one of standard fields, taking the first format as the standard format of the first field and storing the first format into the data verification standard.
4. The apparatus of claim 3,
the processing module is further configured to enter the field if the first standard field does not exist.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510845009.7A CN106802898B (en) | 2015-11-26 | 2015-11-26 | Data entry method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510845009.7A CN106802898B (en) | 2015-11-26 | 2015-11-26 | Data entry method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106802898A CN106802898A (en) | 2017-06-06 |
| CN106802898B true CN106802898B (en) | 2020-09-04 |
Family
ID=58976892
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510845009.7A Expired - Fee Related CN106802898B (en) | 2015-11-26 | 2015-11-26 | Data entry method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106802898B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107392712B (en) * | 2017-07-21 | 2021-06-29 | 罗宝丰 | Purchase, sales and inventory management system and using method thereof |
| CN109471960B (en) * | 2018-11-13 | 2020-10-13 | 深圳市景旺电子股份有限公司 | Method and device for intelligently identifying tool layer names of PCB (printed circuit board) data |
| CN110399428B (en) * | 2019-07-26 | 2022-02-11 | 北京奇艺世纪科技有限公司 | Data verification method and device and electronic equipment |
| CN112416648A (en) * | 2020-06-03 | 2021-02-26 | 上海哔哩哔哩科技有限公司 | Data verification method and device |
| CN112182016A (en) * | 2020-09-30 | 2021-01-05 | 中国民航信息网络股份有限公司 | Automatic checking method for higher point check and related system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101980187A (en) * | 2010-10-13 | 2011-02-23 | 中兴通讯股份有限公司 | Data warehousing method and device |
| CN103631966A (en) * | 2013-12-18 | 2014-03-12 | 用友软件股份有限公司 | Configurable multiple-valued matching field analysis method |
| CN104737163A (en) * | 2012-10-17 | 2015-06-24 | 起元科技有限公司 | Specifying and applying rules to data |
-
2015
- 2015-11-26 CN CN201510845009.7A patent/CN106802898B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101980187A (en) * | 2010-10-13 | 2011-02-23 | 中兴通讯股份有限公司 | Data warehousing method and device |
| CN104737163A (en) * | 2012-10-17 | 2015-06-24 | 起元科技有限公司 | Specifying and applying rules to data |
| CN103631966A (en) * | 2013-12-18 | 2014-03-12 | 用友软件股份有限公司 | Configurable multiple-valued matching field analysis method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106802898A (en) | 2017-06-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106802898B (en) | Data entry method and device | |
| CN107223257B (en) | Test method, test server and test system | |
| CN109635564A (en) | A kind of method, apparatus, medium and equipment detecting Brute Force behavior | |
| CN111382740B (en) | Text picture analysis method, text picture analysis device, computer equipment and storage medium | |
| CN106230602B (en) | The integrity detection system and method for the certificate chain of digital certificate | |
| CN110147213B (en) | Printing detection method, device, equipment and medium based on scanner | |
| CN109144801A (en) | It is a kind of to be directed to the test method of MOC card, device and equipment in server | |
| US20080294377A1 (en) | Method for Automatic Detection of Operational Performance Data of Reading Systems | |
| CN108196975B (en) | Data verification method and device based on multiple checksums and storage medium | |
| CN106933858B (en) | Page source statistical method and view controller | |
| CN107508835B (en) | Account verification method and device and computer readable storage medium | |
| CN112286780B (en) | Method, device, equipment and storage medium for testing recognition algorithm | |
| CN112637888A (en) | Coverage hole area identification method, device, equipment and readable storage medium | |
| CN107562593A (en) | A kind of automated testing method and system for verifying internal memory ECC functions | |
| CN109614382B (en) | Log segmentation method and device for application | |
| CN116433622A (en) | Method, device, equipment and medium for deleting repeated identification of end points of battery cell pole piece | |
| CN113792017A (en) | Method and system for checking template content imported into excel | |
| CN112783942B (en) | Block chain-based data acquisition quality verification method, system, device and medium | |
| CN110046067B (en) | Interface testing method and device | |
| CN110298018B (en) | Text data processing method, device, computer equipment and storage medium | |
| CN110633204B (en) | Program defect detection method and device | |
| CN110807037B (en) | Data modification method and device, electronic equipment and storage medium | |
| CN107861842B (en) | Metadata damage detection method, system, equipment and storage medium | |
| CN108235324B (en) | Short message template testing method and server | |
| CN112784540A (en) | Document number proofreading method and device |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20220616 Address after: 3007, Hengqin international financial center building, No. 58, Huajin street, Hengqin new area, Zhuhai, Guangdong 519031 Patentee after: New founder holdings development Co.,Ltd. Patentee after: BEIJING FOUNDER ELECTRONICS Co.,Ltd. Address before: 100871, Beijing, Haidian District, Cheng Fu Road, No. 298, Zhongguancun Fangzheng building, 9 floor Patentee before: PEKING UNIVERSITY FOUNDER GROUP Co.,Ltd. Patentee before: BEIJING FOUNDER ELECTRONICS Co.,Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20200904 |