Welcome to the LimeSurvey Community Forum

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

Error happens when export survey with txt and import it to Limesurvey cloud

  • LISHANGQI
  • LISHANGQI's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 years 8 months ago - 2 years 8 months ago #224800 by LISHANGQI
Please help us help you and fill where relevant:
Your LimeSurvey version: Version 3.27.35
Own server or LimeSurvey hosting: Own
Theme: 
fruity
==================

Hi there, 

I'm facing a problem when I export my survey with txt format (3.27.35) and reimport it to my own limesurvey cloud account(also 3.27.35) after a little revision such as changing a question code or deleting the column of the"Mandatory"  just as the manual instructed. My survey has two languages English and Dutch, if I change a question code both in English and Dutch, then their is a warning:  Error: Failed to insert question group data. It can be seen that all of the question groups are empty.

And if I only change a question code in English, or delete the column of "Mandatory", then even less data is imported.

So I'm very curious why this happens... 
Thanks in advance if anyone knows the reason.

Best regards,
Shangqi 
 
Last edit: 2 years 8 months ago by LISHANGQI.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 8 months ago #224805 by tpartner
If hosted at LimeSurvey GmbH, contact their support directly - account.limesurvey.org/customer-support

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • LISHANGQI
  • LISHANGQI's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 years 8 months ago #224809 by LISHANGQI
Hi tpartner I export my survey from my own server hosting but since I'm not authorized to create a survey I have to import it to a free account on GmbH..
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 8 months ago #224819 by tpartner
You may be missing an incidence of the question code.

Why not leave the text file unedited, import it and make changes in the GUI.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • LISHANGQI
  • LISHANGQI's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 years 8 months ago #224821 by LISHANGQI
I meant to do a "Looping" and it is suggested by the manual and some experts in the forum to export the txt format of survey and editor directly. But when I tired I found it is even impossibe to change even a question code.. Now I'm just curious about the reason:)
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
2 years 8 months ago #224834 by DenisChenu
In general, currently : i delete the 2 first columns on TXT file

If you do just this without updating anything else : it's OK ?

remind to save as TXT/utf8 with excel.
Best is to use LibreOffice Calc.

If remove the 2 columns fix the issue : please repôrt the issue …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
  • LISHANGQI
  • LISHANGQI's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 years 8 months ago - 2 years 8 months ago #224918 by LISHANGQI
Hi Denis,
Thanks for your reply.

To test, I first exported my survey and imported it to another account on LS cloud. It works.

Then I tried deleting the first two columns and switching to LibreOffice, but the survey still could not be imported successfully after deleting the column " Mandatory."

But never mind, I can continue with my work in GUI. Thanks again!
Last edit: 2 years 8 months ago by LISHANGQI.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
2 years 8 months ago - 2 years 8 months ago #224919 by DenisChenu
Why you delete mandtory column ?

The 1st 2 column (uneeded) are is and related_id : this 2 columns make TSV edit more complcated.

Else : TSV export/import are done to have a solution to edit a survey more easily. If it's not easy : it's an issue …
PS : use LibreOffice in place of Excel is easy step in my opinion :D ;)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
Last edit: 2 years 8 months ago by DenisChenu.
The topic has been locked.
  • LISHANGQI
  • LISHANGQI's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
2 years 8 months ago #224939 by LISHANGQI
The reason is...
In the beginning, I tried to edit the txt-survey since I need to do a looping in my survey , I copied question groups manually but I find it's really time-consuming to copy and import and change the question codes one by one, then I found this solution in the forum. But when I did it the error comes, I'm not sure if its because of my wrong operation, therefore I follow the manual to delete the "Mandatory column" to see if it would work:

"Testing mandatory questions. A common complaint is not the need to make many questions mandatory, but the need to turn off the mandatory feature for testing. Simply create the master spreadsheet with mandatory set to the final desired values. Then, to test it, just delete the "mandatory" column and save the test version of the spreadsheet. When you import that version, none of the questions will be mandatory. After you have finished your testing, import the master copy." 

Yes but if the feature can really work it will really save time. :)
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 8 months ago #224941 by tpartner
Don't delete the mandatory column. Instead, change the values there from "Y" to "N" if you want non-mandatory questions.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
2 years 8 months ago #224946 by DenisChenu
Or leav empty if i don't make error ?

But i think we don't need whole column by default (without debug mode), debug is set ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose