topic Re: tXMLMap trowing Unparseable date: "2008-08-01T13:38:27.133" in Talend Studio

tXMLMap trowing Unparseable date: "2008-08-01T13:38:27.133"

brunosimoes — Sat, 16 Nov 2024 01:51:52 GMT

Hello,

I am trying to parse a XML File to another format to get rid of the XML Overhead. A smaller sample of the file is attached with the name "Posts_Metadata.xml".

I created a metadata process connecting to a tInputXML, that connect to to a tLogRow to test the output before trying to write it and started getting the Unparseable date: "2008-08-01T13:38:27.133". I am trying to connect it now using a tXMLMap to parse the date, but I don't know how to do it. Can anyone please intruct me on what I could do to make this job work?

Re: tXMLMap trowing Unparseable date: "2008-08-01T13:38:27.133"

Anonymous — Mon, 20 Jul 2020 02:20:48 GMT

The date pattern used to parse the date does not map the date format like "2008-08-01T13:38:27.133", change the date pattern of Date column to "yyyy-MM-dd'T'HH:mm:ss.SSS"

Regards

Shong

Re: tXMLMap trowing Unparseable date: "2008-08-01T13:38:27.133"

brunosimoes — Tue, 21 Jul 2020 05:02:29 GMT

It worked, thanks.