[Building Sakai] Course enrollment information

[Steve Swinsburg]

Use the API's to get the data. The cm tables are used by the course
management service and from you original post it doesn't look like you have
a cm provider. So the users aren't going to be in those tables.

If you are wanting the data in an external system there are rest and soap
services to give you what you need and there are even two portlets you can
use to provide a deeper integration.

Cheers
Steve

sent from my mobile
On 17/09/2014 1:45 AM, "Neal Caidin" <neal.caidin at apereo.org> wrote:

> 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 <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> <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>
> wrote:
>
>
>
>     Neal Caidin <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 <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 <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
>
>
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140923/1302a4f4/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/20140923/1302a4f4/attachment.jpg