Reconfigurable multi-source data importing method 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 input efficiency becomes a bottleneck [0004] The source of data processing in the ERP system is the BOM ...

AI Technical Summary

Problems solved by technology

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

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

[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