Comma separated multiple taxonomy terms comma separated, get automatically wrapped in exclamation marks when getting added to field (Obviously their is no problem with a single term being added, but I always needed to be able to add multiple taxonomy terms, tags for a single node or product when using commerce feeds module, infact I have to have multiple terms to catagorise products.)

For an example, say I put in:

auto,repair,nissan

into a column in a CSV file and titled the column tags.

When using feeds to upload the file into a site, I find this:

"auto,repair,nissan"

Wrapped in "exclamation marks". I even tried removing exclamation marks from the csv file around the taxonomy terms I was trying to add but they were wrapped in exclamation marks automatically after being uploaded (To try that I used a ; semi colon as a separator in the CSV file.)

Multiple taxonomy terms being added wrapped in "exclamation marks" means the comma separated terms are treated as one single term by Drupal, they get quite literally glued together as one word, the commas become void once added to Drupal once "wrapped"

Thanks for the great feeds module. Best regards from Josh

Comments

jlhs’s picture

jlhs commented

Sorry that should be when importing comma separated taxonomy terms in a single column,

they get wrapped in "Quotation Marks" not exclamation marks!

termone,termtwo,termthree

becomes

"termone,termtwo,termthree"

Which means the three words glue together to become one word (This can be visually checked in taxonomy terms) because of the quotation marks that always get automatically :( wrapped around them when they are brought into Drupal via feeds.

Sorry I am not advanced enough at PHP to know what to do.

I am surprised no one else is commenting on this? Is everyone happy with assigning only a single taxonomy term to a node or to a product : \

Drupal 7

hyr’s picture

hyr commented

I'm getting the same situation as you are. Have tried using Feeds Tamper to add an explode plugin to my csv importer, but to no avail. I've tried various combinations of separators such as "Tag1||Tag2||Tag3" or "Tag1, Tag2, Tag3" but they all end up imported into the Term Reference field as one string and creates a new taxonomy term. =(

feeds_tamper-7.x-1.0-beta2
feeds-7.x-2.0-alpha3

edit: Hmmm i realise Feeds Tamper isn't actually "tampering" with my importer at all. I created a convert to uppercase to test and it didn't convert my input. maybe i'll try figuring that out.

ps: ok finally got it working nicely using the dev version of both feeds tamper and feeds.

jlhs’s picture

jlhs commented

Hello hyr,

It is fantastic to hear you have success! Unfortunately I have not : (

Can you please post what how you set up feeds tamper to get it adding all the taxonomy terms from a column?

I am using the dev version of both feeds and feeds tamper as you are.

1. I have added tamper module to my tags column for my CSV file

2. I have set the limit input area to 3 (Supposing that was the maximum number of tags I would have) Or is that not how it works.

3. Then tested with two taxonomy terms in the CSV tags column, comma separated.

4. Uploaded the CSV file via feeds only to get failure, the first term was inserted into the node. The second term was not.

5. Tried using || twin pipes to separate the taxonomy terms and changed the setting to || twin pipes in feeds tamper module for my tags/taxonomy terms.

6. Still no success. I always get only the first term out of the multiple terms added, the rest are discarded : \

Regards from Josh

jlhs’s picture

jlhs commented

Please anyone who has successfully got multiple taxonomy terms to attach to a node and go into taxonomy properly, using modification or what have you, doesn't matter. Not being able to get multiple taxonomy terms to go through without them being joined together wrapped in quotation marks is severely crippling : (((( x 1000000

jlhs’s picture

jlhs commented

I got multiple comma separated taxonomy terms to work by setting the the explode function of tamper to 0

Very happy : )

kurtzhong’s picture

kurtzhong commented

@hyr As today when I tried to import some users which got some fields with free tagging fields, I came across with same problem here.
You solution works for me, thanks!

hanmant.sapkal’s picture

hanmant.sapkal commented

Hello Experts,

I am little bit behind you. I am using drupal 6.20 and Feeds 6.x-10 beta11, I have Feeds xPath parser as well.
My input feed is xml feed. I am able to map xml attribute to relative attribute of my content.

Now I want to assign taxonomy to my nodes being created with feeds. In my xml there is one attribute <catagory>sports</catagory>, then how can I assign value of <catagory>sports</catagory> xml field as a taxonomy term to node being created?

Any help is really appreciated.

Thank you.

emackn’s picture

emackn commented
Status: Active » Postponed (maintainer needs more info)
summit’s picture

summit commented

Hi, Could anyone give an example working csv file of products with multiple taxonomy terms, comma seperated which they have working? Also the module versions please?
I am so far unable to get this working.
Thanks a lot in advance for your reply!
Greetings, Martijn

asb’s picture

asb commented

@Summit: As so often, so-called "recommended" releases don't work properly or not at all. After lots of hair-pulling, I found the important hint in #2: Try the dev releases, and ignore "stable" or "recommended".

F.G’s picture

F.G commented

hi all,

my xml send me this :
<keywords> term1, term2, term3</keywords>

i used term autocomplete without limitation and alls terms become one term in my taxonomy ? It seems a old issue, do you have the solution to fix this trouble ? I installed the last version alpha5 and nothing change.

Regards.

asb’s picture

asb commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

@F.G: Once more: A stand-alone 'Feeds' can't do this anymore. Use the current dev release of 'feeds_tamper' and explode the term listing.

F.G’s picture

F.G commented

Once more > sorry i'm not a native english reader so sometime, i mess some infos. I'm not friendly with xml.
Can you please, give a sample of how the xml file will look and xpath syntax?

Regards

asb’s picture

asb commented

XML & XPath: Wrong issue queue, if you are actually trying to transform XML or are fiddling with XPath.

To explode the terms you quoted in #11, just install 'feeds_tamper' and apply it on your mapper field for taxonomy terms.

F.G’s picture

F.G commented

Thanks Asb,

But i don't need Tamper (?) i have the hand on the xml. so i could generate a different xml for keywords, so like i tall you, i'm not expert in this schema and xpath.

<keywords>
<keyword>term1</keyword>
<keyword>term 2</keyword>
<keywords>

Does i have to put id on each, and i suppose than xpath should be different ?

so, i fix it, i remade the xml file, like above.
feeds xpath : keywords/keyword

Regards.