Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Add functionality for importing users from an Excel spreadsheet or CSV file

Description

Add functionality for importing users from an Excel spreadsheet or CSV file. This would be available in the Site Info tool and would add the users to Sakai if necessary before adding them to the site. A sakai property should allow you to turn the functionality off.

Attachments

3

Activity

David Horwitz March 28, 2013 at 7:59 AM

Changing target version to 2.10 as 2.9 is now released

Steve Swinsburg November 16, 2011 at 2:58 PM

Attached 2.8 patch.

Steve Swinsburg November 16, 2011 at 2:52 PM
Edited

Note the trunk patch is missing the opencsv dependency in the base pom as it was added as part of another patch.

Manually add it:
<dependency>
<groupId>net.sf.opencsv</groupId>
<artifactId>opencsv</artifactId>
<version>2.3</version>
<scope>compile</scope>
</dependency>

Adrian Fish November 14, 2011 at 1:53 AM

Awesome. Chris, you should test this out when you get a chance and post a comment in here. If it's ok then we can start talking about getting it included in 2.10 by default.

Steve Swinsburg November 13, 2011 at 6:02 PM

I attach a revised patch for trunk that allows CSV import as well. It also allow you to specify the role as well (both XLS and CSV).

If the role is not specified it comes from sakai.properties (user.upload.default.role=access/maintain/etc)

It also removes the role selection step since that is now catered for.

The rest then hooks into the standard 'Add Participant' workflow, i.e. sending email etc.

Details

Priority

Components

Assignee

Reporter

Created March 25, 2011 at 5:50 AM
Updated June 30, 2014 at 3:20 PM