Force Community Builder user to reset password

Hello,

We have an alumni website running Joomla! 3.4.8 and Community Builder 2.0.12. We are going to import/create a lot of users in our database (people who graduated last year).

What we plan to do is first to import/create them in the Joomla! users MySQL table, then in the user_usergroup_map table and finally in the comprofiler and comprofiler_field_values tables.

Then we would like to advise each of these newly imported/created users by e-mail, using AcyMailing, that their account has been created.

To prevent hacking we would like to give to each user a different password. That can be done easily with incrementation in Excel.

First when we import/create the users in the database how the system will manage the passwords. How will it encrypt them as they are in plain text?

Second we would like to force the newly imported/created users to change their password on their first connection. Can Community Builder handle that? With AcyMailing we can redirect them to the Community Builder modify my profile page and with the Auto-Login plugin they will be allready logged-in.

Third as we do not have all the information regarding these users we fill in some fields with a "À préciser" value (one of our dropdown lists pre-existent field values) which in french means "To be determined". The right field value would be personally set by a user. As we were testing the AcyMailing newsletter coupled with the Auto-Login plugin we noticed that when we click on the hyperlink we get to the Community Builder modify my profile page but the fields previously filled in with the "À préciser" value are blank. We tested with others random values (but still in our dropdown lists pre-existent field values) and the feilds are not blank: they registered the random values we set. Strange, isn't it.

If you can help to find some of these problems we will be glad.

Regards

Do not create users directly in the database. If you need to import users then use something like CB Juice which will properly create them and encrypt their passwords.

You can generate passwords for them so they're all completely random. The pending email can be used to send them their password if you've approval or confirmation enabled otherwise you can send it in the welcome email.

You can let CB notify them of their account creation instead of doing it through AcyMailing so they'll get the notification and their unique password in 1 go with no further action required (they can freely change their password in profile edit). CB has no password force reset functionality at this time.

For your field values most likely your issue is using stored UTF8 characters with a database collation that doesn't support UTF8. Within your database ensure all tables are properly set to UTF8 collation. Alternative is to use the below usage for example.

Value: FIELD_VALUE_1
Label: À préciser

Basically using a generic key for the value with the label being whatever you like. Ideally you'd also make the label a language string as follows.

Value: FIELD_VALUE_1
Label: FIELD_LABEL_1

'FIELD_LABEL_1' => 'À préciser',

Will CB Juice work with CB 2.0?

On the add-on page it says it's only compatible with up to CB 1.7.

I'm running CB 2.0.12 with Joomla 3.4.8.

Yes, CB Juice works with CB 2.x. Please see the below forums for CB Juice support, usage, and latest releases.

www.joomlapolis.com/forum/226-cb-juice