View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
04136Bug reportsOtherpublic2010-02-15 16:142010-03-03 23:37
Reporterthozi Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.87+ 
Summary04136: Multilingual suvery import fails
Description

I experience exactly the same problem as reported here:

https://www.limesurvey.org/de/support/hilfe-foren/5-can-i-do-this-with-limesurvey/17495-done-import-multilingual-survey#17495

Unfortunately I cannot open the related bug. I get access denied. Is this solved? What can I do.

TagsNo tags attached.
Attached Files
G_GeneralFeeeback.csv (3,295 bytes)    
# LimeSurvey Group Dump
# DBVersion 142
# This is a dumped group from the LimeSurvey Script
# http://www.limesurvey.org/
# Do not change this header!

#
# GROUPS TABLE
#
"gid","sid","group_name","group_order","description","language"
"166","92331","Generelles Feedback","2","Bitte teilen Sie uns Ihr generelles Feedback &uuml;ber das Produkt mit. <br />","de"
"166","92331","General Feedback","2","Please provide general feedback about your experiences with the system so far. <br />","en"

#
# QUESTIONS TABLE
#
"qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language"
"626","92331","166","F","GenFeedback001","Bitte bewerten Sie Ihre Zufriedenheit mit dem Produkt anhand folgender Tabelle:<br />","","","N","N","28","0","0","de"
"626","92331","166","F","GenFeedback001","Please rate your satisfaction with the product based on the following categories and then submit your results and exit the test. <br />","","","N","N","28","0","0","en"
"627","92331","166","T","GenFeedback002","Bitte teilen Sie uns weiteres Feedback und Vorschl&auml;ge zur Verbesserung mit. Vielen Dank!<br />","","Ihre Vorschl&auml;ge sind willkommen! Wir werden sie enstprechend in zuk&uuml;nftigen Enwicklungen ber&uuml;cksichtigen. Bei R&uuml;ckfragen werden wir uns direkt mit Ihnen in Verbindung setzen. <br />","N","N","0","0","1","de"
"627","92331","166","T","GenFeedback002","Please provide any other comments or recommendation to use to improve the product. <br />","","Your input is highly appreciated! We will process your comments and consider it for future product improvements. If there is any clarification required, we will contact you directly. <br />","N","N","0","0","1","en"

#
# ANSWERS TABLE
#
"qid","code","answer","default_value","sortorder","assessment_value","language"
"626","1","Benutzerfreundlichkeit der Webseiten","N","1","0","de"
"626","1","Usability of the webpages","N","1","0","en"
"626","2","Geschwindigkeit","N","3","0","de"
"626","2","Performance of the system","N","3","0","en"
"626","3","Benutzerfreundlichkeit des Produkts","N","2","0","de"
"626","3","Usability of the product","N","2","0","en"

#
# CONDITIONS TABLE
#

#
# LABELSETS TABLE
#
"lid","label_name","languages"
"28","Array - 5 Point (poor to excellent)","en de"

#
# LABELS TABLE
#
"lid","code","title","sortorder","language","assessment_value"
"28","1","schlecht","0","de","1"
"28","1","poor","0","en","1"
"28","2","2","1","de","2"
"28","2","2","1","en","2"
"28","3","3","2","de","3"
"28","3","3","2","en","3"
"28","4","4","3","de","4"
"28","4","4","3","en","4"
"28","5","sehr gut","4","de","5"
"28","5","excellent","4","en","5"
"28","1","schlecht","0","de","1"
"28","1","poor","0","en","1"
"28","2","2","1","de","2"
"28","2","2","1","en","2"
"28","3","3","2","de","3"
"28","3","3","2","en","3"
"28","4","4","3","de","4"
"28","4","4","3","en","4"
"28","5","sehr gut","4","de","5"
"28","5","excellent","4","en","5"

