Hi,
We are hoping to use some existing csv exports from another platform to pre-populate data in Kobo.
We have followed the instructions here and (http://support.kobotoolbox.org/en/articles/978826-pull-data-functionality-in-kobotoolbox ) also on xlsform (http://xlsform.org/en/#pre-loading-csv-data ), but are still not seeing any results pulled into the kobocollect app on our devices.
Please see example xls format we are trying to use.
Anyone can help at all with this?
Thanks in advance,
James
Hi James
Could you change your question type to text or integer from calculate as is the case above. This would definitely solve the issue of visibility for the pull data.
Regards
Stephane
1 Like
Hi,
Thanks for the fast response.
Done.
Still getting blank data in the collector unfortunately.
Regards,
James
Hi James
You have not changed your pull data questions to be either text or numeric as you needed to. Could you amend it and see if the behaviour persists
Regards
Stephane
1 Like
Hi,
Thanks again.
I tried this way (and previously), but that doesn’t seem to work either. The structure you wrote here: (http://support.kobotoolbox.org/en/articles/978826-pull-data-functionality-in-kobotoolbox ) seems to conflict with what they write on xlsform: (http://xlsform.org/en/#pre-loading-csv-data ).
Kal_Lam
September 10, 2019, 8:42am
6
Hi @jameshappell ,
Would you mind having a look at an example of the pulldata function from a post discussed earlier. It has a simple example where you could workaround to know how it works:
i’m trying to build a form that will use the pulldata() function to verify barcode ID from a dataset of beneficiary IDs and names. attached is my xls form and the sample database uploaded to my form for kobo collect. The barcode scanner displays the right ID number in kobocollect but the 'search()" function to pull up the beneficiary name and the the pulldata() function to verify the beneficiary ID from the barcode is not working and throws up "no such column: " in attached CSV file… But the c…
GOOD DAY!
Thanks for your help guys. Fixed it now.
1 Like