Skip to content

Instantly share code, notes, and snippets.

@fahdi
Forked from siffring/gist:3130009
Last active January 20, 2021 22:18
Show Gist options
  • Save fahdi/5086ab7ae9b7cfe574a29b426d288678 to your computer and use it in GitHub Desktop.
Save fahdi/5086ab7ae9b7cfe574a29b426d288678 to your computer and use it in GitHub Desktop.
Export ExpressionEngine members to CSV
<?php
header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename=member_export.csv');
header('Pragma: no-cache');
?>
{!--
Exports the EE members in CSV format. This is only accessible to admins and editors.
Does not export members in the banned or guests groups.
--}
{exp:ajw_export
sql="SELECT exp_members.member_id AS member_id, exp_member_groups.group_title AS 'group', screen_name, email, m_field_id_12 AS address_city, m_field_id_15 AS address_country,m_field_id_10 AS address_line_1, m_field_id_11 AS address_line_2,m_field_id_13 AS address_state,m_field_id_14 AS address_zip,m_field_id_16 AS import_contributions,m_field_id_2 AS receive_promotions, FROM_UNIXTIME(join_date) AS join_date FROM exp_members, exp_member_data, exp_member_groups WHERE exp_member_data.member_id = exp_members.member_id AND exp_members.group_id = exp_member_groups.group_id AND exp_members.group_id NOT IN (2,3)"
format="csv"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment