Automated Import Using ETL (Talend)
The purpose of this discussion is to help you automate the import business partners, products, and open documents such as order, invoices, payments, etc...ETL Introduction
ETL Talend Installation
ETL Finished Example using Business Partners
ETL Step by Step Example
See notes below this video.- Instead of using a Talend sequence to set the i_bpartner_id field, it would be better to use a database sequence to sit it automatically. Here is an example. Look for the section named "Default Sequence for Primary Key".
ETL Exporting a Talend Job to Jar for Use in iDempiere Code
Pulled from 2014-05-29 PM Open Discussion. See transcript for where to view in this video.- How to create an ImportValidator (Import Validator) similar to a model validator for propagating custom fields from your import table to the final destination tables.
- 0:08:00 Modifying and Creating forms in ADempiere and iDempiere.
- 0:20:45 Creating a JAR from Talend job for use in an iDempiere form or process.