[Deploying Sakai] Subject Drop Down of SAKAI worksite is empty
Ishtiaq Ahmad
organic.ishtiaq at gmail.com
Mon Sep 28 02:15:09 PDT 2009
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20090928/324ea6b8/attachment-0001.html
More information about the production
mailing list