Exporting CB users

11 years 3 months ago #67500 by beat

Many thanks for keeping this very useful component up to date B)

also replied in related thread: :)

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info
11 years 3 months ago #67763 by bazanaius
If you go into the database of your site there is a table called jos_comprofiler or similar. This will contain the details of all your users. Something like phpmyadmin allows you to export this table as a csv file.
11 years 2 months ago #69081 by pvh
AGlossop wrote:

I've been looking at the CB Juice component, which apparently allows you to import users from a CSV. Not used it yet, and it's probably not yet Joomla 1.5 friendly. But it might have an export feature.

I have used CB Juice in Joomla 1.5 for importing about 100 users from another db via a csv file. Worked great.
CB Juice is also able to export the current CB users into a csv file. So, I would say: go for it.

10 years 11 months ago #78507 by denzel2364
unction defined
SQL error in comprofilerDB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usertype FROM model_users u LEFT JOIN model_comprofiler c on (u.id=c.user_id)' at line 1 SQL=SELECT ,usertype FROM model_users u LEFT JOIN model_comprofiler c on (u.id=c.user_id)

SELECT ,usertype FROM model_users u LEFT JOIN model_comprofiler c on (u.id=c.user_id)

model = my mysql equivelent of 'jos_'

testing the signature to see if it work
10 years 11 months ago #78510 by jciconsult
It is not an error that I have seen. You may have some errors in your tables. Please use the utilities in CB to check that the tables are consistent and Also report which version of CB,Joomla etc that you are using. It is best if you post this sort of stuff in the help forum for CBJUICE on joomlacode. Others might be able to contribute to a suggested solution.
Moderators: beatnantkrileon
Time to create page: 0.433 seconds
Facebook Twitter Google LinkedIn