ADempiere's import mechanism
To speed up data entry, we often find that some people use Structured Query Language (SQL) to enable direct Data Manipulation Language (DML) to inject information directly into ADempiere databases (this is not a healthy practice!). This method does not include validation of data, or data integrity checking. It is advisable to perform data import using ADempiere's import features.
ADempiere has a methodology to accomplish data import. This is as follows:
First, we need to configure a template that will read and capture data through the Import Loader Format window. To do so, we prepare a columnar format of template, which is flexible. To fulfill our needs, we can add, alter, or amend a column at any point in time.
Continuing this activity, we need to prepare text file data sources that comply with the pre-configured Import Loader Format template.
Next, we load the text file data sources into the system.
Finally, we execute the import procedure. ADempiere will check...
