History of Migrating Users Between Bitweaver Sites
Version 5 | Current version | |
---|---|---|
Use case: Bitweaversite1 has a lot of users in its db. The site is being migrated to a new one, without all the previous data. The new site has to have all the old users though, so they can still login using the IDs they had before. Use case 2: Bitweaversite1 userbase is being merged with Bitweaversite2, and all users need to be imported into one userlist, but no content has to be added. Steps to go through:
When re-importing the same list, if you get an error for every imported user: The username "xxx" is already in use,The email address "xxx@example.com" has already been registered, check the "Overwrite existing users" box. Problems solved by CVS update of user/BitUser.php:
Example import data:
Help from the import page:You can batch import users by uploading a CSV (comma-separated values) file. The file needs to have the column names in the first line. The column titles need to match with fields in 'users_users' table. Login, password and email are required fields, however if you leave the password field empty a new password will be auto generated. You can also import a MD5 hash as password, like from phpBB2, it need to be put in the 'hash' column. In such case it override other options and it's assumed the user or at least admin knows the password. Currently you can't import custom fields and if a non-existent field is specified, it's ignored. | Use CasesUse case 1: Bitweaversite1 has a lot of users in its db. The site is being migrated to a new one, without all the previous data. The new site has to have all the old users though, so they can still login using the IDs they had before.Use case 2: Bitweaversite1 userbase is being merged with Bitweaversite2, and all users need to be imported into one userlist, but no content has to be added. Steps to go throughExport the user list from phpMyAdmin.
Importing the exported userlist
Remember: Users will belong to group "Registered" only, more rights for the users will need to be added by hand! Also other options as preferred language etc. will not be imported.When re-importing the same list, if you get an error for every imported user: The username "xxx" is already in use,The email address "xxx@example.com" has already been registered, check the "Overwrite existing users" box. Problems solved (for V2.0.2.) by CVS update of user/BitUser.php:
Example import data:
Help from the import page:You can batch import users by uploading a CSV (comma-separated values) file. The file needs to have the column names in the first line. The column titles need to match with fields in 'users_users' table. Login, password and email are required fields, however if you leave the password field empty a new password will be auto generated. You can also import a MD5 hash as password, like from phpBB2, it need to be put in the 'hash' column. In such case it override other options and it's assumed the user or at least admin knows the password. Currently you can't import custom fields and if a non-existent field is specified, it's ignored. |