Welcome to the LimeSurvey Community Forum

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

Importing respones

More
6 years 10 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.
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
6 years 10 months ago #154540 by Mazi
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.
More
5 years 1 month ago #179934 by EnzoNun06
Replied by EnzoNun06 on topic Importing respones
I have the same problem
The topic has been locked.
More
4 years 8 months ago #186580 by Eze
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?

ezequiel
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
4 years 8 months ago #186599 by Mazi
Replied by Mazi on topic Importing respones
Hi ezequiel,

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.
More
4 years 8 months ago #186641 by Eze
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?

ezequiel
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
4 years 8 months ago #186644 by Mazi
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.

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
4 years 8 months ago #186649 by Eze
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.

ezequiel
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
4 years 8 months ago #186662 by Mazi
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.
More
4 years 8 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.
More
4 years 8 months ago #186710 by Eze
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.
More
4 years 8 months ago - 4 years 8 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
Last edit: 4 years 8 months ago by aaskoura.
The following user(s) said Thank You: Eze
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose