topic Re: tFileInputXML failing, 'cannot be resolved to a variable' in Talend Studio

tFileInputXML failing, 'cannot be resolved to a variable'

Anonymous — Tue, 23 Oct 2012 12:36:04 GMT

I've been searching this for about 30 mins now and haven't found the answer.
Normally I work with CSV, but this time XML is the raw data feeds format. For this I'm trying to use the tFileInputXML component. The data used is in the following format:
<?xml version="1.0" encoding="utf-8"?>
<feed xmlns=" http://www.w3.org/2005/Atom" xmlns:g=" http://base.google.com/ns/1.0">
<entry>
<g:id>...</g:id>
<title>...</title>
<description>...</description>
...
<g:mpn>...</g:mpn>
</entry>
<entry>
...
</entry>
</feed>
So, I've setup my fileinputxml with the parameters shown in the two screenshots.
When running I'm getting the error 'x cannot be resolved to a variable' for all the entries in screenshot 1. What am I doing wrong here...?
Any help is greatly appreciated.

Re: tFileInputXML failing, 'cannot be resolved to a variable'

Anonymous — Tue, 23 Oct 2012 12:37:47 GMT

NO idear how, but my 2nd screenshot won't be uploaded, so here it is

Re: tFileInputXML failing, 'cannot be resolved to a variable'

_AnonymousUser — Tue, 23 Oct 2012 15:16:52 GMT

Hi
I do not really know about the error. However, you can try reading the XML file using Metadata>File XML>Create File XML.
This will give options to choose the required columns. Once the configuration is completed, drag and drop into the job. From here on, it should be like any other format.
-
Sangi

Re: tFileInputXML failing, 'cannot be resolved to a variable'

Anonymous — Tue, 23 Oct 2012 16:00:00 GMT

hi,
seems that you've got some namespace in element name . (ex. g:id)
add it to your Xpath queries if necessary.
hope it helps
regards
laurent

Re: tFileInputXML failing, 'cannot be resolved to a variable'

Anonymous — Tue, 23 Oct 2012 16:15:05 GMT

After checking some other slightly related threads, I figured that all the XPath-queries should be in parentheses... Now it seems rather obvious, but so stupid that I didn't notice it.
Thanks for the help though!