[Building Sakai] Question in creating new course site

[Phuc Bui]

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:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090525/0ab19183/attachment.html