Multiple subitems and concat() not compatible [#2276895]

Here is my XML:

<rows>
<row>
<title>Title 1</title>
<descriptions>
<description lang="EN">Lorem ipsum</description>
<description lang="FR">Lorem ipsum</description>
</descriptions>
</row>
<row>
<title>Title 2</title>
<descriptions>
<description lang="EN">Lorem ipsum</description>
<description lang="FR">Lorem ipsum</description>
</descriptions>
</row>
</rows>

What I need is to export @lang and the description as a string. (ex. "EN :: Lorem ipsum") So I used the concat function for the xpath:
description = concat(.//description,' :: ',.//@lang)
This works well for the first description but ignores the second.

Can anyone tell what I did wrong, please?

Comments

Comment #1

manicato CreditAttribution: manicato commented 30 May 2014 at 11:05

Issue summary:

View changes

Comment #2

twistor CreditAttribution: twistor commented 16 July 2014 at 10:14

Category:	Bug report	» Support request
Status:	Active	» Fixed
Issue tags:	-xpath, -concat

This is a deficiency in XPath

http://stackoverflow.com/questions/21996965/concatenate-multiple-node-va...

Comment #3

manicato CreditAttribution: manicato commented 24 July 2014 at 10:09

string-join is only available with xpath 2.0 which is not supported by Feeds XPath Parser

Comment #4

manicato CreditAttribution: manicato commented 24 July 2014 at 10:10

Status:

Fixed

» Active

Comment #5

twistor CreditAttribution: twistor commented 24 July 2014 at 18:34

Status:

Active

» Fixed

Why did you re-open this?

Comment #6

manicato CreditAttribution: manicato commented 25 July 2014 at 06:18

Because the solution you suggested doesn't work. The function string-join is only available for Xpath 2.0, which is not supported by Feeds XPath Parser.

Comment #7

twistor CreditAttribution: twistor commented 25 July 2014 at 20:50

That was an explanation, not a solution. There's nothing we can do about it. libxml doesn't support XPath 2.0. You can try using Feeds Tamper to do this.