| @@ -8,9 +8,9 @@ |
| *Open your db to extract the users from.
|
| *Select tab "SQL"
|
| *enter {code}SELECT `login`,`email`,`real_name`,`hash`,`registration_date` FROM `users_users` WHERE 1{/code}
|
| -*Push Export
|
| -*Make sure the output is CSV, "export table titles as first row" is checked, delimiter is "," and check "download" button, no compression. Press start to export the list, and save.
|
| -*Enter the saved file and remove the lines of users "root", "guest" and "admin", and check if there is any line with "NULL" in its "real_name" field. Replace this with "", so the field is empty on import.
|
| +*Push Export (bottom of page, not the tab) |
| +*Make sure the output is CSV, empty the "replace NULL with" field, "export table titles as first row" is checked, delimiter is "," and check "download" button, no compression. Press start to export the list, and save. |
| +*Enter the saved file and remove the lines of users "root", "guest" and "admin", and check if there is any line with "NULL" in its "real_name" field. Replace this with the info from "login", so the field is filled with that on import. |
| !!!Importing the exported userlist
|
| *Update "users/BitUser.php" from CVS. (in BW2.0.2.)
|
| *Goto http://example.com/users/admin/users_import.php
|
|
|
| @@ -18,11 +18,11 @@ |
| *Choose the bottom item "do not mail users".
|
| *Press import.
|
|
|
| -!!Remember: Users will belong to group "Registered" only, more rights for the users will need to be added by hand!
|
| +!!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 by CVS update of user/))BitUser((.php:
|
| +!!Problems solved (for V2.0.2.) by CVS update of user/))BitUser((.php: |
| *When importing error: Warning: filesize() [function.filesize]: stat failed for /path/storage/users/4/4/images/2/users.csv in /path/liberty/liberty_lib.php on line 589
|
| *Per import line error: Could not store file: users.csv.
|
|
|
|
|