Update drupal user profile fields with data from facebook

Field storage:
Maybe instead of the profile module, we will use Content profile module

I do not like the profile, it hurts me, lack of imagefield and filefield.
But the combined power of CCK & Views, when you can handle files, not mention to using with other content types (Views).

Synchronization:
In order not to quarrel, it seems to me that it would be better to leave at administrator's discretion.
In some cases just once an hour, some every 3 minutes.

Unfortunately, you can't use Cron, because in most cases we need to make synchronization when user is not using your application (or application must have permission offline_access)

I agree this is a great feature to have! I haven't tried to implement anything along these lines, in part because it was originally a violation of facebook's terms of service. I also see it as pretty complicated. For example, should values only be copied from facebook, or synced (two-way)? How does one map a value from facebook to a profile field (i.e. does the drupal field have to have exactly the same name used on facebook?)

If you want to build a module to work specifically with one third-party module, like Content Profile Module, or CCK, I welcome that but I think it should be done as it's own standalone module. That is, not part of modules/fb, but use modules/fb as a dependency.

If you want to build a module that works more generically, supporting drupal's core profile module or using drupal_execute() to save the values regardless of how they are stored on Drupal, then I would consider adding it to modules/fb (or possibly modules/fb/contrib).

Either way I'll do my best to help, but don't at the moment have any real time to work on this myself.

Next idea:

It seems to me that we need an API that will be was between Facebook and other contributed modules.

API will be responsible for:
- Cyclic retrieval of data from facebook (and then calling hook_fb_synchronisation_check_field )
- Changing data on facebook (API function called by other modules)
- A invoke to remove all data (hook_fb_synchronisation_remove_all_fields() ) or specific fields
- check required permissions

At first glance, we need to create: //function names are examples, probably will be changed

• fb_synchronisation_change_field($uid, $field_name, $value) // Called by the modules, in order to change the value on facebook
• fb_synchronisation_get_fields($app_id) // Get all available fb's fields to map to the corresponding module's fields
• hook_fb_synchronisation_check_field($uid, $field_name, $field_value) // Synchronisation fb -> contributed modules
• hook_fb_synchronisation_remove_all_fields() // Calling to empty all values are kept
• hook_fb_synchronisation_remove_field($field_name) // Calling to empty one particular field, eg. as a result of remove permission

Mapping fields:

Mapping fields is done directly in the module. You can get all available fb's fields via fb_sychronisation_get_fields($app_id)

Synchronisation:

• facebook -> Drupal
  API invoke hook_fb_synchronisation_check_field($uid, $field_name, $value), and the contributed modules update the value (if necessary)
• Drupal -> facebook
  Module call fb_synchronisation_change_field($uid, $field_name, $value) and can update field in the FB

Removing data:

On demand, API should invoke hook_fb_synchronisation_remove_all_fields() or hook_fb_synchronisation_remove_field($field_name)

Advantages Solutions:

Fields can be saved in any way (Profile, CCK, etc.) (by creating standalone module)
Mapping and maintenance depends on contributed module.

What we need:

Name and describe every field in the FB, together with its type (text, int image, array (text))
Eg.

• mail (text - 128 chars)
• home_location (text - 128 chars)
• photo (image)

Standalone or fb/contrib
As Dave suggests, I'll create CCK integration as standalone module.
I'm not sure, which is better, profile integration as standalone module or in fb/contrib (after all it's a core module)

--
A bit much, but I hope is quite clear :)

Because picture is worth thousand words (and my English is a bit rusty :) ), some battle maps

I've found something really interesting - FB Real-time Updates

Whenever a subscribed change occurs, Facebook makes an HTTP POST request to an endpoint you specify with a list of changes. A real-time server will generally send you notification of the change within a couple of minutes of its occurrence.

Of course it have some limitations:

List of user connections to which you can subscribe:

feed, friends, activities, interests, music, books, movies, television, likes, statuses, links

