Add the ability to import profile info from CSV

Description

Add the ability to import profile info from a CSV file at startup. Should also be able to import official profile image urls from a field in the csv file.

Activity

Show:

Steve Swinsburg October 26, 2011 at 7:14 PM

1.4.x r100191

Hudson CI Server October 26, 2011 at 6:08 PM

Steve Swinsburg October 26, 2011 at 5:47 PM

sakai.properties:

profile2.import=true
profile2.import.csv=/path/to/file.csv

Steve Swinsburg October 26, 2011 at 5:45 PM
Edited

The CSV file may contain any of the following headings, in any order:

eid
nickname
position
department
school
room
web site
work phone
home phone
mobile phone
fax
books
tv
movies
quotes
summary
course
subjects
staff profile
uni profile url
academic profile url
publications
official image url

Some requirements:

The file MUST contain the eid field as that is the username (e.g. jsmith26) of the user for whom to create a profile for.

The users must exist in Sakai first.

Column headings must match EXACTLY the list above. They do not need to be in the same order, or even all present.

Fields must be comma separated and each field surrounded with double quotes. There must be no spaces between fields.

Only users that do not currently have a profile will be imported.

Hudson CI Server October 26, 2011 at 6:35 AM

Integrated in profile2 trunk #511 (See http://builds.sakaiproject.org:8080/job/profile2%20trunk/511/)
https://sakaiproject.atlassian.net/browse/PRFL-684#icft=PRFL-684 add csv parsing and processing into profile data

Fixed

Details

Priority

Fix versions

Components

Assignee

Reporter

Property addition/change required

Yes

Created October 26, 2011 at 2:16 AM
Updated February 4, 2015 at 2:27 PM
Resolved October 26, 2011 at 5:45 PM

Flag notifications