Please add the option to download all users

1 month 1 week ago #321083 by ontarget
Hi
Client asked me

I’m trying to download all registrants to date
But I am only managing to get one page . I cannot see where to tick in order to get the complete database.
I’m sure it in front of me but I just can’t see.


I sympathised with her and said its not possible unless you do it page by page which is impractical with 7000 users.
Can you please do an export function for all users via joomla backend - it would be simple and welcome addition.

Please Log in to join the conversation.

1 month 1 week ago #321086 by nant

ontarget wrote: Hi
Client asked me

I’m trying to download all registrants to date
But I am only managing to get one page . I cannot see where to tick in order to get the complete database.
I’m sure it in front of me but I just can’t see.


I sympathised with her and said its not possible unless you do it page by page which is impractical with 7000 users.
Can you please do an export function for all users via joomla backend - it would be simple and welcome addition.


Just dump the joomla users table using phpmyadmin

Please Log in to join the conversation.

1 month 1 week ago #321091 by ontarget
Replied by ontarget on topic Please add the option to download all users
Thanks Nick
That is what I did for her - she is an office secretary with no clue about doing such a complex task.
Also the cb comprofiler table doesnt include users email addresses so we would need to do a sql join on the jos_users table via their id.

If you could for the export function include something like this that would populate a email col

$db = JFactory::getDbo();
$tr_table_u = $db->quoteName('#__users');
$email = $db->quoteName('email');
$c_id = $db->quoteName('id');
$query = "SELECT $email FROM $tr_table_u WHERE $c_id =". {jos_comprofiler___user_id};
$db->setQuery($query);
$uemail = $db->loadResult();
return $uemail;

Please Log in to join the conversation.

1 month 1 week ago #321111 by krileon
Replied by krileon on topic Please add the option to download all users
We're not going to do a generic database dump hardcoded in. Join the _users and _comprofiler tables and dump them via phpmyadmin. There's 3rd party Joomla reporting extensions that let you do this by supplying custom database queries.

As for CB > User Management export functionality it's not meant to dump your entire site. It processes the actual user objects so it gives a realistic expectation of data that CB can work with since it's meant to be used to move small batches of users between sites. It would crash your site trying to export, or imported, too many users. We've plans to implement a batching functionality for this so it, using ajax, collects the users in batches but I've no time frame for that. It's not common someone needs to dump there entire sites users so it's a low priority feature.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

1 month 1 week ago #321116 by ontarget
Replied by ontarget on topic Please add the option to download all users
Thanks for the reply Krileon.
I've used fabrik in the past for this functionality to create a list which combines cb user data and jos_users emails - this allows you to do a csv dump of all users. Takes about 3 seconds for it to process 5000 users into a csv file.
Only 128m php memory_limit so no big deal.
Fabriks a pretty big and specialised component so its like using a sledgehammer to crack a nut!
Being able to export your users by csv is a useful feature e.g for organising and re-importing into specific mailing lists etc
So I for one would love to see a export all feature in CB please don't shelf the idea.
I think there was a 3rd party component called CB juice which could do this but its now deprecated.

Please Log in to join the conversation.

1 month 1 week ago #321121 by krileon
Replied by krileon on topic Please add the option to download all users
Fabrik is just dumping raw database query result data. CBs import/export functionality works with actual user objects for proper serialization of user data. Several fields have processed values that a raw database dump doesn't provide. It's just not that simple when it comes to user data like this. We will be implementing a solution to more efficiently handle large exports and imports, but again it's just not a priority to implement right now as it's not an often needed feature and we've other higher priority things to implement.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.460 seconds

Facebook Twitter LinkedIn