Using HTML tag on xml file from txmlmap

[Anonymous]

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 <p> Hello, </p> 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

[Anonymous]

So I try , Its showing the xml file with the tag,

but I'm using a tFileInputXML and I get the xml file with

((String)globalMap.get("tFileList_1_CURRENT_FILE"))

So I try this one And I don't get the <p> tag her

I used my XPath query

"my:DATA/my:Description/html"

Idk why it doest work 

And I think its a little be boring for you... sorry...

[Anonymous]

Don't use the tFileInputXML for this. You do not need to. Just replace your section of the job which starts with the tFileInputXML component with the components I showed you.

[Anonymous]

But I have many file (maybe 200 per job execution) and I need to read all file, how can I read all file from my directory ?

[Anonymous]

I don't understand why this is changing the reading of files? Just replace the section that starts with the tFileInputXML and replace it with the job section I gave you. You are still reading the file, just with a different component.

EDIT: Hang on, do you think that 

((String)globalMap.get("tFileList_1_CURRENT_FILE"))

is passing the XML to the component? It isn't. It is passing the file path and name to the component. The component then reads the file.

[Anonymous]

I used the ((String)globalMap.get("tFileList_1_CURRENT_FILE")) but I got error on tJavaFlex

How the tFileInputRaw can read the all file ?

[Anonymous]

You are nearly there. Can you show me the tFileInputRaw component config and you might need to check the tConverType_1 settings. You are getting a null value from there

[Anonymous]

[Anonymous]

What code do you have in your tJavaFlex?

Also, try putting a tLogRow between the tConvertTYpe and the tJavaFlex. See what is output. You have a a nullpointerexception. It means that an object you are using is null. It's pretty simple to solve, you just need to find out what is null and why

[Anonymous]

I used your code, and I just change the row name I have a lot of xml file in my directory but the "Besoin.xml" is not, I tried to copie the the file but still read "Besoin.xml"

[Anonymous]

Hmmmm, I've just realised what this is. I am not sure how your previous file managed to be read. But you need to use ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) rather than ((String)globalMap.get("tFileList_1_CURRENT_FILE"))