laptop and a wrench

Bogue

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
Numéro d’ID de bogue BUG-000138093
EnvoiMarch 11, 2021
Dernière modificationJune 5, 2024
S’applique àArcGIS Survey123
Version trouvée3.12
Système d’exploitationWindows OS
Version du système d’exploitation10.0 64 Bit
StatutAs Designed

Informations supplémentaires

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.

Solution de contournement

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

Étapes pour reproduire

ID de bogue: BUG-000138093

Logiciel:

  • ArcGIS Survey123

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement