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.

Notes:

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.
- Link to iDempiere ModelValidator tutorial
- Link to ADempiere ImportValidator tutorial
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.