[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