• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tSchemaCompliaceCheck rejects 12/5/2011 with "MM/dd/yyyy" pattern

#1 2011-12-16 06:03:21

Belayev
New member
Registered: 2011-04-14
Posts: 3

tSchemaCompliaceCheck rejects 12/5/2011 with "MM/dd/yyyy" pattern

Hello all,

I have isolated this case to tSchemaCompliaceCheck component that I believe is rejecting some dates incorrectly.
It is rejecting 12/5/2011 with "MM/dd/yyyy" pattern.

The date is parsing correctly with SimpleDateFormat as in the following java code:

        String inputStringDate = "12/5/2011";
        SimpleDateFormat dSdf = new SimpleDateFormat("MM/d/yyyy");
        SimpleDateFormat ddSdf = new SimpleDateFormat("MM/dd/yyyy");
       
        Date firstDate = ddSdf.parse(inputStringDate);
        Date secondDate = dSdf.parse(inputStringDate);
       
        assertNotNull(firstDate);
        assertNotNull(secondDate);
        assertEquals(firstDate, secondDate);


Feel free to download entire TalendJob from here:
http://db.tt/wehtVYj8

I'm on Ubuntu 10.10 64 Bit, and I am using TOS-All-r63143-V4.2.2

Offline

#2 2011-12-16 08:01:42

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tSchemaCompliaceCheck rejects 12/5/2011 with "MM/dd/yyyy" pattern

Hi
Sorry that i try to download your job and get some http error.

You don't want to reject 12/5/2011, right?
Try date pattern "M/d/yyyy".
Hope this will help you.

Best regards!
Pedro


Only Paranoid Survive.

Offline

#3 2011-12-16 08:31:36

shong
Talend team
Registered: 2007-08-29
Posts: 10359
Website

Re: tSchemaCompliaceCheck rejects 12/5/2011 with "MM/dd/yyyy" pattern

Hi
We have trouble to access your website, please upload some screennshots of job on our forum directly.

Thanks very much for your support!
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#4 2011-12-16 15:53:56

nestoru
Member
Registered: 2011-08-04
Posts: 52

Re: tSchemaCompliaceCheck rejects 12/5/2011 with "MM/dd/yyyy" pattern

I just confirmed this is an issue. I have uploaded just the job here http://dl.dropbox.com/u/50204770/abc.zip and BTW probably your problem is that the domain tt is not allowed in your country?

In any case I also have the there the original file posted by Belayev in case you want the whole project http://dl.dropbox.com/u/50204770/dateTS … roblem.zip

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tSchemaCompliaceCheck rejects 12/5/2011 with "MM/dd/yyyy" pattern

Board footer

Powered by FluxBB