Hi everyone. We are transitioning our data collection work from SurveyMonkey to Kobo (Humanitarian) and would like to keep all of our data stored in the same place, if possible.
We can export our data from SurveyMonkey in XLSX or CSV, but the data will always come out in a single “flat” file. From what I can tell, there are a few ways to get data into Kobo without manually populating the forms:
- the “bulk upload” page: This seems to require individual XML instances that we don’t have
- ODK Briefcase: This also seems to require zipped individual XML instances that we don’t have
- an API from this thread**
Question 1: Is there a convenient way to convert an Excel or CSV file into appropriately formatted individual XML instances for bulk upload or Briefcase push? I know Excel can map to XML schema easily, but this seems different. I can write a script to create individual text/XML files for each row, but where will I get the UUIDs?
Question 2: The API seems like the most promising way forward. Unfortunately, I’ve never done this before… can someone give me some tips about how to use the API for this purpose?
Question 3: Is there any other way to migrate data to Kobo?
Thanks so much. I’ve been searching everywhere weeks and I really don’t know what else to do.