How can I export user list

13 years 1 month ago #158166 by suatcamillo
How can I export user list was created by suatcamillo
Is it possible to export the user list including custom fields?

Please Log in to join the conversation.

13 years 1 month ago #160075 by suatcamillo
Replied by suatcamillo on topic Re: How can I export user list
Doesn't anyone have an answer to this question?

Please Log in to join the conversation.

13 years 1 month ago #160095 by nant
Replied by nant on topic Re: How can I export user list

suatcamillo wrote: Doesn't anyone have an answer to this question?


Nothing exists out of the box.

You would need to use phpmyadmin to export the comprofiler table - it contains most of the data you need.

Perhaps CB Juice can also be used.
The following user(s) said Thank You: suatcamillo

Please Log in to join the conversation.

13 years 1 month ago - 13 years 1 month ago #160283 by kona_pete
Replied by kona_pete on topic Re: How can I export user list

nant wrote:

suatcamillo wrote: Doesn't anyone have an answer to this question?


Nothing exists out of the box.

You would need to use phpmyadmin to export the comprofiler table - it contains most of the data you need.

Perhaps CB Juice can also be used.


I tried both of these.

CB Juice2 was of no use to me because it puts quotes around each "field" and that results in all field data winding up in one column when you open it in a spread sheet.

As for phpmyadmin, this works but has drawbacks.
1. The email and user name fields don't come through, although all others do.
2. I only want required fields and there is no way to filter out all the other fields.
3. It takes too much time to clean up the spread sheet to make it usable as my users want it updated daily.

I've done a lot of looking for an export utility that will allow field selection before exporting but haven't found anything yet. If anyone knows of anything, please let us know.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.369 seconds

Facebook Twitter LinkedIn