[resolved] talend extract xml field

Anonymous — Sat, 16 Nov 2024 13:05:37 GMT

Hey!
I have this job in talend that is suppose to retrieve a field an loop through it.
My big problem is that the code is looping through the xml fields but it's returning null. Here is a sample of the xml:
<?xml version="1.0" encoding="ISO-8859-1"?>
<empresas>
<empresa>
<imoveis>
<imovel>

<fotos>
<nome id="" order="">photo1</nome>
<nome id="" order=""></nome>
<nome id="" order=""></nome>
<nome id="" order=""></nome>
</fotos>
</imovel>

</imovei>
</empresa>
</empresas>

Now using the ExtractXml component I am trying to get the "fotos" element.
I have tried to change the xpath query and the xpath loop query but the result is either I don't loop through the field or I get the null in the value field in the tmap.
You can see the I have retrieved 4 items from the xml but what I get is null in the "nome" field. There must be something wrong with the xpath but I can't seem to find the problem
Hope someone can help me out.
Thanks
Notes: I am using talendv4.1.2 on ubuntu 10.10 64bit
EDIT:
Ok I am able to loop through the xml field
I changed the xpath loop query in the file to:
"/empresas/empresa/imoveis/imovel"
and then changed the loop query in the component to:
"/fotos/nome" and in the column xpath I didn't put anything.
The problem is now that I loop 37 times and I get always the same result of the same block with XML
Ex:
<nome id="" ordem="">photo1.jpg</nome>
<nome id="" ordem="">photo1.jpg</nome>
<nome id="" ordem="">photo1.jpg</nome>
<nome id="" ordem="">photo1.jpg</nome>

Now I just want to retrieve the value of nome and not have it always be the same. What xpath do I have to use!!???
EDIT2:
Ok I figured it out. I put a "." in the xpath

topic [resolved] talend extract xml field in Talend Studio

[resolved] talend extract xml field