Databases
StackOverflow2013
Postsdbo
POHow do I move terms from one vocabulary to another in Drupal 7 without losing the node reference?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I move terms from one vocabulary to another in Drupal 7 without losing the node reference?
    primarykey
    data
    text
    <p>I've inherited a site with a very big hierarchical taxonomy:</p> <pre><code>Vocabulary name: categories --term: company name ---- many child terms -- term: country ---- many child terms -- term: issue ---- many child terms </code></pre> <p>I realized it would be easier to create Search facets and Views with appropriate content if I set up each of these parent terms as their own Vocabularies:</p> <pre><code>company country issue </code></pre> <p>So I created the new Vocabularies and used <a href="http://drupal.org/project/taxonomy_manager/" rel="nofollow">Taxonomy Manager</a> to shift all the sub-terms to their new vocabularies. I then updated the Article node content type to be associated with these 3 vocabularies.</p> <p>Unfortunately I also noticed the term relationship between the Article nodes (all 4,000 of them) and the Terms was now lost in the display. I thought this relationship would have been maintained by the Taxonomy Manager module.</p> <p>I've been searching for a way to update the vocabulary references for the Article nodes, but I'm still not sure how the vocabulary is associated with the node. I see new field_data_field_vocabulary-machine-name tables are created for each new vocabulary - and this is where the termID and node/entity ID are associated. However I don't know how to update the Vocabulary for a node automatically when I move a term from one vocabulary to another.</p> <p>I've recently move this site from Drupal 6 to 7 so it doesn't help that there are a lot of dead tables from D6 cluttering up the database.</p> <p>--</p> <p>I've now set up a new standard D7 install and am looking at the db default tables trying to figure out where the Vocabulary/Node relationship gets defined. On my old db the TermIDs still seem to be correctly associated with the Nodes in the Node table... but I don't see where the VocabularyID/TermID/NodeIDs are stored/updated.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMac Duck
    1. USMac Duck
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload