Sorry. I'm missing something very basic here. I've created a new VR mailing list in Drupal and it appears over on the VR site. I've created a node view containing email address, first name and last name from a profile content type. I've gone into the VR mailing list and the List Field Map tab. I selected the view and mapped the email address, first name and last name. (The pulldowns reflect the fields in my view.) When I Push Local Data, I see the progress bar, but nothing goes to VR. If I add the data manually using the Add List Member tab, I can push it up to VR and I see it when I log in to VR and on the Drupal New Members tab.

Does the view need to be set up in a particular way? I've tried everything I can think of. Does it need to be a user view? I thought I read that it needs to be a node view. Are fields other than email address, first name and last name required?

Thanks for your help and I apologize if I missed something quite elementary.

Comments

jbomb’s picture

jbomb commented

It sounds like the view is setup properly. Does the view use any arguments? The update process will pass each list member's 'uid' to the view.

Rick Nashleanas’s picture

Rick Nashleanas commented

Thanks. I've created a node view filtering on a "profile" content type created within two date ranges (with no exposed filters or arguments). The profile content type is being used as a Content Profile type for user profiles: http://drupal.org/project/content_profile. The fields I display include User: Uid, Content: First Name, Content: Last Name, User: Email, Content: Join Date.

I see a list in preview that displays my data. I went to Manage Mailing Lists > New Members > List Field Map. I select my view from the pulldown. After saving the field map, I see my fields from my view and assign Email, First Name and Last Name from the pulldowns and save it. Then, I go to Push Local Data and I get nothing. Should I map Uid to something?

I also tried creating a User view with no luck.

If you can think of anything else I can try, I'm on it. Thanks.

jbomb’s picture

jbomb commented

Hm, I generally set the view up to use "user" as the base table. I then set a relationship to use the profile content type that comes packaged with content_profile. Next, I add an argument for the user id. Finally I add the fields from the content profile node. It is very important that the view takes the user id as an argument.

The attached view should get you started. It uses two fields "field_firstname" and "field_lastname"

<?php


$view = new view;
$view->name = 'user_map';
$view->description = '';
$view->tag = 'demo';
$view->view_php = '';
$view->base_table = 'users';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('relationships', array(
  'content_profile_rel' => array(
    'label' => 'Content Profile',
    'required' => 0,
    'type' => 'profile',
    'id' => 'content_profile_rel',
    'table' => 'users',
    'field' => 'content_profile_rel',
    'relationship' => 'none',
  ),
));
$handler->override_option('fields', array(
  'field_firstname_value' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'link_to_node' => 0,
    'label_type' => 'none',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_firstname_value',
    'table' => 'node_data_field_firstname',
    'field' => 'field_firstname_value',
    'relationship' => 'content_profile_rel',
  ),
  'field_lastname_value' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'link_to_node' => 0,
    'label_type' => 'none',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_lastname_value',
    'table' => 'node_data_field_lastname',
    'field' => 'field_lastname_value',
    'relationship' => 'content_profile_rel',
  ),
));
$handler->override_option('arguments', array(
  'uid' => array(
    'default_action' => 'empty',
    'style_plugin' => 'default_summary',
    'style_options' => array(),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => '',
    'breadcrumb' => '',
    'default_argument_type' => 'fixed',
    'default_argument' => '',
    'validate_type' => 'none',
    'validate_fail' => 'not found',
    'break_phrase' => 0,
    'not' => 0,
    'id' => 'uid',
    'table' => 'users',
    'field' => 'uid',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
    ),
    'relationship' => 'none',
    'default_options_div_prefix' => '',
    'default_argument_fixed' => '',
    'default_argument_user' => 0,
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'newsletter' => 0,
      'page' => 0,
      'profile' => 0,
      'story' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'validate_argument_php' => '',
  ),
));
$handler->override_option('filters', array(
  'uid' => array(
    'operator' => 'not in',
    'value' => array(
      '0' => 0,
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'uid',
    'table' => 'users',
    'field' => 'uid',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));

?>
Rick Nashleanas’s picture

Rick Nashleanas commented

Thanks for your help. Here's a work flow that we came up with.

We installed Views Bulk Operations. We created a user view filtered by the selection criteria we needed. The page style we used was Bulk Operations. We selected Subscribe to [our mailing list] in style options. We viewed the page, selected all users, and clicked the Submit to [our mailing list].

We went to our mailing list in the vertical response drupal module and pushed the list and, voila, all worked.

When we pushed, we got the error:

recoverable fatal error: Object of class stdClass could not be converted to string in /home/mbca/www/mbca.biz/includes/common.inc on line 945

However, this didn't seem to impact the push. Any insights?

jbomb’s picture

jbomb commented

recoverable fatal error: Object of class stdClass could not be converted to string in .../includes/common.inc on line 945

However, this didn't seem to impact the push. Any insights?

I'm not sure what could be causing this. Are you using the same view to "map" user properties to the list fields in VerticalResponse for the views bulk operation? If so, please try configuring the view so that the "default" view style plugin is "unformatted," then override the plugin settings for the VBO page.