- Posts: 13
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Importing respones
- Amal121
- Offline
- New Member
Less
More
6 years 11 months ago #154539
by Amal121
Replied by Amal121 on topic Importing respones
I export the data from offline survey and the vv file from limesurvey
Then I replace the first line of offlinesurveys file by the first two line of limesurvey vv file.
Then I import the offlinesurvey file to limesurvey.
Then I replace the first line of offlinesurveys file by the first two line of limesurvey vv file.
Then I import the offlinesurvey file to limesurvey.
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
6 years 11 months ago #154540
by Mazi
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
Replied by Mazi on topic Importing respones
If I remember correctly, OfflineSurveys exports the file as comma separated while the VV export uses tab separated values. You have adjust the format.
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.
- EnzoNun06
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
5 years 2 months ago #179934
by EnzoNun06
Replied by EnzoNun06 on topic Importing respones
I have the same problem
The topic has been locked.
- Eze
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
4 years 9 months ago #186580
by Eze
ezequiel
Replied by Eze on topic Importing respones
Hello!
I am using the free versión. When I did what was said, it didn't works.
It shows this:
"Importar un archivo de datos de respuestas VV
Éxito
Se subió el archivo con éxito.
Error
La importación ha fallado: las respuestas no se han podido mapear. "
¿somebody had the same error?
I am using the free versión. When I did what was said, it didn't works.
It shows this:
"Importar un archivo de datos de respuestas VV
Éxito
Se subió el archivo con éxito.
Error
La importación ha fallado: las respuestas no se han podido mapear. "
¿somebody had the same error?
ezequiel
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
4 years 9 months ago #186599
by Mazi
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
Replied by Mazi on topic Importing respones
Hi ezequiel,
can you translate those error messages to English?
Can you outline the exact steps?
can you translate those error messages to English?
Can you outline the exact steps?
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.
- Eze
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
4 years 9 months ago #186641
by Eze
ezequiel
Replied by Eze on topic Importing respones
Mazi, thanks
Hello
I tried the next mode but didn't work.
In the app, I exported the one response and I sent it to PC through bluetooh.
In limesurvey, I exported the responses though vv.
I insert in limesurvey vv (csv-tab) the line with the one response from offline. Later, I give to submitdate, lastpage, startlanguage, from offiline the correct column because it was in other order.
Later, I tried import the file (csv-tab) but shows this error:
Import a VV response data file
Success
File upload succeeded.
1 response lines in your file.
Error
1 responses cannot be inserted or updated.
¿someone had the same problem?
Hello
I tried the next mode but didn't work.
In the app, I exported the one response and I sent it to PC through bluetooh.
In limesurvey, I exported the responses though vv.
I insert in limesurvey vv (csv-tab) the line with the one response from offline. Later, I give to submitdate, lastpage, startlanguage, from offiline the correct column because it was in other order.
Later, I tried import the file (csv-tab) but shows this error:
Import a VV response data file
Success
File upload succeeded.
1 response lines in your file.
Error
1 responses cannot be inserted or updated.
¿someone had the same problem?
ezequiel
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
4 years 9 months ago #186644
by Mazi
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
Replied by Mazi on topic Importing respones
Thanks for the details! Please email support@offlinesurveys.com and include the CSV file you exported as well as your survey as LSS file.
Please also point them to the wrong order of items so this can be fixed.
Please also point them to the wrong order of items so this can be fixed.
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.
- Eze
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
4 years 9 months ago #186649
by Eze
ezequiel
Replied by Eze on topic Importing respones
I sent a email to them.
¿could the problem have relacionship with this?
www.limesurvey.org/es/comunidad/foros/in...ile-to-survey#124845
The original survey was made in beforeone version of limesurvey
Thanks for your help.
¿could the problem have relacionship with this?
www.limesurvey.org/es/comunidad/foros/in...ile-to-survey#124845
The original survey was made in beforeone version of limesurvey
Thanks for your help.
ezequiel
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
4 years 9 months ago #186662
by Mazi
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
Replied by Mazi on topic Importing respones
Possible, but I can't say for sure. But it surely makes sense to use the same Limesurvey version for loading the survey and importing the collected responses later.
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.
- aaskoura
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 9
4 years 9 months ago #186673
by aaskoura
Replied by aaskoura on topic Importing respones
Hi, you should naturally be loading/syncing a survey that was created/synced on the same LimeSurvey instance
The topic has been locked.
- Eze
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
4 years 9 months ago #186710
by Eze
ezequiel
Replied by Eze on topic Importing respones
Hi, I didn't explain correctly. The Limesurvey instalation is one for loading the survey and importing the collected responses later. What I tried to say is that the survey was created in Limesurvey version 1 somes years ago and was modificated each year in the actual version.
ezequiel
The topic has been locked.
- aaskoura
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 9
4 years 9 months ago - 4 years 9 months ago #186752
by aaskoura
Replied by aaskoura on topic Importing respones
I checked the files you sent me, it should be really easy to adjust DB_results to VV format
1- Download a VV file, leave the first 2 rows (the headers) you will paste DB_results in the rows below
2- In VV file leave the first 2 columns should be empty (id, token)
3- Under DB results ignore the firsts 2 columns (limesurvey_response_id, local_response_uid) they belong to internal offlineSurveys DB
4- Reorganize the columns in DB_results to match vv (move submitdate column to the beginning)
- In VV you have (submitdate, lastpage, startlanguage, startdate, datestamp)
- in DB_results you have (lastpage, startlanguage, submitdate, startdate, datestamp)
5- Copy all DB_result rows (without the header) below the vv headers, they will match
Regards,
OfflineSurveys Support,
Amr
1- Download a VV file, leave the first 2 rows (the headers) you will paste DB_results in the rows below
2- In VV file leave the first 2 columns should be empty (id, token)
3- Under DB results ignore the firsts 2 columns (limesurvey_response_id, local_response_uid) they belong to internal offlineSurveys DB
4- Reorganize the columns in DB_results to match vv (move submitdate column to the beginning)
- In VV you have (submitdate, lastpage, startlanguage, startdate, datestamp)
- in DB_results you have (lastpage, startlanguage, submitdate, startdate, datestamp)
5- Copy all DB_result rows (without the header) below the vv headers, they will match
Regards,
OfflineSurveys Support,
Amr
Last edit: 4 years 9 months ago by aaskoura.
The following user(s) said Thank You: Eze
The topic has been locked.