queXS 1.8.0 has been released today on Sourceforge
New features include the ability to limit operators to view particular sample fields (available when importing a sample and also when managing existing samples). Also new is the "case status and assignment" function which allows for viewing of when cases will be available to operators, and the ability to assign the cases to particular operators for accessing right away (useful when managing very small samples, or near the end of a sample).
Read on for more details including how to upgrade from queXS 1.7.x (Database update required)
Upgrading from queXS 1.7.x
- Browse to the queXS administration page
- Click on "Start and monitor system wide case sorting"
- Confirm that the sorting process is stopped
- Click on "Start and monitor VoIP"
- Confirm that the VoIP process is stopped
- IMPORTANT: Backup your database and files
- Run the following SQL on the queXS database:
CREATE TABLE IF NOT EXISTS `case_queue` ( `case_queue_id` bigint(20) NOT NULL AUTO_INCREMENT, `case_id` bigint(20) NOT NULL, `operator_id` bigint(20) NOT NULL, `sortorder` int(11) NOT NULL, PRIMARY KEY (`case_queue_id`), UNIQUE KEY `case_id` (`case_id`), KEY `operator_id` (`operator_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;CREATE TABLE IF NOT EXISTS `sample_import_var_restrict` ( `sample_import_id` bigint(20) NOT NULL, `var` char(128) collate utf8_unicode_ci NOT NULL, `restrict` tinyint(1) NOT NULL default '0', PRIMARY KEY (`sample_import_id`,`var`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- Rename the queXS 1.7.x directory
- Extract quexs-1.8.0 to a new directory on your web server
- Rename the new directory to the same as the existing installation was originally
- Copy the config.inc.local.php file from the queXS 1.7.x installation to this directory
- If you used .htaccess files, copy these to their respective directories also, for example: .htaccess admin/.htaccess client/.htaccess include/limesurvey/admin/.htaccess