WISE v5.4 Release Notes

Table of Contents

• Release Schedule
  
• Download
  
• Notes
  
• Major Goals
  
• Major Changes
  
• Minor Changes
  
• Updating Instructions

Release Schedule

v5.3.1 Released Feb 1, 2017 Announcement
v5.3.2 Released Feb 17, 2017 Announcement
v5.3.3 Released Mar 17, 2017 Announcement

Download

Downloads are available at wise5.org

Notes

WISE5 Goals

WISE5 Design Doc and Notes

This release requires Tomcat 8.0.x and and java 7+ to work with WebSockets. WISE@Berkeley is using Tomcat 8.5.x with java 1.8 (as of Feb. 2017)

Major Goals

1. Improve design and functionality of CM
2. Notebook redesign
3. Make AT easier to use
4. Make easy to develop WISE on Windows

Major Changes

Minor Changes

Updating Instructions

(for people upgrading from v5.3)

1. Add supportedLocales to wise.properties

(in wise.properties file: supportedLocales=en,ar,zh_TW,zh_CN,nl,fr,de,he,it,ja,ko,pt,es,th,tr

2. Run queries to update database

MySQL:

1. Add localNotebookItemId and notebookItemId columns to annotations table
alter table annotations add localNotebookItemId varchar(30) null after studentWorkId;
alter table annotations add notebookItemId int(11) null after localNotebookItemId;

alter table annotations
    add constraint FK_lklpu3fwsovjhx5wqsjlah0ov
    foreign key (notebookItemId)
    references notebookItems (id);   

2. Insert new translator role
insert into granted_authorities (authority, OPTLOCK) values ("ROLE_TRANSLATOR",0)

3. Update the language field for 'en_US' users
update user_details set language='en' where language='en_US';

HSQLDB:

1. In hsqldb/wise_database.script, replace Annotations table definition with below to add new localNotebookItemId and notebookItemId fields
CREATE MEMORY TABLE PUBLIC.ANNOTATIONS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,CLIENTSAVETIME TIMESTAMP NOT NULL,COMPONENTID VARCHAR(30),DATA VARCHAR(16777216) NOT NULL,NODEID VARCHAR(30),SERVERSAVETIME TIMESTAMP NOT NULL,TYPE VARCHAR(30) NOT NULL,FROMWORKGROUPID BIGINT,PERIODID BIGINT NOT NULL,RUNID BIGINT NOT NULL,STUDENTWORKID INTEGER,LOCALNOTEBOOKITEMID VARCHAR(30),NOTEBOOKITEMID INT(11),TOWORKGROUPID BIGINT NOT NULL)

2. In hsqldb/wise_database.script, insert new translator role (find similar rows and add at the end):
INSERT INTO GRANTED_AUTHORITIES VALUES(8,'ROLE_TRANSLATOR',0)

3. In hsqldb/wise_database.script, update the language field for 'en_US' users. Search for "en_US" and replace with "en".