I have a typical situation where I have several taxonomy terms, two taxonomies. I would like to make multiple entries from a CSV file to associate with that field (example: node row 1 has field_term_a with term ID 1, 2, 3 in it and field_term_b with term ID 5, 6, 7). field_term_a and field_term_b are both set as permitting multiple references.

I can consistently get a *single* term on the field_term_a (eg the first term ID attaches correctly).

I tried formatting the cells by both the text of the term and the ID of the term. Also made all terms inside Drupal before importing.
1, 2, 4, -or more precisely they had quotation marks on Excel export like: "1, 7, 21, ","24, 13, 15, 16, 25, 29, 28, "
1 2 4
termname_a, termname_b, termname_c

With the first two the mapping is set reference by term id, and the latter with the reference by name.

Using the ID codes without commas gives me only the first term in the field. I couldn't find a spot in the code that was exploding them on the comma-space character pair so I'm not sure that is the right format.

I looked around at EntityProcessorBase.php, TermProcessor.php and EntityReference.php and didn't catch any good clues about this.

Workaround

Probably going to use views_bulk_operations and views_bulk_edit to insert terms manually, it should let me add individual terms to multiple nodes 'additively' so to speak.

Comments

HongPong created an issue. See original summary.

HongPong’s picture

Issue summary: View changes
HongPong’s picture

Issue summary: View changes
MegaChriz’s picture

Category: Bug report » Support request
Status: Active » Fixed

Importing multiple values into one column is possible with the Tamper plugin "Explode". Install Feeds Tamper and Tamper, edit your feed type, click the "Tamper" tab and add a plugin of type "Explode" on the taxonomy reference field.

See also #2292921: How to import the data with multi value ??.

HongPong’s picture

Ah thank you so much - if i can get a few hours of downtime I will try to hammer out some documentation for this process.

MegaChriz’s picture

I see now that there is documentation available for the same process in D7:
https://www.drupal.org/node/2287473

I would do a few things differently though, like starting with a screenshot of the source file and the end result. This way it's clear where the guide is leading to.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.