topic problem in import Excel to MySQL in Talend Studio

problem in import Excel to MySQL

Anonymous — Thu, 02 Nov 2017 10:28:25 GMT

Hi friends,

i'm new in talend and i want to know if there a solution to get error. Ex: when i run the job 1000 lines is in databse, but when i have error in line 1001 and i correct the error i want ton continu the job, one solution i have is truncat database and reflate the job and start in ligne 1 not 1001, i want to continu job in line 1001

thanks you

Re: problem in import Excel to MySQL

TRF — Thu, 02 Nov 2017 10:42:21 GMT

Hi,

You may include a status field in the Excel file and put a value (OK or KO) in this field field depending on the operation result.

Then when you read the Excel file, you just have to filter the input rows to exclude whose with status = OK.

You may also start with the your previous post (https://community.talend.com/t5/Design-and-Development/Insert-new-record-if-not-exist-in-database/m-p/40662#M11661); add a primary key on the target table and ignore duplicate keys on insert (not too clean).

Finally, you may set the header field for the tFileInputExcel to 1001 other to ignore top records.

The number of records to be ignored can be defined using a context variable.

Just activate prompt on variable for the corresponding variable and you you will be prompted to enter a value for the variable when the job starts.

Hope this helps.

Re: problem in import Excel to MySQL

Anonymous — Thu, 02 Nov 2017 11:06:05 GMT

Thanks you so much

Re: problem in import Excel to MySQL

Anonymous — Fri, 03 Nov 2017 16:15:13 GMT