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

[Ishtiaq Ahmad]

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


-- 
Regards,
Ishtiaq Ahmad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20090917/0d564ee4/attachment.html