[Building Sakai] No data in Academic term

[Matthew Jones]

I agree,

The tool would be pretty 'easy' to write, but would still take quite a few
hours of a developers time to actually do it and integrate it with Sakai
(maybe a week?). The work to modify the database tables is so trivial that
even if all this time was added up it would probably just *almost* come
close to the development time of a new tool.

And as Mark said, many institutions that might have development effort to
do this generally have an external provider
for CourseManagementAdministration and are pulling the academic terms from
a separate source other than this table anyway. It was kind of just put in
as an 'sample' with the default OOTB provider. Generally if you're at the
level of setting up courses and academic terms then you're a more advanced
user and can run some database queries anyway.

Though, it seems like this is a good project for anyone to try. :) Like
Mark I'd also written a 'sample' course management Admin when I was testing
to see if ZK (http://www.zkoss.org/) would be a good framework for rapidly
developing applications. I personally really liked it, and wrote this up in
few days:
https://source.sakaiproject.org/contrib/umich/jonespm/zk/

However it was nearly 2-3 years ago, I haven't tried to run it since and it
may or may not work with the latest version of ZK. Back then the license
was less compatible and the widgets didn't work with Webkit. But they went
to lgpl somewhere along the way and fixed many bugs so it became much more
attractive. Hooking something like this up to RequestFilter, doing an
'isAdmin' check and putting in a tool registration probably wouldn't be too
much work. Even if that's not desired, all the code there for
adding/removing/checking academic terms is in Java, if someone wanted to
write something in wicket or spring mvc archetypes for a fun side project.
[1] The ZK widgets were really slick though.

http://www.gmjjavadesigns.com/content/sakai-spring-maven-archetype-v10

-Matthew

On Thu, Jan 12, 2012 at 11:37 AM, Mark Norton <markjnorton at earthlink.net>wrote:

>  I actually built such a tool years ago.  Sadly, the client for whom it
> was created for declined to make it open source.  Generally, academic terms
> are defined outside of Sakai and made available to it via a Course
> Management provider extension.  For developers, it's easy enough to jump in
> and run a query to create an generic term.
>
> The following SQL can be used to create a generic, opened ended academic
> term:
>
> insert into cm_academic_session_t values (null, 1, "admin", null, "admin",
> null, "open-ended", "Open Ended", "No start or end.", null, null, true);
>
>
> This is generally enough for development purposes.
>
> - Mark Norton
>
>
> On 1/12/2012 11:00 AM, Rafael Morales wrote:
>
> Should it be an admin tool for entering academic terms? I have seen this
> people (including myself) asking about this problem for four years.
>
> Regards,
> Rafael
>
> El 11/01/2012 09:30 a.m., Kromhout, Ethan escribió:
>
>  Hi Mudasar,****
>
> ** **
>
> Have you tried setting “is_current” to 1?****
>
> ** **
>
> Ethan****
>
> ** **
>
> *From:* sakai-dev-bounces at collab.sakaiproject.org [
> mailto:sakai-dev-bounces at collab.sakaiproject.org<sakai-dev-bounces at collab.sakaiproject.org>]
> *On Behalf Of *mudasar yasin
> *Sent:* Wednesday, January 11, 2012 10:25 AM
> *To:* sakai-dev at collab.sakaiproject.org
> *Subject:* [Building Sakai] No data in Academic term****
>
> ** **
>
> Hi,
>
> I am not able to add " course site" under "WorkSite", because there is no
> Academic term is available. After search i have found to change in DB have
> solved this problem. I have run the following db query but still there is
> no data in "Academic term" drop down.
>
> INSERT INTO CM_ACADEMIC_SESSION_T(ENTERPRISE_ID,TITLE,START_DATE,END_DATE)
> VALUES(201250,'Spring2012',2012-01-20,2012-05-25);
> mysql> select * from sakai.CM_ACADEMIC_SESSION_T;
>
> +---------------------+---------+------------------+--------------------+------------+--------------+---------------+------------+-------------+------------+------------+------------+
> | ACADEMIC_SESSION_ID | VERSION | LAST_MODIFIED_BY | LAST_MODIFIED_DATE |
> CREATED_BY | CREATED_DATE | ENTERPRISE_ID | TITLE      | DESCRIPTION |
> START_DATE | END_DATE   | IS_CURRENT |
>
> +---------------------+---------+------------------+--------------------+------------+--------------+---------------+------------+-------------+------------+------------+------------+
> |                   3 |       0 | NULL             | NULL               |
> NULL       | NULL         | 201250        | Spring2012 |             |
> 0000-00-00 | 0000-00-00 |            |
>
> +---------------------+---------+------------------+--------------------+------------+--------------+---------------+------------+-------------+------------+------------+------------+
>
> 2nd there is an other solution to see the Academic term to enable demo
> data, i have add the following parameters in -Dsakai.demo=true in JAVA_OPTS
> but still no work.
>
> Please let me know what is wrong there?
>
>
> Best regards,
> MY
> o2sp.com****
>
> ** **
>
>
> _______________________________________________
> sakai-dev mailing listsakai-dev at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>
>
> _______________________________________________
> sakai-dev mailing listsakai-dev at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120112/1f7ef89f/attachment.html