Implementation of the ERP data into large three ways
The implementation of ERP summarized several data import methods for different status of implementation of ERP software and can be appropriate, are lessons learned, hoping to help those who pass by.

1. Dataload Tools
Now there is a class of software on the network can help to import data, such as dataload, it works for, first data in EXCEL in order is good, and then look for open dataload memory function, then performs a manually copy the data from EXCEL to the ERP system and preservation action, normative action for, in the ERP system, click on the new inventory items, and then switch to EXCEL copy a field, such as inventory parts coding, and then switch to the ERP system, paste this code, such as some N times, this stock parts information pasted into ERP software, and then click Save, a data entry completed, then in the dataload software recorded the entry action. And then the appropriate settings, dataload software will mimic human movements for excel in the tens of thousands of duplicate data entry, until the completion of entry.

Such data-entry work, suitable for ERP software, there is no specific data import tool, and a data entry would involve the complexity of the background associated with more than one table, so that it is difficult to import procedures for the preparation of the circumstances under which the disadvantage of slow, 10000 data may run for several hours.

2. Call ERP software interface
Are more used in this way, the principle for most of the ERP system, for the preservation of a variety of data, such as create a new inventory pieces are all a function or a uniform interface to call. Some are there in the web service interface function for data preservation, and some in the oracle there are interface functions to achieve the preservation of data. I use more is the oracle of the interface functions, for example as follows.

To create a new inventory items, oracle there would be a function called new part (parameter 1, parameter 2), call this function, or as long as the stored procedure, and given the necessary parameters in the system can generate an inventory pieces. Then, the specific implementations of the data import process is as follows: first of all need to excel in order to import the data, then use the sql statement to write a dat file that the main loop to write the excel file to read each record, as well as the implementation of each record, new part function, of course, the imported data may have format problems to be wrong, so also generates a complete import log files, and import log file failed. Such an approach, because you can write your own programs, they were able to adapt to various types of systems, is widely used.

3. ERP system-specific Import Tool
For some ERP systems have their own import tools, of course, is the best choice. However, it was observed that many dedicated import tool, in fact, according to the principle of the second approach, developed tools.