Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Importing a survey

  • nenneke
  • nenneke's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago #143320 by nenneke
Importing a survey was created by nenneke
Hi,

I am trying to export, edit, and then import a survey.
I export the already created survey as a .txt file, then open it in Excel, and modify it. However, when I try to import it back into LimeSurvey, every time I receive an error message, saying:
The page badania.psych.pan.pl is not working
The server badania.psych.pan.pl cannot handle this request right now
HTTP ERROR 500

(badania.psych.pan.pl is the server LimeSurvey is installed on)
I figured that maybe there's something wrong with the modified file, so I tried importing a file where only the name of the survey was modified. The same happened.

After the message is displayed, I refresh the page - the LimeSurvey interface appears, saying:
***Success***
The file was uploaded successfully. Reading the file...
***Success***
Surveys:
Languages:
Question groups:
Questions:
Question attributes:
Answers:
Answer evaluations:
Quotas: ( quota members and language settings

"Go to survey" button that is displayed below does not work.
The imported survey does not appear on the survey list.

Also cutting the file to make it shorter (removing most of the questions) did not help.
The survey includes flash files that were added by the "add flash" button in the question window, and then indicating the URL of the previously uploaded flash files. I work on the 2.05+ Build 140703 version.
The original survey works fine.
Importing a simple survey with just one question and no flash files looks the same, BUT after refreshing the page (after the server error message), the survey DOES appear in the survey list.

I attach the file I am trying to import - the full and the short version (short=just 5 questions left, all the flash file URLs removed).

Can you give me any advice as to what might be wrong?
Thank you in advance.
Best,
Ewa
The topic has been locked.
  • elissa
  • elissa's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 4 months ago #143389 by elissa
Replied by elissa on topic Importing a survey
Hi,

I'm afraid that I cannot help but here are some my observations. I use LS 2.06lts Build 160801 and I imported both your surveys without any error or warning message.

1. Both surveys have expiration date so they appear on the list of inactive surveys.
2. In the longer survey all Polish specific characters and everything after them in a line were cut (dropped). This seems that the character coding after exporting from Excel changed. I think that this may cause some trouble. I usually use Open Office Calc to modify LS files (tokens) instead of Excel bacause I feel that I have more control over the coding ;-).
3. In the shorter survey all Polish texts look fine.
4. I cannot see the flash files but they are on your server and I don't have the full path. When you import the survey the number of the survey changes. However, the path to the flash file in a question does not change. But I assume that the path is still valid after import.

Best regards

Elzbieta Lesinska
LS voluntary Polish translator and supervisor
The following user(s) said Thank You: DenisChenu, nenneke
The topic has been locked.
More
7 years 2 months ago #146797 by AnnaBH
Replied by AnnaBH on topic Importing a survey
I sit with the same problem :/ Did you find a way?
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 2 months ago #146810 by LouisGac
Replied by LouisGac on topic Importing a survey
My bet: it's a problem with separators and quotes ( ' or " or , or ; etc)
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 2 months ago #146847 by DenisChenu
Replied by DenisChenu on topic Importing a survey
Or memory issue (big survey, less memory) for 500 error.

manual.limesurvey.org/Debug_mode

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
More
7 years 2 months ago #146933 by AnnaBH
Replied by AnnaBH on topic Importing a survey
In my case its not a memory issue. And I can´t understand how it can be a separator problem either. I haven´t changed the survey. What I want to do is to join several different surveys into one large. It is exactly the same questions in all surveys. But I fail whatever I do :/
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 2 months ago #146934 by LouisGac
Replied by LouisGac on topic Importing a survey

AnnaBH wrote: how it can be a separator problem either. I haven´t changed the survey.

Opening and saving a csv file in excel is enough to update all its separator, without doing anything else.
The topic has been locked.
More
7 years 2 months ago #146935 by AnnaBH
Replied by AnnaBH on topic Importing a survey
But how can it be a problem when I use LImesurveys own import and export functions? When I try to import a survey I exported just minutes ago I get the answer that "This is not a Limesurvey survey file."?
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 2 months ago #146936 by LouisGac
Replied by LouisGac on topic Importing a survey

AnnaBH wrote: But how can it be a problem when I use LImesurveys own import and export functions? When I try to import a survey I exported just minutes ago I get the answer that "This is not a Limesurvey survey file."?


that's different... what LimeSurvey build are you using?
The topic has been locked.
More
7 years 2 months ago #146937 by AnnaBH
Replied by AnnaBH on topic Importing a survey
It´s an old one I´m afraid :/ Version 2.00+ Build 130708 I have installed it on my virtual server (or someone did it for me) and I cant update it myself. I will have it done in a few weeks but not now.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 2 months ago #146938 by LouisGac
Replied by LouisGac on topic Importing a survey
Then, there is nothing I can do...

I can only suggest you to use limesurvey professional hosting:
www.limesurvey.org/services#pricingHostedSubscription
The topic has been locked.
More
7 years 2 months ago #146939 by AnnaBH
Replied by AnnaBH on topic Importing a survey
ok. Thank´s anyway.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose