Please add the option to download all users

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.

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

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;

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.

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.

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.