topic Re: How to convert String to xml Document in Talend Studio

How to convert String to xml Document

Anonymous — Sat, 16 Nov 2024 12:46:36 GMT

Hi,
Trying to parse database varchar column as XML document, here what I did
1. in tMap, convert string column to Document by calling ParseUtils.parseTo_Document(xmlString)
2. in tXMLMap, use metadata xml defintion and map the xml elements/attributes to output columns.
The job compiles OK. but the columns all come out null. I try the same xml as file, the tFileInputXML parse the column correctly.
Am I missing any step?
I am using TOS 4.2.1

Re: How to convert String to xml Document

Anonymous — Wed, 27 Jul 2011 16:28:50 GMT

I switched to tExtractXMLField and it worked. Still wondering why above approach failed.

Re: How to convert String to xml Document

Anonymous — Thu, 28 Jul 2011 11:30:42 GMT

Hi,
You may have encountered a bug that will be fixed in 4.2.3.
http://www.talendforge.org/bugs/view.php?id=22500
-Carl

Re: How to convert String to xml Document

Anonymous — Fri, 14 Feb 2014 13:36:17 GMT

From another post, I found tConvertType which did exactly what I was looking for here!