Reconfigurable multi-source data importing method in ERP system

An ERP system and multi-source data technology, applied in the field of data processing, can solve the problems of restricting the development speed of ERP system, the difficulty of data matching in ERP system due to the unidirectionality of imported data, and the inability to fundamentally solve the problems of ERP system, etc., so as to achieve simple data import and fast, solve flexibility and dynamic problems, reduce the effect of development workload

Inactive Publication Date: 2015-01-28
WUHAN UNIV OF TECH
View PDF7 Cites 58 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 th

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
  • Reconfigurable multi-source data importing method in ERP system
  • Reconfigurable multi-source data importing method in ERP system
  • Reconfigurable multi-source data importing method in ERP system

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0036] In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

[0037] Such as figure 1 As shown, a method for importing multi-source data in a reconfigurable ERP system includes the following steps:

[0038] 1) Configure the import template according to the data to be imported, including the following steps:

[0039] 1.1) Configure the basic information of the import template. The basic information includes the position of the header of the data template to be imported, the number of columns to be imported, and the underlying database processing function that is executed when the import page is loaded and closed; the data template to be imported includes EXCEL, CSV or XML data templat...

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 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 ...

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
IPC IPC(8): G06F17/30
CPCG06F16/2219G06F16/2282G06F16/2365G06F16/2386
Inventor 郭顺生杜百岗李益兵彭兆郭钧陈艳霞
Owner WUHAN UNIV OF TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products