BUG-000138093 for ArcGIS Survey123

Bug ID Number	BUG-000138093
Submitted	March 11, 2021
Last Modified	June 5, 2024
Applies to	ArcGIS Survey123
Version found	3.12
Operating System	Windows OS
Operating System Version	10.0 64 Bit
Status	As Designed

Additional Information

This behavior is by design. When using a CSV file to retrieve a value using pulldata, the CSV file must meet some formatting requirements. Some of these requirements are noted in the following documentation: https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91 The pulldata() function cannot be used to populate the values of 'select_multiple questions'. When using the pulldata() function, the CSV column names cannot contain spaces, hyphens, or other special characters. For best results, encode the .csv file using UTF-8 character encoding. If using Microsoft Excel to create the .csv file, save it as CSV UTF-8. Having a column with a blank header also causes the pulldata() function from CSV to not work as expected, as stated in the following documentation: https://doc.arcgis.com/en/survey123/desktop/create-surveys/prepopulateanswers.htm If the .csv file lacks a column header or has a trailing comma at the end of the file's rows, the .csv file fails to import into the survey.