harold watson 0 Report post Posted April 13 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 0 Report post Posted April 14 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
harold watson 0 Report post Posted April 15 thank you Share this post Link to post Share on other sites
Kare 0 Report post Posted April 15 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
harold watson 0 Report post Posted April 15 good point, thank you Share this post Link to post Share on other sites