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: September 27, 2014 (Announcement: https://groups.google.com/d/msg/wise-dev/3gWjY8lpRug/KI4P13KvFzIJ)
RC1: September 5, 2014 (Announcement: https://groups.google.com/d/msg/wise-dev/5EYAu4unRKM/IXsNJfTqiWQJ)

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 Sept. 2014)

Goals

1. Annotator Tool
2. Generic HTML WebApp step type
3. Grading+Classroom Monitor
4. More tools that use real-time technology
   1. grading tool display real-time notification of new work
   2. brainstorm display new responses
5. Public "teacher-created" project library
6. "No Cache" Mode for Authoring
7. Upgrade Springframework 3.2.x => 4.0.x
8. Upgrade Hibernate 3.6.10 => 4.3.5
9. Support for Tomcat 8
10. Support for Java 8

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 (Students can add text labels to background images and add annotate their work)
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; can now filter ideas to show up on 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, like zip files
6. Classroom Monitor improvements: Can now grade work 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: Can import Draw step work as a background
9. Table Step: Can import and graph data stored in CSV file
10. Upgraded Spring Framework 3.2.3 => 4.0.5
11. Upgraded Spring Security 3.1.1 => 3.2.4
12. Upgraded Hibernate 3.6.10 => 4.3.5
13. Added method-level object caching using Spring's Cache Annotation context support
14. Added support for running WISE on HTTPS

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) and annotator steps (including default labels)
9. Updated TinyMCE 3=>4
10. Java unit tests for code related to portal are now compiling again
11. Can now specify when nightly jobs are run

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;

ALTER TABLE `wise_database`.`newsitem` ADD COLUMN `type` VARCHAR(255) NOT NULL;

UPDATE `wise_database`.`newsitem` SET type="public" WHERE type = "";

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;