Date format issue in tFileInputExcel from to TOS 4.1 to 5.3.1

[Anonymous]

Hi all
I´ve update Talend Open Studio for Data Integration from 4.1 to 5.3.1 version and
unfortunately I'm finding big changes reading Date fields in Excel files with the tFileInputExcel component.
I´m reading with the tFileList component different Excel files from different countries (with different date format -> ex: MM-dd-YYYY or dd-MM-YYYY or dd/MM/YY),
with the 4.1 version the Date fields was correctly parsed using sometime "isDate" and "parseDate" function but now I found a lot of issues.
It seem that the date content is read in a different way and for this reason the checks I use in the tMap now are not enough.

Do you know why this happen if the source files and the job are not changed?
Do you have any suggestion?
Thanks in advance
mary

[Anonymous]

Hi mahadevank,
You'd better open a new topic for your current context issue.
Best regardsa
Sabrina

[Anonymous]

My expectation is i want to increase the context value for incremental load at each run. Here i attached my job process for understanding , i hope you understand my process.
In context variable i have assigned this value(Initial value)= 01/01/2000
In first main job iam filtering the data Whose input value is greater than context variable value.
In subjob i am getting the max (Date) from source to increase the context value at each run.
In tjavarow i am assigning this max (Date)value to context variable like Context variable=out.MaxDate

But the context variable is not getting the maxDate value from taggrow component

[Anonymous]

Hi any one can help to solve this problem..................
Here i creating a mapping for incremental load logic.
Here i created one context variable with some initial value is called Contex.Last_Date= 01/01/2000
MY Problem is...................
1. For First time load i used insert option in tmssqloutput for full load , here i got full rows from source correctly .
2.But in second load again it reads all the rows from source and its not filter the rows greater than contex.Last_Date, because the value of context variable is not changed in tfilter .

Please any one knows the solution, than kindly help me to solve this.

[Anonymous]

Hi any one can say for this............
I know how to use job compare and with the help of job compare we will compare two two different jobs or two version of the same job is possible.
But i can't understand what is the use of job compare in talend enterprise edition (what is the use of comparison)

[Anonymous]

Hi any one can say for this............
I know how to use job compare and with the help of job compare we will compare two two different jobs or two version of the same job is possible.
But i can't understand what is the use of job compare in talend enterprise edition (what is the use of comparison)

[Anonymous]

Hi mahadevank

2.But in second load again it reads all the rows from source and its not filter the rows greater than contex.Last_Date, because the value of context variable is not changed in tfilter .

The code expression used to access the input row on tJavaRow is:

context.last_date=input_row.inputColumnName;

Note that the new value of context variable is not permanent if it is stored in memory. As a workaround, you can store the new max date to a property file or database, read it and assign it to context variable at each run.
Shong