We need to provide a list of our members to our regulatory body. How can I make a spreadsheet of members? It should include name, date of birth & email address.
Thanks!
James
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
Export Member List | Forum
Team Taissa
Aug 12 '15
James, this kind of option doesn't come within the standard Oxwall installation.
As a solution we may suggest that you exported this data from database via PhpMyAdmin.
For example you may use this query:
SELECT u.username, u.email, d.textValue as `realname`, d1.dateValue as `birthdate` FROM `ow_base_user` u
LEFT JOIN ow_base_question_data d ON ( u.id = d.userId AND d.questionName = 'realname' )
LEFT JOIN ow_base_question_data d1 ON ( u.id = d1.userId AND d1.questionName = 'birthdate' )
And don't forget that you you can help us by using our public repository. Here you can add the features you would like to implement: https://bitbucket.org/oxwall/public . So you are always welcome to commit changes with working solution.
And also please use uservoice for adding your suggestions: http://oxwall.uservoice.com/forums/13756-ideas-for-oxwall
As a solution we may suggest that you exported this data from database via PhpMyAdmin.
For example you may use this query:
SELECT u.username, u.email, d.textValue as `realname`, d1.dateValue as `birthdate` FROM `ow_base_user` u
LEFT JOIN ow_base_question_data d ON ( u.id = d.userId AND d.questionName = 'realname' )
LEFT JOIN ow_base_question_data d1 ON ( u.id = d1.userId AND d1.questionName = 'birthdate' )
And don't forget that you you can help us by using our public repository. Here you can add the features you would like to implement: https://bitbucket.org/oxwall/public . So you are always welcome to commit changes with working solution.
And also please use uservoice for adding your suggestions: http://oxwall.uservoice.com/forums/13756-ideas-for-oxwall