#
# QUESTION_ATTRIBUTES TABLE
#
"qaid","qid","attribute","value"
"531","626","answer_width","60"
"531","626","answer_width","60"
"532","627","maximum_chars","100000"
"533","627","text_input_width","70"
"534","627","display_rows","25"
"532","627","maximum_chars","100000"
"533","627","text_input_width","70"
"534","627","display_rows","25"
G_GeneralFeeeback.csv (3,295 bytes)   
Q_RateYourSatisfaction.csv (1,682 bytes)    
# LimeSurvey Question Dump
# DBVersion 142
# This is a dumped question from the LimeSurvey Script
# http://www.limesurvey.org/
# Do not change this header!

#
# QUESTIONS TABLE
#
"qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language"
"626","92331","166","F","GenFeedback001","Bitte bewerten Sie Ihre Zufriedenheit mit dem Produkt anhand folgender Tabelle:<br />","","","N","N","28","0","0","de"
"626","92331","166","F","GenFeedback001","Please rate your satisfaction with the product based on the following categories and then submit your results and exit the test. <br />","","","N","N","28","0","0","en"

#
# ANSWERS TABLE
#
"qid","code","answer","default_value","sortorder","assessment_value","language"
"626","1","Benutzerfreundlichkeit der Webseiten","N","1","0","de"
"626","1","Usability of the webpages","N","1","0","en"
"626","2","Geschwindigkeit","N","3","0","de"
"626","2","Performance of the system","N","3","0","en"
"626","3","Benutzerfreundlichkeit des Produkts","N","2","0","de"
"626","3","Usability of the product","N","2","0","en"

#
# LABELSETS TABLE
#
"lid","label_name","languages"
"28","Array - 5 Point (poor to excellent)","en de"

#
# LABELS TABLE
#
"lid","code","title","sortorder","language","assessment_value"
"28","1","schlecht","0","de","1"
"28","1","poor","0","en","1"
"28","2","2","1","de","2"
"28","2","2","1","en","2"
"28","3","3","2","de","3"
"28","3","3","2","en","3"
"28","4","4","3","de","4"
"28","4","4","3","en","4"
"28","5","sehr gut","4","de","5"
"28","5","excellent","4","en","5"

#
# QUESTION_ATTRIBUTES TABLE
#
"qaid","qid","attribute","value"
"531","626","answer_width","60"
Q_RateYourSatisfaction.csv (1,682 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)8374
I will donate to the project if issue is resolved
BrowserFirefox
Database type & versionMSSQL 10
Server OS (if known)Windows Server 2007
Webserver software & version (if known)IIS
PHP Version5.2.10

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2010-02-15 17:28

  ~11106

The mentioned bug in the forum link is very old and was resolved in v1.71+.

Please attach a simple base sample survey (survey structure as .csv-file) and a step-by-step instruction how to reproduce the issue - THX!
thozi

thozi

2010-02-18 10:32

reporter   ~11126

Here's more info to debug. I'm able! to export and re-import the same bi-lingual survey w/o problem (example uploaded). However I'm not able to re-import a previously exported group or question. Examples are uploaded.

In both cases I get errors as pasted below:

Group import : G_GeneralFeedback.csv

