Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

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

import of questions starting from LibO Calc / MS Excel or WORD/WRITER il y a 1 an 1 mois #93893

  • ROSt52
  • Portrait de ROSt52
  • Hors ligne
  • Senior Lime
  • Messages : 57
  • Remerciements reçus 1
  • Karma: 0
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
L'administrateur a désactivé l'accès en écriture pour le public.

import of questions starting from LibO Calc / MS Excel or WORD/WRITER il y a 1 an 1 mois #93901

  • DenisChenu
  • Portrait de DenisChenu
  • Hors ligne
  • Moderator Lime
  • Messages : 5843
  • Remerciements reçus 715
  • Karma: 222
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
L'administrateur a désactivé l'accès en écriture pour le public.

import of questions starting from LibO Calc / MS Excel or WORD/WRITER il y a 1 an 1 mois #93907

  • ROSt52
  • Portrait de ROSt52
  • Hors ligne
  • Senior Lime
  • Messages : 57
  • Remerciements reçus 1
  • Karma: 0
Thanks a lot for this very interesting information. I will now upgrade and test!
L'administrateur a désactivé l'accès en écriture pour le public.

import of questions starting from LibO Calc / MS Excel or WORD/WRITER il y a 8 mois 4 semaines #98310

  • ROSt52
  • Portrait de ROSt52
  • Hors ligne
  • Senior Lime
  • Messages : 57
  • Remerciements reçus 1
  • Karma: 0
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.
L'administrateur a désactivé l'accès en écriture pour le public.

import of questions starting from LibO Calc / MS Excel or WORD/WRITER il y a 8 mois 4 semaines #98311

  • Mazi
  • Portrait de Mazi
  • Hors ligne
  • LimeSurvey Team
  • Messages : 5279
  • Remerciements reçus 289
  • Karma: 246
ROSt52 écrit:
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)limesurvey.org'"
L'administrateur a désactivé l'accès en écriture pour le public.

import of questions starting from LibO Calc / MS Excel or WORD/WRITER il y a 8 mois 3 semaines #98358

  • ROSt52
  • Portrait de ROSt52
  • Hors ligne
  • Senior Lime
  • Messages : 57
  • Remerciements reçus 1
  • Karma: 0
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?
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.164 secondes
Donation Image