2Pack and the good old migration scripts have been the only good tools to use until now. I prefer my new way which i share to others. It is visible as a normalised Excel csv file. It moves directly into its named table in DB via UPDATE or INSERT. As it has no other validation besides inherent DB constraints, it is light and fast. The issue of validation is minimally solved by trial and error until you get a working CSV. For example the following is to import in ProductPrice to make a test case for Libero to work. (*See bottom of post on how to use this.)
Note that this is simplistic, comparing to the more powerful http://wiki.idempiere.org/en/NF1.0_ImportCSV
. Mine is providing ready made templates for instant use. Such templates which are a work in progress (ProductMaster and Invoice/Line done) can have VBA scripts to validate before exporting and zipping the CSVs for one step import. (Nakarat here in Bangkok is an expert with VBA apps and will assist in that.)
Been a single zip it can be ported similar to 2Pack.zip. Simialrly there is no attachment via corresponding window tab.
*To use this CSV go to http://sourceforge.net/projects/red1/fi ... facturing/
and take M_ProductPrice4Libero.csv. Since it is a single file you attach this without zipping but put in 'M_ProductPrice' as its name in the ModelMaker tab.
(When used as zipped rename the file to 1_M_ProductPrice.csv or in order according to other CSVs within the same zip. No need to put any value in name of ModelMaker. The movies makes this very clear.)