historical release notes

Below you will find historical release notes for clevr Version 3 - Version 12.

version 12.0 release notes

Version 12.6

Release Date: July 11th, 2019

Tenant Module

• New Page Rights for Record History Audit - Added a Tenant Module clevr page right to be able to grant roles other than clevr Admin access to the Record History Audit Log implemented in clevr V12.4. When granted, the Record History Audit Log gives a user the ability to see changes made to records including the date and the name of the user who made the update. 

• AD / LDAP Parameters for Location and Role Alignment - Added a new section to manage AD Security Group configuration within the Tenant Module to configure LDAP and moved settings to an LDAP Configuration tab with a section to support multiple security groups.

editor

• New School Dropdown that Displays the City or Town the School is Located In - A new school dropdown custom type has been created. This new dropdown displays the name of the school with the name of the city or town the school is located in within brackets. When this dropdown has been added to the form, it will look like this: Douglas Elementary (Toronto). This will greatly help districts distinguish between locations when there are multiple schools with the same name. If there is no value in the city name field, the dropdown will display N/A.  

• New File Upload Custom Type - A new file upload custom type has been created. Within the Editor it can be found labelled “Common: File Upload and View”. This custom type will work within a repeater and allows you to upload seperate files to different tabs.

bug fixes

• Tenant Module - Increased the character limit of the proprietary role ID field within the tenant module

• Advanced Search, Bulk Data Entry, Bulk Print

  • Changed Background Colour - The background colour in Advanced Search, Bulk Data Entry, and Bulk Print has been changed from grey to white

  • Unable to Search with a Text Input Field - Resolved an issue introduced in clevr V12.5 that blocked the ability to search text input fields.

• Forms - Resolved an issue preventing the school query from working when SIS integration was not enabled on the field

• Notifications - Resolved an issue preventing notifications from being deployed when the school name contained an apostrophe

Version 12.4

Release Date: June 6th, 2019

Tenant Module

• If form has custom permissions, it is indicated with a “Yes” or “No” attribute within the Form Rights tab of the Tenant Module. When “Yes” is displayed, it means that there is a container, tab, or element with rights that deviate from the base form right. “No” means that the rights within all containers, tabs, or elements match the base access right.

Editor

• Relative Positioning Fix - Improved relative positioning for multiple repeaters within a container. Eventually the goal is to eliminate the need for relative positioning.

• Auto-complete Attribute List - Now when adding a new attribute to an element, when you begin typing an auto-complete list of matching attributes will be displayed that you can choose from.

• Single Student Multi-Report Custom Type - A new custom type link is available within the Editor called “Single Student Multi-Report”. When added to a form, clicking it generates a master PDF file with all printouts available to that user.

Advanced Search

• A new option is available within Advanced Search to display the legal name of a student in the results page when the checkbox for “Display Legal Name” is selected.

performance enhancement

• Force JavaScript File Cache to Clear When a New Release is Applied - This ensures the cache is cleared after a release to ensure the version number is updated in reference libraries

bug fixes

• Editor

  • Resolved an issue with the Editor where it gets into in an endless loading loop upon clicking publish while using the new copy report feature

  • Relative Positioning - Fixed an issue where the content of a show/hide area did not stay on it’s designated area on the form and would appear at random places on the page

  • Image Missing from Notification Custom Type - Resolved an issue where an image was missing from the notification custom type

• Bulk Data Entry - Resolved an issue that was causing the “Bulk Data Entry Complete” toast message to fail to appear when a Bulk Data Entry was performed

• Forms - Resolved an issue that caused a stored procedure to be invalidated

• Client Specific

  • LSSD - Resolved an issue where teachers were seeing students not associated with their PowerSchool classes for LSSD

  • DDSB - Resolved an issue for the DDSB local install with regard to collation difference between the temp database and the live database

  • CCSD - Resolved an issue where notifications were being deployed to all locations the student was associated with. This has been updated to ensure notifications are only deployed to the school selected within the school dropdown. 

Version 12.2

Release Date: May 9th, 2019

Login Audit Log

• New log module that allows admin-level users to review user account login attempts. With a similar interface to the user module, view the most recent login attempts or the login attempts over a specified date range.

editor