You can't subscribe to these user connections yet:

home, tagged, posts, photos, albums, videos, groups, likes, notes, events, inbox, outbox, updates, accounts

And ...

We will add support for those connections in the coming days. If you are interested, please check back on this page at later time for updates.

Take a look at fb_user.module. It creates a drupal account, links it using the authmap table. It even invokes hook_fb after creating the account so you could put your code in that hook.

At some point, I'm planning to use a new table instead of authmap. But for now at least, authmap is where the local account is linked to the facebook account.

Actually wrote this yesterday. Updates content profile fields with data from fb retrieved using FQL. This isn't production ready but thought I should share...

function _fb_module_after_build($form, &$form_state)  {
    $fb = $GLOBALS['_fb'];

    $query = "SELECT first_name, middle_name, last_name, email, pic_big_with_logo FROM user WHERE uid = me()";
    $access_token = array('auth_token' => $fb->getAccessToken);

    // fql
    $result = fb_fql_query($fb, $query, $access_token);

    $form['group_about_me']['field_user_firstname'][0]['value']['#value'] = $result[0]['first_name'];
    $form['group_about_me']['field_user_firstname'][0]['#value']['value'] = $result[0]['first_name'];

    $form['group_about_me']['field_user_middle'][0]['value']['#value'] = $result[0]['middle_name'];
    $form['group_about_me']['field_user_middle'][0]['#value']['value'] = $result[0]['middle_tname'];


    $form['group_about_me']['field_user_lastname'][0]['value']['#value'] = $result[0]['last_name'];
    $form['group_about_me']['field_user_lastname'][0]['#value']['value'] = $result[0]['last_name'];

    $form['group_about_me']['field_user_email'][0]['value']['#value'] = $result[0]['email'];
    $form['group_about_me']['field_user_email'][0]['#value']['value'] = $result[0]['email'];

    $form['group_about_me']['field_user_profile_image'][0]['value']['#value'] = $result[0]['pic_big_with_logo'];
    $form['group_about_me']['field_user_profile_image'][0]['#value']['value'] = $result[0]['pic_big_with_logo'];

    return $form;
}

/**
* Implementation of hook_form_alter.
*
* Adds a checkbox to node edit and comment forms.  This checkbox lets
* facebook users know that content may be published to their Wall,
* and gives them a chance to prevent that.
*/
function fb_module_form_alter(&$form, $form_state, $form_id) {
   if (isset($GLOBALS['_fb']) && fb_facebook_user()) {  // will be set if user logged using facebook connect
     switch($form_id)   {
         case 'node_form':
             $form['dff_custom']['stream_publish'] = array(
               '#type' => 'checkbox',
               '#title' => 'Share your review with your friends on Facebook',
               '#default_value' => TRUE,
             );
             break;
         case 'comment_form':
            $form['dff_custom']['stream_publish'] = array(
                '#type' => 'checkbox',
                '#title' => 'Share your review with your friends on Facebook',
                '#default_value' => TRUE,
            );
            break;
         case 'profile_node_form';
            $form['#after_build'][] = '_fb_module_after_build';
            break;
     }
  }
}

I think you're better off using hook_form_alter() to pre-populate the default values.

Also, you shouldn't name your module "fb_module" because "fb_..." is essentially reserved by modules/fb. I recommend "custom_fb" or "mysite_fb".

Dave thanks for the feedback. The reason I used after build was because these were CCK fields in Content Profile. It's very hard to update these in hook_form_alter.

The module's actual names is mysite_fb. I just took off identifying information...:)

subscribing

subscribing

drupal for facebook has been nicely installed and all modules seems to give me no problem. But I'm confused about what else to be done, there is nothing appearing in my drupal site, no Facebook Log-in icons, no Facebook connect icons, no "like" icon in my drupal site. The installation document stops at completing installation, but then what? What should be done after that?

