topic Re: Survey123 exporting name rather than label in ArcGIS Survey123 Questions

Survey123 exporting name rather than label

GarretDubois — Wed, 06 Dec 2017 23:39:21 GMT

I have a field in my survey that is showing the information in the name column rather than the label column when the data is viewed in survey123 for ArcGIS, or exported from survey123 to AGOL.

There are other rows that are similar in the survey but are showing up correctly in the data tables when viewed in survey123 for ArcGIS.

Question 1. Does anyone know why this is happening?

Question 2. Is there a way to fix this problem?

Re: Survey123 exporting name rather than label

JohnathanHasthorpe — Wed, 06 Dec 2017 23:45:45 GMT

Hi Garret

What question type are you using for the problem fields - are they select_one? If so, this is a known limitation.

It might be helpful if you share the survey and highlight the problem questions.

Thanks

John

Re: Survey123 exporting name rather than label

GarretDubois — Thu, 07 Dec 2017 20:47:11 GMT

Good morning Johnathan,

The question type is a “select one” question and directly below it in the survey is a similar question that displays properly.

Attached is the survey and the problem question (select_one dca_code) is highlighted in yellow. The problem is that when we view the submitted data in Survey123 for Arcgis or export it from there, that the column is populated with the information in the name column which is just a number, rather than the information in the label column which is the name of an insect or fungus.

Thanks for your help

Garret Dubois

Biological Science Technician

Forest Service

Alaska Region, S&PF Forest Health Protection

p: 907-374-3758

garretddubois@fs.fed.us<mailto:garretddubois@fs.fed.us>

3700 Airport Way

Fairbanks, AK 99709

www.fs.fed.us<http://www.fs.fed.us/>

<http://usda.gov/>[Forest Service Twitter]<https://twitter.com/forestservice>[USDA Facebook]<https://www.facebook.com/pages/US-Forest-Service/1431984283714112>

Caring for the land and serving people

Re: Survey123 exporting name rather than label

JamesTedrick — Fri, 08 Dec 2017 00:48:26 GMT

Hi Garret,

This is a known issue with select_one questions. The data itself is written as the name column and a domain is created to so that the labels seen in Survey123 will be seen in ArcGIS Online; in all but file geodatabase exports, ArcGIS Online provides the code (choice names) instead of labels. You can export the data with the labels via ArcGIS Desktop tools - see Problem: Coded value domain descriptions are not maintained after exporting data .

Re: Survey123 exporting name rather than label

LorettaWinton1 — Thu, 01 Mar 2018 21:54:04 GMT

Hello,

Is there perhaps a fix for this by now? It is very vexing that some select_one questions (eg. Damage causing agent) show the value from the "name" column. Whilst most other select_one questions (eg. Host, Tree diameter, etc.) show the value from the "label" column. We want labels.

To make things even weirder, when I look at the individual response, "Damage causing agent" shows the path for the image that is in the choices list.

Any idea what is the cause and fix for these issues?

Thanks,

Lori

Re: Survey123 exporting name rather than label

JohnathanHasthorpe — Fri, 02 Mar 2018 00:35:03 GMT

Hi Lorretta - can you share your survey?

Re: Survey123 exporting name rather than label

LorettaWinton1 — Fri, 02 Mar 2018 01:10:57 GMT

I sent the .xls file via email because I couldn't figure out how to attach it here. But here are screen shot of what I mean. I thought I pasted them into the original email from earlier today, but now I notice they aren't there.

Re: Survey123 exporting name rather than label

LorettaWinton1 — Fri, 02 Mar 2018 01:50:27 GMT

Here it is!

Thanks

Lori (Loretta) Winton, PhD

Forest Pathologist, SouthCentral & Interior Alaska

Forest Service

Forest Health Protection, R10 Alaska Region

p: 907-743-9460

f: 907-743-9479

lmwinton@fs.fed.us<mailto:lmwinton@fs.fed.us>

LTER

University of Alaska Fairbanks

193 Arctic Health Research Building

PO Box 756780

Fairbanks, AK 99775-6780

www.fs.usda.gov/main/r10/forest-grasslandhealth<http://www.fs.usda.gov/main/r10/forest-grasslandhealth>

www.fs.fed.us<http://www.fs.fed.us/>

<http://usda.gov/>[Forest Service Twitter]<https://twitter.com/forestservice>[USDA Facebook]<https://www.facebook.com/pages/US-Forest-Service/1431984283714112>

