Ruby XML Reading from one XML and parsing into another

Question

XPath.each( xmldoc, "//speech/speaking") do |element| 
# puts element.attributes['name']
# puts element.text
File.open(file_name + "_" + element.attributes['name'] + "-" + year + ".xml", 'a+') do |f|
    f.write("<speaker>" + element.attributes['name'] + "</speaker>")
    f.write("<speech>" + doc.xpath('//speech/speaking').text + "</speech>" + "\n")
end
end

Hello stackoverflow I am looking for help solving a logic issue I am having with XML files. The above code creates a file with the "speakers" name and then it should place what the speaker says into that file.

The problem that I am running into is that it places ALL of the speakers into the same file. So I am thinking the problem lies here:

f.write("<speech>" + doc.xpath('//speech/speaking').text + "</speech>" + "\n")

I am hoping that someone has a better way of doing this, but the idea would be to change the above code to:

doc.xpath('//speech/speaking').text WHERE speaker == element.attributes['name']

Ultimately I would like to have each speaker in their own XML file with their own speeches.

<speaking name="Mr. FAZIO">I appreciate my friend yielding.</speaking>

The above is a sample from the XML file.

Unfortunately not, the problem is the source XML file has hundreds of speakers with hundreds of speeches. The current code is creating the files properly but putting speeches from everyone in all the created XML files. — CodeHard
– CodeHard, Commented May 25, 2014 at 7:05

Community · Accepted Answer · 2017-05-23 12:05:06Z

0

The xpath you are looking for is:

doc.xpath("//speech/speaking[@name='#{element.attributes['name']}']").text

see XPath to select Element by attribute value

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered May 25, 2014 at 7:06

Uri Agassi

37.5k16 gold badges82 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

CodeHard Over a year ago

This looks about right and I tried it before but it gives me an error: node.rb:159:in `evaluate': Invalid expression: //speech/speaking[@name=Mr. THOMAS] (Nokogiri::XML::XPath::SyntaxError)

Uri Agassi Over a year ago

Make sure you have enclosing quotes (/speech/speaking[@name='Mr. THOMAS'])

CodeHard Over a year ago

The above comment yields: speaking[@name=] (Nokogiri::XML::XPath::SyntaxError)

Uri Agassi Over a year ago

All I suggested was to make sure you enclosed the value with single quotes '...

CodeHard Over a year ago

It is enclosed. I feel that this is on the right track but I have been down this path and can not get it to work. I posted some sample XML above if you have any further ideas.

|

Collectives™ on Stack Overflow

Ruby XML Reading from one XML and parsing into another

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related