Answers.Body: <p>We needed to do something similar, though not GDPR related. Because the Export does not access the Drupal user fields, we created a simple View (page display) to give us this data, based on CiviCRM Contact.</p>
  
  <p>We also used the <a href="https://www.drupal.org/project/views_data_export" rel="nofollow noreferrer">Views Export Data</a> module and 'attached' the csv to the Page above. Note the page is not required, you can simply use the csv display via the URL you configure for it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-21T19:41:23.673Z
Answers.LastActivityDate: 2018-05-21T19:41:23.673Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I'm trying to export the Drupal User ID's for a particular Civi group, in preparation for GDPR and as a general clear out. I am able to search for all users in Civi which are a CMS user (and therefore have a Drupal account) but when I go to export and download this information none of the available fields will provide the Drupal User ID, the columns are just blank. </p>
  
  <p>Is this my Civi getting confused and refusing to provide information (which it does do sometimes) or do I need to download this information in a different way. </p>
  
  <p>Hope that makes sense and thanks for any help!!</p>
  
Tags: <drupal><groups><export><cms-integration><gdpr>
Title: Exporting Drupal user account ID's through Civi search
ThreadText: # Exporting Drupal user account ID's through Civi search
  
  (Asked by: username_0 on 2018-05-21)
  
  I'm trying to export the Drupal User ID's for a particular Civi group, in preparation for GDPR and as a general clear out. I am able to search for all users in Civi which are a CMS user (and therefore have a Drupal account) but when I go to export and download this information none of the available fields will provide the Drupal User ID, the columns are just blank.
  
  Is this my Civi getting confused and refusing to provide information (which it does do sometimes) or do I need to download this information in a different way.
  
  Hope that makes sense and thanks for any help!!
  
  **Tags:** drupal, groups, export, cms-integration, gdpr
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-05-21. Score: 4
  
  We needed to do something similar, though not GDPR related. Because the Export does not access the Drupal user fields, we created a simple View (page display) to give us this data, based on CiviCRM Contact.
  
  We also used the [Views Export Data](https://www.drupal.org/project/views_data_export) module and 'attached' the csv to the Page above. Note the page is not required, you can simply use the csv display via the URL you configure for it.
  
  
  ---
  
  