Update/edit nodes from source CSV data using FeedAPI?

Not a clue - I did not dig into the module that far...

Eric

Would you want to sanitize the data coming from the CSV file in any way?? Might be a good idea just in case.

Eric

Pardon my ignorance as I'm a newbie to Drupal and not very skilled at php or server administration.

I am trying to get this script to work but am having no luck. I have this module installed in /sites/all/modules/updatedata and it is enabled on the Modules page. I upload the file "mth_update.php" to the root of my Drupal installation. (It is a multi-site install, and I will only use this module on this site - should I put it in /sites/[siteurl]/modules and upload the mth_update to the root of that site?) Then I go to http://[siteurl]/cron.php, I get a WSOD, then go back to http://[siteurl] and everything looks fine but the update to the nodes did not happen. I believe the module is running on hitting cron.php because I was getting errors about field names, but then used the Devel module to get the names of the CCK fields. I have cleared the cache between each try. There are no apache errors nor errors in the watchdog list but it is not updating the nodes.

Here is my version of the script.

/***********************************************************
*
* Implementation of hook_cron. Is run each time cron.php is run.
*
* Updates nodes from a comma separated values (CSV) file.
* Place the CSV file in the root of the Drupal site.
* Install Devel module to get names of your fields; Devel module instructions and
* source of code: acquia.com/blog/migrating-drupal-way-part-i-creating-node.
* Also source of code: drupal.org/node/67887.
***********************************************************/
function updatedata_cron() {
  $filename = 'mth_update.csv';     //put in root of Drupal site.
  $fp = fopen($filename, "r");         // Open the CSV file read only.

  while ($line = fgetcsv($fp)) {// Read a line of the file and update a node from it.
    // Get the unique id.
    $mthid = $line[0];
    // Query the database for the nid of the unique id.
    // If unique id is numeric use this:
    $result = db_result(db_query("SELECT nid
                                        FROM {content_type_mth_members}
                                        WHERE field_mth_id_value = %d", $mthid));
     // Otherwise if unique id is alphanumeric use this:
    //$result = db_result(db_query("SELECT nid
    //                                  FROM {content_type_mytype}
     //                                 WHERE field_myuniqueid_value = '%s'", $myuniqueid));

    // Load the node from the nid
    if ($result) {
      $node = node_load($result);
   
      // Update the fields.
      // CCK fields.
      $node->field_mth_last_name_value[0]['value'] = $line[1];  
      $node->field_mth_first_name_value[0]['value'] = $line[2];
      $node->field_mth_company_value[0]['value'] = $line[3];
      $node->field_mth_address_value[0]['value'] = $line[4];
      $node->field_mth_city_value[0]['value'] = $line[5];
      $node->field_mth_state_value[0]['value'] = $line[6];
      $node->field_mth_zip_value[0]['value'] = $line[7];
      $node->field_mth_county_value[0]['value'] = $line[8];
      $node->field_mth_expiration_value[0]['value'] = $line[9];  
     
      node_save($node);   // Save node, also bypass required fields.
    }
   
  }
  fclose ($fp);         // Close CSV file.
}

I'd seriously appreciate any hints as to why it's not working.

This is a great piece of code. I am wondering if it is a viable option for updating over 10,000 nodes. Or if node_save would time out at that level and I need to be looking at feeds or the batch api.

Hi I have successfully added values ,taxonomy to node by using node_save .

But I am looking to your solution .
I have created a separate column in excel named unique id and also add a field in my content type.
And if both id match then update node otherwise create a new node,