CiviCRM Community Forums (archive)

Hi - I needed to do the same thing and couldn't find a way to do it through the interface.  I used phpmyadmin to access the underlying data with this query which did the trick.

SELECT con.id, con.first_name as First, con.last_name as Last,  emp.organization_name as Employer, uf_name as DrupUser
FROM ((`civicrm_contact` con
INNER JOIN civicrm_contact emp on con.employer_id = emp.id)
LEFT JOIN  `civicrm_uf_match` mat on con.id=mat.contact_id)
LEFT JOIN xxxxxx.drup_users u on mat.uf_id=u.uid
where con.contact_type="individual"

Note that you need to replace xxxxxx with the name of your drupal database (assuming you have two different databases)

Hope this helps

For alan - og user import - won't that do what you need?

better integration between civicrm and drupal is always beneficial to the community at large. Would be great if you / your organization members could help and contribute code to the project that improves this aspect of civicrm

lobo