Pull Data Functionality in KoboToolbox
HTML-код
- Опубликовано: 27 ноя 2022
- 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’
BUY ME A COFFEE 😊 : www.buymeacoffee.com/seunogunmop
#dataanalytics #datacollection #datascience #kobotoolbox #odk
Thank you so much. It's what I have been looking for months. All the best!!!
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.
A very informative content. Thanks a lot
Merci!!
Thank bro
great
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 work......cos 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.
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?
I think something is wrong somewhere. Take your time and watch the video again to see if there’s no mistake
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
You will be the one to add it. Watch the video again
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.
It’s possible. I will try to do a similar video on it
It’s possible. I will try to do a similar video on it
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.
Hello have a limit of umber of row to pull data?
hi , I am getting error massage . I dont know , not finding the data etc msg are coming
can we import picture, GPS By external file, or other form??
Yes, of course. Just follow the process
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.
If I may get you, you want to reference from the same form. If that’s the problem then it’s not hard, I already have tutorials on that. But I will like to get you clearly.
@@oluwaseunogunmolu yes, the data is already in the choices sheet and I want to reference it in the survey sheet.
Thanks
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 ?
You can do the stratified random sampling using Excel then use pull data to fetch the selected information. After you have done the sample selection from the listing data in excel then use Pull Data to fetch the information of the selected sample in the main survey
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
CAN I EDIT THE DATA I PULL, EXAMPLE I WANT TO PULL ENROLLMENTS AND IF THERE IS CHANGE I WANT TO EDIT AND SUBMIT
Yes of course. In the excel xlsx, in the column where you will write read_only, on the particular question you want to change the read_only will be FALSE. Then you can change and submit easily
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?
Ya encontré la solución, mi base se encontraba con comas y lo cambie por punto y coma y ya funciona
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 ?
Yes, you can only do 5000 submissions in a month and the storage capacity if you are collecting pictures or images from the field or audio is 1gb. Therefore, if you need more storage you can contact Kobotoolbox support. support@kobotoolbox.org for upgrade of account
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.
Sincerely, I don’t get you but I will try to understand and get back to you
@@oluwaseunogunmolu I am talking about media file for pull data functionality, in that file I have created unique ID's for read only pop-up values. But when I created drop-down list for that unique ID's on kobo so the read only values can't populate. So how to fix this issue? I now limitation of pull data functionality this work only text type data. But I have more than 500 ID's so need to drop-down.
A good vedio indeed, can someone edit their details in pull data? maybe after they realize that their name had a spelling error etc?
Yes of course! But you will have to redeploy the form to server.
Also you can make name read_only to be false
Hello, Sr. Very good video. Im trying to pull old form results in a new survey. Is there a way to do this? Thanks.
YES. You can download the result and save as csv, then call the result (data) in the new form
@@oluwaseunogunmolu Oh, I see. Thanks for repply. I expressed myself badly. What I need is to load the old results along with the new results of the new survey. I would like to have in the new survey all the results together. Is it possible?
@@nicolasspoto689 if you are using the same link for the old and new, then you can go to "download" and select "include data from all version". If I get you right. Another thing you can do is to link the two data together using data sharing
@@oluwaseunogunmolu Thats a good solution. But if I have all my old data in my pc, in a csv file for example, is it possible to append theese results to an existing kobotoolbox survey? Thaks for your time, it means a lot.
@@nicolasspoto689 Yes what you need to do is to use pull data. For example the last question can be pull old data - yes or no, if yes then pull data as read only to append to the new data
Getting this error during deployment:
unable to deploy
your form cannot be deployed because it contains errors:
Unexpected KoBoCAT error 400: b'{"detail":"ODK Validate Errors:\
>> XForm is invalid. See above for the errors.\
: Invalid calculate for the bind attached to \\"${Active_Exit_Status}\\" : Couldn\'t understand the expression starting at this point: ...,exit_status\',\'\xcd\x8ecpims_ovc_id\',$... in expression pulldata(\'reglist\',exit_status\',\'cpims_ovc_id\',$[Child_CPIMS_ID])\
\
The following files failed validation:\
${tmpftyny32f}\
\
Result: Invalid"}'
what could be the issue? am getting my data from reglist and have copied every single column name.
it worked, one syntax error.