Mapper for CCK User reference

#1: this is actually not a duplicate, but #705560 is a duplicate of #699176: Mapper for user id and user name. #699176 allows mapping to a node's user id field, but you're asking for mapping to a user reference CCK field, right? This is a separate feature request.

Look at feeds/mappers directory for a couple of examples for CCK field mappers.

http://drupal.org/coding-standards ;-)

//User reference can have more than one value (1-to-many relationship)
//If that is the case, we expect the values to come in as a comma separated

Not sure whether I agree with that... there shouldn't be assumptions like these in a mapper, if we want comma separated lists exploded we ideally support this on the parser level...

Good patchs and comments!

Inspired of these, I add a feature for "user name", if we have user names in feeds

        $user_id = get_user_id_by_name(trim($user_name));
        $field[$i]['uid'] = $user_id[0];
   

the function is something like:

function get_user_id_by_name($user_name) {
    $uids = array();
    $result = db_query(db_rewrite_sql("SELECT u.uid FROM {users} u WHERE u.name = '%s'"), $user_name);
    while ($user = db_fetch_object($result)) {
      $uids[] = $user->uid;
    }
    return $uids; 
}

Hope help

I can't take credit for this, but: since there is already a nodereference mapper in this queue #724536: Mapper for nodereference field in Drupal 6 (which has been working great for me), I simply altered that mapper for userreference - the userreference lookup function is helpfully identical to the nodereference one :)

This one gives you the option of choosing username or uid. It seems to work fine for my test import, but could use some community testing.

Cool. Someone should roll this into a patch. If I knew how to do that I would. Haven't figured that out yet.
-Mike

Looking for this for Drupal 7 too. Has anyone forward ported any of the patches in this ticket yet?

Patch based on Reinette's dropped-in file attached.

Briefly tested it doing the following:

1. Created a content type with a User reference field and called it "Author"
2. Created a user called "Richard"
3. Created a feed importer with the node processor making nodes of that content type
4. Mapped the feed "Author name" source to the "Author (User by username)" target.
5. Imported

Since the author name in the RSS feed is also "Richard", it matched with the newly created user.

there's no code in the above patch

Huh, so there isn't. Trying again.

Patch works great. One small change:

In order to allow multiple usernames or UIDs to be saved, I changed the following code:

<?php
  // Allow for multiple-value fields.
  if (!is_array($value)) {
    $value = array($value);
  }
?>

to:

<?php
  // Explode the values into an array of values delimitted by commas.
  $value = explode(',', $value);
?>

New patch attached, generated off of latest 6.x-1.x-dev branch.

#17, sorry, but we can't have a multiple value separator hard-coded like that. Feeds Tamper provides this functionality though.

Leaving as needs review because the patch in #16 is still valid.

Ah gotcha. Makes sense.

Well I can +1 the patch in #16. It's working great for me.