Upload datasheet to exisiting form

[archibald]

Hello,

We have a very long form with above 1000 submissions where corrections on excel is way easier compared to directly on Kobo, so i was wondering if there is an easy way to upload these corrected submissions directly into KoBo? I have searched around the web and forums and found old threads suggesting that there are no ways to do so (unless python method), i wonder if this has been updated and there is a way now?

Thanks

[Kal_Lam]

@archibald, you got that correct. Currently, it’s only possible through the python script as KoboToolbox has not developed a feature to address the same. But we do have a suggestion box for the same. Maybe you could VOTE for it to make it a reality:

Uploading new data or appending previous data to kobo server

Surveyed data are stored in the Kobo server. Sometimes I feel, and once was a crying need that, if it were possible to append few previously collected data to the newly collected data form, then I could analyse the changes of the result by Kobo automatic report. I think this service will make happy to many.

[archibald]

Thank you for your reply.

Is there a 101 or an easy to use guide for python script?

[Kal_Lam]

@archibald, we don’t have a guide but we have a script for this:

Importing xls data into KoBoToolbox

@sareep, a while back have created a method for converting XLS data into XML with a Python script so that they can be submitted via the API. This requires an existing deployed form to be in your account. Everything is documented in this repository: https://github.com/kobotoolbox/xls-import. I hope this works for you.