[Deploying Sakai] Automatic association of members with relevant site
Ishtiaq Ahmad
organic.ishtiaq at gmail.com
Tue Sep 29 02:50:37 PDT 2009
Hi,
I have populated the table CM_COURSE_OFFERING_ASSOC_T using function
CourseManagementAdministration.*addCourseOfferingToCourseSet*(cs,co); and
now course and section dropdown has values.
*I am facing another problem....*
*Objective: *Automatic association of members with course site
*Work Done:* I have populated the following tables.
CM_MEMBER_CONTAINER_T
CM_ENROLLMENT_SET_T
CM_ENROLLMENT_T
CM_OFFICIAL_INSTRUCTORS_T
Please see in attached files.
CM_MEMBER_CONTAINER_T --> MEMBER_CONTAINER_ID (28) and ENROLLMENT_SET
(41)
CM_ENROLLMENT_SET_T --> ENROLLMENT_SET_ID (41)
CM_ENROLLMENT_T --> ENROLLMENT_SET (41) two member exists
against this enrollment set
CM_OFFICIAL_INSTRUCTORS_T --> ENROLLMENT_SET_ID (41) one instructor exist
*tell me is there any other table which needs to be populated for automatic
association of members with course site...?*
thanks..
On Mon, Sep 28, 2009 at 2:15 PM, Ishtiaq Ahmad <organic.ishtiaq at gmail.com>wrote:
> Thanks Zhen Qian,
>
> The table CM_COURSE_OFFERING_ASSOC_T was empty...
> I populated this table from database and dropdown are filled now....
> Can you please tell me....which function of CM API will be used to populate
> this table....?
>
>
> thanks a lot....
>
>
> On Fri, Sep 25, 2009 at 6:47 PM, Zhen Qian <zqian at umich.edu> wrote:
>
>> Ishtiaq:
>>
>> The cmlevels are determined by this function inside SiteAction.java file:
>>
>> private List<String> getCMLevelLabels() {
>> List<String> rv = new Vector<String>();
>> Set courseSets = cms.getCourseSets();
>>
>>
>> if (courseSets != null)
>> {
>> // CourseSet, CourseOffering and Section are three levels in
>> CourseManagementService
>> rv.add(rb.getString("cm.level.courseSet"));
>> rv.add(rb.getString("cm.level.course"));
>> rv.add(rb.getString("cm.level.section"));
>> }
>> return rv;
>> }
>>
>> It is using the default setting of CMS,
>> CourseSet->CourseOffering->Section. But this is just the lables for the
>> lookup. You will need to populate your db or do the corresponding SIS
>> integration for providing these values.
>>
>> For example, with the default Hibernate CM implementation, you would see
>> the CourseSet, CourseOffering, and Section definition in the
>> CM_MEMBER_CONTAINER_T.
>>
>> mysql> select MEMBER_CONTAINER_ID,CLASS_DISCR,ENTERPRISE_ID,TITLE,
>> DESCRIPTION, CANONICAL_COURSE, ACADEMIC_SESSION, CATEGORY,
>> PARENT_COURSE_SET, COURSE_OFFERING,ENROLLMENT_SET, PARENT_SECTION from
>> CM_MEMBER_CONTAINER_T;
>>
>> +---------------------+--------------------------------------------------------------+----------------------------------+----------------------+----------------------------------------+------------------+------------------+----------+-------------------+-----------------+----------------+----------------+
>> | MEMBER_CONTAINER_ID | CLASS_DISCR
>> | ENTERPRISE_ID | TITLE |
>> DESCRIPTION | CANONICAL_COURSE | ACADEMIC_SESSION
>> | CATEGORY | PARENT_COURSE_SET | COURSE_OFFERING | ENROLLMENT_SET |
>> PARENT_SECTION |
>>
>> +---------------------+--------------------------------------------------------------+----------------------------------+----------------------+----------------------------------------+------------------+------------------+----------+-------------------+-----------------+----------------+----------------+
>> | 1 |
>> org.sakaiproject.coursemanagement.impl.CourseSetCmImpl | SMPL
>> | Sample Department | We study wet things in the
>> Sample Dept | NULL | NULL | DEPT |
>> NULL | NULL | NULL | NULL |
>> | 2 |
>> org.sakaiproject.coursemanagement.impl.CanonicalCourseCmImpl | SMPL101
>> | Sample 101 | A survey of samples
>> | NULL | NULL | NULL | NULL
>> | NULL | NULL | NULL |
>> | 3 |
>> org.sakaiproject.coursemanagement.impl.CanonicalCourseCmImpl | SMPL202
>> | Sample 202 | An in depth study of samples
>> | NULL | NULL | NULL | NULL |
>> NULL | NULL | NULL |
>> | 4 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL101
>> Winter 2009 | SMPL101 | Sample course offering #1,
>> Winter 2009 | 2 | 1 | NULL |
>> NULL | NULL | NULL | NULL |
>> | 5 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL202
>> Winter 2009 | SMPL202 | Sample course offering #2,
>> Winter 2009 | 3 | 1 | NULL |
>> NULL | NULL | NULL | NULL |
>> | 6 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL101
>> Spring 2009 | SMPL101 | Sample course offering #1,
>> Spring 2009 | 2 | 2 | NULL |
>> NULL | NULL | NULL | NULL |
>> | 7 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL202
>> Spring 2009 | SMPL202 | Sample course offering #2,
>> Spring 2009 | 3 | 2 | NULL |
>> NULL | NULL | NULL | NULL |
>> | 8 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL101
>> Summer 2009 | SMPL101 | Sample course offering #1,
>> Summer 2009 | 2 | 3 | NULL |
>> NULL | NULL | NULL | NULL |
>> | 9 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL202
>> Summer 2009 | SMPL202 | Sample course offering #2,
>> Summer 2009 | 3 | 3 | NULL |
>> NULL | NULL | NULL | NULL |
>> | 10 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL101 Fall
>> 2009 | SMPL101 | Sample course offering #1, Fall
>> 2009 | 2 | 4 | NULL | NULL
>> | NULL | NULL | NULL |
>> | 11 |
>> org.sakaiproject.coursemanagement.impl.CourseOfferingCmImpl | SMPL202 Fall
>> 2009 | SMPL202 | Sample course offering #2, Fall
>> 2009 | 3 | 4 | NULL | NULL
>> | NULL | NULL | NULL |
>> | 12 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL101
>> Winter 2009 | SMPL101 Winter 2009 | SMPL101 Winter 2009
>> Lecture | NULL | NULL | 01.lct |
>> NULL | 4 | 1 | NULL |
>> | 13 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL202
>> Winter 2009 | SMPL202 Winter 2009 | SMPL202 Winter 2009
>> Lecture | NULL | NULL | 01.lct |
>> NULL | 5 | 2 | NULL |
>> | 14 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL101 Winter 2009 | Discussion 1 SMPL101 | Discussion 1 SMPL101 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 4 | NULL | NULL |
>> | 15 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL101 Winter 2009 | Discussion 2 SMPL101 | Discussion 2 SMPL101 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 4 | NULL | NULL |
>> | 16 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL101 Winter 2009 | Discussion 3 SMPL101 | Discussion 3 SMPL101 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 4 | NULL | NULL |
>> | 17 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL101 Winter 2009 | Discussion 4 SMPL101 | Discussion 4 SMPL101 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 4 | NULL | NULL |
>> | 18 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL101 Winter 2009 | Discussion 5 SMPL101 | Discussion 5 SMPL101 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 4 | NULL | NULL |
>> | 19 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL101 Winter 2009 | Discussion 6 SMPL101 | Discussion 6 SMPL101 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 4 | NULL | NULL |
>> | 20 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL202 Winter 2009 | Discussion 1 SMPL202 | Discussion 1 SMPL202 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 5 | NULL | NULL |
>> | 21 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL202 Winter 2009 | Discussion 2 SMPL202 | Discussion 2 SMPL202 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 5 | NULL | NULL |
>> | 22 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL202 Winter 2009 | Discussion 3 SMPL202 | Discussion 3 SMPL202 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 5 | NULL | NULL |
>> | 23 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL202 Winter 2009 | Discussion 4 SMPL202 | Discussion 4 SMPL202 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 5 | NULL | NULL |
>> | 24 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL202 Winter 2009 | Discussion 5 SMPL202 | Discussion 5 SMPL202 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 5 | NULL | NULL |
>> | 25 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL202 Winter 2009 | Discussion 6 SMPL202 | Discussion 6 SMPL202 Winter
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 5 | NULL | NULL |
>> | 26 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL101
>> Spring 2009 | SMPL101 Spring 2009 | SMPL101 Spring 2009
>> Lecture | NULL | NULL | 01.lct |
>> NULL | 6 | 3 | NULL |
>> | 27 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL202
>> Spring 2009 | SMPL202 Spring 2009 | SMPL202 Spring 2009
>> Lecture | NULL | NULL | 01.lct |
>> NULL | 7 | 4 | NULL |
>> | 28 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL101 Spring 2009 | Discussion 1 SMPL101 | Discussion 1 SMPL101 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 6 | NULL | NULL |
>> | 29 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL101 Spring 2009 | Discussion 2 SMPL101 | Discussion 2 SMPL101 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 6 | NULL | NULL |
>> | 30 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL101 Spring 2009 | Discussion 3 SMPL101 | Discussion 3 SMPL101 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 6 | NULL | NULL |
>> | 31 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL101 Spring 2009 | Discussion 4 SMPL101 | Discussion 4 SMPL101 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 6 | NULL | NULL |
>> | 32 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL101 Spring 2009 | Discussion 5 SMPL101 | Discussion 5 SMPL101 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 6 | NULL | NULL |
>> | 33 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL101 Spring 2009 | Discussion 6 SMPL101 | Discussion 6 SMPL101 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 6 | NULL | NULL |
>> | 34 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL202 Spring 2009 | Discussion 1 SMPL202 | Discussion 1 SMPL202 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 7 | NULL | NULL |
>> | 35 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL202 Spring 2009 | Discussion 2 SMPL202 | Discussion 2 SMPL202 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 7 | NULL | NULL |
>> | 36 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL202 Spring 2009 | Discussion 3 SMPL202 | Discussion 3 SMPL202 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 7 | NULL | NULL |
>> | 37 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL202 Spring 2009 | Discussion 4 SMPL202 | Discussion 4 SMPL202 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 7 | NULL | NULL |
>> | 38 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL202 Spring 2009 | Discussion 5 SMPL202 | Discussion 5 SMPL202 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 7 | NULL | NULL |
>> | 39 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL202 Spring 2009 | Discussion 6 SMPL202 | Discussion 6 SMPL202 Spring
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 7 | NULL | NULL |
>> | 40 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL101
>> Summer 2009 | SMPL101 Summer 2009 | SMPL101 Summer 2009
>> Lecture | NULL | NULL | 01.lct |
>> NULL | 8 | 5 | NULL |
>> | 41 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL202
>> Summer 2009 | SMPL202 Summer 2009 | SMPL202 Summer 2009
>> Lecture | NULL | NULL | 01.lct |
>> NULL | 9 | 6 | NULL |
>> | 42 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL101 Summer 2009 | Discussion 1 SMPL101 | Discussion 1 SMPL101 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 8 | NULL | NULL |
>> | 43 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL101 Summer 2009 | Discussion 2 SMPL101 | Discussion 2 SMPL101 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 8 | NULL | NULL |
>> | 44 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL101 Summer 2009 | Discussion 3 SMPL101 | Discussion 3 SMPL101 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 8 | NULL | NULL |
>> | 45 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL101 Summer 2009 | Discussion 4 SMPL101 | Discussion 4 SMPL101 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 8 | NULL | NULL |
>> | 46 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL101 Summer 2009 | Discussion 5 SMPL101 | Discussion 5 SMPL101 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 8 | NULL | NULL |
>> | 47 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL101 Summer 2009 | Discussion 6 SMPL101 | Discussion 6 SMPL101 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 8 | NULL | NULL |
>> | 48 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL202 Summer 2009 | Discussion 1 SMPL202 | Discussion 1 SMPL202 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 9 | NULL | NULL |
>> | 49 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL202 Summer 2009 | Discussion 2 SMPL202 | Discussion 2 SMPL202 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 9 | NULL | NULL |
>> | 50 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL202 Summer 2009 | Discussion 3 SMPL202 | Discussion 3 SMPL202 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 9 | NULL | NULL |
>> | 51 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL202 Summer 2009 | Discussion 4 SMPL202 | Discussion 4 SMPL202 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 9 | NULL | NULL |
>> | 52 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL202 Summer 2009 | Discussion 5 SMPL202 | Discussion 5 SMPL202 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 9 | NULL | NULL |
>> | 53 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL202 Summer 2009 | Discussion 6 SMPL202 | Discussion 6 SMPL202 Summer
>> 2009 | NULL | NULL | 03.dsc |
>> NULL | 9 | NULL | NULL |
>> | 54 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL101 Fall
>> 2009 | SMPL101 Fall 2009 | SMPL101 Fall 2009 Lecture
>> | NULL | NULL | 01.lct | NULL
>> | 10 | 7 | NULL |
>> | 55 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | SMPL202 Fall
>> 2009 | SMPL202 Fall 2009 | SMPL202 Fall 2009 Lecture
>> | NULL | NULL | 01.lct | NULL
>> | 11 | 8 | NULL |
>> | 56 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL101 Fall 2009 | Discussion 1 SMPL101 | Discussion 1 SMPL101 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 10 | NULL | NULL |
>> | 57 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL101 Fall 2009 | Discussion 2 SMPL101 | Discussion 2 SMPL101 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 10 | NULL | NULL |
>> | 58 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL101 Fall 2009 | Discussion 3 SMPL101 | Discussion 3 SMPL101 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 10 | NULL | NULL |
>> | 59 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL101 Fall 2009 | Discussion 4 SMPL101 | Discussion 4 SMPL101 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 10 | NULL | NULL |
>> | 60 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL101 Fall 2009 | Discussion 5 SMPL101 | Discussion 5 SMPL101 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 10 | NULL | NULL |
>> | 61 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL101 Fall 2009 | Discussion 6 SMPL101 | Discussion 6 SMPL101 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 10 | NULL | NULL |
>> | 62 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 1
>> SMPL202 Fall 2009 | Discussion 1 SMPL202 | Discussion 1 SMPL202 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 11 | NULL | NULL |
>> | 63 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 2
>> SMPL202 Fall 2009 | Discussion 2 SMPL202 | Discussion 2 SMPL202 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 11 | NULL | NULL |
>> | 64 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 3
>> SMPL202 Fall 2009 | Discussion 3 SMPL202 | Discussion 3 SMPL202 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 11 | NULL | NULL |
>> | 65 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 4
>> SMPL202 Fall 2009 | Discussion 4 SMPL202 | Discussion 4 SMPL202 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 11 | NULL | NULL |
>> | 66 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 5
>> SMPL202 Fall 2009 | Discussion 5 SMPL202 | Discussion 5 SMPL202 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 11 | NULL | NULL |
>> | 67 |
>> org.sakaiproject.coursemanagement.impl.SectionCmImpl | Discussion 6
>> SMPL202 Fall 2009 | Discussion 6 SMPL202 | Discussion 6 SMPL202 Fall 2009
>> | NULL | NULL | 03.dsc | NULL
>> | 11 | NULL | NULL |
>>
>> +---------------------+--------------------------------------------------------------+----------------------------------+----------------------+----------------------------------------+------------------+------------------+----------+-------------------+-----------------+----------------+----------------+
>> 67 rows in set (0.01 sec)
>>
>> The relationship of CourseOffering to CourseSet is defined inside
>> CM_COURSE_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)
>>
>> Please check whether you have those tables populated correctly...
>>
>> Thanks,
>> - Zhen
>>
>> On Sep 25, 2009, at 3:56 AM, Ishtiaq Ahmad wrote:
>>
>> Thanks for your reply,
>>
>> Please see the highlighted portion of the code.... I think *cmLevels*object is null. please guide me on this point...
>> what is missing here which this code is looking for to populate these
>> objects...
>>
>>
>> //******************************************************************************************
>> case 53: {
>> /*
>> * build context for chef_site-findCourse.vm
>> */
>>
>> AcademicSession t = (AcademicSession) state
>> .getAttribute(STATE_TERM_SELECTED);
>>
>> List cmLevels = (List) state.getAttribute(STATE_CM_LEVELS),
>> selections = (List) state
>> .getAttribute(STATE_CM_LEVEL_SELECTIONS);
>>
>> if (cmLevels == null)
>> {
>> cmLevels = getCMLevelLabels();
>> }
>>
>> SectionObject selectedSect = (SectionObject) state
>> .getAttribute(STATE_CM_SELECTED_SECTION);
>> List<SectionObject> requestedSections = (List<SectionObject>)
>> state
>> .getAttribute(STATE_CM_REQUESTED_SECTIONS);
>>
>> if (courseManagementIsImplemented() && cms != null) {
>> context.put("cmsAvailable", new Boolean(true));
>> }
>>
>> if (cms == null || !courseManagementIsImplemented()
>> || cmLevels == null || cmLevels.size() < 1) {
>> // TODO: redirect to manual entry: case #37
>> }
>>
>>
>> //******************************************************************************************
>>
>> Regards,
>> Ishtiaq Ahmad
>>
>> On Thu, Sep 17, 2009 at 11:59 PM, Lydia Li <lydial at stanford.edu> wrote:
>>
>>> Glad that you were able to retrieve the Subject list.
>>>
>>> There's no special configuration for the other 2 drop downs. If you
>>> populated your CM tables correctly, those pull downs should not be empty.
>>> I'd suggest you check the cm tables that you populated, and trace the code
>>> to see where the problem is.
>>>
>>> The code to populate those pulldowns are in :
>>> site-mange/site-manage-tool/tool/src/java/org/sakaiproject/site/tool/SiteAction.java
>>> (This file is very very big!)
>>>
>>> You can start by look in buildContextForTemplate() , in case 53 . (I
>>> can't tell you the exact line numbers since we've done a lot of local
>>> changes in this file.)
>>>
>>> thanks,
>>> Lydia
>>>
>>>
>>>
>>> Ishtiaq Ahmad wrote:
>>>
>>>> Hi,
>>>>
>>>> yes it is working....
>>>> I was giving
>>>> site-manage.cms.subject.category=Department
>>>>
>>>> instead of
>>>>
>>>> site-manage.cms.subject.category=DEPARTMENT.
>>>>
>>>>
>>>> thanks....
>>>>
>>>> Now is there any configuration for other two drop downs.... "Course" and
>>>> "Section".... because they are empty now...But Subject has values.
>>>>
>>>> Thanks for solution.
>>>>
>>>> Ishtiaq Ahmad
>>>>
>>>> On Thu, Sep 17, 2009 at 1:14 AM, Lydia Li <lydial at stanford.edu <mailto:
>>>> lydial at stanford.edu>> wrote:
>>>>
>>>> Hi,
>>>> Not sure if this will fix your problem but did you have these set
>>>> up in your sakai.properties, especially the last one:
>>>>
>>>>
>>>> #coursemanagement demo defaults
>>>> site-manage.courseManagementSystemImplemented=true
>>>> site-manage.cms.subject.label=Department
>>>> site-manage.cms.subject.category=DEPT
>>>>
>>>> thanks,
>>>> Lydia
>>>>
>>>>
>>>>
>>>> Ishtiaq Ahmad wrote:
>>>>
>>>> Hi Steve,
>>>> I know the the structure. Problem is when sakai query to the
>>>> table "cm_member_container_t" then it passes NULL in the where
>>>> clause as i mentioned in my previous email.
>>>>
>>>> I want to know where i can setup the Categories e.g.
>>>> (Department, Faculty etc) for filtration.
>>>>
>>>> thanks
>>>>
>>>>
>>>> On Wed, Sep 16, 2009 at 9:46 AM, Steve Swinsburg
>>>> <steve.swinsburg at gmail.com <mailto:steve.swinsburg at gmail.com>
>>>> <mailto:steve.swinsburg at gmail.com
>>>> <mailto:steve.swinsburg at gmail.com>>> wrote:
>>>>
>>>> Hi,
>>>>
>>>> Try starting Sakai with the JAVA_OPT -Dsakai.demo=true and you
>>>> should get a bunch of sample data populated in your DB for
>>>> courses
>>>> and sections. This will show the structure of how it's set up.
>>>>
>>>> cheers,
>>>> Steve
>>>>
>>>>
>>>> On 16/09/2009, at 2:36 PM, Ishtiaq Ahmad wrote:
>>>>
>>>> Hi,
>>>>
>>>> *I need solution to this Issue ASAP please*
>>>> I am trying to integrate sakai with SIS. I have
>>>> populated SAKAI
>>>> tables with SIS data. Academic Session are present in the
>>>> dropdown but Subject, Course, Section are empty.
>>>> I am attaching reference files. Please tell me what
>>>> could be the
>>>> issue.
>>>> Is there any bean configuration for Subject DropDown
>>>> institutional specific values?
>>>>
>>>> I am using default implementation of
>>>> "CourseManagementServiceHibernateImpl"
>>>>
>>>> CM_MEMBER_CONTAINER_T.csv: snapshot of table data.
>>>> worksite.doc: worksite screen shots
>>>>
>>>> I found the following query from database trace.
>>>>
>>>> SELECT coursesetc0_.member_container_
>>>> id AS member1_60_,
>>>> coursesetc0_.VERSION AS version60_,
>>>> coursesetc0_.last_modified_by AS last4_60_,
>>>> coursesetc0_.last_modified_date AS last5_60_,
>>>> coursesetc0_.created_by AS created6_60_,
>>>> coursesetc0_.created_date AS created7_60_,
>>>> coursesetc0_.enterprise_id AS enterprise8_60_,
>>>> coursesetc0_.title AS title60_,
>>>> coursesetc0_.description AS descrip10_60_,
>>>> coursesetc0_.CATEGORY AS category60_,
>>>> coursesetc0_.parent_course_set AS parent18_60_
>>>> FROM cm_member_container_t coursesetc0_
>>>> WHERE coursesetc0_.class_discr =
>>>>
>>>> 'org.sakaiproject.coursemanagement.impl.CourseSetCmImpl'
>>>> *AND coursesetc0_.CATEGORY = :1*
>>>> ORDER BY coursesetc0_.title
>>>>
>>>> *This query executes but Bind variable ':1' has null
>>>> value.
>>>> Please tell me where can i setup this category value...*
>>>>
>>>>
>>>> I will be very thankful to you...
>>>>
>>>> -- Regards,
>>>> Ishtiaq Ahmad
>>>>
>>>> <worksite.doc><CM_MEMBER_CONTAINER_T.csv>_______________________________________________
>>>> production mailing list
>>>> production at collab.sakaiproject.org
>>>> <mailto:production at collab.sakaiproject.org>
>>>> <mailto:production at collab.sakaiproject.org
>>>> <mailto:production at collab.sakaiproject.org>>
>>>>
>>>>
>>>> http://collab.sakaiproject.org/mailman/listinfo/production
>>>>
>>>> TO UNSUBSCRIBE: send email to
>>>> production-unsubscribe at collab.sakaiproject.org
>>>> <mailto:production-unsubscribe at collab.sakaiproject.org>
>>>> <mailto:production-unsubscribe at collab.sakaiproject.org
>>>> <mailto:production-unsubscribe at collab.sakaiproject.org>>
>>>> with a
>>>> subject of "unsubscribe"
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> -- Regards,
>>>> Ishtiaq Ahmad
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> production mailing list
>>>> production at collab.sakaiproject.org
>>>> <mailto:production at collab.sakaiproject.org>
>>>> http://collab.sakaiproject.org/mailman/listinfo/production
>>>>
>>>> TO UNSUBSCRIBE: send email to
>>>> production-unsubscribe at collab.sakaiproject.org
>>>> <mailto:production-unsubscribe at collab.sakaiproject.org> with a
>>>> subject of "unsubscribe"
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Ishtiaq Ahmad
>>>>
>>>
>>>
>>
>>
>> --
>> Regards,
>> Ishtiaq Ahmad
>> _______________________________________________
>> production mailing list
>> production at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/production
>>
>> TO UNSUBSCRIBE: send email to
>> production-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>>
>>
>
>
> --
> Regards,
> Ishtiaq Ahmad
>
--
Regards,
Ishtiaq Ahmad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20090929/f422134b/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CM_MEMBER_CONTAINER_T.csv
Type: application/vnd.ms-excel
Size: 4424 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20090929/f422134b/attachment-0004.xlb
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CM_ENROLLMENT_SET_T.csv
Type: application/vnd.ms-excel
Size: 559 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20090929/f422134b/attachment-0005.xlb
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CM_ENROLLMENT_T.csv
Type: application/vnd.ms-excel
Size: 568 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20090929/f422134b/attachment-0006.xlb
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CM_OFFICIAL_INSTRUCTORS_T.csv
Type: application/vnd.ms-excel
Size: 69 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20090929/f422134b/attachment-0007.xlb
More information about the production
mailing list