registered site user email addresses

[harold watson 0]

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.

[jayat1familytree 0]

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

 

[harold watson 0]

thank you

[Kare 0]

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

[harold watson 0]

good point, thank you