Re-Import an Excel Export

More
6 years 4 months ago #81917 by baxter
baxter created the topic: Re-Import an Excel Export
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

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #81920 by tpartner
tpartner replied the 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.

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago - 6 years 4 months ago #81921 by Ben_V
Ben_V replied the 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: 6 years 4 months ago by Ben_V.

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #81934 by baxter
baxter replied the topic: Aw: Re-Import an Excel Export
thanks, i will try and give feedback :)

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #81979 by Mazi
Mazi replied the 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
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #81987 by baxter
baxter replied the 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

Please Log in or Create an account to join the conversation.

More
6 years 4 months ago #81999 by Mazi
Mazi replied the 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
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in or Create an account to join the conversation.

More
6 years 3 months ago #82445 by baxter
baxter replied the topic: Aw: Re: Aw: Re: Aw: Re-Import an Excel Export

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

Please Log in or Create an account to join the conversation.

More
6 years 3 months ago #82510 by Mazi
Mazi replied the topic: Aw: Re: Aw: Re: Aw: Re-Import an Excel Export
Thanks!


Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!