I am a kobo collect user and it is a tool that helps me a lot in collecting, processing and analyzing data. However since I use the new version there are tasks that I can no longer do to download data using ODkBriefcase production based on an sql server query. The constant is that the form_id variable is no longer accessible to allow me to execute the query so when my query is executed I receive an error message saying that the “Form ID doesn’t exist”.
I noticed when I develop a form using xlsform in the settings part the form_id variable is changed to id_string when I load and deploy the form on the kobo server.
So I don’t know if in the new version the form_id variable has been removed or not and if so what variable is the equivalent of form_id that we must use to download the data using the query below that I use in previous versions to download data from ODKBriefcase production.
Here is the query that I have always used but which no longer works with the new version of kobo collect :
Exec xp_cmdshell ‘java -jar D:\ODK\ODKBriefcaseProduction.jar -id name_of_form_id -sd D:\ODK -url https://koboserver -u username -p password’
The above query allowed me to download the data in the xml file.