I seem to be having a problem with pulling or searching for data in csv files on Kobo.
Instructions on XLSForm and other forums seem to indicate that you can have csv files with several columns, and this is why you have a way to indicate the column settings when you use the search() and pulldata() functions. However, Kobo only seems to accept 3 column csv files from me.
I spent a long time changing and reuploading a form I was building, tried every possible combination of settings and choices, and nothing worked. This includes uploading a few csv and xlsx files I found on this and other forums to test the pulldata() and search() functions, and they seemed to be broken, which was strange.
Finally, I simply removed all the columns from my csv except the ones necessary for the one function I was testing, and it worked. So to build the rest of the form, every time I needed a pulldata() search() or calculate function, I had to subset my original csv to the three columns I needed and uploaded an addtional csv to the media section. This seems very inefficient for large forms for, say, a baseline study you want to run again.
¿Am I doing something wrong or is this a limit in Kobo?
Thanks in advance.