• A new “Copy All” option is available within the Editor when copying a form. Now you can select whether to copy just the form or include the printouts too.
  Note: Compatible with HTML printouts only, legacy printouts (C#) are not supported in this feature

Active Directory

• Clients who log in with active directory authentication (Ex: LDAP, ADFS, SSO, etc) will be directed to a blank page upon logout that says “You have successfully logged out of clevr”. Previously they would be directed to the clevr login page.

bug fixes

• Integration - Resolved an issue where locations were occasionally removed from students during the SIS integration routines.

• Editor - Resolved an issue where the rights for the internal clevr admin role were appearing as random roles within the Editor. This has been updated so that internal clevr Admin rights are not shown to other roles.

• Homescreen - Previously, if a staff member that had a user account had their record for a form removed from the Homescreen it would remove that form from their account preventing to access it and breaking it if it was the default form in their account. This issue has been resolved.

• Client Specific - Calgary Board of Education - Changed the messaging within a popup on the Off Campus or On Campus Agreement to be more meaningful. Now users will receive a pop up asking “Do you want to import the Employer details (i.e. address, phone number, etc) for the selected employer?”

VERSION 11.0 RELEASE NOTES

Version 11.4

Release Date: March 25th, 2019

BULK PRINTING

• New ability to choose which way you want your records to be generated with the Bulk Printing module:

  • Download a single PDF with all the records you selected in it

  • Download a zip file with all the records you selected contained within separate PDFs

TEXT FILE INTEGRATION

• Added new “On-Demand” import data fields for clients integrating via text files. The fields added include student gender, staff gender and school population

BUG FIXES

• Bulk Data Entry - Resolved an issue with Bulk Data Entry that yielded no results when all roles were selected

Version 11.3

Release Date: May 2019

TENANT MODULE

• Ability for clevr Team Members to efficiently implement settings including:

  • Configuration settings for AD/LDAP in Tenant Module

  • Configuration settings for PowerSchool

  • Private forms configuration

EDITOR

• The initiativeID (used for flagging for advanced  search, bulk data entry, etc) can now be found in the options accordion

• Additional alerts including an alert to the user if a new layout is created without an initiative ID in Page Properties

• Drag and drop is here! Multiple elements can now be selected at once and dragged into place. Press the CTRL button to grab multiple elements. Works with the arrow keys or mouse!

BUG FIXES

• Homescreen - Resolved the issue on the Homescreen (also referred to as the 4500 screen) where if the user attempted to search using a single checkbox, the page reloaded without any search parameters and never yielded any results.

• Email Function - When a user had “all locations” selected in the location dropdown and attempted to send an email an error would occur. This has been resolved.

• User Module - Fixed a typo in the User Module Proprietary ID field.

• Forms

  • The message deployed when apply to all was successful has been changed from "Student records update successfully." to "The records have been updated successfully"

  • Resolved an issue that caused forms with iFrames to ignore the DoNotClone attribute

• Advanced Search - Resolved the issue where Saved Searches stayed with the user account even if the account is moved to a different tenant and no longer has access to the form.

• Bulk Printing - Resolved an issue that was preventing Bulk Print from working with both HTML and C# Printouts (Legacy Printouts) at the same time

• Client Specific - Pembina Trails - Resolved an issue where a clinical database file was run as an integration file

Version 11.0

Release Date: January 9th, 2019

PRIVATE FORM ACCESS RIGHTS

• New access right created for forms that grants the ability for a form to be set up as private for specified roles. When a form has been set to private for a role, users will only be able to access their own record.

FORMS

• Identical records can now be created for multiple staff and students from a master form. Enter data into a master form, then trigger the creation of a new records for other staff and students.

CUSTOM REPORTS

• Links for custom reports used to be found at the top of the Homescreen when the form they belonged to was selected. Links for custom reports can now be found within their own menu item on the Homescreen called “Reports”.

BUG FIXES

• Files and Links - Extra periods in the file name would prevent a file from being able to be opened once uploaded. This has been resolved.

• Groups and Classes - Corrected a sorting issue that was preventing Groups and Classes from displaying in alphabetical order.

• Tenant Module

  • Corrected an issue with the tenant module that caused “ghost” menu items to appear when a new role had no rights for that module (if clicked on, since the role had no permission to the module, a white screen would load)

  • Corrected an issue that was causing the role ID number to determine whether or not a role was class aligned

• User Module

  • The DOB calendar within the User Module ended after the year 2012. There are now options for up to 2017.

  • Corrected an issue that that would prevent persons from being added to forms after having been modified with the User Module

• Interactive Dashboard - When the Metrics Widget had fields flagged and a search had been run, the role selected was not being passed to the Homescreen. This has been corrected.

• clevr Profile

  • Corrected an issue that was causing clevr Profile to accept only http in the URL for images and not https

• Client Specific Fixes

  • Louis Riel - corrected an issue preventing import data from working with their Adaptation Plan

  • Enabled Single Sign On for Greater Essex

  • Renfrew County Catholic - Corrected an issue that applied ready only rendering to the login screen after a user visited a locked record and then logged out

VERSION 10.0 RELEASE NOTES

Version 10.4

Release Date: September 19th, 2018

INTEGRATION ROUTINE

• Support for additional data fields through clevr on-demand integration

• Ability to specify Home vs Concurrent student enrollment during nightly integration

• Ability to schedule On-demand integration to be performed nightly for specific clevr forms 

EMAIL SCHEDULER

• New feature allows users to set up scheduled search reports from clevr via email

USER MODULE

• Names are sorted alphabetically when searching for a person in the User Module

EDITOR

• Fields flagged for SIS Integration, Searching, Bulk Data Entry, Required Fields, etc are now automatically updated when a form is copied

PERFORMANCE ENHANCEMENTS

• Overhaul to Advanced Search to improve performance. Users will notice Advanced Search and Saved Searches run much faster!

• Enhancements to the Listing Screen to improve performance. Page will load faster when users log in or navigate to a form from the clevr Dashboard.

• Improvements to performance when a user clones a clevr record or performs a record rollover from Bulk Data Entry

• Performance improvements to the copy page feature within the Editor 

• Improvements to performance when loading a form into the Editor

SECURITY ENHANCEMENTS

• A generic message is presented on screen to users changing their clevr password

• Additional logging when a record is set Inactive within clevr

TENANT MODULE

• Support added for an unlimited number of roles with a toggle to determine whether the role is class aligned

BUG FIXES

• Groups and Classes - Some teacher names were not appearing in the class list in the Groups and Classes module. This issue has been resolved.

• Dashboard

  • Some metrics fields were showing incorrect totals on the dashboard. This issue has been resolved.

  • Some form tiles were loading a blank screen. This issue has been resolved.

• SQL Exception Errors - SQL exception errors were generated when various functions were performed in the Editor (load a form in the editor, drag and drop elements, create new form, discard draft). These errors were unseen by end users, however may have affected overall performance of clevr. These issues have been resolved.

• Connection Pool Timeout Error - Connection Pool Timeout Error would occasionally appear. This error was caused by a large number of active connections to the database. A patch has been applied to resolve this issue.

• Digital Signatures - Icon was not appearing for roles who had access to this feature. This issue has been resolved.

• Saved Searches - Searches with a special character in the name were not appearing in the Saved Search list. This issue has been resolved.

• clevr Profile - Could not upload an image for a student with a Pre-registered status in the Student Information System. This issue has been resolved.

• Editor - A second apostrophe was added when saving a form with an apostrophe in the form name. This issue has been resolved.

• clevr Client Specific (Saskatoon Public Schools) - The all roles dropdown on the Advanced Search screen was not appearing. This has been resolved.

Version 10.3

Release Date: August 10th 2018

SECURITY ENHANCEMENTS

• Security review to ensure the safety of clevr data

• Ensure objects are not exposed through the URL

• Ensure that clevr running in a separate browser tab cannot alter properties in the original tab

• Improved error handling to ensure clevr is not susceptible to full path disclosure

GOOGLE SINGLE SIGN ON

• Support added for single sign on functionality through Google

ERROR HANDLING

• User friendly error messages if there is an error when a page or tab is loading

USER MODULE

• Names of users are sorted by name when searching for a person in the User Module

CLIENT SPECIFIC - ALL NEW BRUNSWICK CLIENTS

• Support for single sign on functionality through F5

BUG FIXES

• Linked Accounts - Linked accounts were not switching as expected when users were logging into clevr using their Active Directory authentication process. This issue has been resolved.

• Homescreen - Improvements to performance will improve loading times for this screen

• Text File Integration

  • Headers were being stripped off the text files when the files were processed. This issue has been resolved

  • New locations were not added to clevr when they were present in a text file. This issue has been resolved. New locations are now added to the clevr database as expected.

Version 10.2

Release Date: October 17th, 2017

INTEGRATION ROUTINE OVERHAUL

• Massive overhaul to the existing integration routines. Now locations, staff, students, and classes integrations will be running every night for every SIS type - Maplewood, PowerSchool, and Text File. New students / classes etc will now have a next day turnaround reflected in clevr.

SECURITY ENHANCEMENT OVERHAUL

• Massive security updates have been applied including:

  • Encrypting all modules

  • Strengthening protections against XSS attacks, SQL injections, clickjacking

CLIENT SPECIFIC - CALGARY CATHOLIC SCHOOL DISTRICT

• Custom PowerQueries developed to populate Learner Support Plans, ELLs, and Requests for Support with EIE & ELL codes

BUG FIXES

• Notifications

  • Fixes deployed for various notification related issues:

    • When a student’s last name contained a space or if there were two last names, the auto login link would take you to the login screen. This has been corrected, users will now be logged into their clevr account when clicking on the notification link.

    • Corrected an issue where notifications were failing to send

    • If a user clicked on files & links or the email icon then sent a notification, the notification would take you to that module instead of the record. This has been corrected.

• Editor - Corrected an issue that prevented users from updating the name of a form to contain an apostrophe (Ex: Plan d'enseignement différencié)

• Login Screen - Corrected an issue that applied ready only rendering to the login screen after a user visited a locked record and then logged out

• Alerts Module - Corrected missing permission issue that was causing the Alerts module to load a -1 screen.

• Client Specific - Calgary Catholic School District - Made an update to the PowerSchool integration routine that was preventing users from being deactivated at locations they used to work at

• Client Specific - Manitoba First Nations Education Resource Centre - Corrected an issue with the Editor that caused an error message when attempting to copy a form

• Client Specific - Durham District School Board - Updated a stored procedure that was replacing dashes with a soft hyphen in Advanced Search which caused Excel to convert it to a string

VERSION 9.0 RELEASE NOTES

Version 9.4

Release Date: August 29th, 2017

MERGE PERSONS

• Merge Persons Module allows clevr staff to quickly address issues with duplicate student / staff records imported from the SIS

DATA IMPORT / EXTRACT

• Ability to extract clevr data to XML or CSV

NOTIFICATIONS

• Enhancements to notifications including:

  • Ability to specify custom subject line, “from” name and “from” email when setting up a notification

  • Ability to include student / staff /school name, location and current user name dynamically in the subject line and the body

MENU CHANGES

• Change the initiatives button in the menu bar to say Forms instead of Initiatives

• clevr version number is now available from the main menu under the About button

LIMITED LOGIN ATTEMPTS

• Users are locked out if they have 5 unsuccessful login attempts within 30 minutes

• There is an override in the User Module to allow admin users to override an account lockout

UPGRADE TO .NET FRAMEWORK

• clevr program files have been upgraded to build on .NET 4.5.2

BUG FIXES

• Session Timeout - Ensured the dialog box sits on top of everything else in the page when the user session is going to time out within 10 mins

• Login Screen - Active directory users were being redirected back to the non-AD (2 bar) login screen when their session timed out. This issue has been resolved, users will now be redirected to the Active Directory / LDAP login screen when their session has timed out

• Printouts - The HTML printout cache will now be cleared once an update has been published to a clevr printout

• Editor - Issues with saving custom types using the clevr Editor. This issue has been resolved.

• User Module - User name column did not allow for long usernames (Ex: a long email address). This issue has been resolved. Usernames up to a maximum of 120 characters are now supported.

• Bulk Data Entry - User interface prompts have been added to let users know when clevr is working to filter records and navigate to the next screen after applying filters

Version 9.3

Release Date: August 3rd, 2017

SESSION TIMEOUT FEATURE

• 10 minutes before a session times out, users will receive a warning with an option to renew the current session

• Users will receive a message informing them that a session has expired when they return to clevr after a session timeout

USER MODULE

• Role has been added as a searchable field

• User module will now accept numeric values in the employer name field

GRID VIEW DATA ENTRY

• New Grid View Data Entry page available for quick data entry on configured forms

MAPLEWOOD INTEGRATION

• New logic has been added to the Maplewood Integration routine to set staff status to "inactive" for a location when the mw_status = "This year only" and the transfer date / end date is in the past

BUG FIXES

• Forms - Browser spell check will now underline misspelled words in Rich Text Editor fields

• Advanced Search - French accents are now able to be used to search filters and will now return in results

• User Module - Usernames can now contain 50 characters; previously they were limited to 32 characters

• clevr Profile - Fixed an issue in the clevr Profile that prevented users from uploading a file extension that was all capitals such as .PNG or .JPEG

Version 9.2

Release Date: June 17th, 2017

ADVANCED SEARCH - SAVED SEARCHES

• New feature that allows users to save and share search criteria from Advanced Search screen

• New saved searches widget available on the Interactive Dashboard

FORMS

• New icon available to be added to clevr forms that will trigger a form to form integration

• New Rich Text Editor field available to be added to newly developed clevr forms

ADVANCED SEARCH - SAVED SEARCHES

• New feature that allows users to save and share search criteria from Advanced Search screen

• New saved searches widget available on the Interactive Dashboard

ACTIVE DIRECTORY ROLE ALIGNMENT

• "Role Precedence" functionality added to facilitate Active Directory role alignment

BUG FIXES

• Interactive Dashboard - Widgets are now all the same size to correct formatting / adjustment issues when moving widgets on the Interactive Dashboard

• Bulk Data Entry - Bulk data entry did not transfer any carriage returns into the subsequent records. This has been fixed.

• Files and Links - The “Enter File Alias” heading in files and links has been changed to “Enter File Name”

• Text file integration - Resolved issue “reactivating” staff / students at a location

• Linked Accounts - Linked user accounts alias will now appear in alphabetical order

Version 9.1

Release Date: May 8th 2017

LINKED USER ACCOUNTS

• New feature that allows Single Sign On for users with clevr user accounts in multiple Districts / Divisions 

• With linked accounts, users can now have more than one role in clevr

INTERACTIVE DASHBOARD

• New dashboard that allows divisions to customize the clevr dashboard by role

• Allows end users to customize their own Dashboard

HOMESCREEN SEARCH

• Users can now search for students using a “Current Grade” filter

• Users can now run a search using “required fields” as a parameter

ALL ROLES DROPDOWN

• All Roles is now available in the roles dropdowns found on the Interactive Dashboard, Homeccreen, Add Screen, Advanced Search, Bulk Data Entry, and Bulk Print

ACTIVE DIRECTORY INTEGRATION

• Ability for alignment of clevr roles with nested groups in the Active Directory

• Support for self - signed SSL certificates

BUG FIXES

• Dynamic Charting

  • JavaScript error appears when selecting a some forms on the Dynamic charting screen - this issue has been corrected

  • Some filters are not rendered correctly and appear “cut off” in the filters area - this issue has been corrected

• Editor - Extra rights would appear to be applied when changing rights in the editor - this issue has been corrected

• Tenant Module - Update to change wording on label from “Initiative”’ to “Form”

• Maplewood Integration - Issue when importing data into forms for some Maplewood clients - this issue has been corrected

• Dashboard - Some recently updated records were not being reflected under the “What’s new” area on the dashboard - this issue has been corrected

• Report Editor - Checkboxes are now sorted on printouts in the order they appear on the screen by default

• Advanced Search - Correction to Advanced Search results where first symbol is a "-" (which causes Excel to interpret data as a formula and truncate the results to 255 characters)

• Groups and Classes - Update to new Groups function to handle group descriptions/names that might contain an apostrophe

Version 9.0

Release Date: February 17th, 2017

TEXT FILE INTEGRATION

• Update to allow for SIS staff role alignment with clevr roles

• Update to allow for the ability to “Import Data” into clevr forms from a Custom Web Service or Text File Integration

GROUPS AND CLASSES

• New feature that allows users to add / manage custom groups within clevr

• View into SIS classes that have come in from SIS Integration

CLONE RECORD

• Performance improvement for the Clone Record action. The number of calls to the database have been reduced which will speed up cloning an individual student record and cloning / rolling over records via Bulk Data Entry

REPORT EDITOR

• Support added for special characters including standalone bullets, french characters, and others

BUG FIXES

• Active Directory

  • Update to authenticate against Active Directory / LDAP systems without the need for a “match” using the SAMAccountName attribute

  • Active Directory / LDAP authenticated users are now returned to the Active Directory / LDAP enabled login screen when the log out of clevr

  • Update to authentication to support logging into a VIS server. Change is also compatible with all other LDAPS clients.

• PowerSchool Integration

  • SIS enabled fields are now automatically populating when a record is created from the “Add” screen

  • Inactive locations would be set to active again if they were present in the data incoming from PowerSchool. This issue has been resolved.

• Text File Integration

  • Correction to TextIntegration Staff Import to avoid error in duplicating Person / Position / Location entries

  • Update to LRSD custom web service integration code to bring in Parent1Address as a Parent1MailingAddress field

  • Some users had access to locations they were no longer tied to the Web Service. This issue has been corrected. Users are now marked “inactive” for a location in clevr if they are not active for the location in the Web Service during integration.

• Password Restriction - Restriction on the password set functionality to disallow single quotes in the password

• User Module

  • Rapidly pressing on the create user checkbox caused the box of content that it displays to be cut off. This issue has been resolved.

  • When a user modified their own account in the User Module, an error would appear next login. This issue has been resolved.

• Report Editor

  • Fixed the endless loading screen (spinning wheel) display in preview mode

  • Ability to remove printouts from the printouts list in the printouts editor that are no longer in use has been added

  • Empty repeating rows are removed from printouts

  • The Editor would not load after previewing a printout in the printout editor. This issue has been resolved.

• Apostrophies within clevr

  • Apostrophes used within specific instances in clevr caused the following problems: 

    • A user with an apostrophe in their name could not sign in to their account via the login screen

    • An apostrophe in the Users’ Table in the User Module was causing an error with linking so when clicking on the edit pencil or change password icon you would receive a JavaScript error

  • The fix now allows double or single apostrophes in the system for the username. The user can log in and a User Module user can edit a user who has an apostrophe in their name.

• Dynamic Charting - Charts in dynamic charting were not loading properly after Dynamic Charting access was added to a role. This issue has been fixed.

  • Fix display issue to align mouse pointer to new element when dragging and dropping a new element on a form

  • Fix to update labels on the fly in the Editor using IE11 (page refresh was previously required when using IE 11)

  • Removed the Create Custom Types option for all roles except clevr Admin

• SDS Data Submission - A number sign (#) in the school name was causing the extract process to fail. This issue has been resolved.

• Miscellaneous

  • Functionality that replaced swear words with asterisks (****) has been removed

  • Update to FTP file transfer service to ignore files in the LSAdmin upload directory, and also to ignore files with the following extensions: *.js, *.exe, *.bat, *.dll, *.pdb, *.css.

VERSION 8.0 RELEASE NOTES

Version 8.3.6

Release Date: December 12, 2016

INTEGRATION

• Update to allow for SIS staff role alignment with clevr roles

• Update to allow for the ability to “Import Data” into clevr forms from a Custom Web Service or Text File Integration

Version 8.3.5

Release Date: November 2016

ACTIVE DIRECTORY

• Update to authenticate against Active Directory / LDAP systems without the need for a “match” between the clevr username and the SAMAccountName

Version 8.3.4

Release Date: November 2016

SDS DATA TRANSFER

• Update the Disability dropdown display values to match new Ministry values

• Update to allow forms to be configured more efficiently for the Intensive Supports upload process

BUG FIXES

• Auto-complete Fields - Corrected a timing issue when saving data in AutoComplete fields that are flagged as “Required” fields

• Maplewood Integration - Students with ID numbers of all 000000000 were not integrating correctly. This issue has been resolved.

Version 8.3.3

Release Date: November 2016

BULK PRINTING

• Update to support filtering records by one or more selected values in a group of checkboxes

DYNAMIC CHARTING

• Update to support filtering records by one or more selected values in a multi-select dropdown type element

• Update to support newly added elements with long elementIds

Version 8.3.2

Release Date: November 10, 2016

BULK PRINTING

• Created the ability to use Bulk Printing for staff and school records

• Enhancement to functionality to allow Bulk Print option for “All Locations”

BULK DATA ENTRY

• Enhancement to functionality to allow Bulk Data Entry option for “All Locations”

PERFORMANCE ENHANCEMENTS

• Adjustments to Homescreen query to improve performance when filtering records

BUG FIXES

• User Module

  • Apostrophes within usernames were breaking the JavaScript on the User Module. This issue has been corrected.

  • Additional data validation has been added to disallow passwords with quotes due to incompatibility with clevr security features and encryption in place on clevr passwords

Version 8.3.1

Release Date: October 2016

REPORT EDITOR

• Resolved an issue preventing the Report Editor from loading

Version 8.3

Release Date: September 1st, 2016

REPORT EDITOR

• New HTML Editor created for printouts

SECURITY ENHANCEMENTS

• Additional AES encryption applied to all printouts and uploaded files

EDITOR

• Shared forms can now be flagged as searchable, bulk data entry, SIS integration, clevr form integration, etc. using the clevr Editor

CLEVR INTERFACE IMPROVEMENTS

• User module now supports French accent characters in name fields

• Improved spacing and consistency in the login and student listing screens.

GALLERY

• Removal of Provincial tab and links to “broken” videos

• Addition of 13 new forms!

BUG FIXES

• Files and Links - File upload was previously allowing users to upload files with special characters in the filename causing an error when users tried to access the file through clevr. Special characters are now stripped out of the filename as files are uploaded to prevent errors.

• French Menus - Security settings applied to options within the French menu are now working as expected

• Forms - The French word “Ajouter” was replaced with “Add” when the first row within a dynamic add area was deleted. This issue has been resolved.

• Dynamic Charting - Blank charts were being generated when charting data on newer clevr forms. This issue has been resolved.

Version 8.2

Release Date: June 2nd, 2016

CLEVR PROFILE

• New clevr module that shows a summary of all forms tied to a person

EDITOR

• New dropdownchecklist type available

PERFORMANCE IMPROVEMENTS

• Homescreen

• Advanced Search

• Bulk Data Entry

BUG FIXES

• Maplewood Integration - Corrected an issue causing an error when a location was imported with a school ID number beginning with leading 0s

• PowerSchool Integration

  • Routine was crashing when importing data from a location with a single staff member or single student - this issue has been resolved

  • Update to integration routine so that empty fields will not cause integration to crash

  • Update to allow specified locations for PowerSchool clients to be skipped by the nightly integration

• Text File Integration

  • Update to text file integration to support special characters in the text files

  • Update to text file integration to import student grade when provided

• SDS Data Submission

  • Update to XML submission for Saskatchewan Ministry SDS site so that we use board-specified student ID instead of clevr proprietaryId value

  • Generalize SPS Impact Assessment data extract process and terminology

• Forms

  • Fixed an issue causing occasional duplicate records in repeatable areas

  • Fixed issue causing loading issues on some locked records due to misaligned elements

  • Replace asterisks in swear words with correct number of characters

  • Email action now looks at the status of the users returned in the search to avoid sending emails to users inactive at the location selected

  • Corrected issue causing display issues in read only mode with dropdowns tagged with “disabled” attribute (forced read only) rendering the when the page is set to readonly as well

  • Required field asterisk now appears beside the label for checkboxes marked as a required field

• Editor

  • Fix display issue to align mouse pointer to new element when dragging and dropping a new element on a form

  • Fix to update labels on the fly in the Editor using IE11 (page refresh was previously required when using IE 11)

  • Removed the Create Custom Types option for all roles except clevr Admin

• Advanced Search

  • Updated Homescreen search query to filter for role when role (other than student) is selected

  • Changed PDF file name from "TPM" to "clevr" in files saved from Advanced Search

• Homescreen - Fixed bug that causes dropdowns on the Homescreen to appear empty after using the Editor

• Bulk Printing - Bulk Printing lists are now filtered by class for roles limited to classes access

• Tenant Module

  • Update to correct a display issue causing the initiatives tab to not consistently stretch to the width of the content within the tab

  • Page right control buttons created for Dynamic Charting, and Edit Record History

• User Module - Fixed issue in the User Module where the Homescreen was being set but not saved

• Behind the Scenes Fixes - Update to RemoveDuplicatePersons script to support cleaning duplicate person records when one person could have multiple legitimate proprietaryIds for a tenant

VERSION 7.0 RELEASE NOTES

Version 7.3

Release Date: July 2nd, 2015

FORMS

• Apply-to-all functionality created that allows end users to apply/copy content from one student record to to multiple selected student records

• Added base and non-base location to the student ribbon for students who are enrolled in multiple locations

ADD STUDENT SCREEN

• Added the ability to search for students in all locations on add student screen when location is unknown

• You can now hit the enter key to search for students instead of having to click the search button

ADVANCED SEARCH

• Link to most recent student record created for Advanced Search results

PRINTOUTS

• Created the ability to turn option for bulk printing off for specified printouts

• New option for disabling caching functionality for specified printouts

BEHIND THE SCENES ENHANCEMENTS AND EFFICIENCIES

• Update to the most recent JQuery library (improved tools for clevr developers to add new features)

• Tenant Module - New Tenant Module allows clevr staff to quickly configure client information such as SIS URL, Active Directory settings, etc.

BUG FIXES

• Editor

  • Issue corrected causing deleted elements to occasionally reappear

  • Formatting issue when adding ordered or un-ordered lists to the hover tips corrected - previously the bullet / number did not automatically appear as expected

• Homescreen - “Action” column no longer saving when user saves Homescreen search results

Version 7.2

Release Date: April 8th, 2015

ADVANCED SEARCH

• Support added to search with repeatable elements

INTEGRATION

• Text File Integration - module created so districts can independently upload text files

• PowerSchool - SIS Single Sign On (SSO) for PowerSchool created

• Maplewood Integration - Update to allow fields for contact information to be tagged specifically for mother or father

POWERSCHOOL INTEGRATION

• Added the ability to integrate pre-registered students

EDITOR

• Stored procedure created for log templates: log templates can now be created using the editor

• New base type created - bullet list

• Status Indicator created which displays the percentage of required fields completed

DASHBOARD

• Dashboard created as a new alternative Homescreen

ALERTS

• Alerts / messages can be created and deployed to end users on the Homescreen, template screens, dashboard and login screen

ACTIVE DIRECTORY INTEGRATION

• Ability created to import users from the LDAP/Active Directory for non SIS locations (ie: central staff)

RESET PASSWORD

• Updated password reset emails to include a link to clevr with an auto login and password reset prompt

BUG FIXES

• Error Messages - User friendly error handling on all JavaScript calls

• Editor / Forms

  • Fixed show/hide functionality that was broken when Import Data was triggered

  • Corrected styling on required fields

  • Repeater-specific controls (add / delete) are no longer displayed when record is locked

  • Allows editing of shared templates (for clevr team members only)

  • Copy template functionality is now including appropriate page rights

  • Some templates were loading blank when loaded into editor - this issue has been resolved

  • Repeaters are now working as expected in preview mode

  • Repeaters settings are now correct when added to a sub tab using the editor

  • Editor roles are now able to assign newly created or copied templates to themselves. New templates are now automatically assigned to the user who created the template.

• Password Reset - Password reset link previously directed users to the clevr hosted installation when the client has a local installation

• Bulk Data Entry - Students were occasionally duplicated on the filter screen. This issue has been resolved.

• Advanced Search - Search is now working with parameters that include a single apostrophe

• Add Screen - Clicking the checkbox/add button for a single student always created a new blank record even if the student already had an existing record. This issue has been resolved.

• Maplewood Integration

  • Additional error handling in routines preventing integration routine from crashing / stopping

  • Update to Maplewood integration so that students / staff at a closed school or school with no students / staff listed will be set to inactive

  • Locations are now being updated correctly during the nightly integration

Version 7.1

Release Date: December 22nd, 2014

FORMS

• Added tool tips on all e-mail, spell check and undo icons

• Added tool tips on home, change password, help and editor icons

ADVANCED SEARCH

• Added select all / deselect checkbox for fields to be included in results table

USER MODULE

• Created the ability to export user listing to excel or csv

• Increased the number of users listed on one page from 15 - 50

ADD SCREEN

• Improved user interface experience - single student no longer triggers bulk data entry process

FRENCH LANGUAGE SUPPORT

• French spell check added as a custom type

• French template menu available

EXPORT DATA

• Phase 1 deployed: ability to configure templates to push data back to PowerSchool for an individual student

LINKS TO CLEVRCOMMUNITY.CA

• Help menu added to menu bar with links to new user friendly support site / support materials

GALLERY

• Created a Gallery to showcase templates currently available within clevr

BUG FIXES

• Active Directory - Fixed an issue causing active directory login fields not to appear when users log out or the session times out

• Advanced Search

  • Resolved the bug preventing radio button searches from returning results on the Homescreen

  • Filtering was not working for grouped checkboxes

  • Improved poor performance within the search query

  • Advanced Search was not working when there was a comma included in the filter

• User Module

  • Clicking the submit button before the page finished loading corrupted a user account

  • Resolved an issue causing the JavaScript in the User Module to break when a user account contained an apostrophe

• Forms

  • Last SIS integration date on templates was intermittently displaying the wrong date

  • Form-to-form integration would break if there was an apostrophe in one of the fields

• Bulk Printing - Resolved an issue causing alphabetical ordering to be ignored

• Integration - Increased performance / speed while integrating from PowerSchool

• Homescreen - Search filters were would be removed if the page was refreshed when dropdowns and checkboxes were used

• Add Screen - Mouse pointer was not changing to a hand when hovering over a link

Version 7.0

Release Date: August 2014

EDITOR

• Ability added to copy and paste elements

• Ability to copy existing forms created

• Added the ability to load autocomplete suggestions using an XML or CSV file

BULK PRINTING

• Added the ability to print multiple printouts for a student (IE: IEP & IPRC printouts for a single student, or print all printouts available for a student)

• Added the ability to print multiple printouts for a group of students 

HOMESCREEN INFORMATION ICON

• Homescreen alert created that displays a timestamp and the name of the user who last updated the record

USER MODULE

• Ability for end users to reset their own passwords when forgotten

• Created a user friendly person ‘search’ when adding a user account for an existing staff member or student

INTEGRATION

• Optimized classes integration scheduled to run nightly for specified locations

• Regularly scheduled PowerSchool Integration Routines on SAAS Hosted Site

BUG FIXES

• Integration - Resolved an issue preventing SIS Integration from working with 64 bit elements

• Bulk Data Entry - Resolved an issue that was causing all persons to be assigned the student role regardless of the role selected

• Editor - Resolved an issue causing blank pages within the Editor

VERSION 6.0 RELEASE NOTES

Version 6.3

Release Date: June 2014

MAPLEWOOD INTEGRTAION

• Added the ability to integrate pre-registered students

ADD STUDENT SCREEN

• Added the ability to add multiple students to an initiative at once (Ex: all grade 3 students to the Running Records Assessment vs 1 student at a time)

• Added the ability to specify default values when adding multiple students to an initiative through bulk data entry 

• Remove references to the word “Student” in the add student screen (i.e. several implementations are now using clevr for “staff” forms)

HOMESCREEN

• Added the ability to filter for pre-registered students on the Homescreen

• Added a role filter for districts using staff form implementations

FORMS

• Added the ability to specify required fields to match (Ex: school year) when integrating data between templates

EDITOR

• Added the ability to have priority sorted fields appear at the top of the list within bulk data entry and advanced search

BUG FIXES

• Editor

  • Radio buttons were not working when included within repeatable rows

  • Deleted element options not being completely removed as expected

  • No indication to the end user when a page was ‘loading’ into the staging area.  A spinner has been applied as a visual cue.

  • Apply rights functionality not working as expected when applying full access or full access + editor rights

  • Pages occasionally loading as blank pages within the editor

  • Could not click on or edit disabled elements in the editor.  Removed ‘disabled’ attribute from disabled elements when in edit mode

  • Unable to preview repeatable areas in preview mode

  • Roles dropdown not reflecting custom client roles when applying rights 

  • Warning message for hitting boundary line appearing when adding a tab attribute

  • Auto positioning not working when adding elements by clicking on a type, rather than drag and drop

• Maplewood Integration - method to generate link to launch / auto log into clevr from Maplewood not consistently working as expected

• Bulk Data Entry - Issues when rolling over records with dynamic adds (repeatable areas)

• User Module - Could not include alphanumeric values in Local Id area when adding a new user

• Email functionality - Difficult to select multiple recipients with using Internet Explorer

• Template menu - Alignment was off.  The menu was too far over the right

• Advanced Search - Not returning radio button field values as expected

• Homescreen

  • Edit pencil icon not always navigating to student record on newer templates

  • Search values were not made persistent when users specified multiple search criteria 

Version 6.2

Release Date: March 24th, 2014

HOMESCREEN

• Added the ability to use multiple filters on the Homescreen

FORM EDITOR

• Copy and paste functionality added to the Editor

• Added the ability to use repeatable elements

• Options are updated on page without a page refresh required

POWERSCHOOL INTEGRATION

• Added the ability to integrate pre-registered students

ADVANCED SEARCH

• Searching multiple options within a dropdown or series of checkboxes returns results as an “OR” search

• Enhanced functionality when searching radio buttons

• Filter logic allows template developers to specify sort order on searchable fields - unnumbered search fields will appear after numbered items

BUG FIXES

• User Accounts - Some users accounts with “all locations” were unable to change locations - this has been resolved

• Bulk Data Entry - Fix deployed for Bulk Data Entry not working as expected with containers of checkboxes

• Editor

  • Errors when creating new elements/templates in the editor has been resolved

  • Save draft saving to live intermittently has been resolved

  • Fixed the issue causing discard changes to occasionally failing to unlock template 

  • Fixed the issue causing discard changes not to clear template from staging area

• Advanced Search and Dynamic Charting

  • Resolved an issue preventing filters from resetting when alternating between different initiatives using radio button selector

• Import Data - resolved an issue causing import data to require a page refresh before displaying content

Version 6.1

Release Date: December 16th, 2013

FORMS

• Added the ability to email printouts to other users within the divison

• New student banner on templates - includes current school, current grade, and legal name

FORM EDITOR

• Created an Editor for clevr forms

• Drag and drop functionality

• Ability to apply rights using the editor

• Ability to add initiatives using the editor

• Ability to preview/publish templates to TPM

USER MODULE

• Improved interface to assign all locations to a user

• Improved user account searching (by location)

BUG FIXES

• Advanced Search

  • Fix deployed for searching using multiple filters

  • Added the ability to search for multiple options within a dropdown or series of checkboxes

Version 6.0

Release Date: August 26th, 2013

FORMS

• Undo button created

• Delete content in this tab functionality created

ADD SCREEN

• Added the ability to filter students based on active / inactive status in the Add Screen

TENANT LOGO AND LOCATION LOGO MODULES

• Created two new modules so that districts can upload their own tenant or location logos

VERSION 5.0 RELEASE NOTES

Version 5.2

Release Date: March 1st, 2013

FORMS

• Added the ability to connect form fields to the SIS so that data can be integrated directly

• Added the ability to apply hovertips to form fields

BUG FIXES

• User Module - Fix to “Apply all locations”

• Bulk Data Entry - resolved an issue that was causing the “Do not clone” attribute to be ignored

• Editor - fix deployed for “Save As” type

• Advanced Search - Resolved a filtering issue

• Maplewood Integration - Fix to Exceptionality and Placement variable

VERSION 4.0 RELEASE NOTES

Version 4.2

Release Date: March 5th, 2012

FILES AND LINKS

• New control allows users to maintain a filebank for a student/staff member/school, when implemented as a feature on a TPM template

• New control allows users to maintain a linkbank for a student/staff member/school, when implemented as a feature on a TPM template

ADVANCED SEARCH

• Ability to view summary row per student, or list all records per student in result set

IMPROVED NAVIGATION

• New control allows users to go the Next student/staff member/school in the listing rather than needing to return to the listing page between records

BUG FIXES

• Dynamic Charting - Refined appearance of dynamic tab wording to avoid overlapping tabs

Version 4.1

Release Date: December 19th 2011

BULK PRINTING

• Ability to print a report/printout for multiple students at one time

DYNAMIC CHARTING

• Additional functionality includes filters and ability to zoom in and analyze subsets of data within the chart

• Improved appearance of dynamic charting results

ADVANCED SEARCH

• Improved appearance and functionality includes ability for users to stretch results for easier analysis

• Users will be able to search within ‘All Schools’ when they have access to more than one location

DYNAMIC TAB NAMES

• Dynamic tab naming displays the contents of a predetermined field as tab label (examples are IEP Subject areas and IPP goals)

BUG FIXES

• Homescreen - Link from names on main listing screen work when there is an apostrophe in the name

VERSION 3.0 RELEASE NOTES

Version 3.4

Release Date: June 13 2011

IMPROVED RECORD MANAGEMENT

• Ability to create a new record from an existing record, and view record history for all plan records

MAPLEWOOD INTEGRATION ROUTINES

• Improved integration routines will allow for automatic, scheduled daily updates to student and staff biographical information

NEW TPM MENU SYSTEM

• New user friendly menu system to keep links organized

SPELL CHECKING

• Implementation of spell checker on all templates

BUG FIXES

• Advanced search consistently lists values on groups of checkboxes

• Can search by student number when adding a student to a grouping

• Included a text label to specify the current initiative on all templates (where did not already exist)

Version 3.3

Release Date: March 2011

PASSWORD CHANGE SCREEN

• New screen to allow users to change their own passwords

SAVING

• New feature added to the auto save functionality to detect a failed save and automatically retry until successful, up to 5 times.

• TPM will detect if a user has attempted to navigate off a page with unsaved information. After 5 unsuccessful attempts to save the data, the user is informed that a communication error has occurred.

REQUIRED FIELDS

• TPM data entry fields can be flagged as required and inform the user if they attempt to navigate off a page without filling in a required field

USER MODULE

• Graphical User Interface allows faster additions/modifications to user accounts. This will reduce the wait time for LS Team to create user accounts.

• The user admin module will be available to clients to manage their own user accounts in the TPM v4 – August 2011

ADVANCED SEARCH

• Advanced search now supports filters and display of check box searches, as well as customizable Criteria type boxes

DYNAMIC CHARTING

• Formatting improvements applied to the dynamic charting functionality

QUICK SEARCH

• Search is triggered when the user enters search criteria and hits the enter key (rather than needing to click the Search button) Improved appearance and functionality

EXPORT TO CSV, PDF

• Users now have the ability to save Advanced Search results to CSV or PDF