Hi, I’ve got a database XML dump from an old wordpress site that I want to import into a project. I’musing sweet_xml and it’s working fine for the simple structures. However when I encounter lists of nested fields such as wordpress’s metadata fields I can’t get sweet_xml to pick up the values. I’v…

There is a hint in your output - the CDATA elements are wrapped in newline characters and have trailing spaces, i.e. the value for slug in your example is "\napost-name\n ". That means that your Xpath query is not finding anything for the slug or company logo nodes because, for example, it is…

I can confirm that the suggestion from @srowley works, this code is tested in an iex repl: clean_newlines_and_ws = fn x -> String.replace(x, ~r/\r|\n|\W/, "") end rows = SweetXml.xpath( tree, ~x"/rss/channel/item"l, slug: ~x"./wp:post_name/text()"s |> transform…

As a postscript, it occurred to me later that all that is happening here is that the whitespace within the markup is being preserved - looking at the sample within the offending tags there is a newline, the CDATA node, some spaces, and then another newline. The :xmerl documentation confirms this and…

Doh! That makes a lot of sense :slight_smile: I always use a auto-formatter when viewing code. In this case using https://docs.python.org/2/library/xml.dom.minidom.html to make it look readable. But doing that broke the export from wordpress. I can confirm that the original has no newlines wheneve…

Elixir Programming Language Forum

Help with using sweet_xml and nested xpath

Questions & Help Questions

Newxan January 19, 2020, 4:15pm 4

Using ‘contains’ solves my problem. Thanks for the help!