Thank you very much Mister Shong. This helps me. While waiting for an answer here I had found that this line was the source of my problem and your detailed explanation will help me to automatize the solution. But isn't it normal to have a doctype ina XML file? could it be also because, in the example I gave, the name in the doctype (fmresultset) and the name of the root tag i used (resultset) were different and that caused the errors? I hope Talend allows to used XML files that have a doctype defined.
... View more
Hi all, I am trying to do a simple use of the tFileInputXML to extract information from existing XML file and put them in a tlogRow But I keep getting error with this component. So here is the very simple job that I try to run, wihtout sucess : A tfileinputXML reads the content of an xml file and sends it to a tlogrow file I try to use it with a very simple XML file I created for this test (see component configuration in one of the screnshoots) : the content of the file "C:/talend/bis_project/pit-project.xml" is the following : <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//EN" "/fmi/xml/fmresultset.dtd"> <resultset> <record id="1">data1</record> <record id="2">data2</record> <record id="3">data3</record> <record id="4">data564654</record> <record id="5">data534534</record> <record id="6">data45</record> <record id="7">data78</record> </resultset> It is saved under UTF-8. The configuration of the XML component is in the screenshot too. But the job doesn't work, I keep getting the error 'Invalid character constant' What does that mean? How can I solve this? Any help would be appreciated! Thank you
... View more