topic Re: Not able to generate a list based on csv file in ArcGIS Survey123 Questions

Not able to generate a list based on csv file

OumaimaBoukamel95 — Wed, 26 Jul 2023 14:14:30 GMT

Hello !

I am trying to upload a list from my csv file uploaded in my media folder.

This has worked before, but the app doesn't seem able to read the csv file properly.

Here is what i get on survey123 :

And the number of times label appears seem to match with the number of lines.

This doesn't work either with pulldata().

Re: Not able to generate a list based on csv file

DougBrowning — Wed, 26 Jul 2023 15:21:25 GMT

This is often a special char or some other formatting issue with the CSV. Look for that. Often using notepad vs excel lets you see them better. If you do not see it then post the csv and the calling line from the form.

Re: Not able to generate a list based on csv file

OumaimaBoukamel95 — Wed, 26 Jul 2023 15:52:33 GMT

Thanks a lot for your response ! Indeed, my csv were separated by ; instead of , . It sort of work now.

Now i have another issue : this question is supposed to select villages, but i am not getting the list of villages with duplicates. How can i remove duplicates from the list ? Many thanks again for your help

Re: Not able to generate a list based on csv file

DougBrowning — Wed, 26 Jul 2023 18:27:44 GMT

Do you see this on the settings page?

https://community.esri.com/t5/arcgis-survey123-ideas/survey123connect-choices-duplicate-names-amp/idi-p/1053712

Re: Not able to generate a list based on csv file

OumaimaBoukamel95 — Wed, 26 Jul 2023 18:33:35 GMT

I do not have the colunb allow_choice_duplicates, at my level :

Does it mean i do not have the right survey 123 version ? or can i just add this ?

Re: Not able to generate a list based on csv file

DougBrowning — Wed, 26 Jul 2023 18:44:34 GMT

You may have an older 123 version. You can add the column manually though. Download the latest Connect.

You could also try the new upgrade form option but be careful there!

Is it also possible to clean up your list? My guess is that is a pain

Re: Not able to generate a list based on csv file

OumaimaBoukamel95 — Fri, 28 Jul 2023 11:33:14 GMT

Thank you so much for your feedback. Simply added the column allow_choice_duplicates and putting 'yes' didn't work. I also tried to download the app again.

My media dataset is a list of households living in villages (potentially several households per villages), and i would like the enumerator to select the villages and then the farmers among the list of farmers in the village.

A work around could be to generate a list of unique village separated from the list of farmers, and then use 'matches' right ?

Thank you again for your support this is super helpful

Re: Not able to generate a list based on csv file

DougBrowning — Mon, 31 Jul 2023 14:11:13 GMT

I think you want to set it to no though right? You don't want duplicates I thought.