I would love the ability to import a list of users from an Excel file in the 'add mulitiple users' page (admin/user/userplus)....is this possible?

And it would also be great to have the option to notify all new users of their new account.

Comments

robert castelo’s picture

robert castelo commented

You could use the User Import module to do exactly that:

http://drupal.org/node/31940

marcp’s picture

marcp commented

For the import feature, please take a look at the User Import module that Robert suggests above.

For the option to notify users of their new email accounts -- that has been "the next thing on my list" for a while, and it's already on the feature request list here.

Thanks for the feedback!

Marc

robert castelo’s picture

robert castelo commented

As well as auto generating username and password, User Import module also has option to send a welcome email to each new user.

mdowsett’s picture

mdowsett commented

but isn't that version of import users for cvs? Will it work with 4.7? I am always confused about CVS and if their modules just work with Drupal (I have no experience with cvs)...

marcp’s picture

marcp commented

That's a good question for Robert -- I haven't looked at the CVS log, but it probably just needs a tag to show up in the 4.7 listing...

mdowsett’s picture

mdowsett commented

and if I try the CVS version on my 4.7 site, do I risk screwing up my entire site? Or would it be a matter of just deleting the module and I'd be back to where I started...?

robert castelo’s picture

robert castelo commented

CVS version of User Import module is for Drupal 4.7, and is completely stable.

One feature missing which was in the 4.6 version is ability to upload csv file via the browser, once I add that back in I'll release it as an official 4.7 release.

Currently you can upload the csv file to the user_import directory using FTP, and user import will auto-detect it - which actually works better for large imports - MTV UK recently imported 350,000 users with it, so it's quite robust.

mdowsett’s picture

mdowsett commented
Status: Active » Closed (fixed)

this seems to work great. many thanks

mdowsett’s picture

mdowsett commented
Status: Closed (fixed) » Active

i just got around to actually trying user_import in 4.7...and I get these errors:

user warning: Table 'bladetape.user_import' doesn't exist query: INSERT INTO user_import (iid, filename, oldfilename, filepath, started, pointer, total, processed, valid, first_line, contact, username_space, send_email, field_match, roles, setting) VALUES (NULL, 'sample.csv', 'sample.csv', 'sites/default/modules/user_import/sample.csv', '1163224581', '0', '0', '0', '0', '0', '1', '1', '0', 'a:6:{i:0;a:3:{s:11:\"field_match\";s:1:\"0\";s:8:\"username\";s:1:\"1\";s:10:\"abbreviate\";i:0;}i:1;a:3:{s:11:\"field_match\";s:1:\"0\";s:8:\"username\";s:1:\"2\";s:10:\"abbreviate\";i:0;}i:2;a:3:{s:11:\"field_match\";s:8:\"password\";s:8:\"username\";s:1:\"0\";s:10:\"abbreviate\";i:0;}i:3;a:3:{s:11:\"field_match\" in /home/httpd/vhosts/bladetape.ca/httpdocs/includes/database.mysql.inc on line 120.
user warning: Table 'bladetape.user_import' doesn't exist query: SELECT * FROM user_import WHERE iid = '7840' LIMIT 1 in /home/httpd/vhosts/bladetape.ca/httpdocs/includes/database.mysql.inc on line 120.
user warning: Table 'bladetape.user_import_errors' doesn't exist query: INSERT INTO user_import_errors (iid, data, error) VALUES ('7840', 'a:2:{i:9;s:3:\"Fax\";s:5:\"email\";s:5:\"Email\";}', 'invalid email') in /home/httpd/vhosts/bladetape.ca/httpdocs/includes/database.mysql.inc on line 120.
user warning: Table 'bladetape.user_import' doesn't exist query: UPDATE user_import SET filename = 'sample.csv', oldfilename = 'sample.csv', filepath = 'sites/default/modules/user_import/sample.csv', pointer = '237', processed = '4', valid= '3', first_line = '0', contact = '1', username_space = '1', send_email = '0', field_match = 'a:6:{i:0;a:3:{s:11:\"field_match\";s:1:\"0\";s:8:\"username\";s:1:\"1\";s:10:\"abbreviate\";i:0;}i:1;a:3:{s:11:\"field_match\";s:1:\"0\";s:8:\"username\";s:1:\"2\";s:10:\"abbreviate\";i:0;}i:2;a:3:{s:11:\"field_match\";s:8:\"password\";s:8:\"username\";s:1:\"0\";s:10:\"abbreviate\";i:0;}i:3;a:3:{s:11:\"field_match\";s:1:\"0\";s:8:\"username\";s:1:\"0\";s:10:\"abbreviate\&q in /home/httpd/vhosts/bladetape.ca/httpdocs/includes/database.mysql.inc on line 120.
user warning: Table 'bladetape.user_import' doesn't exist query: SELECT * FROM user_import WHERE setting != 'template' ORDER BY started DESC in /home/httpd/vhosts/bladetape.ca/httpdocs/includes/database.mysql.inc on line 120.

marcp’s picture

marcp commented
Status: Active » Closed (fixed)

I'm not supporting 4.7 any more. If this is an issue in 5.x or above, please reopen and set the Version.