problem to load: tfilellist xml to table sql

[hechmi]

Hi all;

i have a problem when i load table from tfilelist xml 

in tfilelist i have 290 file xml when i load with iterate xsd and tmap to table mysql , just one row i find in a table  

my job is: tfilelist (import all file xml )------>tfileinputxml(xsd)---->tmap---->table sql 

the proble is 290 file  input ------> 1 rowoutput ????   i want to have 290 row ourput (in sql )

i put a screen 

job of loadmysql out put in data base mysql

[Anonymous · Accepted solution]

Hi,

     For the interim analysis, could you please a dd a tlogrow instead of tMySQLOutput and run the job again? This step is to verify whether the data is coming till tMySQLOutput.

     Once it is confirmed that the data is coming till that point, could you please select Die on error option in tMySQLOutput and run the job again? Most probably the data might be ignored due to some DB error. But this will be tracked if we add Die on error.

     Please let us know the results and we will take it from there.

Warm Regards,

Nikhil Thampi

[hechmi]

tkank you @nthampi ;

the solution in  two step :

-first i add a tlogrow instead of tMySQLOutput and run the job i find the error that is a double cote in colum date  i correct it and  run the job again, no error her and the job run ok 

 and run the job again.

 -second step i select Die on error option in tMySQLOutput and i drop the table from data  base and run the job again  no error her and the job run ,good solution

best regards

[Anonymous]

Happy to know that you were able to resolve the issue.

Enjoy programming in Talend 🙂

Warm Regards,

Nikhil Thampi