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

[Ishtiaq Ahmad]

Not resolved yet....

On Wed, Sep 16, 2009 at 4:01 AM, Paul Gibbs <pgibbsjr at hotmail.com> wrote:

> Ishtiaq,
>
> Please let us know how you fix this--I'm headed the same way with our SIS
> integration.
>
>
> Paul Gibbs
> Registrar
> Calvary Baptist Theological Seminary
> Lansdale, Pennsylvania
> (215) 368-7538, ext. 207
>
> Sent from my BlackBerry (267.261.4453)
>
> -----Original Message-----
> From: Ishtiaq Ahmad <organic.ishtiaq at gmail.com>
>
> Date: Tue, 15 Sep 2009 06:18:49
> To: <production at collab.sakaiproject.org>; <
> sakai-dev at collab.sakaiproject.org>
> Subject: [Deploying Sakai] Subject Drop Down of SAKAI worksite is empty
>
>
> Hi,
> 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
>



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