[Using Sakai] Using SAKAI Course sites

[Mark J. Norton]

Igor:

Sakora was created (by Oracle and Unicon) to be an integration to 
Oracle/PeopleSoft student information using the IMS Learning Information 
System (LIS) specification.  If you are not using an Oracle product to 
manage your student data, then you are probably wandering off course.

The Sakai Course Management service provides an interface to integrate 
access to student data, usually from an external source (such as 
PeopleSoft or Banner).  It uses Sakai database tables to set up the kind 
of relationships that it expects in that data (as well as some 
caching).  Some Sakai schools have developed code to pull student and 
enrollment data directly from a database and expose it through the Sakai 
Course Management service API, but I'll warn you that it takes a deep 
understanding of how Sakai works internally and how Course Management in 
particular works.

Your questions are largely about the database scheme used by Course 
Management.  If you were writing a custom implementation of the CM 
service, this might be appropriate.  If not, then you should either be 
using the CM API as provided or configuring Sakora appropriately.  
Generally, the Sakai technical community discourages people from 
tinkering with the database directly, in part because they could change 
in the future.  If you truly want to understand how it works, then 
you're going to have dig into the CM code.  If you want help with 
Sakora, your best bet would be to contact Unicon (I've cc'ed John Lewis 
on this reply).

- Mark Norton (co-designer of the CM service)

On 7/30/2013 9:18 AM, igor Novopashenny wrote:
>
> Hi,
>
> I'll try to ask them, but I'm also only SAKAI User and want to use the 
> course site.
>
> But to do it, it is necessary to fill all these tables. Or do you know 
> some other solution?
>
> The other question. If I already made the course site in SAKAI for an 
> academic Term, how can I use the same course site for the other 
> academic term, next year for an example?
>
> Regards Igor
>
> *Von:*sakai-user-bounces at collab.sakaiproject.org 
> [mailto:sakai-user-bounces at collab.sakaiproject.org] *Im Auftrag von 
> *Neal Caidin
> *Gesendet:* Dienstag, 30. Juli 2013 13:51
> *An:* igor Novopashenny
> *Cc:* sakai-user at collab.sakaiproject.org
> *Betreff:* Re: [Using Sakai] Using SAKAI Course sites
>
> Hi Igor,
>
> You are more likely to get an answer to questions of a technical 
> nature on the Production list (system admins, dbas, etc) , 
> production at collab.sakaiproject.org 
> <mailto:production at collab.sakaiproject.org> , or the Developers list, 
> sakai-dev at collab.sakaiproject.org 
> <mailto:sakai-dev at collab.sakaiproject.org> .  The Developers list is a 
> bit more active, but you could try both.
>
> This list is primarily focused on using Sakai, not developing or 
> debugging it.
>
> Cheers,
>
> Neal Caidin
>
> Sakai CLE Community Coordinator
>
> Apereo Foundation
>
> Skype: nealkdin
>
> On Jul 30, 2013, at 3:27 AM, igor Novopashenny 
> <Igor at escience.uni-bremen.de <mailto:Igor at escience.uni-bremen.de>> wrote:
>
>
>
>     Hi,
>
>     we are trying to understand how the tables for the course
>     Management are organized in SAKAI.
>
>     Unfortunately we cannot find any documentation for the tables with
>     the Prefix CM_.
>
>     Analysing the documentation of the SAKORA tools and some other 
>     documents we have understood a lot, but there are still some open
>     questions.
>
>     May be somebody can help us.
>
>     1.Table CM_MEETING_T. It looks like, that this table is not used
>     un the current versions. In any case it stays empty in our
>     installation. From the other side we don't understand where the
>     information about the sections (such as*Meeting Details, Section
>     Size etc.)*is saved. If I add some sections the information is
>     saved, but I don't know where.
>
>     2.CM_OFFICIAL_INSTRUCTORS_T What for is this table? It is not used
>     in SAKORA, so I don't understand what the Official Instructor means.
>
>     3.CM_COURSE_SET_CANON_ASSOC_T- I understand the sense of this
>     table, but it looks like that it is not really used. If I make the
>     inputs in the tables manually and leave this table empty,
>     everything works without it.
>
>     4.CM_CROSS_LISTING_T- What is it?
>
>     5.CM_ENROLLMENT_SET_T- As I understand, this table is used do
>     manage different categories of the studies (lecture, practice,
>     laboratory, etc.). For a course offering different categories of
>     studies are defined here. After it the students are connected to
>     this categories of the studies via the table CM_ENROLLMENT_T. Is
>     it correct?
>
>     Kind regards
>
>     Igor
>
>     _______________________________________________
>     sakai-user mailing list
>     sakai-user at collab.sakaiproject.org
>     <mailto:sakai-user at collab.sakaiproject.org>
>     http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
>     TO UNSUBSCRIBE: send email
>     tosakai-user-unsubscribe at collab.sakaiproject.org
>     <mailto:sakai-user-unsubscribe at collab.sakaiproject.org>with a
>     subject of "unsubscribe"
>
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20130730/7c2b4ca0/attachment-0001.html