How to import data in KoBoToolbox

Hi,

we have 400 subject entries that we need to import into Kobo, from previously collected data. is there a way of importing it en masse, to join the ongoing entries from Kobo, instead of entering the 400 subjects individually?

thank you,

Laurence

Laurence this is a great question. I wish I knew how to do this as well.

I would recommend the API, but it looks like it only allows for reading of data, not adding or editing.

To the creators Is there any chance the API in the future will allow for editing or adding?

I’m only a user, but it is possible to post submissions using the API. I don’t have time currently to properly describe how, but it definitely works. There are also ways to do batch imports. One is using the API, and to push a CSV files with your data. The data has to be quite simple, it cannot contain groups and repeating questions IIRC.
Another way that should work is to use https://opendatakit.org/use/briefcase/. Create one submission on an Android device, check out the created files and folders and then create additional XML files for your submissions and push them (you will probably also have to edit the sqlite database that ODK/KoBoCollect creates). I haven’t tried that approach myself though.

I would say the CSV import functionality of the API is easier if your data is not complex.

Sorry I don’t have the time to describe it better, but with that as pointers hopefully you can work something out.

Best Regards,

Jesaja Everling

···

On Thu, Jan 19, 2017 at 11:44 AM, Johnny Knox knoxj...@gmail.com wrote:

Laurence this is a great question. I wish I knew how to do this as well.

I would recommend the API, but it looks like it only allows for reading of data, not adding or editing.

To the creators Is there any chance the API in the future will allow for editing or adding?

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

1 Like

So are you saying that you can interact with KoboCollect using https://opendatakit.org/use/briefcase/. How do you upload these files into KoboToolbox. Is there a way to access the database of your organization within KoboCollect?

1 Like

Yes, AFAIK that should work. The easiest way is to access your KoBoCollect data is to export the KoBoCollect folder (/sdcard/odk) from your Android device. You can simply use a file manager that supports creating zip files (e.g. this one: https://play.google.com/store/apps/details?id=com.rhmsoft.fm) and then send the zip file to yourself using Email.
But I think in general CSV import should be easier, because with the briefcase application you will have to create individual XML files for all submissions and update the database - I think.
Both ways should be possible though (CSV only with “flat” data).

Best Regards,

Jesaja Everling

···

On Tue, Jan 24, 2017 at 7:37 AM, Johnny Knox knoxj...@gmail.com wrote:

So are you saying that you can interact with KoboCollect using https://opendatakit.org/use/briefcase/. How do you upload these files into KoboToolbox. Is there a way to access the database of your organization within KoboCollect?

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

@Jesaja I have reread I think I am still missing how you are able to import using CSV… I think I must have missed something. Where do you go about importing a CSV?

Hi Johnny,

you have to use the API, specifically this endpoint:

https://kc.kobotoolbox.org/api/v1/forms#import-csv-data-to-existing-form

Best Regards,

Jesaja Everling

···

On Mon, Feb 6, 2017 at 5:39 AM, Johnny Knox knoxj...@gmail.com wrote:

@Jesaja I have reread I think I am still missing how you are able to import using CSV… I think I must have missed something. Where do you go about importing a CSV?

–

You received this message because you are subscribed to the Google Groups “Kobo Users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.

Visit this group at https://groups.google.com/group/kobo-users.

For more options, visit https://groups.google.com/d/optout.

1 Like

Hello everyone
Please any help for how to import data collected with enkento and exported as zip file into kobo;

Thanks

2 Likes

Hi @julesmerlain,

Please see the support article on Manually Uploading Submissions which should solve you with uploading the collected data (from KoBoCollect mobile app as well as Enketo) to KoBoToolbox.

Thanks Kalyan Lama,

I read the article but i could not understand the part about sélection of the zip file

Bests Regards

Kal_Lam

July 23
Hi
@julesmerlain
,

Please see the support article on Manually
Uploading Submissions
which should solve you with uploading the collected data (from KoBoCollect mobile app as well as Enketo) to KoBoToolbox.


Visit
Topic
or reply to this email to respond.

To unsubscribe from these emails,
click here
.

-------- Message original --------

Hey. I’ve already read the article too, but I’m having some troubles exporting the web form data that is previously full-filled in chrome navigator from an Iphone. I don’t know where the downloaded file is (although the page sends a message saying that a zip file was created).

Do you know what could be the problem?

Thanks

Hi @juan.techo,

The best option would be checking directly in the download folder.

1 Like

Hello. This link is asking for a userid and password. Can you provide more instruction on how to upload data to kobo toolbox? Thank you

Hi Jesaja_Everling,

If indeed you have found a workaround to load back a data that has been cleaned of errors to KoboCollect that would be a big help to the community.

Thanks,

Hi @ppmjr12020
I noticed that you have asked the same question on a different thread. Currently, the only workaround is using python as discussed below

Stephane

1 Like