Dynamic configuration method and system for external imported data

Abstract

The present invention relates to a dynamic configuration method and system for the external imported data. The method comprises: according to to-be-imported data, configuring a service type configuration table and a field column name configuration table; according to a corresponding service type, obtaining configuration information in the corresponding field column name configuration table, and generating a template document; determining whether a to-be-imported document is matched with the template document or not, if so, reading a data column from the to-be-imported document, and dynamically inserting the data column into a corresponding table of a database; or otherwise, returning feedback information of rejecting the imported data. According to the method and the system provided by the present invention, the development and maintenance difficulties of the external imported data are lowered; and a data type and a data column definition corresponding to the to-be-imported data are configured in the configuration table, a dynamic judgement is implemented by a program, and whether to check and how to check are configured in the configuration table, so that the dynamic judgement implemented by the program can greatly reduce the development of repetitive codes, and locate and solve the problem quickly when the problem occurs. Moreover, the code is universal and can be transplanted and used between systems.

Description

Technical field [0001] The present invention relates to the technical field of data management, in particular to a method and system for dynamically configuring external imported data. Background technique [0002] In the telecommunications industry, the data to be imported has different import data types, data column definitions, and inspection functions. When processing external data import, the existing technology has many implementation steps and complex processes, and the import and family banquet operations of each commission type All need to be managed separately, which corresponds to a set of corresponding codes. However, as the commission types corresponding to non-settled data continue to increase, the existing external data import system can no longer meet the demand. When a new commission type appears, a set of corresponding codes and corresponding verification modules must be attached. This results in a huge amount of code and no versatility, which greatly increases...

AI Technical Summary

Problems solved by technology

[0002] In the telecommunications industry, the data to be imported has different import data types, data column definitions, and inspection functions. When the existing technology processes external data import, there are many steps to implement, the process is complicated, and the import and family banquet operations of each commission type need to be managed separately, corresponding to a corresponding set of codes

However, with the increasing number of com

Images