View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|14944||Development||Import/Export||public||2019-05-27 19:46||2019-11-22 14:40|
|Summary||14944: Adding id and related_id in TSV export make it complicated to edit|
|Description||TSV is made for Export : update manually, import.|
Have id and related_id make it complex to editing
Remove this 2 columns : still working
What is the usage of this 2 columns ?
|Additional Information||In 2.X : import/export as roughly tested and working with multilingual, survey.|
User just have to put subquestion after question : it's clear enough
Currenlty : using TSV for quick edit of survey seems broken (for example for translation).
I use it for :
2. Make 4 subgroups with same questions in a group
Removing this 2 columns : TSV can be imported.
With this 2 columns : i must set random number …
|Tags||No tags attached.|
|I can find and fix : but speediest if i know usage of this 2 columns :)|
id and related id columns are required for export and import of quotas.
Quotas are too complex to reconstruct without those columns.
All other objects aren't required to have those columns set, it would work without them.
OK, for quota only.
Because quota table use qid and not question/answer code in export (and import).
Terribly boring since TSV is a really good tool but broken here …
|Three tables need to be connected, so it's not so easy.|
|I check it when i found times :)|
Then i think we can use another column for quota is and related id.
For Group we use G1,G2 etc … Why not QTA1, QTA2 etc …
I have an issue currently with quota , i check if it was a plugin before report …
Those columns are used only for Quotas.
Number of columns in TSV export should always be the same or it would be very confusing.
I see you remove the number in export for Group : we add it for import group with multiple language : there are an old issue somewhere …
For id and related id, clearly
1. Don't put it if not used , needed : just set it to "" for qid and gis (and assessmeents).
2. Since ii's not a major columns : add it after other column (maybe just after relevance ) : this one is easy.
If it's used only for quota : why not name it quota_id and related_quota_id ?
Unsure on this point : if we need it another id elsewhere …
After extensive testing, I discovered that any "text" column data that includes a non-standard ASCII character (as get copied out of Word and include things like en-dash and em-dash and the slanted versions of the single and double quotation marks) creates a crash in the import with no error message. It seems that you can copy formated Word text into the Limesurvey survey creator, but the importer cannot handle such text.
I've now cleaned up my Excel pseudo-database of survey questions and can start generating new forms.
|@pnickel : totally unrelated to this issue … please report another bug …|
@ollehar on irc
> (12:19:48) ollehar: I thought we had excel format for that?
Yes : TSV is tab-separated-value for editing in excel
@cdorin : sorry don't found times for this one, set as new. Please can you check ? Nobody use https://manual.limesurvey.org/Tab_Separated_Value_survey_structure on limesurvey.org ?
|2019-05-27 19:46||DenisChenu||New Issue|
|2019-05-27 19:46||DenisChenu||Status||new => assigned|
|2019-05-27 19:46||DenisChenu||Assigned To||=> dominikvitt|
|2019-05-27 19:46||DenisChenu||Additional Information Updated||View Revisions|
|2019-05-27 19:47||DenisChenu||Note Added: 52123|
|2019-05-28 11:08||DenisChenu||Relationship added||related to 14403|
||Note Added: 52128|
|2019-05-28 14:04||DenisChenu||Note Added: 52129|
|2019-05-28 14:05||DenisChenu||Note Edited: 52129||View Revisions|
||Note Added: 52130|
|2019-05-28 14:14||DenisChenu||Assigned To||dominikvitt => DenisChenu|
|2019-05-28 14:14||DenisChenu||Note Added: 52131|
|2019-06-25 14:56||DenisChenu||Note Added: 52543|
|2019-07-12 14:48||DenisChenu||Note Added: 52863|
||Note Added: 52864|
|2019-07-12 15:50||DenisChenu||Note Added: 52866|
|2019-07-12 15:51||DenisChenu||Note Added: 52867|
|2019-07-13 18:33||DenisChenu||Relationship added||related to 06502|
|2019-08-05 00:21||pnickel||Note Added: 53085|
|2019-08-06 09:17||DenisChenu||Note Added: 53121|
|2019-11-22 14:37||DenisChenu||Assigned To||DenisChenu =>|
|2019-11-22 14:40||DenisChenu||Status||assigned => new|
|2019-11-22 14:40||DenisChenu||Note Added: 54762|