topic tExtractXMLField - Content is not allowed in prolog. in Talend Studio

tExtractXMLField - Content is not allowed in prolog.

talendtester — Thu, 29 Oct 2015 17:44:18 GMT

My job:
tFileInputXML > tExtractXMLField > tFileOutputDelimited

Error I am getting:
Error on line 1 of document : Content is not allowed in prolog. Nested exception: Content is not allowed in prolog.
Top of my XML file:
<?xml version='1.0' encoding='utf-8' ?>
<workbook source-platform='win' version='9.0' xmlns:user='http://www.tableausoftware.com/xml/user'>

<preferences>
    <preference name='ui.encoding.shelf.height' value='24' />
    <preference name='ui.shelf.height' value='26' />
</preferences>
<datasources>

Re: tExtractXMLField - Content is not allowed in prolog.

Anonymous — Sat, 31 Oct 2015 20:48:11 GMT

Good day
I don't understand because you have 2 components to extract xml content. Only put a tFileInputXml is sufficient to resolve the 90% of the problems.
Do you need to extract nested xml fields?
Please try to use only a tFileInputXml or show me the output fields to extract.
Best regards,
Alfonso Borre
Skype : alfonso.borre
aborresarmiento@yahoo.es

Re: tExtractXMLField - Content is not allowed in prolog.

isodelta — Wed, 18 Jan 2023 08:38:05 GMT

You need to check 2 parameters in the `tExtractXMLField` component :

`XML Filed`
`Loop XPATH Query`. <br> I think this needs to look like `/workbook/something`

Could you supply us more about the XML data you need to extract and `tExtractXMLField` parameters.

Sincerely,

Rabah LEKHEBASSENE