Using the Data Viewer to concatenate and convert to csdb files collected on Android tablets
Posted: December 5th, 2017, 1:20 pm
Hi,
I have a CSPro application that has been used for multiple surveys with the Dropbox sync using a .pnc file to collect data on Android tablets. Recently I have become aware that the .pnc sync function will no longer be supported and we need to update to CSPro 7 and utilize the new sync function. I have updated the CSPro application to v7.0, but have now come across a few issues that I wanted to ask about.
1. A group of about 12 people was all trying to use the Data Viewer tool and we found that for some people, the tool wouldn't open at all and gave an error message similar to "The program is not responding. Please quit and try again." Others were able to open the Data Viewer tool, but the Dropbox connection didn't work and gave a message similar to "After 1000 milliseconds the server timed out". Others of us were able to successfully connect and concatenate data collected from a number of android tablets and synced to Dropbox. Hence the questions: Have others reported issues with the Data Viewer tool? If so, are there any solutions? How about the Dropbox connect function? In addition, for the Data Viewer tool to work via Dropbox, does the the computer you are using have to have Dropbox installed and that account invited to the folder where they Android tablet is stored? Or can the credentials for the Dropbox account where the data is stored simply be entered after clicking on connection and the files will be pulled from the cloud regardless of the status of Dropbox on the computer?
2. As an alternative, I tried copying the Android tablet data files from my Dropbox folder to a USB drive to allow others to test out the Data Viewer tool to concatenate the data and convert to csdb format without connecting through Dropbox. However, I realized that the Data Viewer tool doesn’t seem to have an option to just select the files you want to convert from a local drive. Is there a way to do this? Or any other alternatives to converting the Android files to csdb other than the Data Viewer? We also tried the old CSConcat tool, but that didn't seem to work with the Android tablet data.
3. In the past, after concatenating data from multiple tablets, we would use the Index Files tool to identify and resolve duplicates before the concatenated data file could be opened in CSEntry. As I was reading some related posts on this forum, I noticed that it may be possible that the Index Files tool no longer works with csdb files. Hence the questions: Does the Index files tool work to identify duplicates in the csdb file? If not, will a csdb file open in CSEntry if it has duplicates? If not, is there a different tool to use to identify and remove duplicates for csdb files?
Many thanks for any suggestions or insight into how the new tools work!
Ashley
I have a CSPro application that has been used for multiple surveys with the Dropbox sync using a .pnc file to collect data on Android tablets. Recently I have become aware that the .pnc sync function will no longer be supported and we need to update to CSPro 7 and utilize the new sync function. I have updated the CSPro application to v7.0, but have now come across a few issues that I wanted to ask about.
1. A group of about 12 people was all trying to use the Data Viewer tool and we found that for some people, the tool wouldn't open at all and gave an error message similar to "The program is not responding. Please quit and try again." Others were able to open the Data Viewer tool, but the Dropbox connection didn't work and gave a message similar to "After 1000 milliseconds the server timed out". Others of us were able to successfully connect and concatenate data collected from a number of android tablets and synced to Dropbox. Hence the questions: Have others reported issues with the Data Viewer tool? If so, are there any solutions? How about the Dropbox connect function? In addition, for the Data Viewer tool to work via Dropbox, does the the computer you are using have to have Dropbox installed and that account invited to the folder where they Android tablet is stored? Or can the credentials for the Dropbox account where the data is stored simply be entered after clicking on connection and the files will be pulled from the cloud regardless of the status of Dropbox on the computer?
2. As an alternative, I tried copying the Android tablet data files from my Dropbox folder to a USB drive to allow others to test out the Data Viewer tool to concatenate the data and convert to csdb format without connecting through Dropbox. However, I realized that the Data Viewer tool doesn’t seem to have an option to just select the files you want to convert from a local drive. Is there a way to do this? Or any other alternatives to converting the Android files to csdb other than the Data Viewer? We also tried the old CSConcat tool, but that didn't seem to work with the Android tablet data.
3. In the past, after concatenating data from multiple tablets, we would use the Index Files tool to identify and resolve duplicates before the concatenated data file could be opened in CSEntry. As I was reading some related posts on this forum, I noticed that it may be possible that the Index Files tool no longer works with csdb files. Hence the questions: Does the Index files tool work to identify duplicates in the csdb file? If not, will a csdb file open in CSEntry if it has duplicates? If not, is there a different tool to use to identify and remove duplicates for csdb files?
Many thanks for any suggestions or insight into how the new tools work!
Ashley