select multiple from file issue with choice filters

brandondurr

Hi,

I can't seem to get choice filters to work on a multi select survey field that is linked to an external csv.

I've attempted a couple different syntaxes:  =${      } and  select() 

When I apply the choice filter to the multi select field, the list options disappear from the survey.

I am currently running Survey123 Connect 3.22.44, and havent had luck with solutions proposed in similar threads. Any ideas?

Here is what my data looks like

XLSForm

type	name	label	appearance	choice_filter
select_one_from_file manager.csv	manager	Manager	autocomplete
select_one_from_file vyds.csv	vineyard	Vineyard	autocomplete	manager=${manager}
select_multiple_from_file sblocks.csv	vineyard_block	Vineyard Block	minimal	vineyard=${vineyard}

 

manager.csv

name	label
manager1	manager1
manager2	manager2
manager3	manager3

 

vyds.csv (file has 150 records)

name	label	manager
farm1	farm1	manager1
farm2	farm2	manager2
farm3	farm3	manager2
farm4	farm4	manager3

 

sblocks.csv (file has 3K records)

name	label	vineyard
1	field1	farm1
2	field2	farm1
3	field3	farm1
4	field1	farm2
5	field2	farm2
6	field3	farm2
7	field4	farm2
8	field1	farm3
9	field2	farm3
10	field1	farm4

abureaux

In that case, the issue is most likely with the full CSVs. There is probably something going on in the file that is breaking your workflow. 

From the S123 side of things, your workflow should work (which is good).

As for the CSVs, I see you have "name" and "label" columns already (which is good). But as for further troubleshooting, it's hard without actually seeing the files. If they aren't confidential, then adding them here would help. 

The few bits of advice I can give are (in no particular order):

• Re-save the file as a CSV. Sometimes CSV files have an issue saving which prevents them from working in S123, but still allows them to be opened in Excel. Doesn't happen often, but I've had it happen a few times.
• Ensure there are no empty rows.
• Ensure there are no special characters in the name column (same general rules as the "name" column in the S123 Excel files). Personally, I stick to alphanumeric characters and underscores. Leave the fancy stuff to the label fields. 
• Cut out all but a few lines from the files and try.