[Building Sakai] How to create "Academic term" by myself ???

[Phuc Bui]

Dear kevin.foote,
It worked !!!
I have tried this before but I had invalid date (I copied the code and not
consider about it)
Thanks so much Kevin :)

By the way, when I create a new Course Site. It asks me to select Subject -
Course - Section. Can we add it as the same way (using SQL script) ??? Of
course, I can add it by selecting "Still cannot find your course/section?"

Thanks

Phuc Bui

-----Original Message-----
From: Kevin P. Foote [mailto:kpfoote at iup.edu] 
Sent: Monday, March 23, 2009 7:34 PM
To: Phuc Bui
Cc: sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] How to create "Academic term" by myself ???


Phuc - 

You will have to do this manually through your DB client.. Here is an
example for mysql.


INSERT INTO CM_ACADEMIC_SESSION_T
(ENTERPRISE_ID,TITLE,START_DATE,END_DATE) VALUES(200950,'Spring
2009',2009-05-10,2009-05-25);

Make sure you have valid (current) dates if you want to see these in the 
'Worksite Setup' drop down.  There is also an IS_CURRENT flag for this
table in sakai 2.6 which will need a 0 or 1. 
Not sure what version you have installed so I didn't place it in the sql
above.


------
thanks
  kevin.foote

On Sun, 22 Mar 2009, Phuc Bui wrote:

-> Dear,
-> 
-> When I create a new Course Site, it asks for a Academic term, but it
appears
-> empty. And I can not create my site.
-> 
-> When I use the demo version contribution on Sakai's page, it give an
-> available Academic term.
-> 
-> So, I would like to ask you for instruction about creating Academic term.
-> 
-> Looking forward to your replies.
-> 
->  
-> 
-> Thanks
-> 
-> Phuc Bui
-> 
->  
-> 
->  
-> 
->