I'm trying to create nodes from an XML feed using Feeds XPath Parser.
Some of the data appears to import, but not all fields are being populated or populated correctly.
Here's a snippet of the feed:
<merchantProductFeed> <script/> <SCRIPT/> <merchant id="2607" name="Business IT Online Office Shop"> <prod id="49194411"> <pId>571895</pId> <text> <name> Avery afterBURNER Label System Software with Applicator 10 Inserts Ref AB1800 [24 Labels] </name> <desc> Avery afterBURNER Label System Software with Applicator 10 Inserts Ref AB1800 [24 Labels].- Includes software, applicator, 24 labels and 10 inserts.- For Professional CD labels and inserts.- No Touch labels - unique design of the label sheets mean you can apply the label to the CD/DVD without touching the printed design or the adhesive.- 20 premium matt and 4 photo quality glossy labels.- The curved design of the applicator means the label is rolled smoothly onto the CD/DVD.- Inserts include a CD jewel case insert cover and tray (including spine) - allowing design and print in one effort.- The software contains over 2000 clip art images, 120 pre-formatted label designs and much more. </desc> </text> <uri> <awTrack> http://www.awin1.com/pclick.php?p=49194411&a=953&m=2607 </awTrack> <awImage> http://images.productserve.com/preview/2607/49194411.jpg </awImage> <mLink> http://www.businessitonline.com/avery-afterburner-label-system-software-with-applicator-10-inserts-ref-ab1800-24-labels.bprod?inctax=true </mLink> <mImage> http://www.businessitonline.com/eCommImages/571895.jpg </mImage> </uri> <price curr="GBP"> <buynow>15.56</buynow> <delivery>5.95</delivery> </price> <cat> <awCatId>68</awCatId> <awCat>Software</awCat> <mCat>Machines and supplies>Computer Software</mCat> </cat> <brand/> </prod>
There are several more products in the document, structured in the same way.
In the feed importer, I've set the context as
I have two fields to populate: 'title' (text) and 'cost' (decimal).
The XPath query I'm using for title is 'text/name' and the query for cost is 'price/buynow'.
When creating the nodes, the title field is populated with the correct data, but includes the and element tags.
The cost field doesn't get populated.
I can't see where my XPath query is going wrong, so I'm unsure if it's a problem with that or something that isn't happening properly elsewhere in the XPath Parser module. So far as I can see, the mappings are set up as they should be.
Can anybody see if my XPath queries are correct for the XML feed above?