[Building Sakai] No data in Academic term

[Mark Norton]

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] *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 list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email tosakai-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/5347ff2d/attachment.html