Welcome to the LimeSurvey Community Forum

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

Re-Import an Excel Export

  • baxter
  • baxter's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago #81917 by baxter
Re-Import an Excel Export was created by baxter
Hi,

i created two identical surveys with limesurvey (One in english, one in german). Now i want to merge the answers into one "List". I exported both results to excel and merged them into one list.
Now my question: Is it possible to re-import these new List? I did not find out how to do.

If it is not possible, it would be great if you can give me another solution (tool, or something else) to evaluate the results.

thank you
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 9 months ago #81920 by tpartner
Replied by tpartner on topic Re-Import an Excel Export

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
More
11 years 9 months ago - 11 years 9 months ago #81921 by Ben_V
Replied by Ben_V on topic Re-Import an Excel Export
For data analysis using LS features:

You can use vv.csv files export/import features

1) Export english + german results (vv.csv files)
/!\ Backup those 2 files in case of.... :evil:
2) Open english one (with text editor not as spreadsheet) and add responses related lines from german file (don't touch the 2 first lines with the columns IDs)
3) If your survey is off, desactive it; A backup answer table will be created to restore those results if further need...
4) Import your "composite" vv file to your english version survey


Ben/

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 11 years 9 months ago by Ben_V.
The topic has been locked.
  • baxter
  • baxter's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago #81934 by baxter
Replied by baxter on topic Aw: Re-Import an Excel Export
thanks, i will try and give feedback :)
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
11 years 9 months ago #81979 by Mazi
Replied by Mazi on topic Aw: Re-Import an Excel Export
This might not work if you are not using the exact same question, answer and subquestion codes.

In this case SPSS should offer features to merge such data files.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
  • baxter
  • baxter's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago #81987 by baxter
Replied by baxter on topic Aw: Re: Aw: Re-Import an Excel Export

Mazi wrote: This might not work if you are not using the exact same question, answer and subquestion codes.


Yes, i found that out, thanks.
But after i corrected the codes, everything was fine. Import after editing (as i expected) did not work. To solve this i did a new, "clean" vv-export, pasted my edited list in this new created file (deleted the new exported data out of it before), saved it and imported this one. Works perfectly.

Thanks for your help guys.
The following user(s) said Thank You: Ben_V
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
11 years 9 months ago #81999 by Mazi
Replied by Mazi on topic Aw: Re: Aw: Re-Import an Excel Export
Thanks for ths additional nstructions. Please also help other by improving our manual at docs.limesurvey.org/Exporting+results&st...Export_and_VVImport_
Would be great if you could extend it after what you have learnt.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
  • baxter
  • baxter's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago #82445 by baxter

Mazi wrote: Thanks for ths additional nstructions. Please also help other by improving our manual at docs.limesurvey.org/Exporting+results&st...Export_and_VVImport_
Would be great if you could extend it after what you have learnt.


Did it here: docs.limesurvey.org/Exporting+results#Im...ing_a_VV_survey_file
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
11 years 9 months ago #82510 by Mazi
Thanks!

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
More
3 years 10 months ago - 3 years 10 months ago #199296 by edwards142
Replied by edwards142 on topic Re-Import an Excel Export
I think you are facing issue in exporting data to excel. If yes then I have something to share with you.

after trying the solution mentioned in the below given link, i am very much sure that you can easily get rid of the Excel data exportation issue.

So, check it out…..!

source:
[link deleted - Reason: spam]
Last edit: 3 years 10 months ago by holch.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose