Import Validation Helper
Contents
Overview of Data Import Validation
In ADempiere, when come to importing data from legacy system, normally we turn to Data Import module (&Menu > System Admin > Data > Data Import).
Following picture depict the concept of how this module works.
If you have been working, and digging into this module before, you will know that the most important part is the validation of raw data --> to data that is valid to ADempiere.
For example, when importing Product, one of the data required is "Product Category". In the Import Product window, you will see 2 fields.
When run Import Product, the "Product Category Key" will be validated (using SQL) to get a valid M_Product_Category_ID for "Product Category".
For example, Product Category Key = "TILE" --> Product Category = "Tile" (M_Product_Category_ID = 101.
It is the "Product Category" that is valid to ADempiere