Make Cutenews data to MySQL

I'm trying to transfer my database from CuteNews to Drupal 6.20, and found the same error. It is interesting to let the solution recorded here.

If anyone has any other solution, help me, please.

Thanks.

Hello my friends.

Today I managed a small advance by importing data from CuteNews to Drupal.

I will share part of my success with friends, but I need help. Come on.

1) I have reviewed the code provided above and I perbes some functions that are there simply have been replaced in version 6 of Drupal. So I replaced by the equivalent versions, according to the rewritten code below.

Code:

  
/**
 * @file
 * A script to help migrate Cutenews users, categories and content to Drupal.
 * 
 * Place this to the root of your Drupal installation, configure (below), log in as
 * the user with ID 1 and run the script. 
 *
 * Categories will be imported as Drupal terms in a vocabulary named 'Cutenews Imported',
 * one can change the name and properties of the vocabulary later. Content will be
 * imported as Drupal story nodes.
 *
 * @version 2005/02/04
 * @author Julius Juurmaa
 */

/**
 * Some basic configuration.
 */

define('CUTENEWS_DATA_PATH', 'cutenews/data'); // The path to Cutenews data directory.
define('MIGRATE_USERS', true); // Should users be migrated?
define('MIGRATE_CATEGORIES', true); // Should categories be migrated?
define('MIGRATE_CONTENT', true); // Should news be migrated?
define('DISPLAY_SUMMARY', true); // Should summary be displayed?
define('DISPLAY_MIGRATED_DATA', true); // Should detailed, ID->ID summary be displayed?

/**
 * Loads the Drupal core and increases the time limit.
 */

include_once 'includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
if (!ini_get('safe_mode')) {
  set_time_limit(240);
}

/**
 * Loads the Cutenews users, categories and content.
 */

$users = file(CUTENEWS_DATA_PATH .'/users.db.php');
$categories = file(CUTENEWS_DATA_PATH .'/category.db.php');
$content = file(CUTENEWS_DATA_PATH .'/news.txt');
array_shift($users);

/**
 * Attempts to migrate users.
 */

if (MIGRATE_USERS && count($users)) {
  foreach ($users as $single_user) {
    $user_data = explode('|', $single_user);
    $account = array(
      'name' => $user_data[2],
      'pass' => '0', // An arbitrary value, will be replaced later. Hash would be rehashed.
      'mail' => $user_data[5],
      'init' => $user_data[5],
      'status' => 1
    );
    $user_exist = user_load(array('name' => $account['name']));
    if ($user_exist) {
      $message['User migration'][] = 'User \''. $account['name'] .'\' already exists in Drupal database.';
    }
    elseif ($saved_user = user_save('', $account)) {
      db_query('UPDATE {users} SET pass=\'%s\' WHERE uid=\'%d\'', $user_data[3], $saved_user->uid);
      $message['User migration'][] = 'Successfully migrated user \''. $saved_user->name .'\'.';
      $migrated['users'][$saved_user->name] = $saved_user->uid;
    }
    else {
      $message['User migration'][] = 'Migration of user \''. $account['name'] .'\' failed.';
    }
    unset($user_data, $account, $saved_user);
  }
}

/**
 * Attempts to migrate categories to Drupal terms.
 */

