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

[Matthew Jones]

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