Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

General service data import method and system

A business data and data import technology, applied in database management systems, digital data processing, structured data retrieval, etc., can solve problems such as lack of versatility, difficulty in maintenance, and difficulty in rapid positioning, and achieve completeness and rapid positioning. problems, the effect of reducing the difficulty of development and maintenance

Pending Publication Date: 2020-09-04
北京思特奇信息技术股份有限公司
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, with the increasing number of commission types corresponding to non-settlement data, the original external data import module can no longer meet the demand. When a new commission type appears, a set of corresponding codes and corresponding verification modules must be attached, which will The amount of code is huge, there is no versatility, and it is difficult to maintain. When an error occurs, it is difficult to quickly locate the problem and solve it

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • General service data import method and system
  • General service data import method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The principles and features of the present invention will be described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0039] Such as figure 1 As shown, a method for importing general business data provided by an embodiment of the present invention, the method includes:

[0040] S1, configure the configuration content corresponding to the business data into the established configuration table;

[0041] It should be noted that the configuration content includes at least one of the data type configuration corresponding to the business data, the data column field definition configuration, the verification function configuration and the audit function configuration.

[0042] S2, downloading an Excel template file containing configuration content;

[0043] S3, fill in the business data into the Excel template file, and import the E...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a general service data import method and system, and relates to the field of telecommunication industry data management. The method comprises the following steps: configuring the configuration content corresponding to the service data into an established configuration table, downloading an Excel template file containing the configuration content; filling the Excel templatefile with the service data; importing the Excel template file filled with the data into a commission settlement system; processing the data of the Excel template file according to the configuration content; synchronizing the processed data to the target table, configuring the data type and the data column needing to be operated in the table by establishing the configuration table, and enabling thesystem to dynamically judge according to the configuration content when the data is imported, so that the development and maintenance difficulty of the external imported data is reduced, and when anerror occurs, the problem can be quickly positioned and solved.

Description

technical field [0001] The invention relates to the field of data management in the telecommunication industry, in particular to a general service data import method and system. Background technique [0002] In the existing commission settlement system, abnormal settlement data such as bills and lists and some normal settlement data need to be entered into the settlement system. Since each commission type has different import data types, data column definitions and verification functions, a commission type in the original external data import module will correspond to a set of corresponding codes. However, with the increasing number of commission types corresponding to non-settlement data, the original external data import module can no longer meet the demand. When a new commission type appears, a set of corresponding codes and corresponding verification modules must be attached, which will The amount of code is huge, there is no versatility, and maintenance is difficult. W...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25G06F40/186
CPCG06F16/25G06F40/186
Inventor 王超
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products