*Sorry for my english, i'm french ^^*
I'm a beginner in Talend and i try to make a jobs to work with VtigerCRM.
So, we have 1 table in AS/400 Database and we want to synchronize datas with Vtiger (AS/400 is the main database) all the 24 hours.
So, with tVtigerCRM Module in talend, we can make one type of action per module (Insert, Update, Delete), and i want to use the right action at the right time (the picture is attached to the post).
I do not know how to determine, for each record, whether it has been modified, deleted (id that no longer exists), or it's a new one ...
I don't know if you really understood what I want to do, I can not explain well what I would like to do...
Thank you !
@Minos,you need to compare the As/400 DB sorce table with Target table then only you can figure out that the record is new or existing.
@Minos,you can do with tMap or tJoin..
please find the blelow links to
Finally I did something else, I've already imported all the data, and for comparison I'm just in the process. I was thinking rather to copy the bases on CSV files (12000 lines approximately it's not very heavy) then to check them using the module tFileCompare, the problem and that I would like to separate into subjob (update or insert) according to the answer of the tFileCompare, it is possible ?
@Minos,you can separate the flow since again you need to do lookup with target to derive new record or udpdated record.
Sorry I had another problem in the evening yesterday and I just corrected the problem...
I don't really understand how to separate the flow according to an entry condition in fact...