| 漏洞 ID 编号 |
BUG-000138093 |
| 已提交 | March 11, 2021 |
| 上次修改时间 | June 5, 2024 |
| 适用范围 | ArcGIS Survey123 |
| 找到的版本 | 3.12 |
| 操作系统 | Windows OS |
| 操作系统版本 | 10.0 64 Bit |
| 状态 | As Designed
经开发团队审核,已确定此行为符合设计。 有关详细信息,请参阅“其他信息”部分。
|
附加信息
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.
解决办法
Remove the empty column from the external CSV file or populate the header.
重现步骤