Caring for the land and serving people

Re: Survey123 exporting name rather than label

ShanaGail1 — Sat, 03 Mar 2018 17:10:25 GMT

Help! I also have this problem. It's not an issue of exporting, it is that when I look at the data in the hosted feature layer it is not showing the label. It is a select_one question, and it is not a cascading select. This is a huge problem for me - I had worked around it in a previous publishing of my Survey using a nested if, e.g. if(selected(${auditorid}, 'abcd1'),'Tom Jones', if(selected(${auditorid}, 'abcd2'),'Calvin Klein', if(selected(${auditorid}, 'abcd3'),'Tommy Hilfiger', if(selected(${auditorid}, 'abcd4'),'Peewee Herman',if(selected(${auditorid}, 'abcd5'),'Random Guy',if(selected(${auditorid}, 'abcd6'),'Strange Behavior','auditor name unknown')))))) .

That clumsy workaround made due for the initial publishing of my Survey, but now 40 auditors want to use it and even if I was willing to continue the workaround, Excel has a limit of 7 nested if functions. I'm supposed to add these new people next week... I didn't see an answer here in the conversation. If I'm missing it, apologies in advance.

Thanks, Shana

Re: Survey123 exporting name rather than label

JohnathanHasthorpe — Mon, 05 Mar 2018 03:19:51 GMT

Hi Loretta and Shana

It looks like you are both being affected by a known limitation.

When choice_filter used, the name text is saved as the data value, instead of the label text.

Shana - can you confirm that you are using choice filters? Also, have you thought of using a pulldata() instead?

You could just create a .csv lookup between name and label - this would be easier to manage.

Thanks

John

Re: Survey123 exporting name rather than label

ShanaGail1 — Mon, 05 Mar 2018 18:25:46 GMT

Hi,

I'm not using a choice filter, it's just a select_one question with a handful of values in the list. The other select_one questions work just fine. I'm adding another 40 values to the list however. I'll look into pulldata, but I'd like to get at the root cause of why the select_one isn't working.

Thanks,

Shana

Re: Survey123 exporting name rather than label

JohnathanHasthorpe — Tue, 06 Mar 2018 04:40:29 GMT

Hi Shana

Could you share your survey with we and I'll take a look? If you are not using choice filters - this is not expected behaviour.

Thanks

John

Re: Survey123 exporting name rather than label

ShanaGail1 — Wed, 07 Mar 2018 04:03:49 GMT

jhasthorpe@esri.com?

Re: Survey123 exporting name rather than label

JohnathanHasthorpe — Wed, 07 Mar 2018 05:36:12 GMT

That is the one - thanks

Re: Survey123 exporting name rather than label

oscaralfredogonzleon — Wed, 21 Mar 2018 04:39:14 GMT

HI guys, i have the same problem, can you help me? thanks alot

Re: Survey123 exporting name rather than label

hgaignard — Tue, 27 Mar 2018 13:35:53 GMT

Hi Johnathan Hasthorpe‌,

When choice_filter used, the name text is saved as the data value, instead of the label text.

This know limitation will be fixed ?

Thanks

FYI Jean-Marie DULISCOUET‌

Re: Survey123 exporting name rather than label

ShanaGail1 — Fri, 30 Mar 2018 00:04:02 GMT

If this is of help to anyone else... when I upgraded Survey123 Connect and Survey123 field app to the latest version, it started saving the label again in my Feature Layer.

Re: Survey123 exporting name rather than label

JohnathanHasthorpe — Tue, 03 Apr 2018 03:33:10 GMT

@ Hugo GAIGNARD we have this open as a bug and hope to address this in a future release: BUG-000106578 - When choice_filter used, the name text is saved as the data value, instead of the label text.

I will update this post with any developments.

Thanks

John

Re: Survey123 exporting name rather than label

LeaHarper3 — Tue, 26 Jun 2018 12:39:11 GMT

Hi Jonathan - is there going to be a fix for this? I have the very same issue as Shana. I'm not using a choice_filter, just select_one but the data is only displaying the ID that is in the name field, not the label.

Re: Survey123 exporting name rather than label

JohnathanHasthorpe — Thu, 28 Jun 2018 06:00:48 GMT

Hi Lea

Can you share your survey? The bug we have open involves the choice filter.

Thanks

John