[resolved] xml file to map :tXMLMap_1_TXMLMAP_OUT Unparseable date

One Star

[resolved] xml file to map :tXMLMap_1_TXMLMAP_OUT Unparseable date

Hello all!
I stripped my process to the bare minimum. tFileInoutXML - > tXMLMap ->tLogrow
 with 2 field : TransmissionCode (string) and TransmissionDateTime (dateTime).
The date in the file is : 2017-03-17T20:17:03
The output of the tFileInoutXML is a Type Document.
In the tXMLMAp I defined the field TransmissionDateTime as a Date with Date pattern: "yyyy-MM-dd'T'HH:mm:ss"
Yet it crash with tXMLMap_1_TXMLMAP_OUT Unparseable date: "2017-03-17T20:17:03"
Exception in component tXMLMap_1_TXMLMAP_OUT
java.lang.RuntimeException: Unparseable date: "2017-03-17T20:17:03"
If I check the code I see the folowing:
Header_tmp.TransmissionDateTime = treeNodeAPI_tXMLMap_1_TXMLMAP_OUT
                                            .get_Date(
                                                    "ColtraneFile.Coltrane:/CollegeTransmission/Header/TransmissionDateTime",
                                                    "dd-MM-yyyy");
Now where and why do the treeNodeAPI_tXMLMap_1_TXMLMAP_OUT is calling getDate( "dd-MM-yyyy") ?
Thank you for your help,
Isabelle

Accepted Solutions
Community Manager

Re: [resolved] xml file to map :tXMLMap_1_TXMLMAP_OUT Unparseable date

Hi  
In the input schema, define the date pattern as "yyyy-MM-dd'T'HH:mm:ss" also, it should work now.

1.png

Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] xml file to map :tXMLMap_1_TXMLMAP_OUT Unparseable date

Hi 
I am trying to reproduce the issue, can you please upload some screenshots of your job or export your job and send it to me via email?
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] xml file to map :tXMLMap_1_TXMLMAP_OUT Unparseable date

Hi Shong,
I send you an email titled
export of job for
Thank yo uso much for your help,
Isabelle
Community Manager

Re: [resolved] xml file to map :tXMLMap_1_TXMLMAP_OUT Unparseable date

Hi  
In the input schema, define the date pattern as "yyyy-MM-dd'T'HH:mm:ss" also, it should work now.

1.png

Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] xml file to map :tXMLMap_1_TXMLMAP_OUT Unparseable date

That flew right past me,
Thank you so very much, this is a good way to start a week!