Importing a survey

More
1 year 1 month ago #143320 by nenneke
nenneke created the topic: Importing a survey
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
Attachments:

Please Log in to join the conversation.

More
1 year 4 weeks ago #143389 by elissa
elissa replied the 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 Polish translator and supervisor
The following user(s) said Thank You: DenisChenu, nenneke

Please Log in to join the conversation.

More
10 months 1 week ago #146797 by AnnaBH
AnnaBH replied the topic: Importing a survey
I sit with the same problem :/ Did you find a way?

Please Log in to join the conversation.

More
10 months 1 week ago #146810 by LouisGac
LouisGac replied the topic: Importing a survey
My bet: it's a problem with separators and quotes ( ' or " or , or ; etc)

Please Log in to join the conversation.

More
10 months 1 week ago #146847 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
10 months 1 week ago #146933 by AnnaBH
AnnaBH replied the 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 :/

Please Log in to join the conversation.

More
10 months 1 week ago #146934 by LouisGac
LouisGac replied the 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.

Please Log in to join the conversation.

More
10 months 1 week ago #146935 by AnnaBH
AnnaBH replied the 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."?

Please Log in to join the conversation.

More
10 months 1 week ago #146936 by LouisGac
LouisGac replied the 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?

Please Log in to join the conversation.

More
10 months 1 week ago #146937 by AnnaBH
AnnaBH replied the 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.

Please Log in to join the conversation.

More
10 months 1 week ago #146938 by LouisGac
LouisGac replied the 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

Please Log in to join the conversation.

More
10 months 1 week ago #146939 by AnnaBH
AnnaBH replied the topic: Importing a survey
ok. Thank´s anyway.

Please Log in to join the conversation.

More
10 months 1 week ago #146944 by nenneke
nenneke replied the topic: Importing a survey
Hi,
no, I didn't find a solution. After many trials that did not work, I did all the work manually... :(
I tried changing the coding in Excel, changing separators etc - nothing helped.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!