[Building Sakai] Course enrollment information

[Neal Caidin]

Hi Venkat,

Thanks. I would presume you should be using the Sakai APIs. I'm copying 
in the developer list so that they can provide more details.

Cheers,
Neal


> Venkat Ravikanti <mailto:vravikan at yahoo.com>
> September 16, 2014 at 10:05 AM
> Neal,
>
> We are working on a project where we need to bring the information 
> from Sakai LMS and show it on external Portal for user to access.
>
> As you see from my original post we are not able to see the 
> information entered on the Sakai portal in the tables. I may be 
> looking in wrong tables here.
>
> Can you pl. guide me on this.  If you have sometime I can show you 
> what I am doing through Skype.
>
> Thanks,
> Venkat
>
>
>
>
> On Tuesday, September 16, 2014 8:54 AM, Neal Caidin 
> <neal.caidin at apereo.org> wrote:
>
>
> And of course it depends what is needed with the information. Is it 
> curiosity? Solving a specific problem? Writing a new tool?  Access the 
> data outside of Sakai? etc.
>
> -- Neal
>
>
> On Thu, Sep 11, 2014 at 10:26 AM, Brian Baillargeon <bbailla2 at uwo.ca 
> <mailto:bbailla2 at uwo.ca>> wrote:
>
>
>
> Neal Caidin <mailto:neal.caidin at apereo.org>
> September 16, 2014 at 8:53 AM
> And of course it depends what is needed with the information. Is it 
> curiosity? Solving a specific problem? Writing a new tool?  Access the 
> data outside of Sakai? etc.
>
> -- Neal
>
>
>
> Brian Baillargeon <mailto:bbailla2 at uwo.ca>
> September 11, 2014 at 10:26 AM
> I just did a quick search on confluence.sakaiproject.org and found a 
> little documentation that hasn't been modified since 2006, but it 
> might be useful nonetheless:
> https://confluence.sakaiproject.org/display/CM/CM+API+Design+-+Round+1
>
> Anyway, the table that stores roster memberships is CM_MEMBERSHIP_T
>
> mysql> describe cm_membership_t;
> +---------------------+--------------+------+-----+---------+----------------+
> | Field               | Type         | Null | Key | Default | 
> Extra          |
> +---------------------+--------------+------+-----+---------+----------------+
> | MEMBER_ID           | bigint(20)   | NO   | PRI | NULL    | 
> auto_increment |
> | VERSION             | int(11)      | NO   |     | NULL    
> |                |
> | USER_ID             | varchar(255) | NO   | MUL | NULL    
> |                |
> | ROLE                | varchar(255) | NO   |     | NULL    
> |                |
> | MEMBER_CONTAINER_ID | bigint(20)   | YES  | MUL | NULL    
> |                |
> | STATUS              | varchar(255) | YES  |     | NULL    
> |                |
> +---------------------+--------------+------+-----+---------+----------------+
>
> Note: the CM_ tables store information about official rosters, which 
> might not necessarily map to users' current role in the site if a role 
> has been changed. Also, you won't find any unofficial participants in 
> these tables. If you want the union of official and unofficial 
> participants, I think they can be found in sakai_realm_rl_gr, but 
> there might be a more authoritative source.
>
> On 14-09-10 06:46 PM, Venkat Ravikanti wrote:
>
> _______________________________________________
> 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"
> Venkat Ravikanti <mailto:vravikan at yahoo.com>
> September 10, 2014 at 6:46 PM
> Hi,
>
> I am new to Sakai. Need your help on the Sakai Tables.
>
> I am looking to find the mysql tables where the course enrollment 
> information stored.
>
> Here is my scenario:
>
> 1. Created Course Site with couple of courses
> 2. Created Users
> 3. Added the Users to the above created courses as Participants
>
> Now when I am trying to query for the participants information in 
> CM_ENROLLMENT_T or CM_ENROLLMENT_SET_T. No Luck.  These two tables are 
> empty
>
> Can someone help with me following:
>
> 1. Data dictionary for Sakai tables with some notes on which table 
> stands for what
> 2. Which table stores the participants or enrollment information.
>
>
> Thanks for your help.
> Venkat
> _______________________________________________
> 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"

-- 
Neal Caidin
Sakai Community Coordinator
Apereo Foundation
neal.caidin at apereo.org
Skype me! (but let me know in advance for the first interaction) - nealkdin

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140916/8e2e2a42/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: compose-unknown-contact.jpg
Type: image/jpeg
Size: 770 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140916/8e2e2a42/attachment.jpg