Hello,
Kind request:
Reposting this issue a second time. The first posting from 2 days ago, was automatically removed by this site’s automated spam filter (Akismet). Not sure what the reason for it could be. It was supposed to be reviewed (by a staff member, the message says) and re-appear, but that has not happened yet. Sincerely hope this does not get auto-removed again. This is a lengthy post to write again as you can see! This is also a serious form management issue for me. Have been managing this manually for some months now, since I did not have the time to write this (long) post. Could really use some help in this matter…
The Problem:
Our forms (on kf.kobotoolbox.org) use csv files. Some of them are master data files that change infrequently. There is however a set of ‘dynamic’ csv files in almost every form, that gets updated via REST API, with every form submission. The form also gets redeployed via the API. This mechanism works very well
However, the API based update of the csv files does not update the same files whose links appear in the Settings->Media section of the kobotoolbox IDE. The version of the csv files in this section is always what was last uploaded manually
Now if a form is modified (its xlsform code that is), or if one of its csv files is to be updated manually (mostly the master data csv files), then the form needs to be redeployed (manually) via the kobotoolbox IDE. In that case, all the csv files that may have gotten modified up till then via API, have to be manually (re)uploaded in the Settings->Media section
Almost every form of ours uses multiple dynamic csv files that get updated with every submission (submission in one form also leads to csv file updates in other forms via the API in most instances, which works very well). Also, many of the ‘master data’ csv files are attached to multiple forms (couple of them apply to all forms). Currently, an update to one these csv files has to be applied manually, which means updating most or all forms csv in their Settings->Media section as described in the previous paragraph. It seems like there are two separate independent locations for csv/media files in the kobotoolbox server?
This is a significant maintenance overhead. Doing this task manually also often leads to ‘human errors’ that eat up additional time. Shouldn’t a csv file update via the API also update that file in the form’s Settings->Media section as well?
Would appreciate any help in this matter. Has anyone else faced this same issue? Is there a solution for this? Can the Kobotoolbox team please look into this problem?
using URL https://kc.kobotoolbox.org/api/v1/forms/ to read form metadata
using URL https://kc.kobotoolbox.org/api/v1/metadata.json for csv file upload
using URL 'KoboToolbox Form Building API for form redeploy
thanks