topic Re: Exporting data from Survey123 with names instead of labels in ArcGIS Survey123 Questions

Exporting data from Survey123 with names instead of labels

SwathiIyengar — Wed, 07 Apr 2021 13:24:44 GMT

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)?

type	name	label::English (en)	bind::esri:fieldAlias	label::Persian (per)
begin group	householdinfo	A. PRELIMINARY INFORMATION / ADMINISTRATIVE SURVEY DATA	householdinfo	A.اطلاعات اولیه / داده های اداری نیازسنجی

Thanks!

Re: Exporting data from Survey123 with names instead of labels

IsmaelChivite — Wed, 07 Apr 2021 15:47:44 GMT

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.

Re: Exporting data from Survey123 with names instead of labels

SwathiIyengar — Thu, 08 Apr 2021 09:22:02 GMT

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!

Re: Exporting data from Survey123 with names instead of labels

MicZatorsky_AEC — Fri, 09 Apr 2021 00:15:01 GMT

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

Select a field, change the name. For example:

Re: Exporting data from Survey123 with names instead of labels

SwathiIyengar — Fri, 09 Apr 2021 08:18:18 GMT

@MicZatorsky_AEC - thanks a million!

Re: Exporting data from Survey123 with names instead of labels

RichardRogers1 — Wed, 08 Jun 2022 16:05:08 GMT

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).

Re: Exporting data from Survey123 with names instead of labels

ConsueloMartinez — Fri, 28 Jul 2023 20:44:36 GMT

It doesn't work TT