Can't get Content Profile fields to show in a Views with the Type of USER [#514190]

I hope this is not a duplicate, although I have searched for a while in the issues queue; here's my problem:

I am basically trying to create a list of all users on my site which is no problem, BUT their Photo is being stored as a CONTENT PROFILE content type with an IMAGE UPLOAD field. Now I cannot access this field in views (looks like because it is a USER type view, I can't access any CONTENT stuff whatsoever).

(Also if you'd like to know why I am storing the profile image as a CONTENT PROFILE field vs. the built in PICTURE in the USER PROFILE)
It is because when I use the built in user profile picture, and I try to read it in a view, I have access to it but the IMAGECAHCE PRESETS don't show up, so I get a very large file and I can't display it correctly.

$view = new view;
$view->name = 'users_listing';
$view->description = 'Users Listing';
$view->tag = 'Users Listing';
$view->view_php = '';
$view->base_table = 'node';
$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('fields', array(
  'value_8' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 1,
    'id' => 'value_8',
    'table' => 'profile_values_profile_first_name',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_13' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 1,
    'id' => 'value_13',
    'table' => 'profile_values_profile_middle_name',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_12' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 1,
      'text' => '<h1 class=\'title\' >[value_8] [value_13] [value_12]</h1>',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_12',
    'table' => 'profile_values_profile_last_name',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'field_profile_photo_custom_fid' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'none',
    'format' => 'user_picture_large_default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_profile_photo_custom_fid',
    'table' => 'node_data_field_profile_photo_custom',
    'field' => 'field_profile_photo_custom_fid',
    'relationship' => 'none',
  ),
  'picture' => array(
    'label' => 'Picture',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'picture',
    'table' => 'users',
    'field' => 'picture',
    'relationship' => 'none',
  ),
  'value' => array(
    'label' => 'Academic Rank',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value',
    'table' => 'profile_values_profile_academic_rank',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_1' => array(
    'label' => 'Area of concentration',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_1',
    'table' => 'profile_values_profile_students_concentration',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_2' => array(
    'label' => 'Biography',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_2',
    'table' => 'profile_values_profile_students_bio',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'field_profile_bio_value' => array(
    'label' => 'Extended Biography',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_profile_bio_value',
    'table' => 'node_data_field_profile_bio',
    'field' => 'field_profile_bio_value',
    'relationship' => 'none',
  ),
  'value_3' => array(
    'label' => 'Courses Taken',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_3',
    'table' => 'profile_values_profile_students_courses',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_4' => array(
    'label' => 'Credentials / Degrees',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_4',
    'table' => 'profile_values_profile_credentials',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_5' => array(
    'label' => 'Date Started Program',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'date_format' => 'large',
    'custom_date_format' => '',
    'exclude' => 0,
    'id' => 'value_5',
    'table' => 'profile_values_profile_students_startyear',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_6' => array(
    'label' => 'Department',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_6',
    'table' => 'profile_values_profile_faculty_department',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_7' => array(
    'label' => 'Fax Number',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_7',
    'table' => 'profile_values_profile_fax_number',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_9' => array(
    'label' => 'Full Time Faculty',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'type' => 'yes-no',
    'not' => 0,
    'exclude' => 0,
    'id' => 'value_9',
    'table' => 'profile_values_profile_fulltime_faculty',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_10' => array(
    'label' => 'I have graduated from SCARP',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'type' => 'yes-no',
    'not' => 0,
    'exclude' => 0,
    'id' => 'value_10',
    'table' => 'profile_values_profile_students_graduated',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_11' => array(
    'label' => 'Internships',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'type' => 'ul',
    'separator' => ', ',
    'empty' => '',
    'exclude' => 0,
    'id' => 'value_11',
    'table' => 'profile_values_profile_student_internships',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_14' => array(
    'label' => 'Notes',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_14',
    'table' => 'profile_values_profile_faculty_notes',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_15' => array(
    'label' => 'Notes',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_15',
    'table' => 'profile_values_profile_personnel_notes',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_16' => array(
    'label' => 'Office Address',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_16',
    'table' => 'profile_values_profile_office_address',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_17' => array(
    'label' => 'Office Hours',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_17',
    'table' => 'profile_values_profile_faculty_officehours',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_18' => array(
    'label' => 'On Leave:',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_18',
    'table' => 'profile_values_profile_faculty_leaveindicator',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_19' => array(
    'label' => 'Other Courses Taught',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'type' => 'ul',
    'separator' => ', ',
    'empty' => '',
    'exclude' => 0,
    'id' => 'value_19',
    'table' => 'profile_values_profile_other_courses',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_20' => array(
    'label' => 'PDF Link',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'display_as_link' => 1,
    'exclude' => 0,
    'id' => 'value_20',
    'table' => 'profile_values_profile_students_pdf',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_21' => array(
    'label' => 'PDF Link ',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'display_as_link' => 1,
    'exclude' => 0,
    'id' => 'value_21',
    'table' => 'profile_values_profile_faculty_pdf',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_22' => array(
    'label' => 'Personal website URL ',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'display_as_link' => 1,
    'exclude' => 0,
    'id' => 'value_22',
    'table' => 'profile_values_profile_personal_url',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_23' => array(
    'label' => 'Phone Number',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_23',
    'table' => 'profile_values_profile_phone_number',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_24' => array(
    'label' => 'Previous Degree',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_24',
    'table' => 'profile_values_profile_students_prevdegree',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_25' => array(
    'label' => 'Program',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_25',
    'table' => 'profile_values_profile_students_program',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_26' => array(
    'label' => 'Public Email',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_26',
    'table' => 'profile_values_profile_public_email',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_27' => array(
    'label' => 'Publications',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'type' => 'ul',
    'separator' => ', ',
    'empty' => '',
    'exclude' => 0,
    'id' => 'value_27',
    'table' => 'profile_values_profile_students_publications',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_28' => array(
    'label' => 'Related Work Experience',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_28',
    'table' => 'profile_values_profile_students_experience',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_29' => array(
    'label' => 'Scholarships and Awards',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'type' => 'ul',
    'separator' => ', ',
    'empty' => '',
    'exclude' => 0,
    'id' => 'value_29',
    'table' => 'profile_values_profile_students_scholarships',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_30' => array(
    'label' => 'Short Biography',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_30',
    'table' => 'profile_values_profile_faculty_bio',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_31' => array(
    'label' => 'Teaching Assistantships',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'type' => 'ul',
    'separator' => ', ',
    'empty' => '',
    'exclude' => 0,
    'id' => 'value_31',
    'table' => 'profile_values_profile_students_taships',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_32' => array(
    'label' => 'Thesis Supervisor',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_32',
    'table' => 'profile_values_profile_thesis_supervisor',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_33' => array(
    'label' => 'Thesis Topic',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_33',
    'table' => 'profile_values_profile_students_thesis',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_34' => array(
    'label' => 'Title / Position',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_34',
    'table' => 'profile_values_profile_position',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'field_profile_supervisors_uid' => array(
    'label' => 'Supervisors',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_node' => 1,
    'label_type' => 'widget',
    'format' => 'default',
    'multiple' => array(
      'group' => 1,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => 0,
    ),
    'exclude' => 0,
    'id' => 'field_profile_supervisors_uid',
    'table' => 'node_data_field_profile_supervisors',
    'field' => 'field_profile_supervisors_uid',
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'value' => array(
    'id' => 'value',
    'table' => 'profile_values_profile_last_name',
    'field' => 'value',
  ),
));
$handler->override_option('arguments', array(
  'uid' => array(
    'id' => 'uid',
    'table' => 'users',
    'field' => 'uid',
  ),
));
$handler->override_option('filters', array(
  'rid' => array(
    'id' => 'rid',
    'table' => 'users_roles',
    'field' => 'rid',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('items_per_page', 1);
$handler = $view->new_display('page', 'Faculty', 'page_1');
$handler->override_option('arguments', array(
  'uid' => array(
    'default_action' => 'default',
    'style_plugin' => 'default_summary',
    'style_options' => array(),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => '',
    'breadcrumb' => '',
    'default_argument_type' => 'user',
    '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,
      '3' => 0,
      '6' => 0,
      '5' => 0,
      '8' => 0,
      '7' => 0,
      '4' => 0,
    ),
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
    'default_options_div_prefix' => '',
    'default_argument_user' => 1,
    'default_argument_fixed' => '',
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'panel' => 0,
      'affiliated_community' => 0,
      'course' => 0,
      'event' => 0,
      'news' => 0,
      'page' => 0,
      'profile_attachments' => 0,
      'publication' => 0,
      'research' => 0,
      'story' => 0,
      'student_project' => 0,
      'top_header_banner_image' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(
      '2' => 0,
      '3' => 0,
      '1' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'validate_argument_php' => '',
  ),
));
$handler->override_option('filters', array(
  'rid' => array(
    'operator' => 'or',
    'value' => array(
      '6' => '6',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'rid',
    'table' => 'users_roles',
    'field' => 'rid',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
    'reduce_duplicates' => 0,
  ),
));
$handler->override_option('path', 'newfacultyprofile');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
));
$handler = $view->new_display('block', 'All Faculty Fulltime', 'block_1');
$handler->override_option('fields', array(
  'field_profile_photo_custom_fid' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_node' => 0,
    'label_type' => 'none',
    'format' => 'user_picture_thumb_default',
    'multiple' => array(
      'group' => TRUE,
      'multiple_number' => '',
      'multiple_from' => '',
      'multiple_reversed' => FALSE,
    ),
    'exclude' => 0,
    'id' => 'field_profile_photo_custom_fid',
    'table' => 'node_data_field_profile_photo_custom',
    'field' => 'field_profile_photo_custom_fid',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'value_8' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 1,
    'id' => 'value_8',
    'table' => 'profile_values_profile_first_name',
    'field' => 'value',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'value_13' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 1,
    'id' => 'value_13',
    'table' => 'profile_values_profile_middle_name',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_12' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '[value_8] [value_13] [value_12]',
      'make_link' => 0,
      'path' => 'newfacultyprofile/[uid]',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 1,
    'id' => 'value_12',
    'table' => 'profile_values_profile_last_name',
    'field' => 'value',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'uid' => array(
    'label' => 'Uid',
    'alter' => array(
      'alter_text' => 1,
      'text' => '[value_8] [value_13] [value_12]',
      'make_link' => 1,
      'path' => 'newfacultyprofile/[uid]',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_user' => 0,
    'exclude' => 0,
    'id' => 'uid',
    'table' => 'users',
    'field' => 'uid',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'value' => array(
    'label' => 'Academic Rank',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value',
    'table' => 'profile_values_profile_academic_rank',
    'field' => 'value',
    'relationship' => 'none',
  ),
  'value_6' => array(
    'label' => 'Department',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'value_6',
    'table' => 'profile_values_profile_faculty_department',
    'field' => 'value',
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'value' => array(
    'order' => 'ASC',
    'id' => 'value',
    'table' => 'profile_values_profile_last_name',
    'field' => 'value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array());
$handler->override_option('filters', array(
  'rid' => array(
    'operator' => 'or',
    'value' => array(
      '6' => '6',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'rid',
    'table' => 'users_roles',
    'field' => 'rid',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
    'reduce_duplicates' => 1,
  ),
  'value' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'value',
    'table' => 'profile_values_profile_fulltime_faculty',
    'field' => 'value',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'status' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'status',
    'table' => 'users',
    'field' => 'status',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'custom_profile_photo' => 'custom_profile_photo',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('items_per_page', 0);
$handler->override_option('row_options', array(
  'inline' => array(),
  'separator' => '',
));
$handler->override_option('block_description', 'Users : Listing : Faculty : Fulltime');
$handler->override_option('block_caching', -1);

(you might say change the Views type from USER to NODE)..
Already tried that, and what happens then is I get a lot of duplicate listings because it is querying the database for NODES as opposed to users and I end up getting duplicates for all the content they have created.

now I have tried to go about creating this list two-three different ways and none of them work.. I would really really really appreciate your help..

thanks

Comments

Comment #1

puya CreditAttribution: puya commented 9 July 2009 at 08:41

I am basically trying to create a list of all users on my site which is no problem, BUT their Photo is being stored as a CONTENT PROFILE with an IMAGE UPLOAD field. Now I cannot access this field in views (looks like because it is a USER type view, I can't access any CONTENT stuff whatsoever).

now I have tried to go about creating this list two different ways and none of them work.. I would really really appreciate your help..

thanks

Comment #2

puya CreditAttribution: puya commented 10 July 2009 at 23:32

Ok I solved this problem by defining a relationship between the USER view and the CONTENT PROFILE field in the relationships tab. Then all of the content fields became available to e :) yess view rules..

Comment #3

giorgio79 CreditAttribution: giorgio79 commented 4 August 2009 at 09:17

Hey,

I seem to be having this issue as well.

I setup a user view, with a relationship for content profile.

Now, the problem is, whenever I add a user picture with content profile nothing shows up in the view, here it is:

Any advice is appreciated.


$view = new view;
$view->name = 'flagged_by_user';
$view->description = '';
$view->tag = '';
$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(
  'flag_user_content_rel' => array(
    'label' => 'user flagged content',
    'required' => 1,
    'flag' => 'myflag',
    'id' => 'flag_user_content_rel',
    'table' => 'users',
    'field' => 'flag_user_content_rel',
    'relationship' => 'none',
  ),
  '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(
  'name' => array(
    'label' => 'Name',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_user' => 1,
    'overwrite_anonymous' => 0,
    'anonymous_text' => '',
    'exclude' => 0,
    'id' => 'name',
    'table' => 'users',
    'field' => 'name',
    'relationship' => 'none',
  ),
  'points' => array(
    'label' => 'Points',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'set_precision' => FALSE,
    'precision' => 0,
    'decimal' => '.',
    'separator' => ' ',
    'prefix' => '',
    'suffix' => '',
    'exclude' => 0,
    'id' => 'points',
    'table' => 'userpoints',
    'field' => 'points',
    'relationship' => 'none',
  ),
  'picture' => array(
    'label' => 'Picture',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'picture',
    'table' => 'users',
    'field' => 'picture',
    'relationship' => 'content_profile_rel',
  ),
));
$handler->override_option('arguments', array(
  'content_id' => array(
    'default_action' => 'ignore',
    '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' => 'content_id',
    'table' => 'flag_content',
    'field' => 'content_id',
    'relationship' => 'flag_user_content_rel',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
      '3' => 0,
      '4' => 0,
    ),
    'default_options_div_prefix' => '',
    'default_argument_user' => 0,
    'default_argument_fixed' => '',
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'blog' => 0,
      'forum' => 0,
      'panel' => 0,
      'page' => 0,
      'profile' => 0,
      'story' => 0,
      'subscription' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(
      '3' => 0,
      '4' => 0,
      '2' => 0,
      '5' => 0,
      '6' => 0,
      '7' => 0,
      '8' => 0,
      '1' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'validate_argument_node_flag_name' => '*relationship*',
    'validate_argument_node_flag_test' => 'flaggable',
    'validate_argument_node_flag_id_type' => 'id',
    'validate_argument_user_flag_name' => '*relationship*',
    'validate_argument_user_flag_test' => 'flaggable',
    'validate_argument_user_flag_id_type' => 'id',
    'validate_argument_php' => '',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler = $view->new_display('block', 'Block', 'block_1');
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);

Comment #4

iant CreditAttribution: iant commented 13 August 2009 at 13:54

I'm having an issue similar to the original post in terms of being able to access content_profile fields in views2. I've used the technique to create a relationship. The problem I have is that I have 3 content profile types

Profile (used for both user role types)
Role 1 (locum) Profile details
Role 2 (practice) Profile details

so it is not clear what is the best way to set up a relationship - do I need one for each type (it doesn't seem to need them to get all content profile fields to who up in the fields list) also I seem to get and odd error see below when I add fields from content profile to my user view.

user warning: Column 'nid' in field list is ambiguous query: SELECT users.uid AS uid, users.name AS users_name, node_users_node_data_field_firstname.field_firstname_value AS node_users_node_data_field_firstname_field_firstname_value, node_users.nid AS node_users_nid, node_users.type AS node_users_type, node_users.vid AS node_users_vid, field_surname_value, nid, type, vid, field_gmc_value, field_phone_mobile_value, field_phone_value, users.mail AS users_mail, users.login AS users_login, users.picture AS users_picture FROM users users LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'locum' INNER JOIN users_roles users_roles ON users.uid = users_roles.uid LEFT JOIN content_type_profile node_users_node_data_field_firstname ON node_users.vid = node_users_node_data_field_firstname.vid WHERE (users.status <> 0) AND (users_roles.rid = 3) LIMIT 0, 25 in /drupal6/sites/all/modules/views/includes/view.inc on line 755.

Can anyone suggest where I need to go from here ?

Comment #5

Bilmar CreditAttribution: Bilmar commented 2 September 2009 at 03:45

puya-

Would using View type: Node and using Distinct results (so no duplicates) solve the problem?
Or would you happen to know if using this will slow down the query process?

Thanks!

Comment #6

iant CreditAttribution: iant commented 2 September 2009 at 08:05

Good idea !

I tried this and it works fine as long as I define relationships for each to the content types I have that i want reveal fields in the view..... That is until I try to remove duplicates with setting Distinct to Yes. The I get the following error.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid), node_users_node_data_field_firstname.field_firstname_valu' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_users_node_data_field_firstname.field_firstname_value AS node_users_node_data_field_firstname_field_firstname_value, node_users.nid AS node_users_nid, node_users.type AS node_users_type, node_users.vid AS node_users_vid, node_users_node_data_field_firstname.field_surname_value AS node_users_node_data_field_firstname_field_surname_value, node_users_1_node_data_field_gmc.field_gmc_value AS node_users_1_node_data_field_gmc_field_gmc_value, node_users_1.nid AS node_users_1_nid, node_users_1.type AS node_users_1_type, node_users_1.vid AS node_users_1_vid, node_users_node_data_field_firstname.field_phone_value AS node_users_node_data_field_firstname_field_phone_value, node_users_1_node_data_field_gmc.field_phone_mobile_value AS node_users_1_node_data_field_gmc_field_phone_mobile_value, node_users__users.login AS node_users__users_login, node_users__users.uid AS node_users__users_uid FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'profile' LEFT JOIN node node_users_1 ON users.uid = node_users_1.uid AND node_users_1.type = 'locum' LEFT JOIN users_roles users_roles_value_0 ON node.uid = users_roles_value_0.uid AND users_roles_value_0.rid = 3 LEFT JOIN content_type_profile node_users_node_data_field_firstname ON node_users.vid = node_users_node_data_field_firstname.vid LEFT JOIN content_type_locum node_users_1_node_data_field_gmc ON node_users_1.vid = node_users_1_node_data_field_gmc.vid INNER JOIN users node_users__users ON node_users.uid = node_users__users.uid WHERE users_roles_value_0.rid = 3 LIMIT 0, 20 in /sites/all/modules/views/includes/view.inc on line 755.

Sorry I'm relatively inexperinced with drupal so I'm not sure where to go now.

I wonder if by being logically pure about my data structures I am making practical problems- so rather than having 3 content profile types viz.

Generic Stuff for all roles (Profile)
specific stuff for role 1 (Locum)
specific stuff for role 2 (Practice)

as I have now. I should either

move Generic stuff into Profile rather than content profile
put content profile generic stuff into the specifc stuff for each role

Comments on this please.

iant

Comment #7

puya CreditAttribution: puya commented 4 September 2009 at 06:23

iant :

if you are listing users you should create your view type as USERS. Then create relationships to any content profile content types as you have, so for example BOTH the generic stuff AND locum. (make suer generic stuff is the first relationship and Under the Locum Relationship, you are not using the general stuff relationship (from the Pull down menu under relationships)) Then all of your fields should be available to you.

Then you can create a page from that view and pass the argument of your USERNAME to that page and then you only get the information pertaining to that specific user, as long as you have also setup the argument in your View.

Also you don't need to select distinct. The only thing to watch for to avoid duplicates, is if you have multiple content profile items for a single user, under the view select "group multiple values"..

Arguments and Relationships can be hard to get your head around, I suggest you google tutorials for them to get a better understanding.. I found the tutorials at GOT DRUPAL particularly helpful (http://www.gotdrupal.com)

good luck