Help

XML Import Help with xpath - Wordpress XML

Topic Labels: ImportingExporting
1639 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Bryan_Smith
6 - Interface Innovator
6 - Interface Innovator

Hi Everyone,
I’m trying to import xml data from a wordpress export file the xml import block. I’m having some success with the xpath filters and matching columns but not sure how to grab the image url and the tags in the sample below. Can anyone please help me. Thanks
Or, if there is a better way to bring an old wordpress site into airtable I’d love to know about it. Thanks

<item>
  <title>November 26, 2018</title>
  <link>/construction-progress/2018/11/26/november-26-2018-1</link>
  <content:encoded><![CDATA[[caption id="" align="alignnone" width="1920.0"]<img src="http://static1.squarespace.com/static/57f7e1b020099e80cdf755c5/599c7166bebafb8302a11b3d/5bfc57bc1ae6cf295239ba32/1543264195783/181126_CCE_pb-web-2.jpg" alt=" JVA with Studio Ma &amp; Edge Builders / Photo: Paul Bundy "/>  JVA with Studio Ma &amp; Edge Builders / Photo: Paul Bundy [/caption]]]></content:encoded>
  <excerpt:encoded />
  <wp:post_name>2018/11/26/november-26-2018-1</wp:post_name>
  <wp:post_type>post</wp:post_type>
  <wp:post_id>1302</wp:post_id>
  <wp:status>publish</wp:status>
  <pubDate>Mon, 26 Nov 2018 20:30:18 +0000</pubDate>
  <wp:post_date>2018-11-26 20:30:18</wp:post_date>
  <wp:post_date_gmt>2018-11-26 20:30:18</wp:post_date_gmt>
  <category domain="post_tag" nicename="copper-crest-east"><![CDATA[Copper Crest East]]></category>
  <category domain="post_tag" nicename="construction"><![CDATA[Construction]]></category>
  <dc:creator>marketing@powdermountain.com</dc:creator>
  <wp:comment_status>closed</wp:comment_status>
  <wp:postmeta>
    <wp:meta_key>_thumbnail_id</wp:meta_key>
    <wp:meta_value><![CDATA[1304]]></wp:meta_value>
  </wp:postmeta>
</item>
0 Replies 0