I am super excited about ODK Central and Collect. Special thanks for making such great documentation.
1. What is the problem? Be very detailed.
I want to get your opinion on how to compare form submissions to data in ODK central or external sources. I want to avoid reinventing the wheel.
Say, I have two forms:
barcode_registeration_formthat is to collect a list of pre-generated barcodes (unique values) in ODK Central through submissions by ODK Collect.
user_items_formis used by users to fill some fields in addition to scanning a barcode. Upon receiving their submission I want to compare the barcodes submitted by the users to what is already stored in ODK Central.
Based on what I have learnt reading the Docs, ODK doesn't seem to have any feature that makes it possible to compare current form submissions to internal (previous submission) or external sources (a csv file, sqlitedb, etc).
2. What app or server are you using and on what device and operating system? Include version numbers.
ODK Central 1.2.1
3. What you have you tried to fix the problem?
I have read some discussion in the forum but couldn't form any conclusive point.
However, I just came across ODK-X. Although it does sound promising but I was not sure if it does has such a feature. Also, I don't know how much would I lose if I move to ODK-X especially after setting everything up for my project with ODK.
A solution that I am thinking to implement is a simple web app or a script to retrieve all submission from both forms through the API and generate a brief report on the comparison.
I would really appreciate your thoughts on how you approach this issue?