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,
If I understand you very well, you need parse "String" to "Date". If so, use the expression in tMap

TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",row1.Value)

.
Best regards
Sabrina

[Anonymous]

Hi any one can help me


Can you tell me how can I convert the date data of "14/09/2001" from MS Access to mssqlserver date format ("yyyy-mm-dd") as "2001-09-14" by using tMap function in Talend Open Studio, please?

[Anonymous]

Hi,
If you input data type is "Date", you can just change schema setting using tMap.
See my screenshot.
Feel free let me know if I misunderstanding your current situation.
Best regards
Sabrina

[Anonymous]

Hi can any one help me to solve this problem..........Hi , i have a source in excel with the following data
id name dateofbirth salary hiredate
1 xays 24/01/1994 100 05/07/2012
2 xyz 22/10/1991 200 04/02/2012
3 kjsdj 04/02/1990 300 14/01/2008
4 dfdkl 06/06/1989 400 16/02/2010
here rowno1 24/01/1994,dateofbirth is displaying in excel as a general format
and rowno2 22/10/1994 dateofbirth is displaying in excel as a general format
and rowno 4 16/02/2010 hiredate is displaying in excel as a general format. so while iam loading this from excel to target iam getting the following error
The cell format is not date in row1 date of birth
The cell format is not date in row2 date of birth
The cell format is not date in row4 hire date Because the above mentioned rows are in general format in excel sheet.
my expetation is i want to get all the rows from source to target.
But if i used parsedate in tmap the complete date value has been changed like.....
row1 date is 24/01/1994 as changed to like this 01/12/95 and
row2. 22/10/1991 is changed to 10/10/19992
can you show me the screen shot please for this solution

[Anonymous]

Hi sabrina,

can you provide me the steps to install the talend enterprise data integration part on windows 7, because now iam going to use talend enterprise data integration.
Iam confusing with talend server and designer tool................

[Anonymous]

Hi anyone can help me how to solve this problem...........

I have a date in my Excel file is 01-JAN-06. 01 represents the day of the week, JAN represents the month and 06 represents the year. The Excel file also contains date values of 00-XXX-00 which represent no date. For example a column containing last purchase date data would look like this:"DateOfLastOrder"
"01-JAN-06"
"02-JAN-06"
"00-XXX-00"
"03-DEC-05"The value of 00-XXX-00 means that there is no purchase date.I want to bring these columns into my table and replace the 00-XXX-00 values with a NULL.
The table of tmssqloutput Data Type is datetime.
This is the error iam getting: only the date between january 1 1753 and december 31 9999 are accepted .

[Anonymous]

Hi, any one can provide me one snapshot for joblet with example, because i am confusing with schema while creating joblet in talend enterprise edition.
here i am doing concatinating fname+lastname=full name in variable tmap
Here i have used schema for emp table for joblet and how can i use this for another job .............
In another job i have customer table.............

[Anonymous]

Hi,

can you provide me the steps to install the talend enterprise data integration part on windows 7, because now iam going to use talend enterprise data integration.
Iam confusing with talend server and designer tool................

Sorry for delay.
Here is an installation document for talend enterprise data integration, TalendHelpCenter:Talend Enterprise Data Integration:Installation and Upgrade Guide, could you please take a look at it?
Feel free let me know your difficulty and issue on it.
Best regards
Sabrina

[Anonymous]

Hi,

Hi can any one help me to solve this problem..........Hi , i have a source in excel with the following data
id name dateofbirth salary hiredate
1 xays 24/01/1994 100 05/07/2012
2 xyz 22/10/1991 200 04/02/2012
3 kjsdj 04/02/1990 300 14/01/2008
4 dfdkl 06/06/1989 400 16/02/2010
here rowno1 24/01/1994,dateofbirth is displaying in excel as a general format
and rowno2 22/10/1994 dateofbirth is displaying in excel as a general format
and rowno 4 16/02/2010 hiredate is displaying in excel as a general format. so while iam loading this from excel to target iam getting the following error
The cell format is not date in row1 date of birth
The cell format is not date in row2 date of birth
The cell format is not date in row4 hire date Because the above mentioned rows are in general format in excel sheet.
my expetation is i want to get all the rows from source to target.
But if i used parsedate in tmap the complete date value has been changed like.....
row1 date is 24/01/1994 as changed to like this 01/12/95 and
row2. 22/10/1991 is changed to 10/10/19992
can you show me the screen shot please for this solution

Is the data type in excel "Date" or "String"? If later, do you want to parse "String" to "Date" into target DB?(The method: TalendDate.parseDate("dd/MM/yyyy ",row.dateofbirth)).
Would you mind sharing your tMap editor screenshot into forum so that we can get your situation more precisely.
Best regards
Sabrina

[Anonymous]

Hi any one know how to set max value to the context variable for incremental load at each run..................and how to increase this value for each run.
here i am using incremental load based on date field, so i used some date value for context variable(initially) for the first run. Based on this value iam filtering but i dont know how to increase this value for the next run .....
If any one knows ,than kindly provide me the solution.