How do i link external csv files with my survey questionnaire?

[Kal_Lam]

Hi @Sven1,

Welcome back to the community!

Regarding your first query:

@Sven1

I didn`t mention earlier but note that I want to work with KOBO COLLECT as we only have smartphones. Your sollutions only include ENKETO.

Kindly please be informed that you are now able to use both Enketo (web form) as well as the Collect (android app) to collect data for select_one_from_file question type. But please be informed that if you wish to use Collect android app, ODK Collect v1.26.2 should only support this feature (hence would recommend you to use the same for this purpose).

Regarding your second query:

@Sven1

I developped a file using select_multiple names that refers to the column names in the csv and I put follwing in appearance: search(‘file’,‘matches’,‘farmergroups’,${groups}) so I can search for all the names of the previously selected farmer group.

You could use the minimal under the appearance as shown in the image below to solve your issue. For reference, please have a look at the images shown below:

In the survey tab of your xlsform:

In the choices tab of your xlsform:

In the settings tab of your xlsform:

CSV file:

Data collection screen as seen in Enketo:

Reference xlsform:
select_one_from_file.xlsx (12.4 KB)

Reference csv file:
fruits.csv (522 Bytes)

Regarding your third query:

@Sven1

However when I send the file to the Kobo server and I download the collected data in xls they are not there.

For this kindly please download your dataset as XLS (legacy) version (as shown in the image below):

Have a great day!