1. What is the general goal of the feature?
Having relational data from questionnaire on device and on server can simplify greatly data engineers and data scientists duties. Usually, connect whatever software (GIS and statistical software) to relational database, Right now the ODK1 and 2 have multiples limitations, among others, regarding distributed synchronization and storage, programming, relational database support for questionnaire data on device and on server. CSEntry is the oldest CAPI software : come from more than 30 years of software development. And, right now, it have the most advanced functionalities and features know on any CAPI platform, among others, support of relational database for questionnaire data, support of sql on data collection application etc. However CSPro ecosystem doesn’t have any dashboard for data management and visualization (map, graph etc. ODK aggregate through several (ONA, KoBoToolBox etc) is very strong for dashboard, but weak in data collection.
2. What are some example use cases for this feature?
This will allow users to use several’s existing functions librairies writing in CSPro Language and facilitate task that are impossible to perform right now on ODK1 and 2. Supporting CSEntry will also facilitate client who support relational database data can allow a direct way to access to raw data during fieldwork. So users can perform live analysis and design script for automatic data processing using whatever languages: SQL, R, CPL (CSPro Programming Language) and Python…
Distributed storage and sync is also a must since CSEntry can sync to FTP, Dropbox. And there's no limitation for CSEntry on how manies servers that a device can sync to.
So, this will allow us to benefit best of two world. The power, flexibility, stability of CSPro and the best thinking dashboard, data management features from ODK1 and 2. So the the a more dynamic of users communities from ODK. *
3. What can you contribute to making this feature a reality?
Having CSEntry as a data client to ODK ecosystem will be not difficult since CSEntry already have an API: CSWeb. This API already have java librairies (https://github.com/IstatCooperation/CSPro2sql) able to connect to it and transfer questionnaire data in a specif relational schema on SQL server and MySQL right now. It will not difficult to adapt theses librairies to PostgreSQL/PostGIS, the RDBMS that is used ODK server. As a 16 year old user of CSEntry, MySQL and PostgreSQL, i can help for this project.