Pull Data Functionality in KoboToolbox

If you have done a listing and you want to reuse some information in the main survey, you can use "pull data" to pull the data from .csv file and call the information in the main survey.

How to pull data

Give that field a name that you want

Then in its calculation column, call the pulldata() function, indicating which field to pull from which row of which .csv file. This can be achieved by writing as follows pulldata(‘nameofcsv’, ‘columnheadingtopulldatafrom’, ‘columncheckformatchingTEXT’, ‘TEXTtoCheckfor’

#dataanalytics #datacollection #datascience #kobotoolbox #odk

[mathtoma]

Thank you so much. It's what I have been looking for months. All the best!!!

[hugemanisme]

Thank you very much. I was looking for a detailed manual on it but glad that I looked up for it on YT. Very thorough and insightful video. Thanks again. Best from India.

[rugwizainnocent]

A very informative content. Thanks a lot

[Lew]

This is wonderful! Would this work if you had something like a grant application form that you wanted to link to a grant review form? Essentially so individuals could submit their grant apps and then reviewers could read those apps and review them in the "child project? Thanks so much for any clarification you can provide.

[fredrickmerie]

Great and easy to follow video, but when I download the xls file it does not have the calculate row and column I see in your xls. I also cannot see pull data in KOBO settings

[WilsonHerreraJr.]

Fantastic video, thanks for your contribution.

My question is that I've already gotten Pulldata to work in Kobotoolbox, but when filling out the form in the Kobocollect app, Pulldata doesn't work because it doesn't call the data. Could you help me?

[xorlaadzoyi]

Great tutorial!!! Mine has an extra layer to it. The last 2 questions in the pulldata series have more than 1 instance in the source csv file. E.g. let's say it goes from continent, to country, to region, to district. And for each country, there are 2 regions, which could also have 2 districts each. In that case, using the text type won't quite I should be able select which of the regions, then districts that I want the new information to be collected for. How do I do this? I have tried changing the question type from text to select_one but then it doesn't quite work.

[constantinrukataza]

Thank you, this is very helpful i was looking for it. besides, Kindly assist me, I'm facing the issue of not submitting data in Enketo form. I get an endless loading rectangle.

[oscarlicto]

En la aplicación del celular no me aparecen lo datos extraídos de la base .csv, pero en la computadora si me aparecen; ¿me podrían ayudar con ese problema?

[zayidhs]

Hello good day!

Thanks for an amazing content as always. I have watched several of your videos to help me through my baby steps in kobotoolbox.

My question is that I want to pull data but not from an external file but rather, the choice sheet of my survey form.

I have already populated it with required data and I want to reference it as a note for the surveyor Eg "there are ${number_of_schools} in your city"

Where there is a number_of_school_filter in the choices sheet.

Thanks.

[ghanshyamsingh]

Hello,

In CSV file created unique id's, if I created drop-down list for that id's so my read only question can't filled as per CSV file they are just blank. Kindly let me know how to fix this issue.

[edmarkwellnessexperience]

can we import picture, GPS By external file, or other form??

[rawadshayya]

what if the entered value not found in csv data? or i entered wrong value
que se passe-t-il si la valeur saisie est introuvable dans les données CSV ? ou j'ai entré une mauvaise valeur

[MagicBus-uq]

CAN I EDIT THE DATA I PULL, EXAMPLE I WANT TO PULL ENROLLMENTS AND IF THERE IS CHANGE I WANT TO EDIT AND SUBMIT

[desmondwafula]

A good vedio indeed, can someone edit their details in pull data? maybe after they realize that their name had a spelling error etc?

[nijaradeka]

HI Oluwaseun Ogunmolu
I have another question.
In my survey, there are two steps . One is listing followed by the main survey. Listing will be done in a place for 100 households. Then 12 households will be selected by making stratification based on education of the head of the household. Households will be grouped in four different groups based on education of the head of the household. Then 3 households will be selected randomly from each stratum.

Is this possible in Kobo programming ?

[edmarkwellnessexperience]

Hello have a limit of umber of row to pull data?

[nijaradeka]

hi, I am getting error massage . I dont know, not finding the data etc msg are coming

[nicolasspoto]

Hello, Sr. Very good video. Im trying to pull old form results in a new survey. Is there a way to do this? Thanks.

[ZAChowdhury-ksgy]

This is a final reminder that the end of your transition period on the Legacy Plan is quickly approaching. On 1 March 2024, your account will be transitioned to the new Community Plan, which includes 5, 000 submissions per month and 1GB of file storage. What is mean? is it free up to 1GB of file storage ?