I'm also learning the Drupal APIs. Can you please provide some information on where you added the function and how to call the function I would like to pull the data from Facebook and update content profile during initial registration and if possible, during linking of user's local account (already registered used) through Facebook connect.

Here are some thoughts on mapping the data without putting restriction on certain modules. Well, except one, the Rules module, optionally if only user need to get more FB data. The only need is to create FB events when it happens and we can conveniently tap into Rules existing facility to validate, populate fields (including CCK), update the node, etc.

These events can be triggered when user connect with FB, on demand or using FB real-time.
#907706: Rules module integration, we probably only need the following events
- fb_user_connected = User has connected his FB account
- fb_user_disconnected = User has disconnected his FB account
- fb_user_login = User has logged in via FB

and some sample rules..

subscribing

++subscribing :-)

subscribing - I'd like to work on integrating Facebook with Advanced Profile Kit.

Good idea. Subscribing.

subscribing

subscribing

subscribing

subscribing

following

subscribing.

subscribing.

Since my users only keep their Facebook profiles up to date this would be a fantastic feature. Did any of the thoughts from last October come to any results?

subscribing..

I'll share if I get anywhere.. Thanks for sharing your progress, fellas

If anyone has more time than me, here's how I've been thinking about cutting and pasting it (nothing has been tested):

function mymodule_fb_user($op, $data, &$return) {
  $fb_app = isset($data['fb_app']) ? $data['fb_app'] : NULL;
  $fb = isset($data['fb']) ? $data['fb'] : NULL;
  $account = isset($data['account']) ? $data['account'] : NULL;

  if ($op == FB_USER_OP_POST_USER) {
     // Learn some details from facebook.
    $infos = fb_users_getInfo(array($fbu), $fb);
    $info = $infos[0];

     // add stuff to $account from $info
     // here's where you add your own code, like "$account['something'] = $info['something'] "
     
     // save user data
     if (user_save($account)) {
         return TRUE;
     } else {
         return FALSE;
     }
     
  }
}

All of the above is paper programming, not code that has actually run. Unfortunately, I know nothing about how to best call user_save, given that there are account settings, profile settings, profile categories etc. If you get this code (or something like it) to work, please post the result.

I've been pretty silent on this thread because I see this as a problem best solved by custom code. Drupal has so many ways of storing data with users (the $user->data, profile module, fields, profile nodes,...) and facebook has so much different data, depending on which extended perms are granted. So I don't expect a one-size-fits-all, click to configure kind of solution to work for many people. Of course I could be wrong so I like to see snippets from anyone that has anything working.

Regarding #36... I think better to implement the FB_USER_OP_PRE_USER operation. This is invoked before the fb_user.module creates a user. That is, throw some values into the &$return parameter of hook_fb_user, and those values will be passed into user_save() when fb_user.module calls it. That hook gives you a change to change a user's name or anything else about them before the account is created.

Subscribing.

subscribing

subscribing.

So I finally got around to doing something smallish with this. The following code will set the user account's language using the language set in Facebook when creating a new account. Replace "mymodule" for your own module name to make it work.

<?php
function mymodule_fb_user($op, $data, &$return) {
  $fb_app = isset($data['fb_app']) ? $data['fb_app'] : NULL;
  $fb = isset($data['fb']) ? $data['fb'] : NULL;
  $info = isset($data['info']) ? $data['info'] : NULL;

  if ($op == FB_USER_OP_PRE_USER) {
     // Set user language (wasn't able to get the FB language in a smoother way)
     fb_api_check_session($GLOBALS['_fb']);
     $fb_lang = $_SESSION['fb_locale'];
     $return['language'] = _fb_admin_i18n_map_reverse($fb_lang);
  }
}


/*
 * Mapping  Facebook locale -> Drupal language code 
 * Helper function, ripped from fb.admin.inc and slightly modified
 */
