topic Re: Using HTML tag on xml file from txmlmap in Talend Studio

Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 09:15:20 GMT

Hello, I have a XML file with many rows, and in my tXmlMap, I need one rows who contains html

In this rows, I use the html tag in my tXmlMap, but he stop read at the first line and talend send me error

ORA-01400: Cannot insert NULL into ("DB"."table"."column")

But, other xml file with many html rows , its working for exemple, after my Hello, I press enter to make a new line, its working

Edit: I tried to use this

StringHandling.EREPLACE(row2.html,"</p>","</p><br>")

but nothing

Re: Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 12:49:00 GMT

I'm afraid your explanation of your problem is not very clear. Are you trying to interrogate HTML using a tXMLMap?

Re: Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 13:44:11 GMT

Hello ( sorry for my bad English :s )

So I have on xml file , and in this, i need the tag, so i put in my tXmlMap but in my tLogRow , it show me nothing while my tag contains one rows ( at the top of the page screen, this is the error returned)

And when i want to insert this data, I got error " NULL" but in my XML file ther is not null

Re: Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 13:58:19 GMT

Can you post an example of the XML and the element that you want to return? There may be a different component you can use as I suspect the tXMLMap will not be suitable.

Re: Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 15:08:01 GMT

This is my xml tag who contains the html information ( I need all informations in all tag

This is my logrow , he show me nothing

This is my txmlmap colomns ( main row)

And in my tFileInputXML, in the XPath request for my html, i used //* at end for read all line, and now, he show me the rows BUT only the first tag and not all tag

Re: Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 15:33:01 GMT

That is because your <html> element contains only another element as far as the XMLMap is concerned. Therefore it is quite rights returning null. Try using the tExtractXMLField to get this HTML tag. You will need to use XPaths for this. You will also need to tick the Get Nodes" box for the column you want to receive the value in.

Re: Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 15:51:01 GMT

Oh okey, I see, but how i should use the ExtractXMLfield ? because I got " Error on line1 of document, Nested exception"

@rhall wrote:

That is because your <html> element contains only another element as far as the XMLMap is concerned. Therefore it is quite rights returning null. Try using the tExtractXMLField to get this HTML tag. You will need to use XPaths for this. You will also need to tick the Get Nodes" box for the column you want to receive the value in.

Re: Using HTML tag on xml file from txmlmap

Anonymous — Wed, 14 Feb 2018 16:07:30 GMT

You need to be working with a Document. If it is a String, you need to convert it to a Document using a tConvertType component. If you are using HTML and NOT an XML Document, it won't work in many cases. It MUST be XML

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 08:02:23 GMT

So i'm using a tHttpRequest to get my file and tFileInputXML for read it .

I replace my tFileInputXml by the tExtractXMLField ?

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 08:36:43 GMT

Problem is tag

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 10:27:44 GMT

You're not using XML. XML and HTML are similar but are not interchangeable. If you want to parse HTML, you will need to use third party Java APIs. I have written a tutorial on how this can be done here: https://www.rilhia.com/tutorials/using-third-party-java-library-scrape-content-table-web-page

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 10:28:10 GMT

when I press space between

<my:Description><html xmlns="http://www.w3.org/1999/xhtml" xml:space="preserve"> <p>

my html tag and tag its work fine, but the file comes with no space and I can't edit file (The job insert the data in db)

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 10:34:27 GMT

What error are you getting? The actual error in the output window in full.

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 10:35:10 GMT

Ther is my xml file

Besoin%20Assistance-2018-02-02T14_59_24-test.xml

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 10:41:27 GMT

This is from normal xml file without the space between >

and

this is when i put space between >

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 11:09:08 GMT

This is a nasty file to work with. I don't believe it is well formed at all....but then Microsoft seldom conform to standards. The "my" is not bound....was the file you sent me edited? Anyway, after removing the broken XML I was able to get the following XPath to work with or without a space between html and ....

"./DATA/Description/html/p"

I was using just a tFileInputXML and had "/WebFORM" as the Loop XPath query.

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 12:44:59 GMT

Hi and thx for reply, so yes I upload a new file, sorry I edited the old file.

I don't use the XPath "./DATA/Description/html/p" because I have other XML file with many tag like this and its show me only the first tag , "Bonjour," and not all tag, and I used "./DATA/Description//*" to read all line in description

Besoin%20Assistance-2018-02-13T15_02_15-test2.xml

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 13:58:51 GMT

Using your new file (it is still missing a namespace for "my", but I added a dummy one), I was able to return .....

<html xmlns="http://www.w3.org/1999/xhtml" xml:space="preserve"><p>Bonjour,</p>
<p>Je vous remercie de bien vouloir renommer le répertoire Solidarités par Actions Solidaires qui se trouve sur H, direction des Solidarités et de la Santé Publique.</p>
<p>Cordialement</p>
<p>Stest </p></html>

....using an XPath of "./myATA/myescription/html" and keeping "Get Nodes" ticked. By unticking "Get Nodes" I get .....

Bonjour,
Je vous remercie de bien vouloir renommer le répertoire Solidarités par Actions Solidaires qui se trouve sur H, direction des Solidarités et de la Santé Publique.
Cordialement
Stest

Is this not what you want?

Re: Using HTML tag on xml file from txmlmap

Anonymous — Thu, 15 Feb 2018 17:03:37 GMT

Did the above work?

Re: Using HTML tag on xml file from txmlmap

Anonymous — Fri, 16 Feb 2018 08:24:24 GMT

Hey, sorry for late reply ( time difference maybe ) So I tried again the XPath

 "/my:DATA/my:Description/html"

But it still return me all the html in my xml file, its Ok

But ther is not returning html on file with only one tag like this file !

Besoin.xml