queXS 2.0.0 has been released today!
queXS 2.0.0 removes the included version of Limesurvey 1.91+ and instead relies on an existing install of Limesurvey of at least version 2.0.6, with the JSON remote control API enabled to collect data.
Therefore queXS 2.0.0 has an additional requirement of a separate installation of Limesurvey with the JSON RPC API enabled.
The advantage of this is being able to use a more modern version of Limesurvey, or being able to "add on" CATI functionality to an existing Limesurvey web only installation.
Both the 1.x and 2.x branches will continue to be maintained for now. Be warned: If you choose to upgrade to the 2.0.0 version, there is "no going back" unless you restore from a backup.
Due to the previous tight integration of queXS and Limesurvey, some notable features are NOT supported in the 2.x series, including:
- Data export:
* Exporting data "by sample" or "by questionnaire" from Limesurvey directly
* queXS paradata export from within Limesurvey
- Integration:
* {SAMPLE:xxx} replacement fields in Limesurvey (you will need to replace these with {TOKEN:attribute_1}, {TOKEN:attribute_2}, etc)
* queXS replacement fields including: CALLATTEMPTS, ONAPPOINTMENT, PERIODOFDAY, APPOINTMENTDATE, APPOINTMENTTIME, APPOINTMENTNUMBER, PERCCOMPLETE, ENDINTERVIEWURL, STARTINTERVIEWURL
* Altering of template / mode of delivery for self complete surveys versus interviewer administered surveys
- Interface:
* Automatically proceeding to next question on answer selection (no need to press "NEXT")
* Custom limesurvey 1.92+ templates will not work with the latest Limesurvey
Please note that you may be able to implement some of these in Limesurvey directly or work around them. If they are critical for your operations, please choose the latest 1.x branch of queXS and/or do not proceed with the upgrade to queXS 2.0.0
Upgrade procedure from 1.15.0 to 2.0.0:
- Browse to System settings and stop the system wide case sorting process
- Browse to VoIP settings (if enabled) and stop the VoIP monitoring process
- IMPORTANT: Backup the queXS database
- IMPORTANT: Backup the queXS files
- Run the following commands on your database:
CREATE TABLE `remote` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`rpc_url` text COLLATE utf8_unicode_ci NOT NULL,
`username` text COLLATE utf8_unicode_ci NOT NULL,
`password` text COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'limesurvey' COMMENT 'type of host',
`entry_url` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'entry url for interviewers',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;CREATE TABLE `users` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`users_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` blob NOT NULL,
`full_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(320) COLLATE utf8_unicode_ci DEFAULT NULL,
`superadmin` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `users_name` (`users_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;INSERT INTO `users` (uid,users_name,password,full_name,email,superadmin)
SELECT uid,users_name,password,full_name,email,superadmin
FROM lime_users;CREATE TABLE `failed_login_attempts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(37) COLLATE utf8_unicode_ci NOT NULL,
`last_attempt` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`number_attempts` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;ALTER TABLE `questionnaire` ADD `remote_id` INT NOT NULL DEFAULT '1', ADD INDEX ( `remote_id`);
ALTER TABLE lime_saved_control DROP INDEX identifier;
- Download the latest version of Limesurvey: https://www.limesurvey.org/stable-release (This was tested with 2.64.1+170310)
- Extract the Limesurvey package to your webserver (separate directory to queXS)
- Edit the Limesurvey file: application/controllers/admin/databaseupdate.php
Comment out the line: $this->_renderWrappedTemplate('update', $aViewUrls, $aData);
Uncomment the following lines:
//$aData = array_merge($aData, $aViewUrls);
//Yii::app()->getController()->renderPartial('databaseupdate/db', $aData);
- Give write permissions to tmp, upload, template, third_party/kcfinder/cache and application/config Limesurvey directories
- - For example in Ubuntu:
- chown www-data:www-data -R tmp
- chown www-data:www-data -R upload
- chown www-data:www-data -R application/config
- chown www-data:www-data -R templates
- chown www-data:www-data -R third_party/kcfinder/cache/
- Browse to the Limesurvey installation and proceed with the installation up until the Database configuration page
- Enter in the database settings from your queXS installation (see the queXS config.inc.local.php file for details)
- Confirm the "table prefix" matches the default of: lime_
- Proceed to database upgrade
- Log in as the administrative user (default from queXS was: admin/password)
- Browse to Configuration -> Global Settings -> Interfaces
- Enable the JSON-RPC interface, and click on "Save"
- Take note of the URL, eg: https://localhost/limesurvey/index.php/admin/remotecontrol
Modify the the following SQL to suit your URL, username and password, then run it on the queXS database:INSERT INTO `remote` (id,description,rpc_url,username,password,entry_url)
VALUES (1,'Limesurvey','https://localhost/limesurvey/index.php/admin/remotecontrol','admin','password','https://localhost/limesurvey/index.php');
- Take note of your new queXS URL, eg: https://localhost/quexs
Modify the following SQL to suit your queXS URL, then run it on the database:UPDATE `lime_surveys_languagesettings`
SET surveyls_url = 'https://localhost/quexs/rs_project_end.php'
WHERE surveyls_url = '{ENDINTERVIEWURL}';
- Extract queXS 2.0.0 to a directory on your web server
- Copy the config.inc.local.php file from your existing queXS installation
- Update the QUEXS_PATH config directive in config.inc.local.php if the path has changed
- Browse to the queXS 2.0.0 system in your browser
- Log in