CSPro Users Forum

Hello CSPro team,

I have a question. I have a CSDB file imported from Dropbox that contains survey data. In this survey, question P001 corresponds to the interviewer’s code. One of the interviewers’ phones was damaged, so he has to use a new phone where I reinstalled the survey app. However, since it’s a new device, it has no surveys stored.

My question is: is it possible to split the CSDB file (imported from Dropbox) by interviewer, so that I can extract only the surveys belonging to that interviewer? This way, I could send him only his surveys and allow him to continue recording his interviews.

Is that possible? I would really appreciate your help with this issue.

Thank you,

Hello,
It is possible to do what you suggest. You can do it in a windows computer and copy the csdb that you create in the following process, or you can do it directly in the android device, in both cases, you can use the same program that I explain in the following lines.
Create an application with few lines to use only to recover the data from the server (dropbox).
You only need to use two dictionaries, one is a dummy dictionary with a single variable, and the other dictionary is the main you want to recover in the device.
the program only need to connect (synconnect()) to dropbox and excute a syncdata(GET,<the lookup dictionary, that one you want to recover>,interviewer code.)
I asume that the interviewer code is the first part of te key (please review the help of syncdata function.
After that, the csdb is restored for the interviewer.
In case the interviewer is not the first part of the key, the situation changes, because you need to know the first part of the key to do the GET, it this case, you need to write a program to get the key and them get the record from the dropbox server.
It depends of how the dictionary was defined.
I do not have more information from your app to give you a more details about how to do the recover.
Regards
Mario

Hi Mario

Thank you very much, I'll try it.

Regards