Serving 3705 extensions to the community
Categories
Directory Menu
Login or Register
CBJuice 
Version
1-7 beta 2 (last update on Aug 31, 2009)
Rating
Compatibility
Votes
25
Favoured
42
License
GPL
Non-Commercial
Type
Views
41514
Date Added
7 July 2007
Management is done on the basis of username. A basic CSV file with username, first name, last name and email is required for bulk Adds. Any user-defined CB fields can also be set at the Add time. Similarly, an Edit CSV file would have only the username and the field or fields that are being edited.
A password generator has now been added for Add mode.
NOTE: A header describing the fields is obviously required. The header must have the EXACT spelling of the variables names include “cb_” as required. It is strongly suggested that you use the EXPORT/SAVE function to get a sample list of the fields.
Dates must be entered as STRING using the form yyyy-mm-dd (note minuses) to match SQL requirements.
If you have accented characters in the names, it is strongly suggested that you process the CSV files using OPENOFFICE to reflect the use of UTF-8 characters on most Linux installations. You can also use Notepad to save in UTF-8 if necessary. Excel is not kind in that regard.
USERTYPE is now defined as a variable. This has been tested in 1.015 with cb and works with and without JACLPlus. It will manage usertypes that are defined in the standard Joomla tables only. Therefore, it will not manage the JACLplus special subgroups.
This version now supports the management of Juga Groups. Try an export to see what is there. CBJUICE uses a special variable jugagroups to report the membership of a user in one or more groups. If there are two groups, they are joined with a + symbol. If jugagroups is empty for a user, the membership in all groups is removed.
This version now supports an edit run without any CB fields.
THIS ROUTINE HAS BEEN TESTED IN 1.5 with CB 1.2.1
Some bug fixes include the ability to add users with just user name, email and one CB field.
This version is still compatible with Joomla 1.0. However, this is not guaranteed in future releases.
by1221 on October 26, 2009
I just installed this extension and I already love it! I can click one button and the member list is downloaded to my computer in csv format. And it appears to be very easy to upload additional members too!
byin93r on October 7, 2009
I had to download Open Office first before I could get a good csv-file, but after that no problems at all! It saved me a lot of time. Thanks!
byrocknolds on August 17, 2009
I have tried this one and works excellent!
There is one issue I have found, the CB User ID is not retained or at least there is no option to retain the CB User ID during export and import.
After my successful import and export, my kunena forum threads were pointing to different users as result.
There is one issue I have found, the CB User ID is not retained or at least there is no option to retain the CB User ID during export and import.
After my successful import and export, my kunena forum threads were pointing to different users as result.
Owner's reply
You are trying to use the package for use that it was not intended to fulfill. If you are doing a migration of a site, it is much better to move tables with migration tools that link packages and associated tables. That is mysql work. If you are not sure how to do that, try to find a firm to support you. (p.s. I don't= cbjuice is a hobby).
CBJuice does not modify the userid because there is no guarantee that it will be the same if you are moving users between sites via an add. I can consider a user-beware option to userthe userid on an ADD only. It could lead to significant corruption. Put this kind of comment in the help forum and we will see what other users suggest.
bymomentis on July 17, 2009
This extension just saved me (and therefore, my client) a whole bunch of time. I was trying to figure out how I was going to pre-populate their user and CB tables with their existing data. I figured I'd have to write several queries and push data all over to get it to work.
That's when I found CBJuice. It did ALL of the work for me, and did it absolutely perfectly. All I had to do was name my fields in my TXT import file to match the user/CB field names and CBJuice did the rest. Perfectly imported and set up all of my custom CB data!
Not only that, but it allowed me to define a custom email to automatically be sent to each user imported, letting them know exactly what was done. This was perfect, as it allowed me to give the users specific instructions pertaining to my client's wishes.
A very BIG thank you to the developers of CBJuice!!!
That's when I found CBJuice. It did ALL of the work for me, and did it absolutely perfectly. All I had to do was name my fields in my TXT import file to match the user/CB field names and CBJuice did the rest. Perfectly imported and set up all of my custom CB data!
Not only that, but it allowed me to define a custom email to automatically be sent to each user imported, letting them know exactly what was done. This was perfect, as it allowed me to give the users specific instructions pertaining to my client's wishes.
A very BIG thank you to the developers of CBJuice!!!
bywebmunki on April 24, 2009
I have installed and used CBJuice and couldn't be more pleased.
I was migrating users from an old version of a website site to a new one and it was a piece of cake.
I did not have a very large list to import but the time it saved me and the auto notifications to members was awesome.
(I would never use the term "great tool" in any other context but this)
I was migrating users from an old version of a website site to a new one and it was a piece of cake.
I did not have a very large list to import but the time it saved me and the auto notifications to members was awesome.
(I would never use the term "great tool" in any other context but this)
bywintercorn on March 31, 2009
I've just imported over 5000 users into CB for a client site and it all went smoothly. I tried other import tools but this one just works.
byfrankyboy on March 31, 2009
I have been using this component and it has saved me a lot of time.
I do miss some functionality though:
It would be great to be able to edit the Default Email Text. You can do this but every time I do a test I loose my set-up text. I always comes back to the default version.
Also I would love to edit the ACAjoom subscibers too. I don't know if this is possible but now I don't get this newsletter info in the export file. And I have to manually add all the new imported users to have them added to the mailinglist. Could this be done through CBjuice it would be perfect!!
I do miss some functionality though:
It would be great to be able to edit the Default Email Text. You can do this but every time I do a test I loose my set-up text. I always comes back to the default version.
Also I would love to edit the ACAjoom subscibers too. I don't know if this is possible but now I don't get this newsletter info in the export file. And I have to manually add all the new imported users to have them added to the mailinglist. Could this be done through CBjuice it would be perfect!!
byJan.Swanwick on February 8, 2009
For anyone wanting to import and update a membership list of user details into CB this is essential. There isn't much in the way of documentation as it doesn't need any as it's very intuitive and does exactly what it promises.
The level of checking and validation of data as it is loaded (or not if it is wrong) is impressive.
The developer responded very quickly to an install issue I had, and with his help I managed to prove it was an ISP issue, which they could quickly address with the information we supplied.
Many Thanks
Jan
The level of checking and validation of data as it is loaded (or not if it is wrong) is impressive.
The developer responded very quickly to an install issue I had, and with his help I managed to prove it was an ISP issue, which they could quickly address with the information we supplied.
Many Thanks
Jan
byLetty on February 2, 2009
It is a wonderful extension. I used it first on my Joomla site 1.0x, and when I migrated to 1.5.9 I installed the beta3 which worked incredibly well. One of the features I like the most is the ability to send (or not) a message to the user which includes username and password. Therefore it is very useful for resetting passwords, updating user information, and importing or reimporting users
bymisdianto on January 27, 2009
Currently I am looking for a tool to have a full list of the user sign-up at my managing website since I can find it at the standard CB. After googling, I found this tool and it's really help me and meet my expectations...
This is a great tools...
This is a great tools...
bydiorist on November 14, 2008
Even for relatively small imports, this saves a mess o' time. The import was flawless and the auto-notification e-mailer was a pleasantly surprising plus. Highly recommended.
bypaddylatino on November 5, 2008
Hi, great to add new users with no clashes, but it allows me to import users with the same email address, which I think should not be allowed.
While it won't allow me to import a user with the same username, the email address I think is important, as I find myself with users that are on separate lists, and I'd have to trawl through them manually to see if they exist in another list.
While it won't allow me to import a user with the same username, the email address I think is important, as I find myself with users that are on separate lists, and I'd have to trawl through them manually to see if they exist in another list.
bydoncrawley on November 1, 2008
CBJuice works as described and it's easy to use. I just used it to migrate 10,000 users from a ColdFusion site to a new Joomla 1.5.7 site. It was ridiculously easy. Thanks for a wonderful tool!
bywrongjon on August 21, 2008
With a tight deadline building a large community site I needed to import over 4,000 users from an existing (non Joomla) website.
I did get an error with the current build but found a quick fix on CB forum at www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,58/id,71901/#71901 which I passed on to Paul the developer for CBJUICE and he replied promptly and was very helpful.
Give it a go!!! It will save you days and days of work!
Well done Paul
I did get an error with the current build but found a quick fix on CB forum at www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,58/id,71901/#71901 which I passed on to Paul the developer for CBJUICE and he replied promptly and was very helpful.
Give it a go!!! It will save you days and days of work!
Well done Paul
bykavaXtreme on August 14, 2008
I have used this tool to import thousands of users with numerous fields in addition to the core fields. I was very impressed with how easy and solid it was. I expected to encounter bugs of sort with this level of usage, but have found it more stable that similar import tools I have used elsewhere.
I hope the ability to change user accounts' Enabled/Disabled settings via CSV will be added, but really have no complaints whatsoever. Kudos to the developer!
I hope the ability to change user accounts' Enabled/Disabled settings via CSV will be added, but really have no complaints whatsoever. Kudos to the developer!
bydbmaniac on April 26, 2008
I have been using an external newsletter program for one of my websites and that forced my visitors to register twice. Obviously this was a huge inconvenience, and loading 4k+ users manually was going to take forever.
I googled for this type of component and that's how I found CBJuice. Now I got it working perfectly with my Community Builder and Vemod Newsletter.
The only con was that I had to spend 5 more minutes than I would have wanted to figure out the correct order for the csv field values. IOW, no big deal, it works, it's great and i'm happy. Thanx!!
I googled for this type of component and that's how I found CBJuice. Now I got it working perfectly with my Community Builder and Vemod Newsletter.
The only con was that I had to spend 5 more minutes than I would have wanted to figure out the correct order for the csv field values. IOW, no big deal, it works, it's great and i'm happy. Thanx!!
bynzimas on April 11, 2008
Have used CB JUICE in a couple of major projects with hundreds to over 2000 thousand users each. The whole process is straightforward and bug free.
Just had to convert XLS spreadsheets into CSV files, name and set the headers order properly, upload the CSV file and that was all. Immediately my CB and core Joomla user tables had the pertinent data stored.
I can even update the user data in edit mode every time the CSV file is changed (existing entries can be kept and new ones are added).
The latest version doesn't seem to support MySQL 4, but that's not really a show stopper these days. Highly recommended for time saving developers.
Just had to convert XLS spreadsheets into CSV files, name and set the headers order properly, upload the CSV file and that was all. Immediately my CB and core Joomla user tables had the pertinent data stored.
I can even update the user data in edit mode every time the CSV file is changed (existing entries can be kept and new ones are added).
The latest version doesn't seem to support MySQL 4, but that's not really a show stopper these days. Highly recommended for time saving developers.
What can I say. It's great. I have very little database experience so this was a lifesaver. I really didn't want to go into my database and start importing. This made it easy.
TIP: After you set up your fields, download so you can see what the fields look like before uploading. Usertype will be there.
TIP: After you set up your fields, download so you can see what the fields look like before uploading. Usertype will be there.
byselfxplanatory on March 10, 2008
I didn't give it Excellent, just because there really isn't very much documentation. But, its a great tool that I think everyone should have.
It helps when migrating, or just performing actions on a live site that might affect users' information.
What I didn't understand is when I exported the userlist (users.csv), why didn't it export the password hashes with it. The answer: The passwords are stored in the core users list that comes with joomla so it is referenced there. If you need to mess around with the joomla users list, I recommend using the original JUICE, that deals with it.
Otherwise, great utility! Does everything at a drop of a click! Hats off to the core team!
It helps when migrating, or just performing actions on a live site that might affect users' information.
What I didn't understand is when I exported the userlist (users.csv), why didn't it export the password hashes with it. The answer: The passwords are stored in the core users list that comes with joomla so it is referenced there. If you need to mess around with the joomla users list, I recommend using the original JUICE, that deals with it.
Otherwise, great utility! Does everything at a drop of a click! Hats off to the core team!
Owner's reply
I can add the password to the save but it will be hashed. My concern has been that people will try to reload a hashed password. The challenge is that with continual changes to the hash, this could get into really messy things. It is NOT possible to export passwords in a clear format. If you have specific suggestions, use the joomla code forum because I would be interested.
bywebdoc46 on January 22, 2008
I haven't tried the upload part of this (already did that the hard way through MySQL), but was looking for a way to download the whole database. Clicked on the download choice, and it did it immediately, and put it straight into Excel. No having to open the file and import into Excel. We have almost 1000 members and I was impressed by the speed.
Page 1 of 2