Programatically create nodes, taxonomies and relationships via exisiting database I have a client that wants a Drupal port. They have a MySql DB with a small built by hand backend. The data structure is about standard in terms of a business organization. 

People


Department
Specialty
Location
Etc


How can I create taxonomies as well as nodes from a MySql Script from the old database?
http://timonweb.com/how-programmatically-create-nodes-comments-and-taxonomies-drupal-7 - only thing to note is making sure the taxonomy terms don't exist before you add them, which you can easily do with a function like this (recently wrote this for a project)

function taxonomy_import_add_or_get_term($term, $vocabulary) {
  $tid = taxonomy_get_term_by_name($term, $vocabulary-&gt;title);
  if (count($tid) &gt; 0) {
    $tid = array_shift(array_keys($tid));
  }
  else {
    $term_object = new stdClass();
    $term_object-&gt;name = ucwords(strtolower($term));
    $term_object-&gt;vid = $vocabulary-&gt;vid;
    taxonomy_term_save($term_object);
    $tid = $term_object-&gt;tid;
  }
  return $tid;
}