Updating existing Nodes using Feeds Import (CSV) [#1681658]

doing an import with Feeds Import for the first time, gives no issues and all fields values are updated,
but when I'm trying to update it the second time with less fields, It updates the fields but makes other fields empty unless it is a term reference or a node reference, everything else has no value.

the scenario would look like this,
let's say the table for the content type with its fields would like this after the first successful import

 id  , first_name, last_name , email          , new_node_ref 
 001 , mike      , john      , <no value>     , lisa         
 002 , john      , john      , <no value>     , john         
 003 , lisa      , john      , <no value>     , mike

when i'm doing the 2nd update, I made a csv file with this template.

 id  , email        
 001 , test@test.com
 002 , test@test.com
 003 , test@test.com

and after importing the csv file the result would be

 id  , first_name, last_name , email          , new_node_ref 
 001 ,           ,           , test@test.com  , lisa         
 002 ,           ,           , test@test.com  , john         
 003 ,           ,           , test@test.com  , mike

The values of the first_name and last_name have changed when I'm only updating one field.
The only value that is unchanged is the node reference.
I did not made changes with feeds mapping of the first import when I did the 2nd import.

I tried to make another importer with just the mapping 2 fields
id, email
and tried importing the csv file with two fields, but the same thing happens

Is there a way for me to update just one field if there is already an existing node without it removing the values of other fields in the same content type?

Any help would be greatly appreciated
Thanks

Comments

Comment #1

timmeh commented 16 July 2012 at 18:31

following this thread.

this would really come in handy.

Comment #2

vbreak commented 6 August 2012 at 15:01

Issues that can be easily reproduced

- Updating a single node reference field deletes other fields (mostly Text Fields) on the same node
- Updating a single integer field deletes other fields (mostly Text Fields) on the same node.
- Using another importer to update a single field creates a duplicate node for the same Feed GUID

To reproduce the problem,
after importing for the first time and successfully populating the fields for integer,text and node reference fields,

 id,   INTEGER, TEXT  , NODE_REF
  1,   1001   , test1 , 10023
  2,   1002   , test2 , 10024
  3,   1003   , test3 , 10025

run the importer again, by having a csv file that has the same Feed GUID and one field either Node reference or an Integer

 id,   INTEGER
  1,   2001
  2,   2002
  3,   2003

RESULT:

 id,   INTEGER, TEXT  , NODE_REF
  1,   2001   ,       , 10023
  2,   2002   ,       , 10024
  3,   2003   ,       , 10025

Comment #3

mrpeanut commented 31 August 2012 at 13:46

I would also appreciate this. In my case, I have all the nodes already set up in Drupal. Now I just want to use Feeds to import files to certain node IDs (my unique target). I have a CSV with nid and file. When I import, all the other fields are emptied.

Comment #4

chadmkidner commented 20 September 2012 at 00:44

Also looking for this solution in drupal 6.x version.

With option of 'Update an existing node' checked, this should check each value for changes and make Only those changes. If this is how it works than how can we add a check for values not included in update feeds and exclude these from being updated to NULL. (If/When NULL is the desired outcome it should be necessary to include a NULL value for given field)