Importing respones

More
2 years 5 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.

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

More
2 years 5 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
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com

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

More
8 months 2 weeks ago #179934 by EnzoNun06
Replied by EnzoNun06 on topic Importing respones
I have the same problem

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

More
3 months 4 days 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

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

More
3 months 3 days 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
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com

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

More
3 months 3 days 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

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

More
3 months 3 days ago #186644 by Mazi
Replied by Mazi on topic Importing respones
Thanks for the details! Please email This email address is being protected from spambots. You need JavaScript enabled to view it. 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
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com

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

More
3 months 3 days 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

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

More
3 months 2 days 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
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com

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

More
3 months 2 days 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

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

More
3 months 1 day 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

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

More
3 months 1 day ago - 3 months 1 day 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: 3 months 1 day ago by aaskoura.
The following user(s) said Thank You: Eze

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

More
1 week 3 days ago #189727 by Eze
Replied by Eze on topic Importing respones
Hello!
Now I tried with another survey that is shorter because the firstone didn t work for me.
Now, LimeSurvey shows this messaje:

"Import a VV response data file

Success
File upload succeeded.
2 response lines in your file.
1 responses were inserted.
Warning
1 responses already exist. "

I don t undertand why. Could someone say why? Thanks

ezequiel

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

More
1 week 2 days ago #189738 by Mazi
Replied by Mazi on topic Importing respones
Please check your import settings, especially regarding existing data sets. Most probably a data set with the same ID already exists.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com
The following user(s) said Thank You: Eze

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

More
1 week 2 days ago #189773 by Eze
Replied by Eze on topic Importing respones
It worked when I select "Exclude record IDs?" -> NO
Although the file did not have IDs
Now, I will try with de firstone survey that is bigger.
Thanks

ezequiel

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!