LimeSurvey Sync

The LimeSurvey Sync module allows to connect the LimeSurvey software (a free and open source Survey application) and the Drupal software together.
In order to use this module, you have to download and install the LimeSurvey software on a server (in a distinct folder than the Drupal one).
Once installed your LimeSurvey site, the table below helps to correctly configure the synchronization process.

Testing interface

Show testing results for synchronization between your Drupal site and your LimeSurvey site.
Any test should fail.

Tested property	Test result	Comment	Edit	Help
1) The LimeSurvey database connection		The LimeSurvey and the Drupal sites are sharing the same hosting server The database connection has succeeded. The 'surveys' database table of the LimeSurvey site has been successfully found.	Set the LimeSurvey database informations LimeSurvey database connexion parameters will be generated according to the datas below and will be saved into the settings.php Drupal file. Datas should match the ones from the application/config/config.php LimeSurvey file The LimeSuvey site and this Drupal site are using the same hosting server, database type (mysql) and database LimeSurvey site Database type * MySQL, MariaDB, or equivalent SQLite The type of database your LimeSurvey data will be stored in. MySQL, MariaDB, or equivalent settings Your LimeSurvey site database name The name of the database your LimeSurvey data is stored in. Your LimeSurvey site database username Your LimeSurvey site database password Your LimeSurvey site table prefix a table prefix such as lime_ for your LimeSurvey site here. Advanced options These options are only necessary for some sites. If you're not sure what you should enter here, leave the default settings or check with your hosting provider. Your LimeSurvey site database host If your database is located on a different server, change this. Your LimeSurvey site database port If your database server is listening to a non-standard port, enter its number. SQLite settings Your LimeSurvey site database file The name of the database your LimeSurvey data is stored in. Your LimeSurvey site table prefix a table prefix such as lime_ for your LimeSurvey site here.	The LimeSurvey database connection informations must be appended into the sites/default/settings.php Drupal file, as the $databases['ls']['default'] variable, replacing each data ('driver', 'database', 'username', 'password', 'host') by the correct value from the config.php LimeSurvey file. Concerning the LimeSurvey database prefix value, you can find it opening the config.php file stored into your LimeSurvey site folder (it is the $dbprefix variable value). Note that if you host your LimeSurvey site and your Drupal site on the same database, you have to choose distinct prefix. If the 'survey' database table is not found : make sure if you have correctly installed the LimeSurvey software and set the right database prefix. This step requires write permissions to sites/default/settings.php. If you are unsure how to grant file permissions, consult the online handbook.
2) The LimeSurvey site url		The LimeSurvey site page has been successfully reached Tested url is : http://drupal-limesurvey-synchronization.com/limesurvey/admin/admin.php.	LimeSurvey site path It can be a relative path or an external website	If it fails, you may need to check the LimeSurvey site path setting and save it on the current page.
3) Softwares synchronized on time		Your Drupal site and your LimeSurvey site are synchronized.	The LimeSurvey Server time value is Fri, 02/14/2014 - 21:41 Yes No Visit the LimeSurvey global setting page, looking for the LimeSurvey Server time value. Select the right LimeSurvey Server time value and submit the page Thu, 02/13/2014 - 21:41Thu, 02/13/2014 - 22:41Thu, 02/13/2014 - 23:41Fri, 02/14/2014 - 00:41Fri, 02/14/2014 - 01:41Fri, 02/14/2014 - 02:41Fri, 02/14/2014 - 03:41Fri, 02/14/2014 - 04:41Fri, 02/14/2014 - 05:41Fri, 02/14/2014 - 06:41Fri, 02/14/2014 - 07:41Fri, 02/14/2014 - 08:41Fri, 02/14/2014 - 09:41Fri, 02/14/2014 - 10:41Fri, 02/14/2014 - 11:41Fri, 02/14/2014 - 12:41Fri, 02/14/2014 - 13:41Fri, 02/14/2014 - 14:41Fri, 02/14/2014 - 15:41Fri, 02/14/2014 - 16:41Fri, 02/14/2014 - 17:41Fri, 02/14/2014 - 18:41Fri, 02/14/2014 - 19:41Fri, 02/14/2014 - 20:41Fri, 02/14/2014 - 21:41Fri, 02/14/2014 - 22:41Fri, 02/14/2014 - 23:41Sat, 02/15/2014 - 00:41Sat, 02/15/2014 - 01:41Sat, 02/15/2014 - 02:41Sat, 02/15/2014 - 03:41Sat, 02/15/2014 - 04:41Sat, 02/15/2014 - 05:41Sat, 02/15/2014 - 06:41Sat, 02/15/2014 - 07:41Sat, 02/15/2014 - 08:41Sat, 02/15/2014 - 09:41Sat, 02/15/2014 - 10:41Sat, 02/15/2014 - 11:41Sat, 02/15/2014 - 12:41Sat, 02/15/2014 - 13:41Sat, 02/15/2014 - 14:41Sat, 02/15/2014 - 15:41Sat, 02/15/2014 - 16:41Sat, 02/15/2014 - 17:41Sat, 02/15/2014 - 18:41Sat, 02/15/2014 - 19:41Sat, 02/15/2014 - 20:41Sat, 02/15/2014 - 21:41Custom Tip time between the Drupal server and the LimeSurvey server second The LimeSurvey Time difference value can be edited on the LimeSurvey global setting page	Your LimeSurvey site and your Drupal site must be synchronized, the server times and timezone settings taken into account. You should make sure your Drupal default timezone setting is correctly set. Note : on Daylight Saving Time changes, you may need to edit your Drupal and LimeSurvey timezones values. The default value for the LimeSurvey Time difference setting is 1 hour.