Survey123 Pulldata Function with .csv

[KayManuel]

I have tried everything I can think of, hence, the call for help.

I am trying to use the pulldata function to call some records from a .csv list.

I have checked and crosschecked the fieldnames in the survey form and the .csv list in the media folder to ensure it all checks out. I have done same with the syntax. At this point, I believe there might be a "minor" check I might have forgotten about or a survey fieldtype I need to add.

Please help.

P.S.: I have attached the survey form as well as the .csv list.

Thanks in advance.

[ChristopherCounsell · Accepted solution]

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F35...

Your CSV column headings have special characters and spaces. Clean it up. Remove columns you aren't using. It should be a very simply formatted CSV.

[KayManuel]

Thank you very much, Sir.

All I had to do was remove the fields I didn't need and it worked like magic. As you said, those extra fields contained spaces.

I now understand why the .csv file I tested with worked perfectly but this didn't: the test file was simple with only the required fields.