laptop and a wrench

Error

The pulldata() function fails to populate values from an external CSV file that includes an empty header at the top of a column.

ArcGIS Survey123
Número de ID del error BUG-000138093
EnviadoMarch 11, 2021
Última modificaciónJune 5, 2024
Relacionado conArcGIS Survey123
Versión encontrada3.12
Sistema operativoWindows OS
Versión de sistema operativo10.0 64 Bit
EstadoAs Designed

Información adicional

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.

Solución alternativa

Remove the empty column from the external CSV file or populate the header.

Pasos para reproducir

ID del error: BUG-000138093

Software:

  • ArcGIS Survey123

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga