[#5434] Alternative to CBJuice

Hi,

I'm having problems getting CBJuice to import a database, populate my CB fields AND send a username/password on import...
There appears to be no support either

Can anyone suggest another way to achieve this or is CBJuice the only way to import a csv into CB?

There is no alternative other than direct database inserts which will send nothing.

OK, would it be possible to ship users into Joomla and have their password/username sent out(probably a Joomla forum question) and then use Edit Mode in CBJuice to populate the additional CB fields?

Since you're using generated passwords you maybe able to import them as unconfirmed and suppress all emails. Then in CB > User Management confirm them and it should generate and store a new password then send their Welcome email, which should have a working password. I would try it with a test user first, but based off the code that's what should happen.

Hi Kyle,

I have played around with this for ages and cannot get CB to send passwords once a user is added!!!

I have managed to import the database as unconfirmed although I get error reports from CBJuice…

CB Version =2.0
CBJ2_HEADER_VARIABLES are
Array ( [0] => name [1] => username [2] => email [3] => firstname [4] => lastname [5] => cb_initial [6] => cb_title [7] => cb_address [8] => cb_address2 [9] => cb_city [10] => cb_state [11] => cb_postalcode [12] => cb_phonenumber [13] => cb_mobile [14] => cb_nomail [15] => cb_companyinfo [16] => cb_position [17] => cb_workphone [18] => cb_faxnumber [19] => cb_businessemail [20] => cb_website [21] => cb_memberid [22] => cb_membershiptype [23] => cb_paymentmethod [24] => cb_2013 [25] => cb_2012 [26] => cb_2011 [27] => cb_2010 [28] => cb_2009 [29] => cb_2008 [30] => cb_2007 [31] => cb_2006 [32] => cb_2005 [33] => cb_2004 [34] => cb_2003 [35] => cb_allyears [36] => cb_lastmodified [37] => cb_2014 [38] => cb_2016 [39] => cb_2015 [40] => cb_comment [41] => cb_partnersname )
Error in register store: DB function reports no errors.
tonymoran Tony MORAN Email: tony@flashpoint.net.au Password: oo4Y9wP5Y7 could not be added
Error in register store: DB function reports no errors.
guestguest Guest GUEST Email: newmember@tommyhafeyclub.com.au Password: yHrExo5wPU could not be added
Error in register store: DB function reports no errors.
newmember New MEMBER Email: t.moran@flashpoint.net.au Password: erkXZiMP3i could not be added
Count of Records Imported=3
Count of Records Used=0


In Joomla User Manager the imported users are Activated but not Enabled
In CB User Manager the imported users are Approved, awaiting to be Confirmed, but not Enabled

When I confirm an imported user the welcome message is sent with their username, however the password is missing…
Username: newmember
Password: [PASSWORD]

In CB User Manager there is a password visible in the password field, but there’s no way of knowing what it is! (it’s not the password CBJuice error report says could not be added… I tried)

I have tried logging in with the password not added in the CBJuice error report and it doesn’t work, however if I request a new password from CB login Forgot Login, the new password that is sent does allow access.

If I manually add a new user in CB Admin the confirmation email sends the username and password without a problem!

Can you please suggest where I’m going wrong?

I'm guessing it's just how CB Juice is importing them then since normal CB registration and user creation is working fine. We'll eventually have import/export tools built in, but that won't be until a much later release. Below is the updated API usage for registering a user, but I'm unsure if CB Juice is using it or older usage.

www.joomlapolis.com/forum/153-professional-member-support/228495-solved-cb-version-api-cb-version-205#258806

Specifically activateUser function is what sends the pending/welcome emails.

To force User Management to regenerate the password and send the email you need to have "Generate Registration Password" set to "Yes" within CB > Configuration > Registration. Next the user must be Approved or it will not send. Now approve them and it should generate a new password then send the Welcome email.