A reconfigurable method for importing multi-source data in erp system

Abstract

The invention discloses a reconfigurable multi-source data importing method in an ERP system. The reconfigurable multi-source data importing method includes the following steps that importing templates are configured according to data needing to be imported; the data which are represented in an EXCEL format, or a CSV format, or an XML format or other formats and provided by a user are converted into intermediate processing files through a standard interface; the corresponding importing templates are matched according to the types of the imported data; information after the matching is carried out is updated according to matching information; updating of associated information is finished according to associated information configuration and importing mode configuration; according to configured checking specifications, the imported data are checked item by item; after passing the check, the data enter the intermediate processing process of data to form an intermediate transition table of the imported data; the data in the transition table are imported into a target table according to the configured data importing mode. The multiple data importing modes are provided in a reconfigurable form, the flexibility and the dynamism needed by data importing are achieved, and a checking rule base provides data integrity and validity rules in different modes.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method for importing multi-source data in a reconfigurable ERP system. Background technique [0002] With the in-depth development of advanced information technologies such as the Internet of Things, enterprises have more urgent needs for resource planning systems (Enterprise Resource Planning, ERP). As an enterprise information decision-making and management platform, the ERP system is based on the logistics information, manufacturing process information, financial information, etc. in the operation process of the enterprise. The data information mainly comes from the data manually entered into the system and the data imported into the system during the management process. Currently, these two methods have the following problems and defects: [0003] (1) Manual entry efficiency becomes a bottleneck [0004] The source of data processing in the ERP system is the BOM ...

AI Technical Summary

Problems solved by technology

[0004] The source of data processing in the ERP system is the BOM information of the product, and the manual entry method is not only cumbersome, but also error-prone

Especially in some large-scale equipment manufacturing enterprises, due to the complex structure of the product and the use of personalized customized design and production, the product BOM data volume is large and the difference is large, and the efficiency of manual entry is low, which leads to the extension of the technical preparation cycle, and even the ERP system. implementation becomes difficult

[0005] (2) Multiple data import requirements restrict the development speed of ERP system

Therefore, the more functions required to import data, the greater the amount of ERP system code development required, which affects the development and implementation progress of the ERP system

[0007] (3) Unidirectionality of imported data and difficulty in matching with ERP system data

The traditional method is to write the corresponding data interface implementation, which can only realize one-to-one data import, and the code development workload is heavy, and the portability is low, especially as the demand for data import increases.

[0009] To sum up, the existing technologies and methods can reduce the cumbersomeness and intensity of data import into the ERP system to a certain extent, but they cannot fundamentally solve the multi-directionality of data import in the ERP system and the dynamic changes in user needs. Difficulty and Ease of Importing

Images