function _fb_admin_i18n_map_reverse($lang_code) {

  $languages_map = array(
    'af' => 'af_ZA',
    'ar' => 'ar_AR',
    'ay' => 'ay_BO',
    'az' => 'az_AZ',
    'be' => 'be_BY',
    'bg' => 'bg_BG',
    'bn' => 'bn_IN',
    'bs' => 'bs_BA',
    'ca' => 'ca_ES',
    'cs' => 'cs_CZ',
    'cy' => 'cy_GB',
    'da' => 'da_DK',
    'de' => 'de_DE',
    'el' => 'el_GR',
    'en' => 'en_US',
    'eo' => 'eo_EO',
    'es' => 'es_ES',
    'et' => 'et_EE',
    'eu' => 'eu_ES',
    'fa' => 'fa_IR',
    'fi' => 'fi_FI',
    'fo' => 'fo_FO',
    'fr' => 'fr_FR',
    'ga' => 'ga_IE',
    'gl' => 'gl_ES',
    'gn' => 'gn_PY',
    'gu' => 'gu_IN',
    'he' => 'he_IL',
    'hi' => 'hi_IN',
    'hr' => 'hr_HR',
    'hu' => 'hu_HU',
    'hy' => 'hy_AM',
    'id' => 'id_ID',
    'is' => 'is_IS',
    'it' => 'it_IT',
    'ja' => 'ja_JP',
    'jv' => 'jv_ID',
    'ka' => 'ka_GE',
    'kk' => 'kk_KZ',
    'km' => 'km_KH',
    'kn' => 'kn_IN',
    'ko' => 'ko_KR',
    'ku' => 'ku_TR',
    'la' => 'la_VA',
    'lt' => 'lt_LT',
    'lv' => 'lv_LV',
    'mg' => 'mg_MG',
    'mk' => 'mk_MK',
    'ml' => 'ml_IN',
    'mn' => 'mn_MN',
    'mr' => 'mr_IN',
    'ms' => 'ms_MY',
    'mt' => 'mt_MT',
    'nb' => 'nb_NO',
    'ne' => 'ne_NP',
    'nl' => 'nl_BE',
    'nn' => 'nn_NO',
    'pa' => 'pa_IN',
    'pl' => 'pl_PL',
    'ps' => 'ps_AF',
    'qu' => 'qu_PE',
    'rm' => 'rm_CH',
    'ro' => 'ro_RO',
    'ru' => 'ru_RU',
    'sa' => 'sa_IN',
    'se' => 'se_NO',
    'sk' => 'sk_SK',
    'sl' => 'sl_SI',
    'so' => 'so_SO',
    'sq' => 'sq_AL',
    'sr' => 'sr_RS',
    'sv' => 'sv_SE',
    'sw' => 'sw_KE',
    'ta' => 'ta_IN',
    'te' => 'te_IN',
    'tg' => 'tg_TJ',
    'th' => 'th_TH',
    'tl' => 'tl_ST',
    'tr' => 'tr_TR',
    'tt' => 'tt_RU',
    'uk' => 'uk_UA',
    'ur' => 'ur_PK',
    'uz' => 'uz_UZ',
    'vi' => 'vi_VN',
    'xh' => 'xh_ZA',
    'yi' => 'yi_DE',
    'zh-hans' => 'zh_CN',
    'zh-hant' => 'zh_TW',
    'zu' => 'zu_ZA',
  );
  
  $languages_map = array_flip($languages_map);
  return isset($languages_map[$lang_code]) ? $languages_map[$lang_code] : 'en';
}
?>

Good progress is good. Thanks for your work!

subscribingg

Does anyone have an example of code to get content, say gender, into a field?

subscribing. this is huge.

subscribing...

This seems very interesting. Harnessing the power of facebook in drupal sites.

Also subscribing.

Let me ask guys. I am trying to figure out how to connect a new profile created by clicking "Connect with Facebook" button with user's FB email address (it doesn't show in the drupal "users" table). Anyone know how to do that or where to code?

