Actions

Difference between revisions of "Alternatives to the LimeSurvey import function"

From LimeSurvey Manual

Line 7: Line 7:
 
*v1.50 or later .CSV files created by LimeSurvey
 
*v1.50 or later .CSV files created by LimeSurvey
 
*v1.90 or later .LSS files created by LimeSurvey
 
*v1.90 or later .LSS files created by LimeSurvey
 +
*v2.0 or later (or via patch to 1.92+) [[Excel Survey Structure|.XLS files]] created by LimeSurvey
  
 
That way you can import old surveys from previous version. The import 'intelligently' re-numbers the survey, group, question, answer and condition IDs so that they all match each other - '''no existing surveys will be overwritten'''. See section on [[Exporting a survey structure]] for more information.
 
That way you can import old surveys from previous version. The import 'intelligently' re-numbers the survey, group, question, answer and condition IDs so that they all match each other - '''no existing surveys will be overwritten'''. See section on [[Exporting a survey structure]] for more information.

Revision as of 20:10, 15 April 2012

Import using the administration interface

If you have previously exported a survey structure, you can import it from the "New Survey" screen. Click on the browse button to choose the SQL/CSV file, and then click on the button. The import process reads the following formats:

  • v1.50 or later .CSV files created by LimeSurvey
  • v1.90 or later .LSS files created by LimeSurvey
  • v2.0 or later (or via patch to 1.92+) .XLS files created by LimeSurvey

That way you can import old surveys from previous version. The import 'intelligently' re-numbers the survey, group, question, answer and condition IDs so that they all match each other - no existing surveys will be overwritten. See section on Exporting a survey structure for more information.

Import using the commandline utility

Since version 1.50 it is possible to import surveys from the command line (or shell). To use this functionality you have to have access to the shell and the PHP interpreter has to be configured to allow shell execution of scripts.

This functionality is useful when you have timeout problems with the web version that could happen when you have very long surveys to import.

To use it, in the shell go to the limesurvey/admin folder and execute:

php cmdline_importsurvey <File to import> [<user> <password>]

  • <File to import> has to be one of the described above
  • <user> has to be a user with the right to create surveys
  • <password> the password for the user
    *<user> and <password> are only required if the control access is active

If you need to see the parameters you can execute:

php cmdline_importsurvey -h

Importing surveys from other applications

We are often getting requests to import a survey from other applications or survey providers. The problem is that providers like SurveyMonkey lock you in - it is not possible to export the survey structure from SurveyMonkey, only the response data. So you can see that using non-open propietary software or providers can be a bad idea in the first place.