Error: Failed to insert group
insert INTO lime_groups (gid,sid,group_name,group_order,description,language) VALUES ('169','92331','General Feedback','3','Please provide general feedback about your experiences with the system so far.
','en')
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'lime_groups' when IDENTITY_INSERT is set to OFF.

Question Import: Q_RateYourSatisfaction.csv

Error: Failed to insert question
INSERT INTO lime_questions (qid,sid,gid,type,title,question,preg,help,other,mandatory,lid,lid1,question_order,language) VALUES ('630','92331','166','F','GenFeedback001','Please rate your satisfaction with the product based on the following categories and then submit your results and exit the test.
','','','N','N','28','0','2','en')
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'lime_questions' when IDENTITY_INSERT is set to OFF.

user372

2010-02-23 08:43

  ~11152

@ c_schmitz: may you please have a look at this issue - I don't have MSSQL.
Mazi

Mazi

2010-02-26 00:16

updater   ~11178

Error message when importing the "csv file icon S_TestSurvyBilingualImport.csv" file:
Import of this survey file failed
[INSERT INTO lime_surveys (sid,owner_id,admin,active,adminemail,private,faxto,format,template,language,additional_languages,datestamp,usecookie,notification,allowregister,allowsave,autonumber_start,autoredirect,allowprev,printanswers,ipaddr,refurl,datecreated,listpublic,publicstatistics,publicgraphs,htmlemail,tokenanswerspersistence,assessments,usecaptcha,usetokens,bounce_email,attributedescriptions,lastpage,emailresponseto,tokenlength) VALUES ('92331','1','Thomas Zimmermann','N','Thomas.Zimmermann@voicecash.com','N','','G','bluengrey','en','de ','Y','N','2','N','Y','0','N','Y','Y','Y','Y','2009-09-11 00:00:00','N','N','N','Y','Y','Y','C','N','Thomas.Zimmermann@voicecash.com','','0','','15')]
"sid","owner_id","admin","active","startdate","expires","adminemail","private","faxto","format","template","language","additional_languages","datestamp","usecookie","notification","allowregister","allowsave","autonumber_start","autoredirect","allowprev","printanswers","ipaddr","refurl","datecreated","listpublic","publicstatistics","publicgraphs","htmlemail","tokenanswerspersistence","assessments","usecaptcha","usetokens","bounce_email","attributedescriptions","lastpage","emailresponseto","tokenlength"

[Microsoft][ODBC SQL Server Driver][SQL Server]Ung?ltiger Spaltenname 'lastpage'.
Mazi

Mazi

2010-02-26 00:17

updater   ~11179

Error message when importing the group:

File upload succeeded.

Reading file...

Import partially successful.

The following languages in this group were not imported since the survey does not contain such a language:
English

Group import summary

* Groups:1
* Questions: 2
* Answers: 3
* Conditions: 0
* Label set: 1 (Labels: 20)
* Question attributes: 8

Import of group is completed.
Mazi

Mazi

2010-02-26 00:19

updater   ~11180

The question imports fine without any problems.
c_schmitz

c_schmitz

2010-03-02 18:24

administrator   ~11197

Fixed in build 8448

Issue History

Date Modified Username Field Change
2010-02-15 16:14 thozi New Issue
2010-02-15 16:14 thozi Status new => assigned
2010-02-15 16:14 thozi Assigned To => user372
2010-02-15 16:14 thozi LimeSurvey build number => 8374
2010-02-15 16:14 thozi Browser => Firefox
2010-02-15 16:14 thozi Database & DB-Version => MSSQL 10
2010-02-15 16:14 thozi Operating System (Server) => Windows Server 2007
2010-02-15 16:14 thozi Webserver => IIS
2010-02-15 16:14 thozi PHP Version => 5.2.10
2010-02-15 17:28 user372 Note Added: 11106
2010-02-15 17:28 user372 Status assigned => feedback
2010-02-18 10:25 thozi File Added: S_TestSurvyBilingualImport.csv
2010-02-18 10:26 thozi File Added: G_GeneralFeeeback.csv
2010-02-18 10:26 thozi File Added: Q_RateYourSatisfaction.csv
2010-02-18 10:32 thozi Note Added: 11126
2010-02-23 08:43 user372 Note Added: 11152
2010-02-23 08:43 user372 Status feedback => assigned
2010-02-23 08:43 user372 Assigned To user372 => c_schmitz
2010-02-26 00:16 Mazi Note Added: 11178
2010-02-26 00:17 Mazi Note Added: 11179
2010-02-26 00:19 Mazi Note Added: 11180
2010-03-02 18:24 c_schmitz Note Added: 11197
2010-03-02 18:24 c_schmitz Status assigned => resolved
2010-03-02 18:24 c_schmitz Fixed in Version => 1.87+
2010-03-02 18:24 c_schmitz Resolution open => fixed
2010-03-02 18:24 c_schmitz File Deleted: S_TestSurvyBilingualImport.csv
2010-03-03 23:37 c_schmitz Status resolved => closed
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)