Chapter 11. Importing Data

During the implementation of, or migration to, a new ERP system such as ADempiere, there will be existing data that will need to be entered into ADempiere. This existing data can be entered item-wise, one-by-one. Entering a small amount of data would not be a problem, but when working with a large amount of data, the process is time-consuming and error-prone. Recovering from incomplete data will be an exhausting and costly affair. We need effective and efficient ways to input such data into the system.

By default, ADempiere provides us with an import feature. Before we proceed to the import processes, we will discuss the following:

• Import Loader Format

• Import File Loader

After understanding these features, we will continue on to practicing how to import data, which includes importing:

• Business Partners

• Products

• Currency Rates

• GL Journal entries

• Orders (both Purchase Order and Sales Order)

• Invoices (both Invoice (Vendor) and Invoice (Customer))

• Inventory

• Statements

We will start...