[Building Sakai] Course enrollment information

[Neal Caidin]

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:

>  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:
>
> 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 listsakai-dev at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140916/a3dbefc2/attachment.html