[Building Sakai] Question in creating new course site
Zhen Qian
zqian at umich.edu
Sun May 24 22:00:09 PDT 2009
The userId in enrollment and membership usually mean the enterprise id
(EID). Like in Michigan, we have 8 digit number for university members. The
user EID is different from the id field in sakai_user table. The user_id
field has a UUID number and is internally to Sakai.
As for adding a list of use to the site, you can either use the "Add
Participant" choice inside Site Info tool to add multiple users, or you can
use the Web Services approach. For example, you can use
addMemberToSiteWithRoles from SakaiScript.jws.
/**
* Add a user to a site with a given role
*
* @param sessionid the id of a valid session
* @param siteid the id of the site to add the user to
* @param eid the login username (ie jsmith26) of the user you want to
add to the site
* @param roleid the id of the role to to give the user in the site
* @return success or exception message
*
* TODO: fix for if the role doesn't exist in the site, it is still
returning success - SAK-15334
*/
public String addMemberToSiteWithRole(String sessionid, String siteid,
String eid, String roleid) throws AxisFault
Please let me know if the methods works for you.
Thanks,
- Zhen
On Mon, 25 May 2009 10:37:20 +0700, "Phuc Bui" <phucbui2006 at yahoo.com.vn>
wrote:
> Dear,
>
> What does the userID in enrollment, membership mean ? It does not refer
to
> sakai_user ?
>
> By the way, how can I add a list of user in system to a available site ?
>
> Earlier, I have successfully created a list of users from a excel file as
> Sakai users. Now, how can I add them to sites ?
>
>
>
> Thanks,
>
> Phuc Bui
>
>
>
> From: Phuc Bui [mailto:phucbui2006 at yahoo.com.vn]
> Sent: Sunday, May 24, 2009 11:45 PM
> To: 'Zhen Qian'
> Cc: 'sakai-dev at collab.sakaiproject.org'; 'Steve Swinsburg'
> Subject: RE: [Building Sakai] Question in creating new course site
>
>
>
> Dear,
>
> Which condition make my course's information display when I create a new
> course site like this
>
> http://i693.photobucket.com/albums/vv296/phucbm/course_site_create_2.jpg
>
> I have create some course set, canonical course, course offering, let
them
> to be enrolled. But I don't see these information when I create a course
> site.
>
> What does the table cm_cross_listing_t mean ?
>
>
>
> Thanks,
>
> Phuc Bui
>
>
>
>
>
> From: Zhen Qian [mailto:zqian at umich.edu]
> Sent: Thursday, May 21, 2009 11:35 PM
> To: Phuc Bui
> Cc: sakai-dev at collab.sakaiproject.org; 'Steve Swinsburg'
> Subject: Re: [Building Sakai] Question in creating new course site
>
>
>
> Phuc Bui:
>
>
>
> As I said, it all depends on your institution's implementation for
getting
> the right information into db or using the external provider approach.
>
>
>
> But here is the result of using the sample data loader from OOTB Sakai.
You
> can see the mapping between Course_Set, Course_Offering, and Section.
>
>
>
> mysql> select * from CM_COURSE_SET_OFFERING_ASSOC_T;
>
> +-----------------+------------+
>
> | COURSE_OFFERING | COURSE_SET |
>
> +-----------------+------------+
>
> | 4 | 1 |
>
> | 5 | 1 |
>
> | 6 | 1 |
>
> | 7 | 1 |
>
> | 8 | 1 |
>
> | 9 | 1 |
>
> | 10 | 1 |
>
> | 11 | 1 |
>
> +-----------------+------------+
>
> 8 rows in set (0.01 sec)
>
>
>
>
>
> mysql> select * from CM_ENROLLMENT_SET_T;
>
>
+-------------------+---------+------------------+--------------------+-----
>
-------+--------------+-----------------------+------------------------+----
>
---------------------------------------------------+----------+-------------
> ----+-----------------+
>
> | ENROLLMENT_SET_ID | VERSION | LAST_MODIFIED_BY | LAST_MODIFIED_DATE |
> CREATED_BY | CREATED_DATE | ENTERPRISE_ID | TITLE
> |
> DESCRIPTION | CATEGORY |
> DEFAULT_CREDITS | COURSE_OFFERING |
>
>
+-------------------+---------+------------------+--------------------+-----
>
-------+--------------+-----------------------+------------------------+----
>
---------------------------------------------------+----------+-------------
> ----+-----------------+
>
> | 1 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL101 Winter 2009es | SMPL101 Enrollment
Set
> |
> Sample course offering #1, Winter 2009 Enrollment Set | lecture | 3
> | 4 |
>
> | 2 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL202 Winter 2009es | SMPL202 Enrollment
Set
> |
> Sample course offering #2, Winter 2009 Enrollment Set | lecture | 3
> | 5 |
>
> | 3 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL101 Spring 2009es | SMPL101 Enrollment
Set
> |
> Sample course offering #1, Spring 2009 Enrollment Set | lecture | 3
> | 6 |
>
> | 4 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL202 Spring 2009es | SMPL202 Enrollment
Set
> |
> Sample course offering #2, Spring 2009 Enrollment Set | lecture | 3
> | 7 |
>
> | 5 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL101 Summer 2009es | SMPL101 Enrollment
Set
> |
> Sample course offering #1, Summer 2009 Enrollment Set | lecture | 3
> | 8 |
>
> | 6 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL202 Summer 2009es | SMPL202 Enrollment
Set
> |
> Sample course offering #2, Summer 2009 Enrollment Set | lecture | 3
> | 9 |
>
> | 7 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL101 Fall 2009es | SMPL101 Enrollment
Set
> |
> Sample course offering #1, Fall 2009 Enrollment Set | lecture | 3
> | 10 |
>
> | 8 | 0 | NULL | NULL |
> admin | 2009-05-14 | SMPL202 Fall 2009es | SMPL202 Enrollment
Set
> |
> Sample course offering #2, Fall 2009 Enrollment Set | lecture | 3
> | 11 |
>
>
+-------------------+---------+------------------+--------------------+-----
>
-------+--------------+-----------------------+------------------------+----
>
---------------------------------------------------+----------+-------------
> ----+-----------------+
>
> 8 rows in set (0.02 sec)
>
>
>
> It is always helpful to review the "Sakai course management model "
> diagram:
>
http://bugs.sakaiproject.org/confluence/display/~markjnorton/Sakai+Course+Ma
> nagement+Model Thanks, Mark!
>
>
>
> - Zhen
>
> On May 21, 2009, at 12:11 PM, Phuc Bui wrote:
>
More information about the sakai-dev
mailing list