export a User list

[Jeff Fleisher]

My organization has some databases that we would like to coordinate with our forum list of members. I would like to create a list of our member's userID, email address, and full name (a field in our users profile) that I can import into excel. Can I do this from vBulletin or do I have to create an SQL query and run it from our ISP host on the database? I'm not a real SQL guru so I'd like create the list from vBulletin if possible. Is this possible?
Thanks,
Jeff

[Steve Machol]

There is no function in vB to do this. You would have to come up with a custom MySQL query that pulls data from multiple tables and joins it. Unfortunately I do not know how to write such a query.

[Reeve of Shinra]

If you use phpmyadmin, you can export a table as a csv or excel file...
You will want to export the 'users' and the 'userfield' tables iirc.

In excel, create a named range and use a vlookup to add the email addresses from the 'userfield' tab to the 'user' tab.