[Using Sakai] [Building Sakai] CM_ACADEMIC_SESSION_T --> Re: Setup of own version 2.5.4

[zaimi]

Beautiful! Thanks again!

-zaimi-

Matthew Jones wrote:
> For Sakai 2.5 the default worksite setup will only show semesters that
> are current by date. So you need something that starts before July
> 10th AND ends after July 10th. It looks like you need an entry for
> spring/summer for this year as the earliest you have is 02-SEP-2009.
> If you need it to display future semesters you'd need to change some
> code.
>
> (2.5 course management)
> course-management/cm-impl/hibernate-impl/hibernate/src/hibernate/org/sakaiproject/coursemanagement/impl/AcademicSessionCmImpl.hbm.xml
> ...
>     <query name="findCurrentAcademicSessions">
>         <![CDATA[
>         from AcademicSessionCmImpl as term where
>             (term.startDate is null or term.startDate <= current_date()) and
>             (term.endDate is null or term.endDate >= current_date())
>             order by term.startDate
>         ]]>
>     </query>
>
> In sakai 2.6 there is an additional column (IS_CURRENT) that allows
> you to specify what displays.
>
> -Matthew
>
> On Fri, Jul 10, 2009 at 11:19 AM, zaimi<nnordin at umich.edu> wrote:
>   
>> Good morning,
>>
>> We are still not able to see the Academic Term listed in the WorkSite Setup
>> --> Creating a new a site
>>
>> -- populated CM_ACADEMIC_SESSION_T  table with data:
>> insert into cm_academic_session_t values(CM_ACADEMIC_SESSION_S.NEXTVAL, 1,
>> 'admin', '09-JULY-09', 'admin', '09-JULY-09', 'FALL 2009', 'FALL 2009',
>> 'F09', '02-SEP-2009', '09-DEC-2009');
>> insert into cm_academic_session_t values(CM_ACADEMIC_SESSION_S.NEXTVAL, 1,
>> 'admin', '09-JULY-09', 'admin', '09-JULY-09', 'WINTER 2010', 'WINTER 2010',
>> 'W10', '03-JAN-2010', '15-APR-2010');
>> insert into cm_academic_session_t values(CM_ACADEMIC_SESSION_S.NEXTVAL, 1,
>> 'admin', '09-JULY-09', 'admin', '09-JULY-09', 'SPRING 2010', 'SPRING 2010',
>> 'Sp10', '29-APR-2010', '20-JUN-2010');
>> insert into cm_academic_session_t values(CM_ACADEMIC_SESSION_S.NEXTVAL, 1,
>> 'admin', '09-JULY-09', 'admin', '09-JULY-09', 'SPRING_SUMMER 2010',
>> 'SPRING_SUMMER 2010', 'SpSu10', '29-APR-2010', '15-AUG-2010');
>> insert into cm_academic_session_t values(CM_ACADEMIC_SESSION_S.NEXTVAL, 1,
>> 'admin', '09-JULY-09', 'admin', '09-JULY-09', 'SUMMER 2010', 'SUMMER 2010',
>> 'Su10', '25-JUN-2010', '15-AUG-2010');
>> insert into cm_academic_session_t values(CM_ACADEMIC_SESSION_S.NEXTVAL, 1,
>> 'admin', '09-JULY-09', 'admin', '09-JULY-09', 'FALL 2010', 'FALL 2010',
>> 'F10', '02-SEP-2010', '09-DEC-2010');
>>
>> -- restarted Tomcat service
>>
>> #################################
>>
>> Sakai version 2.5.4 (binary installed)
>> Database: Oracle 10G
>>
>> #################################
>>
>> Did I miss anything else or do I need to add something to the
>> Sakai.properties?
>>
>> Thanks!
>> -zaimi-
>>
>>
>> Matthew Jones wrote:
>>
>> You have to start up with the JAVA_OPT "-Dsakai.demo=true" to create
>> the CM_ACADEMIC_SESSION_T table or create it from an sql script.
>>
>> Here's some info on that
>> http://faq.serensoft.com/index.php?action=artikel&cat=19&id=37&artlang=en
>>
>> Here's the sql scripts if you don't want to start up with the demo option.
>>
>> https://source.sakaiproject.org/svn/msub/umich.edu/ctools/ctools-providers/trunk/component/impl/src/sql/
>>
>> (Might have to add some up-to-date 'insert' semesters into the script)
>>
>> -Matthew
>>
>> On Wed, Jul 8, 2009 at 3:07 PM, Morris, Yvonne<ymorris at umich.edu> wrote:
>>
>>
>> We have setup our own version of sakai 2.5.4 but the pull down list in “Site
>> Type” next to Course site will not list the academic terms.   Could someone
>> help me out with what table I’m missing.
>>
>>
>>
>> _______________________________________________
>> sakai-user mailing list
>> sakai-user at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>>
>> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org
>> with a subject of "unsubscribe"
>>
>>
>>
>> _______________________________________________
>> sakai-user mailing list
>> sakai-user at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>>
>> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org
>> with a subject of "unsubscribe"
>>
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
>> with a subject of "unsubscribe"
>>
>>