1)); $genres = array( 'indie' => array('mdb' => 'GenreIndie', 'name' => 'Indie Rock'), 'loud_rock' => array('mdb' => 'GenreLoud', 'name' => 'Loud Rock'), 'hiphop' => array('mdb' => 'GenreHipHop','name' => 'HipHop'), 'electronic' => array('mdb' => 'GenreElectronic','name' => 'Electronic'), 'local' => array('mdb' => 'GenreNorthwest', 'name' => 'Northwest'), 'folk' => array('mdb' => 'GenreFolk', 'name' => 'Folk'), 'world' => array('mdb' => 'GenreWorld', 'name' => 'World'), 'mainstream' => array('mdb' => 'GenreMainstream', 'name' => 'Mainstream'), 'jazz' => array('mdb' => 'GenreJazz', 'name' => 'Jazz'), ); // Setup the taxonomy. $vid = _import_create_taxonomy($genres); // Connect to the MDB $conn = new COM("ADODB.Connection") or die("Cannot start ADO"); $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". MDB_PATH); // SQL statement to build recordset. $rs = $conn->Execute("SELECT * FROM [Recording List]"); // Display all the values in the records set while (!$rs->EOF) { // Try to avoid script time outs. if (!ini_get('safe_mode')) { set_time_limit(0); } // Build a new node. $node = new stdClass(); $node->type = 'station_album'; $node->uid = $user->uid; $node->name = $user->name; $node->status = 1; $node->promote = 0; // Map the data over. $node->album['number'] = $rs->Fields('Log Number')->value; $node->album['artist'] = $rs->Fields('Artists')->value; $node->album['album'] = $rs->Fields('Album')->value; $node->album['genre'] = $rs->Fields('Genre')->value; $node->album['label'] = $rs->Fields('Label')->value; $node->album['year'] = $rs->Fields('Year')->value; $node->title = $node->artist .' - '. $node->album; $node->body = $rs->Fields('Comments')->value; if (module_exists('taxonomy')) { $node->taxonomy = array(); foreach ($genres as $key => $field) { if ($rs->Fields($field['mdb'])->value) { $node->taxonomy[$vid][] = $genres[$key]['tid']; } } } if (module_exists('comment')) { $node->comment = variable_get("comment_$node->type", COMMENT_NODE_READ_WRITE); } // Save the node. $node = node_submit($node); node_save($node); print "

";
  print_r($node);
  print "

"; $rs->MoveNext(); } $rs->Close(); $conn->Close(); function _import_create_taxonomy(&$genres) { $vid = _station_catalog_get_vid(); // Create the terms. foreach ($genres as $key => $genre) { $term = array( 'vid' => $vocabulary['vid'], 'name' => $genre['name'], 'description' => '', 'weight' => 0, ); taxonomy_save_term($term); $genres[$key]['tid'] = $term['tid']; } return $vid; }