Finally a final release!
Note: only the English language file is now present. In the coming days/weeks additional language files will be made available.
• Users can be mass deleted, blocked, unblocked and activated. A re-activation string can be set and their group assignments can be changed; all with only a few mouse clicks.
• All user information can be set or updated, including registration date, activation string and params.
• The exported user list can be downloaded as CSV text directly.
• userport can be configured by non-super users too: all options can be set and checked in the 4-step workflow.
• An export can retrieve all user information from all users. Basic filtering can be applied to restrict which users need exporting.
• A 'test mode' allows you to test the import file and to verify the notification emails safely: without touching your database, and without disrupting your userbase.
• userport will not time-out: it has been tested to successfully import more than 20000 users using 1 import file.
• userport automatically uses default values for those fields you don't supply.
• All options and their consequences are clearly explained on the page where you configure them.
Note: Joomla 1.5 users must use the stable version v2.2
Changes for v3.0:
Only minor fixes since the last beta.
- Corrected access check for non-super-users.
- Clear the BOM if present.
- Do not present the next batch if no more data is present.
- Do not parse the last empty row.
A quick search led me here, and within 10 minutes I had everything setup and all current users updated to the new site.
Such an essential component that absolutely works flawlessly. Very good documentation within the component itself made it easy to just look, see what was required, provide the data and be done with it.
Hats off to the programmer!
This specifically relates to exporting a user database from 1.0, including passwords, and importing them, passwords intact, into a 1.5 installation, a task which is actually rather hard without this component.
Migrating users from Joomla 1.0 to 1.5.
This initially was a difficult task, but using a few steps I was able to complete it using an open-source extension. Even with this extension there are a number of steps you need to take that I was not aware of, and which took me a while to get through. However, I have heard that many people find imporing users a very difficult task from 1.0 and importing them into 1.5 without a full migration, this definitely worked for me.
Please be aware that this only imports the following fields:
It does not import
If you need those fields imported then you will probably have to do a full migration, as I was unable to find any way to export and import all of these fields easily. Usertype can be chosen when you import the data, as you will see.
1) Log into phpMyAdmin on your 1.0 site
2) Select the database of your 1.0 site
3) Click the Export tab
4) At the left, select *only* the jos_users section to export. If your prefix is different, I am not sure if this method will work when you import the database, but it should.
5) Select CSV for MS Excel
6) Check the "Put fields names in the first row" option at the right
7) Check the Save As item at the bottom, compression is none, then click Go, and save the file.
8) You have now exported your user database. Open this csv file in Excel or some other spreadsheet program.
9) Delete all columns except "name", "username", "email", and "password". Save this file.
10) Open this file again in a text editor. You should see multiple rows with your field items separated only by a comma.
11) Now its time to install the importer. Go here: http://extensions.joomla.org/extensions/5430/details
And navigate your way to download the 1.7 or later version of Userport. Make sure it's at least 1.7; the older versions cause errors.
12) Install this on your 1.5 site. Navigate to this component in your backend.
13) Set your parameters for "Given passwords are already properly encoded" to YES.
Select User type as "registered" or whatever type of user you are importing. Everything else is up to you, but this should be the only two you need to set.
IMPORTANT: If you have a lot of users in multiple user groups, such as 200 authors, 300 admins, and 1000 registred users, you will probably have to import these groups one at a time, otherwise you will have to go back and change their status to the correct one. For 5 super admins, for example, this is not a problem, but for a wide variety of users, the process would be more complex. You would filter out of your csv FIRST all users who are authors, save the file with only the authors, THEN delete all the fields like in step 9, and THEN import these users as Authors into Userport. You'd need to do this for each group.
14) Click import, then check the No Initial Text radio box, then click continue.
15) On the next page, copy a single line of a user from your open CSV file (which is open in your text editor) you are able to log into the old 1.0 site with, such as an admin account. Paste this into the CSV field, then click add.
16) If all goes well, you should see no errors, and then you can navigate to your current sites front end and try logging in as the user you just imported.
17) Now that you know it works, you can import them all at once this way by pasting your entire csv file in and adding all the users. If your csv file has a "" in it for a user, it might throw an error, but this doesn’t break the process.
18) Now go into your user database and alter any admin or superadmin or special usergroups that people were assigned to. If you have a wide variety of people assigned to usergroups, this method may require additional editing of users after they have been imported.
It took me quite a while to figure this out; this is the simplest way to do this. I went through a lot of paint o figure this out, as I could never get the user fields to export properly from the old site. This method is relatively painless.
I played around with it first on a trial installation of Joomla 1.5.17 that I set up specifically for this purpose.
It took me a little while to get the passwords to copy across properly, but after checking out the support section I located the solution on page 2 of the support site.
Fantastic bit of code this, which will allow me to start a fresh installation of Joomla without losing my subscribers.
Thanks to the developer!
WARNREG_MAIL should have been replaced by the appropriate language string. In English, this is "Please enter a valid e-mail address." This just means that the email you supplied has an invalid syntax.
Are you quoting the fields? You should not. See the text above for some valid examples. If you still have issues, it is better to use the support forum.
Thank you for the kind scoring!
You basically import the data in from a .csv file with NAME, LOGIN_NAME, EMAIL, PASSWORD .
Note: PASSWORD(s) can be auto-generated for you if you want.
Then you can review the imported data in a window.
Then you can add, update or add+update from that list into your user database.
Make sure you configure the parameters first, before running.
Some things to consider is the group assignment for those users being added (will they be Registered, Author, etc).
You can also opt to send and email for each new user added ... and these emails can contain some parameters, which were a wonderful to discover as they were not in to documentation that I read, but were on the support forum under enhancements.
Example of text you can include in the new user email template:
Then when it mails the new users added, they can see their USERNAME and PASSWORD (they generated in the .csv)
Great componant ... and when importing, existing emails are not overwritten (configurable, of course) ... and the errors/warning messages are very descriptive and useful.