Exporting SurveyMonkey Data to Toolbox and Integrating with DevResults

[ascharf]

Hello,

I am a MEL specialist for my organization and am working with a program team who would like to export data from a previously used SurveyMonkey survey into Kobo so we can distribute the same survey at the end of the program to compare pre/post responses. I know there are other API posts but I couldn’t find any specific to SurveyMonkey or that had been posted within the last year so was hoping someone could please give me step by step instructions on how to upload the SurveyMonkey data to a Kobo form (I’m new to API!).

I also would like to build an integration from Kobo data to DevResults. I believe I can use Postman to create a Kobo API and import into our DevResults site as well, but am unsure of exactly how to do this as well.

Thank you in advance!

[stephanealoo]

Hi,
Unfortunately, there is no direct plug-and-play approach to getting survey monkey data within the platform as you have described.

You may have to create a clear form on KoBooolbox which mirrors your form on Survey monkey. Download your data from Survey Monkey, then try the upload using the approach proposed here

Stephane

[ascharf]

Thanks @stephanealoo ! The hyperlink to the approach you mentioned doesn’t seem to be working for me - could you please paste just the link, so I can copy and paste? Thanks!

[stephanealoo]

Uploading XLSForms through kobotoolbox rest api using Python

Hey All, I am trying to replace xlsforms automatically via following python code but it prints the response code 500 can you guys tell me what’s wrong with my code. import requests def upload_to_kobo(xlsform,form_number): files = { 'xls_file': (xlsform, open(xlsform, 'rb')), } d = r'https://kc.humanitarianresponse.info/api/v1/forms/' + form_number response = requests.patch(d, files=files, auth=('ihsan_afghanistan', '***')) print(response) upload_to_kobo(r’\agysKtkeMyW8FTForzQP9T.xlsx’,…

[Josh]

Hi @ascharf, if you are looking for some examples of posting submissions via the API, you can also refer to the threads here and here. There’s also a script here that I use for dummy submission data you can refer to.