[Building Sakai] Add Users
Daniel McCallum
dmccallum at unicon.net
Thu Jun 24 18:46:02 PDT 2010
"Simple SIS" services won't satisfy SAK-18450, but can be used for
periodic bulk user account upload from a CSV file. Just send people.csv
[1] and ignore all the rest. Keep in mind, though, that the handler will
treat that file as a snapshot of all known users, so this isn't an
appropriate solution for ad hoc individual user adds.
Also won't help if the goal is to add users directly to sites.
- Dan
1 - http://bit.ly/ds70Gz
Steve Swinsburg wrote:
> There is also an outstanding feature request to add CSV input to the
> Admin 'Users' tool, to allow bulk creation of users. IMO this is a
> vital piece of functionality.
> http://jira.sakaiproject.org/browse/SAK-18450
>
> Could your code be used for this, Matthew?
>
> cheers,
> Steve
>
> On 25/06/2010, at 4:33 AM, Matthew Jones wrote:
>
>> A a quick followup to Steve's comment, I'd written a Rhino script to
>> perform the add user process a few months ago.
>> (https://source.sakaiproject.org/svn/msub/umich.edu/ctools/builds/trunk/tools/sakaiscript/rhino/)
>>
>> However at the request of Aaron at the conference, I also wrote up a
>> quick client side interface which performs all of this in the browser.
>> [1] It users jquery and the jquery csv plugin [2] to parse value from
>> a text box. Because POST isn't XSS restricted (only reading the
>> result) you can use this page to add to your own server, or just save
>> the source and get 2 external scripts to be customized to do a few
>> other things possible with EB (create sites, add users to sites, etc).
>>
>> It *possibly* could also do an ajax upload and use that file, but that
>> would require a little server side processing and local temporary
>> storage, whereas this is all in client-side javascript.
>>
>> Anyway, as you can see there are a few ways of doing this.
>>
>> [1] http://ctnightly.dmc.dc.umich.edu/staticcontent/csv/
>> [2] http://plugins.jquery.com/project/csv
>>
>> -Matthew
>>
>>
>> On Tue, Jun 22, 2010 at 7:37 PM, Steve Swinsburg
>> <steve.swinsburg at gmail.com <mailto:steve.swinsburg at gmail.com>> wrote:
>>
>> Hi,
>>
>> There are two simple ways to get an enterprise integration going,
>> the web services, and Quartz.
>>
>> 1. If you have a reasonable number of users (under 1000) then you
>> can use the web services and some
>> Perl/PHP/Java/whatever-language-you-like to connect to Sakai and
>> add users, create sites and add users to sites etc. If you have
>> more than 1000 users, go to 2, since the webservices add some
>> overhead, otherwise, read on.
>>
>> I have a number of extremely simple and easy to follow Perl
>> scripts that do things like create users etc:
>> https://source.sakaiproject.org/contrib//swinsburg/webservice-scripts/
>>
>> It is trivial to adjust these to create sites and add users to
>> sites (see create-users.pl <http://create-users.pl/> for an
>> example), but if you want to do that, get in touch:
>>
>> 2. If you have more users, Sakai has a Quartz job scheduler which
>> is essentially a cron scheduler and runs a Java class, so uses the
>> API's directly and is extremely fast. I believe most institutions
>> that have a level of integration with a student information system
>> or similar, use Quartz.
>> http://confluence.sakaiproject.org/display/DOC/Quartz+in+Sakai
>>
>> I also have a Quartz script I can give you which will synchronise
>> users in sites, adding and removing as required, based on some
>> external system which holds this information.
>>
>>
>> cheers,
>> Steve
>>
>>
>> p.s. I'm not mentioning the CourseManagement API here.
>>
>>
>> On 23/06/2010, at 2:01 AM, Dave Churchley wrote:
>>
>> > Hi Cheryl and Peter
>> >
>> > A tool that adds a new user to a specific site is exactly the
>> kind of thing we're after at the moment. I'd appreciate it if you
>> could share the code, please.
>> >
>> > Thanks
>> > Dave
>> >
>> >
>> >> -----Original Message-----
>> >> From: sakai-dev-bounces at collab.sakaiproject.org
>> <mailto:sakai-dev-bounces at collab.sakaiproject.org>
>> [mailto:sakai-dev- <mailto:sakai-dev->
>> >> bounces at collab.sakaiproject.org
>> <mailto:bounces at collab.sakaiproject.org>] On Behalf Of Johns, Cheryl
>> >> Sent: 22 June 2010 14:59
>> >> To: Longfei Yu; sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> >> Subject: Re: [Building Sakai] Add Users
>> >>
>> >> We can share the code, no problem, but this does not just add
>> them to
>> >> the Sakai instance, it adds them to a single site.
>> >>
>> >> If that works for you, I can have our system programmer be in
>> contact to
>> >> share the code. Please respond to Peter who is cc'd here.
>> >>
>> >> -----Original Message-----
>> >> From: sakai-dev-bounces at collab.sakaiproject.org
>> <mailto:sakai-dev-bounces at collab.sakaiproject.org>
>> [mailto:sakai-dev- <mailto:sakai-dev->
>> >> bounces at collab.sakaiproject.org
>> <mailto:bounces at collab.sakaiproject.org>] On Behalf Of Longfei Yu
>> >> Sent: Tuesday, June 22, 2010 9:39 AM
>> >> To: sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> >> Subject: Re: [Building Sakai] Add Users
>> >>
>> >> Great, I also need one to upload user information from .csv file to
>> >> Sakai. I just added 200 users manually, sounds so stupid.
>> >>
>> >> How can I get it?
>> >>
>> >> Thanks.
>> >>
>> >> Longfei
>> >>
>> >> Quoting "Johns, Cheryl" <cheryl.johns at yale.edu
>> <mailto:cheryl.johns at yale.edu>>:
>> >>
>> >>> Good morning Mohan,
>> >>>
>> >>> We have developed a tool that allows you to populate a
>> specific site
>> >>> using a spreadsheet of IDs/roles. Would this work for you?
>> >>>
>> >>> -----Original Message-----
>> >>> From: sakai-dev-bounces at collab.sakaiproject.org
>> <mailto:sakai-dev-bounces at collab.sakaiproject.org>
>> >>> [mailto:sakai-dev-bounces at collab.sakaiproject.org
>> <mailto:sakai-dev-bounces at collab.sakaiproject.org>] On Behalf Of
>> >>> mohan at samudrasoftware.com <mailto:mohan at samudrasoftware.com>
>> >>> Sent: Tuesday, June 22, 2010 8:40 AM
>> >>> To: sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> >>> Subject: [Building Sakai] Add Users
>> >>>
>> >>> Hi,
>> >>>
>> >>> Is there any way to load users from csv or spread sheet to sakai
>> >> database?
>> >>>
>> >>>
>> >>> Thanks
>> >>> Mohan
>> >>>
>> >>> _______________________________________________
>> >>> sakai-dev mailing list
>> >>> sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >>>
>> >>> TO UNSUBSCRIBE: send email to
>> >>> sakai-dev-unsubscribe at collab.sakaiproject.org
>> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>> subject of
>> >>> "unsubscribe"
>> >>> _______________________________________________
>> >>> sakai-dev mailing list
>> >>> sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >>>
>> >>> TO UNSUBSCRIBE: send email to
>> >>> sakai-dev-unsubscribe at collab.sakaiproject.org
>> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>> subject of
>> >>> "unsubscribe"
>> >>>
>> >>
>> >>
>> >> _______________________________________________
>> >> sakai-dev mailing list
>> >> sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >>
>> >> TO UNSUBSCRIBE: send email to sakai-dev-
>> >> unsubscribe at collab.sakaiproject.org
>> <mailto:unsubscribe at collab.sakaiproject.org> with a subject of
>> "unsubscribe"
>> >> _______________________________________________
>> >> sakai-dev mailing list
>> >> sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >>
>> >> TO UNSUBSCRIBE: send email to sakai-dev-
>> >> unsubscribe at collab.sakaiproject.org
>> <mailto:unsubscribe at collab.sakaiproject.org> with a subject of
>> "unsubscribe"
>> > _______________________________________________
>> > sakai-dev mailing list
>> > sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >
>> > TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org
>> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>> subject of "unsubscribe"
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> <mailto:sakai-dev at collab.sakaiproject.org>
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org
>> <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>> subject of "unsubscribe"
>>
>>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
More information about the sakai-dev
mailing list