taxonomy

CNNGo.com

Contract
Turner New Products Group Senior Developer
Talener Inc.

Worked with team of developers using Drupal 6 to build CNNGo.com. Developed module for "Hero" generation and display. Required use of custom MySQL queries and PHP code to retrieve field data and inject Advertisement code into slideshow. Used Jquery / Javascript to build and customize a high-end functional slideshow on Drupal Website. Also incorporated CSS sprites for menu and view state display and control.

Taxonomy Tables and relations

The following is a list and descriptions of the taxonomy tables used by Drupal 6. In depth description and explanations are not provided here. I'm only listing them because I've had a hard time finding a list myself. BYODD (Backup YOur Database, Dummy) before changing these tables.

-- VOCABULARY TABLES --
custom_breadcrumbs_taxonomy_vocabulary : Added by the Custom Breadcrumbs Taxonomy module. I don't know how it's used at this time.
vocabulary : Assigns an ID to a vocabulary name and stores the description, weight, hierarchy, and other metadata about vocabularies

Use MySQL to delete terms to save me from the single-term manual delete process.

I needed to delete a bunch (Over 100) of child terms from a Vocabulary and save the parents.
I needed to do this without sitting in front of a web browser and waiting for a page to load every time.

Disclaimer: BYODD (Backup YOur Database, Dummy!) before attempting any instructions on this site. Owners AND all Affiliates are NOT responsible for anything YOU screw up by following any instructions you find here.

Anyway... I'll cut to the chase... then explain. here are the queries I ran:

Technologies:

Move taxonomy terms to a new vocabulary while retaining Term IDs (tid) with an added bonus

I've been tasked with tightening up our site's taxonomy. Unfortunately, this includes yet another desire that cannot be met with any of the default tools available in Drupal (and noone has quite hit the mark with a module): Gather terms from multiple vocabularies into one single vocabulary and do it in such a way as to avoid recategorizing the thousands of nodes we have that have already been categorized using the existing terms. The reason for this was that all the vocabulary names could be seen as one.

Forget About "Taxonomy CSV" and "Taxonomy Export"... Use "Taxonomy import/export via XML" instead.

Just spent hours trying to find a method for exporting Taxonomy terms to other Drupal instances.

I tested the following and very easily found flaws:

http://drupal.org/project/taxonomy_csv : Found it difficult (never actually found "it") to describe to the front end what I need (ie full download of all taxonomies including Vocabulary name, descriptions, etc)
http://drupal.org/project/taxonomy_export : Seems to be just a shell... insert your code here.. is not the type of help I was looking for from a module.

Technologies:
Subscribe to RSS - taxonomy