Check out the LimeSurvey source code on GitHub!

Problems importing tab delimited text files

4 years 3 months ago #86266 by olliebown
I am trying to export and then reimport a survey with lots of added questions. I have exported the survey to a txt file, opened it in Excel, added my survey questions and saved it again as a tab delimited text file (UTF-16 Unicode). When I import the survey back into lime survey the import appears to be successful (the report screen contains some information). However, the survey does not appear. I notice that if I simply export and then re-import it works fine.

I attach the file. The results of the import are as follows:

Surveys: 1
Languages: 1
Question groups: 1
Questions: 7
Question attributes: 7
Answers: 0
Subquestions: 0
Default answers: 7
Assessments: 0
Quotas: 0 (0 quota members and 0 quota language settings

Please Log in to join the conversation.

4 years 3 months ago - 4 years 3 months ago #86286 by TMSWhite
You've found a bug , which I reported on your behalf. It works fine in 1.92, but behaves exactly as you describe in 2.0

When I run the database consistency check, it appears that LS never creates the needed entry in the surveys table. There are rows for questions and attributes, but there is no matching surveyid.
Last Edit: 4 years 3 months ago by TMSWhite.

Please Log in to join the conversation.

4 years 3 months ago #86322 by olliebown
Thank you.

for the benefit of anyone else who has the same problem, here is a workaround.

In the bug discussion c_schmitz says "Datecreated field in the TSV contains an invalid date format". Just open the file in a text editor, search for "datecreated" and reformat the date to the form YYYY-MM-DD (mine was in the form DD/MM/YYYY).

I've now got my survey imported. Fingers crossed it's good to go.

It's a pleasure to be able to import from a spreadsheet like this.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form