View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04136 | Bug reports | Other | public | 2010-02-15 16:14 | 2010-03-03 23:37 |
Reporter | thozi | Assigned To | c_schmitz | ||
Priority | normal | Severity | block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.87+ | ||||
Fixed in Version | 1.87+ | ||||
Summary | 04136: Multilingual suvery import fails | ||||
Description | I experience exactly the same problem as reported here: Unfortunately I cannot open the related bug. I get access denied. Is this solved? What can I do. | ||||
Tags | No 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 ü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äge zur Verbesserung mit. Vielen Dank!<br />","","Ihre Vorschläge sind willkommen! Wir werden sie enstprechend in zukünftigen Enwicklungen berücksichtigen. Bei Rü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" 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" | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 8374 | ||||
I will donate to the project if issue is resolved | |||||
Browser | Firefox | ||||
Database type & version | MSSQL 10 | ||||
Server OS (if known) | Windows Server 2007 | ||||
Webserver software & version (if known) | IIS | ||||
PHP Version | 5.2.10 | ||||
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! |
|
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 Question Import: Q_RateYourSatisfaction.csv Error: Failed to insert question |
|
@ c_schmitz: may you please have a look at this issue - I don't have MSSQL. |
|
Error message when importing the "csv file icon S_TestSurvyBilingualImport.csv" file: [Microsoft][ODBC SQL Server Driver][SQL Server]Ung?ltiger Spaltenname 'lastpage'. |
|
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: Group import summary
Import of group is completed. |
|
The question imports fine without any problems. |
|
Fixed in build 8448 |
|
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 |
|
Note Added: 11106 | |
2010-02-15 17:28 |
|
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 |
|
Note Added: 11152 | |
2010-02-23 08:43 |
|
Status | feedback => assigned |
2010-02-23 08:43 |
|
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) |