[Deploying Sakai] Subject Drop Down of SAKAI worksite is empty

[Lydia Li]

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>> 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>
>>     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
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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"