Single column CSV media does not work

[freedim]

Hi there,

Description

When dealing with a CSV having a single column (with or without a final comma on each row), pulldata() does not work.

Example of use case: I want to check an entered value against a huge list but I don’t want the user to be able to see all the list (so no big.select_one, whether with search appearance or not. It will even be safer with hashes the day Enketo implements the function digest().

If I change the file to contain:
item_key,dummy_header
item_1,dummy
item_2,dummy

then the exact same pulldata(‘items’, ‘item_key’, ‘item_key’, ‘item_1’) will return ‘item_1’, as expected.

Steps to Reproduce

1. Upload as “media” the file ‘items.csv’, containing only:
   item_key
   item_1
   item_2

2. Make a form with

• a calculate field named ‘calc’ containing:
  pulldata(‘items’, ‘item_key’, ‘item_key’, ‘item_1’)
• a note field containing
  Pulled: ${calc}

3. Launch the date collection (Enketo, online): the note field will show no pulled data.

4. update the file ‘item.csv’ to:
   item_key,dummy_header
   item_1,dummy
   item_2,dummy

5. Redeploy and relaunch Enketo, the note field will display:
   Pulled: item_1

Expected behavior

Enketo able to pull data from a single-column CSV file

Actual behavior

Enketo not able to pull data from a single-column CSV file

Cheers!

[Kal_Lam]

Hi @freedim,

Have you tried using the csv as shared and discussed earlier. It should work:

Trying to build a form that will use pulldata() function to verify barcode ID

Hi @henryakuete, Please see the images below to build a survey form that uses barcode as question type to pull data from the csv file. You could practice this by replacing the barcode (Code) of the csv file with the ones that you have from any of your books (this is the one that i had them with me). Just wanted to show you a demo that if you have a barcode number, you could manage them in your csv file and use the pull data function to get the desired information during your survey. Image 1 (i…

Have a great day!

[freedim]

Hi @Kal_Lam,

Thanks for responding, but perhaps you should read my post, which is not about how to use a CSV or the function pulldata.

Cheers.

[Kal_Lam]

Hi @freedim,

Would you mind having a look at the sample csv that i shared in post that i shared earlier:

Codes.csv (285 Bytes)

Try using the csv in this format and you should be able to overcome the issue you are currently having.

Have a great day!

[freedim]

Sorry @Kal_Lam but I keep thinking you have not actually read my post

[Kal_Lam]

Hi @freedim,

Have you prepared an xlsform and a csv for this. It would be easy for us to test the same at our end.

Have a great day!

[freedim]

I don’t have this but you can generate one by copy/pasting what I provide in the OP. As a reminder:

• a calculate field named “calc” containing:
  pulldata(‘items’, ‘item_key’, ‘item_key’, ‘item_1’)

• a note field containing:
  Pulled: ${calc}

• a media file named “items.csv” containing:
  item_key
  item_1
  item_2

Cheers