queXS 0.9.6 (Release Candidate 2) Released

queXS 0.9.6 has been released on SourceForge today.

New features:

  • Lithuanian Translation (Thank you zimi)
  • As many strings as possible made available for translation (see lang.inc.php)
  • Quota management (stop calling a sample when a quota is reached)
  • Quota row management (stop calling selected parts of a sample when a quota is reached)
  • No login required for LimeSurvey (if permissions granted in queXS)
  • Link from case management to modifying responses in LimeSurvey
  • Display outcomes by sample within a questionnaire
  • Display of appointments in supervisor mode

Bug fixes:

  • Licence updates to comply with FSF
  • Only return one record per sample record in samplesearch.php
  • Fixed case not ending on time bug (reported by zimi)
  • Fixed where 12pm showing up as 12am

Read more for how to upgrade from 0.9.5...

Upgrading from 0.9.5...

1. Copy config.inc.php to config.inc.php.bak
2. Extract the new package over the existing one
3. Execute the following SQL code on the queXS database:


CREATE TABLE IF NOT EXISTS `questionnaire_sample_quota` (
`questionnaire_sample_quota_id` bigint(20) NOT NULL auto_increment,
`questionnaire_id` bigint(20) NOT NULL,
`sample_import_id` bigint(20) NOT NULL,
`lime_sgqa` varchar(255) collate utf8_unicode_ci NOT NULL,
`value` varchar(2048) collate utf8_unicode_ci NOT NULL,
`comparison` varchar(15) collate utf8_unicode_ci NOT NULL default 'LIKE',
`completions` int(11) NOT NULL,
`quota_reached` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`questionnaire_sample_quota_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `questionnaire_sample_quota_row` (
`questionnaire_sample_quota_row_id` bigint(20) NOT NULL auto_increment,
`questionnaire_id` bigint(20) NOT NULL,
`sample_import_id` bigint(20) NOT NULL,
`lime_sgqa` varchar(255) collate utf8_unicode_ci NOT NULL,
`value` varchar(2048) collate utf8_unicode_ci NOT NULL,
`comparison` varchar(15) collate utf8_unicode_ci NOT NULL default 'LIKE',
`completions` int(11) NOT NULL,
`exclude_var` char(128) collate utf8_unicode_ci NOT NULL,
`exclude_val` varchar(256) collate utf8_unicode_ci NOT NULL,
`quota_reached` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`questionnaire_sample_quota_row_id`),
KEY `questionnaire_id` (`questionnaire_id`),
KEY `sample_import_id` (`sample_import_id`),
KEY `exclude_var` (`exclude_var`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

4. Copy config.inc.php.bak over the extracted config.inc.php file