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

[Lydia Li]

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