[Deploying Sakai] Sakai Course Management

[Steve Swinsburg]

Your best bet would be to write a Quartz job that will talk to your SIS, get
the data and load it into Sakai. You can schedule these similar to a cron
job.

It will be far easier to use the Sakai API's as there are many
interconnected tables and things will get out of sync quickly if you do it
manually. You can inject the dependencies via Spring, see here for a simple
example:
https://source.sakaiproject.org/svn//msub/anu.edu.au/alliance/2.6.x/quartz/
https://source.sakaiproject.org/svn//msub/anu.edu.au/alliance/2.6.x/quartz/scheduler-jobs/src/java/org/sakaiproject/msub/alliance/jobs/ArchiveSites.java

You can actually checkout that whole package and build it (adjust the parent
pom though). This isn't a SIS integration but you can see how it works. This
is also a neat way to keep your quartz scripts separate from the actual
Sakai quartz bundle (where you can also put them).

This is how I've done integrations with SIS's in the past, it's very
straight forward.

cheers,
Steve

On Fri, Nov 20, 2009 at 8:00 AM, Paul Ross <Paul.Ross at bexleyschools.org>wrote:

>  Two questions for the brains trust.
>
> **
>
> *Q1*. I have reviewed the course management documentation and everything
> points to using the API to provide for an enterprise integration with a SIS.
>  I do not have the staff to leverage the API, however we can compose
> scripts to integrate Sakai with our SIS.  Can someone please point us in the
> right direction to find documents detailing the database schema and the
> course, user import/update process?  We have done this previously with
> another system and are aware that changes will be needed for new DB
> releases, but this is something we can do.  We have used the inbuilt
> interface so far however need to move to an automated process for efficiency
> and to minimize complexity for teachers.
>
>
>
> Assistance with this issue will enable us to achieve a secondary
> objective, that is to create a community document detailing how Sakai can be
> installed and maintained in a K-12 environment.  So far we have documented
> our experience installing Sakai successfully in a Windows 2008 MySQL 64 bit
> environment.  Our next challenge is to integrate Sakai with PowerSchool and
> document a K-12 configuration.
>
>
>
> *Q2*. We have used the internal interface provided to add a few courses
> and students however the name of the course displayed makes no sense if you
> are using institutional codes (course code, subject, section codes, term
> ID).  Is there an option or database field to use a common course name?
>
>
>
> Any assistance would be appreciated.
>
>
>
> Thanks
>
>
>
> Paul Ross
>
>
> -----------------------------------------------------------------------------------------------------
>
> Paul Ross (Technology Director - Bexley City Schools)
>
> Email: Paul.Ross at bexleyschools.org Phone: 614-231-7611 ext 5313
>
>
> -----------------------------------------------------------------------------------------------------
>
>
>
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to
> production-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20091120/46dce9b6/attachment.html