Welcome, Guest
Username: Password: Remember me

TOPIC: error message on attempt to import question

error message on attempt to import question 2 years 5 months ago #81731

  • Psyleigh
  • Psyleigh's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Sorry, importing questions is limited to the same version. Import failed.

I have downloaded an array in order to manually sort the 150 list items in then Excel spreadsheet. I try to upload the file using the Import feature, but I get the error message posted above.

The import worked at one point when I attempted to upload the same file to a test survey without sorting.
So there must be some tiny glitch, but I checked every detail and cannot find it.
The only change to the .csv file is the sort order of the 'answers" on the array.
Any clues to the meaning of this error message?
Last Edit: 2 years 5 months ago by Psyleigh. Reason: typo
The administrator has disabled public write access.

Re: error message on attempt to import question 2 years 5 months ago #81738

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
Do NEVER open or edit files with Excel. Excel breaks the internal data structure which is probably the reason why the import fails.

It might be far easier to copy the list from Excel and then use the quick add feature to add answer options and paste the list there.

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'"
The administrator has disabled public write access.

Re: error message on attempt to import question 2 years 5 months ago #81741

  • TMSWhite
  • TMSWhite's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 759
  • Thank you received: 82
  • Karma: 36
There is a new Excel import/export format (distinct from the traditional .lss format), but as Mazi said, if you're simply trying to re-order 150 list items, the quick-add feature is the easiest solution.
The administrator has disabled public write access.

Re: error message on attempt to import question 2 years 5 months ago #81748

  • Psyleigh
  • Psyleigh's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thank you. I tried opening the file in Libre office. Still did not work, but the error message changed to telling me my file was not a Lime Survey question file. Guess I will keep trying or sort the list manually.
The administrator has disabled public write access.

Re: error message on attempt to import question 2 years 5 months ago #81749

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2951
  • Thank you received: 378
  • Karma: 124
If it is only for inserting the item you could always use the quick insert feature of the newer versions of LS. Not solving the actual problem, but probably even better and quicker.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.124 seconds
Donation Image