Automate export of member database to server

I need to be able to export my S2Member Pro membership database to a file on my server (I want to be able to process the data and send out special notices). I already have programs that can process the CSV that is exported when I do this manually, but it requires that I do lots of steps manually.

Someone suggested that I find out the request that is issued when the Export button is pressed on the admin page and use wget to get the file. I’ve tried this (with the username and password as part of the URL) but I just get a redirect.

Is there an accepted way to do this? Ideally, I should be able to call a php script or shell script from cron and have the member data exported to a file on the server directly.

Hi David.

No, the User Export tool doesn’t have an API for this. You’ll have to create your own hack to achieve this.

These may help:
s2member-pro/includes/classes/exports-in.inc.php
Knowledge Base » Remote User Status (Custom API)
http://adambrown.info/p/wp_hooks/hook/wp_loaded
http://codex.wordpress.org/Function_Reference/get_users
http://www.s2member.com/codex/stable/s2member/api_functions/package-functions/#src_doc_get_s2member_custom_fields%28%29

That’s too bad. Looking at the code,you guys could refactor things so that there would be an official API to extract the data into arrays, and then wrap that in a function that could format it as a csv and response header.

I know I’m not the only customer who needs this kind of thing.

Thanks for the suggestion. I’m adding it to the feature requests list. :)