[resolved] tXMLMap - catch errors/exceptions

[Anonymous]

Hi guys,
I have a small Talend job that reads CSVs and makes an XML from its rows, then moves the CSVs in an archive folder afterwards.
Im having a problem trying to catch CSVs with errors, the job stops and doesnt continue on the other CSVs afterwards.
How can I catch the errors in the XML mapping and be able to move that certain CSV, then continue with the other CSVs in processing them?

[Anonymous]

Thanks for your answers. The question about the tJavaFlex was actually meant to be which section in the component (Start, Main, End). But your problem doesn't look like it is there now. You are getting 8 rows from your input file and that matches the output you are getting. We need to check the config of the tFileInputDelimited. The rest of the job looks like it is behaving correctly.

[Anonymous]

It might also be useful to see the contents of the file (if you can post that).

[Anonymous]

We need to check the config of the tFileInputDelimited.
Here it is:

It might also be useful to see the contents of the file (if you can post that).
Unfortunately this is a confidential XML from out client, but I can say that all the error rows are the same row copied over (for test purposes), I guess thats whats causing it to group them as one. Ill try to simulate unique error rows by tomorrow, the day is about to end in our time zone, glad you mentioned about it, hopefully this will get it working right.

[Anonymous]

My thoughts on possible causes are....
1) The CSV input file does not always use a line feed to separate rows. Could it be  "\r\n"
2) The CSV does not have a header maybe?
I suspect  the rows with the wrong row separator are likely the ones that you have added as errors. The tFileInputDelimited will not filter these because they are the same. It will just return rows according to the settings and data in the file.

[Anonymous]

Client is currently testing the application, hopefully things go well considering possible errors would be within the data and unique from each other.
Thanks so much for the help guys. Much appreciated.