Pulldata from a media .csv not working

Question

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

abureaux · Answer

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):

Ruth_JiatengXu · Answer

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

Form 23.xlsx

VWPtable.csv

RemyOlive · Answer

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