The RPX module is able to do this for either core user Profile or Content Profile modules.

Thanks. I would check this out and leave a short information does it work accurately.

It seems that Janrain Engage doesn't wrok as I wanted:
1. the bridge between Janrain Engage and Content Profile doesn't exist,
2. also there is not any "Connect with" button as I described in the Drupal for Facebook case: http://drupal.org/node/1181834.

Dave Cohen wrote:

I've been pretty silent on this thread because I see this as a problem best solved by custom code. Drupal has so many ways of storing data with users (the $user->data, profile module, fields, profile nodes,...) and facebook has so much different data, depending on which extended perms are granted. So I don't expect a one-size-fits-all, click to configure kind of solution to work for many people. Of course I could be wrong so I like to see snippets from anyone that has anything working.

Regarding #36... I think better to implement the FB_USER_OP_PRE_USER operation. This is invoked before the fb_user.module creates a user. That is, throw some values into the &$return parameter of hook_fb_user, and those values will be passed into user_save() when fb_user.module calls it. That hook gives you a change to change a user's name or anything else about them before the account is created.

and

I think you're better off using hook_form_alter() to pre-populate the default values.

I tried for several days to figure out in which way, during registration, save for example "birthday" or "list of friends" fields from facebook to the same standard profile fields on Drupal, but without any success.
Can you show us a working snippet for that? (I'm using 7.x-3.x version)

I think saving data from facebook's account with ease were one of the missing feature of your promising module.

Thanks in advance

Hi all, I am looking for the patch or code which I can use to simply update the profile name and picture with facebook name and picture. I am presently using fb module.

Please help

Thanks

Thank you RasputinJones! Some of your code helped me a lot.
In a hook_form_alter:

      if (isset($GLOBALS['_fb']) && fb_facebook_user()) {
        $fb = $GLOBALS['_fb'];
        $query = "SELECT first_name, current_location FROM user WHERE uid = me()";
        $access_token = array('auth_token' => $fb->getAccessToken);
        $result = fb_fql_query($fb, $query, $access_token);
        $form['title']['#default_value'] = $result[0]['first_name'];
        $form['field_city'][0]['#default_value']['value'] = $result[0]['current_location']['city'];
      }

Guys, is there any progress on syncing Content Profile fields to Facebook user profile fields?

fb_user.module will call hook_fb_user() before calling user_save. So, your module a chance to add data that will be passed to user_save(). The profile module will honor that data, if you get the field names just right.

The example code below is for D6, and works if you've named your profile fields "profile_name_first" and "profile_name_last". In D7, it works in principle the same way, but the data structure has become wildly more complicated.

Now if someone wants to make a module that makes this stuff configurable. I.e. when editing a profile fields, add an option "grab this data from facebook". That would be cool!

function custom_fb_user($op, $data, &$return) {
  if ($op == FB_USER_OP_PRE_USER) {
    // fb_user.module is going to call user_save().  We have a chance to add data.

    // $data['info'] is data learned from facebook.
    // $return is array to be passed into user_save().

    // If the names of these profile fields change, breaks this code.
    $return['profile_name_first'] = $data['info']['first_name'];
    $return['profile_name_last'] = $data['info']['last_name'];

  }
}

For drupal 7 i can fill custom user fields like this:

function wb_connect_fb_user($op, $data, &$return) {
	global $user;
	if ($op == FB_USER_OP_PRE_USER) {
		$return['field_voornaam']['und'][0] = $data['info']['first_name'];
		$return['field_achternaam']['und'][0] =$data['info']['last_name'];
         }
  
}

Only one problem, only the first letter is saved :s

grts

frederic

Aren't you missing the value item?

$return['field_fieldname']['und'][0]['value']

Of course! How Stupid of me! Thanks for your quick reply, it works like a charm now!
Maybe we should post this example in the documentation section. I think there are a lots of people searching for this one.

Also... to do this you need to know what those fields are. It won't always be 'value'. For some fields, it might be URL, email, etc, some fields are different.

@kevinquillen yes i know... I have worked many times with those things... Its just that i was trying so hard to get this thing working with the fb module that i overlooked this ;-)

