WISE v4.9 Release Notes

Table of Contents Release Schedule Notes Goals Issues Major additions/changes Minor additions/changes Updating instructions (for people upgrading from v4.8)

Release Schedule

Release dates:
Stable: ETA: September 2014
RC1: ETA: August 2014

Notes

This release requires Tomcat 8.0.x and and java 7+ to work with WebSockets. WISE@Berkeley is using Tomcat 8.0.9 with java 1.7.0_65 (as of Aug. 2014)

Goals

1. Annotator Tool
2. Generic HTML WebApp step type
3. Grading+Classroom Monitor+Premade Comments v2
4. More tools that use real-time technology
   1. grading tool real-time notification of new work
   2. authoring tool co-authoring notification
   3. brainstorm new responses
   4. new teacher feedback
   5. collaborative annotator
5. Public "teacher-created" project library
6. IE 11 support
7. "No Cache" Mode for Authoring
8. Upgrade Springframework v3.2.x to 4.0.x
9. Support for Tomcat 8
10. Support for Java 8
11. Authoring Tool v2

Issues

1. See here: https://github.com/WISE-Community/WISE/issues?milestone=2&page=1&state=open

Major additions/changes

1. New Annotator Step type
2. Teacher and Student can override language (by default, WISE looks at system language) via "Update My Account" page or by adding ?lang=XX to end of URL. #320
3. AssessmentListNode (Questionnaire): new choose multiple item type
4. Explanation Builder step: added filtering of ideas You can now filter ideas to show up on an Explanation Builder and Idea Basket steps based on one or more steps that the ideas were created on.
5. "TrustedAuthors" can now upload more file types than normal authors. A "Trusted Author" can upload more types of files than a normal author like zip files
6. Classroom Monitor improvements You can now grade from within the classroom monitor tool
7. Teacher Run Notes. Teachers can take private and public notes on a run via the "My Notes" link in the run listing page
8. MySystem Step: Import Draw step work into as a background
9. Table Step: Import and Graph data stored in CSV file
10. Upgrade Spring Framework 3.2.3 => 4.0.5
11. Upgrade Spring Security 3.1.1 => 3.2.4
12. Upgrade Hibernate 3.6.10 => 4.3.5
13. Added method-level object caching using Spring's Cache Annotation context support

Minor additions/changes

1. Fixed problem where old projects can't be exported
2. DB query optimizations
3. Drawing tool loading optimizations
4. You can now specify max file upload size in wise.properties
5. More translations to Simplified Chinese, Spanish, and Dutch
6. Localization Support for Systems running with default locale that is not English
7. Refactoring - merged functions, removed old and unused resources
8. Added ability to author a starting state for draw steps (including default snapshots and editable drawing elements on the student layer)
9. Updated TinyMCE 3=>4
10. Java unit tests for code related to portal are now compiling again

Updating instructions (for people upgrading from v4.8)

0. Make sure you are using Tomcat 8.0.x and java 7+

1. Add new fields to wise.properties (see wise_sample.properties for example):

# maxFileUploadSize - max size of each file that can be uploaded, in bytes. Default: 15728640 (15MB)
maxFileUploadSize=15728640

# c3p0 database connection pooling settings
# you can use these default values, or modify them to match your server environment as needed.
# see here for detailed explanation of each setting: http://www.mchange.com/projects/c3p0/#configuration
c3p0.minPoolSize=10
c3p0.maxPoolSize=100
c3p0.acquireIncrement=5
c3p0.maxStatements=0
c3p0.maxStatementsPerConnection=0
c3p0.maxIdleTime=300
c3p0.idleConnectionTestPeriod=100


normalAuthorAllowedProjectAssetContentTypes=text/plain,text/csv,text/xml,image/gif,image/jpeg,image/png,image/svg+xml,image/gif,audio/mp4,audio/mpeg,audio/vnd.wave,audio/ogg,audio/webm,audio/x-aac,video/mpeg,video/mp4,video/ogg,video/quicktime,video/x-flv,video/avi,video/webm,application/vnd.oasis.opendocument.text,application/vnd.oasis.opendocument.spreadhseet,application/vnd.oasis.opendocument.presentation,application/vnd.oasis.opendocument.graphics,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-powerpoint,application/vnd.openxmlformats-officedocument.presentationml.presentation,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/java-archive,application/octet-stream,application/x-shockwave-flash,application/json
trustedAuthorAllowedProjectAssetContentTypes=text/html,application/javascript,application/x-javascript,text/javascript,text/css,application/zip,application/x-zip,application/x-zip-compressed,application/gzip


########## nightly cronjobs ###########

# When the daily job should execute.
# pattern is a list of six single space-separated fields: representing second, minute, hour, day, month, weekday
# default is to run every night at midnight
cronJobExpression=0 0 0 * * ?

2. Update db schema (for people using mysql)

ALTER TABLE `wise_database`.`user_details` ADD COLUMN `language` VARCHAR(255) NULL DEFAULT NULL;

INSERT INTO `wise_database`.`granted_authorities` (id, authority, OPTLOCK) VALUES (7, "ROLE_TRUSTED_AUTHOR", 0);

ALTER TABLE `wise_database`.`runs` ADD COLUMN `private_notes` text NULL DEFAULT NULL;

ALTER TABLE `wise_database`.`runs` ADD COLUMN `public_notes` text NULL DEFAULT NULL;

CREATE TABLE `portfolio` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `workgroupId` bigint(20) DEFAULT NULL,
  `runId` bigint(20) DEFAULT NULL,
  `metadata` text,
  `data` mediumtext,
  `isPublic` bit(1) DEFAULT NULL,
  `isSubmitted` bit(1) DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `postTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
);

3. Replace all instances of isXMPPEnabled with isRealTimeEnabled in the wise.properties file

Before:
isXMPPEnabled=true

After
isRealTimeEnabled=true

4. Run this query on your database to replace all instances of isXMPPEnabled with isRealTimeEnabled in the info column in the runs table

update wise_database.runs set info = replace(info, "isXMPPEnabled", "isRealTimeEnabled");

5. Make project.name field not nullable

ALTER TABLE `wise_database`.`projects`  CHANGE COLUMN `name` `name` VARCHAR(255) NOT NULL;