Table of Contents
Updated. Download version 1.2 here
Features
• User friendly interface
• 2 delimiter options: tab | comma
• Filter by member group
• Filter by join date
• Output any core member data fields of choice
• Output any custom member fields of choice
• Optional JS date picker for date fields
First steps
Step 1. Create a new template
Step 2. Allow PHP for this template. PHP in Templates
Step 3. Copy and paste “The Code” that follows inside your template, or download the full package here. Coping the code from this page is not 100% guaranteed as some characters are striped out on editing.
Step 4. Add or remove group ids to the following array:
$allow_access = array(1);
By default, only super admins (1) have access to this script. To add more groups separate them with a comma. Example:
$allow_access = array(1,8,9);
Step 5. To use the optional date picker for date fields, set $use_datepicker to TRUE then set the appropriate paths to the js files.
Note: The datepicker js, by Mathieu Jondet, requires prototype and scriptaculous. You are not required to use it. Set $use_datepicker to FALSE to disable this feature.
The files can be downloaded here.
$use_datepicker = TRUE;
$datepicker_js = "/scripts/datepicker.js";
$prototype_js = "/scripts/lib/prototype.js";
$scriptaculous_js = "/scripts/src/scriptaculous.js";
The Code
Notes:
Note 1. Make sure that $allow_access only contains the ids of admins.
Note 2. If you want to use the datepicker widget, download the appropriate js files to your server and set the variables at the top of the script.
Download here.
Note 3. Visit the page on a browser.
http://domain.com/export_member_data/
Note 4. Use the interface to filter and select data to be exported.
Note 5. Filter dates expect either a perfect string or nothing. To enter a date use this notation: YYYY-MM-DD hh:mm AM/PM. Example: 2008-08-29 12:19 PM
DatePicker widget
DatePicker widget using Prototype and Scriptaculous.
(c) 2007 Mathieu Jondet
Eulerian Technologies
DatePicker is freely distributable under the same terms as Prototype.
In order to use the datepicker widget, download the files below, upload them to your server, and setup the url paths to the js files as described above.
Download files
you can download this script and all required js files by clicking the link below
File:Export EE Member Data-1.2.tgz
Result:
All selected data will be exported to a text-file. Each field is seperated with a comma (,) or tab (\t) and each text is surrounded with double quotes (”“). Each row is placed on a new line. Save the text-file to your desktop and open it with Excel or probably any other Spreadsheet-tool. Follow the instructions with the information as provided.
Category:Exporting Category:Members