Subscribe! :)

Otherwise I have a problem with this solution, concrete with the hometown information. If i debug my hook with dpm() then I cant find this data tag: $data['info']['location']['name'] Its missing. :( The interesting part is that I got this permission from FB, and if I click to the profile page after login with an admin, where the module dump out the FB params, there I see it. Anybody has any idea? :) Thanks!

How do you get the data you're passing to dpm?

The piece on the user profile comes from fb_devel.module. It does not call fb_graph(), but instead:

            // Don't use fb_api() because we don't want the caching here.
            $info = $fb->api("/$fbu", array('access_token' => fb_get_token($fb)));

As you may know, not all users make that info available. You can also try facebook's graph explorer to see what's there.

Hi! Thanks the answer.
My module:

 function mymodule_fb_user($op, $data, &$return) {
  if ($op == FB_USER_OP_PRE_USER) {
    #$return['field_hometown']['und'][0]['value'] = $data['info']['location']['name'];
    $return['field_birthday']['und'][0]['value'] = date('Y-m-d', strtotime($data['info']['birthday']));
  }
  drupal_set_message('Devel: fb_user '.$op); dpm($return); dpm($data);
} 

And here I cant find the data in the $data array, but if I check the http://mysite.com/user/$uid page there I can read this:

facebook graph for /123456789:
Array
(
    [id] => 123456789
    [name] =>  --
    [first_name] => --
    [last_name] => --
    [link] =>  --
    [username] => --
    [location] => Array
        (
            [id] => 105603297474072
            [name] => Cityname
        )
    [gender] => --
    [email] => --
    [locale] => --
)

Has you got any idea about this problem? Thanks! Lazly

There's a convoluted history behind the $info passed to that hook. It used to come from a facebook api called users_getInfo(). They deprecated that, so the code switched to use something called FQL. It still uses that, but the devel info you're seeing on user/$uid comes from a new thing called the graph API.

There are a couple possible fixes for this....

a) it might be possible to add location fields to fb_users_getInfo(). You'd have to look up exactly what's available to FQL.

b) fb_users_getInfo() could be changed to use the graph query. This is a bigger change, probably not worth doing until the next major release of modules/fb.

And finally this is probably your best bet for an immediate workaround:

In your own hook, call something like:

$more_info = fb_graph($data['fbu']);

That $more_info array should end up being the same data you see on the user page.

Hi!

Unfortunately the fb_graph isnt worked for me correctly, because that want an second parameter, but I copy out the source of fb_devel_user_view function (you can find it in fb_devel module), and rewrite it. Its was successful, my module currently looks like this, and its working:

 function mymodule_fb_user($op, $data, &$return) {
  if ($op == FB_USER_OP_PRE_USER) {
    $fb = $GLOBALS['_fb'];
    try {
      $info = $fb->api('/'.$data['fbu'], array('access_token' => fb_get_token($fb)));
      $return['field_hometown']['und'][0]['value'] = $info['location']['name'];
      $return['field_birthday']['und'][0]['value'] = date('Y-m-d', strtotime($data['info']['birthday']));
      //watchdog('mymodule_fb_data',print_r($data,true));
      //watchdog('mymodule_fb_fb',print_r($fb,true));
      //watchdog('mymodule_fb_info',print_r($info,true));
    }
    catch (Exception $e) {
      watchdog('desszert_fb',
        'Failed to get info for fbu !id<br />message: !message',
        array('!id'=>$data['fbu'], '!message'=>$e->getMessage()),
        WATCHDOG_WARNING
      );
    }
  }
}

subscribing! :D