I was using node import for bulk upload the nodes from csv.

the node's cck fields were autocomplete textfield with autocreate. but unfortunatly imports error with....

so I used this modules node auto create type, and it works well, but one issue was it recreate the node even the node is exists with the same title. In my case, I needed to eliminate the duplicates, so I added the existing node check in this module.

may be this can be useful to you .

in function nodereference_autocreate_validate
line number 119

        $nid = $referenced_node->nid;
    }
    else {

       /**
	* check if the node is exists.
	*/
			 
	$enid = db_result(db_query(db_rewrite_sql("SELECT n.nid FROM {node} n WHERE n.title = '%s' and n.type = '%s' "),  $title, nodereference_autocreate_type_get($field['referenceable_types'])));
			 
	if ($enid){
			 
	  $nid = $enid;
					
	}else{
		 
	  //$nid = nodereference_autocreate_value($element);
	  // Create a new node with the specified title.
	  $node = new stdClass();
          //other lines...............
        }