Skip to Content Skip to Menu

How can I export user list

13 years 9 months 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 or Create an account to join the conversation.

13 years 9 months 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 or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
13 years 9 months 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 or Create an account to join the conversation.

  • kona_pete
  • kona_pete
  • OFFLINE
  • Posts: 8
  • Thanks: 0
  • Karma: 0
13 years 9 months ago - 13 years 9 months 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.
Last edit: 13 years 9 months ago by kona_pete.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum