[Building Sakai] Question in creating new course site
Phuc Bui
phucbui2006 at yahoo.com.vn
Sun May 24 09:45:04 PDT 2009
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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090524/cb3442d4/attachment.html
More information about the sakai-dev
mailing list