Currently the xml feed looks something like this
<hotel> <hotel_facilities> <facility>Gym</facility> <facility>Restaurant</facility> <facility>Bar</facility> </hotel_facilities> ... </hotel>
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: 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 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?