CN109189849B - Standardized and streamlined data entry method and system - Google Patents
Standardized and streamlined data entry method and system Download PDFInfo
- Publication number
- CN109189849B CN109189849B CN201811203202.0A CN201811203202A CN109189849B CN 109189849 B CN109189849 B CN 109189849B CN 201811203202 A CN201811203202 A CN 201811203202A CN 109189849 B CN109189849 B CN 109189849B
- Authority
- CN
- China
- Prior art keywords
- data
- data file
- module
- task
- execution
- 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.)
- Active
Links
- 238000013479 data entry Methods 0.000 title claims abstract description 23
- 238000000034 method Methods 0.000 title claims abstract description 16
- 230000008676 import Effects 0.000 claims abstract description 37
- 238000012795 verification Methods 0.000 claims description 9
- 238000004458 analytical method Methods 0.000 claims description 7
- 210000001503 joint Anatomy 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims description 2
- 238000007689 inspection Methods 0.000 claims description 2
- 238000004891 communication Methods 0.000 claims 1
- 238000012549 training Methods 0.000 claims 1
- 230000006870 function Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 238000012552 review Methods 0.000 description 3
- 239000000835 fiber Substances 0.000 description 2
- 230000003213 activating effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a standardized and streamlined data entry method and system, belonging to the technical field of data import, and the method comprises the following steps: the standardized template is a combination of a plurality of models, and the combination is from beginning to end of a correlation; and a standard flow taking task control as an implementation mode is adopted, so that data is input into a target system from a source system, and personnel and time for inputting the data are recorded. The model is oriented to resource management systems with various stocks, the combination relation can better guide a user to fill the model, and the one-key import of a plurality of models saves the operation time.
Description
Technical Field
The invention relates to a data import technology, in particular to a standardized and streamlined data entry method and system.
Background
The situations of inventory data entry and data cutting are often met in the project implementation process. Data is an extremely important asset to each customer, which is the requirement that each customer will make. The storage forms of the stock data of the clients are various, some stock data are stored in a certain system or a database, and some stock data are even manually maintained by Excel.
Existing methods typically construct templates from a single model, requiring the customer to import each model separately. The client needs to perform multiple import operations on a batch of related data. The dispersed models are not easy to make the client notice the incidence relation between the models, and the accuracy of the data provided by the client is reduced. The original import mode is general in prompting of reasons of data import failure, a client is laboursome in data rectification, and data rectification is frequently required to be conducted for many times for one reason. This results in a large amount of repetitive work required for data import, and data segmentation becomes a very troublesome task for project personnel.
Disclosure of Invention
In order to solve the technical problems, the invention provides a standardized and flow-based data entry method, which is provided with a standardized template, is guided in by one key in a standard flow control mode, and can be checked efficiently.
The invention provides a standardized and streamlined data entry method, which comprises the following steps:
the standardized template composed of the models with a certain incidence relation is provided, and the incidence relation enables a user to accurately recognize the incidence relation among the models when filling data, so that the data accuracy is improved, and the data entry efficiency is improved.
The data file filled by the user according to the template can be manually uploaded to the server through the foreground page. The client can input the data of a plurality of models into the system together only by uploading once, so that the number of times of import operation of the client is reduced, and the efficiency of data input is improved.
If the data file is in butt joint with other systems, the server can be informed to collect the data file after the data file is generated.
Further, in the above-mentioned case,
after the data file is uploaded or the server receives the message generated by the data file, a data entry task is generated, and the task information comprises an execution state, a result, execution starting time, execution ending time, a task creator and the like. If the import fails, the export task details can see which the error data is and which the error reason is.
The data entry program periodically trains and executes the import tasks, so that the execution quantity of the import tasks can be effectively controlled to control the server resources consumed by all the import tasks.
The details of the exported task clearly see that each piece of error data is marked and illustrates the cause of the data error. The client can accurately correct the wrong data and improve the efficiency of client data import.
Further, in the above-mentioned case,
after the task is executed, if the data file needs to be collected, the data file is collected firstly and then processed, and the data file is directly processed after the data file is uploaded by a client;
the processing of the data file includes: analyzing, checking, inputting the data file and returning an execution result. Data that fails to be entered and the reason for the data entry failure are marked if the execution fails. The analysis and the check sum input are performed by taking the model as the granularity, the result of the execution failure can be returned when any model fails to input, and the subsequent model is not subjected to the analysis and the check sum input any more.
The analysis means that the ID corresponding to each associated data is found according to the information provided by each piece of data, because the system uses the ID for association.
The verification can carry out all-rule verification on the whole data, so that all error data and all error reasons of each piece of data can be verified at one time, and convenience is provided for a client to modify the data.
And the logging operation is performed after all data are successfully verified. In addition, the entry function can enter the outside line data into the OSP system, and the problem that OSP data can only be manually created one by one in the prior art is solved.
Further, in the above-mentioned case,
the data entry task also functions as an oplog. The customer can review which people imported which data by entering the task. This is also very important to the customer.
The invention also provides a standardized and streamlined data entry system, which mainly comprises:
the system comprises a standard template module, a data file uploading module, a data file collecting module, a data file analyzing module, a data file checking module, a data file inputting module, an error marking module and an inspection module; wherein,
the standard template module provides a standardized template consisting of models with incidence relation, and the incidence relation enables a user to accurately recognize the incidence relation among the models when filling data;
the data file uploading module uploads the data file filled according to the template to a server;
the data file acquisition module is used for informing the server to enable the server to acquire data after the data file is generated when the data file acquisition module is in butt joint with other systems;
the data file analysis module finds the ID corresponding to each associated data according to the information provided by each piece of data;
the data file checking module is used for checking all rules of the full data;
the data file input module is used for inputting operation after all data are successfully verified, and inputting the outside line data into the OSP system;
the error marking module marks the data and reasons of the recording failure;
and the checking module is used for checking the execution condition of the data entry task.
Further, the method also comprises the following steps:
the processor and the memory are communicated with each other through a bus; the memory stores program instructions executable by the processor, the processor invoking the program instructions to perform any of the methods of the present invention described above.
Further, the method also comprises the following steps:
a computer-readable storage medium, comprising:
on which a computer program is stored which, when being executed by a processor, carries out the method of any of the preceding claims of the invention.
The invention has the advantages that
The standardized template is a combination of a plurality of models, and the combination is the beginning to the end of an association relationship (such as equipment required by service opening); the task control is used as a standard flow of an implementation mode, data is input into a target system from a source system, and personnel and time for inputting the data can be recorded. The model can be oriented to resource management systems with various stocks, the combination relation can better guide a user to fill the model, and the one-key import of a plurality of models saves the operation time. The data source of the process can be collection or manual input, a task is generated after the process is initiated, and the data is analyzed, verified and input after the task is executed.
Drawings
FIG. 1 is a schematic workflow diagram of the present invention.
Detailed Description
The invention is explained in more detail below:
specifically, the data recorded by the resource template of the device required for activating the FTTH service is used as an example for explanation.
Step one, providing a standardized template.
Watch 1
Watch two
Tables one and two show the front and back halves of the template, respectively. It can be seen that this template is a standard template consisting of nine models. This is a template of the resources required to open the FTTH service. If nine models are in nine templates, respectively, the customer needs to do this import operation and assemble the templates only once.
The arrangement sequence of the templates is the sequence in which the model data should be imported, and the data of the model arranged later can be imported only after the previous model data is imported. Because there is an associative relationship between the models. And putting the models together can make the customer better pay attention to the association. The specific association relationship is specifically developed as follows:
watch III
The Equipment Address is a model which must be filled with data first, and most of the data of the later model has an associated relationship with the model. The model also has three attributes, namely, subnet Name, Zone Network Name and Site Name, which need to be associated with data of other models, but the three models belong to data of physical address category, which are considered to be possessed in advance and cannot be changed easily. These three models are not listed.
Watch four
The attribute Related Rack in Module is associated with Equipment Address. The value of the Related Rack attribute can only be the value of Device Name of Equipment Address that has been imported into the system.
Watch five
The attribute Related Object in FDT Splitter is associated with Equipment Address. The value of the Related Object attribute can only be the value of the Device Name of data for which Device Type of Equipment Address that has been imported into the system is FDT.
Watch six
The attribute Related Object in the FAT Splitter is associated with the Equipment Address. The value of the Related Object attribute can only be the value of the Device Name of data whose Device Type is FAT that has been imported into the system.
Watch seven
The attributes A-Device and Z-Device in the envelope Segment are associated with Equipment Address. The values of both attributes can only be the values of Device Name of Equipment Address that has been imported into the system.
Table eight
Attributes A Device Name and Z Device Name in Jumper are associated with Equipment Address, FDT Splitter, FAT Splitter. The values of the two attributes can only be the value of Device Name of Equipment Address or the values of POS Name of FDT Splitter, FAT Splitter, which have already been imported into the system.
Watch nine
The attribute Device Name in Terminate is associated with Equipment Address. The value of an attribute can only be the value of Device Name of Equipment Address that has been imported into the system.
The latter two models, Customer Address and Address-Resource Binding, are not mandatory and are not described first.
The association relationship described above is mainly the association relationship between each model and Equipment Address. The associations between other models are not fully described.
And step two, filling data into the template. The data may be manually populated by the customer or programmatically populated by other resource systems.
And step three, uploading the data file on the page or sending a message generated by the data file to the server to wait for the acquisition of the server, and simultaneously generating an import task.
If the template is manually filled by a client, the client needs to import the data file in a foreground page after filling data, the import operation is finished in a mode of creating an import task, and the import task is generated while importing the file.
If the template is filled by other butt joint resource systems, after the data is filled, the system needs to send a message that the data file is generated to the server, and the server generates an import task and returns the message that the message is received after receiving the message.
The data entry program periodically trains and executes the import tasks, and the quantity of the simultaneously executed import tasks can be controlled through configuration so as to control the server resources consumed by all the import tasks. The import task has several important attributes: the system automatically adds the task according to the login user; the task state comprises four types of non-execution, execution failure and execution success; a task start time; task end time; and (4) task details and details can be exported, if the import fails, the position of error data is marked in the details, an error information attribute is added in the model to give the reason of each error data error, and if the import succeeds, the details are imported data.
By utilizing the detail export function, a client can efficiently correct error data, and can modify all error reasons of all error data of one model at one time, so that the data entry efficiency is improved; the task creator and detail export functions together can serve to review which users import which data, facilitating review and management by administrators.
And step four, executing the data import task, and modifying the execution state of the data import task into the execution state. Data import is subdivided into four small steps:
and 4.1, collecting the data file, wherein the step is carried out when the data file is required to be collected by the server for data sharing among the systems, and the step is skipped if the data file is imported in a foreground page.
And 4.2, analyzing the data, and generating other required fields by using the existing data after the data file is obtained according to the established rule, particularly obtaining the unique identifier of the associated data, wherein the unique identifier is used for associating the data by the program after all. The data analysis is prepared for the subsequent steps, and the subsequent steps are convenient to carry out.
And 4.3, checking the data, wherein the data is checked to ensure the accuracy of the data, and the checking rule can be configured as required. There are two kinds of configuration files, one is used to configure the model name and check rule file name; one is a check rule file, one check rule file corresponds to one model, and all check rules used by all fields of the corresponding model are configured in one check rule file. The check rules are various and can be non-null check, digital type check, integer check, length check, size check, whether to repeat check, check whether the associated data is already at the server side, and check whether the used associated data is correct.
The step of checking the data matches the rules used corresponding to the data used for the model being executed. If the verification fails, marking which data fails and recording the verification rule that the data fails to pass, ending the data import task, and modifying the task execution state into the execution failure state.
And the client reforms the data according to the reason of the data error, namely the failed verification rule, and then the step two is carried out again.
If the verification is successful, the following steps are then performed.
And 4.4, recording data, wherein the recorded data comprises the insertion of new data and the modification of the existing data, and the recorded data can be recorded into one database or a plurality of databases according to the requirement.
After entering data into the database, data entry for one model ends. And 4 small steps of the fourth step are carried out on the data of the next model until the data entry of all models is successful.
And after all data entry is successful, modifying the execution state of the task into the execution success state, and finishing the data entry task.
Description of the terms
FTTH is an abbreviation for fiber to the home, i.e. fiber directly to the home.
The service opening means that a natural person opens a voice service or a broadband service or an IPTV service of a family at a business hall of a telecom operator.
OSP is an outside line system that can present a model (resource) on a map based on latitude and longitude information of the model. The physical address where the model (resource) passes, the buildings and facilities passing, and the geographic environment of roads, rivers and the like which a resource needs to pass to a target position can be seen through the OSP.
Claims (5)
1. A standardized and streamlined data entry method is characterized in that,
providing a standardized template consisting of models with incidence relations, manually uploading data files filled by a user according to the template to a server through a foreground page or informing the server to collect the data files;
further comprising:
after the data file is uploaded or the server side receives a message generated by the data file, a data entry task is generated, wherein the task information comprises an execution state, a result, execution starting time, execution ending time and a task creator; if the import fails, the export task details check which error data is and which error reason is;
further comprising:
the data entry program performs an import task in a timing round training mode;
further comprising:
after the task is executed, the server side firstly obtains the uploaded data file or the collected data file;
analyzing, verifying and inputting the data file, returning an execution result, and marking the data which is input in failure and the reason of the data input in failure if the execution fails;
further comprising:
the analysis, the verification and the input are performed by taking the model as the granularity, the input failure of any model returns the result of the execution failure, and the subsequent model is not analyzed, verified and input any more;
further comprising:
the analysis means that the ID corresponding to each associated data is found according to the information provided by each piece of data;
the verification can carry out verification of all rules on the full data;
and the logging operation is performed after all data are successfully verified.
2. A standardized and streamlined data entry system is characterized by mainly comprising:
the system comprises a standard template module, a data file uploading module, a data file collecting module, a data file analyzing module, a data file checking module, a data file inputting module, an error marking module and an inspection module; wherein,
the standard template module provides a standardized template consisting of models with incidence relation, and the incidence relation enables a user to accurately recognize the incidence relation among the models when filling data;
the data file uploading module uploads the data file filled according to the template to a server;
the data file acquisition module is used for informing the server to enable the server to acquire data after the data file is generated when the data file acquisition module is in butt joint with other systems;
the data file analysis module finds the ID corresponding to each associated data according to the information provided by each piece of data;
the data file checking module is used for checking all rules of the full data;
the data file input module is used for inputting operation after all data are successfully verified, and inputting the outside line data into the OSP system;
the error marking module marks the data and reasons of the recording failure;
and the checking module is used for checking the execution condition of the data entry task.
3. The system of claim 2,
the system also comprises a memory and a processor, wherein the processor and the memory finish mutual communication through a bus; the memory stores program instructions executable by the processor.
4. The system of claim 3,
a computer-readable storage medium is also included, having a computer program stored thereon.
5. The system of claim 3 or 4,
the program when invoked by the processor performs the following:
after the data file is uploaded or the server side receives a message generated by the data file, a data entry task is generated, wherein the task information comprises an execution state, a result, execution starting time, execution ending time and a task creator; if the import fails, the task detail can be exported to see what the error data is, what the error reason is;
after the task is executed, the server side firstly obtains the uploaded data file or the collected data file;
analyzing, verifying and inputting the data file, returning an execution result, and marking the data which is input in failure and the reason of the data input in failure if the execution fails;
inputting data into an OSP system;
reorganizing the data files according to failure reasons, and checking which people import which data according to task information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811203202.0A CN109189849B (en) | 2018-10-16 | 2018-10-16 | Standardized and streamlined data entry method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811203202.0A CN109189849B (en) | 2018-10-16 | 2018-10-16 | Standardized and streamlined data entry method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109189849A CN109189849A (en) | 2019-01-11 |
| CN109189849B true CN109189849B (en) | 2022-02-18 |
Family
ID=64944829
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811203202.0A Active CN109189849B (en) | 2018-10-16 | 2018-10-16 | Standardized and streamlined data entry method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109189849B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118193521A (en) | 2019-09-27 | 2024-06-14 | 钉钉控股（开曼）有限公司 | Information importing method and device |
| CN110995437B (en) * | 2019-10-22 | 2022-12-02 | 威富通科技有限公司 | ETC system-based user information input method, device, equipment and storage medium |
| CN112612842A (en) * | 2020-12-30 | 2021-04-06 | 南方电网深圳数字电网研究院有限公司 | Standing book information input method and device, electronic equipment and storage medium |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6754674B2 (en) * | 2000-11-03 | 2004-06-22 | Strohl Systems Group, Inc. | Method and apparatus for creation and maintenance of incident crisis response plans |
| CN101452441A (en) * | 2008-12-05 | 2009-06-10 | 山东浪潮齐鲁软件产业股份有限公司 | Electronic table general-purpose data parsing and leading-in method |
| CN101882266A (en) * | 2010-06-22 | 2010-11-10 | 方志忠 | Account making system for medium-sized and small enterprises |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN105550267B (en) * | 2015-12-09 | 2018-09-07 | 西南交通大学 | A kind of method and system handling welding performance data using Excel formatted datas |
| CN106250472A (en) * | 2016-07-29 | 2016-12-21 | 广州仕邦人力资源有限公司 | A kind of EXCEL data lead-in method |
| CN106503222A (en) * | 2016-11-04 | 2017-03-15 | 上海轻维软件有限公司 | Batch based on Excel imports the method and device of management data base |
| CN106951534A (en) * | 2017-03-22 | 2017-07-14 | 北京数猎天下科技有限公司 | A kind of big data visualizes the graphic processing method and device of data correlation relation |
| CN108595597A (en) * | 2018-04-19 | 2018-09-28 | 平安科技（深圳）有限公司 | Data lead-in method, device, computer equipment and storage medium |
-
2018
- 2018-10-16 CN CN201811203202.0A patent/CN109189849B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN109189849A (en) | 2019-01-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7916925B2 (en) | System and method for generating magnetic ink character recognition (MICR) testing documents | |
| US7653641B2 (en) | Abstraction control solution | |
| CN109189849B (en) | Standardized and streamlined data entry method and system | |
| CN102122265B (en) | System and method for verifying computer software test results | |
| CN109710810B (en) | Change management method, device, equipment and storage medium | |
| CN112416778B (en) | Test case recommendation method and device and electronic equipment | |
| CN106649500A (en) | Data verification method and system | |
| US20140351686A1 (en) | Expert system for automation, data collection, validation and managed storage without programming and without deployment | |
| CN114185770A (en) | Method and device for generating test data, computer equipment and storage medium | |
| CN109740129B (en) | Report generation method, device and equipment based on blockchain and readable storage medium | |
| US20160019266A1 (en) | Query generating method and query generating device | |
| CN110231937A (en) | Script defects scanning method, device, computer equipment and storage medium | |
| CN111815169A (en) | Business approval parameter configuration method and device | |
| CN115526605A (en) | Enterprise internal control management-based approval method and system | |
| CN117493158A (en) | Test method and device, electronic equipment and storage medium | |
| CN115221380A (en) | Method, system and platform for managing urban construction files in batches | |
| CN109636303B (en) | Storage method and system for semi-automatically extracting and structuring document information | |
| CN114254617A (en) | Method, device, computing equipment and storage medium for revising clauses | |
| CN112651716A (en) | Data processing method, device and storage medium | |
| CN117093497A (en) | Test report processing method and device, electronic equipment and storage medium | |
| CN110008772B (en) | Method and system for rapidly identifying and inputting invoice for tax administration | |
| CN113704123B (en) | Interface testing method, device, equipment and storage medium | |
| CN115934044A (en) | Approval process configuration method and device based on flowable | |
| CN113421053A (en) | Service management method, system and computer readable storage medium | |
| CN111159988A (en) | Model processing method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 250100 S06 tower, 1036, Chao Lu Road, hi tech Zone, Ji'nan, Shandong. Applicant after: INSPUR COMMUNICATION AND INFORMATION SYSTEM Co.,Ltd. Address before: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant before: Beijing MetarNet Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |