[Deploying Sakai] Automatic association of members with relevant site
Zhen Qian
zqian at umich.edu
Tue Sep 29 08:22:41 PDT 2009
Ishtiaq:
It might be helpful to take a look at this confluence site: http://
confluence.sakaiproject.org/display/CM/Local+Implementations, where
it lists a couple of contact information for CM integration.
In Michigan, we write our own cm impl and provider, and we do not
populate those CM_ tables. You can take a look at our implementation
at https://source.sakaiproject.org/svn/msub/umich.edu/ctools/ctools-
providers/trunk/
It looks like UC Davis is using the Hibernate approach, so you might
want to follow their code link https://source.sakaiproject.org/
contrib/ucd/cm-ucd-impl/
Thanks,
- Zhen
On Sep 29, 2009, at 5:50 AM, Ishtiaq Ahmad wrote:
> 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
> <CM_MEMBER_CONTAINER_T.csv><CM_ENROLLMENT_SET_T.csv><CM_ENROLLMENT_T.c
> sv><CM_OFFICIAL_INSTRUCTORS_T.csv>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20090929/0c9d58cf/attachment-0001.html
More information about the production
mailing list