by Jaakko Naakka
First uploaded 321 days ago
0
Recommendations
Summary:
Upload users from a csv file
Full description:
Upload Users
(Edit your project's description!)
A simple plugin for admins to create user accounts by uploading a csv file including users' information.
The first line in the csv file must define what fields the rest of the file includes. The only required fields are username, name and email. If password is not included in the file, a random password will be generated. The fields can be in any order you want. Account details can be sent to users by email, if you wish.
All other fields will be added as metadata. This makes it possible to define, for instance, location or interests in the file if needed. If yout field delimiter is something else than a comma you can have a comma separated list of tags as a value.
The plugin supports both UTF8 and ISO-8859-1 encoded files and a few different delimiters like ',' and ';', for instance.
An example of a valid and simple csv file:
username; name; email; interests
naakka; Jaakko Naakka; jaakko.naakka@gmail.com; Elgg, php, jQuery
The package includes Finnish and English translations.
Changes from version 0.1
This is a POWERFUL contribution... Done without asking for penny too! Thanks for sharing your work...
Dave 255 days ago
@Jaakko Naakka
Can you please send me your PayPal Link ? so that I may send you some donation $$
Thank you for this very useful PlugIn..
;-)
DhrupDeScoop 246 days ago
Ok, so I got the file to work, but now when I preview the user accounts then click submit, all I get is a blank white screen. It doesn't create them or anything, just a blank screen. Anyone else have this problem?? I have over 1400 members, so I've broken it up into 4 separate files so as to not overwhelm my server.
Liz 239 days ago
Never mind, I apparently still had too many to a file.
Liz 239 days ago
Liz, I'm glad you got it working. For some reason the process of creating user accounts is quite heavy for the database, but it also depends on the amount of other information you have in the file. We are not using this plugin extensively yet but I if we run into similar problems I'll try to boost up the performance in possible future releases.
Jaakko Naakka 238 days ago
This would be really be a very useful plugin.
I could upload a csv file. It got properly picked up and showed me the user lists.
But when I clicked "Create User Accounts", it displayed
The php log file shows the following:
Undefined property: stdClass::$language in E:\...\elgg1.5\engine\lib\languages.php on line 87
Any clue on this ?
Naba
nabakumar 237 days ago
Hi Jaakko
I had problems with uploading a csv, I kept getting errors, but I fixed them :-)
So for anyone else getting a CSV error try this:
1. Download notepad++
2. Open your file and make sure the field names are all in lower case
3. Press Format - Convert to UTF 8 without BOM
4. Then ensure the file is in UNIX format by: Format -> Convert to Unix format
5. Save the file and upload and that should do it.
This works for me, might not for others, good luck x-D
David Pike 207 days ago
Hey Jaakko,
Version 2.0 no longer allows me to create accounts with the email address as a username. Was this intentional? is this new to elgg v1.6?
Thanks,
Kirby
kirb 193 days ago
Hi Kirby,
I've just been off my computer for a month and I didn't even know about versin 1.6 until now :) I'll be back to work pretty soon and I'll look into this later on. If I remember correctly there are no changes regarding the username format between versions 0.1 and 0.2, so I guess this is something new in Elgg 1.6. But I'm not sure until I can try the new version myself.
I'm almost looking forward to getting back to work ;)
Jaakko Naakka 193 days ago
is possible to import and set a default language? i did try to add the field language and in the rows put en or es (for spanish) and didn't work
melvyn 165 days ago
@melvyn I think this should be possible but I've never tried it myself. That's something that would be useful for our Finnish users as well so I think I will try this later on.
There's also a small bug in sending emails and I'll try to fix this soon.
Jaakko Naakka 165 days ago
ohh thanks, if you can tell me how is the process for import a default language can be nice, well i saw when you select No send emails, always send a email to all the users uploaded
melvyn 164 days ago
Wow, I was thinking of such plug-in. Thank you very much!!!
Shouvik Mukherjee 164 days ago
Hi folks, and Jaakko, many thanks for a truly useful plugin. This is going to save lots of work for many administrators!
My question is how might a person import an original "date joined" and update the Elgg field with the real date rather than having it default to the date the script was run?
And for that matter, are there any other "system" fields that may benefit from having the original values captured?
- Tom
Tom Foley 141 days ago
Does this plugin work with 1.6.1?
Can I make so users that get registered also are put in to/joined to groups?
Tamir 79 days ago
@Jaakko, I second this:
Hi folks, and Jaakko, many thanks for a truly useful plugin. This is going to save lots of work for many administrators!
My question is how might a person import an original "date joined" and update the Elgg field with the real date rather than having it default to the date the script was run?
And for that matter, are there any other "system" fields that may benefit from having the original values captured?
- Tom
...Have you tested your plugin on 1.7 alpha? Is it going to be ready for 1.7? It is a critical plugin, for many of us. Thanks!
Yakiv 78 days ago
please help
how to create a CSV file
or put a demo here.
i tried with ms-excel, ms-word, notepad...
i am unable to make a proper file
as the system places an error, "wrong csv file"
saifee 16 days ago
Hi saifee,
I think your problem has something to do with the line endings. I know I should fix the plugin but at the moment I'm busy with other projects and this is not a priority. Using notepad should work just fine, check out the example in the release notes in the start of this page.
Jaakko Naakka 15 days ago

Ukr Programmer
Profile
Friends
Friends of
Pages
Plugins
Thank you for this!
Ukr Programmer 256 days ago