Info

Category: uncategorized
Licence: GNU General Public License (GPL) version 2
Updated: 60 days ago
Downloaded: 846

Releases

Latest: 0.2

Previous releases:
More projects by Jaakko Naakka:

0

Recommendations

Summary:

Upload users from a csv file

Full description:

Upload Users

(Edit your project's description!)

Release notes:

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

  • Better error control
  • Preview of uploaded users before actually creating the accounts
  • Possibility to have a list of tags as a value

This is a POWERFUL contribution... Done without asking for penny too! Thanks for sharing your work...

Dave 255 days ago

Your are amazing. Remember that!

kirb 251 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

  • Total number of accounts: 0
  • Number of errors:   

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