Hi, I have been working on exporting the data from excel input to the MySQL using the TOS 5.6.2. I have been facing the date lenient parsing when I export the date fields. But for CSV files I know the option for strictly checking the dates tFileInputDelimited->Advanced settings->Check date. I am facing the date lenient for excel files ..if the input date value comes wrong its not rejecting..Please see the below example .. and please assist me on this ..I want to reject the wrong dates..is there any option for excel files..?? Suppose my input file date column format is MM/dd/yyyy
If you can code:
read everthing as String and do your own check date
If not:
read everything as string write dirctly as CSV and read with you componant which Support checkdate
Hi.
Thanks for your reply.
I am working with the tfileinputexcel in the Event mode i.e., Less memory consumed for large excel(Event mode). When I try to read the excel file date files it is reading the exact input records.
See the below..
Input Record---> Talend Output
| |
12/13/2015----> 12/13/15
12/18/2015----> 12/18/15
12/4/2015-----> 12/4
/15 Here, Year part is not reading as like as in the input ..it is reading only "YY".
In, Event mode only I am facing this problem. In user mode for small excel files date has been loading the exact values as in the input.
So, is there any options like to check date values strictly in the tfileinputexcel as like check date in the tfileinputdelimited.
And I am not familiar with programing. Please suggest any GUI options.
