Тёмный

Pull Data Functionality in KoboToolbox 

Oluwaseun Ogunmolu
Подписаться 1,5 тыс.
Просмотров 10 тыс.
50% 1

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.buymeacoff...
#dataanalytics #datacollection #datascience #kobotoolbox #odk

Опубликовано:

 

19 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 47   
@isaacbissang4035
@isaacbissang4035 2 месяца назад
💯💯💯
@mathtoma7885
@mathtoma7885 3 месяца назад
Thank you so much. It's what I have been looking for months. All the best!!!
@hugemanisme
@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.
@rugwizainnocent1881
@rugwizainnocent1881 Год назад
A very informative content. Thanks a lot
@javierguerrero2886
@javierguerrero2886 10 месяцев назад
Merci!!
@WilsonHerreraJr.
@WilsonHerreraJr. 6 месяцев назад
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?
@oluwaseunogunmolu
@oluwaseunogunmolu 6 месяцев назад
I think something is wrong somewhere. Take your time and watch the video again to see if there’s no mistake
@Lew1414
@Lew1414 7 месяцев назад
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.
@oluwaseunogunmolu
@oluwaseunogunmolu 7 месяцев назад
It’s possible. I will try to do a similar video on it
@oluwaseunogunmolu
@oluwaseunogunmolu 7 месяцев назад
It’s possible. I will try to do a similar video on it
@herimasuka1622
@herimasuka1622 Год назад
Thank bro
@fredrickmerie451
@fredrickmerie451 8 месяцев назад
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
@oluwaseunogunmolu
@oluwaseunogunmolu 8 месяцев назад
You will be the one to add it. Watch the video again
@ZAChowdhury-ks8gy
@ZAChowdhury-ks8gy 6 месяцев назад
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 ?
@oluwaseunogunmolu
@oluwaseunogunmolu 6 месяцев назад
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
@nkwantanorthdeo667
@nkwantanorthdeo667 Год назад
great
@xorlaadzoyi9845
@xorlaadzoyi9845 6 месяцев назад
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.
@constantinrukataza2139
@constantinrukataza2139 7 месяцев назад
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.
@edmarkwellnessexperience7427
can we import picture, GPS By external file, or other form??
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
Yes, of course. Just follow the process
@rawadshayya5662
@rawadshayya5662 10 месяцев назад
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
@nijaradeka5358
@nijaradeka5358 Год назад
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 ?
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
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
@desmondwafula5246
@desmondwafula5246 Год назад
A good vedio indeed, can someone edit their details in pull data? maybe after they realize that their name had a spelling error etc?
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
Yes of course! But you will have to redeploy the form to server.
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
Also you can make name read_only to be false
@oscarlicto
@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?
@oscarlicto
@oscarlicto Год назад
Ya encontré la solución, mi base se encontraba con comas y lo cambie por punto y coma y ya funciona
@user-jn5sd4cs8n
@user-jn5sd4cs8n 9 месяцев назад
CAN I EDIT THE DATA I PULL, EXAMPLE I WANT TO PULL ENROLLMENTS AND IF THERE IS CHANGE I WANT TO EDIT AND SUBMIT
@oluwaseunogunmolu
@oluwaseunogunmolu 9 месяцев назад
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
@ghanshyamsingh7422
@ghanshyamsingh7422 Год назад
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.
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
Sincerely, I don’t get you but I will try to understand and get back to you
@ghanshyamsingh7422
@ghanshyamsingh7422 Год назад
@@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.
@zayidhs
@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.
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
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.
@zayidhs
@zayidhs Год назад
@@oluwaseunogunmolu yes, the data is already in the choices sheet and I want to reference it in the survey sheet. Thanks
@edmarkwellnessexperience7427
Hello have a limit of umber of row to pull data?
@nijaradeka5358
@nijaradeka5358 Год назад
hi , I am getting error massage . I dont know , not finding the data etc msg are coming
@nicolasspoto689
@nicolasspoto689 Год назад
Hello, Sr. Very good video. Im trying to pull old form results in a new survey. Is there a way to do this? Thanks.
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
YES. You can download the result and save as csv, then call the result (data) in the new form
@nicolasspoto689
@nicolasspoto689 Год назад
@@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?
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
@@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
@nicolasspoto689
@nicolasspoto689 Год назад
@@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.
@oluwaseunogunmolu
@oluwaseunogunmolu Год назад
@@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
@farahbrian5853
@farahbrian5853 Год назад
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.
@farahbrian5853
@farahbrian5853 Год назад
it worked, one syntax error.
Далее
Load KoboToolbox data to Power BI via API connection
13:47
연준 (YEONJUN) ‘GGUM’ Official MV
02:44
Просмотров 3,8 млн
KOBOTOOLBOX FOR BEGINNERS
40:32
Просмотров 4,9 тыс.
How to Setup Dynamic Data Attachments in KoBoToolbox
33:16