Jump to content
TNG Community
harold watson

registered site user email addresses

Recommended Posts

harold watson

I wondered if there a way to export email addresses from TNG to a csv file?  trying to compare information in a gmail account to what shows in TNG user info.

Share this post


Link to post
Share on other sites
jayat1familytree

Harold,

Here is a SQL query I used that is entered into a report, so I can just now run the report when needed. Then use the create CSV from the report results page.

SELECT u.realname AS Name, DATE(u.dt_registered) AS Registration_Date, CASE WHEN u.disabled = 0 THEN CONCAT('Yes',' - Active') ELSE 'No' END AS Active, u.email FROM tng_users AS u LEFT JOIN tng_people AS p ON u.personID = p.personID AND u.gedcom = p.gedcom WHERE (u.dt_registered != '0000-00-00 00:00:00') AND  u.lastlogin >= '2009-05-17 00:00:00'  ORDER BY u.realname

Hope that helps.

Jay

 

Share this post


Link to post
Share on other sites
Kare

Note that the query does not list registered users who have not yet logged in..

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×