[Building Sakai] Question in creating new course site
Zhen Qian
zqian at umich.edu
Sun May 24 21:52:06 PDT 2009
Phuc Bui,
Sakai uses GroupProvider interface for site group and role integration.
Please refer to Course Management Integration
(http://bugs.sakaiproject.org/confluence/display/SAKDEV/Course+Management+Integration)
for more details on CM integration strategy and deployment.
Also you might want to check the prepareCourseAndSectionMap code inside
SiteAction.java file. This is the function that produces the following
course list.
Thanks,
- Zhen
On Sun, 24 May 2009 23:45:04 +0700, "Phuc Bui" <phucbui2006 at yahoo.com.vn>
wrote:
> 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:
>
>
>
>
>
> Dear,
>
> Here is what I want
>
>
http://i693.photobucket.com/albums/vv296/phucbm/creating_new_couse_site_1.jp
> g
>
> When I select a subject, it gives the corresponding Course offering and
> sections.
>
> So how do I make that data ? Which table contains those data ?
>
>
>
> Thanks,
>
> Phuc Bui
>
>
>
> From: Zhen Qian [mailto:zqian at umich.edu]
> Sent: Thursday, May 21, 2009 9:52 PM
> To: Phuc Bui
> Cc: sakai-dev at collab.sakaiproject.org
> Subject: Re: [Building Sakai] Question in creating new course site
>
>
>
> Phuc Bui:
>
>
>
> You can get a sense of the dropdown list by setting -Dsakai.demo=true in
> your JAVA_OPTS.
>
>
>
> The course select page is based on the
> "CourseSet"->"CourseOffering"->"Section" hierarchy set in
> CourseManagementService. Your CMS implementation would populate the
content
> for the cascading drop-down menus.
>
>
>
> If the user cannot find any after looking at the drop-down menus, he then
> can click on "Still cannot find your course/section? " link.
>
>
>
> The "subject", "course", "section" labels are customizable. Please check
> the
> api and impl of SectionFieldProvider and SectionField.
>
>
>
> Thanks,
>
>
>
> - Zhen
>
> On May 21, 2009, at 10:34 AM, Phuc Bui wrote:
>
>
>
>
>
>
> Dear,
>
> I mean this stage (view the image)
>
>
http://i693.photobucket.com/albums/vv296/phucbm/creating_new_couse_site.jpg
>
>
>
> Thanks,
>
> Phuc Bui
>
> From: Phuc Bui [mailto:phucbui2006 at yahoo.com.vn]
> Sent: Thursday, May 21, 2009 3:32 PM
> To: 'sakai-dev at collab.sakaiproject.org'
> Subject: Question in creating new course site
>
>
>
> Dear all,
>
> When I create a course site, I wonder how to select from some available
> Subject, course, section instead of selecting 'Still cannot find your
> course/section'
>
> Does Sakai support tools to manage that or we have to insert data
directly
> into database ?
>
>
>
> Thanks,
> Phuc Bui
>
> _______________________________________________
>
> 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"
>
More information about the sakai-dev
mailing list