[tbones]

Hi,

I´d like to create a email list of my users to hold a poll with LimeSurvey (LimeSurvey.org - The Leading Open Source Tool for Online Surveys - Home). I will extract the list as csv through phpMyAdmin but I need the query.

Minimum values are user id and email address, a surplus would be user name and user level to sort out some users.

Thx

[betagirl]

Originally Posted by tbones

Hi,

I´d like to create a email list of my users to hold a poll with LimeSurvey (LimeSurvey.org - The Leading Open Source Tool for Online Surveys - Home). I will extract the list as csv through phpMyAdmin but I need the query.

Minimum values are user id and email address, a surplus would be user name and user level to sort out some users.

Thx

This will work directly through phpMyAdmin -
SELECT `user_id`, `user_email`, `user_names` FROM `pligg_users` WHERE `user_level` = "normal" ORDER BY `user_email`;

[tbones]

It works perfect, thank you!

[P1mpPanther]

Now all we need is to add this to the admin area!

hmmm....

[tbones]

That´s not necessary. The csv file allows a convenient import to LimeSurvey and that allows to track the individual participance to the poll via email invitation.

[P1mpPanther]

Sorry, I was chiming in but not being very clear. The ability to export users contact info would be a nice feature for the admin section was all I meant.

[tbones]

Yeah, if it would provide (just as the file upload module) a link to a custom csv file that can be transformed into nearly every format.