queXS 1.11.0 Released

Submitted by adamzammit on Fri, 2014-12-19 16:07

queXS 1.11.0 has been released today on Sourceforge

queXS now supports time slots for cases. This allows for time slots to be defined, and the call scheduler will make sure cases are assigned to be called equally over all timeslots. System sorting has been improved to work on a questionnaire by questionnaire basis which reduces down time for interviewers while the system sorts. The default timezone is now defined in the administrative menu instead of from the configuration file.

Many bugs have been fixed including quota completions now displaying above 100%, and VoIP integration correctly working in Asterisk 11.

Translations have also been updated from Launchpad - Thank you for your contributions, especially for the complete Russian translation.

Read on for more details including how to upgrade from queXS 1.10.x (Database update required)

Upgrading from queXS 1.10.x

  1. Browse to the queXS administration page
  2. Click on "Start and monitor system wide case sorting"
  3. Confirm that the sorting process is stopped
  4. Click on "Start and monitor VoIP"
  5. Confirm that the VoIP process is stopped
  6. IMPORTANT: Backup your database and files
  7. Run the following SQL on the queXS database:

    ALTER TABLE `questionnaire_sample` ADD `allow_new` TINYINT( 1 ) NOT NULL DEFAULT '1';

    CREATE TABLE `questionnaire_timeslot` (
    `questionnaire_id` bigint( 20 ) NOT NULL ,
    `availability_group_id` bigint( 20 ) NOT NULL ,
    PRIMARY KEY ( `questionnaire_id` , `availability_group_id` )
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;

    INSERT INTO `setting` (`setting_id`,`field`,`value`)
    VALUES (NULL , 'DEFAULT_TIME_ZONE', 's:18:"Australia/Victoria";');

  8. Rename the queXS 1.10.x directory
  9. Extract quexs-1.11.0 to a new directory on your web server
  10. Rename the new directory to the same as the existing installation was originally
  11. Copy the config.inc.local.php file from the queXS 1.10.x installation to this directory
  12. If you used .htaccess files, copy these to their respective directories also, for example: .htaccess admin/.htaccess client/.htaccess include/limesurvey/admin/.htaccess