laptop and a wrench

Bug

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
Bug-ID-Nummer BUG-000138093
EingereichtMarch 11, 2021
Zuletzt geändertJune 5, 2024
Gilt fürArcGIS Survey123
Gefunden in Version3.12
BetriebssystemWindows OS
Betriebssystemversion10.0 64 Bit
StatusAs Designed

Zusätzliche Informationen

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.

Workaround

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

Schritte zur Reproduzierung

Bug-ID: BUG-000138093

Software:

  • ArcGIS Survey123

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln