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

[Ishtiaq Ahmad]

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>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
> 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/20090916/3187e587/attachment.html