Page 1 of 1

Look Up files

Posted: January 8th, 2021, 11:19 am
by MuleFena
Dear CSPro Users,

Currently, I am designing a CAPI data collection on CSPro 7.5. I created a lookup dictionary files and this works well on my laptop. I am using a Dropbox as server for synchronization. The application works fine without the look up files when downloaded to tablets. But doesn't work with the lookup files when downloaded to tablets though it is working well on laptop.

Kindly looking for support and guidance on this

Re: Look Up files

Posted: January 8th, 2021, 1:48 pm
by MuleFena
@Gregory Martin,

Kindly looking for your support on the problem posted

Re: Look Up files

Posted: January 8th, 2021, 3:36 pm
by aaronw
Based on your description:
  • Application on laptop works without the lookup file
  • Application on tablets don't work without the lookup file
it's likely that the look up file does not exist (or is empty) on the tablet. Open the look up file and inspect the contents of the laptop and the tablet. Is one empty? Is it possible the synchronization logic is not working on either? Maybe the look up file already exists on the laptop, because that's where it was created during app development?

Re: Look Up files

Posted: January 8th, 2021, 7:38 pm
by MuleFena
Hi aaronw,

Thank you for your response:

Here is the exact description.

1. The application works well on the laptop with the lookup file. But,
2. when I added the application to tablet from drop box, the application refused to work the same way on laptop; the look up table doesn't come and pops up the following error message;
Error(88889)
WARNING: Out of range! Please enter a valid value for the Zone.

Below your response:

"it's likely that the look up file does not exist (or is empty) on the tablet. make sense.

Open the look up file and inspect the contents of the laptop and the tablet. Is one empty? Is it possible the synchronization logic is not working on either? Synchronization has no problem from my observation

Maybe the look up file already exists on the laptop, because that's where it was created during app development? Correct, it has been on laptop where it was created, but how I can bring everything to drop box and get it to multiple tablets?

I attached the screenshot, that it works on laptop

Thanks again and looking to hear from you more,

Mulugeta

Re: Look Up files

Posted: January 9th, 2021, 7:47 am
by josh
Does your program sync the lookup file? If you just set up syncrhonization from the options menu it only syncs the main data file. It does not sync the lookup file.

There are two ways people do that:

1) Include it in the deployment package when uploading the application to Dropbox using the deploy applications tool.

2) Use the syncdata function to download it to the tablet when the interviewer syncs the application.

If the lookup is created once and doesn't get updated then option 1 is sufficient. If you are changing the lookup during the survey and want the users to get the latest version then you should also do option 2.

If you are already syncing the lookup then look at the sync.log file in the csentry directory on your tablet to make sure that it is getting downloaded correctly.

Re: Look Up files

Posted: January 10th, 2021, 1:49 am
by MuleFena
Hi Josh,

Thank you so much and your observation and guidance is fine. I was using the first option and still has the same problem. My application uses the attached data files while running on laptop.

but when I deploy I was including the dictionary files for the lookup which still didn't work on tablet.


Thanks

Mulugeta

Re: Look Up files

Posted: January 10th, 2021, 9:52 am
by josh
You need to deploy the DATA files, not the dictionary files. The dictionary files are not needed. Add the csdb files to your deployment package.

Take a look at the deployment for the Labor Force Survey in the CSPro examples directory (DeployPopstanLFS.csds). It includes two lookup files (sample.csdb and staff.csdb) in the deployment.

Re: Look Up files

Posted: January 10th, 2021, 10:44 am
by MuleFena
Many Thanks Josh,

It is now working. I am really happy that you guys are around for support.

Thanks again,

Mulugeta