How can I import multiple taxonomy terms using Feeds and the Feeds XML Parser Currently the xml feed looks something like this

&lt;hotel&gt;
    &lt;hotel_facilities&gt;
        &lt;facility&gt;Gym&lt;/facility&gt;
        &lt;facility&gt;Restaurant&lt;/facility&gt;
        &lt;facility&gt;Bar&lt;/facility&gt;
    &lt;/hotel_facilities&gt;
...
&lt;/hotel&gt;


I've trying to import all the facilities as taxonomy terms using the Feeds XPath Parser but I am only able to import a single facility. I'm not sure if the module supports this. What currently happens when I set the context to hotel and the xpath query as hotel_facilities/facility it results in the error:


  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'Restaurant', 'Bar'' at line 1


If I use the query: hotel_facilities/facility[1] it returns and inputs the term into my taxonomy vocabulary, but I require all the terms to be added. 

Is there a query/module or setting that I need to run; or is this a limitation of the Feeds/Feeds XPath Parser parser modules?
Feeds Tamper will sort this out (I know this for a fact, as I've done this in the last week).

Set your query to hotel_facilities/facility which will return a comma separated list of facilities (you won't see this array as you'll be exploding it. Feel free to dpm() it though). Using Feeds Tamper, you can explode this array.

Go to your feed, and there will be a "Tamper" menu item at the top. If you click this, and then go down whatever xpathparser if importing these facilities. Then click Add plugin and find the explode plugin (you can find it under List)



Don't forget to set your Feeds mapping to Search taxonomy terms by: Term Name and check the "Auto create" checkbox.