if (MIGRATE_CATEGORIES && count($categories) && module_exists('taxonomy')) { //mudou para module_exists
  $vocabulary = array(
    'name' => 'Cutenews Imported',
    'description' => 'Categories imported from Cutenews',
    'nodes' => array('story'),
    'multiple' => 1,
    'required' => 0,
    'relations' => 1,
    'hierarchy' => 1,
    'weight' => 0
  );
  $vocabulary_id = db_last_insert_id('{vocabulary}_vid') + 1;
  if (taxonomy_save_vocabulary($vocabulary)) {
    $message['Category migration'][] = 'Successfully created vocabulary \''. $vocabulary['name'] .'\'.';
    foreach ($categories as $single_category) {
      $category_data = explode('|', $single_category);
      $term = array(
        'vid' => $vocabulary_id,
        'name' => $category_data[1],
        'description' => '',
        'weight' => 0
      );
      $term_id = db_last_insert_id('{term_data}_tid') + 1;
      if (taxonomy_save_term($term)) {
        $message['Category migration'][] = 'Successfully migrated category \''. $term['name'] .'\'.';
        $migrated['terms'][$category_data[0]] = $term_id;
      }
      else {
        $message['Category migration'][] = 'Migration of category \''. $term['name'] .'\' failed.';
      }
      unset($category_data, $term, $term_id);
    }
  }
  else {
    $message['Category migration'][] = 'Creation of vocabulary \''. $vocabulary['name'] .'\' failed.';
    $message['Category migration'][] = 'Category migration failed.';
  }
  unset($vocabulary_id);
}

/**
 * Attempts to migrate content to Drupal story nodes. Connects migrated users and terms
 * to nodes, where applicable. Where no user is found, user with ID 1 is used.
 */

if (MIGRATE_CONTENT && count($content)) {
  foreach ($content as $single_item) {
    $item_data = explode('|', $single_item);
    $get_user = user_load(array('name' => $item_data[1]));
    $node->uid = $get_user->uid ? $get_user->uid : 1;
    $node->type = 'story';
    $node->title = $item_data[2];
    $node->body = $item_data[4] ? $item_data[4] : $item_data[3];
    $node->teaser = $item_data[3];
    $node->filter = variable_get('filter_default_format', 1);
    $node->status = 1;
    $node->revision = 1;
    $node->promote = 1;
    $node->comment = 2;
    $node->created = $item_data[0];
    $node->changed = time();
    $node_id = db_last_insert_id('{node}_nid') + 1;
    node_save($node);
    if ($migrated['terms'][$item_data[6]] && module_exists('taxonomy')) { //mudou para module_exists
      db_query('INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)', $node_id, $migrated['terms'][$item_data[6]]);
    }
    $message['Content migration'][] = 'Successfully migrated article \''. $node->title .'\'.';
    $migrated['nodes'][$item_data[0]] = $node_id;
    unset($item_data, $node, $node_id);
  }
}

/**
 * If requested, prints out a summary.
 */

if (DISPLAY_SUMMARY && count($message)) {
  print '<h1>Migration summary</h1>';
  foreach ($message as $key => $value) {
    print '<h2>'. $key .'</h2>'. theme('item_list', $value);
  }
}

/**
 * If requested, prints out a detailed report.
 */

if (DISPLAY_MIGRATED_DATA && count($migrated)) {
  print '<h1>Migrated data in detail</h1>&amp;#039;;&amp;#10;  print_r($migrated);&amp;#10;  print &amp;#039;';
}
  

Notes:

a) The above code I saved with the name cutenews.php at:

C:\wamp\www\drupal\cutenews.php

b) The above code will need to be modified according to the installation of each user.

2) As you can see, I'm still running my version of Drupal on localhost. So I downloaded the folder 'data', existing within my CuteNews directory on the web, to my pc. The path to the folder it was this way:

C:\wamp\www\drupal\cutenews\data

That done, I logged in Drupal and I ran the file 'cutenews.php' in the browser.

Users, the categories and stories have been imported into Drupal.

As I still had no news on my site, now the news imported are displayed on the front page.

Despite the success of importing the data, some unwanted characters were also brought to the new articles and I'll need to edit each one to the exclusion or Replacing these characters.

That occurs when I try to edit these articles, I get the following error message:

"warning: call_user_func_array() expects parameter 1 to be a valid callback, function 'story_node_form' not found or invalid function name in C:\wamp\www\drupal\includes\form.inc on line 378."

I believe this is very important since many users of CuteNews not only migrated to Drupal yet, lack of resources to import data. I see this as a great breakthrough because it still had not found anything concrete that would allow me to such importation.

Can anyone help me decipher the above message and correct the error, so I have opportunities to edit any imported content?

Thank you in advance.