Detail 20140926 - iDempiere New Import and Export
2014-09-26 - iDempiere New Import and Export
- Introduction
- 0:01:30 Export product data to create an example for using the import process
- 0:02:00 Review exported CSV data - introduce header nomenclature
- No longer need to reference the ID - instead call by name or value
- Includes sub-tab table and fields
- Example: M_Substitute>M_Product_ID[Value]
- 0:04:15 Review import CSV pulled from export example
- 0:05:00 Import (Insert) 6 product records
- 0:05:30 Review log of imports
- 0:06:16 Turn some of the previously imported products into BOM lines
- 0:07:00 Export Product with BOM lines for reference
- 0:08:00 How to specify import key columns
- 0:09:30 Merge in BOM lines for existing products
- 0:10:45 Use the same process to update the Product Name and the BOM Qty at the same time with an additional merge
- 0:12:15 Difference between Insert, Update, and Merge import methods.
- 0:13:30 Apply the same concepts to Business Partners, Locations and Contacts