topic Re: Pulldata from a media .csv not working in ArcGIS Survey123 Questions

Pulldata from a media .csv not working

RemyOlive — Mon, 02 Sep 2024 08:52:02 GMT

Hi everyone,

I'm fairly new to Survey123 connect, and have been trying to collect latitude and longitude data from a CSV file located in the media folder of my survey.

I'm doing this through a pulldata() function, as shown here:

Survey123 Tricks of the Trade: How to calculate a geopoint (esri.com):

this is my pulldata query.

and this is my CSV table located in the media folder.

Whenever I select one of the list's choices, neither of the two pulldata() fields fill with the lat and long.

I think I've tried everything that I could find on the forums, from notepad checking my csv to removing any potentially special characters as seen here:

Solved: Pulldata From Linked csv Not Working - Esri Community

Solved: pulldata function not working in survey - Esri Community

Solved: Pulldata from external csv not working - Esri Community

Still not working for me, any help would be appreciated !

Thanks,

Rémy

Re: Pulldata from a media .csv not working

Ruth_JiatengXu — Mon, 02 Sep 2024 10:58:25 GMT

Hi @RemyOlive ,

Could you please also provide a screenshot of your choices tab in the XLSForm? I think we also need to check the choice list "WP" for the "select_one WP".

Thanks,

Ruth

Re: Pulldata from a media .csv not working

RemyOlive — Mon, 02 Sep 2024 11:05:47 GMT

Hi Ruth,

Thanks for the reply,

here is the screenshot of the WP choice list, pretty basic stuff as all other columns are empty, I made sure that these are the same as the IDs from the media table.

Thanks,

Rémy

Re: Pulldata from a media .csv not working

Ruth_JiatengXu — Tue, 03 Sep 2024 10:33:12 GMT

Hi @RemyOlive

I created a survey based on your screenshot, and it worked for me. The XLSForm and csv file are attached to this post.

Could you please try my form in your Connect or share your XLSForm with us?

Thanks,

Ruth

Re: Pulldata from a media .csv not working

abureaux — Wed, 04 Sep 2024 14:58:35 GMT

Your CSV is wrong.

The "name" and "label" columns are required, just like on the Choices tab.

EDIT: For clarity, the screen shot above is from OP. Here is an example of what it should look like (note the addition of the "name" and "label" columns):