import of questions starting from LibO Calc / MS Excel or WORD/WRITER

More
4 years 6 days ago #93893 by ROSt52
Is there a way to create a survey (groups and questions only) in a spreadsheet and converting this to an lss-file for import?

Any other idea is welcome as well.

Thanks in advance for your help

Please Log in to join the conversation.

More
4 years 6 days ago #93901 by DenisChenu
Look at tsv import export feature.

TSV: Tab Separated Value
Named excel in documentation, but it's a bad name
docs.limesurvey.org/Excel+Survey+Structure

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).

Please Log in to join the conversation.

More
4 years 6 days ago #93907 by ROSt52
Thanks a lot for this very interesting information. I will now upgrade and test!

Please Log in to join the conversation.

More
3 years 8 months ago #98310 by ROSt52
Dear Denis,

Again thanks for your hints a while ago.

I upgraded to Version 2.00+ Build 130406

To understand how I have to import questions, I created a small survey (base language = Japanese) which works nice.

This survey I exported as a tab separated file which comes with the extension txt. As import requires a Tab separated file with extension csv, I just renamed the extension.

Next, I created a new survey (base language = Japanese). When I needed to add the first question group I selected import question group. Required file is csv extension but from the manual I understand it must be a tab separated content.

When I upload the file I get the error message: "You can't import a group which doesn't support at least the survey base language."

In both surveys I have the same base language = Japanese.

I appreciate any help as I need to import sooner a large survey.

Please Log in to join the conversation.

More
3 years 8 months ago #98311 by Mazi

ROSt52 wrote: This survey I exported as a tab separated file which comes with the extension txt. As import requires a Tab separated file with extension csv, I just renamed the extension.

This will not work. You can't change the internal file structure by just changing the file extension.

Generally, the Excel survey import feature work for whole surveys only. For importing questions or question groups, Limesurvey uses in internal, XML based file structure (.LSQ and .LSG files).

The error message seems to be a little misleading.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
3 years 8 months ago #98358 by ROSt52
Hi Mazi,

Thank you very much for your reply. I was afraid that something like this applies.

If I now want to translate questions (eg. English to Japanese), How can I import the questions in Japanese?

When I want to create a new question group there is the possibility to import a group (or even groups???) How can I do this?

And then the same applies for questions. How can I import questions? What is the data structure needed and format needed for such an import?

Please Log in to join the conversation.