Select to view content in your preferred language

Exporting data from Survey123 with names instead of labels

2637
6
04-07-2021 06:24 AM
SwathiIyengar
Emerging Contributor

Hi all, 

We need to export data from Survey123/ArcGIS Online using field names instead of labels. I know this question has been asked a few times in the past (in 2017, in 2019, and earlier this year). 

One of the solutions suggested, "changing DisplayName in the AGOL Feature Layer to be the value you want to see in Excel, the next Excel export will pickup the change." How does one do this?

Another solution suggested populating the column bind::esri:fieldAlias - to confirm, that would look something like this (assuming we want the name fields to appear in the excel/csv exports)?

typenamelabel::English (en)bind::esri:fieldAliaslabel::Persian (per)
begin grouphouseholdinfoA. PRELIMINARY INFORMATION / ADMINISTRATIVE SURVEY DATAhouseholdinfoA.اطلاعات اولیه / داده های اداری نیازسنجی 

 

Thanks!

6 Replies
IsmaelChivite
Esri Notable Contributor

Hi @SwathiIyengar   No news on this one. For clarity, Survey123 is limited to what the export capabilities of ArcGIS Online and ArcGIS Enterprise provide.  The solutions provided in the links you include are still valid.

0 Kudos
SwathiIyengar
Emerging Contributor

Hi @IsmaelChivite , 

Thanks - with regard to one of the solutions, can you provide some additional instructions (see below)

One of the solutions suggested, "changing DisplayName in the AGOL Feature Layer to be the value you want to see in Excel, the next Excel export will pickup the change." How does one do this?

Thanks!

0 Kudos
RichardRogers1
Occasional Contributor

Are there any plans to resolve this?  An option to choose actual column headers ("name") rather than field aliases ("label") would save much trouble on the next step in the data workflow (in my case, pushing data into a separate database).

0 Kudos
MicZatorsky_AEC
Frequent Contributor

Find the feature layer that your survey uses  > Data tab > Fields tab

Select a field, change the name.  For example:

MicZatorsky_AEC_0-1617927251084.png

 

 

 

SwathiIyengar
Emerging Contributor

@MicZatorsky_AEC - thanks a million!

0 Kudos
ConsueloMartinez
New Contributor

It doesn't work TT

0 Kudos