[Deploying Sakai] Subject Drop Down of SAKAI worksite is empty
Zhen Qian
zqian at umich.edu
Fri Sep 25 06:47:12 PDT 2009
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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20090925/2a4939a8/attachment-0001.html
More information about the production
mailing list